1

CURRENT DATE

Date this report was generated, in mm/dd/yyyy format

2

IMSID

Identification code for the IMS that processed the transactions

3

SMFID

Identification code from the SMCA for the computing system that processed the transactions

4

IMS LEVEL

IMS release number and modification level

5

LSO OPTION

LSO processing option (N, Y, X, or S) in effect

6

EARLIEST START

Julian date and time of day when the first terminal session started

7

LATEST STOP

Julian date and time of day when the last terminal session ended

8

RESOURCE IDENTIFICATION

Resource used; resources are grouped by:

• IMS overhead CPU usage

• IMS chargeable CPU usage

• IMS total CPU usage

• IMS scheduling activity

• IMS terminal I/O (full function transactions)

• IMS full function database requests

• IMS full function database I/O

• IMS terminal I/O (Fast Path transactions)

• IMS Fast Path database requests

• IMS Fast Path database I/O

• Db2 requests

• MQ requests

9

MPP WORKLOAD

IMS workload that is MPP (message processing program), JMP (Oracle Java message processing program), TPI (CPI, C-driven program), DBCTL threads (CICS and ODBA), and MDP (Fast Path message-driven program):

• QUANTITY; amount of the IMS workload attributable to MPPs, JMPs, TPI, DBCTL threads, and MDPs for CPU consumed, scheduling activity, I/O activity, or requests made to a database or Db2 subsystem

• % TOTAL WORKLOAD; percentage of the total resources consumed that is attributable to MPPs, JMPs, TPI, DBCTL threads, and MDPs

10

BMP WORKLOAD

IMS workload that is BMP (batch message processing), JBP (Java batch message processing), FPU (Fast Path utility), and NDP (non-message-driven program):

• QUANTITY; amount of the IMS workload attributable to BMPs, JBPs, FPU, and NDP for CPU consumed, scheduling activity, I/O activity, or requests made to a database or Db2 system

• % TOTAL WORKLOAD; percentage of the total resources consumed that is attributable to BMPs, JBPs, FPU, and NDP

11

TOTAL WORKLOAD

Total amount of resources used for the total workload

12

IMS OVERHEAD CPU USAGE

Amount of CPU time (expressed in seconds) consumed as IMS overhead:

12

Control REGION/DLISAS CPU TIME

Amount of CPU time used by the IMS DLISAS address spaces after buffer handling, OPEN/CLOSE, and program scheduling CPU time have been subtracted (for more information, see Control region overhead)

The calculation method for this field uses the program record (PAR) field that includes only the non-attributable overhead values. This method is more accurate when subsetted IRUFs are used as input (all matching transaction and program records may not be available).

12

BUFFER HANDLING CPU TIME

Amount of CPU time used in searching and managing the database I/O buffer pool. (For more information, see Message buffer CPU and Control buffer CPU)

12

OPEN/CLOSE PROCESSING CPU TIME

Amount of CPU time used in opening and closing data sets for use by DL/I (for more information, see Message OPEN/CLOSE CPU)

12

PROGRAM SCHEDULING CPU TIME

Amount of CPU time used for program scheduling and termination in the control region and DLISAS address spaces (for more information, see Program scheduling CPU)

12

MESSAGE REGION OVERHEAD CPU TIME

Amount of additional overhead CPU time used in the message region. The value includes all dependent region CPU time except for application program and message DL/I, OPEN/CLOSE, or Db2 CPU time (for more information, see Message region overhead CPU)

12

TOTAL OVERHEAD CPU TIME

Sum of control region/DLISAS, buffer handler, OPEN/CLOSE, program scheduling, and message region overhead CPU times

12

AVG OVERHEAD CPU/TRAN

Average overhead CPU time per transaction

13

IMS CHARGEABLE CPU USAGE

Amount of CPU time (expressed in seconds) directly attributed to the processing of a particular transaction

13

APPLICATION PROGRAM CPU TIME

