niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » IBM DB2
Db2 backup List
Post new topic   Reply to topic Page 1 of 1 [7 Posts] View previous topic :: View next topic
Author Message
Santhosh
*nix forums beginner


Joined: 01 Dec 2005
Posts: 17

PostPosted: Tue Jul 18, 2006 8:17 am    Post subject: Db2 backup List Reply with quote
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
Back to top
s.sathyaram@googlemail.co
*nix forums beginner


Joined: 20 Feb 2006
Posts: 13

PostPosted: Tue Jul 18, 2006 10:07 am    Post subject: Re: Db2 backup List Reply with quote
list history command
or
if you are on V8 FP 9 and above, admin_list_hist table function

Sathyaram

Santhosh wrote:
Quote:
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
Back to top
Santhosh
*nix forums beginner


Joined: 01 Dec 2005
Posts: 17

PostPosted: Tue Jul 18, 2006 11:17 pm    Post subject: Re: Db2 backup List Reply with quote
Dear Sir

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

Regards
Santhosh

Sathyaram Sannasi wrote:
Quote:
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
Back to top
Santhosh
*nix forums beginner


Joined: 01 Dec 2005
Posts: 17

PostPosted: Thu Jul 20, 2006 1:34 am    Post subject: Re: Db2 backup List Reply with quote
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:
Quote:
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
Back to top
Gert van der Kooij
*nix forums Guru Wannabe


Joined: 27 May 2005
Posts: 267

PostPosted: Thu Jul 20, 2006 1:56 am    Post subject: Re: Db2 backup List Reply with quote
In article <1153359241.103471.308100@b28g2000cwb.googlegroups.com>,
kollam68@yahoo.com says...
Quote:
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
Back to top
Santhosh
*nix forums beginner


Joined: 01 Dec 2005
Posts: 17

PostPosted: Thu Jul 20, 2006 6:59 am    Post subject: Re: Db2 backup List Reply with quote
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:
Quote:
In article <1153359241.103471.308100@b28g2000cwb.googlegroups.com>,
kollam68@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
Back to top
Gert van der Kooij
*nix forums Guru Wannabe


Joined: 27 May 2005
Posts: 267

PostPosted: Thu Jul 20, 2006 8:37 am    Post subject: Re: Db2 backup List Reply with quote
In article <1153378795.802718.14800@m73g2000cwd.googlegroups.com>,
kollam68@yahoo.com says...
Quote:
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.
Back to top
Google
Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [7 Posts] View previous topic :: View next topic
The time now is Fri Nov 21, 2008 7:13 pm | All times are GMT
navigation Forum index » Databases » IBM DB2
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Backup Jan Dinger Debian 4 Fri Jul 21, 2006 8:50 am
No new posts List History Backup Gladiator IBM DB2 3 Fri Jul 21, 2006 8:21 am
No new posts Backup failure notification for 10g EM Console (not grid) NetComrade Server 0 Fri Jul 21, 2006 6:36 am
No new posts Testing my Black List Marc Perkel Exim 6 Fri Jul 21, 2006 5:57 am
No new posts Your Opinion about how to set up a DNS list Marc Perkel Exim 0 Fri Jul 21, 2006 2:18 am

Home Insurance | Mortgages | Debt Consolidation | Loans | Computers 2007
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group

[ Time: 0.1607s ][ Queries: 16 (0.0754s) ][ GZIP on - Debug on ]