Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2011
    Posts
    18

    Red face Unanswered: Client authorization

    hi all,
    after running db2 "RESET DBM CFG" command, is there any parameter in dbm cfg hav to configure(db2 8.2 on AIX)?
    as bcoz of running this command. i unable to connect with client tool(RAZOR SQL) and through application also.
    i can access AIX db2 even all type of commands running fine..
    but client is not accessible with db2 instance.


    Thank you.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    check authentication - default is server - so connect is needed with target userid/pw from system where db2 is residing - also check svcename - this is the mapping to the port the instance is listening
    and the error is ??
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Dec 2011
    Posts
    18

    Red face Check authorization

    thank you.

    but how to check authorization? i mean is there any command?

    by running db2 "get dbm cfg " i got this o/p regarding authorization..

    Client Userid-Password Plugin (CLNT_PW_PLUGIN) =
    Client Kerberos Plugin (CLNT_KRB_PLUGIN) = IBMkrb5
    Group Plugin (GROUP_PLUGIN) =
    GSS Plugin for Local Authorization (LOCAL_GSSPLUGIN) =
    Server Plugin Mode (SRV_PLUGIN_MODE) = UNFENCED
    Server List of GSS Plugins (SRVCON_GSSPLUGIN_LIST) =
    Server Userid-Password Plugin (SRVCON_PW_PLUGIN) =
    Server Connection Authentication (SRVCON_AUTH) = NOT_SPECIFIED
    Database manager authentication (AUTHENTICATION) = CLIENT
    Cataloging allowed without authority (CATALOG_NOAUTH) = NO
    Trust all clients (TRUST_ALLCLNTS) = YES
    Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
    Bypass federated authentication (FED_NOAUTH) = NO


    and if there any updation do let me know.
    thank you.

  4. #4
    Join Date
    Dec 2011
    Posts
    18

    Red face Check authorization

    when i am trying to connect to client tool (RAZOR SQL) it gives

    ERROR: An error occurred while trying to make a connection to
    the database:

    JDBC URL: jdbc:db2://172.20.2.51:50000/IRISDBTO

    [jcc][t4][2043][11550][3.57.82]
    Exception java.net.ConnectException:
    Error opening socket to server /172.20.2.51 on
    port 50,000 with message: Connection refused: connect. ERRORCODE=-4499,
    SQLSTATE=08001

    bt working fine on AIX.

    what to do?

  5. #5
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    it is (not authorization)
    Database manager authentication (AUTHENTICATION) = SERVER
    if you have a db2 client installed - try native connect from clp and see rc..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  6. #6
    Join Date
    Dec 2011
    Posts
    18

    Red face Check authorization

    thank u 4 ur reply.
    as u said,
    Database manager authentication (AUTHENTICATION) = SERVER

    i have client tool (RAZOR SQL)
    i dnt understand ur last line.
    wht do i check?

    thanks again.

  7. #7
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    all doc is available here
    IBM DB2 9.5 Information Center for Linux, UNIX, and Windows
    try to find how to setup a client connection and test this connection
    Configuring client-to-server connections using the command line processor
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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