Meaning of Derivation TRUNCAT on the SQLTEXT screen.

Document ID : KB000049183
Last Modified Date : 14/02/2018
Show Technical Document Details

Question: 

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

Answer: 

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.