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