By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,703 Members | 1,116 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,703 IT Pros & Developers. It's quick & easy.

Run SQL from Windows against AS/400

P: n/a
new

It seems the DB2 CLP (Command Line Processor) is the way to go (other
ideas???)

I downloaded and installed and configured and got the msg below.
However I do not understand it what gets licensed - on the AS400 or Windows?
My setup is at the bottom.

SQL8002N Connect processing failed; a valid product license was not
found.

SQLSTATE=42968

db2 =>

The final error message was looked up here:

http://publib.boulder.ibm.com/infoce...m0/sql8000.htm

Here is the error message text

SQL8002N
DRDA connect processing failed; a valid product license was not
found.
Explanation: A valid license key could not be found and the evaluation
period has expired.

User Response: Install a license key for the fully entitled version of
the product. You can obtain a license key for the product by contacting your
IBM representative or authorized dealer.

sqlcode: -8002

This is a link to where I downloaded the software from:

https://www6.software.ibm.com/dl/rtcl/rtcl-p

I then ran the setup and the post setup configuration as found here:

http://www-128.ibm.com/developerwork...301chong2.html


Jun 8 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
m
new wrote:
It seems the DB2 CLP (Command Line Processor) is the way to go (other
ideas???)

I downloaded and installed and configured and got the msg below.
However I do not understand it what gets licensed - on the AS400 or Windows?
My setup is at the bottom.

SQL8002N Connect processing failed; a valid product license was not
found.

SQLSTATE=42968

db2 =>

The final error message was looked up here:

http://publib.boulder.ibm.com/infoce...m0/sql8000.htm

Here is the error message text

SQL8002N
DRDA connect processing failed; a valid product license was not
found.
Explanation: A valid license key could not be found and the evaluation
period has expired.

User Response: Install a license key for the fully entitled version of
the product. You can obtain a license key for the product by contacting your
IBM representative or authorized dealer.

sqlcode: -8002

This is a link to where I downloaded the software from:

https://www6.software.ibm.com/dl/rtcl/rtcl-p

I then ran the setup and the post setup configuration as found here:

http://www-128.ibm.com/developerwork...301chong2.html

To connect to a HOST system (z/OS or AS/400) you need DB2 Connect. The
plain ol' windows client (ODBC) won't work.
Jun 8 '06 #2

P: n/a
new


If I have iSeries Navigator installed on the same machine would that mean I
have DB2 Connect installed?


"m" <md*******@yahoo.com> wrote in message
news:ce***************************@ALLTEL.NET...
new wrote:
It seems the DB2 CLP (Command Line Processor) is the way to go
(other ideas???)

I downloaded and installed and configured and got the msg below.
However I do not understand it what gets licensed - on the AS400 or
Windows?
My setup is at the bottom.

SQL8002N Connect processing failed; a valid product license was
not found.

SQLSTATE=42968

db2 =>

The final error message was looked up here:


http://publib.boulder.ibm.com/infoce...m0/sql8000.htm

Here is the error message text

SQL8002N
DRDA connect processing failed; a valid product license was not
found.
Explanation: A valid license key could not be found and the
evaluation period has expired.

User Response: Install a license key for the fully entitled version
of the product. You can obtain a license key for the product by
contacting your IBM representative or authorized dealer.

sqlcode: -8002

This is a link to where I downloaded the software from:

https://www6.software.ibm.com/dl/rtcl/rtcl-p

I then ran the setup and the post setup configuration as found
here:


http://www-128.ibm.com/developerwork...301chong2.html

To connect to a HOST system (z/OS or AS/400) you need DB2 Connect. The
plain ol' windows client (ODBC) won't work.

Jun 8 '06 #3

P: n/a
NO, iSeries Navigator uses the iSeries Access ODBC & JDBC drivers. Maybe, you
should just use the Run SQL Scripts interface in iSeries Navigator.

new wrote:
If I have iSeries Navigator installed on the same machine would that mean I
have DB2 Connect installed?


"m" <md*******@yahoo.com> wrote in message
news:ce***************************@ALLTEL.NET...
new wrote:
It seems the DB2 CLP (Command Line Processor) is the way to go
(other ideas???)

I downloaded and installed and configured and got the msg below.
However I do not understand it what gets licensed - on the AS400 or
Windows?
My setup is at the bottom.

SQL8002N Connect processing failed; a valid product license was
not found.

SQLSTATE=42968

db2 =>

The final error message was looked up here:


http://publib.boulder.ibm.com/infoce...m0/sql8000.htm

Here is the error message text

SQL8002N
DRDA connect processing failed; a valid product license was not
found.
Explanation: A valid license key could not be found and the
evaluation period has expired.

User Response: Install a license key for the fully entitled version
of the product. You can obtain a license key for the product by
contacting your IBM representative or authorized dealer.

sqlcode: -8002

This is a link to where I downloaded the software from:

https://www6.software.ibm.com/dl/rtcl/rtcl-p

I then ran the setup and the post setup configuration as found
here:


http://www-128.ibm.com/developerwork...301chong2.html

To connect to a HOST system (z/OS or AS/400) you need DB2 Connect. The
plain ol' windows client (ODBC) won't work.



--
Kent Milligan
ISV Enablement - System i
km***@us.eye-bee-m.com (spam trick) GO HAWKEYES!!
ibm.com/iseires/db2

(opinions stated are not necessarily those of my employer)
Jun 9 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.