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