Does DB2 8.2 client support DB2 9.5 Server

[Prakash]

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.

[The Boss]

Prakash wrote:

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.

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/infoce.../r0009731.html

HTH

--
Jeroen

[Prakash]

On Feb 27, 12:13*am, "The Boss" <[e-mail]:

Prakash wrote:

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.

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/infoce...pic/com.ibm.db...

HTH

--
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

[Serge Rielau]

Prakash wrote:

On Feb 27, 12:13 am, "The Boss" <[e-mail]:

>Prakash wrote:

>>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.

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/infoce...pic/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
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab