search cancel

Meaning of Derivation TRUNCAT on the SQLTEXT screen.


Article ID: 49183


Updated On:


RC Compare for DB2 for z/OS Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS Subsystem Analyzer for DB2 for z/OS Database Analyzer for DB2 for z/OS Fast Unload for DB2 for z/OS Fast Check for DB2 for z/OS Fast Index for DB2 for z/OS Rapid Reorg for DB2 for z/OS



Explain the meaning of status(Derivation) of TRUNCAT on the R/SQLTEXT Currently Executing screen. Is this size limit changeable?


The value "TRUNCAT" means that only the first 4K of the statement was available. The size limit is not changeable, because Insight for DB2(IDB2) is using information in an IBM control block. If you look at DB2.DB2A10.SDSNMACS(DSNDQW01) and find "QW01242" in column 1, you'll see the doc on it. If we find that the statement is truncated, we try to get the full statement text from other IBM control blocks but it may no longer be available. For example, you hit enter on the SQLTEXT screen and we get a truncated statement. By the time we realize this, and go to find the full statement text, the statement may have completed and a new statement is in the DB2 control blocks. Then we put out the truncated text.

IFCID 124 only supports 4000 bytes of text and may be the only text we have available. IFCID 124 is the record we obtain when you select a thread from the active threads list and try to display the SQL text.


Component: CIDB