Hi all
I have to use data on a remote DB2 server which using V7, and I installed DB2 V8 at local. the OS is AIX ,and db2 have latest fixpak

after catalog node and db to local server. type the following command to verify .

>db2 connect to dgsamp71 user db2user using password

But got error msg:

SQL0902C A system error (reason code = "200x1232"("0200")"") occurred.
Subsequent SQL statements cannot be processed. SQLSTATE=58005

I'm not sure it's a communication problem between the db2 v8 and db2 v7 ? Does anybody can help me?

Hi,

Due to the architectural changes in DB2 V7 and V8 you would not be able to connect to a V7 Database using a V8 client and vice versa.

Hope that helps.

Nitin

You need to play around with some DRDA settings. This is documented in one of DB2 manual, I don't know right now which one though!!! (look into "Whats New" guide of V8 and I think there is a pointer, follow the link below to access that)

http://www-3.ibm.com/cgi-bin/db2www/...bs.d2w/en_main

Re. V7 client connecting to V8 databases, that is possible, we have that setup in our organization without any problem and setup required is nothing compared to V8 connectivity to V7.

dollar

Hi,

I have encountered similar problem and this is what we found out

Version 8 clients can connect to version 7 servers only if the version 7 server is running DRDA-AS. Version 7 clients can connect to version 8 with limited capacity.

hi all, thank you help.

did you figure out the solution?

dollar