db2 connect 数据库报错:
SQL0980C A disk error occurred. Subsequent SQL statements cannot be
processed. SQLSTATE=58005
db2dart 报告:
DART (V9.1) Report:
2016-12-30-00.12.11.617924
Database Name: ICCDB
Report name: ICCDB.RPT
Old report back-up: ICCDB.BAK
Database Subdirectory: /home/db2inst1/data/db2inst1/NODE0000/SQL00001
Operational Mode: Database Inspection Only (INSPECT)
______________________________________________________________________________
------------------------------------------------------------------------------
Action option: DB
Connecting to Buffer Pool Services...
Database inspection phase start.
Tablespace file inspection phase start.
Loading tablespace files.
Inspecting next tablespace and associated containers.
Error: Tablespace file / container mismatch
Inspecting next tablespace and associated containers.
Error: Tablespace file / container mismatch
Inspecting next tablespace and associated containers.
Error: Tablespace file / container mismatch
Inspecting next tablespace and associated containers.
Error: Tablespace file / container mismatch
Inspecting next tablespace and associated containers.
Error: Tablespace file / container mismatch
5 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.
Database 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.
______________________________________
Complete DB2DART report found in:
/home/db2inst1/sqllib/db2dump/DART0000/ICCDB.RPT
_______ D A R T P R O C E S S I N G C O M P L E T E _______
SQL0980C 发生磁盘错误。无法处理后续的 SQL 语句。
解释:
发生磁盘错误,将阻止成功执行当前的和后续的
SQL 语句。 应用程序不允许发出附加的 SQL 语句。
例如,与应用程序相关的恢复例程不能发出附加的
SQL 语句。 数据库被标记为需要恢复,并且阻止使用
数据库的所有应用程序访问该数据库。
无法处理该语句。
用户响应:
记录来自 SQLCA
的所有错误信息(如果有可能)。终止使用数据库
的所有应用程序。确定错误是否是硬件错误。重新
启动数据库。如果不能恢复,则根据备份副本复原
数据库。
如果正在安装样本数据库,则删除它并再次安装
样本数据库。
sqlcode : -980
sqlstate : 58005
收起