IBM Support

PH69230: MORE LOCAL APPLICATIONS CONTROL WITH DB2 PROFILE TABLES

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

  • More local applications control with Db2 profile tables

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
****************************************************************
* PROBLEM DESCRIPTION: This APAR adds support for ATTRIBUTE2   *
*                      specification for global variables and  *
*                      special registers in profile tables.    *
****************************************************************
This APAR adds support for the ATTRIBUTE2 specification
introduced with Db2 function level 508. On panel ADB2Z2PA, you
can specify ATTRUBUTE2 with the following global variables:
  SYSIBMADM.MAX_LOCKS_PER_TABLESPACE
  SYSIBMADM.MAX_LOCKS_PER_USER
  SYSIBMADM.GET_ARCHIVE
  SYSIBMADM.MOVE_TO_ARCHIVE
  SYSIBM.TEMPORAL_LOGICAL_TRANSACTION_TIME
  SYSIBM.TEMPORAL_LOGICAL_TRANSACTION;
And the following special registers:
  CURRENT ACCELERATOR
  CURRENT APPLICATION COMPATIBILITY
  CURRENT DEBUG MODE
  CURRENT DECFLOAT ROUNDING MODE
  CURRENT DEGREE
  CURRENT EXPLAIN MODE
  CURRENT GET_ACCEL_ARCHIVE
  CURRENT LOCALE LC_CTYPE
  CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION
  CURRENT OPTIMIZATION HINT
  CURRENT PRECISION
  CURRENT QUERY ACCELERATION
  CURRENT QUERY ACCELERATION WAITFORDATA
  CURRENT REFRESH AGE
  CURRENT ROUTINE VERSION
  CURRENT RULES
  CURRENT SQLID
  CURRENT TEMPORAL BUSINESS_TIME
  CURRENT TEMPORAL SYSTEM_TIME
  ENCRYPTION PASSWORD
  PATH
  SCHEMA
  SESSION TIME ZONE

    



Problem conclusion


    

  • 



Temporary fix


    

  • 



Comments


    

  • The enhancements have been delivered.

    



APAR Information




    

  • APAR number
    PH69230
    • 

  • Reported component name
    DB2 ADMIN TOOL
    • 

  • Reported component ID
    568851500
    • 

  • Reported release
    D10
    • 

  • Status
    CLOSED  UR1
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    YesSpecatt / New Function / Xsystem
    • 

  • Submitted date
    2025-12-02
    • 

  • Closed date
    2025-12-09
    • 

  • Last modified date
    2025-12-11
    • 





    

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

    • 

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

    
UO06148
    

    • 



Modules/Macros


    

  • ADB2Z2PA

    



Fix information


    

  • Fixed component name
    DB2 ADMIN TOOL
    • 

  • Fixed component ID
    568851500
    • 



Applicable component levels


    

  • RD10  PSY  UO06148
       UP25/12/11  I  1000   
    • 



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":"D10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            11 December 2025
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback