Troubleshooting
Problem
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
[{"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"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21966721