Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Performance issues
to check extents in tables on a database for more than 7 extents: select tabname Tabla, count(*) Fragmentos, sum(size) Tamaqo from sysextents where dbsname = 'dbname' group by tabname having count(*) > 7 order by 2 DESC, 1 either you must use for a particular table in a database...- Gimbert
- Post #13
- Forum: Informix solutions
-
Database performance
too many sequential scans for OLTP BD (onstat -p), rewiew UPDATE STATISTICS policy and indexes in your tables.- Gimbert
- Post #12
- Forum: Informix solutions
-
dbexport problem
Dbexport do not management more than 2Gb in a tape, you must use option -s with maximun of 2Gb, when a tape is full (2 Gb) dbexport prompt for the next tape.- Gimbert
- Post #2
- Forum: Informix solutions
-
Stalled Checkpoint on IDS 7.3
It's possible that rootdbs is small, increase space for rootdbs- Gimbert
- Post #2
- Forum: Informix solutions
-
How Increase Database Performance
The tunning consist of three elements, Disk, Memory o CPU, you can see where the problem is using system commands and informix utilities (I think onstat -p is very useful). it's recomendable start with disk (the most slow device), review spaces, extents in your tables, queues (onstat -g ioq)...- Gimbert
- Post #3
- Forum: Informix solutions
