IV02082: DBI_FACTORY.PM NEEDS TO BE ALTERED TO ENABLE LOCAL DB2 CATALOG USE IN HADR ENVIRONMENT.

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

• Product: Tivoli Network Manager
  Version(s): 3.8, 3.9
  Component: ncp_perl
  
  
  Environment:
  Any installation that uses DB2 High Availability Disaster
  Recovery (HADR) for the NCIM, NCMONITOR, NCPGUI,NCMIB or
  NCPOLLDATA database.
  
  To enable use of the DB2 catalog, m_PortNum must equal zero in
  the DbLogins.<domain>.cfg file.  Once configured ncp_ processes
  that act as DB2 clients will connect to which ever DB2 instance
  is the acting primary.
  
  Symptoms:
  Running any script that uses ncp_perl, for example RemoveNode.pl
  returns the following:
  
  Connecting to database.
  
  critical: Database Connection Error: [IBM][CLI Driver] SQL30081N
  A communication error has been detected.  Communication protocol
  being used: "TCP/IP".  Communication API being used: "SOCKETS".
  Location where the error was detected: "1.1.1.1".
  Communication function detecting the error: "connect".
  Protocol specific error code(s): "111", "*", "*".
  SQLSTATE=08001
  
  
  (where "1.1.1.1" represents the IP address for the socket).
  
  Cause:
  The DBI_Factory.pm fails to check for the configured port to be
  zero.
  

Local fix

• Backup the existing DBI_Factory.pm file
  
  cp $NCHOME/precision/perl/lib/site_perl/5.8.8/NCP/DBI_Factory.pm
  $NCHOME/precision/perl/lib/site_perl/5.8.8/NCP/DBI_Factory.pm.or
  ig
  
  Edit the original file, and change line
  
  
   if (defined($port))
  
  to
  
   if (defined($port) && $port != 0)
  
  
  In 3.8 this is on line 552 of the default file.
  In 3.9 this is on line 689 of the default file.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users with DB2 HADR                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Perl scripts fail to connect to DB2 when configured to use   *
  * the DB2 catalog by setting the port number to 0. In addition *
  * in version 3.8 Perl was not reading domain specific versions *
  * of the MibDbLogin.cfg configuration file                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * The following fixpacks will contain the fix:                 *
  * | fix pack | 3.8.0-ITNMIP-FP0007                             *
  * | fix pack | 3.9.0-ITNMIP-FP0001                             *
  ****************************************************************
  

Problem conclusion

• The NCP::DBI_Factory Perl module was modifed so that it uses the
  DB2 catalog when the port number is 0. And in version 3.8 it was
  additionally modified to read a domain specific version of the
  MibDbLogin.cfg configuration file (should one exist).
  

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