db2 SQL1092N 没有执行所请求的命令的权限
win7安装db2后,创建报没有权限
解决方法:
1。将登录用户user加入DBADMNS组和系统管理员组里面
2。在db2cmd命令行下,敲入db2set DB2_GRP_LOOKUP=LOCAL,TOKENLOCAL
然后就解决了
"CCA3054N The ODBC DSN could not be registered" when adding a database from Configuration Assistant on Windows Vista, 7, or 2008
Resolving the problem
To resolve the problem, the Configuration Assistant must be explicitly launched with administrative privileges. To do this, right-click on the Configuration Assistant icon in the start menu and select the option to "Run as Administrator". Once the Configuration Assistant is launched, retry the previous steps that caused the CCA3054N error and it should complete successfully and create a system DSN on the machine.