List History Backup

[Gladiator]

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..........

[Peri]

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..........

[Gladiator]

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

[Peri]

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

[Pierre Saint-Jacques]

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..........

[Pierre Saint-Jacques]

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..........

[Pierre Saint-Jacques]

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