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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Gimbert

    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...
  2. Gimbert

    Database performance

    too many sequential scans for OLTP BD (onstat -p), rewiew UPDATE STATISTICS policy and indexes in your tables.
  3. Gimbert

    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.
  4. Gimbert

    Stalled Checkpoint on IDS 7.3

    It's possible that rootdbs is small, increase space for rootdbs
  5. Gimbert

    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)...

Part and Inventory Search

Back
Top