Hello all,

Got 2 db2 instances DB2 and DB2_915, using on IBM z/VM 9 & 10. (DB2 CONNECT Client 8.1 on Windows )

I have cataloged LATIN1(819) DB on DB2 ($server1) and CYRILLIC (915) DB on DB2_915 ($server2)

I have set codepage by DB2SET CODEPAGE=xxx for each one.
So, that works and i can connect and select in every DB.

On php, when using

putenv("DB2INSTANCE=DB2");
$db = db2_connect($server1,$Logindba1,$Passdba1);
putenv("DB2INSTANCE=DB2_915");
$db = db2_connect($server2,$Logindba2,$Passdba2);

The first is ok, second returns [IBM][CLI Driver] SQL3282N error.

if I change order

putenv("DB2INSTANCE=DB2_915");
$db = db2_connect($server1,$Logindba1,$Passdba1);
putenv("DB2INSTANCE=DB2");
$db = db2_connect($server2,$Logindba2,$Passdba2);

The first is ok, second returns [IBM][CLI Driver] SQL3282N error.

So that works separately in PHP pages.

But I dont understand :
when I use db2_connect function, the following putenv() fonction seems to be inoperand.

I can't use one instance, cause DB are in different codepages.
I need to connect several DB in same PHP Page

Any solution ?

Thanks
Fred

up ! if someone got any solution

I would start with reading the explanation for the error message: