Invalid free space report in IDS 7.31.FD8 on Solaris 9

To me it seems it's something wrong with reports regarding free space in dbspaces. Or, in the worse case, could be something wrong with our database. The OS is Solaris 9 (SPARC) and IDS version is 7.31.FD8. Look at these reports: ===================================================================== informix$ onstat -d IBM Informix Dynamic Server Version 7.31.FD8 -- On-Line -- Up 71 days 19:52:03 -- 2016256 Kbytes Dbspaces address number flags fchunk nchunks flags owner name 154f7e1c0 1 1 1 1 N informix rootdbs 15690d838 2 1 2 1 N informix physdbs 15690d920 3 1 3 1 N informix llogdbs1 15690da08 4 1001 4 1 N informix tmpdbs1 15690daf0 5 2001 5 1 N T informix tmpdbs2 15690dbd8 6 1001 6 1 N informix tmpdbs3 15690dcc0 7 2001 7 1 N T informix tmpdbs4 15690dda8 8 1 8 4 N informix oltpdbs 15690de90 9 1 12 8 N informix storagedbs 15690e028 10 1001 19 6 N informix auxdbs 10 active, 2047 maximum Chunks address chk/dbs offset size free bpages flags pathname 154f7e2a8 1 1 50 999000 997579 PO- /usr1/informix/dblinks/rootdbs 15690c028 2 2 50 50000 39947 PO- /usr1/informix/dblinks/logdbs1 15690c140 3 3 50050 800000 499947 PO- /usr1/informix/dblinks/logdbs1 15690c258 4 4 0 950000 949947 PO- /usr1/informix/dblinks/tmpdb1 15690c370 5 5 0 950000 947050 PO- /usr1/informix/dblinks/tmpdb2 15690c488 6 6 0 950000 949947 PO- /usr1/informix/dblinks/tmpdb3 15690c5a0 7 7 0 950000 942404 PO- /usr1/informix/dblinks/tmpdb4 15690c6b8 8 8 50 999950 34 PO- /usr1/informix/dblinks/baza1 15690c7d0 9 8 50 999950 470310 PO- /usr1/informix/dblinks/baza2 15690c8e8 10 8 50 999950 999947 PO- /usr1/informix/dblinks/baza3 15690ca00 11 8 50 999950 999947 PO- /usr1/informix/dblinks/baza4 15690cb18 12 9 50 999950 0 PO- /usr1/informix/dblinks/baza5 15690cc30 13 9 50 999950 0 PO- /usr1/informix/dblinks/baza6 15690cd48 14 9 50 999950 37500 PO- /usr1/informix/dblinks/baza7 15690ce60 15 9 50 999950 287500 PO- /usr1/informix/dblinks/baza8 15690cf78 16 9 50 999950 975000 PO- /usr1/informix/dblinks/baza9 15690d090 17 9 50 999950 300000 PO- /usr1/informix/dblinks/baza10 15690d1a8 18 9 50 999950 0 PO- /usr1/informix/dblinks/baza11 15690d2c0 19 10 50 999950 699897 PO- /usr1/informix/dblinks/baza12 15690d3d8 20 10 50 999950 849947 PO- /usr1/informix/dblinks/baza13 15690d4f0 21 10 50 999950 1949947 PO- /usr1/informix/dblinks/baza14 15690d608 22 10 50 999950 1449947 PO- /usr1/informix/dblinks/baza15 15690d720 23 10 50 999950 999947 PO- /usr1/informix/dblinks/baza16 158d0c028 24 9 50 995000 794997 PO- /usr1/informix/dblinks/baza17 156c73110 25 10 50 995000 994997 PO- /usr1/informix/dblinks/baza18 25 active, 2047 maximum =================================================================== You can see that for some chunks (21,22) the number of free pages is larger than the size of the chunk! When I look in onmonitor's report on corresponding dbspace, I get: =================================================================== Press ESC to return to the Status Menu. Use arrow keys to move the cursor. CHUNKS FOR auxdbs Chunk Chunk Pages Pages Full Pathname of Chunk Status Id Offset In Chunk Used 19 50 999950 300053 /usr1/informix/dblinks/baza12 PO- 20 50 999950 150003 /usr1/informix/dblinks/baza13 PO- 21 50 999950 -949997 /usr1/informix/dblinks/baza14 PO- 22 50 999950 -449997 /usr1/informix/dblinks/baza15 PO- 23 50 999950 3 /usr1/informix/dblinks/baza16 PO- DBspace has total of 5994750 pages, 6944682 of which are free =================================================================== You can see that we have some negative numbers. Also, I've executed Art Kagel's dbsavail.ec program, with the following output: =================================================================== informix$ ./dbsavail Dbspace Total Pages Free Pages ------------------ ------------ ------------ physdbs 50000 39947 llogdbs1 800000 499947 tmpdbs2 950000 944719 TempSpace tmpdbs4 950000 946282 TempSpace tmpdbs1 950000 949947 tmpdbs3 950000 949947 rootdbs 999000 997571 storagedbs 7994650 2394997 oltpdbs 3999800 2470238 auxdbs 5994750 6944682 ------------------ ------------ ------------ Totals: 23638200 17138277 =================================================================== For auxdbs, there seems to be more free pages than there are total pages! I have indications that the reporting on free pages is not invalid only on auxdbs dbspace. Yesterday the IDS were not able to insert new rows into table in storagedbs, in spite of the fact that it was reported that there were about 1600000 free pages in that dbspace. The problem was resolved by adding additional chunk to that dbspace. When running some oncheck commands, the most suspicious parts of what I got were: =================================================================== WARNING:No syssyntable records found. ... WARNING:No sysviews records found. .... WARNING:No sysdepend records found. =================================================================== Should I be worried? What do you suggest me to do? TIA, Darko Krstic

