Using DDF Reports

The following figure shows the sequence in which we recommend that you use the DDF reports. Starting with the DDF SQL CPU Usage Summary report, you can go to either of the other two reports next, depending on whether you want to know the location from which the SQL code originates.

Using DDF Reports

To begin your analysis of the DDF address space, start with the DDF SQL CPU Usage Summary report (DDF SQL CPU Usage Summary Report). This report shows which DBRMs are using the most in_DB2 SQL CPU and execution (elapsed) time.

Next, inspect either the DDF CPU Usage by SQL Statement report (DDF SQL CPU Usage By SQL Statement Report) or the SQL Statement by DBRM by Requester report (DDF SQL Statement by DBRM by Requester by Location Report).

If you want to see the text of the SQL statements, you must refer to the DDF CPU Usage by SQL Statement report.

Both reports show which SQL statements are using the most in_DB2 SQL CPU or execution time. If you are interested in the origin of the SQL statements, then you want to look at the DDF SQL Statement by DBRM by Requester report, which lists the DBRMs by the source of the SQL that is executing in the DDF address space.

The DDF SQL Statement by DBRM by Requester report can be helpful when you find that the same DBRM appears to use different amounts of execution and in_DB2 SQL CPU times. This might occur because one or more SQL statements were modified in the DBRM and they are running on different servers, the network was more congested in one location, or a heavy workload was running on the MVS system when Strobe measured the DDF address space.

If you have installed iStrobe, a separate BMC product, you can analyze the SQL statements of interest even further by viewing the Run Time Statistics, Stored Procedure SQL Activity, Trigger SQL Activity, or SQL Analysis reports.

SQL Analysis gives statement-specific performance suggestions for the SQL statements in the DDF reports. To use these tools with Performance Profiles generated for a measurement of a DDF address space, you need to generate the DDF reports for iStrobe output.

To generate iStrobe output for your DDF reports, enter I for an iStrobe file in the OUTPUT FORMAT field of any of the following panels:

• Strobe - Produce a Performance Profile (See the following figure)
• Strobe - Create an Auto Performance Profile
• Strobe - Change an Auto Performance Profile.

Strobe - Produce a Performance Profile Panel

For more information about creating Performance Profiles for iStrobe, refer to the Using-Strobe-to-measure-online-applications-and-batch-programs. For information about using iStrobe, refer to the iStrobe documentationand online help.