Skip to Content

db startup failed

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • May 04 at 07:03 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 04 at 07:26 AM

    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


    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • May 04 at 08:29 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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