Db2 Error 42968
Contents |
Driver even though DB2 Connect license file exists in the license directory sql1598n sqlstate=42968 of the install path DB2 Connect Personal Edition: db2conpe.lic DB2
Errorcode=-4230, Sqlstate=42968
Connect Application Server Edition: db2consv_as.lic DB2 Connect Enterprise Edition: db2consv_ee.lic DB2 Connect Unlimited Edition for System db2connectactivate 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) db2 license file Problem(Abstract) 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 Connect License
DB2 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/dsdrive
ERRORCODE=-4472 SQLSTATE=42968 ERRORCODE=-4472 SQLSTATE=42968; Db2 Connect jdbc jcc license db2jcc db2jcc_license_cisuz.jar Technote (troubleshooting) Problem(Abstract) I'm trying to connect to a db2licm mainframe. I am new to JDBC connections. My java application fails with the ibm passport advantage following message. How do you locate or obtain the license jar file? "[jcc][t4][10109][10354][4.7.85] The version of the IBM
Sqlcode: -1598
Universal JDBC driver in use is not licensed for connectivity to xxx databases. To connect to this server, please obtain a licensed copy of the IBM DB2 Universal Driver for JDBC http://www-01.ibm.com/support/docview.wss?uid=swg21635635 and SQLJ. An appropriate license file db2jcc_license_*.jar for this target platform must be installed to the application class path. Connectivity to xxx databases is enabled by any of the following files: [db2jcc_license_cisuz.jar]. ERRORCODE=-4472, SQLSTATE=42968". Cause The JDBC connection checks to see if it is licensed to connect to the server by checking the CLASSPATH environment variable for db2jcc_license_cisuz.jar. If the http://www.ibm.com/support/docview.wss?uid=swg21413734 correct license file is not listed in the CLASSPATH then the error is returned. Resolving the problem To resolve the error you must add the appropriate DB2 JDBC license file to the applications CLASSPATH environment variable. If you are connecting to a host (z/OS or iSeries) then you need to add the db2jcc_license_cisuz.jar file. Where do I find the license file? The db2jcc_license_cisuz.jar file is included in all DB2 Connect server editions including DB2 Connect Personal Edition. The license is also part the IBM Database Enterprise Developer Edition. If you already have one of these products, then please use the license file from the DB2 Connect Activation CD. If you have a Passport Advantage account, then remember to download the activation key from Passport Advantage for the DB2 Connect edition that you have purchased. The db2jcc_license_cisuz.jar file is located in the /db2/license directory of the activation CD or activation file downloaded from Passport Advantage. The license files for DB2 Connect products are not shipped with fix packs. Fix packs only contain a 90 day trial license for DB2 Connect and do not
Events Forums DB2-LDB2-L ArchivesNA ConferenceEMEA Conference Resources BlogsIDUG eBulletinIDUG NewsroomCommunitiesRegional User Groups Articles&Content IDUG Content ArticlesTech ChannelBeginner's BlogDB2 Hot Topics BlogContent LibraryIDUG YouTubePast Conference http://www.idug.org/p/fo/et/thread=43013 ContentCodeplace Library GetInvolved Volunteering with IDUGVolunteer PositionsJoin a Regional User GroupBecome an IDUG MentorSponsorship OpportunitiesJoin a CommunitySpeaker Community Activate DB2 connect licence Brahmaiah Peddapadamala Activate DB2 connect licence January 10, 2014 11:25 AM Hi All, Need your help to activate DB2 db2 error connect licence, below are the steps I followed. 1) Install IBM Data Server Client Version 10.5 Fix Pack 1 . 2) From DB2 CLP,catalog tcpip node PROD remote aa.bb.c.ddd server 5001 ostype mvs 3)terminate(To refresh) 4)list node directory(To verify) 5)catalog database ODMDEV as ODMDEV at node db2 error 42968 PROD authentication SERVER_ENCRYPT 6)terminate(to refresh) 7)list db directory(to verify) 8)connect to ODMDEV user PALGUDI failed to connect and got below error: SQL1598N An attempt to connect to the database server failed because of a licensing problem. SQLSTATE=42968 9) Then I tried to copy the licence file toC:\Program Files\IBM\SQLLIB\BIN> C:\Program Files\IBM\SQLLIB\BIN>db2licm -l Product name: "IBM Data Server Client" Product identifier: "db2client" Version information: "10.5" 10) Tried to apply the licence and got below error. C:\Program Files\IBM\SQLLIB\BIN>db2licm -a db2consv_zs LIC1408N The file "C:\Program Files\IBM\SQLLIB\BIN\db2consv_zs" could not be op ened. Enter the name of a file that exists and can be opened and try the command again. Could anyone help where and what is missing? Thanks Palgudi Michael Arlebrandt SV: Activate DB2 connect licence January 11, 2014 01:55 AM (in response to Brahmaiah Peddapadamala) Hi Seems like you miss