PI50478: DB2 ADMINISTRATION TOOL U.L FUNCTION SQLCODE=-330, REASON 16

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Using line command U.L may result in SQLCODE=-330, REASON 16
  The INSERT INTO SESSION.DB2T002 value X'00000000010EAC756FA3'
  The X'0E' is interpreted as shift-out character, but is just
  hex data.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who set MIXED=YES in the            *
  *                 DSNHDECP module on a DB2 subsystem.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following are fixed:                *
  *                                                              *
  *                      1- When using the 'U.L - Load           *
  *                      Utility (input created by U)' line      *
  *                      command on panel ADB21T                 *
  *                      'Tables, Views, and Aliases'            *
  *                      a SQLCODE-330 / SQLCODEN330             *
  *                      error is received if a non-numeric      *
  *                      (such as, char with for bit data)       *
  *                      column in the DB2 catalog table         *
  *                      SYSIBM.SYSTABLES contains a             *
  *                      HEX value of X'0E' ( the shift-out      *
  *                      character ):                            *
  *                                                              *
  *                      DSNT408I SQLCODE=-330,                  *
  *                      ERROR:A STRING CANNOT                   *
  *                      BE USED BECAUSE IT CANNOT               *
  *                      BE PROCESSED.  REASON 16,               *
  *                      CHARACTER , HOST VARIABLE               *
  *                      DSNT418I SQLSTATE = 22021               *
  *                      SQLSTATE RETURN CODE                    *
  *                                                              *
  *                      2- An internal SQL statement failed     *
  *                      with SQLCODE =-206 / SQLCODEN206        *
  *                      error due to the specification of       *
  *                      a column name in lower case when        *
  *                      building the statement:                 *
  *                                                              *
  *                      DSNT408I SQLCODE = -206,                *
  *                      ERROR: c.default IS NOT VALID           *
  *                      IN THE CONTEXT                          *
  *                      WHERE IT IS USED                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  1- If MIXED=YES is used, a HEX value of  x'0E' ( the shift-out
  character ) without a matching HEX value of x'0F' ( the
  shift-in character ) will result in a SQLCODE=-330 /
  SQLCODEN330.
  
  2- An internal SQL statement contains text in lower case and it
  is not parsed correctly by DB2.
  

Problem conclusion

• The following problems have been resolved:
  
  1- The problem has been fixed by converting the string to HEX.
  
  2- The text is converted to uppercase.
  

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:

  UI33948 UI33949

Modules/Macros

•    ADBMAIN  ADB2UT0
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI33948

     UP15/12/23 P F512

• RB20 PSY UI33949

     UP15/12/23 P F512

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.