Performance & PDQ et al...

We have several update process that are currently very slow, (~ 12 hr each) And have enabled PDQ but no table fragmentation yet. Here is our onstat -g mgm output. Interesting that I note, there is not many contention with the PDQ, and very little I/O loading and have free CPU resources (via vmstat/iostat). But we still not much benefit gained. Is that because of no table fragmentation or bad database design? We tried a couple of other things, like setting NOAGE 1, but surprising update statistics run 10 times slower, so we drop that. We now usingrenice to get oninit process as high priority as possible... Thanks. Chris INFORMIX-OnLine Version 7.23.UC4 -- On-Line -- Up 18:48:37 -- 150880 Kbytes Memory Grant Manager (MGM) -------------------------- MAX_PDQPRIORITY: 100 DS_MAX_QUERIES: 10 DS_MAX_SCANS: 1024 DS_TOTAL_MEMORY: 2000 KB Queries: Active Ready Maximum 1 0 10 Memory: Total Free Quantum (KB) 2000 1200 200 Scans: Total Free Quantum 1024 1024 1 Load Control: (Memory) (Scans) (Priority) (Max Queries) (Reinit) Gate 1 Gate 2 Gate 3 Gate 4 Gate 5 (Queue Length) 0 0 0 0 0 Active Queries: Session Query Priority Thread Memory Scans Gate 307 40404028 40 4022de10 100/100 0/0 - Ready Queries: None Free Resource Average # Minimum # -------------- --------------- --------- Memory 134.1 +- 89.8 34 Scans 1023.2 +- 0.4 1021 Queries Average # Maximum # Total # -------------- --------------- --------- ------- Active 1.5 +- 0.5 3 311111 Ready 1.1 +- 0.2 2 34 Resource/Lock Cycle Prevention count: 0 -- Chris Lo mailto: cklo@hk.super.net System Administrator/Informix DBA mailto: cklo@cklo.hk.super.net The Prudential Assurance (HK) Co. Ltd mailto: paclck@hk.net ============================================================================== -- Linux + FreeBSD + HPUX + Solaris + AIX ============================================================================== #include <std/disclaimer.h>