Skip to Content
author's profile photo Former Member
Former Member

DB startup failed

Dear Friends,

I was changed LOGARCHMETH1 from OFF to DISK:/db2/<SID>/archlog & tried to restart the SAP instance by stopsap.

While running STARTSAP getting the below error

mmcprod:mmpadm 1> startsap

Checking db6 db Database

-


Database is not available via R3trans

Running /usr/sap/MMP/SYS/exe/run/startdb

05/30/2011 12:47:07 0 0 SQL1063N DB2START processing was successful.

SQL1063N DB2START processing was successful.

Activate database failed

R3trans connect failed

DB startup failed

Then I checked with db22start command

mmcprod:mmpadm 9> db2start

05/30/2011 12:53:20 0 0 SQL1063N DB2START processing was successful.

SQL1063N DB2START processing was successful.

mmcprod:mmpadm 10>

Then again tried to run startsap

mmcprod:mmpadm 10> startsap

Checking db6 db Database

-


Database is not available via R3trans

Running /usr/sap/MMP/SYS/exe/run/startdb

05/30/2011 12:53:53 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

Kindly help me out on this.

Where I found the parameter file to reset the LOGARCHMETH1 again to OFF. Is it problem because of changing the parameter LOGARCHMETH1 in my case.

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 30, 2011 at 07:32 AM

    Hello,

    after setting the loging mode from circular to archiving the database is in backup pending.

    Take a backup from your database, or change the state with db2dart.

    best regards

    Joachim

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.