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
List History Backup
Post new topic   Reply to topic Page 1 of 1 [4 Posts] View previous topic :: View next topic
Author Message
Shyam Peri
*nix forums beginner


Joined: 11 Mar 2005
Posts: 31

PostPosted: Fri Jul 21, 2006 11:52 am    Post subject: Re: List History Backup Reply with quote
Along similar lines,
The following page would give us information abt the automatic / manual
backup restore process.
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/t0006070.htm

Status flag would be used by db2 to identify/update the status of the
backup images at the automatic incremental restore process. Thus, build
the chain of backup images.

For example:
Flag I: Images that no longer belong to active log chain.
Flag D: Images that are no longer available for recovery should be
marked as having been deleted
And we can do this thru db2 update history utiltity.

Further information abt the same can be found at
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/r0001993.htm



Gladiator wrote:
Quote:
Peri wrote:
Kamal,
The status field get's mapped to oStatus a.k.a entry status field in
the hist entry data structure & the following classification would
provide more information

Entry status -> Desc
A -> action
D -> deleted
E -> expired
I -> inactive
N -> not yet committed
Y -> committed / active.





Gladiator wrote:
Hai every one...

I was trying List history backup
cmd.......... the output i got is



List History File for first

Number of matching file entries = 12


Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------
--------------
B D 20060630150920001 F D S0000000.LOG S0000000.LOG

----------------------------------------------------------------------------
Contains 3 tablespace(s):

00001 SYSCATSPACE
00002 USERSPACE1
00003 SYSTOOLSPACE

----------------------------------------------------------------------------
Comment: DB2 BACKUP FIRST OFFLINE
Start Time: 20060630150920
End Time: 20060630151025
" Status: A "

----------------------------------------------------------------------------
EID: 3 Location: c:\backups\FIRST.0\DB2\NODE0000\CATN0000\20060630




can anyone tell me what is tht Status A mean............... pls let me
the other options tht are available .................


Regards
Kamal..........



Thanks peri....

Now i deleted the backup file and when i give List History backup cmd
it is still showing A ..
Can u tell me wht happened.........
Regards
Kamal
Back to top
Gladiator
*nix forums beginner


Joined: 09 May 2005
Posts: 34

PostPosted: Fri Jul 21, 2006 10:41 am    Post subject: Re: List History Backup Reply with quote
Peri wrote:
Quote:
Kamal,
The status field get's mapped to oStatus a.k.a entry status field in
the hist entry data structure & the following classification would
provide more information

Entry status -> Desc
A -> action
D -> deleted
E -> expired
I -> inactive
N -> not yet committed
Y -> committed / active.





Gladiator wrote:
Hai every one...

I was trying List history backup
cmd.......... the output i got is



List History File for first

Number of matching file entries = 12


Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------
--------------
B D 20060630150920001 F D S0000000.LOG S0000000.LOG

----------------------------------------------------------------------------
Contains 3 tablespace(s):

00001 SYSCATSPACE
00002 USERSPACE1
00003 SYSTOOLSPACE

----------------------------------------------------------------------------
Comment: DB2 BACKUP FIRST OFFLINE
Start Time: 20060630150920
End Time: 20060630151025
" Status: A "

----------------------------------------------------------------------------
EID: 3 Location: c:\backups\FIRST.0\DB2\NODE0000\CATN0000\20060630




can anyone tell me what is tht Status A mean............... pls let me
the other options tht are available .................


Regards
Kamal..........



Thanks peri....

Now i deleted the backup file and when i give List History backup cmd
it is still showing A ..
Can u tell me wht happened.........
Regards
Kamal
Back to top
Shyam Peri
*nix forums beginner


Joined: 11 Mar 2005
Posts: 31

PostPosted: Fri Jul 21, 2006 10:31 am    Post subject: Re: List History Backup Reply with quote
Kamal,
The status field get's mapped to oStatus a.k.a entry status field in
the hist entry data structure & the following classification would
provide more information

Entry status -> Desc
A -> action
D -> deleted
E -> expired
I -> inactive
N -> not yet committed
Y -> committed / active.





Gladiator wrote:
Quote:
Hai every one...

I was trying List history backup
cmd.......... the output i got is



List History File for first

Number of matching file entries = 12


Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------
--------------
B D 20060630150920001 F D S0000000.LOG S0000000.LOG

----------------------------------------------------------------------------
Contains 3 tablespace(s):

00001 SYSCATSPACE
00002 USERSPACE1
00003 SYSTOOLSPACE

----------------------------------------------------------------------------
Comment: DB2 BACKUP FIRST OFFLINE
Start Time: 20060630150920
End Time: 20060630151025
" Status: A "

----------------------------------------------------------------------------
EID: 3 Location: c:\backups\FIRST.0\DB2\NODE0000\CATN0000\20060630




can anyone tell me what is tht Status A mean............... pls let me
the other options tht are available .................


Regards
Kamal..........
Back to top
Gladiator
*nix forums beginner


Joined: 09 May 2005
Posts: 34

PostPosted: Fri Jul 21, 2006 8:21 am    Post subject: List History Backup Reply with quote
Hai every one...

I was trying List history backup
cmd.......... the output i got is



List History File for first

Number of matching file entries = 12


Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------
--------------
B D 20060630150920001 F D S0000000.LOG S0000000.LOG

----------------------------------------------------------------------------
Contains 3 tablespace(s):

00001 SYSCATSPACE
00002 USERSPACE1
00003 SYSTOOLSPACE

----------------------------------------------------------------------------
Comment: DB2 BACKUP FIRST OFFLINE
Start Time: 20060630150920
End Time: 20060630151025
" Status: A "

----------------------------------------------------------------------------
EID: 3 Location: c:\backups\FIRST.0\DB2\NODE0000\CATN0000\20060630




can anyone tell me what is tht Status A mean............... pls let me
the other options tht are available .................


Regards
Kamal..........
Back to top
Google
Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [4 Posts] View previous topic :: View next topic
The time now is Thu Dec 04, 2008 7:57 am | 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 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
No new posts FAQ 4.41 How can I remove duplicate elements from a list ... PerlFAQ Server Perl 0 Fri Jul 21, 2006 1:03 am

Internet Advertising | MPAA | Buy Anything On eBay | Property in Spain | Credit Check
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.1682s ][ Queries: 20 (0.0749s) ][ GZIP on - Debug on ]