DB2 backup notification on Java Stack

[Former Member]

Hi,

I currently have a number of systems on pure Java stacks, so am limited on my DB2 management tools.

Most of these I plan to solve using DBA_COCKPIT from Solution Manager, but the immediate concern is notification of successful backups.

Is there a table or view which I can query and it will give me the status of the last backup? I can then run this as a cron job and have the status e-mailed to me.

Thanks

Chris

[Former Member · Accepted solution]

here is the db2 command to check the backup history

db2 list history backup all for <Database Name> | more

and if you want to check if the current backup is running or not or u want to check the procegress of the current backup you can use the db2 command

db2 list application show detail

if the backup is running it will show u the progress of the back once the backup is finished it wont show you anything , it will display only when back is running

hope this will help you ......

cheers

dEE

Edited by: Deep Kwatra on Nov 19, 2008 2:37 PM