PI67825: ELIMINATE SUPPORT FOR FEATURES BEING INCLUDED IN DB2 LOAD (1) REPLACE SHRLEVEL REFERENCE (2) RESUME SHRLVL REF PART X REPLACE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This fix allows the user to turn off support by the DB2 Utility
  Enhancement Tool for:
    LOAD RESUME SHRLEVEL REFERENCE PART x REPLACE  and
    LOAD REPLACE SHRLEVEL
  and provides functionality to pass these features to IBM LOAD.
  .
  Feature/Function Impacted:
  1. This allows the DB2 Utility Enhancement Tool to pass control
  to the IBM LOAD Utility to process the syntax LOAD
  REPLACE SHRLEVEL REFERENCE and LOAD RESUME SHRLEVEL REFERENCE
  PART x REPLACE for DB2 V11 New function mode and DB2
  V11 Conversion mode.
  .
  2. The new option LRSR_IBMLOAD(YES/NO) was implemented.
  LRSR_IBMLOAD=”YES” will process the syntax in item one with IBM
  LOAD for DB2 V11 New function mode and V11 Conversion mode.
  LRSR_IBMLOAD=”YES” for DB2 V10 will fail with invalid syntax
  due to no support in IBM LOAD for DB2 V10.
  LRSR_IBMLOAD=”NO” will process the syntax in item one with the
  DB2 Utility Enhancement Tool for DB2 V10, DB2 V11 Conversion
  mode and DB2 V11 New function mode. The default is ‘YES”, use
  IBM LOAD.
  .
  3. UET will still honor all other extended syntax for the LOAD
  utility, CONSTANT, PRESORT , VALUEIF and IFDISCARDS.
  .
  4. The manipulation of the keywords “REPLACE” and ‘RESUME” in
  the UTILITY Monitor feature for the DB2 Utility Enhancement Tool
  will no longer be supported due to IBM LOAD natively processing
  LOAD REPLACE SHRLEVEL REFERENCE and LOAD RESUME SHRLEVEL
  REFERENCE PART x REPLACE
  .
  To implement:
  Verify that the following DB2 APARS PI67793/PI67794 are applied.
  No changes are required to implement the default
  LRSR_IBMLOAD=”YES”. To override the default LRSR_IBMLOAD option
  to NO, use the Tools Customizer to generate an option member
  with this parameter.  To implement this update, stop the DB2
  Utility Enhancement Tool started task, ABPSTC, and then restart
  the DB2 Utility Enhancement Tool started task.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 Utilities Enhancement Tool  *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: This fix allows the user to turn off    *
  *                      support by the DB2 Utility Enhancement  *
  *                      Tool for:                               *
  *                       LOAD RESUME SHRLEVEL REFERENCE PART    *
  *                       x REPLACE  and LOAD REPLACE SHRLEVEL   *
  *                      and provides functionality to pass      *
  *                      these features to IBM LOAD.             *
  *                      Feature/Function Impacted:              *
  *                      1. This allows the DB2 Utility          *
  *                      Enhancement Tool to pass control to the *
  *                      IBM LOAD Utility to process the syntax  *
  *                      LOAD REPLACE SHRLEVEL REFERENCE and     *
  *                      LOAD RESUME SHRLEVEL REFERENCE PART x   *
  *                      REPLACE for DB2 V11 New function mode   *
  *                      and DB2 V11 Conversion mode.            *
  *                      2. The new option LRSR_IBMLOAD(YES/NO)  *
  *                      was implemented. LRSR_IBMLOAD= YES      *
  *                      will process the syntax in item one     *
  *                      with IBM LOAD for DB2 V11 New function  *
  *                      mode and V11 Conversion mode. DB2       *
  *                      Utility Enhancement Tool for DB2 V10,   *
  *                      DB2 V11 Conversion mode and DB2 V11     *
  *                      New function mode. The default is  DB2  *
  *                      Utility IBM LOAD.                       *
  *                      3. UET will still honor all other       *
  *                      extended syntax for the LOAD utility,   *
  *                      CONSTANT, PRESORT , VALUEIF and         *
  *                      IFDISCARDS.                             *
  *                      4. The manipulation of the keywords     *
  *                      the UTILITY Monitor feature for the     *
  *                      DB2 Utility Enhancement Tool will no    *
  *                      longer be supported due to IBM LOAD     *
  *                      natively processing LOAD REPLACE        *
  *                      SHRLEVEL REFERENCE and LOAD RESUME      *
  *                      SHRLEVEL REFERENCE PART x REPLACE       *
  *                      To implement:                           *
  *                      Verify that the following DB2 APARS     *
  *                      PI67793/PI67794 are applied. No changes *
  *                      are required to implement the default   *
  *                      LRSR_IBMLOAD=V11 New function mode and  *
  *                      V11 Conversion mode. To NO, use the     *
  *                      Tools Customizer to generate an option  *
  *                      member with this parameter.  To         *
  *                      implement this update, stop the DB2     *
  *                      Utility Enhancement Tool started task,  *
  *                      ABPSTC, and then restart the DB2        *
  *                      Utility Enhancement Tool started task.  *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

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

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

Modules/Macros

• ABP$$PRM ABPDISCO ABPDTDOP ABPFADM0 ABPFADM1 ABPFADM2 ABPHF188
  ABPLADM1 ABPLADM2 ABPOPTCR ABPPBATU ABPPBATX ABPPCHCK ABPPCOPY
  ABPPDITB ABPPDOBJ ABPPEXEC ABPPFSPC ABPPINIX ABPPLIST ABPPLOAD
  ABPPOPTS ABPPQUIS ABPPREBU ABPPRECO ABPPREOR ABPPRUNS ABPPSTMT
  ABPPTMPL ABPPUNLD ABPPUTLM ABPPUTLU ABPPUTLX ABPPXMLU ABPSINIT
  ABPSPRMP ABPSTSRV ABPUMAIN
  

Fix information

• Fixed component name

  DB2 UTIL ENHANC

• Fixed component ID

  5655T5800

Applicable component levels

• R220 PSY UI42050

     UP16/10/29 P F610

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.