tags:

views:

510

answers:

0

Hi I stopped my db using db2stop force. The started did a backup restarted and after that i cannot connect to db from the a client anymore i get: using the command

db2 connect to "dbname" using "user"

SQL30082N Security processing failed with reason "42" ("ROOT CAPABILITY REQUIRED"). SQLSTATE=08001

password and username are correct. When im on the server connecting using command

db2 connect to "dbname"

or

db2 connect to "dbnmae" user "user"

or

db2 connect to "dbname" user db2inst1

works just fine. I m really confused. Any help is much appreciated Thanks.

What i tried so far :

db2 get dbm cfg | grep -i auth GSS Plugin for Local Authorization
(LOCAL_GSSPLUGIN) = Server Connection Authentication
(SRVCON_AUTH) = NOT_SPECIFIED Database manager authentication
(AUTHENTICATION) = SERVER Cataloging allowed without authority
(CATALOG_NOAUTH) = NO Trusted client authentication
(TRUST_CLNTAUTH) = CLIENT Bypass federated authentication
(FED_NOAUTH) = NO

switched to client but did not using

db2 update dbm cfg using authentication client