Db2 Sql Error 8001
Contents |
license was not found 1308412; sql1598n sqlstate=42968 TM; DB2; 8.2; CLI; ODBC; SQLSTATE=42968; SQL8001N; license Technote db2 license file (troubleshooting) Problem(Abstract) This technote explains how to resolve an error: "SQL8001N DB2 connect db2connectactivate processing failed," that can occur when testing CLI and ODBC connections in IBM Rational TestManager (TM) against an IBM DB2 back-end database
Db2licm
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 db2 connect 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. Document information More support for: Rational TestManager Datastore Software version: 7.0, 7.0.0.3, 7.0.0.4, 7.0.1, 7.0.1.1, 7.0.1.2, 7.0.1.3, 7.0.2, 2003.06.15, 2003.06.16 Operating system(s): Linux, Windows Reference #: 1308412 Modified date: 2008-10-09 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
Driver even though DB2 Connect license file exists in the license directory sqlcode of the install path DB2 Connect Personal Edition: db2conpe.lic DB2 Connect Application Server Edition: db2consv_as.lic DB2 Connect Enterprise Edition: db2consv_ee.lic DB2 Connect Unlimited Edition for System i: db2consv_is.lic DB2 Connect Unlimited Edition for System z: db2consv_zs.lic DB2 for z/OS IBM DB2 for IBM i DB2 Server for VM and VSE Technote (troubleshooting) Problem(Abstract) http://www-01.ibm.com/support/docview.wss?uid=swg21308412 SQL1598N error connecting to mainframe DB2 from IBM Data Server Driver even though DB2 Connect license file exists in the license directory of the install path Symptom Per the following Information Center link: http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.apdv.cli.doc/doc/r0024162.html It is possible to license the IBM Data Server Driver to connect to mainframe DB2 such as DB2 http://www-01.ibm.com/support/docview.wss?uid=swg21635635 for z/OS, IBM DB2 for IBM i, and DB2 Server for VM and VSE servers by copying one of these files into the installation_path/license directory. DB2 Connect Personal Edition: db2conpe.lic DB2 Connect Application Server Edition: db2consv_as.lic DB2 Connect Enterprise Edition: db2consv_ee.lic DB2 Connect Unlimited Edition for System i: db2consv_is.lic DB2 Connect Unlimited Edition for System z: db2consv_zs.lic Even after copying the license file, a test connection may fail with the following error: SQL1598N An attempt to connect to the database server failed because of a licensing problem. SQLSTATE=42968 Cause The license file copied to the license directory is from a different release. Diagnosing the problem Go to the installation_path/bin folder and run db2level. For example it may show the following: $ db2level DB21085I Instance "DB2" uses "64" bits and DB2 code release "SQL09076" with level identifier "08070107". Informational tokens are "DB2 v9.7.0.6", "s120629", "IP23421", and Fix Pack "6". Product is installed at "/opt/IBM/dsdriver/V9.7_FP6/dsdriver/.". View the
DB2; RAM; DB2 configuration; installation; http://www-01.ibm.com/support/docview.wss?uid=swg21403644 RAM server setup; CRRAM703I; configure database; Exception java.net.ConnectException; Error opening socket to server; Connection refused; ERRORCODE=-4499; SQLSTATE=08001; WSRR; service registry Technote (troubleshooting) Problem(Abstract) Attempts to configure your IBM DB2 database connection in IBM Rational Asset Manager results in "Error opening socket to server db2 sql {machine} on port 60,000 with message: Connection refused. " Symptom You see the following error message: CRRAM703I: Database - [jcc][t4][2043][11550][3.51.90] Exception java.net.ConnectException: Error opening socket to server {machine} on port 60,000 with message: Connection refused. ERRORCODE=-4499, SQLSTATE=08001 Cause A possible cause for this db2 sql error problem is that TCP/IP is not properly enabled on your DB2 database server. Resolving the problem Use the db2set DB2COMM command from the DB2 command window to start the TCP/IP connection: db2set DB2COMM=protocol_names For example, to set the database manager to start connection managers for the TCP/IP communication protocols, enter the following commands:
db2set DB2COMM=tcpip db2stop Db2start If the above command does not resolve the connection problem, contact IBM support. Related information Configuring TCP/IP communications for a DB2 instance Document information More support for: Rational Asset Manager Installation Software version: 7.1 Operating system(s): Linux Reference #: 1403644 Modified date: 2014-12-10 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility