SAP Knowledge Base Article - Preview

3675757 - DB6: Tablespaces offline due to file sharing violation

Symptom

  • Tablespaces go offline after the database server is restarted.

  • Following error is observed in database log (/db2/<SID>/db2diag.log).

    2025-10-28-19.46.42.855000+480 I61693396F749        LEVEL: Error
    PID     : 5532                 TID : 852            PROC : db2syscs.exe
    INSTANCE: DB2ABC               NODE : 000           DB   : ABC
    APPHDL  : 0-63                 APPID: *LOCAL.DB2ABC.251028114615
    AUTHID  : SAPSERVICEABC        HOSTNAME: ABC
    EDUID   : 852                  EDUNAME: db2agent (ABC) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:810
    MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing violation."
              DIA8519C A file sharing violation has occurred, filename was "".
    DATA #1 : <preformatted>
    Error checking container 0 (\db2\ABC\sapdata1\DB2ABC\NODE0000\ABC\T0000012\C0000000.LRG) for tbsp 12.  Rc = 870F0016


Read more...

Environment

SAP on IBM Db2 for Linux, Unix and Windows

Product

SAP NetWeaver 7.5 ; SAP enhancement package 7 for SAP ERP 6.0

Keywords

tablespace offline, file sharing violation, ZRC=0x870F0016, DIA8519C, ADM6023I, SQLCODE -290 , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration , 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.