Other / Utilities
Purpose
Utility view shows the list of utilites. This view could be used to check the progress and state of each utility.
Screenshot
Metric shown
Member
In a partitioned database environment, this is the numeric identifier for the database member. For Db2 Enterprise Server Edition and in a Db2 pureScale environment, this value is 0.
Source: SYSIBMADM.SNAPUTIL.DBPARTITIONNUM
Utility ID
The unique identifier corresponding to the utility invocation.
Source: SYSIBMADM.SNAPUTIL.UTILITY_ID
Utility type
The class of utility.
Source: SYSIBMADM.SNAPUTIL.UTILITY_TYPE
Utility start_time
The date and time when the current utility was originally invoked.
Source:
Progress start_time
A timestamp representing the start of the phase.
Source:
Utility description
A brief description of the work a utility is performing.
Reorg end
The end time of a table or data partition reorganization.
Source: SNAP_GET_TAB_REORG(CURRENT_SERVER, 0).REORG_END
Utility state
The state of a utility.
Source:
Invoke type
Describes how a utility was invoked.
Table schema
The schema of the table.
Source: SNAP_GET_TAB_REORG(CURRENT_SERVER, 0).TABSCHEMA
Table name
The name of the table.
Source: SNAP_GET_TAB_REORG(CURRENT_SERVER, 0).TABNAME
Partition ID
The identifier of the data partition for which information is returned.
Source: SNAP_GET_TAB_REORG(CURRENT_SERVER, 0).DATA_PARTITION_ID
Index schema
Schema name of the index.
Source: SYSCAT.INDEXES.INDSCHEMA
Index name
Unqualified name of the index.
Source: SYSCAT.INDEXES.INDNAME
Reorg type
Table reorganize attribute settings.
Source: SNAP_GET_TAB_REORG(CURRENT_SERVER, 0).REORG_TYPE
Utility priority
The amount of relative importance of a throttled utility with respect to its throttled peers.
Source: SYSIBMADM.SNAPUTIL.UTILITY_PRIORITY
Reorg phase
Indicates the reorganization phase of the table.
Source: SNAP_GET_TAB_REORG(CURRENT_SERVER, 0).REORG_PHASE
Percentage complete
The percentage of work units for the current phase which have been completed.
If UTILITY_TYPE does not equal to ‘REORG’, the value is PROGRESS_TOTAL_UNITS / PROGRESS_COMPLETED_UNITS; If UTILITY_TYPE equals to ‘REORG’ and REORG_STATUS equals to ‘COMPLETED’, then the value is 100; For all the rest cases, the value is REORG_CURRENT_COUNTER / REORG_MAX_COUNTER.
Source:
UTILITY_TYPE = SYSIBMADM.SNAPUTIL.UTILITY_TYPE
REORG_STATUS = SNAP_GET_TAB_REORG(CURRENT_SERVER, 0).REORG_STATUS
PROGRESS_TOTAL_UNITS = SYSIBMADM.SNAPUTIL_PROGRESS.PROGRESS_TOTAL_UNITS
PROGRESS_COMPLETED_UNITS = SYSIBMADM.SNAPUTIL_PROGRESS.PROGRESS_COMPLETED_UNITS
REORG_CURRENT_COUNTER = SNAP_GET_TAB_REORG(CURRENT_SERVER, 0).REORG_CURRENT_COUNTER
REORG_MAX_COUNTER = SNAP_GET_TAB_REORG(CURRENT_SERVER, 0).REORG_MAX_COUNTER
Progress complete unit
The number of work units for the current phase which have been completed.
Reorg rows compressed
The number of rows compressed in the table during reorganization.
Source: SNAP_GET_TAB_REORG(CURRENT_SERVER, 0).REORG_ROWSCOMPRESSED
Reorg rows rejected
The number of rows that were not compressed during reorganization due to the record length being less than or equal to the minimum record length.
Source: SNAP_GET_TAB_REORG(CURRENT_SERVER, 0).REORG_ROWSREJECTED
Reorg completion
Indicator for table reorganization success.
If REORG_END is not NULL, then the value is REORG_COMPLETION; Otherwise, the value is NULL
Source:
REORG_END = SNAP_GET_TAB_REORG(CURRENT_SERVER, 0).REORG_END
REORG_COMPLETION = SNAP_GET_TAB_REORG(CURRENT_SERVER, 0).REORG_COMPLETION
Progress total units
The total amount of work to perform in order for the phase to be complete.
Progress description
Describes the phase of work.
Progress work metric
The metric for interpreting the PROGRESS_TOTAL_UNITS and PROGRESS_COMPLETED_UNITS elements.
= PROGRESS_WORK_METRIC
Source:
PROGRESS_WORK_METRIC = SYSIBMADM.SNAPUTIL_PROGRESS.PROGRESS_WORK_METRIC
PROGRESS_TOTAL_UNITS = SYSIBMADM.SNAPUTIL_PROGRESS.PROGRESS_TOTAL_UNITS
PROGRESS_COMPLETED_UNITS = SYSIBMADM.SNAPUTIL_PROGRESS.PROGRESS_COMPLETED_UNITS
Progress seq num
Phase number.
Progress list cur seq num
This element describes how to interpret a list of progress elements.
Source: SYSIBMADM.SNAPUTIL.PROGRESS_LIST_ATTR