Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

DB2 UDB LUW 8.2:clp 32 bit connect to 64 bit engine

 
   Database Help (Home) -> DB2 RSS
Next:  How toCopy data from Table 1 to Table 2 via scipt  
Author Message
dhoogheb

External


Since: Jan 07, 2005
Posts: 2



(Msg. 1) Posted: Wed Feb 23, 2005 2:13 am
Post subject: DB2 UDB LUW 8.2:clp 32 bit connect to 64 bit engine
Archived from groups: comp>databases>ibm-db2 (more info?)

Environment: DB2 UDB LUW (AIX) 8.2
Database instance: test migration to 64 bit
Clients: 32 bit, embedded sql, db2 clp

When PATH/LIBPATH point to the 32 lib environment
(/usr/opt/db2_08_01/bin and (/usr/opt/db2_08_01/lib)

db2 clp receives a DB21015E at connect attempt.

It is a local connect:

db2 connect to <dbase>,

without userid/password.

When doing su - ~instance-of-db, the PATH/LIBPATH contain 64 bit
executables/libraries and the clp works fine.

Question: DB2 8.x was designed to allow 32 bit clients access 64 bit
instances, is there a error somewhere in the setup made?

Remarks: 32 bit local clients (Cobol) work fine when PATH/LIBPATH
contain first references to the 32 bit environment it is linked with
(LIBPATH=/usr/opt/db2_08_01/lib, ...) but db2 clp does not work then

when setting PATH/LIBPATH to 64 bit first
(LIBPATH=/usr/opt/db2_08_01/lib64:/usr/opt/db2_08_01/lib, ...), db2 clp
work, but the 32 bit client (Cobol) can not load.

Bernard Dhooghe

 >> Stay informed about: DB2 UDB LUW 8.2:clp 32 bit connect to 64 bit engine 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Not able to connect to db ! - Hi All, Am using Db2 v.8.2 ESE on Win 2003 Server. Am trying to connect to an already created db. But am getting the following error: db2 connect to DBNAME SQL1226N The maximum number of client connections are already started. SQLSTATE=57030 This is th...

How to connect IBM DB2 with JSP? - Hello everyone. I m having my databse in access till now. Now i want to use IBM DB2, can you help me by telling how to connect the IBM DB2 with a JSP application? Thanks Kartikeya

DB2 CONNECT configure and Sysplex support - Hi, All, I have question on DB2 CONNECT configure. We installed DB2 ESE V8 FixPak 14 o AIX . When we set up the connection to DB2 Mainframe. We just catalog node and DB directory without DCS. From what I know, DB2 conenct needs to set up node, dcs and db...

db2 connect 4 minut delay after adding partitions - Hi! I have a previous post on the subject that connect takes a long time. I uninstalled db2 completely. Installed V9.5 Installed fixpack 1 created das created an instance installed database sample. Tested to connect to sample from DB2 CC - Worked OK..

DB2 EE (or Connect) and iSeries Scrollable cursor problem - Hello, I'm trying to retrieve some records in my web application using a jdbc Statement like this: statement = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); resultSet = statement.executeQuery(...); with DB2..
   Database Help (Home) -> DB2 All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]