Update Statistics 597 errors and assert failures

We just installed IDS 9.40.FC3 on a 64-bit DEC Alpha server running the True64 operating system (uname -a: OSF1 odb1 V5.1 2650 alpha). The server has 2 CPUs and 4 Gig physical memory. The following relevant Informix environment variables are set: BIG_FET_BUF_SIZE=32000 DBUPSPACE=100000 INFORMIXSTACKSIZE=128PDQPRIORITY=LOW PSORT_NPROCS=2 The following relevant onconfig parameters are set: RESIDENT -1 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor NUMCPUVPS 2 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one NOAGE 1 # Process aging AFF_SPROC 0 # Affinity start processor AFF_NPROCS 0 # Affinity number of processors BUFFERS 200000 # Maximum number of shared buffers NUMAIOVPS 2 # Number of IO vps PHYSBUFF 32 # Physical log buffer size (Kbytes) LOGBUFF 64 # Logical log buffer size (Kbytes) CLEANERS 30 # Number of buffer cleaner processes SHMBASE 0x200000000L # Shared memory base address SHMVIRTSIZE 1150000 # initial virtual shared memory segment size#SHMVIRTSIZE 125000 # initial virtual shared memory segment size SHMADD 32768 # Size of new shared memory segments (Kbytes) SHMTOTAL 3072000 # Total shared memory (Kbytes). 0=>unlimited CKPTINTVL 900 # Check point interval (in sec) LRUS 30 # Number of LRU queues LRU_MAX_DIRTY 2.0 # LRU percent dirty begin cleaning limit LRU_MIN_DIRTY 1.0 # LRU percent dirty end cleaning limit STACKSIZE 128 # Stack size (Kbytes0 DS_TOTAL_MEMORY 1024000 # Decision support memory (Kbytes) When I run UPDATE STATISTICS MEDIUM FOR TABLE name RESOLUTION 1.0 0.99 DISTRIBUTIONS ONLY I often get 597: [Internal] Premature End Of Buffer errors.The errors do not occur consistently and don't always occur on the same table. I tried to get a handle on the problem by varying percent and confidence. When I run UPDATE STATISTICS MEDIUM FOR TABLE name DISTRIBUTIONS ONLY I start getting assert failures. I can suppress assert failures by incrementing the virtual shared memory segment size and descision support memory and executing update statistics with PDQPRIORITY set to a large value (100). However, Istill get the 597 errors. I also tried replacing the MEDIUM with HIGH but to no avail. Also note that the problems seem to be limited to running update stats at the table and database level. I haven't seen the problem when updating stats at the column level Any suggestions? Thanks ... Andy

try running update stats on your procedures, one by one... i had a similar problem, my tables were fine, but procedure stats barked on one procedure. informix (SAP) told me not to worry, if needed they could recreate the proc. this happened during upgrade testing... the testing has taken many turns and this error has not repeated...(so i didn't have to have informix recreate a proc or anything). Norma Jean -----Original Message----- From: andy@nohrsc.nws.gov [mailto:andy@nohrsc.nws.gov] Sent: Friday, April 23, 2004 3:09 PM To: ids@iiug.org; forum.subscriber@iiug.org Subject: Update Statistics 597 errors and assert failures [2879] We just installed IDS 9.40.FC3 on a 64-bit DEC Alpha server running the True64 operating system (uname -a: OSF1 odb1 V5.1 2650 alpha). The server has 2 CPUs and 4 Gig physical memory. The following relevant Informix environment variables are set: BIG_FET_BUF_SIZE=32000 DBUPSPACE=100000 INFORMIXSTACKSIZE=128PDQPRIORITY=LOW PSORT_NPROCS=2 The following relevant onconfig parameters are set: RESIDENT -1 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 1 # 0 for single-processor, 1 formulti-processor NUMCPUVPS 2 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vpsto one NOAGE 1 # Process aging AFF_SPROC 0 # Affinity start processor AFF_NPROCS 0 # Affinity number of processors BUFFERS 200000 # Maximum number of shared buffers NUMAIOVPS 2 # Number of IO vps PHYSBUFF 32 # Physical log buffer size (Kbytes) LOGBUFF 64 # Logical log buffer size (Kbytes) CLEANERS 30 # Number of buffer cleaner processes SHMBASE 0x200000000L # Shared memory base address SHMVIRTSIZE 1150000 # initial virtual shared memory segmentsize #SHMVIRTSIZE 125000 # initial virtual shared memory segment size SHMADD 32768 # Size of new shared memory segments (Kbytes) SHMTOTAL 3072000 # Total shared memory (Kbytes). 0=>unlimited CKPTINTVL 900 # Check point interval (in sec) LRUS 30 # Number of LRU queues LRU_MAX_DIRTY 2.0 # LRU percent dirty begin cleaning limit LRU_MIN_DIRTY 1.0 # LRU percent dirty end cleaning limit STACKSIZE 128 # Stack size (Kbytes0 DS_TOTAL_MEMORY 1024000 # Decision support memory (Kbytes) When I run UPDATE STATISTICS MEDIUM FOR TABLE name RESOLUTION 1.0 0.99 DISTRIBUTIONS ONLY I often get 597: [Internal] Premature End Of Buffer errors.The errors do not occur consistently and don't always occur on the same table. I tried to get a handle on the problem by varying percent and confidence. When I run UPDATE STATISTICS MEDIUM FOR TABLE name DISTRIBUTIONS ONLY I start getting assert failures. I can suppress assert failures by incrementing the virtual shared memory segment size and descision support memory and executing update statistics with PDQPRIORITY set to a large value (100). However, I still get the 597 errors. I also tried replacing the MEDIUM with HIGH but to no avail. Also note that the problems seem to be limited to running update stats at the table and database level. I haven't seen the problem when updating stats at the column level Any suggestions? Thanks ... Andy ----------------------------------------- ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================

> > > We just installed IDS 9.40.FC3 on a 64-bit DEC Alpha server > running the True64 operating system (uname -a: OSF1 odb1 V5.1 > 2650 alpha). The server has 2 CPUs and 4 Gig physical memory. > The following relevant Informix environment variables are set: > > When I run UPDATE STATISTICS MEDIUM FOR TABLE name RESOLUTION > 1.0 0.99 DISTRIBUTIONS ONLY I often get 597: [Internal] > Premature End Of Buffer errors.The errors do not occur > consistently and don't always occur on the same table. > > I tried to get a handle on the problem by varying percent and > confidence. When I run UPDATE STATISTICS MEDIUM FOR TABLE > name DISTRIBUTIONS ONLY I start getting assert failures. I > can suppress assert failures by incrementing the virtual > shared memory segment size and descision support memory and > executing update statistics with PDQPRIORITY set to a large > value (100). However, I still get the 597 errors. > > I also tried replacing the MEDIUM with HIGH but to no avail. > Also note that the problems seem to be limited to running > update stats at the table and database level. I haven't seen > the problem when updating stats at the column level > > Any suggestions? > Upgrade to Tru64 5.1B PK3. Informix have been looking at this problem for us for several months. Just gone away with the above change. PK3 seems to be the key factor. Would be interested in feedback. Colin Bull c.bull@videonetworks.com