Zurück
-
Titel
What is the difference between the three "SQL text size" fields in the DB2 agent properties? -
Beschreibung
There are three different "SQL text size" fields in the DB2 agent status properties, what are they used for?
Top SQLsSQL text size (bytes)Current agents detailsSQL text size (bytes)History Locks Waits DetailsSQL text size (bytes) -
Lösung
Each SQL text size field corresponds to a different area in the DB2 agent drilldowns.
- The Top SQLs value sets the length for the SQL statements captured and displayed in Homepage | Activity | Top SQL.
- The Current Agents value sets the length for the SQL statements captured and displayed in Homepage | Activity | Current Agents.
- The History Locks value sets the length for the SQL statements captured and displayed in Homepage | Activity | Locks.
Increasing the SQL size should not cause performance issues but it may have lead to memory issues in cases where the FglAM doesn't have enough memory since the memory cache will maintain more data if the values are increased.