PM56735: VARIOUS USABILITY FIXES (APARTBD)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR address the following issues:
  
  1.The temporary Table for the CHECK DATA utility is
     not created if lower case characters are used in the creator
     or table name.
  
  2.  Because the ABPAUDIT table is not defined for the
       secondary SSIDs,  modify the documentation to
      indicate that the bind for the secondary SSID will
      complete with a  warning that the ABPAUDIT table is
      not  defined on that subsystem.
  
  3.  Error Message ABPU5314E (update worklist status
      failed) is issued when the DB2 object is not found or  when
      the utility syntax is incorrect
  
  4.  SPRT0001 contains an incorrect index name if the
      index name is more than 8 characters
  
  5. All Partitions of an object might be blocked when
     using the Thread Cancel and Block feature even though
     PARTLEVEL was specified in the utility syntax.
  
  6. Running the LOAD with the DB2 UET parameter
     PRESORT abends  with 0C4 when using DB2SORT on z/OS  1.13
  
  7. Specifying a single data set in the DB2 UET started
     task STEPLIB causes dynamic allocation error IKJ56231 when
     intercepting a DB2 utility.
  
  8.  Error Message ABPU5336E (error during catalog
      look-up) is issued during the LOAD utility if the columns in
      the field spec do not correspond to the table columns.
  
  9.  When customizing DB2 UET with the IBM Tools
      Customizer for z/OS  if the group attach name is used, the
      generated jobs have a blank group name with in the parameter
       DSN SYSTEM( )
  
  10. When customizing DB2 UET with the IBM Tools Customizer
      for z/OS, panel CCQPDB2 has removed the requirement to
      specify the DB2 DBRM library for the journal migration job
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Utilities Enhancement Tool.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR address the following issues: *
  *                      1.The temporary Table for the CHECK     *
  *                       DATA utility is not created if lower   *
  *                       case characters are used in the        *
  *                       creator or table name.                 *
  *                      2.Because the ABPAUDIT table is not     *
  *                       defined for the secondary SSIDs,       *
  *                       modify the documentation to indicate   *
  *                       that the bind for the secondary SSID   *
  *                       will complete with a warning that the  *
  *                       ABPAUDIT table is not defined on that  *
  *                       subsystem.                             *
  *                      3.Error Message ABPU5314E (update       *
  *                       worklist status failed) is issued      *
  *                       when the DB2 object is not found or    *
  *                       when the utility syntax is incorrect.  *
  *                      4.SPRT0001 contains an incorrect index  *
  *                       name if the index name is more than 8  *
  *                       characters.                            *
  *                      5.All Partitions of an object might be  *
  *                       blocked when using the Thread Cancel   *
  *                       and Block feature even though          *
  *                       PARTLEVEL was specified in the         *
  *                       utility syntax.                        *
  *                      6.Running the LOAD with the DB2 UET     *
  *                       parameter PRESORT abends  with 0C4     *
  *                       when using DB2SORT on z/OS  1.13       *
  *                      7. Specifying a single data set in      *
  *                       the DB2 UET started task STEPLIB       *
  *                       causes dynamic allocation error        *
  *                       IKJ56231 when intercepting a DB2       *
  *                       utility.                               *
  *                      8.Error Message ABPU5336E (error during *
  *                       catalog ook-up) is issued during the   *
  *                       LOAD utility if the columns in the     *
  *                       field spec do not correspond to the    *
  *                       table columns.                         *
  *                      9.When customizing DB2 UET with the     *
  *                       IBM Tools Customizer for z/OS if the   *
  *                       group attach name is used, the         *
  *                       generated jobs have a blank group      *
  *                       name with in the parameter DSN         *
  *                       SYSTEM( ).                             *
  *                      10.When customizing DB2 UET with the    *
  *                       IBM Tools Customizer for z/OS, panel   *
  *                       CCQPDB2 has removed the requirement    *
  *                       to specify the DB2 DBRM library for    *
  *                       the journal migration job.             *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK76909

Modules/Macros

•    ABPBMEPL ABPBNDCR ABPBPRMP ABPFMEPL ABPGAPIS
  ABPGDDJ3 ABPGDYNA ABPGMODD ABPGMODL ABPGMSGF ABPGSRB1 ABPGSRVS
  ABPGSTRN ABPGTRAC ABPHF016 ABPHF024 ABPHF094 ABPHF096 ABPHF099
  ABPHF108 ABPIDXCR ABPMIGRT ABPMIGR2 ABPMMEPL ABPMSGEN ABPOBJCR
  ABPPBATU ABPPDOBJ ABPPOSGS ABPRSTCR ABPRUSQL ABPRXLAT ABPSCHKP
  ABPSESTM ABPSEST0 ABPSEST1 ABPSEST2 ABPSEST3 ABPSINIT ABPSMEPL
  ABPSMPCR ABPSUSQL ABPUFSPC ABPUMAIN ABPUMEPL ABPUSE15 ABPUSTUB
  ABPUXLAT ABPWKLCR
  

Fix information

• Fixed component name

  DB2 UTIL ENHANC

• Fixed component ID

  5655T5800

Applicable component levels

• R220 PSY UK76909

     UP12/03/23 P F203

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.