Unix Technical Forum

Re: Does DB2 8.2 client support DB2 9.5 Server

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


Go Back   Unix Technical Forum > Database Server Software > DB2

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 03:25 PM
Serge Rielau
 
Posts: n/a
Default Re: Does DB2 8.2 client support DB2 9.5 Server

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:15 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com