PK05010: INZI006E NO CONVERSION WAS AVAILABLE BETWEEN CCSID NN AND CCSID MMM WHERE THIS CONVERSION IS SHOWN IN DB2 SYSSTRINGS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• MSGINZI006E NO CONVERSION WAS AVAILABLE BETWEEN CCSID NN AND
  MMM WHERE THIS CONVERSION IS SHOWN IN DB2 SYSSTRINGS.
  After UK01743 or UK01744 HPU no longer checks SYSSTRINGS.
  This apar taken to correct this.
  

Local fix

• ADDITIONAL SYMPTOMS:
  1) Wrong output when a column defined with a FIELDPROC + a
     parameter list, is selected. The fieldproc is not applied to
     decode the data before writing the output record. PB 6696
  2) Incorrect CCSID for date, time or timestamp fields when
     unloading data with CCSID translation and select is performed
     through DB2 (DB2 FORCE or DB2 YES with unsupported select)
     PB 7084
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: - MSGINZI006E NO CONVERSION WAS         *
  *                      AVAILABLE BETWEEN CCSID NN AND MMM      *
  *                      WHERE THIS CONVERSION IS SHOWN IN DB2   *
  *                      SYSSTRINGS.                             *
  *                      After UK01743 or UK01744 HPU no longer  *
  *                      checks SYSSTRINGS.                      *
  *                      This apar taken to correct this.        *
  *                      PB 7061                                 *
  *                      ADDITIONAL SYMPTOMS:                    *
  *                      1- Wrong output when a column defined   *
  *                       with a FIELDPROC + a parameter list,   *
  *                       is selected. The fieldproc is not      *
  *                       applied to decode the data before      *
  *                       writing the output record. PB 6696     *
  *                      2- Incorrect CCSID for date, time or    *
  *                       timestamp fields when unloading data   *
  *                       with CCSID translation and select is   *
  *                       performed through DB2 (DB2 FORCE or    *
  *                       DB2 YES with unsupported select)       *
  *                       PB 7084                                *
  *                      3- HPU cannot support an ORDER BY or    *
  *                       ORDER CLUSTER on a column that is      *
  *                       defined with a fieldproc.  Before the  *
  *                       fix, the data was sorted on the        *
  *                       decoded values. DB2 sorts the data on  *
  *                       the encoded values. PB6697             *
  *                      After the fix (PP99262):                *
  *                      - for ORDER BY                          *
  *                      - if DB2 YES is specified, the SELECT   *
  *                       is processed by DB2                    *
  *                      - if DB2 NO is specified then a message *
  *                       INZU186E is issued and processing      *
  *                       stops                                  *
  *                      - for ORDER CLUSTER                     *
  *                      - Message INZU186E is always issued and *
  *                       processing stops                       *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  

Problem conclusion

• - oqueryGetSysstrings() function in inzquery was modified in
   order to take available conversions into account
  1- Function inzbabDetermineEctAfppv() was changed to process
   correctly the fieldproc parameters.
  2- inzctrl module was fixed.
  3- Function inzcontrolOrderBy() was changed to ckeck if an
   order by is required on columns with fieldproc.
   Module Inzmsgs was changed to add error message INZU186E.
  

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:

  UK03257 UK03258

Modules/Macros

•    INZCRXSM INZQRYV8 INZQUERY INZRSAVE INZSBIND
  INZUTILB INZUTISK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R210 PSY UK03257

     UP05/05/13 P F505

• R220 PSY UK03258

     UP05/05/13 P F505

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.