DB2 Z/OS - Cross Region Alias Not Working v8 Clients ?

Bill

Hi All,
I have a cross region alias defined - DB2 Z/OS v8

When I execute 'SELECT * FROM AAA.X_REGION_ALIAS' I get the following
results;

SPUFI - works fine

DB2 Client v7 - works fine - (query executed via JAVA & MS Excel)

DB2 Client v8 - fails - (query executed via JAVA & MS Excel)

[IBM][CLI DRIVER][DB2] SQL0204N "AAA.X_REGION_ALIAS" is an undefined name.
SQLSTATE=42704

I've tried this on multiple desktop machines / connecting to multiple
servers. All exhibit the same symptoms.

- Any idea what could be wrong with the v8 client set-up ?
(All other functionality apart from querying x-region alias appears to be
working fine)

TIA

Bill

Oct 13 '06 #1