multiple clients and multiple databases on one system

[#1]

Does SAP support having a single system ( Let's call it PEQ for the sake of argument ) having multiple clients ( again, for the sake of argument, call them 200, 250, 260, and 300) allow for each client to have it's own physical database ?

For example, here is what I would like to have set up:

PEQ 200 - database 1

PEQ 250 - database 2

PEQ 260 - database 3

PEQ 300 - database 1

So PEQ 200 and 300 access database 1, PEQ 250 accesses database 2, and PEQ 260 accesses database 3.

I only want to know if this is possible and if so how would you set it up. I do not want to get into any discussion on whether this is the best way to go or not. Any pointers to OSS notes on the subject are more than welcome.

Thanks;

Bruce

[Former Member]

I'm pretty sure the answer's no. There's things you could try like table partitioning on the client and filegroups but SAP doesn't support mulitple filegroups (or table partitioning outside of BI systems).