PK17548: ERROR RUNNING INZT02: THE MEMBER INZDB21X CANNOT BE WRITTEN INTO THE LIBRARY AAA.BBB.SINZSAMP. INZTVAR VUU027 LONGER THAN 37 CHAR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When running the INZT02 clist to create INZUTIL from INZTVAR
  variables receive message:
  The member INZDB21X cannot be written into the library
  aaa.bbb.sinzsamp.
  This error is received if INZTVAR variable VUU027 is coded
  longer than 37 characters.
  ADDITIONAL SYMPTOMS:
  1) MSGINZU063I UNSUPPORTED SELECT:
     when processing DBCS characters. PB 7514
  2) When using FASTUNLOAD syntax. Missing tag when
     ONE-SYSREC is generated and AUTO-TAG is not specified.
     PB 7781
  3) Error message during the execution of INZT02 concerning
     the generation of member INZDB21X. This occures when
     variable VUU027 is too long.  PB 7742
  4) Incorrect output as HPU Unloads data from FLOAT
     COLUMNS. It occurs with NEGATIVE float values.
     PB 7814
  

Local fix

• Code VUU027 less than 37 characters or blank out the setting
  of VUU020.  PB 7742
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: - When running the INZT02 clist to      *
  *                      create INZUTIL from INZTVAR variables   *
  *                      receive message:                        *
  *                      The member INZDB21X cannot be written   *
  *                      into the library aaa.bbb.sinzsamp.      *
  *                      This error is received if INZTVAR       *
  *                      variable VUU027 is coded longer than    *
  *                      37 characters. PB 7742                  *
  *                      ADDITIONAL SYMPTOMS:                    *
  *                      1- MSGINZU063I UNSUPPORTED SELECT:      *
  *                      when processing DBCS characters.        *
  *                      PB 7514                                 *
  *                      2- When using FASTUNLOAD syntax.        *
  *                      Missing tag when ONE-SYSREC is          *
  *                      generated and AUTO-TAG is not           *
  *                      specified.  PB 7781                     *
  *                      3- Error message during the execution   *
  *                      of INZT02 concerning the generation of  *
  *                      member INZDB21X. This occures when      *
  *                      variable VUU027 is too long.  PB 7742   *
  *                      4- Incorrect output as HPU Unloads      *
  *                      data from FLOAT COLUMNS. It occurs      *
  *                      with NEGATIVE float values. PB 7814     *
  *                      5- The unloaded data is incorrect when  *
  *                      unloading from a non EBCDIC tablespace  *
  *                      a GRAPHIC column, and when a            *
  *                      conversion to a CHAR MIXED EBCDIC is    *
  *                      requested. PB 7521                      *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  - Skeleton inzdb2sk was changed to avoid the error when using
  the file tailoring.
  1- Modules Ocnvft and Infconv were changed to process correctly
  the CUNBCPRM_Subcodepage flag when calling function
  cnvftConvertFromCUN() to convert from unicode to EBCDIC mixed.
  2- Module inzctrlf was changed to generate by default AUTOTAG
  1 and to set the format of the autotag to character instead of
  binary.
  3. Skeleton inzdb2sk was changed to avoid the error when using
  the file tailoring.
  4- Module UDBCRFEL was changed. The test of the high order bit
  was incorrectly done on the value in DB2 internal format.
  5- Module INZBAB and INFCONV were changed to process correctly
  the conversion from ASCII or UNICODE GRAPHIC to EBCDIC mixed.
  

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:

  UK11412 UK11413

Modules/Macros

•    INZDB2SK INZUTILB
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R210 PSY UK11412

     UP06/02/07 P F602

• R220 PSY UK11413

     UP06/02/07 P F602

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.