thanks and I already have this link but how to configuration in SAP for provide SAP when generate Report use read only DB2 standby database and when update data use primary DB2 database.
SAP itself does not provide read-only access in the manner you require, because the functionality is very dependent on exactly what DBMS you are using and how it is installed. It is DB/2 Functionality, not SAP functionality, and is configured in DB/2, as specified in the Enabling reads on standby link on the page given by Former Member above.
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.