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.
Example output
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
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.