IBM Support

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



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


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

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Database Objects\/Config - Database","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1;10.5;9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018