logical logs location
Paulo Padilla asked how to find which dbspaces hold the logical logs. Madison Pruet suggested oncheck -pe, showing log files in the chunk layout. Ajay Gupta gave a sysmaster query joining syslogfil, syschunks and sysdbstab on chunk and dbsnum to list log number, chunk and dbspace. Paulo thanked them.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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!