Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2004
    Posts
    2

    Post Unanswered: DB2 V8 communicate with DB2 V7 problem?

    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?

  2. #2
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Compability Issues

    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
    HTH

    Nitin

    Ask the experienced rather than the learned

  3. #3
    Join Date
    Sep 2002
    Posts
    456

    Re: DB2 V8 communicate with DB2 V7 problem?

    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


    Originally posted by Howard He
    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?

  4. #4
    Join Date
    Oct 2003
    Posts
    11

    Re: DB2 V8 communicate with DB2 V7 problem?

    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.

  5. #5
    Join Date
    Feb 2004
    Posts
    2

    Re: DB2 V8 communicate with DB2 V7 problem?

    hi all, thank you help.

  6. #6
    Join Date
    Sep 2002
    Posts
    456

    Re: DB2 V8 communicate with DB2 V7 problem?

    did you figure out the solution?

    dollar

    Originally posted by Howard He
    hi all, thank you help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •