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 2: 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 3: 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

Figure 4: onstat -g dsk command output for a compress operation

                          Rows            Approx               Approx
Partnum     OP       Processed  Cur Page    Prog  Duration  Remaining  Table
0x00100196  COMPRESS     63253      3515     75%  00:00:03   00:00:01  footab

Figure 5: onstat -g dsk command output for a repack operation

                         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