Skip to Content
0
Former Member
Jun 02, 2008 at 09:14 AM

DB2 and TDP/R3 log archive time mismatch

152 Views

Hello.

Im my databases im inspect strange situation with log archive time logging in DB2 history file and TDP backom utility log.

Log's are archived to TSM disk pool

In DB2 history for archiving log file S0001437.LOG are presented :

Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID

X D 20080602060857 1 O S0001437.LOG C0000000

Comment: /db2/NBP/tdp_r3/vendor.env

Start Time: 20080602060857

End Time: 20080602114031

Status: A

EID: 1799 Location: /usr/tivoli/tsm/tdp_r3/db264/libtdpdb264.a

In backom log file for this operation are presented :

BKI8800I: The command is: ARCHIVE

BKI8801I: Time: 2008-06-02-11.39.48.0549 --- PID: 499748

BKI8807I: Archive log file 'S0001437.LOG' of chain 'C0000000'.

BKI8803I: The DB2 UDB image size for this session is about '63.992 MB'.

BKI2017I: Blocksize is set to 131072 bytes

BKI5016I: Time: 06/02/08 11:39:52 New TSM session created: MGMNT-CLASS: MGCAR_COM1, TSM-Server: INFRA_ODD, type: SIMPLE

BKI5016I: Time: 06/02/08 11:39:53 New TSM session created: MGMNT-CLASS: MGCAR_COM2, TSM-Server: INFRA_ODD, type: SIMPLE

BKI0057I: Time: 06/02/08 11:40:29 Object: /:db2nbp.NBP.NODE0000.20080602113948.C0000000_S0001437.LOG with: 63.992 MB saved with description NBP___A0FGYR4I5D_INFRA_ODD@MGCAR_COM2#525538 2.COPY 00243.

BKI0057I: Time: 06/02/08 11:40:29 Object: /:db2nbp.NBP.NODE0000.20080602113948.C0000000_S0001437.LOG with: 63.992 MB saved with description NBP___A0FGYR4I5D_INFRA_ODD@MGCAR_COM1#525537 1.COPY 00243.

So. DB2 think what log file archiving taken approximately 5 hours and 32 minutes !!??

But backom think what this taken approximately 40 sec

Why it so diference ? And who are rigth DB2 or backom ?

Big thank's

With best regards, Dmitry