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 dskExample 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
Rows Approx Approx
Partnum OP Processed Cur Page Prog Duration Remaining Table
0x00100196 COMPRESS 63253 3515 75% 00:00:03 00:00:01 footab
Rows Approx Approx
Partnum OP Processed Cur Page Prog Duration Remaining Table
0x00100196 REPACK 22900 4285 28% 00:00:01 00:00:02 footab
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 RowsProcessed
- 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.
- Curr Page
- The current page number that the server is operating on
- Approx Prog
- Percentage of the total operation that has completed
- Duration
- The number of seconds that have elapsed since the operation started
- Approx Remaining
- The approximate time that remains before the operation is complete
- Table NameTable
- Name of the table