onstat -g dsk command: Print the progress of the currently running compression operation

Use the onstat -g dsk command to print information that shows the progress of currently running compression operations, such as compress, repack, and shrink.

Read syntax diagramSkip visual syntax diagram
Syntax:

>>-onstat-- -g -dsk--------------------------------------------><

Example output

Figure 1. onstat -g dsk command output for a compress operation
                    Processed        Remaining Duration Remaining
Partnum   OP        Rows      Blobs  Rows      Time(s)  Time(s)  Table Name
400002    Compress  6325      1752   1497      00:00:00 00:00:00 db:sl:t1
Figure 2. onstat -g dsk command output for a repack operation
                        Processed        Remaining Duration Remaining
Partnum  OP     Pass    Rows      Blobs  Rows      Time(s)  Time(s)  Table Name
400002   Repack 1       6325      1752   1497      00:00:00 00:00:00 db:sl:t1

Output description

partnum
Partition number of the table or fragment
OP
Compression operation, such as compress, repack, or shrink.
Pass
For repack operations, 1 indicates the first pass of reading the rows, and 2 indicates the second pass.
Processed Rows
Number of rows that are processed so far for the specified operation
Blobs
The number of simple large objects that were operated on
Remaining Rows
The number of remaining rows to process. For repack operations, the number of rows that remain in the current pass.
Duration Time(s)
The amount of time since the beginning of the operation
Remaining Time(s)
Approximate amount of remaining time for the operation. For repack operations, the amount of time that remains for the current pass.

Copyright© 2019 HCL Technologies Limited