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

Can we use sap read only on standby db2 database?

Dear Expert

Please help to me to provide information.

Can we use sap read only on standby db2 database?

Best Regards,

DB Administrator

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Aug 20, 2012 at 03:48 PM

    Yes , you can perform read only operations on a DB2 standby database.

    Refer to the link

    http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.db2.luw.admin.ha.doc%2Fdoc%2Fc0054257.html

    Please let us know if you have more queries.

    Regards

    Ratnajit

    Add a comment
    10|10000 characters needed characters exceeded

    • I would also like to stress the fact that an SAP workprocesses can connect to a single database during startup and cannot connect to multiple databases for business transactions at a time. The SAP Database is a single point of failure for an SAP system. You can create multiple database connections from the DBACOCKPIT to monitor remote databases and again this is an external connection. But again I am not sure if dbacockpit can connect to standby remote database. So the way you want to use the primary and standby database , logically does not stand atleast for DB2 LUW flavour.

      You can setup read only on standby and use sql to query tables to view business data.

      There is a link to setting up the read only standby database.

      http://www.ibm.com/developerworks/data/library/techarticle/dm-1205hadrstandby/index.html

      Regards

      Ratnajit

  • Posted on Aug 20, 2012 at 07:07 AM

    Discussion moved from Getting Started with SCN to SAP on DB2 for Linux, UNIX, and Windows (Getting Started with SCN is for general SAP Community Network related discussions only)

    To get a quick (or any) response, create your new discussion in a space related to your query. This way it will be visible to topic experts who will then see and reply to it. The SCN Site Index contains a full listing of all SCN spaces.

    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.