SAP Knowledge Base Article - Preview

3699620 - DB6: db2start fails due to SQL1072C error

Symptom

  • When shutting down the SAP system, the database was not correctly stopped, resulting in the following error while starting Db2:

    "SQL1072C The request failed because the database manager resources are in an inconsistent state. The database manager might have been incorrectly terminated, or another application might be using system resources in a way that conflicts with the use of system resources by the database manager."
  • db2diag.log

    2025-11-13-07.05.25.726751+120 E164279279E508        LEVEL: Warning (OS)
    PID     : 27791                TID : 139743146661056 PROC : db2star2
    INSTANCE: db2abc               NODE : 000
    HOSTNAME: abc123
    FUNCTION: DB2 UDB, SQO Memory Management, sqloMemCreateSingleSegment, probe:100
    CALLED  : OS, -, shmget                           OSERR: EEXIST (17)
    DATA #1 : unsigned integer, 4 bytes
    1046555233
    DATA #2 : Current set size, PD_TYPE_SET_SIZE, 8 bytes
    222494720
    DATA #3 : Hex integer, 4 bytes
    0x00000781


Read more...

Environment

  • SAP on IBM Db2 for Linux, Unix and Windows
  • Linux or Unix

Product

SAP ERP 6.0

Keywords

db2start, SQL1072C, shmget, OSERR, EEXIST (17) , 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.