Did you run oncheck -ce ? Something does appear wrong in the counters. You may also want to bounce Informix. If nothing comes from these log a call with Tech Support. MW -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of darko Sent: Wednesday, 18 October 2006 2:59 a.m. To: informix-list@iiug.org Subject: Invalid free space report in IDS 7.31.FD8 on Solaris 9 To me it seems it's something wrong with reports regarding free space in dbspaces. Or, in the worse case, could be something wrong with our database. The OS is Solaris 9 (SPARC) and IDS version is 7.31.FD8. Look at these reports: ===================================================================== informix$ onstat -d IBM Informix Dynamic Server Version 7.31.FD8 -- On-Line -- Up 71 days 19:52:03 -- 2016256 Kbytes Dbspaces address number flags fchunk nchunks flags owner name 154f7e1c0 1 1 1 1 N informix rootdbs 15690d838 2 1 2 1 N informix physdbs 15690d920 3 1 3 1 N informix llogdbs1 15690da08 4 1001 4 1 N informix tmpdbs1 15690daf0 5 2001 5 1 N T informix tmpdbs2 15690dbd8 6 1001 6 1 N informix tmpdbs3 15690dcc0 7 2001 7 1 N T informix tmpdbs4 15690dda8 8 1 8 4 N informix oltpdbs 15690de90 9 1 12 8 N informix storagedbs 15690e028 10 1001 19 6 N informix auxdbs 10 active, 2047 maximum Chunks address chk/dbs offset size free bpages flags pathname 154f7e2a8 1 1 50 999000 997579 PO- /usr1/informix/dblinks/rootdbs 15690c028 2 2 50 50000 39947 PO- /usr1/informix/dblinks/logdbs1 15690c140 3 3 50050 800000 499947 PO- /usr1/informix/dblinks/logdbs1 15690c258 4 4 0 950000 949947 PO- /usr1/informix/dblinks/tmpdb1 15690c370 5 5 0 950000 947050 PO- /usr1/informix/dblinks/tmpdb2 15690c488 6 6 0 950000 949947 PO- /usr1/informix/dblinks/tmpdb3 15690c5a0 7 7 0 950000 942404 PO- /usr1/informix/dblinks/tmpdb4 15690c6b8 8 8 50 999950 34 PO- /usr1/informix/dblinks/baza1 15690c7d0 9 8 50 999950 470310 PO- /usr1/informix/dblinks/baza2 15690c8e8 10 8 50 999950 999947 PO- /usr1/informix/dblinks/baza3 15690ca00 11 8 50 999950 999947 PO- /usr1/informix/dblinks/baza4 15690cb18 12 9 50 999950 0 PO- /usr1/informix/dblinks/baza5 15690cc30 13 9 50 999950 0 PO- /usr1/informix/dblinks/baza6 15690cd48 14 9 50 999950 37500 PO- /usr1/informix/dblinks/baza7 15690ce60 15 9 50 999950 287500 PO- /usr1/informix/dblinks/baza8 15690cf78 16 9 50 999950 975000 PO- /usr1/informix/dblinks/baza9 15690d090 17 9 50 999950 300000 PO- /usr1/informix/dblinks/baza10 15690d1a8 18 9 50 999950 0 PO- /usr1/informix/dblinks/baza11 15690d2c0 19 10 50 999950 699897 PO- /usr1/informix/dblinks/baza12 15690d3d8 20 10 50 999950 849947 PO- /usr1/informix/dblinks/baza13 15690d4f0 21 10 50 999950 1949947 PO- /usr1/informix/dblinks/baza14 15690d608 22 10 50 999950 1449947 PO- /usr1/informix/dblinks/baza15 15690d720 23 10 50 999950 999947 PO- /usr1/informix/dblinks/baza16 158d0c028 24 9 50 995000 794997 PO- /usr1/informix/dblinks/baza17 156c73110 25 10 50 995000 994997 PO- /usr1/informix/dblinks/baza18 25 active, 2047 maximum =================================================================== You can see that for some chunks (21,22) the number of free pages is larger than the size of the chunk! When I look in onmonitor's report on corresponding dbspace, I get: =================================================================== Press ESC to return to the Status Menu. Use arrow keys to move the cursor. CHUNKS FOR auxdbs Chunk Chunk Pages Pages Full Pathname of Chunk Status Id Offset In Chunk Used 19 50 999950 300053 /usr1/informix/dblinks/baza12 PO- 20 50 999950 150003 /usr1/informix/dblinks/baza13 PO- 21 50 999950 -949997 /usr1/informix/dblinks/baza14 PO- 22 50 999950 -449997 /usr1/informix/dblinks/baza15 PO- 23 50 999950 3 /usr1/informix/dblinks/baza16 PO- DBspace has total of 5994750 pages, 6944682 of which are free =================================================================== You can see that we have some negative numbers. Also, I've executed Art Kagel's dbsavail.ec program, with the following output: =================================================================== informix$ ./dbsavail Dbspace Total Pages Free Pages ------------------ ------------ ------------ physdbs 50000 39947 llogdbs1 800000 499947 tmpdbs2 950000 944719 TempSpace tmpdbs4 950000 946282 TempSpace tmpdbs1 950000 949947 tmpdbs3 950000 949947 rootdbs 999000 997571 storagedbs 7994650 2394997 oltpdbs 3999800 2470238 auxdbs 5994750 6944682 ------------------ ------------ ------------ Totals: 23638200 17138277 =================================================================== For auxdbs, there seems to be more free pages than there are total pages! I have indications that the reporting on free pages is not invalid only on auxdbs dbspace. Yesterday the IDS were not able to insert new rows into table in storagedbs, in spite of the fact that it was reported that there were about 1600000 free pages in that dbspace. The problem was resolved by adding additional chunk to that dbspace. When running some oncheck commands, the most suspicious parts of what I got were: =================================================================== WARNING:No syssyntable records found. ... WARNING:No sysviews records found. .... WARNING:N

