List History Backup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gladiator - 21 Jul 2006 09:21 GMT

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

Reply to this Message

Peri - 21 Jul 2006 11:31 GMT

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.

> Hai every one...
>
[quoted text clipped - 31 lines]
> Regards
> Kamal..........

Reply to this Message

Gladiator - 21 Jul 2006 11:41 GMT

> Kamal,
> The status field get's mapped to oStatus a.k.a entry status field in
[quoted text clipped - 44 lines]
> > 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

Reply to this Message

Peri - 21 Jul 2006 12:52 GMT

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

> > Kamal,
> > The status field get's mapped to oStatus a.k.a entry status field in
[quoted text clipped - 52 lines]
> Regards
> Kamal

Reply to this Message

Pierre Saint-Jacques - 22 Jul 2006 05:32 GMT

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

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

> Along similar lines,
> The following page would give us information abt the automatic / manual
[quoted text clipped - 72 lines]
>> Regards
>> Kamal

Reply to this Message

Pierre Saint-Jacques - 22 Jul 2006 05:29 GMT

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

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

> Kamal,
> The status field get's mapped to oStatus a.k.a entry status field in
[quoted text clipped - 44 lines]
>> Regards
>> Kamal..........

Reply to this Message

Pierre Saint-Jacques - 22 Jul 2006 05:27 GMT

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.

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

> Hai every one...
>
[quoted text clipped - 31 lines]
> Regards
> Kamal..........

Reply to this Message