RE: strange behavior in 9.40.FC6
Hey, thanks. That fixed it. When I upgraded I ran "dostats -h $DBSERVER -d $DATABASE -p -P 10". That -P 10 was causing the problem. I'm not sure where my head was at when I decided to do that. Shot myself in the foot with that one. I've been floundering around with this problem for days.
Thanks,
Bill
> -----Original Message-----
> From: owner-informix-list@iiug.org [SMTP:owner-informix-list@iiug.org] On Behalf Of Superboer
> Sent: Wednesday, May 04, 2005 3:11 AM
> To: informix-list@iiug.org
> Subject: Re: strange behavior in 9.40.FC6
>
> 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
>
sending to informix-list