Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Learn about SQL Server DBA, SQL Server database performance,SQL Server optimisation,database tuning,t-sql,ssis
Browse by Tags · View All
DBA Scripts 51
performance 37
SQL Server 29
Object Management 24
#SQLServer 24
Backup and Restore 20
Security Management 20
Powershell 17
Indexes 14
DBA 14

Archive · View All
June 2011 38
January 2011 33
May 2011 32
August 2011 27
July 2011 26
January 2012 24
February 2011 19
April 2011 19
March 2011 17
March 2012 17

Jack Vamvas's Blog

DB2 - Real time monitoring of DB2 backup and restore

Feb 18 2012 12:00AM 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

Republished with author's permission. See the original post here.


Republished from SQL Server DBA [65 clicks].  Read the original version here [32134 clicks].

Jack Vamvas
5 · 27% · 8528
0
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]