onstat -g defragment command: Print defragment partition extents

Use the onstat -g defragment command to display information about the active requests to defragment partition extents.

Syntax:

onstat -gdefragment

Example output

Figure 2: onstat -g defragment command output
Defrag info
id  table name                     tid  dbsnum  partnum  status                substatus  errnum
15  stores_demo:informix.stdtab2   49   2       2097155  SEARCHING_FOR_EXTENT  0          0  
Note: This command displays information about defragment requests that are active. If there are no active defragment requests, only the column headings are returned.

Output description

id
The ID of the defragment request.
table name
The fully-qualified name of the table that is being defragmented.
tid
The thread ID.
dbsnum
The dbspace number that is being defragmented.
partnum
The partition number that is being defragmented.
status
  • SEARCHING_FOR_EXTENT
  • MERGING_EXTENTS
  • DEFRAG_COMPLETED
  • DEFRAG_FAILED
substatus
The detailed status number, if any.
errnum
The last error number returned from the defragmentation request.