We identified that the daily backup scheduled for our database was not obtained because the tablespace "SYSTOOLSPACE" was offline, so looking in the internet found that could be solved by running the following command
ALTER TABLESPACE SWITCH ONLINE
After that the system needs to be restarted, so we did it with the following command.
RESTART DATABASE
It didn't work and we cannot open connection to the database. When we tried to open a connection the system give us the following error "SQL0980C"
Looking again in the internet we realise we have tablespace corrupt (probably SYSTOOLSPACE but we're not sure of that) and executed the following command: (attach the result report)
db2dart
Any idea how can we do?
Thanks
_______ DART _______
D a t a b a s e A n a l y s i s a n d R e p o r t i n g T o o l
IBM DB2 NT
DART (V9.5) Report: 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)
______________________________________________________________________________
Action option: DB
Warning: The database state is not consistent.
Warning: Errors reported about reorg rows may be due to the inconsistent state of the database. Connecting to Buffer Pool Services...
Database inspection phase start.
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.
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.
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 _____