DB2 - Real time monitoring of DB2 backup and restore

18 February,2012 by Jack Vamvas

A useful command for DB2 DBAs is the LIST UTILITIES command.

It displays the list of active utilities.

 Examples of usage include : BACKUPS, RESTORES, performance issue, progress of RUNSTATS

[db2usr1@server1 ~]$ db2 list utilities show detail

ID                               = 36708
Type                             = BACKUP
Database Name                    = MYDB
Partition Number                 = 0
Description                      = offline db
Start Time                       = 18/02/2012 10:29:57.616567
State                            = Executing
Invocation Type                  = User
Throttling:
   Priority                      = Unthrottled
Progress Monitoring:
   Estimated Percentage Complete = 99
      Total Work                 = 124309084 bytes
      Completed Work             = 123348784 bytes
      Start Time                 = 18/02/2012 10:29:57.616576

 See Also

Command to see connection on a DB2 database - list applications

DMS Container Space Full

Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on DB2 - Real time monitoring of DB2 backup and restore

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright