How to tell which dbspace logical logs are stored in

Answer

Described are two methods for determining the dbspace(s) logical logs were created in. The dbspaces listed in the following ontsat -d output will be utilized in the two methods described.

onstat -d

IBM Informix Dynamic Server Version 11.50.FC5     -- On-Line -- Up 00:10:03 -- 1
50528 Kbytes

Dbspaces
address          number   flags      fchunk   nchunks  pgsize   flags   owner    name
111430e88        1        0x60001    1        1        2048     N  B    informix rootdbs
112524b60        2        0x60001    2        1        2048     N  B    informix logdbs
 2 active, 2047 maximum

Chunks
address          chunk/dbs     offset     size       free       bpages     flags
 pathname
111432028        1      1      0          250000     229731                PO-B
 /chunks/rootdbs
112524cf8        2      2      0          25000      23447                 PO-B
 /chunks/logdbs
 2 active, 32766 maximum



method-1

The follow example of the onstat -l output illistrates how to identify the dbspaces each logical log resides in. The begin column lists the
dbspace number:page number where each logical log resides.

example:

onstat -l

IBM Informix Dynamic Server Version 11.50.FC5     -- On-Line -- Up 00:10:14 -- 1
50528 Kbytes

Physical Logging
Buffer bufused  bufsize  numpages   numwrits   pages/io
  P-2  11       16       1655       126        13.13
      phybegin         physize    phypos     phyused    %used
      1:263            9950       1771       73         0.73

Logical Logging
Buffer bufused  bufsize  numrecs    numpages   numwrits   recs/pages pages/io
  L-3  0        16       108837     8475       2720       12.8       3.1
        Subsystem    numrecs    Log Space used
       OLDRSAM      108827     14181224
       HA           10         440

address          number   flags    uniqid   begin          size    used  %used
111575ee0        1        U-B----   7        1:10213        750      414   55.20
111575f48         2        U------   8        1:10963        750      750  100.00
111575fb0         3        U------   9        1:11713        750      750  100.00
11155d450        4        U------   10       1:12463        750      750  100.00
11155d4b8        5        U------   11       1:13213        750      750  100.00
11155d520        6        U---C-L  12       1:13963        750      561   74.80
112533c58        7        A------    0        2:53             750          0     0.00
112524798        8        A------    0        2:803           750          0     0.00
8 active, 8 total


method-2

The oncheck -pr will display logical log information found in the reserved pages.
The Physical location lists the
dbspace number:page number where each logical log resides.

example:

Log file number 1
Unique identifier 7
Physical location 1:10213


Log file number 2
Unique identifier 8
Physical location 1:10963


Log file number 7
Unique identifier -
Physical location 2:53


Log file number 8
Unique identifier -
Physical location 2:803