DB2 statistics IFCID tracing detail report (BSTATDI)
The following figure shows a sample of the DB2 statistics IFCID tracing detail report (BSTATDI).
BSTATDI : DB2 STATISTICS IFCID DETAILS 12/02/04 09:59:00 PAGE 1
GROUP : DB2 STATISTICS IFCID TRACING DETAIL DB2 SUBSYSTEM: DECN 8.1
MEMBER: LOCATION: DECN
BEGIN RECORD: 09/17/04 09:56:36.50
END RECORD: 11/29/04 13:39:56.22
ELAPSED TIME: 73 DAYS 73 03:43:19 Statistics invocation reason: BY COMMAND
IFC DEST WRITTEN NOT WRTN BUF OVER NOT ACCP WRT FAIL IFC RECORD TYPE WRITTEN NOT WRTN
-------- -------- -------- -------- -------- -------- ---------------- -------- --------
SMF 14724 0 0 0 0 SYSTEM RELATED 7274 3558
GTF 0 0 0 0 0 DATABASE RELATED 7274 3558
OP1 6305 921 0 921 0 ACCOUNTING 1279 4980
OP2 5088 166 0 166 0 START TRACE 676 255
OP3 0 0 0 0 0 STOP TRACE 430 378
OP4 0 0 0 0 0 SYSTEM PARMS 2743 3698
OP5 54 561 0 561 0 SYS PARMS-BPOOL 5906 3393
OP6 387 32421417 0 46633 0 AUDIT 0 7991
OP7 477 32421060 0 46274 0
OP8 955 43 0 43 0 TOTAL 25582 27811
RES 0 0 0 0 0
TOTAL 27990 64844168 0 94598 0
BSTATDI : DB2 STATISTICS IFCID DETAILS 12/02/04 09:59:00 PAGE 2
GROUP : DB2 STATISTICS IFCID TRACING DETAIL DB2 SUBSYSTEM: DECN 8.1
MEMBER: LOCATION: DECN
BEGIN RECORD: 09/17/04 09:56:36.50
END RECORD: 11/29/04 13:39:56.22
ELAPSED TIME: 73 DAYS 73 03:43:19 Statistics invocation reason: BY COMMAND
IFCID WRITTEN NOT WRITTEN NOT WANTED BUFFER NAV COLLECT FAIL
----- -------- ----------- ---------- ---------- ------------
1 7331 3564 0 0 0
2 7331 3564 0 0 0
3 1282 4981 0 0 0
4 683 257 0 0 0
5 434 380 0 0 0
106 2789 3706 0 0 0
140 0 468 0 0 0
141 0 113 0 0 0
142 0 0 0 0 0
143 0 3628 0 0 0
144 0 3782 0 0 0
145 0 0 0 0 0
146 0 0 0 0 0
199 0 36 0 0 0
202 5959 3399 0 0 0
230 0 0 0 0 0
GROUP : DB2 STATISTICS IFCID TRACING DETAIL DB2 SUBSYSTEM: DECN 8.1
MEMBER: LOCATION: DECN
BEGIN RECORD: 09/17/04 09:56:36.50
END RECORD: 11/29/04 13:39:56.22
ELAPSED TIME: 73 DAYS 73 03:43:19 Statistics invocation reason: BY COMMAND
IFC DEST WRITTEN NOT WRTN BUF OVER NOT ACCP WRT FAIL IFC RECORD TYPE WRITTEN NOT WRTN
-------- -------- -------- -------- -------- -------- ---------------- -------- --------
SMF 14724 0 0 0 0 SYSTEM RELATED 7274 3558
GTF 0 0 0 0 0 DATABASE RELATED 7274 3558
OP1 6305 921 0 921 0 ACCOUNTING 1279 4980
OP2 5088 166 0 166 0 START TRACE 676 255
OP3 0 0 0 0 0 STOP TRACE 430 378
OP4 0 0 0 0 0 SYSTEM PARMS 2743 3698
OP5 54 561 0 561 0 SYS PARMS-BPOOL 5906 3393
OP6 387 32421417 0 46633 0 AUDIT 0 7991
OP7 477 32421060 0 46274 0
OP8 955 43 0 43 0 TOTAL 25582 27811
RES 0 0 0 0 0
TOTAL 27990 64844168 0 94598 0
BSTATDI : DB2 STATISTICS IFCID DETAILS 12/02/04 09:59:00 PAGE 2
GROUP : DB2 STATISTICS IFCID TRACING DETAIL DB2 SUBSYSTEM: DECN 8.1
MEMBER: LOCATION: DECN
BEGIN RECORD: 09/17/04 09:56:36.50
END RECORD: 11/29/04 13:39:56.22
ELAPSED TIME: 73 DAYS 73 03:43:19 Statistics invocation reason: BY COMMAND
IFCID WRITTEN NOT WRITTEN NOT WANTED BUFFER NAV COLLECT FAIL
----- -------- ----------- ---------- ---------- ------------
1 7331 3564 0 0 0
2 7331 3564 0 0 0
3 1282 4981 0 0 0
4 683 257 0 0 0
5 434 380 0 0 0
106 2789 3706 0 0 0
140 0 468 0 0 0
141 0 113 0 0 0
142 0 0 0 0 0
143 0 3628 0 0 0
144 0 3782 0 0 0
145 0 0 0 0 0
146 0 0 0 0 0
199 0 36 0 0 0
202 5959 3399 0 0 0
230 0 0 0 0 0
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*