LI72513: MESSAGE "SQL10013N THE SPECIFIED LIBRARY "LIBDB2CTLIBF.A" COULD NOT BE LOADED" WHEN TRYING TO USE THE SYBASE CTLIB WRAPPER

DB2 UDB Version 8.1 FixPak 16 (also known as Version 8.2 FixPak 9 )

APAR status

• Closed as program error.

Error description

• The problem occurs only on AIX 5.3 and above.  The customer gets
  the following message when performing any operation that uses
  the CTLIB wrapper to access a Sybase data source:
  SQL10013N The specified library "libdb2ctlibF.a" could not be
  loaded SQLSTATE=4272.
  
  It is caused by an error in the djxlinkSybase script, which is
  used to create the fenced Sybase wrapper library libdb2ctlibF.a.
  

Local fix

• Workaround:
  These instructions apply only to WebSphere Information
  Integrator V8 Fix Pack 14.  For fixes for earlier fix packs,
  please contact IBM Service.
  Copy the djxlinkSybase script from db2_install_directory/bin to
  another directory, for example, $HOME/patch, and modify it as
  follows:
  Chnage line 1100 from:
      5.2.*) rc=100 ;;
  to:
      5.*) rc=100 ;;
  To install and run the modified script:
  (1) Stop all active DB2 instances.  (Login as each instance and
  enter the command "db2stop".)
  (2) Create backup copies of the existing files:
         cd /usr/opt/db2_08_01/bin
         mv djxlinkSybase djxlinkSybase.original
  (3) Copy the patch files into the install directory:
         cd /usr/opt/db2_08_01/bin
         cp $HOME/patch/djxlinkSybase .
  (4) Run the djxlinkSybase script to re-build the CTLIB wrapper
  library:
        cd /usr/opt/db2_08_01/bin
        ./djxlinkSybase
      You should see messages similar to the following.  Note that
  if you do not have the dblib client installed, then the link of
  the DBLIB wrapper will fail.
      SYBASE = /opt/oemclient/sybase/sdk125_32
      SYBASE_OCS = OCS-12_5
      Library "libdb2dblib.a" was built successfully.
      SYBASE = /opt/oemclient/sybase/sdk125_32
      SYBASE_OCS = OCS-12_5
      Linking library "libdb2ctlibF.a" with version "12.5" of
  client...
      Library "libdb2ctlibF.a" was built successfully.
  (5) Update all DB2 instances:
      - Enter the command "db2ilist" to list all the instances.
      - For each instance listed, enter the command "db2iupdt
  instance_name".
  

Problem summary

• Users affected:
     Users of the Sybase wrapper in InfoSphere Federation Server
  Problem description and summary:
     See error description.
  

Problem conclusion

• Problem was first fixed in Version 8.2, FixPak 16 (s080111).
  This fix should be applied on the federation server.
  

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

  WS II SYBASE WR

• Fixed component ID

  5724C7411

Applicable component levels

• R820 PSN

     UP