informix 5 tbstat -d shows negative values and ...(goes on)
Posted in 2003
Hi Gurus,
This is related to a very old version , informix 5x.
I was asked to add some dataspace to this rather old version ,but when
i went to the customer i discovered strange things:
This is a gsm company . Their problem is lack of disk space . when i
run tbstat -d , i see 3 dbspaces rootdbs , dbs1 , dbs2 and 2
databases , db1 and db2 . I dropped some tables in db2 (which resides
in dbs2) , then move a large table from dbs1 to dbs2 . Basically this
solved the customers space problem until they reboot the server!
Before rebooting the server tbstat -d had proper information . After
reboot , tbstat -d had negative values for free spaces !
More interestingly , i discovered that the customer who knows nothing
about informix , issue tbinit after the server reboots and starts
application but the server has 2 informix instance running and both of
these instances use SAME DISK AREA. They use SAME ROOTDBS ,... all the
files! And i also discovered that their application is using its own
instance (by properly setting INFORMIXSERVER and TBCONFIG parmeters )
but the customer use the dbserver by using their instance which uses
same data files.
The gsm application which they use , did not run after i made the
table reorganization , (although the dbserver is up , and the
applications 4gl interface runs (means application can connect the db)
interestingly the app cant go on further .This is the problem of
application in fact.)I did not find the reason or this since the
dbserver is up ,sqlturbo is up , data is same but only the dbspace of
one table is changed . Basicaly, this change cant affect the
application since the app does not aware the phy.ocation of the
tables.
So , the online.log has some corruption messages .But these messages
were there before i made the reorg.:
tblspace header error:
22:46:14 8e0e40: 00000000 00000000 00000000 00000000 ........
........
22:46:14 8e0e50: 00000000 00000000 00000000 00000000 ........
........
22:46:14 8e0e60: 01000000 00000000 03000001 00000000 ........
........
22:46:14 8e0e70: 10001000 00000000 00000000 00000000 ........
........
22:46:14 8e0e80: 00000000 00000000 00000000 00000000 ........
........
22:46:14 8e0e90: 00000000 00000000 00000000 00000000 ........
........
22:46:14 8e0ea0: 00000000 00000000 00000000 00000000 ........
........
22:46:14 8e0eb0: 00000000 00000000 00000000 00000000 ........
........
22:46:14 8e0ec0: 00000000 00000000 00000000 00000000 ........
........
22:46:14 8e0ed0: 00000000 00000000 00000000 00000000 ........
........
22:46:14 8e0ee0: 00000000 00000000 00000000 00000000 ........
........
22:46:14 8e0ef0: 00000000 00000000 00000000 00000000 ........
........
22:46:14 8e0f00: 00000000 00000000 00000000 00000000 ........
........
22:46:14 8e0f10: 02000001 02000a00 24000000 01000100 ........
$.......
22:46:14 8e0f20: 7fa9ec36 01000000 04000000 04000000 ...6....
........
22:46:14 8e0f30: 04000000 03000000 01000000 ffffffff ........
........
22:46:14 8e0f40: 48000000 02000000 00000000 b8541b00 H.......
.....T..
22:46:14 8e0f50: 04000000 00000000 00000000 00000000 ........
........
22:46:14 8e0f60: 00000000 00000000 00000000 00000000 ........
........
22:46:14 8e0f70: 00000000 00000000 00000000 00000000 ........
........
22:46:14 8e0f80: 00000000 00000000 04000000 00000000 ........
........
22:46:14 8e0f90: 00000000 00000000 00000000 00000000 ........
........
22:46:14 8e0fa0: 00000000 00000000 183c8f00 00000000 ........
.<......
22:46:14 8e0fb0: 883eae85 ffffffff 00000000 00000000 .>......
........
22:46:14 8e0fc0: 98488f00 00000000 .H......
22:46:14 page header, slot table and stamp: page e20000 slottabe207e8
22:46:14 e20000: 10001000 3a31a27a 05000200 58009007 ....:1.z
....X...
22:46:14 e20010: 00000000 00000000 ........
22:46:14 e207e8: 50000800 50000000 50000000 50000000 P...P...
P...P...
22:46:14 e207f8: 18003800 3a31a27a ..8.:1.z
22:46:14 -- Fail Consistency Check -- pthdrpage:ptalloc:bad extent
slot -- pid=3325 user=100 us=803468
Just because the app cant run the customer applies its own recovery
process which is rather unbelievable: They reboot the server , login
as informix (at this step i run ipcs and saw an informix instance is
up) , issue tbinit -i , and tbtape -r than the app starts to run!!!.
I suggested them immediate dbexport of databases and also applied it
since they did not know what dbexport was. I have the clean data
without corruption and thinking of reinitializing the server (but only
one) and importing the data. But the big issue is the application
probably wont work as i did similiar thing before(reorganizing table)
the customer also does not know about their application.
Any suggestions will be appreciated.
Kind Regards,
hope