sysptprof seq scan info
Upgraded from 9.40.FC2 to 9.40.FC4W1 on AIX 5.2
No changes to ONCONFIG (or anything else for that matter).
When I run this query against sysmaster:
select tabname,seqscans from sysptprof
wheredbsname='db1' and
tabname in ('table1','table2','table3')
I get these results:
tabname table1
seqscans 2031616
tabname table2
seqscans 60293120
tabname table3
seqscans 89128960
These numbers are not correct because 'onstat -p' shows this:
IBM Informix Dynamic Server Version 9.40.FC4W1
-- On-Line -- Up 2 days 00:43:27 -- 3604320 Kbytes
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
5151858 5951731 585827856 99.12 381404 844368 3277680 88.36
isamtot open start read write rewrite delete commit
rollbk
601048424 23013282 50133143 398114427 1010277 152808 392692 81069
178
gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
0 0 0 0 0 0 0
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 4634.33 217.43 27 133
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
604969 206 138155032 0 0 12 60190 355976
ixda-RA idx-RA da-RA RA-pgsused lchwaits
647861 65183 2078422 2791203 100119
It almost looks like sysptprof is reporting the number of pages
scanned rather than the number of times a table was scanned.
This query ran fine in FC2. I usually picked up a few scans on each
table throughout the day.
Any ideas on this one? I searched CDI and IBM Support without any
luck.
Thanks!
--
bothwellno@spam.duke.edu