DBI1088E error when attempting to create DB2 instance
Attempts to create a DB2 instance via the 'db2icrt' command fail due to the following error:
DBI1088E Invalid access permission detected for directory <instance dir>.
The DBI1088E error suggests a permissions problem and, as described in technote #1397962, this error may occur as the result of an underlying permissions problem. However, this error may also be seen if the ulimit for the number of open files (nofile) is set too large for the DB2 instance owner.
Diagnosing the problem
This problem behavior has been seen with a nofile ulimit value larger than 1048576. If the failure is occurring due to the nofile user limit value being set too large, then an attempt to su to the DB2 instance owner will also fail:
# su - tsminst1 -c /bin/pwd
could not open session
Resolving the problem
Perform the following actions to allow for the successful creation of the DB2 instance:
- Temporarily decrease the nofile ulimit value for the DB2 instance owner in the /etc/security/limits.conf file; the value will need to be less than 1048577
- Re-issue the 'db2icrt' command to create the DB2 instance
- Increase the nofile ulimit value for the DB2 instance owner in the /etc/security/limits.conf file back to it's original value
Translate this page: