IBM Support

PH65746: IN THE ACCELERATOR TABLES VIEW, IT IS NOT POSSIBLE TO SORT TABLES ALL ACROSS MULTIPLE SCHEMAS.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • In the Accelerator tables view, it is not possible to sort
tables across different schemas, for example by the 'Last load'
timestamp or the 'statistic collection' timestamp. The sort of
the tables takes place within one schema only. Thus it is
difficult to see all tables as a group which for example do not
have statistics collected yet, especially when there are many
schemas and tables.

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: Users of IBM DB2 Admin Foundation for z/OS   *
****************************************************************
* PROBLEM DESCRIPTION: In the Accelerator tables view, it is   *
*                      not possible to sort tables across      *
*                      different schemas, for example by       *
*                      the 'Last load' timestamp or the        *
*                      'statistic collection' timestamp.       *
*                      The sort of the tables takes place      *
*                      within one schema only. Thus it is      *
*                      difficult to see all tables as a group  *
*                       which for example do not have          *
*                      statistics collected yet, especially    *
*                      when there are many schemas and tables. *
****************************************************************
In the Accelerator tables view, it is not possible to
sort tables all across multiple schemas.

    



Problem conclusion


    

  • Apply the PTF provided by this APAR

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PH65746
    • 

  • Reported component name
    DB2 ADMIN FND Z
    • 

  • Reported component ID
    5698ADF00
    • 

  • Reported release
    120
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2025-03-19
    • 

  • Closed date
    2025-06-25
    • 

  • Last modified date
    2025-06-27
    • 





    

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

    • 

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

    • 



Modules/Macros


    

  • AFXDDLPX AFXOPPAX AFXVRPAX

    



Fix information


    

  • Fixed component name
    DB2 ADMIN FND Z
    • 

  • Fixed component ID
    5698ADF00
    • 



Applicable component levels


    

  • R120  PSY  UP
       A
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU011","label":"Systems - zSystems software"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"120"}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            28 June 2025
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback