This is a discussion on Re: Does DB2 8.2 client support DB2 9.5 Server within the DB2 forums, part of the Database Server Software category; --> Prakash wrote: > On Feb 27, 12:13 am, "The Boss" <use...@No.Spam.Please.invalid> wrote: >> Prakash wrote: >>> Hello All, >>> ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Prakash wrote: > On Feb 27, 12:13 am, "The Boss" <use...@No.Spam.Please.invalid> wrote: >> 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 |
| Thread Tools | |
| Display Modes | |
|
|