Explanation
The server was unable to allocate a handle to
the database environment.
System action
User response
The following are possible causes and solutions:
- 1. The most common cause is that the DSMSERV utility is not being
run as the instance owner, or the user profile (db2profile) has not
been sourced for the current login shell. To resolve the issue, log
in as the instance user and source the DB2® profile,
db2profile: . /home/tsminst1/sqllib/db2profile Note: Ensure that you
insert a space after the initial dot.
- 2. A mismatch between the /etc/hosts file and the ~/sqllib/db2nodes.cfg
file. If the host name was recently updated, ensure that the systems
host name in the /etc/hosts file matches the host name in the ~/sqllib/db2nodes.cfg
file. If the files contain the same host name, see the db2diag.log
files for more information. For information about the db2nodes.cfg
file, see the DB2 documentation.
- 3. The database manager cannot be started due to insufficient
system resources. Review the current operating system kernel settings
and ulimit settings for parameters like nofiles for the user who is
starting the DSMSERV program. Increase the values if needed. For information
about changing kernel and ulimit values, see the documentation for
your operating system. For guidelines concerning ulimit settings on Tivoli® Storage Manager servers
search for "user limits" in the appropriate version of the product information.
For guidelines concerning operating system kernel parameters, search
for "tuning kernel parameter" in the product information.
- 4. Instance entries are missing from the /etc/services file. If
the entries do not exist in the /etc/services file, re-create the
entries as in this example: DB2_tsminst1 60000/tcp DB2_tsminst1_1
60001/tcp DB2_tsminst1_2 60002/tcp DB2_tsminst1_END 60003/tcp As a
general rule, these entries are placed near the end of the /etc/services
file. Replace tsminst1 with the name of the Tivoli Storage Manager instance that is being
used on the server.
- 5. A copy of the DB2APP64.dll file is in the server instance directory.
In some cases, users mistakenly copy the DB2APP64.dll file to the
server instance directory from the installation directory. By default,
the installation directory is C:\Program Files\Tivoli\TSM\db2\BIN.
The DB2APP64.dll file should be in this directory only. Any additional
copies of this DLL file should be removed.