DB2 ZOS Accounting Report
Que signifie la colonne "SQLSTMT" dans cet Accounting Report ?
Code : Sélectionner tout - Visualiser dans une fenêtre à part
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28------------------------------------------------------------------------------------------------------- !PROGRAM NAME TYPE #OCCURS SQLSTMT CL7 ELAP.TIME CL7 CPU TIME CL8 SUSP.TIME CL8 SUSP! !SYSLN300 PACKAGE 2 4.50 0.004132 0.002592 0.001145 1.50! !SYSSTAT PACKAGE 16 1.00 0.000283 0.000218 0.000547 0.38! !FASE107S PACKAGE 3 84.00 0.167054 0.053952 0.099473 46.33! !SQL00010 PACKAGE 1 1.50 0.007164 0.001968 0.003572 2.50! !SQL11334 PACKAGE 1 1.50 0.024797 0.006042 0.017391 6.00! !SQL13998 PACKAGE 6 1.50 0.000564 0.000602 0.000000 0.00! !SQL16179 PACKAGE 7 1.50 0.002022 0.001045 0.000664 0.28! !SQL21399 PACKAGE 6 1.50 0.000865 0.000793 0.000042 0.07! !SQL45126 PACKAGE 1 1.50 0.001755 0.000602 0.001004 1.50! !SQL46328 PACKAGE 2 1.50 0.011191 0.004639 0.004384 3.75! !SQL50025 PACKAGE 4 1.50 0.002484 0.001216 0.001406 1.60! !SQL56010 PACKAGE 4 1.50 0.006020 0.002902 0.002014 2.00! !SQL58121 PACKAGE 1 1.50 0.008066 0.003622 0.003013 2.50! !SQL62855 PACKAGE 4 1.50 0.004015 0.001491 0.001060 1.20! !SQL73452 PACKAGE 1 1.50 0.020019 0.008256 0.009608 5.00! !SQL76272 PACKAGE 1 1.50 0.004651 0.001380 0.002242 2.50! !SQL77920 PACKAGE 2 1.50 0.001063 0.001124 0.000148 0.25! !SQL78527 PACKAGE 4 1.50 0.002472 0.001580 0.000408 0.30! !SQL84682 PACKAGE 1 1.50 0.067945 0.023853 0.039496 14.50! !SQL84915 PACKAGE 1 1.50 0.008232 0.003105 0.004077 3.50! !SQL87209 PACKAGE 2 1.50 0.001465 0.000663 0.000663 0.50! !SQL88732 PACKAGE 4 1.50 0.002714 0.001022 0.001244 0.50! !SQL94818 PACKAGE 1 1.50 0.035796 0.008080 0.027155 17.50! !SQL97430 PACKAGE 1 1.50 0.077552 0.019282 0.057151 60.00! -------------------------------------------------------------------------------------------------------
Répondre avec citation
Envoyé par SuperWaza
Partager