DB2 - Real time monitoring of DB2 backup and restore

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