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

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

Sathyaram

Santhosh wrote:

Dear Sir

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

Regards
Santhosh

Sathyaram Sannasi wrote:

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:

In article <1153359241.103471.308100 (AT) b28g2000cwb (DOT) googlegroups.com>,
kollam68 (AT) yahoo (DOT) com says...
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

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 <1153378795.802718.14800 (AT) m73g2000cwd (DOT) googlegroups.com>,
kollam68 (AT) yahoo (DOT) com says...
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.