|
|
|
You can also display the DB2View panel directly from the Interactive Analysis panel by selecting Option 10.
CA MAT--------------------- Interactive Analysis --------------------------- OPTION ===> Enter option to analyze the monitored job: Profile: PROFT9 Options: NORMAL CA MAT Monitor Information Subsystem Details ------------------------------------------- ------------------------------ 0 OverView - Monitor session information 10 DB2 - View all SQL 1 TaskView - Activity by task 11 IMS - IMS Transactions 2 DelayView - Program delays 12 JVM - Java Virtual Machine 3 CodeView - Program activity 13 WAS - WebSphere Trans. 4 TimeView - Samples by time 14 CIC - CICS Summary Stats 5 DataView - Dataset information 15 IDMS - CA IDMS Activity 6 TranView - Activity by transaction 16 DCM - CA-Datacom Activity 7 ModView - Module layout 17 IDL - CA-Ideal Activity 8 PoolView - Buffer pools 18 ADA - Adabas Activity 9 USSView - Unix System Services 19 NAT - Natural Activity ACTIVE - switch mode to ACTIVE WAIT - switch mode to WAIT NORMAL - switch mode to NORMAL ALL - switch mode to ALL Press END to exit analysis
The DB2View panel displays.
CA MAT -------------------- DB2View --------------------------- Row 25 of 50 COMMAND ===> SCROLL ===> CSR Primary Commands: ADDHelp, SQL all/sampled, SEQ (sort) Profile: DB2STPRO Options: NORMAL Line commands: S - Select SQL E - Explain SQL SQL: All SD - Show Declare I - Explain Information Sort: Sequence C - Code Details D - Statement Detail DB2 SSID: DB9G DB2 Rel: 9.1.0 DBRM or D Data Call Total LC Package S From Stmt Num Type Count Total CPU CPU-P-Call Resp Time ________ _ B___ ________ ________ _________ __________ __________ __________ >------------------------------------------------------------------------------ __ D91@PROG S B 201 SELECT 1 1.582823 1.582823 2.285674 __ D91@PROG S B 232 SELECT 1 1.363766 1.363766 2.285488 __ D91@PROG S B 263 SELECT 1 1.302925 1.302925 2.143666 __ D91@PROG S B 388 SELECT 1 0.006287 0.006287 0.076504 __ D91@PROG S B 460 OPEN 1 9.063884 9.063884 13.145094 __ D91@PROG S B 469 FETCH 76924 2.575384 0.000033 2.934821 __ D91@PROG S B 538 OPEN 1 1.403580 1.403580 2.040191 __ D91@PROG S B 580 OPEN 1 2.968967 2.968967 4.958089 __ D91@PROG S B 589 FETCH 1 0.000356 0.000356 0.459179 __ D91@PROG S B 623 OPEN 1 0.002196 0.002196 0.015715 __ D91@PROG S B 632 FETCH 1000001 30.286899 0.000030 37.179097
CA MAT -------------------- DB2View --------------------------- Row 25 of 50 COMMAND ===> SCROLL ===> CSR Primary Commands: ADDHelp, SQL all/sampled, SEQ (sort) Profile: DB2STPRO Options: NORMAL Line commands: S - Select SQL E - Explain SQL SQL: All SD - Show Declare I - Explain Information Sort: Sequence C - Code Details D - Statement Detail DB2 SSID: DB9G DB2 Rel: 9.1.0 DBRM or D Data Average Declare Total LC Package S From Stmt Num Type Resp Time Stmt Samps Actv% Wait% ________ _ B___ ________ ________ __________ _______ ______ ______ ______ <>----------------------------------------------------------------------------- __ D91@PROG S B 201 SELECT 2.285674 NA 101 0.83 0.14 __ D91@PROG S B 232 SELECT 2.285488 NA 100 0.81 0.15 __ D91@PROG S B 263 SELECT 2.143666 NA 89 0.71 0.15 __ D91@PROG S B 388 SELECT 0.076504 NA 3 0.01 0.02 __ D91@PROG S B 460 OPEN 13.145094 100826 591 4.49 1.22 __ D91@PROG S B 469 FETCH 0.000038 100826 243 2.27 0.08 __ D91@PROG S B 538 OPEN 2.040191 100862 87 0.75 0.09 __ D91@PROG S B 580 OPEN 4.958089 100881 220 1.57 0.56 __ D91@PROG S B 589 FETCH 0.459179 100881 22 0.00 0.21 __ D91@PROG S B 623 OPEN 0.015715 100900 1 0.00 0.01 __ D91@PROG S B 632 FETCH 0.000037 100900 3057 27.98 1.57
CA MAT -------------------- DB2View --------------------------- Row 25 of 50 COMMAND ===> SCROLL ===> CSR Primary Commands: ADDHelp, SQL all/sampled, SEQ (sort) Profile: DB2STPRO Options: NORMAL Line commands: S - Select SQL E - Explain SQL SQL: All SD - Show Declare I - Explain Information Sort: Sequence C - Code Details D - Statement Detail DB2 SSID: DB9G DB2 Rel: 9.1.0 DBRM or D Data LC Package S From Stmt Num Type Totl% ________ _ B___ ________ ________ ______ <------------------------------------------------------------------------------ __ D91@PROG S B 201 SELECT 0.98 __ D91@PROG S B 232 SELECT 0.97 __ D91@PROG S B 263 SELECT 0.86 __ D91@PROG S B 388 SELECT 0.03 __ D91@PROG S B 460 OPEN 5.71 __ D91@PROG S B 469 FETCH 2.35 __ D91@PROG S B 538 OPEN 0.84 __ D91@PROG S B 580 OPEN 2.13 __ D91@PROG S B 589 FETCH 0.21 __ D91@PROG S B 623 OPEN 0.01 __ D91@PROG S B 632 FETCH 29.54
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |