Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11

    Unanswered: asnclp license as400

    using db2 aese 10.5 on linux
    having db2 connect for as400 connection
    Product name: "DB2 Advanced Enterprise Server Edition"
    License type: "CPU Option"
    Expiry date: "Permanent"
    Product identifier: "db2aese"
    Version information: "10.5"
    Enforcement policy: "Soft Stop"

    Product name: "DB2 Connect Enterprise Edition"
    License type: "User"
    Expiry date: "Permanent"
    Product identifier: "db2consv"
    Version information: "10.5"
    Concurrent connect user policy: "Disabled"
    Enforcement policy: "Soft Stop"
    Number of licensed authorized users: "1"

    the needed jar file is also present
    [db2itoo@s999jclnx090 db2temp]$ ll ../sqllib/java/db2jcc_license_cisuz.jar
    -r--r--r-- 1 bin bin 1467 Mar 8 10:33 ../sqllib/java/db2jcc_license_cisuz.jar


    I can connect to the db at as400 and query : all ok
    I try to setup sql replication using asnclp as we don't have x-mgr for db2rc

    created all needed tables
    SET SERVER TARGET TO DB GFDIDB2 ID userid PASSWORD "password"; I can connect with this user and pw from command line
    CREATE MEMBER IN SETNAME SET_PMMQT APPLYQUAL AQ_TO_AS400_HI_A ACTIVATE YES
    SOURCE DIL.PERSON_MUTUALITY_MQT
    TARGET NAME LIBCXFIL40.PERSON_MUTUALITY_MQT
    DEFINITION TYPE USERCOPY
    COLS ALL REGISTERED;
    when executing
    ASN1561E Connection to the server "GFDIDB2" cannot be established. An SQL error was encountered. SQL message: "[jcc][10509][13454][3.69.24] Connection to the data server failed. The IBM Data Server for JDBC and SQLJ license was invalid
    or was not activated for the DB2 for z/OS subsystem. If you are connecting directly to
    the data server and using DB2 Connect Unlimited Edition for System z, perform the
    activation step by running the activation program in the license activation kit.
    If you are using any other edition of DB2 Connect, obtain the license file,
    db2jcc_license_cisuz.jar, from the license activation kit, and follow the installation
    directions to include the license file in the class path. ERRORCODE=-4230, SQLSTATE=42968".

    lic is ok - connect is ok - jar is present
    any hint on this
    ....
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  2. #2
    Join Date
    Apr 2012
    Posts
    1,006
    Provided Answers: 16
    Check what needs to be done at the iseries end. If in doubt, take jdbc trace at linux end to see if any negative response came from iseries. Also can try simple jar test of the connectivity from linux just to eliminate asnclp issue.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •