[Saharian]

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

[Shashank1984]

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