PM00540: -99999 ERROR IN PREDICATE TABLE FOR ANY LITERAL VALUE THAT IS LONGER THAN 256 BYTES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• -99999 error in predicate table for any literal value that is
  longer than 256 bytes
  
  DB2INCORR/K
  

Local fix

• No Work Around
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 for z/OS users of EXPLAIN.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: Malformed text may appear in the TEXT   *
  *                      column of DSN_PREDICAT_TABLE or the     *
  *                      NODE_DATA column of DSN_QUERY_TABLE     *
  *                      when a literal value in the EXPLAIN     *
  *                      statement exceeds 256 bytes. A side     *
  *                      effect of this malformed text is that   *
  *                      the user may run into a SQL error with  *
  *                      SQLCODE -99999 when using               *
  *                      Visual Explain/OSC/OE. Detailed error   *
  *                      information may show a Java             *
  *                      MalformedInputException error.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Malformed text may appear in the TEXT column of
  DSN_PREDICAT_TABLE or the NODE_DATA column of DSN_QUERY_TABLE
  when a literal value in the EXPLAIN statement exceeds 256 bytes.
  
  An example of an EXPLAIN statement that will cause the malformed
  text is:
  
  EXPLAIN ALL FOR
  SELECT *
  FROM T1
  WHERE C1 = <Literal>;  //Where <Literal> exceeds 256 bytes
  
  Any program that utilizes the value in the TEXT column of
  DSN_PREDICAT_TABLE or the NODE_DATA column of DSN_QUERY_TABLE
  may run into an error due to the malformed text.
  
  The malformed text occurred because a buffer was not large
  enough to handle literal values larger than 256 bytes.
  
  Additional keywords:
  SQLEXPLAIN SQLCODE99999
  

Problem conclusion

• DB2 code has now been changed to properly handle literal values
  larger than 256 bytes when using EXPLAIN.
  

Temporary fix

Comments

APAR Information

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

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

  UK53315 UK53317

Modules/Macros

• DSNXODTX
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK53315

     UP10/01/19 P F001

• R910 PSY UK53317

     UP10/01/19 P F001

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.