Display DML Delays

Using the Product in a CA IDMS Environment › Display DML Delays

Display DML Delays

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 MAT detected CA IDMS waiting for resources.

Follow these steps:

Use the DML command from the CA IDMS Delays panel.

The DML Delays panel displays.

CA MAT--------------------------- DML Delays -------------- Row 1 to 10 of 19 COMMAND ===> SCROLL ===> CSR Line commands: D - Detail Profile: IDMS17 Options: NORMAL CV number: 97 IDMS Release: 17.0.01 Local Mode: NO LC TaskCode Module Offset DML SEQ Totl% Visual ________ ________ ________ ________ _____ __________ >------------------------------------------------------------------------------ __ RHDCNP3S RHDCNP3S 00000000 00000000 12.90 =========> __ RCVR RCVRTS01 00000000 00000000 9.68 ======> __ BYE RHDCBYE 00000000 00000000 9.68 ======> __ RHDCNP3S RHDCNP3S 00000000 00000000 6.45 ====> __ DCUF RHDCUF00 00000000 00000000 6.45 ====> __ DCMT RHDCMTPR 00001A6E 00000000 6.45 ====> __ DCMT RHDCMT00 00000000 00000000 6.45 ====> __ BYE RHDCBYE 000001BC 00000000 6.45 ====> __ RHDCNP3S RHDCNP3S 00000000 00000000 3.23 => __ DCMT RHDCMTDY 00000F78 00000000 3.23 => ----------------------------------- Totals ------------------------------------ 100.0

Use the fields in the DML Delays panel as necessary.
A description for each field in the DML Delays panel follows.

Profile

Name of the profile that you specified when you created the monitor definition.

Options

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.

TaskCode

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.

Module

Name of the program requesting CA IDMS DB/DC services, when known, or the name of the program invoked by specifying the task code.

Offset

Relative address within the module to which control will be returned upon completion of the CA IDMS DB/DC service request.

DML SEQ

An optional precompiler-generated number identifying the physical sequence in which DML statements appear in a program.

Totl%

Percentage of the monitored period where CA MAT detected DML statements waiting for resources.

Visual

Visual depiction of the Totl% value.

Note: Scroll right to see one of the following fields on the DML Delays panel.

DML Verb

Command in a DML statement requesting a data manipulation operation. FINDs are converted to OBTAINs, as appropriate.

DML Target

DML statement object of the requested operation (such as a record or set name).

DML Qualifier

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 10 of 19 COMMAND ===> SCROLL ===> CSR Line commands: D - Detail Profile: IDMS17 Options: NORMAL CV number: 97 IDMS Release: 17.0.01 Local Mode: NO LC TaskCode Module Offset DML Verb ________ ________ ________ ________________________________________ <>----------------------------------------------------------------------------- __ RHDCNP3S RHDCNP3S 00000000 __ RCVR RCVRTS01 00000000 __ BYE RHDCBYE 00000000 __ RHDCNP3S RHDCNP3S 00000000 ERASE ALL MEMBERS __ DCUF RHDCUF00 00000000 __ DCMT RHDCMTPR 00001A6E __ DCMT RHDCMT00 00000000 __ BYE RHDCBYE 000001BC __ RHDCNP3S RHDCNP3S 00000000 STORE __ DCMT RHDCMTDY 00000F78 ----------------------------------- Totals ------------------------------------

Use line command D to display detail information about the selected row, as shown following.

CA MAT ---------------------------- IDMS Detail -------------- Row 1 to 8 of 8 COMMAND ===> SCROLL ===> CSR Profile: IDMS17 Options: NORMAL Field Name Field Value ________________ ____________________________________________ ------------------------------------------------------------------------------- Task Code RHDCNP3S Module RHDCNP3S Offset 00000000 DML Sequence 00000000 DML Verb ERASE ALL MEMBERS DML Target RESOURCE DML Qualifier Total% 6.45 ********************************* End of Table ********************************