CPU directly attributable to the application program (for more information, see Application program CPU)

13

DL/I CPU TIME

Amount of CPU time used by DL/I in processing the DL/I requests, excluding the overhead items OPEN/CLOSE CPU times and optionally buffer handler CPU time (for more information, see Message DL/I CPU and Control DL/I CPU)

13

DB2 CPU TIME

Amount of CPU time spent processing Db2 calls (for more information, see Db2 CPU)

13

TOTAL CHARGEABLE CPU

Sum of application program, DL/I, and Db2 CPU time

13

AVG CHARGEABLE CPU/TRAN

Average amount of chargeable CPU time per transaction

13

AVG DL/I CPU/DB CALL

Average amount of chargeable DL/I CPU time per call to a DL/I database

13

AVG DB2 CPU/DB2 CALL

Average amount of chargeable Db2 CPU time per call to a Db2 subsystem

14

IMS TOTAL CPU USAGE

Amount of control region, DLISAS, and dependent region CPU time spent processing transactions

14

Control REGION/DLISAS CPU TIME

Sum of control region DL/I, buffer, program scheduling, OPEN/CLOSE (full function databases), and overhead CPU time

14

DEPENDENT REGION CPU TIME

Sum of application program, Db2, message region DL/I, buffer, OPEN/CLOSE (Fast Path databases), and message region overhead CPU time

14

TOTAL IMS CPU

Sum of the control, DLISAS, and dependent region CPU time used

14

AVG CPU/TRAN

Average CPU time spent processing each transaction

14

% DEP. REGION/TOTAL CPU

Dependent region usage percentage of total CPU, calculated as:

(Dependent_Region_CPU × 100) ÷ Total_IMS_CPU

14

% CHARGEABLE TOTAL CPU

Percentage of total CPU that is chargeable, calculated as:

[(DLI_CPU + DB2_CPU + Application_Program) × 100]) ÷ Total_CPU

15

IMS SCHEDULING ACTIVITY

Number of programs executed and transactions processed during the summarization period

The figures allow approximation of I/O required for IMS supervisory functions.

15

NUMBER OF PROGRAMS

Number of programs executed

15

NUMBER OF PROGRAM ABENDS - SYSTEM

Number of programs that incurred a system abend

15

NUMBER OF PROGRAM ABENDS - USER

Number of programs that incurred a user abend

15

NUMBER OF TRANSACTIONS

Number of transactions processed

15

NUMBER OF TRANS. ACCESSING DB2

Number of transactions that accessed a Db2 subsystem

15

AVG TRANS/PROGRAM

Average number of transactions per program, calculated as:

Number_of_Transactions ÷ Number_of_Programs

16

IMS TERMINAL I/O

Number of DL/I message calls (terminal I/O) issued in processing the full function message queue transaction volume:

16

FULL FUNCTION TRANS (MSG Q)

Number of transactions processed through the full function message queue

16

INPUT CALLS - MGU/MGN

Number of MESSAGE GET UNIQUE and MESSAGE GET NEXT calls

16

OUTPUT CALLS - MISRT/MPURG

Number of MESSAGE INSERT and MESSAGE PURGE calls

16

TOTAL TERMINAL I/O

Sum of the input and output calls

16

AVG TERMINAL I/O / TRAN

Average amount of terminal activity per transaction, calculated as:

Total_Terminal_I/O ÷ Number_of_Transactions

17

IMS FULL FUNCTION DATA BASE REQUESTS

Number of DL/I requests and updates issued by transactions

17

TRANS ACCESSING FF DBS

Number of transactions accessing full function databases

17

DL/I GET UNIQUES

Number of GET UNIQUE calls

17

DL/I GET NEXT

Number of GET NEXT calls

17

TOTAL GET CALLS

Sum of GET UNIQUE and GET NEXT calls

17

AVG GET CALLS/TRAN

Average number of GET calls per transaction, calculated as:

Total_GET_Calls ÷ Number_of_Transactions

