Skip to Content
0
May 18, 2018 at 08:04 AM

DB2 stsrtup failed

463 Views

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.