Meaning of Derivation TRUNCAT on the Sysview for Db2 SQLTEXT screen.

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Explain the meaning of status(Derivation) of TRUNCAT on the Sysview for Db2 for z/OS (IDB2) R/SQLTEXT Currently Executing screen.
Is this size limit changeable?

Resolution

The value "TRUNCAT" means that only the first 4K of the statement was available. The size limit is not changeable, because IDB2 is using information in an IBM control block.
If you look at hlq.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. Thus 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.