PK21731: DYNAMIC SQL STATEMENT TRUNCATED AFTER REACHING 5000 (DECIMAL) BYTES.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DYNAMIC SQL STATEMENT TRUNCATED AFTER REACHING 5000 (DECIMAL)
  BYTES.
  
  When customer goes into Thread History to display the dynamic
  SQL statement, in spite of specifying LROWS=9999, the SQL
  statement is still truncated.
  
  Explanation: the dynamic SQL statement text is obtained through
  IFCID 63, which has a limit of 5000 (decimal) bytes. See the
  comments in SDSNMACS(DSNDQW01):
  
  NOTE: THE MAXIMUM LENGTH OF ANY TRACE FIELD IS 5000 (DECIMAL)
  BYTES.  THEREFORE, THE USER SHOULD BE AWARE THAT THE SQL
  STATEMENT AT THE END OF IFCID 63 WILL BE TRUNCATED
  AFTER REACHING 5000 (DECIMAL) BYTES.
  
  In case you want to see the full SQL statement, you have two
  options: If the statement is in the dynamic statement cache,
  you can use IFCID 317 to retrieve the full SQL statement through
  the READS interface of the IFI.  If the statement is not in the
  dynamic statement cache, you can use the new IFCID 350.  Unlike
  IFCID 63, it contains the full SQL statement text.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM V310            *
  *                 users of component:                          *
  *                 -   Classic Interface                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Only the first 5000 characters of       *
  *                      dynamic SQL text was being shown on     *
  *                      real-time and Near Term History         *
  *                      displays.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The program has been enhanced to use IFCID 317 to display
  the full SQL text in real-time and optionally use IFCID 350
  in Near Term History to get the complete SQL text.
  ---------------
  SYSMOD TITLE: Display Full SQL text for DB2 V8
  KEYWORDS:     ZHTCALL ZSQL SQL TEXT TRUNCATED
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  OA14264

• APAR is sysrouted TO one or more of the following:

  UK14160

Modules/Macros

•    HKDB310J KO2ACAPS KO2ACAP2 KO2ATRCB KO2CMVSC
  KO2CMVSF KO2CNSRB KO2CNTPS KO2CNTP2 KO2CTEXB KO2CTHIS KO2CTHI2
  KO2DAUDS KO2DAUD2 KO2DDSBS KO2DDSB2 KO2DMSCS KO2DMSC2 KO2DTHDS
  KO2DTHD2 KO2DXSTB KO2DXS1S KO2DXS12 KO2DXS2S KO2DXS22 KO2HDTIB
  KO2HDTPB KO2HINTB KO2HPRCB KO2HPR1B KO2HPR2B KO2HSQIB KO2HSQPB
  KO2HVINB KO2HWLMB KO2ICOLS KO2ICOL2 KO2IINTB KO2LCAPB KO2MSBDB
  KO2MSB1B KO2MSB2B KO2MSB3B KO2MSB4B KO2MSUMB KO2OH2IB KO2ONTAB
  KO2OTEXB KO2OTHDB KO2TSB1B KO2TSB2B KO2TSB3B KO2TSB4B KO2WGETB
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSY UK14160

     UP06/05/10 P F605

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.