Type 4 driver licencing error message ....

[Raquel]

This is the scenario:

We have DB2 Connect EE V8.1 installed on Sun sever. On my Windows PC, I
have DB2 UDB PE 8.1 installed (Expiry date "Permanent").

When I try to access z/OS data using type 2 driver through a Java program
on my PC, works fine.

However, when I try to access z/OS data using type 4 driver through a Java
program on my PC, it gives a message:

"Error -com.ibm.db2.jcc.a.SqlException: The version of the IBM Universal
JDBC driver in use is not licensed for connectivity to z/OS databases. To
connect to th
is DB2 server, please obtain a licensed copy of the IBM DB2 Universal
Driver for JDBC and SQLJ. An appropriate license file
db2jcc_license_*.jar for this target platform must be installed to the
application classpath. Connectivity to z/OS databases is enabled by any
of the following license files: { db2jcc_license_cisuz.jar }"

Why these special licencing requirements only for Type 4 driver and how
can I obtain the licence?

TIA
Raquel.

[Ian]

Raquel wrote:

This is the scenario:

We have DB2 Connect EE V8.1 installed on Sun sever. On my Windows PC, I
have DB2 UDB PE 8.1 installed (Expiry date "Permanent").

When I try to access z/OS data using type 2 driver through a Java program
on my PC, works fine.

However, when I try to access z/OS data using type 4 driver through a Java
program on my PC, it gives a message:

"Error -com.ibm.db2.jcc.a.SqlException: The version of the IBM Universal
JDBC driver in use is not licensed for connectivity to z/OS databases. To
connect to th
is DB2 server, please obtain a licensed copy of the IBM DB2 Universal
Driver for JDBC and SQLJ. An appropriate license file
db2jcc_license_*.jar for this target platform must be installed to the
application classpath. Connectivity to z/OS databases is enabled by any
of the following license files: { db2jcc_license_cisuz.jar }"

Is your java app connecting via the DB2 Connect server or trying to
connect directly to the mainframe?

[Raquel]

Java app is connecting via DB2 Connect server.

Actually can a java application connect *directly* to mainframe (without
DB2 connect or any third party connect software). I did not know that and
would be definitely interested to know how. Things are moving fast and I
have just started...

TIA
Raquel.

[Michael Reinfeld]

Hi Raquel,
the licence is included by your DB2 Connect produkt. Copy the licence file
db2jcc_license_cisuz.jar from your DB2 Connect server to the CLASSPATH of
your client.
Your are right that you can connect to z/OS databases with the type 4 driver
without any middleware. But you need a DB2 Connect licence. That is the
reason why the file db2jcc_license_cisuz.jar is not included by the normal
DB2 Client software.

"Raquel" <ra****@nospam.com> schrieb im Newsbeitrag
news:14******************************@localhost.ta lkaboutdatabases.com...

This is the scenario:

We have DB2 Connect EE V8.1 installed on Sun sever. On my Windows PC, I
have DB2 UDB PE 8.1 installed (Expiry date "Permanent").

When I try to access z/OS data using type 2 driver through a Java program
on my PC, works fine.

However, when I try to access z/OS data using type 4 driver through a Java
program on my PC, it gives a message:

"Error -com.ibm.db2.jcc.a.SqlException: The version of the IBM Universal
JDBC driver in use is not licensed for connectivity to z/OS databases. To
connect to th
is DB2 server, please obtain a licensed copy of the IBM DB2 Universal
Driver for JDBC and SQLJ. An appropriate license file
db2jcc_license_*.jar for this target platform must be installed to the
application classpath. Connectivity to z/OS databases is enabled by any
of the following license files: { db2jcc_license_cisuz.jar }"

Why these special licencing requirements only for Type 4 driver and how
can I obtain the licence?

TIA
Raquel.

[Raquel]

I cannot find db2jcc_license_cisuz.jar in sqllib/java on the Sun Server.
The only files in this directory are:

Common.jar db2fs.jar db2java.zip db2jcc.jar

Is there any other place I should look at, to find
db2jcc_license_cisuz.jar?

TIA
Raquel.

[Larry]

Probably on the DB2 Connect CD. Did you install DB2 Connect on that server?

Larry Edelstein

Raquel wrote:

I cannot find db2jcc_license_cisuz.jar in sqllib/java on the Sun Server.
The only files in this directory are:

Common.jar db2fs.jar db2java.zip db2jcc.jar

Is there any other place I should look at, to find
db2jcc_license_cisuz.jar?

TIA
Raquel.

[Raquel]

It is a gone case then. I have no idea who installed DB2 Connect on the
server or where the CD is...but I can't imagine why the person who
installed DB2 connect would not copy the license files..or if he did copy
the license file, why would someone delete it..very surprising...

Raquel.