IBM Support

JR27002: NNSTAT OF DB2 V8 CAN NOT GET REMOTE TABLE STATISTIC WHEN THE TABLE HAS INDEX (OR PRIMARY KEY).

A fix is available

DB2 UDB Version 8.1 FixPak 16 (also known as Version 8.2 FixPak 9 )

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • NNSTAT of DB2 V8 can not get remote table statistic when the
table has index (or primary key).

Local fix

  • Workaround:

This issue not only occured for Oracle database but all
other data sources when the remote table has index. This issue
only occurs in db2v8, for the codes of NNSTAT of db2v9 are
changed. And if 'ANALYZE' is run at Oracle side first, this
issue will not occur.

Problem summary

  • N/A

Problem conclusion

  • Problem was first fixed in DB2 UDB Version 8.1 FixPak 16.

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    JR27002
    • 

  • Reported component name
    WS II UTILITIES
    • 

  • Reported component ID
    5724C7416
    • 

  • Reported release
    820
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2007-07-20
    • 

  • Closed date
    2009-06-02
    • 

  • Last modified date
    2009-06-02
    • 





    

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

    • 

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

    • 



Fix information


    

  • Fixed component name
    WS II UTILITIES
    • 

  • Fixed component ID
    5724C7416
    • 



Applicable component levels


    

  • R820  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS2K5T","label":"InfoSphere Federation Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"820","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            12 October 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback