여러 가지 방법이 존재하겠지만,
db2diag.log에서 Backup Complete 메시지와 함께 정확한 사이즈가 찍혀있다.
위의 예시에서 16진수 0000 09DD D4D4 7000 를 10진수로 변환하면
Backup image의 byte는 10,848,363,114,496 임을 알 수 있다.
db2diag.log에서 Backup Complete 메시지와 함께 정확한 사이즈가 찍혀있다.
2009-05-15-22.46.53.108696+540 I790856A473 LEVEL: Warning
PID : 1991526 TID : 1 PROC : db2agent (SAMPLE) 0
INSTANCE: instance NODE : 000 DB : SAMPLE
APPHDL : 0-1823 APPID: *LOCAL.dbpainst.090515090122
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:128
MESSAGE : Estimated size of backup in bytes:
DATA #1 : Hexdump, 8 bytes
0x0FFFFFFFFFFEDB78 : 0000 09DD 446C 9000 ....Dl..
2009-05-15-22.46.53.110938+540 I791330A470 LEVEL: Warning
PID : 1991526 TID : 1 PROC : db2agent (SAMPLE) 0
INSTANCE: instance NODE : 000 DB : SAMPLE
APPHDL : 0-1823 APPID: *LOCAL.dbpainst.090515090122
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:128
MESSAGE : Actual size of backup in bytes:
DATA #1 : Hexdump, 8 bytes
0x0FFFFFFFFFFEDB80 : 0000 09DD D4D4 7000 ......p.
2009-05-15-22.46.53.111391+540 I791801A355 LEVEL: Warning
PID : 1991526 TID : 1 PROC : db2agent (SAMPLE) 0
INSTANCE: instance NODE : 000 DB : SAMPLE
APPHDL : 0-1823 APPID: *LOCAL.dbpainst.090515090122
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:130
MESSAGE : Backup Complete.
PID : 1991526 TID : 1 PROC : db2agent (SAMPLE) 0
INSTANCE: instance NODE : 000 DB : SAMPLE
APPHDL : 0-1823 APPID: *LOCAL.dbpainst.090515090122
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:128
MESSAGE : Estimated size of backup in bytes:
DATA #1 : Hexdump, 8 bytes
0x0FFFFFFFFFFEDB78 : 0000 09DD 446C 9000 ....Dl..
2009-05-15-22.46.53.110938+540 I791330A470 LEVEL: Warning
PID : 1991526 TID : 1 PROC : db2agent (SAMPLE) 0
INSTANCE: instance NODE : 000 DB : SAMPLE
APPHDL : 0-1823 APPID: *LOCAL.dbpainst.090515090122
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:128
MESSAGE : Actual size of backup in bytes:
DATA #1 : Hexdump, 8 bytes
0x0FFFFFFFFFFEDB80 : 0000 09DD D4D4 7000 ......p.
2009-05-15-22.46.53.111391+540 I791801A355 LEVEL: Warning
PID : 1991526 TID : 1 PROC : db2agent (SAMPLE) 0
INSTANCE: instance NODE : 000 DB : SAMPLE
APPHDL : 0-1823 APPID: *LOCAL.dbpainst.090515090122
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:130
MESSAGE : Backup Complete.
위의 예시에서 16진수 0000 09DD D4D4 7000 를 10진수로 변환하면
Backup image의 byte는 10,848,363,114,496 임을 알 수 있다.