IC80802: CANNOT CONNECT TO DATABASE FROM CLP WHEN USING DB2DSDRIVER.CFG. DB2DIAG.LOG ERROR: CANNOT OPEN SHARED OBJECT LIBDB2CLIXML4C.SO

DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• When db2dsdriver.cfg is configured to connect to the database
  from DB2 V9.7 FP5 CLP, the connection may not be established
  neither error is reported on the CLP window.
  
  The error message like below appears in the db2diag.log:
  
  2011-12-27-10.04.55.802873-300 I200563E1296        LEVEL: Error
  PID     : 664                  TID  : 140332108551936PROC :db2bp
  INSTANCE: db2psc               NODE : 000
  FUNCTION: DB2 Common, OSSe, OSSHLibrary::load, probe:90
  MESSAGE : ECF=0x90000076=-1879048074=ECF_LIB_CANNOT_LOAD
  Cannot load the specified library DATA #1 : String, 98 bytes
  /opt/ibm/db2/V9.7/lib/libdb2clixml4c.so: cannot open shared
  object file: No such
   file or directory
  CALLSTCK: (Static functions may not be resolved correctly, as
  they are resolved
  to the nearest symbol)
    [0] 0x00007FA19BD3A6FE pdOSSeLoggingCallback + 0x100
    [1] 0x00007FA19A6B6F46
  /home/db2psc/sqllib/lib64/libdb2osse.so.1 +0x1D3F46
    [2] 0x00007FA19A6B8762 ossLog + 0xA6
    [3] 0x00007FA19A6C328F _ZN11OSSHLibrary4loadEPKcm + 0x237
    [4] 0x00007FA19C055ADC CLI_coLoadXml4cLib + 0x1CE
    [5] 0x00007FA19C2CA7D7 _ZN9rccConfig7loadXmlEP5sqlcaPc + 0x1CB
    [6] 0x00007FA19C2D425A
  _ZN10rccDBEntry19getAltSrvrFromCacheEP7rccListP5sqlca + 0x144
    [7] 0x00007FA19C2D581E
  _ZN10rccDBEntry28getEffectiveAlternateSrvListEPcPbPP7rccListP5sq
  lca + 0x172
  

Local fix

• Workaround is to manually create a softlink for lib pointing to
  lib64 (in 64 bit clients) or to lib32(in 32 bit clients),
  present under install path eg. /opt/ibm/db2/V9.7
  
  To create a softlink for the lib directory you must first change
  directory to the install path and then create the softlink:
        -traverse to the install path
        -create soft link
  
  For example, assume your client is installed in
  /opt/ibm/db2/v9.7 and you encounter the error.  Use the
  following commands to create the softlink on the client:
  
  -->64-bit client
          cd  /opt/ibm/db2/v9.7
          sudo ln -s lib64 lib
  
  -->32-bit client
          cd /opt/ibm/db2/v9.7
          sudo ln -s lib32 lib
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users connecting to database from command line with using    *
  * DB2DSDRIVER.CFG                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * CANNOT CONNECT TO DATABASE FROM CLP WHEN USING               *
  * DB2DSDRIVER.CFG.DB2DIAG.LOG ERROR: CANNOT OPEN SHARED OBJECT *
  * LIBDB2CLIXML4C.SO                                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 Version 9.7 Fix Pack 6                        *
  ****************************************************************
  

Problem conclusion

• Problem first fixed in DB2 Version 9.7 Fix Pack 6
  

Temporary fix

• See Local Fix
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  IC84299

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• R970 PSN

     UP