PK98700: SQLCODE -331 WITH CORRUPTED DATA.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• HPU is getting the following error message:
  DSNT408I SQLCODE = -331, ERROR:  CHARACTER CONVERSION CANNOT BE
  PERFORMED BECAUSE A STRING, POSITION 3, CANNOT BE CONVERTED
  FROM 935 TO 500, REASON 16
  This occurs because the DSNEXIT library declared in the HPU
  parmlib is not APF authorized.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following are V310 and V320...      *
  *                                                              *
  *                      1. When the DSNEXIT library pointed to  *
  *                      by parmlib variable VZD007 is not an    *
  *                      APF library, HPU cannot load the        *
  *                      DSNHDECP from this library, and the     *
  *                      system automatically loads the          *
  *                      DSNHDECP from the LINKLIST, if one      *
  *                      exists. This can generate different     *
  *                      kinds of problems, because the          *
  *                      DSNHEDCP is used to get the CCSIDs,     *
  *                      the format of the date and time, the    *
  *                      MIXED attribute, the decimal point and  *
  *                      other parameters required by HPU to     *
  *                      process the unload.                     *
  *                      This APAR changes this behavior, and    *
  *                      if the DSNEXIT listed in parmlib is     *
  *                      not APF, an abend S306-0C with message  *
  *                      CSV019I REQUESTED MODULE DSNHDECP NOT   *
  *                      ACCESSED, IS IN NON-APF                 *
  *                      LIBRARY/CONCATENATION will now be       *
  *                      issued, thus avoiding getting           *
  *                      incorrect output data or processing     *
  *                      errors.                                 *
  *                      PB 10313                                *
  *                                                              *
  *                      The following are V320 only...          *
  *                                                              *
  *                      2. When unloading from an image copy    *
  *                      made on a clone table, HPU finds no     *
  *                      rows, and issues error message:         *
  *                      INZRE45 IMAGE COPY FROM DD IC00         *
  *                       CONTAINS NO ROW WITH SPECIFIED         *
  *                       OBID(S), SCAN ABORTED                  *
  *                      PB 10253                                *
  *                      3. Error message INZU021E UNSUPPORTED   *
  *                      CONVERSION DECFLOAT TO CHAR is issued   *
  *                      when trying to unload a DECFLOAT        *
  *                      column in external format, either       *
  *                      using FORMAT EXTERNAL or an INTO        *
  *                      specification that converts the         *
  *                      DECFLOAT into a CHAR field.             *
  *                      PB 10302                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. Module odb2ctrl was changed to issue an abend S306-0C when
  the DSNEXIT specified in the parmlib is not APF, instead of
  loading the DSNHDECP module.
  2. Modules inzpabf and inzrstat were changed to process
  correctly the OBID of a clone table which high order bit is set.
  3. Modules inzctrl and inzgcxtr were changed to support
  conversion of DECFLOAT data into external representation.
  

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:

  UK52951 UK52952

Modules/Macros

•    INZT01   INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R310 PSY UK52951

     UP09/12/24 P F912

• R320 PSY UK52952

     UP09/12/24 P F912

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.