Does DB2 8.2 client support DB2 9.5 Server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Prakash - 26 Feb 2008 06:39 GMT

Hello All,

We have installed UDB 9.5 on HP-UX IA64 machine. We would like to
install DB2 8.2 client on HP-UX PA-RISC V11.11. We want to install
only on HPUX V 11.11 since we have licensed version MF Cobol on this.

My question is: Can DB2 8.2 client talk to DB2 server 9.5?

Please let me know asap.

Thanks in advance.

Reply to this Message

The Boss - 26 Feb 2008 19:13 GMT

> Hello All,
>
[quoted text clipped - 7 lines]
>
> Thanks in advance.

Let me quote the Information Center for DB2 9.5 :

Combinations of DB2 Universal Database (UDB) Version 8, DB2 Version 9.1, and
DB2 Version 9.5

DB2 Universal DatabaseT (UDB) Version 8 and DB2 Version 9.1 clients can
access a remote DB2 Version 9.5 server. Note the following restriction:
There is a restriction when a client is located on the same system as a DB2
server, and they are different versions. In this case, local
client-to-server connections using Interprocess Communication (IPC) are not
supported. Instead, a connection can be established by treating the
connection as a remote connection (called a loopback connection) using
TCP/IP.
IBM® Data Server Client, IBM Data Server Runtime Client, and IBM Data Server
Driver for ODBC, CLI, and .NET Version 9.5 can access DB2 Version 9.1 and
DB2 UDB Version 8 servers. However, new DB2 Version 9.5 functionality is not
available.

Access to DB2 Version 9.1 or Version 9.5 servers from DB2 UDB Version 7
clients is not supported.

Source:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.qb.cl
ient.doc/doc/r0009731.html

HTH

Signature

Jeroen

Reply to this Message

Prakash - 27 Feb 2008 05:41 GMT

> > Hello All,
>
[quoted text clipped - 35 lines]
> --
> Jeroen

Thank you for the details.
If I am right, can I use the all the features of the server 9.5 using
client 8.2?.
e.g: optimistic locking is new feature in 9.5 server, can I still get
this feature if I use client 8.2?.

Please let me know.

Thanks,
Prakash

Reply to this Message

Serge Rielau - 27 Feb 2008 14:13 GMT

>>> Hello All,
>>> We have installed UDB 9.5 on HP-UX IA64 machine. We would like to
[quoted text clipped - 25 lines]
>>
>> Source:http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db...

> Thank you for the details.
> If I am right, can I use the all the features of the server 9.5 using
> client 8.2?.
> e.g: optimistic locking is new feature in 9.5 server, can I still get
> this feature if I use client 8.2?.

You can use all the DB2 9.5 features that do not require the client.
Ie. you can use e.g. the RID_BIT() function and ROW_CHANGE_TOKEN, but
you cannot exploit the JDBC client integrated optimistic locking that
hides all the SQL from you.

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message