I am able to connect user newuser1 to the database without any problems.

> db2 connect to Feddb

Database Connection Information

Database server = DB2/6000 8.2.2
SQL authorization ID = NEWUSER1
Local database alias = FEDDB

But when I used to following command I got the error below:

> db2 connect to FEDDB user newuser1 using pass123

SQL30082N Attempt to establish connection failed with security reason "19"
("USERID DISABLED or RESTRICTED").

Server Connection Authentication (SRVCON_AUTH) = NOT_SPECIFIED
Database manager authentication (AUTHENTICATION) = SERVER
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


Please advise. Any suggestions would be greatly appreciated. Thank you!

Hold on a sec. On one line you are saying that you can connect fine. on another youa re saying that you can't. Are you having a case of a split personality?

can you clarify your question?

When I logged on as Instance owner and issued command below, I got error.

db2 connect to FEDDB user newuser1 using pass123

When I 'su' to the user newuser1 on AIX, I was able to connect database without problem.

> db2 connect to Feddb

Database Connection Information

Database server = DB2/6000 8.2.2
SQL authorization ID = NEWUSER1
Local database alias = FEDDB

It sounds like you are getting this error when you are trying to connect from a remote server. Check that user on that server. That id is most likely disabled there.

I'll check. Thanks!