sql server hosting both abap and java

[Former Member]

HI All,

With dual stack gone we need to have stand alone abap and stand alone java.Is there a possibility of using the same database for both abap and java.THis for CRM.Thanks.

[former_member188883 · Accepted solution]

Hi,

You use the same database instance for installation of CRM abap and JAVA. It will create a database schema for your JAVA instance within ABAP database. It does not seem to be a recommended approach since SAP does not support MCOD installations.

To avoid MCOD, you can perform 2 separate installations with 2 different database homes for ABAP and JAVA each.

Hope this helps.

Regards,

Deepak Kori

[clas_hortien · Accepted solution]

Hello,

this is not true. SAP supports MCOD since years now, each dualstack system is a MCOD system.

If you want to use the same database for the two systems you can do it, you have to have a different SID for each system, but this is the only thing you have to ensure.

Best regards and happy MCODing

Clas

[tomas-krojzl · Accepted solution]

Hello,

It does not seem to be a recommended approach since SAP does not support MCOD installations.

Why do you think SAP does not support MCOD?

Here is page about MCOD subject:

There are some important considerations - like to not mix development and production systems in one DB, to no mix OLAP and OLTP systems in one db, Unicone and non-Unicode, etc..

I would recommend to follow simple logic. In my opinion independent databases are better as you get many benefits (like separate maintenance, possibility of upgrade of one database but not other, etc.) However in certain cases these benefits have no meaning for highly dependent systems - like ABAP and Java installations where both components are dependent on each other.

So in case of ABAP and Java part of the SAME system where both components are strongly dependent on each other - it might be more suitable to have just one database. Example is database restore - instead of restoring two databases and making them synchronous using Point-In-Time recovery it is more easy to have MCOD and restore and recover just one database where both parts are always synchronized by design.

I would say it is always about comparing benefits of every approach.

Tomas

[Former Member · Accepted solution]

HI Clas,

Very true .In sdn below list has been listed out regarding mcod.

List of OLTP Components

SAP Web Application Server 6.10 and higher

SAP R/3 4.6C SR2*

SAP R/3 Enterprise

SAP CRM 2.0C SR1*

SAP CRM 3.0 and higher

SAP EBP 2.0C SR1*

SAP EBP 3.0 and higher

SAP SRM 2.0 and higher

SAP SCM 4.0 and higher

SAP Workplace 2.11* SR1

SAP Knowledge Warehouse 5.0/5.1*, 5.2*

SAP NetWeaver 04***

SAP NetWeaver 7.0

Clas one doubt i have i dont have much knowledge about sql server we have option coming in the installation screen saying that create new database or use existing database.I wanted to understand the difference between the two.

Can you please help me.Thanks.

[Former Member · Accepted solution]

HI Tomas,

THanks for the lovely insight.

In MCOD only the schema changes right ? Can we have a option where we have db software same but thier respective homes different.Thanks.

[clas_hortien · Accepted solution]

Hi,

if you choose 'new database' the installation will create a new database for your installation and will put all the data into this new database. You will then have two databases on the SQL Server, one for each system.

If you choose 'existing database' the installation will create a new schema within this existing database and will put all the data into this database into the new schema. The existing data will not be affected. You will end up with one database, which contains both systems, each in a separate schema.

Best regards

Clas

[Former Member · Accepted solution]

Hi Clas,

If we choose a existing database then we run into problems like if we restore we restore both abap and java right.Thanks.

[Former Member · Accepted solution]

Right, the backup will include both the schemas, but keep in mind that for java stack the file system backup is also necessary.

Thanks

[Former Member · Accepted solution]

Thanks file system backup is not require if it is netweaver 7.1