strange behavior in 9.40.FC6

I've actually got a patch loaded, 9.40.FC6X2. The server is randomly allocating multiple scan and sometimes group threads to sessions for no apparent reason. Onstat -g mgm doesn't report any PDQ queries running. The session has PDQPRIORITY set to 0. Onstat -u doesn't show the scan threads doing much work, if any. Usually just a few reads. Just wondering if anyone has seen this behavior in 9.40.FC6. I think the patch is the likely cause and I plan to back it out this weekend to verify that. Bill testdb:[/usr/informixtst/work/430569]> onstat -g ses 1365 IBM Informix Dynamic Server Version 9.40.FC6X2 -- On-Line -- Up 07:07:09 -- 123856 Kbytes session #RSAM total used dynamic id user tty pid hostname threads memory memory explain 1365 jwapusr WEB_DISP 1064 10.0.0.1 3 360448 328416 off tid name rstcb flags curstk status 4324 sqlexec 700000050314940 Y--P--- 2816 cond wait(netnorm) 4325 scan_1.0 70000001030f2e8 Y------ 1328 cond wait(await_MC1) 4326 scan_1.0 700000050324e40 Y------ 1328 cond wait(await_MC1) Memory pools count 1 name class addr totalsize freesize #allocfrag #freefrag 1365 V 7000000604a9040 360448 32032 470 29 name free used name free used overhead 0 3248 mtmisc 0 288 resident 0 144 scb 0 288 opentable 0 18168 filetable 0 2784 log 0 12696 temprec 0 6592 keys 0 400 ralloc 0 214456 gentcb 0 3392 ostcb 0 3456 sqscb 0 19280 sql 0 72 rdahead 0 1872 xchg_desc 0 2400 xchg_port 0 2272 xchg_packet 0 856 xchg_group 0 208 xchg_priv 0 648 hashfiletab 0 1656 osenv 0 2240 sqtcb 0 12616 fragman 0 17448 shmblklist 0 664 sapi 0 128 sqscb info scb sqscb optofc pdqpriority sqlstats optcompind directives 7000000604a40b0 7000000604aa028 0 0 0 2 1 Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 1365 - jevic DR Not Wait 0 0 9.03 Off Last parsed SQL statement : execute procedure wpfmacro2(?) testdb:[/usr/informixtst/work/430569]>> onstat -g mgm IBM Informix Dynamic Server Version 9.40.FC6X2 -- On-Line -- Up 07:07:23 -- 123856 Kbytes Memory Grant Manager (MGM) -------------------------- MAX_PDQPRIORITY: 100 DS_MAX_QUERIES: 100 DS_MAX_SCANS: 1048576 DS_TOTAL_MEMORY: 524288 KB Queries: Active Ready Maximum 0 0 100 Memory: Total Free Quantum (KB) 524288 524288 5240 Scans: Total Free Quantum 1048576 1048576 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: None Ready Queries: None Free Resource Average # Minimum # -------------- --------------- --------- Memory 58914.4 +- 0.0 52436 Scans 1048575.5 +- 0.0 1048570 Queries Average # Maximum # Total # -------------- --------------- --------- ------- Active 1.0 +- 0.1 2 823 Ready 0.0 +- 0.0 0 0 Resource/Lock Cycle Prevention count: 0 testdb:[/usr/informixtst/work/430569]> sending to informix-list

