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