Skip to Content

DB2 stsrtup failed

we are installing solution manger and logged into system. we performed some post installation steps then down the system.

I am trying to up system but it doesn't up.

startsap
Checking db6 Database
Database is not available via R3trans
-------------------------------------------
05/18/2018 10:40:22 0 0 SQL1026N The database manager is already active.
SQL1026N The database manager is already active.
Activate database failed
R3trans connect failed
DB startup failed

please send the tracefile /home/smdadm/startsap.trc to support

in startsap.trc showing

Running /usr/sap/SMD/SYS/exe/run/startdb
DB startup failed

Exit code 5

in db2diag.log showing

2018-05-18-10.40.28.233016+330 I8847273A570 LEVEL: Severe
PID : 23724188 TID : 4113 PROC : db2sysc 0
INSTANCE: db2smd NODE : 000 DB : SMD
APPHDL : 0-196 APPID: 10.101.4.22.41102.180518051028
AUTHID : SAPSMD HOSTNAME: ssseccqas
EDUID : 4113 EDUNAME: db2agent (SMD) 0
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:6155
MESSAGE : ZRC=0x87020002=-2029912062=SQLB_BPSE "Debug logic error detected"
DIA8501C A buffer pool logic error has occurred.

2018-05-18-10.40.28.233469+330 I8847844A909 LEVEL: Severe
PID : 23724188 TID : 4113 PROC : db2sysc 0
INSTANCE: db2smd NODE : 000 DB : SMD
APPHDL : 0-196 APPID: 10.101.4.22.41102.180518051028
AUTHID : SAPSMD HOSTNAME: ssseccqas
EDUID : 4113 EDUNAME: db2agent (SMD) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10318
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -902 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL10057
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
DATA #2 : Boolean, 1 bytes
false

2018-05-18-10.40.28.241883+330 E8848754A518 LEVEL: Event
PID : 23724188 TID : 4113 PROC : db2sysc 0
INSTANCE: db2smd NODE : 000 DB : SMD
APPHDL : 0-196 APPID: 10.101.4.22.41102.180518051028
AUTHID : SAPSMD HOSTNAME: ssseccqas
EDUID : 4113 EDUNAME: db2agent (idle) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FreeResourcesOnDBShutdown, probe:15583
STOP : DATABASE: SMD : DEACTIVATED: NO

Please help us to come out.

Regards,

