Location of physical and logical logs

This may seem like a bit of stupid question but how do I find out in which dbspace the logs are on a system I didn't set up? Thanks -- Regards Scott Newton | R&D Solution Specialist | Integral Technology Group Ltd 95 Ascot Ave, Greenlane | PO Box 302313, North Harbour, North Shore City 0751 DDI 09 302 3788 | Fax 09 477 0478 | www.integralgroup.co.nz This correspondence is confidential, is intended for the named recipient(s) only, and may contain information that is confidential or subject to legal professional privilege. If you are not the intended recipient you must not use, disclose, distribute, copy or retain it. If you have received it in error please immediately notify me by return email and delete the emails. Thank you.

"Scott Newton" <scott.newton@integralgroup.co.nz> wrote in message news:mailman.111.1230672900.1831.informix-list@iiug.org... This may seem like a bit of stupid question but how do I find out in which dbspace the logs are on a system I didn't set up? onstat -l. See below for an example: # onstat -l IBM Informix Dynamic Server Version 10.00.FC8W2 -- On-Line (Prim) -- Up 12 days 16:52:20 -- 46892464 Kbytes Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-1 12 64 16998852 339057 50.14 phybegin physize phypos phyused %used 2:53 511947 306996 106319 20.77 <snip> address number flags uniqid begin size used %used c00000070235ffc0 7 U-B---- 3307 3:53 102399 102399 100.00 <snip> So the physical log in in dbspace 2 (from 2:53) and the first (and in fact all subsequent, but I've snipped the remainder of the output) logical logs are in dbspace 3. And these are: onstat -d | more IBM Informix Dynamic Server Version 10.00.FC8W2 -- On-Line (Prim) -- Up 12 days 16:59:20 -- 46892464 Kbytes Dbspaces address number flags fchunk nchunks pgsize flags owner name c00000070033ae90 1 0x40001 1 1 2048 N B informix rootdbs c0000007047c88a0 2 0x40001 2 1 2048 N B informix physdbs c0000007047c8a40 3 0x40001 3 1 2048 N B informix llogdbs <snip> 2 - physdbs, and 3 - llogdbs. rgds Neil