互联网服务
数据库还原之后 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同行回答
浏览764
回复 35# wangweilong
) Locate db2nodes.cfg in one of the following directories:
UNIX/Linux:
/sqllib/db2nodes.cfg
All Windows flavors running DB2 v8 and v9.1:
Program Files\IBM\SQLLIB\DB2\db2nodes.cfg
Windows XP and 2003 running DB2 v9.5:
Documents and Settings\All Users\Application Data\IBM\DB2\\DB2\db2nodes.cfg
NOTE: Application Data is a hidden folder
Windows Vista and later operating systems: ProgramData\IBM\DB2\\DB2\db2nodes.cfg
Note that only DB2 ESE has a db2nodes.cfg. If you are running other editions (WorkGroup Server, or Personal Edition) then you can skip this step and the next.收起
) Locate db2nodes.cfg in one of the following directories:
UNIX/Linux:
All Windows flavors running DB2 v8 and v9.1:
Program Files\IBM\SQLLIB\DB2\db2nodes.cfg
Windows XP and 2003 running DB2 v9.5:
Documents and Settings\All Users\Application Data\IBM\DB2\
NOTE: Application Data is a hidden folder
Windows Vista and later operating systems: ProgramData\IBM\DB2\
Note that only DB2 ESE has a db2nodes.cfg. If you are running other editions (WorkGroup Server, or Personal Edition) then you can skip this step and the next.收起
浏览781
浏览745
浏览737
浏览738
浏览761