The oncheck -pr command
The database server stores chunk information in the reserved pages PAGE_1PCHUNK and PAGE_2PCHUNK.
To list the contents of the reserve pages, run oncheck -pr. The following
example shows sample output for oncheck -pr. This output is essentially the same
as the onstat -d output; however, if the chunk information has changed since the
last checkpoint, these changes are not in the oncheck -pr output.
Validating PAGE_1DBSP & PAGE_2DBSP...
Using DBspace page PAGE_1DBSP.
DBspace number 1
DBspace name rootdbs
Flags 0x20001 No mirror chunks
Number of chunks 1
First chunk 1
Date/Time created 06/15/2023 08:35:02
Partition table page number 14
Logical Log Unique Id 0
Logical Log Position 0x0
Oldest Logical Log Unique Id 4
Last Logical Log Unique Id 0
Expand Size (Chunk Create) 10.0%
Expand size (Chunk Extend) 10000k
DBspace archive status No archives have occurred.
DBspace number 2
DBspace name sbspace
Flags 0x28001 No mirror chunks
& sbspace
Number of chunks 1
First chunk 2
Date/Time created 06/15/2023 08:37:10
Partition table page number 4
Logical Log Unique Id 4
Logical Log Position 0xcdc050
Oldest Logical Log Unique Id 4
Last Logical Log Unique Id 0
Expand Size (Chunk Create) 10.0%
Expand size (Chunk Extend) 0.0%
DBspace archive status No archives have occurred.
DBspace number 3
DBspace name sb_ext1
Flags 0x40028001 No mirror chunks
& sbspace
& External Smart Blobs
ESB Directories: /work/jmcmahon/utm/sbdir1
Number of chunks 1
First chunk 3
Date/Time created 06/15/2023 08:37:24
Partition table page number 4
Logical Log Unique Id 4
Logical Log Position 0xce4050
Oldest Logical Log Unique Id 4
Last Logical Log Unique Id 0
Expand Size (Chunk Create) 10.0%
Expand size (Chunk Extend) 0.0%
DBspace archive status No archives have occurred.
Validating PAGE_1PCHUNK & PAGE_2PCHUNK...
Using primary chunk page PAGE_2PCHUNK.
Chunk number 1
Flags 0x40 Chunk is online
Chunk path rootdbs_chunk_1
Chunk offset 0 (p)
Chunk size 150000 (p)
Number of free pages 39439
DBspace number 1
Chunk number 2
Flags 0x24044 Chunk resides in UNIX file
& Chunk is online
& Part of an sbspace
Chunk path sbspace
Chunk offset 0 (p)
Chunk size 10000 (p)
Number of free pages 518
DBspace number 2
Chunk number 3
Flags 0x24044 Chunk resides in UNIX file
& Chunk is online
& Part of an sbspace
Chunk path /work/jmcmahon/utm/sb_ext1
Chunk offset 0 (p)
Chunk size 10000 (p)
Number of free pages 518 DBspace number 3