Troubleshooting
Problem
This technote explains how to resolve an error: "SQL8001N DB2 connect processing failed," that can occur when testing CLI and ODBC connections in IBM® Rational® TestManager (TM) against an IBM DB2® back-end database from client to server.
Symptom
When testing the connection of a DB2 database from client to server, you will get the following error message:
CLI connection failed.
SQL8001N DB2 connect processing failed, a valid product license was not found. SQLSTATE=42968
IBM CLI Driver
ODBC connection failed.
SQL8001N DB2 connect processing failed, a valid product license was not found. SQLSTATE=42968
Resolving The Problem
The error references that the DB2 license key has expired. To resolve this issue, you will need to do the following:
- Locate your license key named db2exp.lic(server) or db2exp_u.lic(user) from the install packages DB2\EXP\image\db2\license directory.
- Once have located this DB2 license key file, simply double-click on it. You will see a DOS window open and close promptly.
[{"Product":{"code":"SSSHVH","label":"Rational TestManager"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Datastore","Platform":[{"code":"PF033","label":"Windows"},{"code":"PF016","label":"Linux"}],"Version":"2003.06.15;2003.06.16;7.0;7.0.1;7.0.1.1;7.0.0.3;7.0.1.2;7.0.0.4;7.0.1.3;7.0.2","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21308412