17

DL/I DELETES

Number of DELETE calls

17

DL/I REPLACES

Number of REPLACE calls

17

DL/I INSERTS

Number of INSERT calls

17

TOTAL UPDATE CALLS

Sum of DELETE, REPLACE, and INSERT calls

17

AVG UPDATE CALLS / TRAN

Average number of update calls per transaction, calculated as:

Total_Update_Calls ÷ Number_of_Transactions

17

TOTAL DL/I DATA BASE CALLS

Total GET and UPDATE calls.

17

AVG DL/I CALLS / TRAN

Average number of DL/I calls per transaction, calculated as:

Total_DL/I_Database_Calls ÷ Number_of_Transactions

17

% UPDATE CALLS

Percentage of database calls for updates, calculated as:

(Total_Update_Calls × 100) ÷ Number_of_DL/I_Calls

18

IMS FULL FUNCTION DATA BASE I/O

Amount of database I/O activity (for more information, see Database reads and Database writes)

18

KEY READS

Number of reads to VSAM KSDSs to satisfy DL/I requests

18

NONKEY READS

Number of reads to QSAM or VSAM KSDSs to satisfy DL/I requests

18

TOTAL READ I/O

Sum of key and nonkey reads

18

AVG READ I/O / TRAN

Average number of reads per transaction, calculated as:

Total_Read_I/O ÷ Number_of_Transactions

18

KEY WRITES

Number of writes to VSAM KSDSs to satisfy DL/I requests

18

NONKEY WRITES

Number of writes to QSAM or VSAM KSDSs to satisfy DL/I requests

18

TOTAL WRITE I/O

Sum of key and nonkey writes

18

AVG WRITE I/O / TRAN

Average number of writes per transaction, calculated as:

Total_Write_I/O ÷ Number_of_Transactions

18

TOTAL DATA BASE I/O

Sum of total I/O reads and writes

18

AVG I/O / TRAN

Average I/O activity per transaction, calculated as:

Total_I/O ÷ Number_of_Transactions

18

% KEY I/O

Percentage of I/O activity for KSDSs, calculated as:

(Total_Key_I/O × 100) ÷ Total_Database_I/O

18

% WRITE I/O

Percentage of I/O activity for database writes, calculated as:

(Total_Write_I/O × 100) ÷ Total_Database_I/O

19

IMS TERMINAL I/O (not printed if there is no Fast Path activity)

Number of DL/I message calls (terminal I/O) issued in processing the Fast Path transaction volume:

19

FAST PATH TRANSACTIONS (EMH)

Number of Fast Path transactions processed through the Expedited Message Handler

19

INPUT CALLS - MGU

Number of MESSAGE GET UNIQUE calls

19

OUTPUT CALLS - MISRT/MPURG

Number of MESSAGE INSERT and MESSAGE PURGE calls

19

TOTAL TERMINAL I/O

Sum of the input and output calls

19

AVG TERMINAL I/O / TRAN

Average amount of terminal activity, calculated as:

Total_Terminal_I/O ÷ Number_of_Fast_Path_Transactions

20

IMS FAST PATH DATA BASE REQUESTS (not printed if there is no Fast Path activity)

Number of DL/I requests and updates issued to Fast Path databases (DEDBs and MSDBs):

20

TRANS ACCESSING FP DBS

Number of transactions accessing Fast Path databases

20

DL/I GET UNIQUES

Number of GET UNIQUE calls

20

DL/I GET NEXT

Number of GET NEXT calls

20

TOTAL GET CALLS

Sum of GET UNIQUE and GET NEXT calls

20

% MSDB GET CALLS

Percentage of MSDB calls for GET calls, calculated as:

(Total_Get_Calls × 100) ÷ Number_of_MSDB_Calls

20

DL/I DELETES

Number of DELETE calls

20

DL/I REPLACES

Number of REPLACE calls

20

DL/I INSERTS