Did you run update statistics with pdpqriority set?? also for your spl??? afaikr if you run update stats for procedure/function xxx and have pdqpriority set then the spl will get it 'compiled in' so next time you run it it will use pdq. you could try to run set pdqpriority 0; update statitistics for routine ; Superboer. Bill Dare schreef: > I've actually got a patch loaded, 9.40.FC6X2. The server is randomly > allocating multiple scan and sometimes group threads to sessions for no > apparent reason. Onstat -g mgm doesn't report any PDQ queries running. > The session has PDQPRIORITY set to 0. Onstat -u doesn't show the scan > threads doing much work, if any. Usually just a few reads. > > Just wondering if anyone has seen this behavior in 9.40.FC6. I think > the patch is the likely cause and I plan to back it out this weekend to > verify that. > > Bill > > > > testdb:[/usr/informixtst/work/430569]> onstat -g ses 1365 > > IBM Informix Dynamic Server Version 9.40.FC6X2 -- On-Line -- Up > 07:07:09 -- 123856 Kbytes> > session #RSAM total used > dynamic > id user tty pid hostname threads memory memory > explain > 1365 jwapusr WEB_DISP 1064 10.0.0.1 3 360448 328416 > off > > tid name rstcb flags curstk status > 4324 sqlexec 700000050314940 Y--P--- 2816 cond wait(netnorm) > 4325 scan_1.0 70000001030f2e8 Y------ 1328 cond > wait(await_MC1) > 4326 scan_1.0 700000050324e40 Y------ 1328 cond > wait(await_MC1) > > Memory pools count 1 > name class addr totalsize freesize #allocfrag > #freefrag > 1365 V 7000000604a9040 360448 32032 470 29 > > > name free used name free used > > overhead 0 3248 mtmisc 0 288 > > resident 0 144 scb 0 288 > > opentable 0 18168 filetable 0 2784 > > log 0 12696 temprec 0 6592 > > keys 0 400 ralloc 0 > 214456 > gentcb 0 3392 ostcb 0 3456 > > sqscb 0 19280 sql 0 72 > > rdahead 0 1872 xchg_desc 0 2400 > > xchg_port 0 2272 xchg_packet 0 856 > > xchg_group 0 208 xchg_priv 0 648 > > hashfiletab 0 1656 osenv 0 2240 > > sqtcb 0 12616 fragman 0 17448 > > shmblklist 0 664 sapi 0 128 > > > sqscb info > scb sqscb optofc pdqpriority sqlstats > optcompind directives > 7000000604a40b0 7000000604aa028 0 0 0 2 > 1 > > Sess SQL Current Iso Lock SQL ISAM F.E. > Id Stmt type Database Lvl Mode ERR ERR Vers > Explain > 1365 - jevic DR Not Wait 0 0 9.03 > Off > > Last parsed SQL statement : > execute procedure wpfmacro2(?)> > testdb:[/usr/informixtst/work/430569]>> onstat -g mgm > > IBM Informix Dynamic Server Version 9.40.FC6X2 -- On-Line -- Up > 07:07:23 -- 123856 Kbytes> > Memory Grant Manager (MGM) > -------------------------- > > MAX_PDQPRIORITY: 100 > DS_MAX_QUERIES: 100 > DS_MAX_SCANS: 1048576 > DS_TOTAL_MEMORY: 524288 KB > > Queries: Active Ready Maximum > 0 0 100 > > Memory: Total Free Quantum > (KB) 524288 524288 5240 > > Scans: Total Free Quantum > 1048576 1048576 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: None > > Ready Queries: None > > Free Resource Average # Minimum # > -------------- --------------- --------- > Memory 58914.4 +- 0.0 52436 > Scans 1048575.5 +- 0.0 1048570 > > Queries Average # Maximum # Total # > -------------- --------------- --------- ------- > Active 1.0 +- 0.1 2 823 > Ready 0.0 +- 0.0 0 0 > > Resource/Lock Cycle Prevention count: 0 > > testdb:[/usr/informixtst/work/430569]> > > sending to informix-list

"Bill Dare" <dareb@jevic.com> wrote in message news:1115154586.41877d638e6a36c3447a085ec262c671@teranews... > > I've actually got a patch loaded, 9.40.FC6X2. The server is randomly > allocating multiple scan and sometimes group threads to sessions for no > apparent reason. Onstat -g mgm doesn't report any PDQ queries running. > The session has PDQPRIORITY set to 0. Onstat -u doesn't show the scan > threads doing much work, if any. Usually just a few reads. > > Just wondering if anyone has seen this behavior in 9.40.FC6. I think > the patch is the likely cause and I plan to back it out this weekend to > verify that. > > Bill I have no insight to your problem but am interested to know what bug in FC5 or earlier you have the patch for. Could it be this one?: 171489 SERVER CRASHES IN CMPRSTR/CMPRNAME IF DICTIONARY CACHE IS TOO SMALL. I'd like to know for the benefit of one of my clients who is about to apply an FC6 patched version too. thanks Neil