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.


Syntax:

>>-onstat-- -g--ppd--+------------------+----------------------><
                     +-partition number-+   
                     '- 0---------------'

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

Figure 1. onstat –g ppd Output

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
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