Number of INSERT calls

20

TOTAL UPDATE CALLS

Sum of DELETE, REPLACE, and INSERT calls

20

% MSDB UPDATE CALLS

Percentage of MSDB calls for update calls, calculated as:

(Total_Update_Calls × 100) ÷ Number_of_MSDB_Calls

20

TOTAL DL/I DATA BASE CALLS

Total GET and UPDATE calls

20

AVG DL/I CALLS / TRAN

Average number of calls per Fast Path transaction, calculated as:

Total_DL/I_Database_Calls ÷ Number_of_Fast_Path_Transactions

20

% MSDB CALLS

Percentage of MSDB calls for DL/I calls, calculated as:

(Total_MSDB_Calls × 100) ÷ Number_of_DL/I_Calls

21

IMS FAST PATH DATA BASE I/O (not printed if there is no Fast Path activity)

Amount of Fast Path database I/O activity (for more information, see Database reads and Database writes)

21

DEDB READS

Number of reads to DEDBs to satisfy DL/I requests

21

AVG READ I/O / TRAN

Average number of reads per Fast Path transaction, calculated as:

Total_Read_I/O ÷ Number_of_Fast_Path_Transactions

21

DEDB WRITES

Number of DEDB writes to satisfy DL/I requests

21

AVG WRITE I/O / TRAN

Average number of writes per Fast Path transaction, calculated as:

Total_Write_I/O ÷ Number_of_Fast_Path_Transactions

21

TOTAL DATA BASE I/O

Sum of DEDB reads and writes

21

AVG I/O / TRAN

Average I/O activity per Fast Path transaction, calculated as:

Total_I/O ÷ Number_of_Fast_Path_Transactions

21

% WRITE I/O

Percentage of I/O activity for DEDB writes, calculated as:

(Total_Write_I/O × 100) ÷ Total_DEDB_I/O

22

DB2 REQUESTS

Number of Db2 requests issued by transactions

Note

This section of the report is not printed if there is no Db2 activity or if FEATURE=NODB2 in IMFSYS00.

22

SSID

Subsystem identification code of the first Db2 subsystem accessed

22

NUMBER OF TRANS ACCESSING DB2

Number of transactions that accessed a Db2 subsystem

22

DB2 SELECTS/FETCHES

Number of SQL SELECTs and FETCHes to the Db2 subsystem

22

DB2 OPENS

Number of SQL OPEN calls to the Db2 subsystem

22

TOTAL GET CALLS

Sum of SQL SELECT/FETCH and OPEN calls

22

AVG GET CALLS / TRAN

Average number of SELECT/FETCH and OPEN calls issued per Db2 transaction

22

DB2 INSERTS

Number of SQL INSERT calls to the Db2 subsystem

22

DB2 DELETES

Number of SQL DELETE calls to the Db2 subsystem

22

DB2 UPDATES

Number of SQL UPDATE calls to the Db2 subsystem

22

TOTAL UPDATE CALLS

Sum of SQL INSERT, DELETE, and UPDATE calls

22

AVG UPDATE CALLS / TRAN

Average number of update calls made by each Db2 transaction

22

DB2 DATA DEF. LANGUAGE (DDL)

Number of SQL Data Definition Language calls to the Db2 subsystem (CREATE, DROP, ALTER, COMMENT, LABEL)

22

DB2 DYNAMIC SQL CALLS

Number of SQL dynamic calls to the Db2 subsystem (PREPARE, DESCRIBE, EXECUTE)

22

DB2 SQL Control CALLS

Number of SQL control-type calls to the Db2 subsystem (GRANT, REVOKE)

22

DB2 OTHER CALLS

Number of other SQL control-type calls to the Db2 subsystem (EXPLAIN, LOCK, LABEL, CLOSE)

22

TOTAL SPECIAL CALLS

Ttotal DDL, DYNAMIC, control, and other SQL calls

22

AVG SPECIAL CALLS / TRAN

