Results 1 to 9 of 9
  1. #1
    Join Date
    Mar 2004
    Posts
    448

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

  2. #2
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276
    hi,
    test authentication at the client is server_encrypt

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    have you done db2updv7 on the database server ?
    Visit the new-look IDUG Website , register to gain access to the excellent content.

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

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

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

  7. #7
    Join Date
    Mar 2004
    Posts
    448

    Angry

    Hi Lekharaju,


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

    regards,

    mujeeb

  8. #8
    Join Date
    Mar 2004
    Posts
    448
    still struck here.

    regards,

    mujeeb

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •