IBM Support

IV20645: NCP_POLLING_EXCEPTIONS.PL FAILS WITH OUT-OF-MEMORY EXCEPTION WHEN NCIM DATABASE HAS MORE THAN MILLION RECORDS

Fixes are available

IBM Tivoli Network Manager IP 3.9.0 Fix Pack 3, 3.9.0-TIV-ITNMIP-FP0003
IBM Tivoli Network Manager IP 3.9.0 Fix Pack 4, 3.9.0-TIV-ITNMIP-FP0004
IBM Tivoli Network Manager IP Edition 3.9.0 Fix Pack 5, 3.9.0-TIV-ITNMIP-FP0005

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • v3.9 - GA & FP1 builds - platform independent.
Noticed problem on NCIM being Mysql.

In a multi domain environment, when NCIM table (ncim.interfaces)
holds more than 1million rows, ncp_polling_exceptions.pl fails
to return data due to inefficient queries.

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED:                                              *
* Users with large size of ncim.interfaces table.              *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* In a multi domain environment, when NCIM table               *
* (ncim.interfaces) holds more than 1million rows,             *
* ncp_polling_exceptions.pl fails                              *
* to return data due to inefficient queries.                   *
****************************************************************
* RECOMMENDATION:                                              *
* Apply testfix IV20645 or upgrade to FP3.                     *
* | fix pack | 3.9.0-ITNMIP-FP0003                             *
****************************************************************

    



Problem conclusion


    

  • Modified the SQL query that outputs the Unmanaged tables to be
more efficient.

The following fixpacks will contain the fix:
| fix pack | 3.9.0-ITNMIP-FP0003

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IV20645
    • 

  • Reported component name
    TIV NETWK MGR I
    • 

  • Reported component ID
    5724S4500
    • 

  • Reported release
    390
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2012-05-04
    • 

  • Closed date
    2012-10-31
    • 

  • Last modified date
    2012-10-31
    • 





    

  • 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
    TIV NETWK MGR I
    • 

  • Fixed component ID
    5724S4500
    • 



Applicable component levels


    

  • R390  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSSHRK","label":"Tivoli Network Manager IP Edition"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.9","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            31 October 2012
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback