I am not able to create or drop database, but i can stop and start db2 instance.

User is a domain user, but memeber of local Administrator group and
DB2ADMNS local group which is SYSADM_GROUP in dbm cfg.
OS windows XP.

i tried setting DB2_GRP_LOOKUP=LOCAL or
DB2_GRP_LOOKUP=LOCAL,TOKENLOCAL , but no use.

Any suggestions.

To drop a db user should have either sysadm or sysctrl Authorization. Please check what type of Authorization your user id had.

Thanks
Naval K

paste the output of

db2 get authorizations

regds
Paul

Hi i am not sure what i did , but now it is fine.

U:\>db2 get authorizations

Administrative Authorizations for Current User

Direct SYSADM authority = NO
Direct SYSCTRL authority = NO
Direct SYSMAINT authority = NO
Direct DBADM authority = NO
Direct CREATETAB authority = NO
Direct BINDADD authority = NO
Direct CONNECT authority = NO
Direct CREATE_NOT_FENC authority = NO
Direct IMPLICIT_SCHEMA authority = NO
Direct LOAD authority = NO
Direct QUIESCE_CONNECT authority = NO
Direct CREATE_EXTERNAL_ROUTINE authority = NO
Direct SYSMON authority = NO

Indirect SYSADM authority = YES
Indirect SYSCTRL authority = NO
Indirect SYSMAINT authority = NO
Indirect DBADM authority = NO
Indirect CREATETAB authority = YES
Indirect BINDADD authority = YES
Indirect CONNECT authority = YES
Indirect CREATE_NOT_FENC authority = NO
Indirect IMPLICIT_SCHEMA authority = YES
Indirect LOAD authority = NO
Indirect QUIESCE_CONNECT authority = NO
Indirect CREATE_EXTERNAL_ROUTINE authority = NO
Indirect SYSMON authority = NO