Db2 backup List

[Santhosh]

Dear All

Can I know how can I get the last backup status for a db2 database from
the system tables..? Any SQl statement to get that details??

Regards
Santhosh

[Sathyaram Sannasi]

list history command
or
if you are on V8 FP 9 and above, admin_list_hist table function

Sathyaram

Santhosh wrote:

Dear All

Can I know how can I get the last backup status for a db2 database from
the system tables..? Any SQl statement to get that details??

Regards
Santhosh

[edeva001]

there is a table is syscat schema
look into table names u will find it

Kumar

[Santhosh]

Dear Sir

what about in FP 6? I have a installation with FP6..

Regards
Santhosh

Sathyaram Sannasi wrote:

list history command
or
if you are on V8 FP 9 and above, admin_list_hist table function

Sathyaram

Santhosh wrote:

Dear All

Can I know how can I get the last backup status for a db2 database from
the system tables..? Any SQl statement to get that details??

Regards
Santhosh

[Santhosh]

Dear All

Any help from anyone? I tried , could't able to findout SQL statements
to get the back details from FP <9

Pl help me

Regards
Santhosh
=========================
Santhosh wrote:

Dear Sir

what about in FP 6? I have a installation with FP6..

Regards
Santhosh

Sathyaram Sannasi wrote:

list history command
or
if you are on V8 FP 9 and above, admin_list_hist table function

Sathyaram

Santhosh wrote:

Dear All
>
Can I know how can I get the last backup status for a db2 database from
the system tables..? Any SQl statement to get that details??
>
Regards
Santhosh

[Gert van der Kooij]

In article <11**********************@b28g2000cwb.googlegroups .com>,
ko******@yahoo.com says...

Dear All

Any help from anyone? I tried , could't able to findout SQL statements
to get the back details from FP <9

You can't. You need to open a DB2 Command Window and issue the 'db2 list
history' command or write a C program calling the needed API
(db2HistoryOpenScan etc.).
There's a sample in the SQLLIB\samples\C\dbhistfile.sqc

[Santhosh]

Dear Gert sir

Thanks for the reply.. But could't able to see the dbhistfile..

My plan is to write a java program that runs from my desktop, connect
to all our Db2 instances and then collect the backup information from
all instances. Then email to our mail box. If I have the SQL stmt, I
can do it in java.. That is why i ask this qn

Regards
Santhosh

Gert van der Kooij wrote:

In article <11**********************@b28g2000cwb.googlegroups .com>,
ko******@yahoo.com says...

Dear All

Any help from anyone? I tried , could't able to findout SQL statements
to get the back details from FP <9

You can't. You need to open a DB2 Command Window and issue the 'db2 list
history' command or write a C program calling the needed API
(db2HistoryOpenScan etc.).
There's a sample in the SQLLIB\samples\C\dbhistfile.sqc

[Gert van der Kooij]

In article <11*********************@m73g2000cwd.googlegroups. com>,
ko******@yahoo.com says...

Dear Gert sir

Thanks for the reply.. But could't able to see the dbhistfile..

My plan is to write a java program that runs from my desktop, connect
to all our Db2 instances and then collect the backup information from
all instances. Then email to our mail box. If I have the SQL stmt, I
can do it in java.. That is why i ask this qn

What do you mean by "could't able to see the dbhistfile" ?
If you tried the 'list history' command please show the used commands
and returned error messages.