DB2 10.5 for Linux, UNIX, and Windows

LIST UTILITIES command

Displays to standard output the list of active utilities on the instance. The description of each utility can include attributes such as start time, description, throttling priority (if applicable), as well as progress monitoring information (if applicable).

Scope

This command returns information for all database partitions.

Authorization

One of the following authorities:

SYSADM
SYSCTRL
SYSMAINT
SYSMON

Required connection

Instance

Command syntax


>>-LIST UTILITIES--+-------------+-----------------------------><
                   '-SHOW DETAIL-'

Command parameters

SHOW DETAIL: Displays detailed progress information for utilities that support progress monitoring.

Examples

Sample output showing the progress information:

LIST UTILITIES SHOW DETAIL

ID                               = 1
Type                             = BACKUP
Database Name                    = SAMPLE
Description                      = offline db
Start Time                       = 09/17/2012 13:28:30.575198
State                            = Executing
Invocation Type                  = User
Throttling:
   Priority                      = Unthrottled
Progress Monitoring:
   Estimated Percentage Complete = 1
      Total Work                 = 747868852768 bytes
      Completed Work             = 10738136885 bytes
      Start Time                 = 09/17/2012 13:28:30.575211

Sample output showing the partition number in the output when the DB2 Database Partitioning Feature (DPF) is enabled:

db2 BACKUP DATABASE DWDB ON DBPARTITIONNUM 16 TO /db2/part16 COMPRESS WITHOUT PROMPTING

LIST UTILITIES SHOW DETAIL

ID                               = 1
Type                             = BACKUP
Database Name                    = DWDB
Partition Number                 = 16
Description                      = offline db
Start Time                       = 09/17/2012 13:28:30.575198
State                            = Executing
Invocation Type                  = User
Throttling:
   Priority                      = Unthrottled
Progress Monitoring:
   Estimated Percentage Complete = 1
      Total Work                 = 747868852768 bytes
      Completed Work             = 10738136885 bytes
      Start Time                 = 09/17/2012 13:28:30.575211

Usage notes

Use this command to monitor the status of running utilities. For example, you might use this utility to monitor the progress of an online backup. In another example, you might investigate a performance problem by using this command to determine which utilities are running. If the utility is suspected to be responsible for degrading performance then you might elect to throttle the utility (if the utility supports throttling). The ID from the LIST UTILITIES command is the same ID used in the SET UTIL_IMPACT_PRIORITY command.

The LIST UTILITIES command can be used to monitor the progress of deferred cleanup of indexes by asynchronous index cleanup.

Starting with DB2® Version 9.7 Fix Pack 1, the LIST UTILITIES command can be used to monitor the progress of the completion of a detach of a data partition from a partitioned table by the asynchronous partition detach task. Detaching a data partition from a data partitioned table is initiated by issuing a ALTER TABLE statement with the DETACH PARTITION clause.