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

Bernard Dhooghe · *nix forums beginner Joined: 22 Jun 2005 Posts: 39

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

Google