LIST UTILITIES command
The 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
Command parameters
- SHOW DETAIL
- Displays detailed progress information for utilities that support progress monitoring.
Examples
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
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.