|
|
|
The DML Delays panel enables you to pinpoint bottlenecks due to requests from Data Manipulation Language (DML) statements.
On this panel, you can see the current or most recent DML statement in effect when CA Mainframe Application Tuner detected CA IDMS waiting for resources.
You can access this panel by using the DML command from the CA IDMS Delays panel.
CA MAT ------------------------- DML Delays -------------- Row 1 to 19 of 39 COMMAND ===> SCROLL ===> HALF Line commands: D - Detail Profile: IDMS8 Options: NORMAL CV number: 160 IDMS Release: 16.0 Mode: Module LC TaskCode Module Offset DML SEQ Totl% Visual ________ ________ ________ ________ _____ __________ >------------------------------------------------------------------- __ OPER RHDCOPER 000005A0 00000000 45.56 =========> __ RHDCNP3S RHDCNP3S 00000000 00000000 16.07 ==> __ RHDCNP3S RHDCNP3S 00000000 00000000 15.43 ==> __ COBWALK DCRDISCV 00000C9E 00000012 9.87 => __ RHDCNP3S RHDCNP3S 00000000 00000000 6.35 > __ RHDCNP3S RHDCNP3S 00000000 00000000 1.65 __ COBWALK DCRDISCV 000009DC 00000008 1.09 __ OPER RHDCOPER 000004FA 00000000 1.03 __ GO4AWALK TRIDMSCV 00000C50 00000004 0.91 __ ASMWALK READDBCR 000006D6 00000004 0.74 __ COBWALK DCRDISCV 00000BFC 00000011 0.46 __ IDD IDMSDDDC 00000538 00607030 0.22 __ COBWALK DCRDISCV 00000E20 00000012 0.14 __ COBWALK DCRDISCV 00000F20 00000012 0.10 __ COBWALK DCRDISCV 00000E9E 00000012 0.06 __ ASMWALK READDBCR 000002BC 00000004 0.04 __ ASMWALK READDBCR 0000040C 00000009 0.03 __ ASMWALK READDBCR 00000460 00000010 0.03 __ ASMWALK READDBCR 0000025A 00000013 0.02 ------------------------ Totals ------------------------------------ 100.0
A description for each field in the DML Delays panel follows.
Name of the profile that you specified when you created the monitor definition.
Type of analysis in effect: NORMAL, ALL, ACTIVE, or WAIT.
An asterisk (*) following the value indicates that tasks or transactions have been selected for analysis. Place the cursor on the Options field value and press Enter to display a pop-up panel listing the selected tasks/transactions.
Unique name that identifies a task to CA IDMS DC/UCF.
The user types the task code in response to the DC/UCF system prompt. Task codes are defined at system generation or by using a DCMT VARY DYNAMIC TASK command.
Name of the program requesting CA IDMS DB/DC services, when known, or the name of the program invoked by specifying the task code.
Relative address within the module to which control will be returned upon completion of the CA IDMS DB/DC service request.
An optional precompiler-generated number identifying the physical sequence in which DML statements appear in a program.
Percentage of the monitored period where CA Mainframe Application Tuner detected DML statements waiting for resources.
Visual depiction of the Totl% value.
Note: Scroll right to see one of the following fields on the DML Delays panel.
Command in a DML statement requesting a data manipulation operation. FINDs are converted to OBTAINs, as appropriate.
DML statement object of the requested operation (such as a record or set name).
DML statement object qualifying the target (such as an area or set name when the target is a record name).
Scroll to the right in the CA IDMS Delays panel to see the DML Verb/Target/Qualifier field. This field displays either the command in a DML statement requesting a data manipulation operation, the object of the requested operation, or the object qualifying the target.
CA MAT ------------------------- DML Delays -------------- Row 1 to 16 of 39 COMMAND ===> SCROLL ===> HALF Line commands: D - Detail Profile: IDMS8 Options: NORMAL CV number: 160 IDMS Release: 16.0 Mode: Module LC TaskCode Module DML Verb ________ ________ ________________________________________ <>------------------------------------------------------------------ __ OPER RHDCOPER __ RHDCNP3S RHDCNP3S OBTAIN CALC __ RHDCNP3S RHDCNP3S OBTAIN CALC __ COBWALK DCRDISCV OBTAIN CALC __ RHDCNP3S RHDCNP3S OBTAIN NEXT RECORD IN SET __ RHDCNP3S RHDCNP3S OBTAIN CALC __ COBWALK DCRDISCV OBTAIN CALC __ OPER RHDCOPER __ GO4AWALK TRIDMSCV OBTAIN CALC __ ASMWALK READDBCR OBTAIN CALC __ COBWALK DCRDISCV OBTAIN NEXT RECORD IN SET __ IDD IDMSDDDC OBTAIN NEXT RECORD IN SET __ COBWALK DCRDISCV OBTAIN CALC __ COBWALK DCRDISCV OBTAIN CALC __ COBWALK DCRDISCV OBTAIN CALC __ ASMWALK READDBCR OBTAIN CALC
Use line command D to display detail information about the selected row, as shown following.
CA MAT -------------------------- IDMS Detail -------------- Row 1 to 9 of 9 COMMAND ===> SCROLL ===> HALF Profile: IDMS8 Options: NORMAL Field Name Field Value ________________ ____________________________________________ ------------------------------------------------------------------------------ Task Code COBWALK Module DCRDISCV Offset 00000BFC DML Sequence 00000011 DML Verb OBTAIN NEXT RECORD IN SET DML Target TELLER DML Qualifier BRANCH-TELLER Total% 0.46 ******************************** End of Table ********************************
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |