Troubleshooting
Problem
cannot set user id: Resource temporarily unavailable when trying to log into a DB2 instance
Symptom
When attempting to log into a DB2 instance the error above will be returned to the console.
Cause
The most common cause is a lower resource setting in one or more of the following areas:
- If the nosuid option is set at the mount point of this file system this error will occur.
- Adjust the /etc/security/limits.conf and increase the number of processes allowed.
- Extend the nproc value in /etc/security/limits.conf for the user.
Environment
Linux ONLY
Diagnosing The Problem
Review the kernel settings and /etc/security/limits.conf and ensure they meet the minimum requirements in both links noted below.
Related Information
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Database Objects\/Config - Instance","Platform":[{"code":"PF016","label":"Linux"}],"Version":"9.7;10.1;10.5","Edition":"Advanced Enterprise Server;Advanced Workgroup Server;Enterprise Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21965867