PH18055: MIG IS NOT SETTING CCSID CORRECTLY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• MIGrate TABLE path of multiple tables with a mixture of
  ENCODING_SCHEME results in HPU UNLOAD statement missing keyword
  EBCDIC/UNICODE from generated Source job ADBMGS1.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for z/OS.   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Issue #1:                               *
  *                      MIG Table path does not set CCSID       *
  *                      correctly when multiple table objects   *
  *                      are added.                              *
  *                                                              *
  *                      Issue #2:                               *
  *                      Message "No rows returned" is           *
  *                      erroneously issued when option L is     *
  *                      selected more than once on panel ADB25  *
  *                      'Utility generation using LISTDEFs and  *
  *                      TEMPLATEs'.                             *
  ****************************************************************
  Issue #1:
  PH18055 MIGrating multiple tables with a mixture of
  ENCODING_SCHEME using HPU results in object's data getting
  loaded with the wrong ENCODING_SCHEME.
  
  Issue #2:
  When "DB2 Admin Default" panel ADB2P2 setting "Max No of Rows
  to Fetch" is set to a value greater than 9999, "No rows
  returned" is erroneously issued when option L is selected more
  than once on panel ADB25 'Utility generation using LISTDEFs and
  TEMPLATEs'.
  The scenario also erroneously blanks out the "DB2 Admin Default"
  panel setting "Max No of Rows to Fetch".
  This blank value translates to a value of 1000 which can
  negatively impact CATNAV.
  

Problem conclusion

• Incident has 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:

  UI66305

Modules/Macros

• ADB25L   ADB28ADD ADB28ASD ADB28ATD ADB28M   ADB28M2  ADB28S
  ADB28T   ADBEDIAG ADBPDIAG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI66305

     UP19/11/12 P F911

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.