Total IMS Resource Usage Analysis report description (report elements)
The following table describes IMS Resource Usage Analysis report elements.
The reference numbers (with the <n> format) match the elements in the report example pages to the elements described in the table.
Ref. | Description |
|---|---|
1 | CURRENT DATE Date this report was generated, in mm/dd/yy 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:
|
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):
|
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):
|
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 nonattributable 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, seeMessage-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 Nnumber 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 |
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 |
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 |
Related topic