RE: location of logs
In article <90r0bf$ldg$1@nnrp1.deja.com>,
rsalido@my-deja.com wrote:
> Yeah, I already knew about both options. Onmonitor is not available
for
> NT, is it?
> Isn't there an easier way that oncheck -pe? This is a very long
> output for what it should be a simple thing....what about querying
SMI?
> What is the name of the table that has information about the logs?
>
> Thank you.
>
> In article <90qttu$mtv$1@news.xmission.com>,
> "Obnoxio The Clown" <obnoxio@hotmail.com> wrote:
> >
> > From: "Sinha, Niraj" <niraj.sinha@BondBook.com>
> > >
> > >How about just going to :
> > >onmonitor --> status ---> logs.
> > >I think that is pretty easy :)
> >
> > I keep forgetting about onmonitor. :-)
> >
> > >-----Original Message-----
> > >From: Obnoxio The Clown [mailto:obnoxio@hotmail.com]
> > >
> > >oncheck -pe> > >
> > >From: rsalido@my-deja.com
> > > >
> > > >Is there a way to find out where my logs are? I mean onstat -l
> gives me
> > > >a bunch of information regarding the logs but I dont think it
shows
> in
> > > >which dbspace they reside in.....any ideas?
> > > > I just started working on this database and I'd like to know
if
> the
> > > >logs physical and logical were moved out of the root dbspace....
> > >
> >
>
>_______________________________________________________________________
> _
> > >_____________
> > >Get more from the Web. FREE MSN Explorer download :
> > >http://explorer.msn.com
> >
> >
>
________________________________________________________________________
> _____________
> > Get more from the Web. FREE MSN Explorer download :
> http://explorer.msn.com
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
I have the following saved of as working from my 7 days. I am sure I
got it from someone else's post, because I didn't even know there was a
physchunk SP.(If there isn't, just do the match to get the chunk number
from the address)
--
SELECT number, name
FROM syslogfil, syschunks, sysdbspaces
WHERE physchunk(physloc) = chknum
AND syschunks.dbsnum = sysdbspaces.dbsnum
--
The structure of syslogfil in 8.3 does not have physloc, so I have
nothing to test this on.
Hope this helps,
Will
P.S. you can also do an onstat -l, and look at the address. From the
address you can get the chunk #, from the chunk # you can get the
dbspace.
Sent via Deja.com http://www.deja.com/
Before you buy.