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