CA MAT can gather and display data from SQL statements. The gathered data provides valuable information about performance and resource use of DB2 applications. With CA MAT, you do not require expensive DB2 SQL traces to gather data. CA MAT 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 MAT 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.
CA MAT automatically converts this information to a more readable EBCDIC format.
CA MAT uses three methods of data collection to obtain DB2 data:
|
Copyright © 2012 CA Technologies.
All rights reserved.
|
|