Problem DB2 9.5 connection to Iseries

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Saharian
    New Member
    • Aug 2008
    • 1

    Problem DB2 9.5 connection to Iseries

    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: "Unwarrante d"
    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
    New Member
    • Jul 2007
    • 26

    #2
    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

    Comment

    Working...