IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    IV02082

  • Reported component name

    TIV NETWK MGR I

  • Reported component ID

    5724S4500

  • Reported release

    380

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-06-16

  • Closed date

    2011-07-14

  • Last modified date

    2011-10-25

  • 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

  • R380 PSY

       UP

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

Document Information

Modified date:
27 September 2021