IV73439: DLA GENERATION IS TAKING TOO LONG

3.9.0-TIV-ITNMIP-Solaris-FP0005
3.9.0_INSTALL_NLS_FP0005
3.9.0_INSTALL_FP0005
3.9.0-TIV-ITNMIP-Windows-FP0005
3.9.0-TIV-ITNMIP-zLinux-FP0005
3.9.0-TIV-ITNMIP-Linux-FP0005
3.9.0-TIV-ITNMIP-AIX-FP0005
IBM Tivoli Network Manager IP Edition 3.9.0 Fix Pack 5, 3.9.0-TIV-ITNMIP-FP0005

APAR status

• Closed as program error.

Error description

• Improve performance and define a property on the DLA that
  includes an SQL query to serve as a pre-filter that governs
  what is ultimately exported
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * The users that use ITNM DLA                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The DLA when exporting large networks can take over 24 hours *
  * to run. And some customers need a filtering mechanism by     *
  * entityIds using a SQL statement!                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update ncp_dla to latest level. 3.9.0-ITNMIP-FP0005          *
  ****************************************************************
  

Problem conclusion

• DLA runs a query for each entity that exports and that can
  consume a lot of time when is a system with a database that
  doesn't perform very well. I changed the query to return all
  entities information at once! This information will be cached
  and DLA will look at the cache instead of going to the database
  when information is needed! This change improved the performance
  by more than 50%!
  I also defined a new property called ncp.dla.chassis.ids that
  customers can use to filter the chassis to be exported! The
  example below shows the property definition and
  ncp_dla.properties have more details
  ncp.dla.chassis.ids=SELECT e.mainNodeEntityId FROM entity e
  INNER JOIN domainMgr d ON d.domainMgrId = e.domainMgrId WHERE
  d.domainName = 'NCPPUP' AND EXISTS (SELECT ed.entityId FROM
  entityDetails ed WHERE ed.entityId = e.entityId AND ed.keyName =
  'NetworkEdge' AND ed.keyValue = 1) GROUP BY e.mainNodeEntityId
  

Temporary fix

Comments

APAR Information

• 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 PSN

     UP

• R390 PSY

     UP