db2icrt fails with DBI1959N after computer name change on windows server
Problem(Abstract)
On Windows server db2icrt fails with the following error after a computer name change
DBI1959N The instance directory cannot be created.
The error suggests the user does not have the write access to create the instance directory
even though the user has all the permissions,
Cause
When computer name is changed the global registry entries for groups DB2ADMNS and DB2USERS remain unchanged and are not updated, (호스트 이름이 변경되었거나 영문이 아닌 경우에도 발생할 수 있다)
Diagnosing the problem
The only way to diagnose this issue is to take a DB2 trace.
The trace will show that the we fail to get the SID for group <old computer name>\DB2USERS
Resolving the problem
Update the global registry entries with the new name for groups DB2ADMNS and DB2USERS
db2extsec -a <new computer name>\DB2ADMNS -u <new computer name>\DB2USERS
This is a mandatory requirement after a computer name change
http://www-01.ibm.com/support/docview.wss?uid=swg21597650