logical logs location
Hi everyone, I'm trying to identify in which DBSPACE current logical logs are located Is there any query or command to identify each one? I guess prior DBA created in several dbspaces. Thanks in advance!
oncheck -pe
Chunk Pathname Pagesize(k) Size(p) Used(=
p)
Free(p)
1 ./rootchk 2 1000000 2195=
06
780494
Description Offset(p=
)
Size(p)
------------------------------------------------------------- --------=
--------
RESERVED PAGES 0=
12
CHUNK FREELIST PAGE 12=
1
rootdbs:'informix'.TBLSpace 13=
250
PHYSICAL LOG 263=
97800
LOGICAL LOG: Log file 1 98063=
5000
LOGICAL LOG: Log file 2 103063=
5000
LOGICAL LOG: Log file 3 108063=
5000
LOGICAL LOG: Log file 4 113063=
5000
LOGICAL LOG: Log file 5 118063=
5000
LOGICAL LOG: Log file 6 123063=
5000
From: "PAULO PADILLA" <prpv75@hotmail.com>
To: ids@iiug.org
Date: 10/25/2014 11:11 AM
Subject: logical logs location [34031]
Sent by: ids-bounces@iiug.org
Hi everyone,
I'm trying to identify in which DBSPACE current logical logs are locate=
d
Is there any query or command to identify each one? I guess prior DBA
created
in several dbspaces.
Thanks in advance!
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
Run the following query in sysmaster database. it will give the logical log number, chunk number and dbspace name where logical log is located. select number logfile, c.chknum CHUNK, d.name DBSPACE from syslogfil l, syschunks c, sysdbstab d where c.chknum = l.chunk and c.dbsnum = d.dbsnum;
Thanks for your support!