|
|
|
CA Mainframe Application Tuner can gather and display data from SQL statements. The gathered data provides valuable information about performance and resource use of DB2 applications. With CA Mainframe Application Tuner, you do not require expensive DB2 SQL traces to gather data. CA Mainframe Application Tuner collects all relevant performance measurements in real time for every SQL statement that is executed in a DB2 subsystem.
The collected data is then summarized and stored for analysis. This method of collecting data provides detailed information about the performance and resource usage of DB2 applications, while avoiding the costly overhead and large volumes of data that is associated with other DB2 performance aids.
CA Mainframe Application Tuner collects data from DB2 internal objects and the DB2 catalog. Beginning with version 8.1, DB2 maintains some character information in UNICODE. This data is stored using a code page of 1208, which is similar to ASCII for characters with a numeric representation below 128.
In order to convert this information to a more readable EBCDIC format, CA Mainframe Application Tuner provides the ability to convert code page 1208 to one of the following code pages:
-1, 37, 273, 274, 277, 278, 280, 281, 284, 285, 297, 500, 871, and 1047
The code page specified should match that of the DB2 subsystems that will be monitored. To specify the code page in the TUNSSP00 member, use the following parameter described next:
UNICODE translation code page.
Translate data from UNICODE code page 1208 into the code page specified.
Supported code page values are -1, 37, 273, 274, 277, 278, 280, 281, 284, 285, 297, 500, 871, and 1047.
The default is DB2TCSID=-1. (-1 is equivalent to code page 37.)
CA Mainframe Application Tuner uses three methods of data collection to obtain DB2 data:
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |