DB2 – Real time monitoring of DB2 backup and restore

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

 Author: Jack Vamvas

Leave a Reply

Discover more from ciquery

Subscribe now to keep reading and get access to the full archive.

Continue reading