Skip to Content

could not start DB2 database

Hi dear SAP Gurus,

    I cannot start my DB2 database after installing a Java stack:

db2start

08/22/2012 14:32:10     0   0   SQL1026N  The database manager is already active.

SQL1026N  The database manager is already active.

db2 activate database PJ2

SQL1092N  "" does not have the authority to perform the requested command or

operation.

OS: AIX 6.1 DB2 9.7 FP5

I can backed up database successfully but I can't activate it

R3trans -x shows this error:

4 ETW000  [     dev trc,00000]  *** ERROR in DbSlConnectDB6[dbsldb6.c, 1294] CON

= 0 (BEGIN)           29583  0.296671

4 ETW000  [     dev trc,00000]  &+     DbSlConnectDB6: unable to open file: '/us

r/sap/PJ2/SYS/global/dscdb6.conf'

In fact, file  /usr/sap/PJ2/SYS/global/dscdb6.conf does not exist

thanks for your kind help

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Aug 22, 2012 at 08:41 PM

    Hi Jose

    Looks like you do not have the authorizations to start the database.

    Please make sure you are logged in as <sid>adm or db2<sid> before starting the db.

    "does not have the authority to perform the requested command or

    operation."

    you can generate dscdb6.conf by following this sap note.

    Note 1532727 - DB6: dscdb6up generates incorrect sidadm password

    you need to have your <sid>adm and sap connect user password.

    If you run into any issues let me know.

    Regards

    Amit Padmawar

    Regards

    Amit Padmawar

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks for all your responses, I finally solved my problem using

      note 997635

      SERVSAPDEVBI:db2pj2 5> su


      root's Password:


      # mv /usr/sap/PJ2/SYS/global/dscdb6.conf


      /usr/sap/PJ2/SYS/global/dscdb6.conf.viejo


      # dscdb6up -create


      Enter new password for connect_user:



      Confirm password for connect_user:



      Enter new password for sidadm_user:



      Confirm password for sidadm_user:



      password file '/usr/sap/PJ2/SYS/global/dscdb6.conf' successfully written

          And finally, SAP instance is running