onstat -g ppd command: Print partition compression dictionary information
Use the onstat –g ppd command to display information about the active compression dictionaries that were created for compressed tables and table fragments or compressed B-tree indexes. You can choose to print information for a particular numbered partition or for all open partitions.
The onstat –g ppd command prints the same information that the syscompdicts_full table and the syscompdicts view in the sysmaster database display. The only difference is that the syscompdicts_full table and the syscompdicts view display information about all compression dictionaries, not just the active dictionaries.
If you specify a partition number, onstat
-g ppd prints the partition profile for that partition.
If you specify 0
, this option prints profiles for
all partitions.
Example output
partnum Version DbsNum CrTS CrLogID CrLogPos DrTS DrLogID DrLogPos
0x200002 1 2 1229018150 3 577560 0 0 0
0x200003 1 2 1229018150 3 606232 0 0 0
0x300002 1 3 1229018150 3 630808 0 0 0
0x400002 1 4 1229018150 3 655384 0 0 0
0x500002 1 5 1229018150 3 679960 0 0 0
partnum ColOffset DbsNum CrTS CrLogID CrLogPos DrTS DrLogID DrLogPos
0x1001d5 -1 1 1393371661 4 16339024 0 0 0
0x1001d5 4 1 1393371661 4 16355408 0 0 0
Output description
- partnum
- Partition number to which the compression dictionary applies
- Version
- Version of the code that is creating the compression dictionary
- ColOffset
- The byte offset for a compressed partition blob column.
-1
means that only the row is compressed - DbsNum
- Number of the dbspace that the dictionary resides in
- CrTS
- Timestamp that shows when the dictionary was created
- CrLogID
- Unique ID for the logical log that was created when the dictionary was created
- CrLogPos
- Position within the logical log when the dictionary was created
- DrTS
- Timestamp that shows when the dictionary was purged
- DrLogID
- Unique ID for the logical log that was created when the dictionary was purged
- DrLogPos
- Position within the logical log when the dictionary was purged