IBM Support

SQL1598N connecting to a host migrated from DB2 z/OS V9 NFM to V10 CM 9

Troubleshooting


Problem

SQL1598N may occur on a DB2 Client or DB2 Connect after DB2 z/OS has been migrated from DB2 V9 NFM to DB2 V10 CM 9 and a valid DB2 Connect Unlimited Edition license has been applied to DB2 z/OS while at V9 NFM.

Symptom

Here are three examples of the error message:

  • Using CLP:

    db2 => connect to <dbname> user <xyz>
    Enter current password for<xyz>:

    SQL1598N An attempt to connect to the database server failed because of a  licensing problem.  SQLSTATE=42968


    CLP is not present in IBM Data Server Driver, hence, use CLPPlus or db2cli instead to demonstrate the error with DS driver product. 

  • Using CLPPlus:

    CLPPlus is available starting DB2 Version 9.7.

    C:\>clpplus <username>@<dsn alias>
    CLPPlus: Version 1.4
    Copyright (c) 2009, 2011, IBM CORPORATION.  All rights reserved.

    Enter password: **********

  • Using db2cli:

    db2cli validate -dsn <dsn name> -connect -user <username> -passwd <password>

    db2cli utility is available starting DB2 Version 9.7 Fix Pack 3a.

Cause

The reason for this behavior is that the license activation logic in the drivers, as well as the license activation tool itself is incorrectly treating a DB2 V10 CM9 level server as if it was DB2 V10 CM8, thus, when a DB2 Connect driver is connected to a DB2 z/OS V10 CM9 system, an incorrect license validation mechanism is being utilized.

Resolving The Problem

Note: This is applicable only when server license activation utility of DB2 Connect Unlimited Edition is in place.

Reactivate the server side license again on the migrated z/OS database i.e DB2 V10 CM 9 using the db2connectactivate - Server license activation utility

The server license activation utility db2connectactivate is available in DB2 Connect Unlimited Edition only starting with DB2 V9.7 FP3 (9.7.0.3).

The following example activates the license for DB2 Connect Unlimited Edition for System z on a DB2 for z/OS subsystem:

db2connectactivate.sh -host myzos.ibm.com -port 446 -database payroll –user db2admin –password adminpassword

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Install\/Migrate\/Upgrade - Licensing","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSEPDU","label":"Db2 Connect"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":null,"Platform":[{"code":"","label":""}],"Version":"9.7;10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21589320