PM84164: A NON SUPPORTED STATEMENT OR A STATEMENT PASSED TO DB2 USING DB2FORCE IS REJECTED WITH EITHER SQLCODE = -311 OR SQLCODE = -010

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A non supported statement or a statement passed to DB2 using
  DB2 FORCE is rejected with either SQLCODE
  
  DSNT408I SQLCODE = -311, ERROR:  THE LENGTH OF INPUT HOST
  VARIABLE NUMBER 001 IS NEGATIVE OR GREATER THAN THE MAXIMUM
  or
  DSNT408I SQLCODE = -010, ERROR:  THE STRING CONSTANT
  BEGINNING 'AAAAAAAAà IS NOT TERMINATED
  
  This occurs when the prepared statement is longer than 32kb,
  as apparently the type of host variable used for the PREPARE
  is a VARCHAR. Since DB2 V9 prepared statements can be longer
  (up to 2mb) but require to use a CLOB string instead of the
  varchar.
  
  PB11864
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: A non supported statement or a          *
  *                      statement passed to DB2 using DB2       *
  *                      FORCE is rejected with either SQLCODE   *
  *                      DSNT408I SQLCODE = -311, ERROR:  THE    *
  *                       LENGTH OF INPUT HOST VARIABLE NUMBER   *
  *                       001                                    *
  *                       IS NEGATIVE OR GREATER THAN THE        *
  *                       MAXIMUM                                *
  *                                                              *
  *                      or                                      *
  *                                                              *
  *                      DSNT408I SQLCODE = -010, ERROR:  THE    *
  *                       STRING CONSTANT BEGINNING 'AAAAAAAA    *
  *                       IS NOT TERMINATED                      *
  *                      This occurs when the prepared           *
  *                      statement is longer than 32Ko, as       *
  *                      apparently the type of host variable    *
  *                      used for the PREPARE is a VARCHAR.      *
  *                      Since DB2 V9 prepared statements can    *
  *                      be longer (up to 2mb) but require to    *
  *                      use a CLOB string instead of the        *
  *                      varchar.                                *
  *                      pb 11864                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzcrxsm, inzcrxsq, infoutil  and inzpab  modules were
  fixed.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK93297 UK93298 UK93299

Modules/Macros

•    INZCRXSM INZCRXSQ INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R320 PSY UK93297

     UP13/04/16 P F304

• R410 PSY UK93298

     UP13/04/16 P F304

• R420 PSY UK93299

     UP13/04/16 P F304

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.