PI90666: DB2 VERSION WRONGLY DETERMINED BY HPU IF THE UNLOAD IS DONE IN DATASHARING FROM THE SSID OF THE GROUP

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When it is run against a datasharing group, although DB2 HPU
  correctly displays the DB2 version via the INZI020I message, it
  actually handles a wrong DB2 version which leads to subsequent
  issues whenever DB2 HPU internal features or the user unload
  involve DB2 version dependent processing.
  
  PB51073  Z626
  

Local fix

• run the unload aganst a member of the datasharing group.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of High Performance Unload                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * PI89113:                                                     *
  * A table defined through a LISTDEF statement and that         *
  * fulfills one of the following conditions:                    *
  * - it has a clone table and CLONED YES is specified           *
  * - it is an history table                                     *
  * - it is a materialized query table                           *
  * is unduly not unloaded by DB2 HPU/InfoUnload without any     *
  * explanation message.                                         *
  *                                                              *
  * PI90666:                                                     *
  * When it is run against a datasharing group of a non-NFM DB2  *
  * version, although DB2 HPU correctly displays the DB2 version *
  * via the INZI020I.message, it actually handles a wrong DB2    *
  * version which leads to subsequent issues whenever DB2 HPU    *
  * internal features or the user unload involve DB2 version     *
  * dependent processing.                                        *
  * When a DB2 version 11 is involved, messages such as the      *
  * folowing ones are issued:                                    *
  *    INZI193E DB2 ERROR: {DB2 FOR OS/390}{ODBC                 *
  * DRIVER}{DSN11010}                                            *
  *    DSNT408I SQLCODE = -4700, ERROR: ATTEMPT TO USE NEW       *
  *    FUNCTION BEFORE NEW FUNCTION MODE                         *
  *    DSNT418I SQLSTATE = 56038 SQLSTATE RETURN CODE            *
  * are issued and DB2 HPU stops with completion code 8.         *
  *                                                              *
  * PI91110:                                                     *
  * The message INZCI0559 message expected in the file allocated *
  * under the HPUPRINT optional ddname is not issued. As a       *
  * consequence, nothing is written to this ddname.              *
  *                                                              *
  * PI92093:                                                     *
  * An ABENDU1013 can occur when unloading a table having an     *
  * EDITPROC, in native mode. As it is due to a lack of memory   *
  * initialisation, no accurate condition when the problem       *
  * accours can be determined.                                   *
  *                                                              *
  * PI92094:                                                     *
  * HPU supports to generate a list of objects - 'LISTDEF        *
  * listname INCLUDE TABLESPACES TABLE owner.tbname' - that is   *
  * later used in the UNLOAD.                                    *
  * But, there is no support to generate a list for DB2 views    *
  * using LISTDEF.                                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the PTF for problem resolution                         *
  ****************************************************************
  

Problem conclusion

• Code has been changed to fix this problem
  

Temporary fix

• PI89113:
  The concerned table can be unloaded by explicitly specifying it
  in the FROM clause of the SELECT statement.
  
  PI90666:
  Run the unload aganst a member of the datasharing group.
  
  PI91110:
  Consider using the more flexble SELMSG feature instead. By
  specifying SELMSG HPUPRINT, you can get INZX090 messages in the
  HPUPRINT data set. These messages give the same information as
  INZCI0559 with a different format. The INZX090   is formatted as
  follows:
    INZX090  n RECORDS WRITTEN [IN hh:mm:ss][,INTERVAL hh:mm:ss],
  UNLOAD DONE.
  
  while INZCI0559 is formatted as follows:
    INZCI0559 DDNAME : ddname ROWS : number
  
  PI92093:
  Use the SQL mode by specifying DB2 FORCE.
  

Comments

APAR Information

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

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

  UI53275

Modules/Macros

• INZ$$PRM INZUTILK INZTVAR
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI53275

     UP18/01/23 P F801

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.