Skip to Content
0
Former Member
Jun 08, 2009 at 09:03 AM

BW System copy from PRD to DEV - Reduce database size

231 Views

Hi All

We are in the process of copying our existing Production BW system (3.5) to become a new Development & test system. We want to reduce the database size significantly from 1.4 Tb to about 150 - 200 Gb. We have deleted all cube and ODS data as well as much of the master data but still have much tablespace tied up in monitor entries (eg table RSMONMESS) and IDOCs. All of the notes I read say that we cannot delete from RSMONMESS in a "Prodcution" environment, however we are creating a new DEV system and really need to get rid of monitor entries anyway. So there are two questions:

1. Any idea how we can clear up table RSMONMESS or delete unwanted monitor entries ?

2. How can we delete IDOCs copied from our production system without archiving them ? (They are of no use in our new test system.)

Please help.

Many thanks in anticipation.

Paul Sullivan

Orica IT