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
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