By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,564 Members | 1,081 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,564 IT Pros & Developers. It's quick & easy.

List History Backup

P: n/a
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..........

Jul 21 '06 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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..........
Jul 21 '06 #2

P: n/a

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

Jul 21 '06 #3

P: n/a
Along similar lines,
The following page would give us information abt the automatic / manual
backup restore process.
http://publib.boulder.ibm.com/infoce...n/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/infoce...e/r0001993.htm

Gladiator wrote:
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
Jul 21 '06 #4

P: n/a
No I could not find it in the Command Reference Manual. A "db2 list history
backup status" search on Google gave:
Entry Status
a..
a.. D - Deleted (for future use)
b.. E - Expired
c.. I - Inactive
d.. N - Not yet committed
e.. Y - Committed or active
No "A"
Goog luck, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Gladiator" <vk************@gmail.coma écrit dans le message de news:
11**********************@i3g2000cwc.googlegroups.c om...
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..........
Jul 22 '06 #5

P: n/a
I obviously am not reading the proper Command Ref.
Peri, where did you get the "A" info. I could not find it.
Thanks, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Peri" <pe*******@gmail.coma écrit dans le message de news:
11*********************@i42g2000cwa.googlegroups.c om...
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..........
Jul 22 '06 #6

P: n/a
Apologies to all.
I should have read the "entire" thread before doing these ans. and ques.
Sorry, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Peri" <pe*******@gmail.coma écrit dans le message de news:
11**********************@i42g2000cwa.googlegroups. com...
Along similar lines,
The following page would give us information abt the automatic / manual
backup restore process.
http://publib.boulder.ibm.com/infoce...n/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/infoce...e/r0001993.htm

Gladiator wrote:
>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
Jul 22 '06 #7

This discussion thread is closed

Replies have been disabled for this discussion.