IBM Support

Error "SQL1022C There is not enough memory available to process the command" after changing hostname of the DB2 server.

Technote (troubleshooting)


Problem(Abstract)

After changing the hostname of the DB2 server, DB2 service on Windows fails to start with error:
SQL1022C There is not enough memory available to process the command. SQLSTATE=57011

Cause

DB2 Extended security enabled.

Resolving the problem

If you change the computer name, and the computer groups DB2ADMNS and DB2USERS are local computer groups, you must update the DB2_ADMINGROUP and DB2_USERSGROUP global registries. To update the registry variables after renaming and restarting the computer run the following command:

Open a command prompt.
Run the db2extsec command to update security settings:
db2extsec -a new computer name\DB2ADMNS -u new computer name\DB2USERS

Related information

Extended Windows security using the DB2ADMNS and DB2USE
Changing hostname

Document information

More support for: DB2 for Linux, UNIX and Windows
Database Objects/Config - Database

Software version: 9.7, 10.1, 10.5

Operating system(s): Windows

Reference #: 1966721

Modified date: 18 November 2015