By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,617 Members | 1,166 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,617 IT Pros & Developers. It's quick & easy.

Problem DB2 9.5 connection to Iseries

P: 1
Hi all,

I am new to DB2.
I want to configure replication between DB2 9.5-C Express and DB2 Iseries V5R2. I am maintaining a small database(around 50 tables) on local DB2 9.5. I want to keep exactly the same copy on Iseries V5R2. According to my understand of DB2 I though replication could be an option.
But when I try to connect from DB2 9.5 to Iseries I get following error.

CLI connection failed.
SQL8002N An attempt to connect to a host failed due to a missing DB2 Connect product or invalid license. SQLSTATE=42968

db2licm -1 displays following information
Product name: "DB2 Express-C"
License Type: "Unwarranted"
Expiry date: "Permanent"
Product identifier: db2exp"
Version information : "9.5"
Max number of CPUs: "2"

I am not sure if I can connect at all to Iseries V5R2 from DB2 9.5-C. Or even doing a replication is an a better choice.

I would request db2 gurus to help me out.

Thank
Aug 30 '08 #1
Share this Question
Share on Google+
1 Reply


Shashank1984
P: 26
G'day mate,

1) Make sure you have DB2 Connect product installed.
(All I can see from above db2licm is just DB2 Express-C)

2) There is a known defect : (see if your hitting this)
IZ08501: Connection to host/iseries using the IBM Data Server Driver for ODBC and CLI on Windows results in SQL8002N
(http://www-01.ibm.com/support/docview.wss?uid=swg1IZ08501)
Are you using drivers on Win?

Thanks,
Shashank Kharche
IBM
DB2 for Linux, Unix & Windows -Information Management Software
Aug 31 '08 #2

Post your reply

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