Backup and restore statistics
Each successful backup and restore operation generates a single record in the db2diag.log file, which provides information on the performance of that operation. The log record is informational and is dumped at diagnostic error capture level (diaglevel) 3 (the default) and 4.
Examples
The log records for backup and restore statistics consist of a row for each backup and restore buffer manipulator (db2bm) EDU and a row for each backup and restore media controller (db2med) EDU:
2021-05-07-10.00.11.513920-420 E288031E1405 LEVEL: Info
PID : 8933 TID : 139912309368576 PROC : db2sysc
INSTANCE: zhiyang NODE : 000 DB : SAMPLE
APPHDL : 0-174 APPID: *LOCAL.zhiyang.210507170110
AUTHID : ZHIYANG HOSTNAME: db2i-zhiyangpan-hgy95-x86
EDUID : 418 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, database utilities, sqluxLogDataStats, probe:2051
MESSAGE : Performance statistics
DATA #1 : String, 884 bytes
Parallelism = 2
Number of buffers = 4
Buffer size = 16781312 (4097 4kB pages)
BM# Total I/O MsgQ WaitQ Buffers kBytes
--- -------- -------- -------- -------- -------- --------
000 9.28 8.87 0.00 0.27 6 98328
001 7.56 7.19 0.00 0.37 7 98356
--- -------- -------- -------- -------- -------- --------
TOT - - - - 13 196684
MC# Total I/O MsgQ WaitQ Buffers kBytes
--- -------- -------- -------- -------- -------- --------
000 7.21 0.07 7.08 0.04 14 196688
--- -------- -------- -------- -------- -------- --------
TOT - - - - 14 196688- BM
- The db2bm EDU ID
- Total
- Length of time that each EDU existed
- I/O
- The time spent running read or write input/output (I/O) operations, to or from stable storage.
- MsgQ
- Time that was spent waiting for an I/O buffer
- WaitQ
- Time that was spent waiting for a state machine control message.
- Buffers
- Number of I/O buffers that were processed
- KBytes
- Quantity of data that was processed
- MC
- the db2med EDU ID
Examples
For compressed backups, the log record contains two additional columns for performance information about the compression operation:
2021-05-07-10.05.06.868138-420 E79550E1682 LEVEL: Info
PID : 10249 TID : 139725134358272 PROC : db2sysc
INSTANCE: zhiyang NODE : 000 DB : SAMPLE
APPHDL : 0-36 APPID: *LOCAL.zhiyang.210507170502
AUTHID : ZHIYANG HOSTNAME: db2i-zhiyangpan-hgy95-x86
EDUID : 127 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, database utilities, sqluxLogDataStats, probe:2051
MESSAGE : Performance statistics
DATA #1 : String, 1160 bytes
Parallelism = 3
Number of buffers = 6
Buffer size = 16781312 (4097 4kB pages)
Compr
BM# Total I/O Compr MsgQ WaitQ Buffers kBytes kBytes
--- -------- -------- -------- -------- -------- -------- -------- --------
000 7.35 5.10 2.16 0.00 0.03 3 116064 117266
001 7.33 0.01 0.00 0.00 7.27 2 208 220
002 7.33 0.00 0.00 0.00 7.29 1 384 384
--- -------- -------- -------- -------- -------- -------- -------- --------
TOT - - - - - 6 116656 117870
MC# Total I/O MsgQ WaitQ Buffers kBytes
--- -------- -------- -------- -------- -------- --------
000 7.41 0.05 7.29 0.01 7 81972
--- -------- -------- -------- -------- -------- --------
TOT - - - - 7 81972- Compr
- Time that was spent performing the compression operation
- Compr Bytes
- Quantity of uncompressed data that was compressed