By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,237 Members | 1,234 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,237 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.