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.

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 ??

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.

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?

it is (not authorization)
Database manager authentication (AUTHENTICATION) = SERVER
if you have a db2 client installed - try native connect from clp and see rc..

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.

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