IBM Support

DBI1088E error when attempting to create DB2 instance

Technote (troubleshooting)


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:

    1. 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
    2. Re-issue the 'db2icrt' command to create the DB2 instance
    3. Increase the nofile ulimit value for the DB2 instance owner in the /etc/security/limits.conf file back to it's original value

Document information

More support for: Tivoli Storage Manager

Software version: All Supported Versions

Operating system(s): Linux

Reference #: 1958057

Modified date: 25 April 2017

Translate this page: