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: 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 for Me (Login required).

Search for additional results

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