Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.