Siva.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • May 19 at 01:04 AM

    Hello Siva,

    The "Debug logic error detected" error happened within function "sqledint, probe:6155".
    Is the database also a new setup? Any changes before current issue?

    You may try with a clean shut down with IPC resources owned by instance owner removed.

    If it does not resolve the issue, consider either a restore from a valid backup or contact us with expert chat or incident.

    Thank you.


    Kind regards
    Maria


    Add comment
    10|10000 characters needed characters exceeded

  • May 22 at 11:17 AM

    If this is a fresh installation something has gone very wrong.... most evidence found indicated that this is most likely to occur after a restore (copy) or upgrade...

    In any case I suggest you to review your post-installation steps and/or re-attempt the install/restore following the guidelines

    Regards, JP

    Add comment
    10|10000 characters needed characters exceeded

  • May 18 at 08:21 AM

    Hi Siva,

    There is several reasons for "Debug logic error detected" error to happen, can you post an extended portion of the db2diag.log?

    Additional to that can you tell us what version of DB2 are you running (including SP)?

    Regards, JP

    Add comment
    10|10000 characters needed characters exceeded

    • Dear Reyes,

      As per your request, please find the below db2daig.log

      ssseccqas:smdadm 7> tail -100 db2diag.log

      2018-05-21-17.53.56.744345+330 I8914572A806 LEVEL: Severe
      PID : 23724188 TID : 3856 PROC : db2sysc 0
      INSTANCE: db2smd NODE : 000 DB : SMD
      APPHDL : 0-1164 APPID: *LOCAL.db2smd.180521122356
      AUTHID : DB2SMD HOSTNAME: ssseccqas
      EDUID : 3856 EDUNAME: db2agent (SMD) 0
      FUNCTION: DB2 UDB, buffer pool services, sqlbReadStorageGroup, probe:1678
      MESSAGE : ZRC=0x87020002=-2029912062=SQLB_BPSE "Debug logic error detected"
      DIA8501C A buffer pool logic error has occurred.
      DATA #1 : String, 38 bytes
      Error reading from storage group files
      DATA #2 : Storage Group ID, PD_TYPE_SQLB_STORAGEGROUP_ID, 8 bytes
      0
      DATA #3 : Pointer, 8 bytes
      0x0a00040001168000
      DATA #4 : Pointer, 8 bytes
      0x0780000002039ed9

      2018-05-21-17.53.56.745045+330 I8915379A743 LEVEL: Severe
      PID : 23724188 TID : 3856 PROC : db2sysc 0
      INSTANCE: db2smd NODE : 000 DB : SMD
      APPHDL : 0-1164 APPID: *LOCAL.db2smd.180521122356
      AUTHID : DB2SMD HOSTNAME: ssseccqas
      EDUID : 3856 EDUNAME: db2agent (SMD) 0
      FUNCTION: DB2 UDB, buffer pool services, sqlbReadStorageGroupTable, probe:1984
      MESSAGE : ZRC=0x87020002=-2029912062=SQLB_BPSE "Debug logic error detected"
      DIA8501C A buffer pool logic error has occurred.
      DATA #1 : String, 38 bytes
      Failed to read the storage group table
      DATA #2 : Pointer, 8 bytes
      0x0780000002039ed9
      DATA #3 : Pointer, 8 bytes
      0x0a00040001168000

      2018-05-21-17.53.56.745666+330 I8916123A795 LEVEL: Severe
      PID : 23724188 TID : 3856 PROC : db2sysc 0
      INSTANCE: db2smd NODE : 000 DB : SMD
      APPHDL : 0-1164 APPID: *LOCAL.db2smd.180521122356
      AUTHID : DB2SMD HOSTNAME: ssseccqas
      EDUID : 3856 EDUNAME: db2agent (SMD) 0
      FUNCTION: DB2 UDB, buffer pool services, sqlbInitStorageGroupTable, probe:1661
      MESSAGE : ZRC=0x87020002=-2029912062=SQLB_BPSE "Debug logic error detected"
      DIA8501C A buffer pool logic error has occurred.
      DATA #1 : String, 44 bytes
      Failed to initialize the storage group table
      DATA #2 : Pointer, 8 bytes
      0x0780000002039ed9
      DATA #3 : Pointer, 8 bytes
      0x078000000203f0e0
      DATA #4 : Pointer, 8 bytes
      0x0780000001fd0080

      2018-05-21-17.53.56.746331+330 I8916919A565 LEVEL: Error
      PID : 23724188 TID : 3856 PROC : db2sysc 0
      INSTANCE: db2smd NODE : 000 DB : SMD
      APPHDL : 0-1164 APPID: *LOCAL.db2smd.180521122356
      AUTHID : DB2SMD HOSTNAME: ssseccqas
      EDUID : 3856 EDUNAME: db2agent (SMD) 0
      FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:15
      MESSAGE : ZRC=0x87020002=-2029912062=SQLB_BPSE "Debug logic error detected"
      DIA8501C A buffer pool logic error has occurred.

      2018-05-21-17.53.56.746782+330 I8917485A566 LEVEL: Severe
      PID : 23724188 TID : 3856 PROC : db2sysc 0
      INSTANCE: db2smd NODE : 000 DB : SMD
      APPHDL : 0-1164 APPID: *LOCAL.db2smd.180521122356
      AUTHID : DB2SMD HOSTNAME: ssseccqas
      EDUID : 3856 EDUNAME: db2agent (SMD) 0
      FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:6155
      MESSAGE : ZRC=0x87020002=-2029912062=SQLB_BPSE "Debug logic error detected"
      DIA8501C A buffer pool logic error has occurred.

      2018-05-21-17.53.56.747212+330 I8918052A905 LEVEL: Severe
      PID : 23724188 TID : 3856 PROC : db2sysc 0
      INSTANCE: db2smd NODE : 000 DB : SMD
      APPHDL : 0-1164 APPID: *LOCAL.db2smd.180521122356
      AUTHID : DB2SMD HOSTNAME: ssseccqas
      EDUID : 3856 EDUNAME: db2agent (SMD) 0
      FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10318
      DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
      sqlcaid : SQLCA sqlcabc: 136 sqlcode: -902 sqlerrml: 0
      sqlerrmc:
      sqlerrp : SQL10057
      sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
      (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
      sqlwarn : (1) (2) (3) (4) (5) (6)
      (7) (8) (9) (10) (11)
      sqlstate:
      DATA #2 : Boolean, 1 bytes
      false

      2018-05-21-17.53.56.755830+330 E8918958A514 LEVEL: Event
      PID : 23724188 TID : 3856 PROC : db2sysc 0
      INSTANCE: db2smd NODE : 000 DB : SMD
      APPHDL : 0-1164 APPID: *LOCAL.db2smd.180521122356
      AUTHID : DB2SMD HOSTNAME: ssseccqas
      EDUID : 3856 EDUNAME: db2agent (idle) 0
      FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FreeResourcesOnDBShutdown, probe:15583
      STOP : DATABASE: SMD : DEACTIVATED: NO

      Regards,

      Siva