IBM Support

Measuring database update activity using IMS Performance Analyzer

Question & Answer


Question

How can I measure database update activity using IMS Performance Analyzer?

Answer

Database update activity can be measured using the IMS PA Database Update Activity report. Options for this Log report can be found on the Database Update Activity panel in the Resource Usage and Availability Reports category as follows:

The Database Update Activity report summarizes Full Function Database update activity and helps determine the cost of database calls. Reports generated using the FORMAT2 option provide a faster, more concise breakdown of database update activity. FORMAT2 is the recommended report option.

To run a FORMAT2 report, use the Database Update Activity report options panel, or specify


FORMAT2 in your batch command as follows:
     IMSPALOG DBUPDATE(PROGRAM,FORMAT2)     IMSPALOG EXECUTE  

A sample report can be found below:

IMSPA_Database_Update_Activity.txtIMSPA_Database_Update_Activity.txt


The columns in a FORMAT2 report are described as follows:
  • Database - Database name.
  • Program - Program name. Use the DBUPDATE(PROGRAM) batch operand to report a breakdown by program name within the database name. If there are two or more programs for the database then the database total (*Total*) is reported.
  • Proc - Processing taking place when record was written. Can be one of:
    • APPL – Record written during application processing.
    • B/O – Record written during Transaction Backout.
    • OLR – Record written during online recovery.
  • 5050 Total – The total number of 5050 (Database Update) records (sum of the ISRT, DLET, REPL, and ROLx columns).
  • Updates – The total number of block updates.
    • For DLI application calls, this value is the sum of the ISRT, DELT, and REPL columns minus the ROLx column.
    • For Physical I/O, this value is the sum of the ISRT, DELT, and REPL columns.
  • ISRT/DLET/REPL - The number of physical segments changed by ISRT, DLET and REPL calls.
  • ROLx – The number of rollbacks.
  • New Block – The number of requests to create new blocks.
  • Free Space – The number of changes to free space elements.
  • 5052 Insert – The number of 5052 (Database Update prior to KSDS insert) records.
  • 5051 Problem – The number of 5051 (Database Update – prior action was unsuccessful) records.
  • 20 Open - The number of 20 (Database Open) records (row above).
  • 24 Error - The number of 24 (Database Error) records (row below).
A summary total can be found at the end of the report.

Requirement
  • Apply PTF UK92421 / APAR PM83153 for IMS Performance Analyzer V4.3.

[{"Line of Business":{"code":"LOB35","label":"Mainframe SW"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSAVHQ","label":"IMS Performance Analyzer for z\/OS"},"ARM Category":[{"code":"a8m0z000000cvZ6AAI","label":"IMS Performance Analyzer for z\/OS"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

Document Information

Modified date:
15 November 2020

UID

swg21647784