PH52437: ADMIN TOOL: "SQLCODE = -331, ERROR: CHARACTER CONVERSION ERROR PANEL ADB21K LINE CMD KC, ON A PACKAGE CREATED IN DB2 Z/OS V13

APAR status

• Closed as program error.

Error description

• Admin Tool: "SQLCODE = -331, ERROR: CHARACTER CONVERSION CANNOT
  BE PERFORMED" occurs when panel ADB21K line command KC is used
  on a Package created in Db2 V13.
  
  
  DESCRIPTION:
  
  When panel ADB21K line command KC is used on a Package created
  in Db2 V13, the following error occurs:
  
  
  
   DSNT408I SQLCODE = -331, ERROR:  CHARACTER CONVERSION CANNOT BE
        PERFORMED BECAUSE A STRING, POSITION 4, CANNOT
        BE CONVERTED FROM 1208 TO 285, REASON 16
  
  
   DSNT418I SQLSTATE   = 22021 SQLSTATE RETURN CODE
   DSNT415I SQLERRP    = DSNXROHB SQL PROCEDURE DETECTING ERROR
   DSNT416I SQLERRD    = -117  0  0  -1  0  0 SQL DIAGNOSTIC
         INFORMATION
   DSNT416I SQLERRD    = X'FFFFFF8B'  X'00000000'  X'00000000'
         X'FFFFFFFF'
         X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION
  

Local fix

• na
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQL code -331 might occur               *
  *                      when using line command KC on           *
  *                      panel ADB21K.                           *
  ****************************************************************
  When using line command KC on panel ADB21K for a
  package created from Db2 13, the following error might occur:
  DSNT408I SQLCODE = -331, ERROR: CHARACTER CONVERSION CANNOT BE
  PERFORMED BECAUSE A STRING, POSITION 4, CANNOT BE CONVERTED FROM
  1208 TO 285, REASON 16
  

Problem conclusion

• The problem has been resolved.
  

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:

  UI91588

Modules/Macros

• ADB21K
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UI91588

     UP23/06/01 P F305