Hi,
I am unable to connect DB2 client on solaris to DB2 Server located on Linux. Below is the Environment details.
DB2 Client
OS => Solaris 10
User
Instance User Name => iusr
Instance Home directory => /home/iusr
Fence User Name => fusr
Instance Group => igrp
Fence Group => fgrp
Application Details
The client application access the DB2 Database on Linux using the following user details and environment variable set to following values
User Name => ausr
_Environment Variable Set in ausr profile._
DB2DIR=/opt/IBM/db2/V9.5; export DB2DIR
DB2INSTANCE=ius r; export DB2INSTANCE
INSTHOME=/home/iusr; export INSTHOME
DB2PATH=/opt/IBM/db2/V9.5; export DB2PATH
LD_LIBRARY_PATH =$DB2DIR/lib64:$INSTHOME/sqllib/lib64
PATH=$INSTHOME/sqllib/bin:$INSTHOME/sqllib/adm
DB2 Server
OS => SUSE Linux Enterprise Server 10 (x86_64) VERSION = 10 PATCHLEVEL = 2
Instance Name => iusr
Fence User Name => fusr
Instance Group => igrp
Fence Group => fgrp
Problem Description
1) On client i created the DB2 client instance as ROOT user using following command as the default client didnt exist.
cd /opt/IBM/db2/V9.5/instance
./db2icrt -s client iusr
2) I am unable to see sqlib directory link created in the /home/iusr on client.
3) Since my application access data using ausr, and in order to allow it access the DB2 server i have set the environment variable as mentioned above. As the "ausr" on DB2 client, i am unable to execute any DB2 CATALOG command since the SQLLIB directory link is not created in DB2 Client instance home directory. Therefore unable to access DB2 Server from DB2 Client.
Kindly please assist me on the following.
I am unable to connect DB2 client on solaris to DB2 Server located on Linux. Below is the Environment details.
DB2 Client
OS => Solaris 10
User
Instance User Name => iusr
Instance Home directory => /home/iusr
Fence User Name => fusr
Instance Group => igrp
Fence Group => fgrp
Application Details
The client application access the DB2 Database on Linux using the following user details and environment variable set to following values
User Name => ausr
_Environment Variable Set in ausr profile._
DB2DIR=/opt/IBM/db2/V9.5; export DB2DIR
DB2INSTANCE=ius r; export DB2INSTANCE
INSTHOME=/home/iusr; export INSTHOME
DB2PATH=/opt/IBM/db2/V9.5; export DB2PATH
LD_LIBRARY_PATH =$DB2DIR/lib64:$INSTHOME/sqllib/lib64
PATH=$INSTHOME/sqllib/bin:$INSTHOME/sqllib/adm
DB2 Server
OS => SUSE Linux Enterprise Server 10 (x86_64) VERSION = 10 PATCHLEVEL = 2
Instance Name => iusr
Fence User Name => fusr
Instance Group => igrp
Fence Group => fgrp
Problem Description
1) On client i created the DB2 client instance as ROOT user using following command as the default client didnt exist.
cd /opt/IBM/db2/V9.5/instance
./db2icrt -s client iusr
2) I am unable to see sqlib directory link created in the /home/iusr on client.
3) Since my application access data using ausr, and in order to allow it access the DB2 server i have set the environment variable as mentioned above. As the "ausr" on DB2 client, i am unable to execute any DB2 CATALOG command since the SQLLIB directory link is not created in DB2 Client instance home directory. Therefore unable to access DB2 Server from DB2 Client.
Kindly please assist me on the following.