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.


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.