互联网服务
数据库还原之后 sysibmadm下的视图不可用
使用离线备份进行的还原，
源和目标都是win2003的操作系统，数据库都是V9.5.4 。
还原之后，目标库的其他表和视图都没问题，只有sysibmadm下的视图不可访问，报错如下：
C:Documents and Settingsdb2admin>db2 "select * from sysibmadm.snaptab"
SQL1042C An unexpected system error occurred. SQLSTATE=58004
请大神看看什么原因呢？
我查询了SQL1042C报错的详细内容，还是没有什么思路。
源和目标都是win2003的操作系统，数据库都是V9.5.4 。
还原之后，目标库的其他表和视图都没问题，只有sysibmadm下的视图不可访问，报错如下：
C:Documents and Settingsdb2admin>db2 "select * from sysibmadm.snaptab"
SQL1042C An unexpected system error occurred. SQLSTATE=58004
请大神看看什么原因呢？
我查询了SQL1042C报错的详细内容，还是没有什么思路。
附件：
db2trc.rar (440.96 KB)
41同行回答
删除和重建实例，并重新catalog该数据库，问题该解决。
权限问题，确保在目标机器上的用户具备以下权限
Authorization
One of the following authorizations is required to use the view:
SELECT privilege on the SNAPDB administrative view
CONTROL privilege on the SNAPDB administrative view
DATAACCESS authority
DBADM authority
SQLADM authority
In addition, to access snapshot monitor data, one of the following authorities is also required:
SYSMON
SYSCTRL
SYSMAINT
SYSADM收起
权限问题，确保在目标机器上的用户具备以下权限
Authorization
One of the following authorizations is required to use the view:
SELECT privilege on the SNAPDB administrative view
CONTROL privilege on the SNAPDB administrative view
DATAACCESS authority
DBADM authority
SQLADM authority
In addition, to access snapshot monitor data, one of the following authorities is also required:
SYSMON
SYSCTRL
SYSMAINT
SYSADM收起
浏览327