刚刚在XP上装了DB2 9.7,启动任务中心就报错,错误如下:
ICM0003N An SQL error occurred while searching for objects.
[IBM][CLI Driver][DB2/NT] SQL0551N "ADMINISTRATOR" does not have
the required authorization or privilege to perform operation
"SELECT" on object "SYSTOOLS.MDTASKTYPE00". SQLSTATE=42501
Explanation:
An SQL error occurred while the Information Catalog Manager API was
performing a search of the IBM DB2 tools catalog.
User response:
Check the Message Reference for more information about this SQL error.
错误提示中写到ADMINISTRATOR没有权限SELECT SYSTOOLS.MDTASKTYPE00
在XP的计算机管理中查到ADMINISTRATOR已隶属于Administrators和DB2ADMNS组,貌似权限已经比较大了。
在TOOLSDB数据库中发现除ADMINISTRATOR用户外还有一个SYSTEM用户,并且其权限比ADMINISTRATOR高,请问如何使用SYSTEM用户?密码是多少?
收起