When we need to setup federation we need to first create a wrapper which will identify data source of the federated server.
We get this error SQL10013N as shown below, When we don't have Informix data source support installed in our server.
db2inst1@test-machine:~$ db2 "create wrapper drda"
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL10013N The specified library "libdb2drda.so" could not be loaded.
SQLSTATE=42724
Below commands list the features that are installed on the server, we can seen there is no Informix Data Source Support Installed on the server
db2inst1@test-machine:~$ db2ls -q -b /opt/ibm/db2/V9.7
Install Path : /opt/ibm/db2/V9.7
Feature Response File ID Level Fix Pack Feature Description
---------------------------------------------------------------------------------------------------------------------
BASE_CLIENT 9.7.0.6 6 Base client support
JAVA_SUPPORT 9.7.0.6 6 Java support
SQL_PROCEDURES 9.7.0.6 6 SQL procedures
BASE_DB2_ENGINE 9.7.0.6 6 Base server support
JDK 9.7.0.6 6 IBM Software Development Kit (SDK) for Java(TM)
COMMUNICATION_SUPPORT_TCPIP 9.7.0.6 6 Communication support - TCP/IP
REPL_CLIENT 9.7.0.6 6 Replication tools
DB2_DATA_SOURCE_SUPPORT 9.7.0.6 6 DB2 data source support
LDAP_EXPLOITATION 9.7.0.6 6 DB2 LDAP support
INSTANCE_SETUP_SUPPORT 9.7.0.6 6 DB2 Instance Setup wizard
SPATIAL_EXTENDER_CLIENT_SUPPORT 9.7.0.6 6 Spatial Extender client
APPLICATION_DEVELOPMENT_TOOLS 9.7.0.6 6 Base application development tools
As we identified the problem now we shall install the Informix Data source support, i'm using response file installation for this as its a single component installation. Just copy below things and change the parameter "FILE" according to your already installed location of db2 server
PROD = ADVANCED_ENTERPRISE_SERVER_EDITION
FILE = /opt/ibm/db2/V9.7_01
LIC_AGREEMENT = ACCEPT
INSTALL_TYPE = CUSTOM
COMP = INFORMIX_DATA_SOURCE_SUPPORT
I will save above 5 lines in /home/db2inst1/resp
Now i will install the single component informix_data_source_support using below command
db2inst1@test-machine:~/server$ sudo ./db2setup -r /home/db2inst1/resp
WARNING:
DBT3534W The db2prereqcheck utility determined that ASLR is set to ON and that this could cause issues with some tools.
WARNING:
The 32-bit library file libpam.so is not found on the system.
DBI1191I db2setup is installing and configuring DB2 according to the
response file provided. Please wait.
A minor error occurred while installing "DB2 Advanced Enterprise Server
Edition " on this computer. Some features may not function correctly.
For more information see the DB2 installation log at "/tmp/db2setup.log".
Once done i have connected to database and was able to create wrapper successfully
db2inst1@test-machine:/opt/ibm/db2/V9.7_01/instance$ db2 connect to attempt
Database Connection Information
Database server = DB2/LINUXX8664 9.7.6
SQL authorization ID = DB2INST1
Local database alias = ATTEMPT
db2inst1@test-machine:/opt/ibm/db2/V9.7_01/instance$ db2 create wrapper drda
DB20000I The SQL command completed successfully.
We get this error SQL10013N as shown below, When we don't have Informix data source support installed in our server.
db2inst1@test-machine:~$ db2 "create wrapper drda"
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL10013N The specified library "libdb2drda.so" could not be loaded.
SQLSTATE=42724
Below commands list the features that are installed on the server, we can seen there is no Informix Data Source Support Installed on the server
db2inst1@test-machine:~$ db2ls -q -b /opt/ibm/db2/V9.7
Install Path : /opt/ibm/db2/V9.7
Feature Response File ID Level Fix Pack Feature Description
---------------------------------------------------------------------------------------------------------------------
BASE_CLIENT 9.7.0.6 6 Base client support
JAVA_SUPPORT 9.7.0.6 6 Java support
SQL_PROCEDURES 9.7.0.6 6 SQL procedures
BASE_DB2_ENGINE 9.7.0.6 6 Base server support
JDK 9.7.0.6 6 IBM Software Development Kit (SDK) for Java(TM)
COMMUNICATION_SUPPORT_TCPIP 9.7.0.6 6 Communication support - TCP/IP
REPL_CLIENT 9.7.0.6 6 Replication tools
DB2_DATA_SOURCE_SUPPORT 9.7.0.6 6 DB2 data source support
LDAP_EXPLOITATION 9.7.0.6 6 DB2 LDAP support
INSTANCE_SETUP_SUPPORT 9.7.0.6 6 DB2 Instance Setup wizard
SPATIAL_EXTENDER_CLIENT_SUPPORT 9.7.0.6 6 Spatial Extender client
APPLICATION_DEVELOPMENT_TOOLS 9.7.0.6 6 Base application development tools
As we identified the problem now we shall install the Informix Data source support, i'm using response file installation for this as its a single component installation. Just copy below things and change the parameter "FILE" according to your already installed location of db2 server
PROD = ADVANCED_ENTERPRISE_SERVER_EDITION
FILE = /opt/ibm/db2/V9.7_01
LIC_AGREEMENT = ACCEPT
INSTALL_TYPE = CUSTOM
COMP = INFORMIX_DATA_SOURCE_SUPPORT
I will save above 5 lines in /home/db2inst1/resp
Now i will install the single component informix_data_source_support using below command
db2inst1@test-machine:~/server$ sudo ./db2setup -r /home/db2inst1/resp
WARNING:
DBT3534W The db2prereqcheck utility determined that ASLR is set to ON and that this could cause issues with some tools.
WARNING:
The 32-bit library file libpam.so is not found on the system.
DBI1191I db2setup is installing and configuring DB2 according to the
response file provided. Please wait.
A minor error occurred while installing "DB2 Advanced Enterprise Server
Edition " on this computer. Some features may not function correctly.
For more information see the DB2 installation log at "/tmp/db2setup.log".
Once done i have connected to database and was able to create wrapper successfully
db2inst1@test-machine:/opt/ibm/db2/V9.7_01/instance$ db2 connect to attempt
Database Connection Information
Database server = DB2/LINUXX8664 9.7.6
SQL authorization ID = DB2INST1
Local database alias = ATTEMPT
db2inst1@test-machine:/opt/ibm/db2/V9.7_01/instance$ db2 create wrapper drda
DB20000I The SQL command completed successfully.
Hi Admin,
ReplyDeleteI have been just watching that blog, It is really Impressive. Just loved that information content of that blog. Keep writing the stuff like that. Thanks,
Norton Phone Number