PI90659: GLOBAL SELMSG DDNAME IGNORED WHEN SAME DDNAME IS SET FOR PROCMSG

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When the parameters PROCMSG and SELMSG are set to the same
  ddname, distinct from the value 'SYSPRINT', the messages related
  to SELMSG (i.e. INZX089 and INZX090) are sent by WTO.
  
  PB51087
  

Local fix

• none but consider specifying GLOBAL PROCMSG SYSPRINT and SELMSG
  SYSPRINT or use two different ddname for PROCMSG and SELMSG
  parameters to avoid the messages to be issued by WTO.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of High Perfornance Unload                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When the parameters PROCMSG and SELMSG are set to the same   *
  *                                                              *
  * ddname, distinct from the value 'SYSPRINT', the messages     *
  * related                                                      *
  * to SELMSG (i.e. INZX089 and INZX090) are sent by WTO.        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the PTF for problem resolution                         *
  ****************************************************************
  This package includes fixes for the following APARs:
  
  PI90986:
  In the CA OUTPUT FORMAT VARIABLE, all the null indicators (one
  byte for each nullable
  column to tell if the column contains a NULL value or not) are
  located all together at the
  beginning of the record, before all the columns.
  This is something that we cannot do in the HPU syntax, simply
  because the only possibility
  is to say that the null indicator is either just before or just
  after the column itself.
  This is possible with CA compatibility syntax but not with HPU
  "native" syntax.
  
  
  PI88371:
  DB2 HPU repeatedly allocates the LOB auxiliary table spaces
  during the unload which lead
  to low performance of the unload process. This occurs when the
  LOB table space associated
  to the LOB column involved in the unload, processed in native
  mode, is a multi-LDS one.
  
  
  PI88226:
  An unload of the data from an image copy (COPYDDN) fails after
  the following message has
  been issued.
  
  IKJ56228I FILE HPU00000 NOT IN CATALOG OR CATALOG CAN NOT BE
  ACCESSED
  
  This occurs if either of the following structure mismatches
  exist between the table space,
  the image copy was taken for, and the online table space
  involved the unload:
  - The copied table space was not partitioned while the
    current table space is partitioned
  - the copied table space was not a partition-by-growth
    table space while the current table space is
  
  
  PI89751:
  An unload fails with error message INZU016E in the following
  case:
  The sysin contains the "not" character and this same character
  has a different hexadecimal
  value when encoded in the DB2 subsystem SBCS CCSID.
  
  
  PI91165:
  After the fix for APAR PI90051 (PTF HZ4851H) has been applied,
  an unload requesting LOB
  data be unloaded into an output data set in spanned format
  (SPANNED YES option applies)
  fails with IEC020I 001-1. This occurs only if the  amount of
  unloaded and formatted data
  is less than 2 cylinders, i.e. 1.6 MB
  

Problem conclusion

• Code has been changed to fix this problem
  

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:

  UI52812

Modules/Macros

• INZTDSC  INZ$$PRM INZUTILK INZTVAR
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI77713

     UP21/10/30 P F110

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.