DB2 : displays the list of active utilities

  db2 list utilities show detail

The LIST UTILITIES command in DB2 displays the list of active utilities on the instance, providing detailed progress information for utilities that support progress monitoring.



This command is useful for monitoring the status of running utilities, such as online backups or RUNSTATS operations. It helps in identifying performance issues and determining which utilities are running. If a utility is suspected to be degrading performance, it can be throttled using the SET UTIL_IMPACT_PRIORITY command.

Note: The LIST UTILITIES command can also be used to monitor the progress of deferred cleanup of indexes by asynchronous index cleanup and the completion of a detach of a data partition from a partitioned table.




Sample Output

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

Comments

Post a Comment

Popular posts from this blog

Oracle: To clean up WRI$_ADV_OBJECTS

 set linesize 200; select segment_name, segment_type, bytes from dba_segments where tablespace_name='SYSAUX' order by bytes asc; COL OCCUPANT_NAME FORMAT A30 SELECT OCCUPANT_NAME,SPACE_USAGE_KBYTES FROM V$SYSAUX_OCCUPANTS ORDER BY SPACE_USAGE_KBYTES DESC; COL SEGMENT_NAME FORMAT A30 COL OWNER FORMAT A10 COL TABLESPACE_NAME FORMAT A10 COL SEGMENT_TYPE FORMAT A15 SELECT * FROM (SELECT SEGMENT_NAME,OWNER,TABLESPACE_NAME,BYTES/1024/1024 "SIZE(MB)",SEGMENT_TYPE FROM DBA_SEGMENTS WHERE TABLESPACE_NAME='SYSAUX' ORDER BY BYTES DESC) WHERE ROWNUM<=10; 1.  automatic clean-up default 31 days           SELECT dbms_stats.get_stats_history_availability from Dual; 2. modify retention policy        exec  dbms_stats.alter_stats_history_retention (14); 3. a manual cleaning  exec dbms_stats.purge_stats (sysdate-14);   ALTER TABLE WRI$_ADV_OBJECTS MOVE; ALTER INDEX WRI$_ADV_OBJECTS_IDX_01 REBUILD; ALTER INDEX WRI$_ADV_OBJECTS_IDX_02 R...
Read more