Use the Product with Adabas

Using the Product with Other Databases › Use the Product with Adabas

Use the Product with Adabas

CA Mainframe Application Tuner provides a list of Adabas statements that are detected during the monitored period. Use this procedure to display these statements after monitoring a job.

To display Adabas statements

Analyze the data by using one of the analysis line commands (A, AL, AA, or AW).

Select one of the following two ways to locate the Adabas statements:

From the Interactive Analysis menu, select Option 18.
From the Interactive Analysis menu, select Option 5. Ensure that .Adabas is displayed in the DD Name field. Type S next to .Adabas.

The ADABAS Statements panel displays:

CA MAT -------------------- ADABAS Statements ----------- Row 1 to 16 of 50 COMMAND ===> SCROLL ===> CSR Profile: CICS63 Actv% DB ID File # CMD CMD-IDX CMD-ID Wait% Totl% Visual _____ _____ ______ ________ ________ ______ _____ _____ __________ ------------------------------------------------------------------------------ 0.26 12345 9 L3 D5D3C2D7 NLBP 45.66 45.92 =========> 0.00 12345 10 S1 00400201 .... 7.65 7.65 > 0.00 12345 0 RC 01200201 .... 4.59 4.59 0.00 12345 10 L3 01000201 .... 2.55 2.55 0.00 12345 10 L3 01100201 .... 2.55 2.55 0.00 12345 10 S1 00000000 .... 2.04 2.04 0.26 12345 10 L2 01400201 .... 0.77 1.02 0.00 12345 9 L9 51000101 .... 0.77 0.77 0.00 12345 10 L1 00400201 .... 0.77 0.77 0.00 12345 10 L3 01300201 .... 0.77 0.77 0.00 12345 0 ET 00000000 .... 0.77 0.77 0.51 12345 10 L3 01200201 .... 0.26 0.77 0.00 12345 10 L3 01900201 .... 0.77 0.77 0.00 12345 10 L1 00000000 .... 0.77 0.77 0.00 12345 10 L3 00900201 .... 0.51 0.51 0.00 12345 20 S1 01300201 .... 0.51 0.51

The following text describes the fields in the ADABAS Statements panel.

Actv%

Percentage of the monitored period that the processing of the Adabas statement used CPU.

DB ID

Decimal representation of the Adabas database ID containing the file to be accessed. This number can be in the range of 1 to 65535.

File #

Decimal representation of the Adabas file number to be accessed. This number can be in the range of 1 to 5000.

CMD

One of the Adabas commands used to access Adabas databases.

This field displays the database access command. Possible values in this field, and the descriptions of these values, are as follows:

A1: Update records (hold option)
BT: Remove database updates for ET logic users
C1: Write Command ID, PLOG, RABN checkpoint, buffer flush option
C3: Write SYNX-03 checkpoint for exclusive control update users; option to store user data
C5: Write user data on SIBA/PLOG
CL: End/ET session and update database
E1: Delete record (hold option) or Refresh file
ET: End and save current transaction
HI: Prevent record update by other users
L1: Read record of specified ISN
L2: Read records in physical order
L3: Read records in descriptor value order
L4: Read and hold, wait for held record/issue return code option
L5: Read in physical order and hold, wait/issue return code option
L6: Read in descriptor value order with wait/issue return code option
L9: Read ISNs of specified descriptor
LF: Read characteristics of all fields in file
N1: Add new database record with Adabas-assigned ISN
N2: Add new database record with user-assigned ISN
OP: Open user session
RC: Release one or more command IDs or a global format ID for the issuing user
RE: Read ET data for this user, another user, or all users
RI: Release held record and ISN
S1: Return count and ISNs of records meeting the search criteria
S2: Return count of records and ISNs in user-specified order
S4: Return count and ISNs of records meeting the search criteria and hold
S5: Return or save a list of coupled ISNs for the specified file
S8: Combine two ISN lists from the same file with AND, OR, or NOT operation
S9: Sort ISN list in ascending ISN or descriptor-specified sequence

CMD-IDX

Same value as the CMD-ID field in hexadecimal format.

CMD-ID

Identifies users, their transactions, and decoded formats for reuse by subsequent instructions.

The command ID is either user-specified or system-generated. It can be either local or global to specify either internal or globally accessible decoded formats.

Wait%

Percentage of the monitored period that the program waited for Adabas data to be returned.

Totl%

Sum of the Actv% and Wait% fields.

This value represents the total percentage of the Adabas delay time used by this Adabas statement.

Visual

Graphical representation of the sum of the Actv% and Wait% categories for the Adabas statement.

The Visual field provides a graphical representation of the data in the column that immediately precedes it. A graph’s color is determined by its value, as follows:

Green represents a value between 0 and 20.
Yellow represents a value between 20 and 50.
Red represents a value between 50 and 100.

The size of the graph is either relative or absolute, depending on the value (Y/N) selected for AutoScale in the Profile Parameters panel

Relative scale

Graphs are sized relative to the highest value. The graph for the highest value extends the maximum length of the field, with all other graphs proportional to it.

For example, if the maximum value on a screen is 10, its graph extends the maximum length of the field. If the next highest value is 5, its graph extends half of the maximum length of the field.

Absolute scale

The graph displays an absolute representation of the value. For example, if the maximum value on the screen is 10, the graph extends 1/10 the length of the field.

Tell Technical Publications how we can improve this information