Hi

DB2 8.2.6 on windows 2000

Our database reported error :
SQL0980C A disk error occurred SQL0980C Subsequent SQL statements cannot beprocessed. SQLSTATE=58005.

As per DB2 help suggestion we restored the database from backup. the restore worked ok but we still get the same error.

Following is the extract from db2diag file..


2007-04-13-11.50.10.692000+600 I148443H443 LEVEL: Severe
PID : 5760 TID : 3580 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : AXISHSD1
APPHDL : 0-573 APPID: *LOCAL.DB2.070413015010
FUNCTION: DB2 UDB, data management, sqldLoadTCB, probe:4649
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.

2007-04-13-11.50.10.692000+600 I148888H460 LEVEL: Severe
PID : 5760 TID : 3580 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : AXISHSD1
APPHDL : 0-573 APPID: *LOCAL.DB2.070413015010
FUNCTION: DB2 UDB, data management, sqldLoadTCB, probe:4649
MESSAGE : Error loading TCB. tcbFlags =
DATA #1 : Hexdump, 4 bytes
0x210B5470 : 0000 0000 ....

2007-04-13-11.50.10.692000+600 I149350H355 LEVEL: Severe
PID : 5760 TID : 3580 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : AXISHSD1
APPHDL : 0-573 APPID: *LOCAL.DB2.070413015010
MESSAGE : SQLD_TCB:
DATA #1 : String, 37 bytes
Perm Table(0:1)=TBSPACEID=0.TABLEID=1

.....................

Our database is down & unusable now. will be thankfull for suggestions/help

Regards

Harikumar

Hari, Looks like there is a problem with your catalog .,..
"Perm Table(0:1)=TBSPACEID=0.TABLEID=1"

Have you tried running db2dart to identify the problem??? You should find info in the manuals ...

Contact IBM support to get further help

Sathyaram