DB2 Express-C 9.5.2 错误 SQL0980C

DB2 Express-C 9.5.2 错误 SQL0980C

我们发现,由于表空间“SYSTOOLSPACE”处于离线状态,因此无法获取数据库的每日备份,因此在互联网上查找发现可以通过运行以下命令来解决

修改表空间切换在线

之后系统需要重新启动,因此我们使用以下命令进行重新启动。

重启数据库

它不起作用,我们无法打开与数据库的连接。当我们尝试打开连接时,系统给出以下错误“SQL0980C”

http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.messages.sql.doc/doc/msql00980c.html

再次查看互联网,我们发现表空间已损坏(可能是 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 的表空间容器已损坏。我猜可能是存储(硬盘)故障?

相关内容