PI48580: DB2 V11 DDF REQUESTER SQLCODE -332 ERROR: CHARACTER CONVERSION BETWEEN CCSID 0 TO 1208 NOT SUPPORTED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2DDF DB2DRDA defect pi48580 dpi48580
  SQLCODE -332 issued for a DB2 11 DDF thread
  DSNT408I SQLCODE = -332, ERROR:  CHARACTER CONVERSION BETWEEN
  CCSID 0 to 1208 REQUESTED BY DSNXEDP IS NOT SUPPORTE
  DSNT418I SQLSTATE   = 57017 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNXEASC SQL PROCEDURE DETECTING ERROR
  
  NOTE this is a V11 problem only
  ***************************************************************
  Additional Symptoms and Keywords:
   SQLCODE332 SQLCODE -332 SQL332M SQL0332M SQL00332N
   CCSID DSNXEDP DSNXEASC
  

Local fix

• no local fix or workaround
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Distributed Data Facility (DDF) Users.   *
  *                 DB2 11 for z/OS only.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: A DB2 11 for z/OS requestor system may  *
  *                      incorrectly flow a zero SBCS value for  *
  *                      DRDA TYPDEFOVR command data relative    *
  *                      to the attribute of a prepared dynamic  *
  *                      statement.                              *
  *                      If the remote server is also DB2 for    *
  *                      z/OS, the DB2 for z/OS server will      *
  *                      detect SQLCODE -332, indicating that    *
  *                      character conversion between CCSID 0    *
  *                      and 1208 is not supported.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A DB2 for z/OS requestor application attempts to prepare a
  statement with cursor attributes at the remote DB2 for z/OS
  server.  The prepare fails at the DB2 for z/OS server with
  SQLCODE332.
  The DB2 for z/OS server fails to prepare the statement because
  the character conversion for the statement attribute encounters
  an unsupported SBCS CCSID value 0.
  The DB2 11 for z/OS requestor has wrongly determined that the
  application has supplied the ccsid override on the statement
  attribute, when in fact the ccsid override was only supplied
  on the statement alone (not the statement attribute).
  The following example illustrates the scenario:
   EXEC SQL DECLARE :MYSTR1 VARIABLE CCSID 1208;
   EXEC SQL SET :MYSTR1 =
            'SELECT 1 FROM TBPROT71 FOR FETCH ONLY';
   MYSTR2 = 'WITH CS ';
   EXEC SQL CONNECT TO STLEC2;
   EXEC SQL PREPARE STMT1  ATTRIBUTES :MYSTR2 FROM :MYSTR1;
  

Problem conclusion

• DB2 11 for z/OS requestor processing is corrected to flow
  the default ccsid with the dynamic statement attributes
  when the application does not supply the override ccsid in
  the SQLDA for the dynamic statement attribute.
  

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:

  UI34226

Modules/Macros

• DSNLZR00
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI34226

     UP16/01/21 P F601

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.