SAP Knowledge Base Article - Preview

2639863 - DB2 LUW (DB6) DIA8402C or SQL1034C errors in tablespace access

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

  • Tablespace status shows a value of 0x00004080
    Determine status with the following query:
    db2pd -db <SID> -tablespaces


Read more...

Keywords

ADM6023I
0x00004080
SQL0290N , 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.