Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Posts
    104

    Unanswered: SQL0980C A disk error occurred

    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

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •