470,826 Members | 1,898 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,826 developers. It's quick & easy.

querying backup process

I am new to DB2. The version we are using is 8.2.3

I have to query DB2 to find out all backups for a given database and take
following
information

Backup Date, Start Time, End TIme, Status
If failure, the error code.

I am working on a script of someone else.

The command used is db2 list history backup since YYMMDD for DBNAME.

And then I have to filter out the information from the output.

Is there a better way. Like some sort of system catalog tables where I can
query.

Thanks.
Oct 12 '06 #1
1 2408
Ian
Tambi Dude wrote:
I am new to DB2. The version we are using is 8.2.3

I have to query DB2 to find out all backups for a given database and
take following information

Backup Date, Start Time, End TIme, Status If failure, the error code.
I am working on a script of someone else.

The command used is db2 list history backup since YYMMDD for DBNAME.

And then I have to filter out the information from the output.

Is there a better way. Like some sort of system catalog tables where
I can query.
Yes, see the ADMIN_LIST_HISTORY table function that was introduced in
8.2. This gives you the ability to query this information with SQL.

Oct 13 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by TThai | last post: by
3 posts views Thread by bryja_klaudiusz[at]poczta[dot]fm | last post: by
6 posts views Thread by Uthuras | last post: by
1 post views Thread by Fabius | last post: by
1 post views Thread by | last post: by
3 posts views Thread by Brian McCullough | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.