win7安装db2 8.2客户端后，创建报没有权限SQL1092

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.