If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Restriction between client and server

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-27-04, 13:33
haburai haburai is offline
Registered User
 
Join Date: Dec 2003
Posts: 10
Restriction between client and server

Exist any restrictions when I would like to make connection from DB2 client version 8.1 to DB2 server version 7.2 ?
Thanks for answer.
Reply With Quote
  #2 (permalink)  
Old 07-27-04, 14:20
bmujeeb bmujeeb is offline
Registered User
 
Join Date: Mar 2004
Posts: 448
The client/server layer has been rewritten in v8.
should check

There are many restrictions with this client/server connectivity. For a complete list of the restrictions, please refer to the What's New in V8 manual, Chapter 1 Introduction to DB2 Universal Database Version 8.

regards,

mujeeb
Reply With Quote
  #3 (permalink)  
Old 07-28-04, 09:48
famudba famudba is offline
Registered User
 
Join Date: Jan 2004
Location: Tallahassee, FL, USA
Posts: 96
R U you try to access V7 DB server from V8 client??

you can access , but restrictions sql1326 .


also you need to bind nessary PKGs

can be done in 2 ways


1. from DB2CA ( configuration assistant)
type from dos prompt db2ca, that will take you there, highlight the instance , right click on it, select bind option , enter instance owner userid & passwd , click on bind, that will bind all needed PKGs.


2 run this scripts
from ...\sqllib\bin directory

put in scripts in file like dbpkgbnd.sql

bind db2ajgrt.bnd blocking all grant public ;
bind db2arxcs.bnd blocking all grant public ;
bind db2arxrr.bnd blocking all grant public ;
bind db2arxur.bnd blocking all grant public ;
bind db2arxrs.bnd blocking all grant public ;
bind db2arxnc.bnd blocking all grant public ;
bind db2clpcs.bnd blocking all grant public ;
bind db2clprr.bnd blocking all grant public ;
bind db2clpur.bnd blocking all grant public ;
bind db2clpnc.bnd blocking all grant public ;
bind db2uredp.bnd blocking all grant public ;
bind db2urexp.bnd blocking all grant public ;
bind db2uimpm.bnd blocking all grant public ;
bind db2uimtb.bnd blocking all grant public ;
bind db2ueiwi.bnd blocking all grant public ;
bind db2uigsi.bnd blocking all grant public ;
bind db2uiici.bnd blocking all grant public ;
bind db2uiict.bnd blocking all grant public ;
bind db2ugtpi.bnd blocking all grant public ;
bind db2pctsp.bnd blocking all grant public ;
bind db2dropv.bnd blocking all grant public ;
bind db2ucktb.bnd blocking all grant public ;
bind db2uqtpd.bnd blocking all grant public ;
bind db2uqtnm.bnd blocking all grant public ;
bind db2ulxld.bnd blocking all grant public ;
bind db2uipkg.bnd blocking all grant public ;
bind db2atld.bnd blocking all grant public ;
terminate ;


run as below


db2 -tvf dbpkgbnd.sql -z dbpkgbnd.log

reconnect to DB , then try it


Hope it may helps.


Thank You


Lekharaju Ennam
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On