我们发现,由于表空间“SYSTOOLSPACE”处于离线状态,因此无法获取数据库的每日备份,因此在互联网上查找发现可以通过运行以下命令来解决
修改表空间切换在线
之后系统需要重新启动,因此我们使用以下命令进行重新启动。
重启数据库
它不起作用,我们无法打开与数据库的连接。当我们尝试打开连接时,系统给出以下错误“SQL0980C”
再次查看互联网,我们发现表空间已损坏(可能是 SYSTOOLSPACE,但我们不确定),并执行了以下命令:(附加结果报告)
db2dart
知道我们该怎么办吗?
谢谢
_______ DART _______
数据库分析和报告工具
IBM DB2 NT
DART(V9.5)报告:2011-07-15-07.51.49.887000
Database Name: DATABASE
Report name: DATABASE.RPT
Old report back-up: DATABASE.BAK
Database Subdirectory: F:\DB2\NODE0000\SQL00001
Operational Mode: Database Inspection Only (INSPECT)
______________________________________________________________________________
操作选项:DB
警告:数据库状态不一致。
警告:报告的有关重组行的错误可能是由于数据库状态不一致造成的。正在连接到缓冲池服务...
数据库检查阶段开始。
Tablespace file inspection phase start.
Loading tablespace files.
Inspecting next tablespace and associated containers.
Inspecting next tablespace and associated containers.
Inspecting next tablespace and associated containers.
3 tablespaces were identified and their containers checked.
Error: tablespace files corrupt.
Error: This phase encountered an error and did not complete.
Tablespace file inspection phase end.
数据库检查阶段结束。
______________________________________
DB2DART Processing completed with error!
WARNING:
The inspection phase did not complete!
ERROR:
The tablespace files are damaged or corrupt.
The database may not be usable.
DB2DART Processing completed with warning(s)!
Warning(s) detected during processing.
______________________________________
Complete DB2DART report found in: DATABASE.RPT
_______ D A R T P R O C E S S I N G C O M P L E T E _____
答案1
似乎 systoolspace 的表空间容器已损坏。我猜可能是存储(硬盘)故障?