db startup failed

[sivareddy436]

Hi all,

The solution manager system isn't bringing up. the db2 database startup failed.

Please find the below trans.log

4 ETW000 R3trans version 6.26 (release 745 - 04.12.17 - 20:17:05).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 02.05.2018 - 12:55:10
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -x
4 ETW000 trace at level 1 opened for a given file pointer
4 ETW000 [ dev trc,00000] Wed May 2 12:55:10 2018
4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/SMD/SYS/exe/run/dbdb6slib.so' ...
4 ETW000 [ dev trc,00000] Library '/usr/sap/SMD/SYS/exe/run/dbdb6slib.so' loaded
4 ETW000 [ dev trc,00000] Version of '/usr/sap/SMD/SYS/exe/run/dbdb6slib.so' is "745.04", patchlevel (0.711)
4 ETW000 [ dev trc,00000] *** ERROR in DbSlConnectDB6[/bas/745_REL/src/dbs/db6/dbsldb6.c, 1352] CON = 0 CACHEID = -1 (BEGIN)
4 ETW000 [ dev trc,00000] &+ DbSlConnectDB6: unable to open file: '/usr/sap/SMD/SYS/global/dscdb6.conf'
4 ETW000 [ dev trc,00000] &+
4 ETW000 [ dev trc,00000] &+
4 ETW000 [ dev trc,00000] &+
4 ETW000 [ dev trc,00000] &+
4 ETW000 [ dev trc,00000] *** ERROR in DbSlConnectDB6[/bas/745_REL/src/dbs/db6/dbsldb6.c, 1352] (END)
2EETW169 no connect possible: "DBMS = DB6 --- DB2DBDFT = 'SMD'"

Regards,

Siva.

[VinodVaddi]

Can you check if the user sapsmd is locked?

login as root and give passwd -S sapsmd

if it says user locked, then unlock by giving passwd -u sapsmd

[sivareddy436]

Dear Vinod,

I am executing command how to know it is locked or unlocked.

after executing command please find the below result. could please suggest.

passwd -s sapsmd
Current available shells:
/bin/sh
/bin/bsh
/bin/csh
/bin/ksh
/bin/tsh
/bin/ksh93
/usr/bin/sh
/usr/bin/bsh
/usr/bin/csh
/usr/bin/ksh
/usr/bin/tsh
/usr/bin/ksh93
/usr/bin/rksh
/usr/bin/rksh93
/usr/sbin/uucp/uucico
/usr/sbin/sliplogin
/usr/sbin/snappd
sapsmd's current login shell:
/bin/csh
Change (yes) or (no)? >

Regards,

Siva.

8501810436

[VinodVaddi]

hello Siva

If this was working properly before and no changes were made to the system, then look into /db2/SMD/db2dump/db2diag.log for more information.

In DB refresh/system copy scenarios you have to update the password file dscdb6.conf

If the following error occurs:
unable to open file: '/usr/sap/<SAPSID>/SYS/global/dscdb6.conf'
'/sapmnt/<SAPSID>/exe/dscdb6up -create xxx' returned with '12' which is not defined as a success code.

That is because the password for the user sap<sapsid> is missing and dscdb6.conf was created wrong. Create dscdb6.conf manually. Therefore execute following command as user <sapsid>adm:
dscdb6up -create password1 password2
where password1 is the password for the connect user sap<sapsid> and password2 is the password for the user <sapsid>adm

[sivareddy436]

Dear Vinod,

As per requested, please find the below db2diag.log.

MESSAGE : ZRC=0x87020002=-2029912062=SQLB_BPSE "Debug logic error detected"
DIA8501C A buffer pool logic error has occurred.

2018-05-04-12.33.15.222615+330 I12536049A566 LEVEL: Severe
PID : 27525360 TID : 4113 PROC : db2sysc 0
INSTANCE: db2smd NODE : 000 DB : SMD
APPHDL : 0-239 APPID: *LOCAL.db2smd.180504070315
AUTHID : DB2SMD 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-04-12.33.15.223071+330 I12536616A905 LEVEL: Severe
PID : 27525360 TID : 4113 PROC : db2sysc 0
INSTANCE: db2smd NODE : 000 DB : SMD
APPHDL : 0-239 APPID: *LOCAL.db2smd.180504070315
AUTHID : DB2SMD 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-04-12.33.15.230327+330 E12537522A514 LEVEL: Event
PID : 27525360 TID : 4113 PROC : db2sysc 0
INSTANCE: db2smd NODE : 000 DB : SMD
APPHDL : 0-239 APPID: *LOCAL.db2smd.180504070315
AUTHID : DB2SMD HOSTNAME: ssseccqas
EDUID : 4113 EDUNAME: db2agent (idle) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FreeResourcesOnDBShutdown, probe:15583
STOP : DATABASE: SMD : DEACTIVATED: NO

trans.log:

4 ETW000 [ dev trc,00000] Supported features:
4 ETW000 [ dev trc,00000] ..retrieving configuration parameters
4 ETW000 [ dev trc,00000] ..done
4 ETW000 [ dev trc,00000] DB2 library has been loaded.
4 ETW000 [ dev trc,00000] Info: successfully loaded DB2 library '/usr/sap/SMD/SYS/global/db6/AIX_64/db6_clidriver/lib/libdb2.a(shr_64.o)'
4 ETW000 [ dev trc,00000] Running with UTF-8 Unicode
4 ETW000 [ dev trc,00000] DB2 client driver version '10.05.0007'
4 ETW000 [ dev trc,00000] Running with CLI driver.
4 ETW000 [ dev trc,00000] Wed May 2 16:38:54 2018
4 ETW000 [ dev trc,00000] *** ERROR in DB6Connect[/bas/745_REL/src/dbs/db6/dbdb6.c, 1907] CON = 0 CACHEID = -1 (BEGIN)
4 ETW000 [ dev trc,00000] &+ DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL30082N Security processing failed with reason "24" ("USERNAME
4 ETW000 [ dev trc,00000] &+ AND/OR PASSWORD INVALID"). SQLSTATE=08001
4 ETW000 [ dev trc,00000] &+
4 ETW000 [ dev trc,00000] &+
4 ETW000 [ dev trc,00000] &+
4 ETW000 [ dev trc,00000] *** ERROR in DB6Connect[/bas/745_REL/src/dbs/db6/dbdb6.c, 1907] (END)
4 ETW000 [dbdb6.c ,00000] *** ERROR => DbSlConnect to 'SMD' as 'sapsmd' failed
2EETW169 no connect possible: "DBMS = DB6 --- DB2DBDFT = 'SMD'" Regards,

Siva

[maria_shen]

Hello Siva,

As a first step, could you please check

1. Whether following file exists
   '/usr/sap/SMD/SYS/global/dscdb6.conf'
   
2. If the file exists, which user you used to run "R3trans -d"?
   
   If it is not <sid>adm user, please re-run the command.
   
3. Whether database is connectable via CLP command with db2<sid> user.
   db2 connect to <dbsid>

Thank you.

Kind regards
Maria

[sivareddy436]

Dear Maria,

1.the .conf file exit in the system.

2.we are executing R3trans -d with smdadm user.

3.

db2 connect to SMD
SQL0902C A system error occurred. Subsequent SQL statements cannot be
processed. IBM software support reason code: "". SQLSTATE=58005

Regards,

Siva.

[maria_shen]

It seems something went wrong within database.
Did you check the db2diag.log?