PK66467: SQLCODE -805 EXECUTING INZHPU 08/07/28 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DSNT408I SQLCODE = -805 is issued when executing CLIST INZHPU.
  ADDITIONAL SYMPTOMS:
  1) INZU134E SYNTAX ERROR - INVALID CORRELATION-NAME WITH UR.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: For HPU220 and HPU310:                  *
  *                      1. Abend S0C4can occur when parmlib     *
  *                      variable VUM027/SQLACCES is set to YES  *
  *                      and an error occurs on a SELECT made    *
  *                      on the DB2 catalogue (for example an    *
  *                      SQLCODE -904 because of a ressource     *
  *                      unavailable). PB 9327                   *
  *                      For HPU310:                             *
  *                      2. SQLCODE -805 on package INZQRYV8     *
  *                      occurs under ISPF in V8 CM. This is     *
  *                      beacuse the ISPF application doesn't    *
  *                      issue a DISPLAY GROUP to get the        *
  *                      execution mode (CM / ENFM / NFM),       *
  *                      considers that the DB2 subsystem is in  *
  *                      NFM, and tries to use a module that is  *
  *                      V8 NFM only. PB 9320                    *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. Modules inzcat and inzctrl were changed to interpret the
  SQLCODE that occurs when reading the DB2 catalog in SQL.
  2. Module UNLECME and inzquery were changed to access to the
  value of parmlib variable VZD014 to get the running mode in DB2
  V8. Skeleton INZUTISK is changed to generate a new DBMDxxxx
  variable corresponding to variable VZD014 for each SSID defined
  in VZD001.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

Comments

• ž**** PE08/09/15 FIX IN ERROR. SEE APAR PK72110  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK39074 UK39075

Modules/Macros

•    INZRSAVE INZUTILB INZUTISK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R220 PSY UK39074

     UP08/08/23 P F808

• R310 PSY UK39075

     UP08/08/23 P F808

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.