Re: Location of physical and logical logs [SOLVED]

On Wednesday 31 December 2008 10:34, Scott Newton wrote: > 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 to Neil, Pamela and June for answering: Either: Run 'onstat -d/-D' and focus on the 'fchunk' and name of the dbspaces you have. Then run 'onstat -l' and focus on the 'begin' column.  The number preceding the colon " : " corresponds to the chunk number from 'onstat -d/-D'. Or: You can see the location of the physical log by looking at the onconfig parameter PHYSDBS. To see the location of the logical log, you can run "oncheck -pe" and the report produced from this command shows the location of each of the logical log files.  The report from oncheck -pe also shows you the location of the physical log. Sometimes you just can't see the wood for the trees :-( Hope everybody using the Western calendar enjoys the New Year. 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.