IBM Support

PH53018: SQL QUERY FAILS WITH CODE -171. THE SAME QUERY RUNS SUCCESSFULLYIN DB2

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

  • SQL query fails with code -171. The same query runs successfully
in Db2

Local fix

  • 110

Problem summary

  • ****************************************************************
* USERS AFFECTED: ALL USERS                                    *
****************************************************************
* PROBLEM DESCRIPTION: PH53018                                 *
*                      SQL Queries on DB2 virtual tables       *
*                      generate incorrect SQL for DB2          *
****************************************************************
* RECOMMENDATION: APPLY PTF                                    *
****************************************************************
PH53018
SQL Queries on DB2 virtual tables generate incorrect SQL for DB2

Problem conclusion

  • 



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PH53018
    • 

  • Reported component name
    DATA VIRT MGR Z
    • 

  • Reported component ID
    5698DVM00
    • 

  • Reported release
    110
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2023-03-06
    • 

  • Closed date
    2023-08-22
    • 

  • Last modified date
    2023-09-01
    • 





    

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

    • 

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

    • 



Modules/Macros


    

  • AVZCCUBU AVZCDLCH AVZCGTMM AVZCISBR AVZCOPDM AVZCSQMM AVZCSQOP
AVZCTSOP AVZCXDLI AVZMBTPA AVZOBRSQ AVZOBRSR AVZOCLUP AVZODMWR
AVZOINSQ AVZOIO31 AVZOMPTP AVZOPPA  AVZORXDM AVZPB    AVZSFPAR
AVZSQ29D AVZSQ29N AVZSQ2BN AVZSQ2CN AVZSQ2DN AVZSQL9D AVZSQL9N
AVZSQLBN AVZSQLCN AVZSQLDN

    



Fix information


    

  • Fixed component name
    DATA VIRT MGR Z
    • 

  • Fixed component ID
    5698DVM00
    • 



Applicable component levels


    

  • R110  PSY  UI93275
       UP23/08/23  P  F308
    • 



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":"BU011","label":"Systems - zSystems software"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"110"}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            01 September 2023
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback