473,320 Members | 1,969 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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

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

Nov 12 '05 #1
0 3716

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Linda Lee | last post by:
I purchased Visual Basic .NET version 2003 Standard I first try to connect Visual Basic .NET 2003 Standard to SQL Server 2000 Personal edition. When I go into Visual Basic .NET under Server...
7
by: James Foreman | last post by:
We have 5 users of our database (DB2 UDB 8.1 on SuSE linux) : db2inst1 bill fred sarah jessica The tables are created under db2inst1, which has the ability to drop/create/alter/etc. bill,...
5
by: Frank Apap | last post by:
I am trying to call a stored procedure that has an INOUT parameter from the CLP to do some testing on a UDB 8 system. Since the value is needed as input I cannot use ? for the parameter, and...
2
by: Tatiana Zadiraka | last post by:
I use DB2 8.1 with FixPack 5. In command line for sql I get all DATE columns only in MM-DD-YYYY format. Of course, DATE('20-12-2003') gives me an error SQL0181N The string representation of a...
2
by: Erik Hendrix | last post by:
Hi, When I run a DB2 command: i.e.: db2 list tablespaces show detail and while this is running do: ps -ef | grep "db2 " then I can see in the output the db2 command as: db2 list tablespaces...
5
by: Carl Castrianni | last post by:
When running files containing many sql statements using the db2 command line processor, I`d like to have the output show the time that each sql statement was executed (so I know when they ran). ...
5
by: SaschaMoe | last post by:
Hi, I want to pass the content of a clp-file as a parameter for db2clpex? E.g.: db2clpex db2 -z log.txt -tvf "connect to mydb user myuser using mypassword;select * from table;connect reset",...
1
by: satish mullapudi | last post by:
Hi all, I am using DB2 v 8.2 , Win XP OS. I have creaed a sample situation which results in a deadlock created by appl1 & appl2.Now, I want to release one of the locks (using CLP, not Control...
4
by: bea | last post by:
Is there a way to set a default schema name by setting environment variable, so that it is set for CLP before connect to the database? Thank you.
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.