ifxmaillist@quanta.co.nz wrote: > Did you run oncheck -ce ? > Something does appear wrong in the counters. You may also want to bounce > Informix. If nothing comes from these log a call with Tech Support. > > MW > > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] > On Behalf Of darko > Sent: Wednesday, 18 October 2006 2:59 a.m. > To: informix-list@iiug.org > Subject: Invalid free space report in IDS 7.31.FD8 on Solaris 9 > > To me it seems it's something wrong with reports regarding free space > in dbspaces. Or, in the worse case, could be something wrong with our > database. The OS is Solaris 9 (SPARC) and IDS version is 7.31.FD8. > > Look at these reports: > > ===================================================================== > informix$ onstat -d> > IBM Informix Dynamic Server Version 7.31.FD8 -- On-Line -- Up 71 > days 19:52:03 -- 2016256 Kbytes> > Dbspaces > address number flags fchunk nchunks flags owner > name > 154f7e1c0 1 1 1 1 N informix > rootdbs > 15690d838 2 1 2 1 N informix > physdbs > 15690d920 3 1 3 1 N informix > llogdbs1 > 15690da08 4 1001 4 1 N informix > tmpdbs1 > 15690daf0 5 2001 5 1 N T informix > tmpdbs2 > 15690dbd8 6 1001 6 1 N informix > tmpdbs3 > 15690dcc0 7 2001 7 1 N T informix > tmpdbs4 > 15690dda8 8 1 8 4 N informix > oltpdbs > 15690de90 9 1 12 8 N informix > storagedbs > 15690e028 10 1001 19 6 N informix > auxdbs > 10 active, 2047 maximum > > Chunks > address chk/dbs offset size free bpages flags > pathname > 154f7e2a8 1 1 50 999000 997579 PO- > /usr1/informix/dblinks/rootdbs > 15690c028 2 2 50 50000 39947 PO- > /usr1/informix/dblinks/logdbs1 > 15690c140 3 3 50050 800000 499947 PO- > /usr1/informix/dblinks/logdbs1 > 15690c258 4 4 0 950000 949947 PO- > /usr1/informix/dblinks/tmpdb1 > 15690c370 5 5 0 950000 947050 PO- > /usr1/informix/dblinks/tmpdb2 > 15690c488 6 6 0 950000 949947 PO- > /usr1/informix/dblinks/tmpdb3 > 15690c5a0 7 7 0 950000 942404 PO- > /usr1/informix/dblinks/tmpdb4 > 15690c6b8 8 8 50 999950 34 PO- > /usr1/informix/dblinks/baza1 > 15690c7d0 9 8 50 999950 470310 PO- > /usr1/informix/dblinks/baza2 > 15690c8e8 10 8 50 999950 999947 PO- > /usr1/informix/dblinks/baza3 > 15690ca00 11 8 50 999950 999947 PO- > /usr1/informix/dblinks/baza4 > 15690cb18 12 9 50 999950 0 PO- > /usr1/informix/dblinks/baza5 > 15690cc30 13 9 50 999950 0 PO- > /usr1/informix/dblinks/baza6 > 15690cd48 14 9 50 999950 37500 PO- > /usr1/informix/dblinks/baza7 > 15690ce60 15 9 50 999950 287500 PO- > /usr1/informix/dblinks/baza8 > 15690cf78 16 9 50 999950 975000 PO- > /usr1/informix/dblinks/baza9 > 15690d090 17 9 50 999950 300000 PO- > /usr1/informix/dblinks/baza10 > 15690d1a8 18 9 50 999950 0 PO- > /usr1/informix/dblinks/baza11 > 15690d2c0 19 10 50 999950 699897 PO- > /usr1/informix/dblinks/baza12 > 15690d3d8 20 10 50 999950 849947 PO- > /usr1/informix/dblinks/baza13 > 15690d4f0 21 10 50 999950 1949947 PO- > /usr1/informix/dblinks/baza14 > 15690d608 22 10 50 999950 1449947 PO- > /usr1/informix/dblinks/baza15 > 15690d720 23 10 50 999950 999947 PO- > /usr1/informix/dblinks/baza16 > 158d0c028 24 9 50 995000 794997 PO- > /usr1/informix/dblinks/baza17 > 156c73110 25 10 50 995000 994997 PO- > /usr1/informix/dblinks/baza18 > 25 active, 2047 maximum > =================================================================== > > You can see that for some chunks (21,22) the number of free pages is > larger than the size of the chunk! > > When I look in onmonitor's report on corresponding dbspace, I get: > > =================================================================== > Press ESC to return to the Status Menu. > Use arrow keys to move the cursor. > > > > CHUNKS FOR auxdbs > > Chunk Chunk Pages Pages Full Pathname of Chunk > Status > Id Offset In Chunk Used > > 19 50 999950 300053 /usr1/informix/dblinks/baza12 > PO- > 20 50 999950 150003 /usr1/informix/dblinks/baza13 > PO- > 21 50 999950 -949997 /usr1/informix/dblinks/baza14 > PO- > 22 50 999950 -449997 /usr1/informix/dblinks/baza15 > PO- > 23 50 999950 3 /usr1/informix/dblinks/baza16 > PO- > > > > > > > DBspace has total of 5994750 pages, 6944682 of which are free > =================================================================== > > You can see that we have some negative numbers. > > Also, I've executed Art Kagel's dbsavail.ec program, with the following > output: > > =================================================================== > informix$ ./dbsavail > > Dbspace Total Pages Free Pages > ------------------ ------------ ------------ > physdbs 50000 39947 > llogdbs1 800000 499947 > tmpdbs2 950000 944719 TempSpace > tmpdbs4 950000 946282 TempSpace > tmpdbs1 950000 949947 > tmpdbs3 950000 949947 > rootdbs 999000 997571 > storagedbs 7994650 2394997 > oltpdbs 3999800 2470238 > auxdbs 5994750 6944682 > ------------------ ------------ ------------ > Totals: 23638200 17138277 > > =================================================================== > > For auxdbs, there seems to be more free pages than there are total > pages! > > I have indications that the reporting on free pages is not invalid only > on auxdbs dbspace. Yesterday the IDS were not able to insert new rows > into table in storagedbs, in spite of the fact that it was reported > that there were about