142 Storage Management with DB2 for OS/390
Figure 57. DB2 PM Accounting, Class 1 and Class 2 Sections
Figure 58. DB2 PM Accounting, SQL DML Section
The DB2 PM accounting report contains two more sections with SQL statements.
One of these (SQL DCL)contains interesting information for this study. This
section is shown in Figure 59 on page 143:
LOne SET DEGREE statement
MOne CONNECT of type 2
The SET DEGREE statement means that the user decided to enable parallelism
for this query.This can be confirmed by examining the parallel query section of
the DB2P Maccounting repor tin Figure 60 on page 143. A parallel degree of 5 (N
in Figure 60)was established. One parallel group executed (Oin Figure 60) and it
executedwith a degree of 5 (Pin Figure 60).
The other DCL statement( Min Figure 59on page 143) is a CONNECT of type 2.
This could mean that distributed data was accessed. To conf irm this, the DDF
requester information in the accounting report is checked, this section is not
present in the report. Statistics also collects DDF information, this is shown in
Figure 61 on page 144. No information is shown. This means that the trace
classes to collect DDF information were not started, or there was no DDF activity.
TIMES/EVENTS APPL (CLASS 1) DB2 (CLASS 2)
------------ -------------- --------------
ELAPSED TIME 37:41.001054 37:40.386069 A
CPU TIME 1:06:21.580844 1:06:21.549125 B
TCB 14:02.087183 14:02.055513 C
TCB-STPROC 0.000000 0.000000
PAR.TASKS 52:19.493661 52:19.493612 D
SUSPEND TIME N/A 30:55.990291 E
TCB N/A 3:48.273531 F
PAR.TASKS N/A 27:07.716760 G
NOT ACCOUNT. N/A 19:50.057025 H
DB2 ENT/EXIT N/A 217
EN/EX-STPROC N/A 0
DCAPT.DESCR. N/A N/A
LOG EXTRACT. N/A N/A
SQL DML TOTAL
-------- --------
SELECT 0
INSERT 0
UPDATE 0
DELETE 0
DESCRIBE 0
DESC.TBL 0
PREPARE 1 J
OPEN 1
FETCH 101 K
CLOSE 1
DML-ALL 104