SQL1219N 因為未能分配專用虛擬記憶體，所以請求失敗。 SQLSTATE=57011

環境： db2 v9.7 , windows xp

今天不知怎得，連線DB2資料庫一直報這個錯誤“SQL1219N  因為未能分配專用虛擬記憶體，所以請求失敗。  SQLSTATE=57011”，開始一直以為是記憶體不夠用，於是重啟電腦，並將其它的程式關掉。仍無法解決問題。在網上找了半天，發現說有個全域性變數DB2_EXTSECURITY可以解決這個問題。於是的命令列輸入： db2set  DB2_EXTSECURITY=NO ,重新啟動資料庫即可連線。

 

這個變數DB2_EXTSECURITY描述如下：

DB2 version 8.2 on Windows contains a new security feature that
controls access to DB2 system files, registry keys, and network
shares. The security feature is enabled by default by setting
the DB2 registry variable DB2_EXTSECURITY=YES during
installation of DB2. Attempts to use the DB2 product under a
userid that is not part of either the DB2USERS or DB2ADMNS group
on Windows, will result in a variety of symptoms, including, but
not limited to the following:

- SQL1224N - database agent could not be started.
- Various permissions errors using the DB2 CLP.
- DB2 processes that unexplainably abend.