IBM Support

PH56994: (ADB) INTERNAL APAR SUPPORT FOR MISSING LOAD UTILITY OPTIONS

A fix is available

Obtain the fix for this APAR.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • (ADB) Internal APAR Support for missing LOAD utility options

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
*                 and Db2 Object Comparison Tool for z/OS      *
****************************************************************
* PROBLEM DESCRIPTION: This APAR provides enhancements to      *
*                      add support for LOAD utility options.   *
****************************************************************
This APAR adds support as follows:

The following options have been added to the 'Specify Utility
Options - LOAD' panel (ADB2UTC):
 - FORCE
 - DEFINEAUX
 - PREFORMAT
 - FLOAT
 - NOCHECKPEND
 - NOSUBS
 - IGNORE
 - OVERRIDE
 - DRAIN_WAIT
 - RETRY
 - RETRY_DELAY
 - SWITCHTIME
 - INDEXDEFER
 - UPDMAXASSIGNEDVAL

The following options have been added to the 'Table Utilities -
LOAD with Cross Loader' panel (ADBPUTLC):
 - FORCE
 - DEFINEAUX
 - PREFORMAT
 - NOCHECKPEND
 - IGNORE
 - OVERRIDE
 - DRAIN_WAIT
 - RETRY
 - RETRY_DELAY
 - SWITCHTIME
 - INDEXDEFER
 - UPDMAXASSIGNEDVAL

Also, for Db2 Admin Tool 12.1, statistics options STATCLGMEMSRT,
HISTORY and FORCEROLLUP were added to the ADB2UTC and ADBPUTLC
panels. In Db2 Admin Tool 13.1, these options have already been
supported since GA.

The following Change Management (CM) batch parameters have been
added to CM batch:
 - UTIL_LOAD_BACKOUT
 - UTIL_LOAD_DECFLOAT_ROUNDMODE
 - UTIL_LOAD_DEFINEAUX
 - UTIL_LOAD_FORCE
 - UTIL_LOAD_INDEXDEFER
 - UTIL_LOAD_INDEXDEFER_NONUNIQUE
 - UTIL_LOAD_NOCHECKPEND
 - UTIL_LOAD_NOSUBS
 - UTIL_LOAD_PREFORMAT
Also, Db2 Admin Tool 12.1 added support for the following
additional parameters that are already supported in version
13.1:
 - UTIL_LOAD_STATISTICS
 - UTIL_LOAD_STATISTICS_FORCEROLLUP
 - UTIL_LOAD_STATISTICS_INVALIDATECACHE
 - UTIL_LOAD_STATISTICS_HISTORY
 - UTIL_LOAD_STATISTICS_REPORT
 - UTIL_LOAD_STATISTICS_TABLE_SAMPLE
 - UTIL_LOAD_STATISTICS_UPDATE
 - UTIL_LOAD_STATISTICS_USE_PROFILE

    



Problem conclusion


    

  • 



Temporary fix


    

  • 



Comments


    

  • Enhancements have been delivered.

    



APAR Information




    

  • APAR number
    PH56994
    • 

  • Reported component name
    DB2 ADMIN TOOL
    • 

  • Reported component ID
    568851500
    • 

  • Reported release
    C10
    • 

  • Status
    CLOSED  UR1
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    YesSpecatt / New Function / Xsystem
    • 

  • Submitted date
    2023-09-15
    • 

  • Closed date
    2023-09-20
    • 

  • Last modified date
    2023-10-02
    • 





    

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

    • 

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

    
UI93644 UI93645
    

    • 



Modules/Macros


    

  • ADB2000  ADB28M   ADB28MC  ADB2CMR  ADB2CMT  ADB2LCC  ADB2U
ADB2UOPS ADB2UTC  ADB2UTCI ADB2UTCO ADB34    ADB5000  ADB9000
ADBCCM   ADBCMBIV ADBEALT  ADBGAJOB ADBHUTC  ADBHUTLC ADBPUTLC
ADBS27AC ADBTEP2  ADBTTP

    



Fix information


    

  • Fixed component name
    DB2 ADMIN TOOL
    • 

  • Fixed component ID
    568851500
    • 



Applicable component levels


    

  • RC10  PSY  UI93644
       UP23/09/23  P  F309   
    • 

  • RD10  PSY  UI93645
       UP23/09/23  P  F309   
    • 



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.
    








      
              
                            

              

              [{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.1.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            02 October 2023
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback