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.

Figure 1: Syntax:

1  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