Average number of special SQL calls per transaction, calculated as:

Total_Special_SQL_Calls ÷ Number_of_DB2_Transactions

22

DB2 DATA DEF. LANGUAGE (DDL)

Number of SQL Data Definition Language calls to the Db2 subsystem (CREATE, DROP, ALTER, COMMENT, LABEL)

22

DB2 DYNAMIC SQL CALLS

Number of SQL dynamic calls to the Db2 subsystem (PREPARE, DESCRIBE, EXECUTE)

22

DB2 SQL Control CALLS

Number of SQL control-type calls to the Db2 subsystem (GRANT, REVOKE)

22

DB2 OTHER CALLS

Number of other SQL control-type calls to the Db2 subsystem (EXPLAIN, LOCK, LABEL, CLOSE)

22

TOTAL SPECIAL CALLS

Total DDL, DYNAMIC, control, and other SQL calls

22

AVG SPECIAL CALLS / TRAN

Average number of special SQL calls per transaction, calculated as:

Total_Special_SQL_Calls ÷ Number_of_DB2_Transactions

22

TOTAL DB2 CALLS

Total number of all Db2 calls

22

AVG DB2 CALLS / TRAN

Average number of Db2 calls per transactions, calculated as:

Total_DB2_Calls ÷ Number_of_DB2_Transactions

22

% UPDATE CALLS

Percentage of DB2 calls that are updates, calculated as:

(Total_Update_Calls × 100) ÷ Total_DB2_Calls

23

MQ REQUESTS

Number of MQ requests issued by transactions

Note

This section of the report is not printed if there is no MQ activity.

23

SSID

Subsystem identification code of the first MQ subsystem accessed

23

NUMBER OF TRANS. ACCESSING MQ

Number of transactions that accessed an MQ subsystem

23

MQ GETS

Number of MQ GET calls to the MQ subsystem

23

AVG GETS / TRAN

Average number of GET calls made by each MQ transaction

23

MQ PUTS

Number of MQ PUT calls to the MQ subsystem

23

AVG PUTS / TRAN

Average number of PUT calls made by each MQ transaction

23

MQ PUT1S

Number of MQ PUT1 calls to the MQ subsystem

23

AVG PUT1S / TRAN

Average number of PUT1 calls made by each MQ transaction

23

MQ SETS

Number of MQ SET calls to the MQ subsystem

23

AVG SETS / TRAN

Average number of SET calls made by each MQ transaction

23

MQ OPENS

Number of MQ OPEN calls to the MQ subsystem

23

AVG OPENS / TRAN

Average number of OPEN calls made by each MQ transaction

23

MQ CLOSES

Number of MQ CLOSE calls to the MQ subsystem

23

AVG CLOSES / TRAN

Average number of CLOSE calls made by each MQ transaction

23

MQ BACKS

Number of MQ BACK calls to the MQ subsystem

23

AVG BACKS / TRAN

Average number of BACK calls made by each MQ transaction

23

MQ COMMITS

Number of MQ COMMIT calls to the MQ subsystem

23

AVG COMMITS/ TRAN

Average number of COMMIT calls made by each MQ transaction

23

MQ CONNECTS

Number of MQ CONNECT calls to the MQ subsystem

23

AVG CONNECTS/ TRAN

Average number of CONNECT calls made by each MQ transaction

23

MQ DISCONNECTS

Number of MQ DISCONNECT calls to the MQ subsystem

23

AVG DISCONNECTS/ TRAN

Average number of DISCONNECT calls made by each MQ transaction

23

MQ INQUERIES

Number of MQ INQUERY calls to the MQ subsystem

23

AVG INQUERIES / TRAN

Average number of INQUERY calls made by each MQ transaction

23

MQ UNKNOWNS

Number of MQ UNKNOWN calls to the MQ subsystem

23

AVG UNKNOWNS / TRAN

Average number of UNKNOWN calls made by each MQ transaction