SAP Knowledge Base Article - Preview

2639863 - DB2 LUW (DB6) DIA8402C SQL1034C ADM6023I TABLESPACE is in state 0x00004080 SQL0290N Table space access is not allowed. SQLSTATE=55039

Symptom

  • db2diag.log
       YYYY-MM-DD-HH.MM.SS.msmsms . . .            LEVEL: Error (OS)
       . . .
       FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80
       MESSAGE : ZRC=0x860F0004=-2045837308=SQLO_DGFL "general failure (DD)"
                 DIA8402C A disk error has occurred.
       . . .

       YYYY-MM-DD-HH.MM.SS.msmsms . . .           LEVEL: Severe
       . . .
       FUNCTION: DB2 UDB, base sys utilities, sqeApplication::AppStopUsing, probe:7111
       MESSAGE : ZRC=0xFFFFFBF6=-1034
                 SQL1034C  The database was damaged, so all applications processing 
                 the database were stopped.

       YYYY-MM-DD-HH.MM.SS.msmsms . . .          LEVEL: Error
       . . .
       FUNCTION: DB2 UDB, data protection services, sqlptfrg, probe:1388
       RETCODE : ZRC=0x8610000D=-2045771763=SQLP_BADLOG "Log File cannot be used"
                 DIA8414C Logging can not continue due to an error.
       . . .

       YYYY-MM-DD-HH.MM.SS.msmsms . . .           LEVEL: Error
       . . .
       FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2404
       MESSAGE : ADM6023I  The table space "<SID>#<TBLSPACENAME>" (ID "#") is in state 
                 "0x00004080".  The table space cannot be accessed.  Refer to the 
                 documentation for SQLCODE -290.

  • linux . . . /var/log/messages
    . . .
    Mon DD HH:MM:SS <linux_host> <linux_exe_process_name>[<pid>]: <msg>
    Mon DD HH:MM:SS <linux_host> klnagent[<pid>]: Abnormal behavior! Product 'Kaspersky Endpoint Security 10 for Linux' changes its tasks by itself!<*AlphaNumeric*characters*>{SC:Add a key to Linux Servers}
    Mon DD HH:MM:SS <linux_host> SAP<SID>_00[<pid>]: <AA#> Database: Database error -1655 with FET access to table <TABLENM>
    Mon DD HH:MM:SS <linux_host> SAP<SID>_00[<pid>]: <AA#> Database: > SQL1655C The operation could not be completed due to an


Read more...

Environment

DB2 LUW   10.5 FP8SAP3   linux 64bit . . . Informational tokens are "DB2 v10.5.0.8", "special_36677", "IP23993_36677", Fix Pack "8".

Keywords

KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.