IV14221: THE DOMAIN_DROP.PL SCRIPT IS SUPPOSED TO INCREMENTALLY DELETE ENTITIES FROM A DOMAIN.

ITNMIP_Patch_V3.8.0.89_AIXPPC32
3.8.0-TIV-ITNMIP-Linux-REF-FP0007
3.8.0-TIV-ITNMIP-Solaris-REF-FP0007
ITNMIP_Patch_V3.8.0.89_Win32
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

APAR status

• Closed as program error.

Error description

• When deleting directly from the domainMgr table or deleting all
  entities in a single command, the level of cascaded deletions
  that are performed can result in a transaction that is too large
  for the database to handle or is simply too slow. The
  domain_drop.pl script resolves this by incrementally deleting
  batches of entities from the domain before deleting the domain
  itself, but this mechanism does not currently work. The entities
  are deleted only at the end of the script, when the domain
  itself is removed from the domainMgr table. This defeats the
  purpose of the script, and can fail on very large topologies.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All ITNM 3.8 and 3.9 releases                                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When deleting directly from the domainMgr table or deleting  *
  * all                                                          *
  * entities in a single command, the level of cascaded          *
  * deletions                                                    *
  * that are performed can result in a transaction that is too   *
  * large                                                        *
  * for the database to handle or is simply too slow. The        *
  * domain_drop.pl script resolves this by incrementally         *
  * deleting                                                     *
  * batches of entities from the domain before deleting the      *
  * domain                                                       *
  * itself, but this mechanism does not currently work. The      *
  * entities                                                     *
  * are deleted only at the end of the script, when the domain   *
  * itself is removed from the domainMgr table. This defeats the *
  * purpose of the script, and can fail on very large            *
  * topologies.                                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * | fix pack | 3.9.0-ITNMIP-FP0003                             *
  * | fix pack | 3.8.0-ITNMIP-FP0007                             *
  ****************************************************************
  

Problem conclusion

• | fix pack | 3.9.0-ITNMIP-FP0003
  

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