PK15319: MSGINZI152E WHEN RUNNING HPU UNLOAD POINTING TO A DB2 SSID THAT IS NOT STARTED. 05/12/07 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1. Message INZI152E when accessing a Datasharing GROUP name and
  when DISPLUSR=INSTALL_SYSOPR    PB 7645
  2. IEC161I 066-053 if SYSREC not catalogued with a dsname
     corresponding to an existing entry in the Catalog.
     PB 7626
  3. Message INZI006E No Conversion Was Available Between CCSID
     00002 And CCSID 1144 issued with strange values for the first
     CCSID   PB 7649
  4) If the HPU UNLOAD is coded with outddn pointing to a
     sysrec dd with DISP=(new,keep,) and with a specific
     volser coded ( and not SMS managed to override the
     specific volser ) then HPU may not follow the proper
     ICF Catalog search sequence. MSGIEC161I 066-053 may be
     seen. IEC161I RC66 RC066 RC053 RC53 RSN053 RSN53
  5. HPU job ends with msgINZU063I and sqlcode -199.
     This is the PE against UK09167. PB 7671.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Message INZI152E when accessing a    *
  *                       Datasharing GROUP name and when        *
  *                       DISPLUSR=INSTALL_SYSOPR                *
  *                       PB 7645                                *
  *                      2. EC161I 066-053 if SYSREC not         *
  *                       catalogued with a dsname               *
  *                       corresponding to an existing entry     *
  *                       in the Catalog.                        *
  *                       PB 7626                                *
  *                      3. Message INZI006E No Conversion Was   *
  *                       Available Between CCSID 00002 And      *
  *                       CCSID 1144 issued with strange values  *
  *                       for the first CCSID.                   *
  *                       PB 7649                                *
  *                      4. If the HPU UNLOAD is coded with      *
  *                       outddn pointing to a sysrec dd with    *
  *                       DISP=(new,keep,) and with a specific   *
  *                       volser coded ( and not SMS managed to  *
  *                       override the specific volser ) then    *
  *                       HPU may not follow the proper ICF      *
  *                       Catalog search sequence. MSGIEC161I    *
  *                       066-053 may be seen. IEC161I RC66      *
  *                       RC066 RC053 RC53 RSN053 RSN53          *
  *                       PB 7626                                *
  *                      5. HPU job ends with SQLCODE -199.      *
  *                       PB 7671                                *
  *                      6. The null byte that should be         *
  *                       present in the output data is not      *
  *                       generated when a constant is           *
  *                       selected, a null indicator is added    *
  *                       with a NULLID YES (HPU syntax) or      *
  *                       NULL (CA/Fastunload syntax) keyword,   *
  *                       and one of the following is true:      *
  *                       - a numeric or character constant is   *
  *                       selected and converted into a numeric  *
  *                       data type.                             *
  *                       - a character constant which data      *
  *                       type is not changed by a forced        *
  *                       conversion.                            *
  *                       PB 7659                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. Module inzmain was changed to use the SSID instead of the
   connection ID to read the userid corresponding to the
   INSTALL_SYSOPR in DB2 control blocks.
  2. Module udbifs00 was changed. When a non cataloged file is
   used as output, HPU doesn't issue a SVC 26 (listcat) to check
   if the file is VSAM, and considers that the file is QSAM.
  3. Module inznode was changed to set correctly the CCSID of
   the date/time expression passed to the CHAR or VARCHAR
   function.
  4. Module udbifs00 was changed. When a non cataloged file is
   used as output, HPU doesn't issue a SVC 26 (listcat) to check
   if the file is VSAM, and considers that the file is QSAM.
  5. Modules inzhyacc, inzpyacc and inzfyacc were changed to
   extract correctly the unsupported SELECT statement.
  6. Module inzbab was changed to add the null indicator in
   the value of the unloaded constant.
  

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:

  UK10092 UK10093

Modules/Macros

•    INZRSAVE INZUTILB INZUTISK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R210 PSY UK10092

     UP05/12/21 P F512

• R220 PSY UK10093

     UP05/12/21 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.