473,466 Members | 1,393 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

DB2 Client on Solaris fails to connect to DB2 Server on Linux

3 New Member
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=iusr; 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.
Apr 9 '10 #1
0 1936

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Rationalman | last post by:
I'm new to ASP, and need to do something that should be straightforward. I want to access the database in my vbscript function on the serverside, when someone clicks a button on the cient side....
7
by: CT | last post by:
Hi, This might seem like a basic question but I have some doubts, please humour me. I have a client-server application using java where each client on each machine needs to directly...
8
by: Xela | last post by:
Hi A have a very annoying problem. I have written java strored procedures for DB2 v8.1. Their deployement and usage is fine as long as the server is a Windows one. But under Solaris 8 and Linux...
3
by: Roy Souther | last post by:
Trying to get the unixODBC to work connecting to an IBM DB2 UDB V8.1. The DB2 server is running on Red Hat 8 and is tested and confirmed to be serving connections to Windows 98 clients using the...
2
by: Frank Swarbrick | last post by:
I am trying to understand "client authentication" works. My environment is DB2/UDB LUW 8.2 on zSeries SLES9 as the database server and DB2 for VSE 7.4 as the client. We currently have DB2/LUW set...
5
by: ganeshp | last post by:
Hi , In Java using socket programming is it possible to have a server program on windows that services a client program on linux? I tried the code in the below given link:...
6
by: Iain King | last post by:
Hi. I'm using the win32 module to access an Access database, but I'm running into the File Sharing lock count as in http://support.microsoft.com/kb/815281 The solution I'd like to use is the one...
3
by: TsanChung | last post by:
I want to make a java TCP socket client to communicate with a TCP server socket on linux. Are there some sample C unix server and java client socket programs available? The Richard Stevens'...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.