CA MICS Analyzer Option for IDMS (IDM) Queries › IDMTYP – IDMS Daily Transaction Type Analysis › Overview

Overview

The IDMTYP query produces two CSV output files.

The first CSV output file produces several daily charts that display the hourly values of several resource and performance-related measurements for the various types of transactions executed by IDMS regions. The IDMS transaction type is stored in the MICS data element IDMTYPE.

The IDMTYPEs and their meanings are:

O

IDMS/DC Online

B

Batch external run units

C

CICS external run units

I

IDMS/DC/UCF external run units

S

IDMS/DC system task

The transaction type is determined from the raw data transaction records, and is included as a summarization key in the CA MICS database file that is used to generate these charts.

The second CSV output file generates the charts that show the daily transaction response time distribution for each IDMS transaction type. The charts from this second CSV rely on the transaction response time classifications (for example, SHORT, MEDIUM, LONG), and response time distribution buckets that are defined using CA MICS-provided user interfaces. The IDMS Transaction Type Exit in prefix.MISC.PARMS(IDMRLRT) is used to assign a response time classification (for example, SHORT, MEDIUM, LONG) for each transaction. Response time bucket distribution values are specified with the RESP keyword in the IDMS Processing Options member, prefix.MICS.PARMS(IDMOPS). The value of these charts is enhanced significantly when these members are updated to reflect your IDMS environment.

Two CSV output files are generated by this query:

• Daily IDMS Region Tran Type by HOUR
• Daily IDMS Region Tran Type Resp Dist

The Daily IDMS Region Tran Type by HOUR data extract generates the following six chart views:

#1 - Daily IDMS Region Transaction Type: Hourly CPU Time Use

This view uses stacked vertical bars to show the hourly CPU time used by the transaction type displayed in the chart title area. A horizontal line shows the hourly transaction count.

The first chart sample (previously shown) is an example of the charts produced by view #1. This chart was produced from two cycles of the DAYS timespan IDMSSY file and shows:

• The hourly CPU time used and transaction count for IDMS transaction type ‘CICS External Run Units’ executed by IDMS Region CV44 running on z/OS LPAR XE61 on an IBM 2817-615 (z196 CPC with 15 sub-capacity CP engines).
• This IDMS transaction type began executing during HOUR 4:00 AM, and was heavily used until about 10:00 PM.
• The CPU time that was used by this transaction type was evenly split between standard CP and zIIP processors.

#2 - Daily IDMS Region Transaction Type: Hourly Response Time Analysis

This view uses stacked vertical bars to show the hourly number of SHORT, MEDIUM, and LONG transactions executed for the transaction type. The average SHORT and MEDIUM transaction response times are displayed using horizontal lines.

#3 - Daily IDMS Region Transaction Type: Hourly Database Activity

This view uses stacked vertical bars to show the hourly count of database calls, and pages requested, read, and written for the transaction type. A horizontal line shows the hourly transaction count.

#4 - Daily IDMS Region Transaction Type: Hourly Queue Activity

This view uses stacked vertical bars to show the hourly count of queue DELETES, GETS, and PUTS for the transaction type. A horizontal line shows the hourly transaction count.

#5 - Daily IDMS Region Transaction Type: Hourly Storage Pool Use

This view uses stacked vertical bars to show the hourly count of storage FREES and GETS for the transaction type. A horizontal line shows the hourly transaction count.

#6 - Daily IDMS Region Transaction Type: Hourly Scratch Activity

This view uses stacked vertical bars to show the hourly quantity of scratch DELETES, GETS, and PUTS for the transaction type. A horizontal line shows the hourly transaction count.

The Daily IDMS Region Resp Dist data extract generates a single chart view:

#1 - Daily IDMS Transaction Type Response Time Distributions

This view uses vertical stacked bars to display the count of SHORT, MEDIUM, and LONG transactions that completed in each of the eight user-defined response time distribution ranges for each transaction type where the transactions have been categorized.

Note: The query does not produce charts for transaction types where the CA MICS IDMS Transaction Type exit code did not assign response time categorizations.

The second chart sample (previously shown) is an example of a response time distribution chart that is produced by this view. This chart sample shows the daily transaction response time distributions for the same IDMS region and transaction type that is shown in the first chart sample. The chart shows:

• The majority of SHORT transactions (over 1.5 million) completed in between 0.001 and 0.005 seconds.
• Approximately 50,000 transactions completed in less than 0.001 seconds.
• Virtually all of the MEDIUM transactions completed in between 0.1 and 1 seconds
• A few of the LONG transactions (just over 3000) completed in between 1 and 10 seconds.