PH07715: ADDING HPU 5.1 DSNA064C SDSNLOD2 MIG STEPLIB CONCATENATION ERROR SPANNED YES ADB586E IFI WARNING 00E60800 ADB2Z2T2 IFCIDS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR addresses 5 issues:
  Issue #1:
  The Db2 DSNAO64C load module (included in Db2 library SDSNLOD2)
  is required for Db2 HPU 5.1.  However, adding more than one
  library to the Tools Customizer parameter
  'HPU load library' produces the following
  errors upon invocation of DB2
  Administration Tool:
  IKJ56716I EXTRANEOUS INFORMATION
  WAS IGNORED:
  '<hlq>.SDSNLOD2(INZUTILK)'
   IKJ56109I DATA SETS NOT CONCATENATED+
   IKJ56109I COMBINING UNLIKE DATA SET
  ORGANIZATIONS IS INVALID
   IRX0555E The input or output file XGETINFO
  is not allocated. It cannot be opened for I/O.
  IRX0670E EXECIO error while trying to
  GET or PUT a record.
  IKJ56247I FILE XGETINFO NOT FREED,
  IS NOT ALLOCATED
  Also, as a result, the steplib in MIG generated job ADBMGS1
  is erroneously concatenated.
  Issue #2:
  MIG using HPU on LOB objects does not
  generate HPU option SPANNED YES.
  Issue #3:
  The following message is issued on panel
  ADB28M 'Migrate Parameters' when
  'Unload method=H' and
  'Generate template statements=NO':
  ADB586E An UNLDDN template is required
  when SPANNED=YES is set.
  Issue #4:
  When using option Z.2U to display panel
  ADB2Z2U2 "Display/Terminate Utilities",
  only approximately 20 active utilities are shown.
  If more than 20 utilities are active the following
  error message may result:
  DB2 IFI warning, return code= 4,reason code=00E60800
  Issue #5:
  Panel ADB2Z2T2 'Display/Manage Traces' does
  not have the provision to change the IFCIDs
  (trace events) associated with a particular active trace.
  1.  When bringing up Admin Tool, the following errors may occur:
  IKJ56716I EXTRANEOUS INFORMATION WAS IGNORED:
  '<hlq>.SDSNLOD2(INZUTILK)'
  IKJ56109I DATA SETS NOT CONCATENATED+
  IKJ56109I COMBINING UNLIKE DATA SET ORGANIZATIONS IS INVALID
  IRX0555E The input or output file XGETINFO is not allocated. It
  cannot be opened for I/O.
  IRX0670E EXECIO error while trying to GET or PUT a record.
  IKJ56247I FILE XGETINFO NOT FREED, IS NOT ALLOCATED
  2.   When generating JCL for an HPU MIG job, the following
  error in STEPLIB concatenation may occur:
  //STEPLIB  DD  DISP=SHR,DSN='<hlq>SINZLINK'
  '<hlq>DSNLOD2'
  

Local fix

• For issue #1: Add dataset SDSNLOD2 to Db2 Load Libraries field
  in Tools Customizer.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool         *
  *                 and IBM Tools Customizer for z/OS.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: Issue #1:                               *
  *                      Adding more than one library to the     *
  *                      Tools Customizer parameter              *
  *                      'HPU load library' may produce the      *
  *                      following error upon invocation of Db2  *
  *                      Administration Tool:                    *
  *                                                              *
  *                      IKJ56716I EXTRANEOUS INFORMATION        *
  *                      WAS IGNORED...                          *
  *                                                              *
  *                      Also, the STEPLIB in MIG generated job  *
  *                      ADBMGS1 is erroneously concatenated as  *
  *                      a result.                               *
  *                                                              *
  *                      Issue #2:                               *
  *                      MIG using HPU on LOB objects does not   *
  *                                                              *
  *                      Issue #3:                               *
  *                      The following message may be issued     *
  *                      on panel ADB28M 'Migrate Parameters'    *
  *                      when 'Unload method=H' and              *
  *                      'Generate template statements=NO':      *
  *                                                              *
  *                      ADB586E An UNLDDN template is required  *
  *                      when SPANNED=YES is set.                *
  *                                                              *
  *                      Issue #4:                               *
  *                      Panel ADB2Z2U2 "Display/Terminate       *
  *                      Utilities", displays only about 20      *
  *                      active utilities, and if more than      *
  *                      20 utilities are active, the following  *
  *                      error message may appear:               *
  *                      generate HPU option SPANNED YES.        *
  *                                                              *
  *                      DB2 IFI warning, return code= 4,reason  *
  *                      code=00E60800                           *
  *                                                              *
  *                      Issue #5:                               *
  *                      Panel ADB2Z2T2 'Display/Manage Traces'  *
  *                      does not have the provision to change   *
  *                      the IFCIDs (trace events) associated    *
  *                      with a particular active trace.         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Issue #1:
  Adding more than one library to the Tools Customizer
  parameter 'HPU load library' produces the following
  errors upon invocation of DB2 Administration Tool:
  
  IKJ56716I EXTRANEOUS INFORMATION
  WAS IGNORED:
  'DSN.VC10.SDSNLOD2(INZUTILK)'
   IKJ56109I DATA SETS NOT CONCATENATED+
   IKJ56109I COMBINING UNLIKE DATA SET
  ORGANIZATIONS IS INVALID
   IRX0555E The input or output file XGETINFO
  is not allocated. It cannot be opened for I/O.
  IRX0670E EXECIO error while trying to
  GET or PUT a record.
  
  IKJ56247I FILE XGETINFO NOT FREED,
  IS NOT ALLOCATED
  STEPLIB in MIG generated job ADBMGS1
  is erroneously concatenated as a result.
  
  Issue #2:
  MIG using HPU on LOB objects does not generate HPU option
  SPANNED YES.
  
  Issue #3:
  The following message should only be issued on panel
  ADB28M 'Migrate Parameters' when 'Unload method' does
  not equal 'H' and 'Generate template statements=NO':
  
  ADB586E An UNLDDN template is required when SPANNED=YES
  is set.
  
  Issue #4:
  When using option Z.2U to display panel ADB2Z2U2 "Display/
  ADB2Z2U2 "Display/Terminate Utilities", only approximately
  20 active utilities are shown.  If more than 20 utilities
  are active the following error message may result:
  
  DB2 IFI warning, return code= 4,reason code=00E60800
  
  Issue #5:
  Add line command MT on panel ADB2Z2T2 'Display/Manage
  Traces' that will execute the Db2 command -MODIFY TRACE
  to change the IFCIDs (trace events) associated with a
  particular active trace.
  

Problem conclusion

• Problems have been resolved.
  

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:

  UI63334

Modules/Macros

•    ADBEDIAG ADBE8T   ADBHZ2T2 ADB2UOPS ADB2Z
  ADB2Z2T2 ADB28HPU ADB28M   ADB58
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI63334

     UP19/06/04 P F906

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.