IBM Support

PH26287: DBRM MODULES WERE NOT UPDATED WITH CORRECT VERSION ID WITHIN PTF

A fix is available

Obtain the fix for this APAR.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DBRM modules were not updated with correct version id within PTF

Local fix

  • 



Problem summary


    

  • 1.Not showing correct information about indexes for remote
location;
2.Not possible to use two version of SQLPA
in one DB2 ;
3.Is showed ANL2021W message even if
VERSION parameter is correct.

    



Problem conclusion


    

  • Code logic was corrected to fix the issues described.

Search Keywords:
slcode -806 if try to use two releases of SQLPA in one DB2
subsytem

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PH26287
    • 

  • Reported component name
    DB2 SQL PERF AN
    • 

  • Reported component ID
    5697F5701
    • 

  • Reported release
    510
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    YesHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2020-06-09
    • 

  • Closed date
    2020-06-24
    • 

  • Last modified date
    2020-07-06
    • 





    

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

    • 

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

    • 



Modules/Macros


    

  • ANLBATCH ANLBPAM  ANLCAT   ANLCHECK ANLCLOB  ANLCONV  ANLCSV
ANLDB2X  ANLDPRM  ANLEEE   ANLGPRM  ANLGPST  ANLMAIN  ANLNUXD
ANLPDBRM ANLPFILE ANLPICP  ANLPIDD  ANLPIQLR ANLPITP  ANLPLAN
ANLPLIN  ANLPPKGE ANLPRCR  ANLPRER  ANLPTCM  ANLPTEX  ANLPTLD
ANLPTRP  ANLPTSM  ANLQMF   ANLSERV  ANLSQ2M  ANLSQLPA ANLTABS
ANLTOHEX ANLTSO   ANLUNIC  ANLUOPT  ANLVER8  ANLWIF   ANLWIFF

    



Fix information


    

  • Fixed component name
    DB2 SQL PERF AN
    • 

  • Fixed component ID
    5697F5701
    • 



Applicable component levels


    

  • R510  PSY  UI70225
       UP20/06/26  P  F006  ¢
    • 



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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.1.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                                                                    

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            12 February 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback