IBM Support

PH52123: DB2 ADMINISTRATION TOOL - SELECT FOR REMOTE TABLES RETURNS NO ROWS

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

  • While connecting to a remote location in the DB2 Administration
Tool, use of the command "SEL" for remote tables returns the
message "No rows returned".

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
****************************************************************
* PROBLEM DESCRIPTION: A user encounters an error after        *
*                      accessing a remote system and issuing   *
*                      the SEL line command on a table.        *
****************************************************************
The user selects option DD (Distributed DB2 systems) from the
main menu in Db2 Admin Tool and connects to a remote
system. When the user issues the SEL line command on a
remote table, the error "No rows returned" is displayed.

    



Problem conclusion


    

  • The problem has been resolved.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PH52123
    • 

  • Reported component name
    DB2 ADMIN TOOL
    • 

  • Reported component ID
    568851500
    • 

  • Reported release
    D10
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2023-01-24
    • 

  • Closed date
    2023-05-01
    • 

  • Last modified date
    2023-06-01
    • 





    

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

    • 

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

    
UI91587
    

    • 



Modules/Macros


    

  • ADB21T   ADB21TDE ADB21TIN ADB21TSE ADB21TUP ADB223T

    



Fix information


    

  • Fixed component name
    DB2 ADMIN TOOL
    • 

  • Fixed component ID
    568851500
    • 



Applicable component levels


    

  • RD10  PSY  UI91587
       UP23/05/05  P  F305
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU011","label":"Systems - zSystems software"},"Product":{"code":"SG19O","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"D10"}]
              

                                                                    

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            02 June 2023
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback