Analyze IMS Data

Using the Product in an IMS Environment › Analyze IMS Data

Analyze IMS Data

CA Mainframe Application Tuner enables you to analyze IMS data to the IMS statement level. Use the following steps to see the IMS statements for an IMS job:

Set up your monitoring criteria so that the Observations Requested field contains a number in the range of 3000 to 10000.
Invoke the monitor by using the Invoke line command (I).
Analyze the data by using one of the analysis line commands, A, AL, AA, or AW.

Select Option 5 from the Interactive Analysis menu.

The DataView panel displays.

CA MAT -------------------------- DataView ------------------ ROW 1 to 4 of 4 COMMAND ===> SCROLL ===> CSR Primary commands: LINklist on/off Profile: IMS Options: NORMAL Line commands: S - Select Linklist: ON LC DD name Dataset name Delay% Visual ________ ____________________________________________ ______ __________ >------------------------------------------------------------------------------ __ .IMS IMS Statement Delay 23.88 =========> S_ INVDATA CAMAT.TEST.INVDATA 1.45 __ INVINDX CAMAT.TEST.INVINDX 1.11 __ INVTRAN CAMAT.TEST.INVTRAN 0.55 __ DFSRESLB IMS.V7100.RESLIB 0.00 __ IEFRDER IMSLOG 0.00 __ IMS IMS.V7100.PSBLIB 0.00 __ IMS IMS.V7100.DBDLIB 0.00 __ LINKLST SYS1.LINKLIB 0.00 __ LINKLST SYS1.MIGLIB 0.00

Type S next to one of the DD statements and press Enter.
An enhanced version of the Data Set Details panel displays. In this example, the INVDATA DD statement was selected.
```
CA MAT--------------------- Data Set Details ------------ Row 1 to 26 of 32 
COMMAND ===>                                                  SCROLL ===> HALF
                                                                               
DDNAME: INVDATA                                             Profile: IMS   
                                                                               
                                                                               
Access Method: VSAM        Cluster: CAMAT.TEST.INVDATA
   Opened for: DIRECT         Data: CAMAT.TEST.INVDATA.DATA
Share Options: 3 3           Index: CAMAT.TEST.INVDATA.INDX
 Organization: KSDS      Alt Index: N/A                                  
                                                                               
Data Component Information for: CAMAT.TEST.INVDATA.DATA
                                                                               
------ SMS ------- ------ Allocation ------- ----------- Format ---------------
DATACLAS:          Unit:                     Rec Len:        200 CI Size:    20
STORCLAS:          Primary:                0 # CIs per CA:   315 Strings:     0
MGMTCLAS:          Secondary:              0 CA Freespace:    25               
                   Volume Count:         n/a CI Freespace:    25               
                   Total Extent Count:     0 Stripes:          0               
                                                                               
---- VSAM Statistics --------------------------------------------------------- 
 Records Read: 0          Records Updated: 0          CA Splits:     19        
Records Added: 0          Records Deleted: 0          CI Splits:    559        
                                                                               
Index Component Information for: CAMAT.TEST.INVDATA.INDX                     
                                                                               
------ SMS ------- ------ Allocation ------- ----------- Format ---------------
DATACLAS:          Unit:                     Rec Len:       3065 CI Size:    30
STORCLAS:          Primary:                0 # CIs per CA:    15 Strings:     0
MGMTCLAS:          Secondary:              0 CA Freespace:     0               
                   Volume Count:         n/a CI Freespace:     0               
                   Total Extent Count:     0 Stripes:          0
```
The fields in this panel are described next.
DD Name

DDNAME used to allocate the data set.

Organization

Physical organization of the data stored in this data set,

Possible values are KSDS, ESDS, or RRDS

Dataset name

Full name of the data set.

If the data set organization is KSDS, CA Mainframe Application Tuner displays the names of the DATA and INDEX components.

Volser

First volume serial of the data set.

Unit

First device address of the data set.

Opened for

Intention of the program when performing I/Os for this data set.

Possible values are READ, WRITE, and DIRECT.

Logical record length

Specified length of the records that reside in this data set.

Share Options
Displays how an alternate index’s data or index component is shared among users.

You can select one of the following numbers:
- The data set can be shared by any number of users for read processing, or the data set can be accessed by only one user for read and write.
- The data set can be accessed by any number of users for read processing and it can also be accessed by one user for write processing.
- The data set can be fully shared by any number of users.
- The data set can be fully shared by any number of users, and buffers used for direct processing are refreshed for each request.
Data CI size

Size of the Control Interval for the data in this data set.

Number of CIs per CA

Count of CIs allocated within a control area for the data in this data set

Index levels.

number of index levels

VSAM KSDS data sets are indexed using a multilevel structure. The number of levels can have an impact on the performance of the data set if there are insufficient index buffers.

RPL strings

Number of strings for the data set.

This field indicates the number of concurrent operations that might be started for the data set.

Index buffers

Number of buffers used to perform I/O for the index component.

Data buffers

Number of buffers used to perform I/O for the data component.

Index EXCPs

Number of EXCPs for the INDEX component during the monitored period.

Data EXCPs

Number of EXCPs for the DATA component during the monitored period.

Records retrieved

Total number of records retrieved during the monitored period.

Records written

Number of records written to the data set during the monitored period.

CI splits

Number of times that the control interval was split due to lack of space.

CA splits

Number of times that the control area was split due to lack of space.

CI freespace

Percentage of free space in the control interval. Defined when the data set was created.

CA freespace

Percentage of free space in the control area. Defined when the data set was created.

File uses Shared Resources

The file uses VSAM local and global shared resources (LSR/GSR) and some values are invalid in the main display.

When the message File uses Shared Resources appears, values described below replace those marked n/a.

Pool ID

Pool identifier used to satisfy requests for this file (LSR/GSR).

Buffer Size

Size of the buffer used from the pool identified by Pool ID (LSR/GSR).

Num Buffers

Number of buffers available in the shared pool (LSR/GSR).

Hit Ratio

Percentage of READ requests that were satisfied from the buffer pool without an EXCP (LSR/GSR).

Steal Writes

Number of nonuser-initiated WRITES that were initiated for this buffer pool. A value of greater than 0 in this field can indicate a serious performance problem (LSR/GSR).
Press End to return to the DataView panel.

To select the .IMS DD statement, type S in the LC column and press Enter.

The IMS Statements panel displays:

CA MAT ----------------------- IMS Statements --------------- ROW 1 to 7 of 7 COMMAND ===> SCROLL: CSR Primary commands: DBDname, PSBname, IMSview Profile: IMS Mode: PSBNAME Line commands: S - SSA LC PSB Name PCB# DBD Name Segment Call P-Opts Actv% Wait% Totl% Visual ________ ____ ________ ________ ____ ______ _____ _____ _____ __________ ------------------------------------------------------------------------------- __ INV2200 2 INVDBD INVENSEG ISRT A 1.78 17.07 18.86 ========> __ INV2200 2 INVDBD INVENSEG GHU A 2.79 0.11 2.90 > __ INV2200 2 INVDBD INVENSEG REPL A 0.78 0.00 0.78 __ INV2200 2 INVDBD INVENSEG DLET A 0.55 0.00 0.55 __ INV2200 2 INVDBD INLOCSEG GHU A 0.44 0.00 0.44 __ INV2200 2 INVDBD INLOCSEG REPL A 0.22 0.00 0.22 __ INV2200 2 INVDBD INLOCSEG DLET A 0.11 0.00 0.11 ********************************* END OF TABLE ********************************

Tell Technical Publications how we can improve this information