Skip to main content

DB2 Q & A

Changed instance name

Instance 帳號名稱變更後,就無法正常執行任何指令

[cim@tpemimtst99 ~]$ db2level
SQL10007N Message "-10003" could not be retrieved.  Reason code: "3".

Solution: 編輯 ~/sqllib/db2profile

...
DB2INSTANCE=<new-account-name>
export DB2INSTANCE
INSTHOME=<new-account-home>
...