Meaning of Derivation TRUNCAT on the SQLTEXT screen.

book

Article ID: 49183

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

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.

Environment

Release:
Component: CIDB