Linux 5.2 DB2 V9.5 FP 6a.

We are trying to give our developers access to DB2 on a Linux server but so no success. Our Linux admin created a local group in Linux server and add those developers' domain accounts into it. Then, I pulled the local group into DB2 database (User and Group Objects --> DB Groups) and give "Connect to Database" access but not successful.

I even stop/start DB2 but no luck.

Domain group name looks like "SOMEDOMAIN\domain^users" on the linux server. It is Windows controlled domain.

Error: SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001.



Is there any way to accomplish this ?.

Thanks.

Can you confirm the users are able to login to the linux server using ssh?

Are you using Samba to integrate to Active Directory?

Thank you for your reply. Yes, they are able to logon to Linux server.

With

if [ -f /home/db2inst1/sqllib/db2profile ]; then
. /home/db2inst1/sqllib/db2profile
fi


in their profile, they are able to run some DB2 commands but can not connect to the database with the local group account given permissions to connect to the database.

No we are not using Samba..............Thanks

Calvin.

By default DB2 enumerates the users' group on the system where the users are defined, that is, in the AD in your case.

Try setting the registry variable DB2_GRP_LOOKUP to LOCAL.

Thanks...........I set the DB2_GRP_LOOKUP to LOCAL but no luck. I stop and restart DB2 and even reboot the server but the same error.

SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR
PASSWORD INVALID"). SQLSTATE=08001