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

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-24-04, 11:53
bmujeeb bmujeeb is offline
Registered User
 
Join Date: Mar 2004
Posts: 448
connection problem

connection problem db2 v7 fixpak 11
client v8 fixpak 5

The authentication at the server is server_encrypt
The authentication at the client is server

node/database has been catalog

but when try to connect get this error sql30082n security reason 17
unsupported function

regards,

mujeeb
Reply With Quote
  #2 (permalink)  
Old 08-24-04, 18:15
achiola achiola is offline
Registered User
 
Join Date: May 2002
Location: General Deheza, Cba, Arg.
Posts: 273
hi,
test authentication at the client is server_encrypt
Reply With Quote
  #3 (permalink)  
Old 08-25-04, 13:01
sathyaram_s sathyaram_s is offline
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,534
have you done db2updv7 on the database server ?
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
  #4 (permalink)  
Old 08-26-04, 09:52
famudba famudba is offline
Registered User
 
Join Date: Jan 2004
Location: Tallahassee, FL, USA
Posts: 96
what is you DBM cfg for your server and client,

let me know , based on it , can be fixed.


--Lekharaju Ennam
__________________
Lekharaju Ennam
Certified Oracle8i & DB UDB DBA
Florida A&M University
Reply With Quote
  #5 (permalink)  
Old 08-26-04, 09:56
famudba famudba is offline
Registered User
 
Join Date: Jan 2004
Location: Tallahassee, FL, USA
Posts: 96
if you are DB sever is V7 and your client is V8 , to acces DB2 server , need to bind bunch packages from your client, connect as instance

go to ..\sqllib\bnd

run this scripts, save it in a file ( may be pkgv8bnd.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 ;


connect to DB as instance onwer


db2 -tvf pkgv8bnd.sql -z pkgv8bnd.log


--
__________________
Lekharaju Ennam
Certified Oracle8i & DB UDB DBA
Florida A&M University
Reply With Quote
  #6 (permalink)  
Old 08-26-04, 15:51
bmujeeb bmujeeb is offline
Registered User
 
Join Date: Mar 2004
Posts: 448
My authentication for server is server_encrypt
for client it is server

I already ran the db2updv7

regards,

mujeeb
Reply With Quote
  #7 (permalink)  
Old 08-26-04, 15:56
bmujeeb bmujeeb is offline
Registered User
 
Join Date: Mar 2004
Posts: 448
Angry

Hi Lekharaju,


How can I run this scripts when I have trouble of connecting.

regards,

mujeeb
Reply With Quote
  #8 (permalink)  
Old 08-27-04, 15:40
bmujeeb bmujeeb is offline
Registered User
 
Join Date: Mar 2004
Posts: 448
still struck here.

regards,

mujeeb
Reply With Quote
  #9 (permalink)  
Old 08-27-04, 16:08
bmujeeb bmujeeb is offline
Registered User
 
Join Date: Mar 2004
Posts: 448
After reading I found that server_encrypt is not supported for connecting
v8 client to v7 db. is there any body using the same authentication
structure.

regards,

mujeeb
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