How do I know in which dbspace log files are 1

[pengzhang]

I want to find out in an existing informix setup the location of logical log files. Can I use onstat or something else?

Thanks

 

[vpshriyan]

Hi,

There are 3 ways:

1. onmonitor -> Status -> Logs
2. oncheck -pe ( If you have several logs output could be huge)
3. onstat -l and locate begin column. You have a hexdecimal number which poins to the logical log start address. The full address is like 0xCCCPPPPP. CCC stands for chunk number and PPPPP stands for offset with the chunk. We interested in chunk number only in this context. Onstat removes the preceding contents of this address and prints in form of CPPPPP. Relate the chunk number to the output of onstat -d and locate the chunk name and space name. IF C is 1 you can assume that it is root dbspace.

Further infomation:

http://www7b.software.ibm.com/dmdd/zones/informix/library/techarticle/scranton/0204scranton.html

Regards,
Shriyan

 

[pengzhang]

Thanks a lot, vpshriyan