Re: How can I identify which dbspace the logical logs are in ?

In article <6chd8i$1ih$1@nnrp1.dejanews.com>, lee.gammell@ctaylor.co.uk wrote: > > Does anyone know a way to identify which dbspace logical logs have been > created in using either SMI, onstat, oncheck etc. I know onmonitor can > display this, but I what a shell script to extract this information. I am > using Online Version 6.00.UE1. > Check this: database sysmaster; select number, uniqid, physchunk(physloc) physloc, chknum, name from syslogfil l, syschktab c, sysdbstab d where physchunk(physloc) = c.chknum and c.dbsnum = d.dbsnum order by 1; It's working in OnLine 7.2x > The SMI give me the size of each log but not its location with respect > to its dbspace or chunk. I need this for my companies Disaster Recovery > Manual and would like to capture the "current picture" rather than hard code > the current values which might change over the years (however unlikely that > may be). > > Many Thanks, > Lee Gammell. > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/ Now offering spam-free web-based newsreading > -- Vardan Aroustamian -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading