Skip to Content
0
Nov 15, 2011 at 11:23 AM

Database migration to MAXDB and Performance problem during R3load import

377 Views

Hi All Experts,

We want to migrate our SAP landscape from oracle to MAXDB(SAPDB). we have exported database of size 1.2 TB by using package and table level splitting method in 16 hrs.

Now I am importing into MAXDB. But the import is running very slow (more than 72 hrs).

Details of import process as per below.

We have been using distribution monitor to import in to target system with maxdb database 7.7 release. We are using three parallel application servers to import and with distributed R3load processes on each application servers with 8 CPU.

Database System is configured with 8CPU(single core) and 32 GB physical RAM. MAXDB Cache size for DB instance is allocated with 24GB. As per SAP recommendation We are running R3load process with parallel 16 CPU processes. Still import is going too slow with more that 72 hrs. (Not acceptable).

We have split 12 big tables in to small units using table splitting , also we have split packages in small to run in parallel. We maintained load order in descending order of table and package size. still we are not able to improve import performance.

MAXDB parameters are set as per below.

CACHE_SIZE 3407872

MAXUSERTASKS 60

MAXCPU 8

MAXLOCKS 300000

CAT_CACHE_SUPPLY 262144

MaxTempFilesPerIndexCreation 131072

We are using all required SAP kernel utilities with recent release during this process. i.e. R3load ,etc

So Now I request all SAP as well as MAXDB experts to suggest all possible inputs to improve the R3load import performance on MAXDB database.

Every input will be highly appreciated.

Please let me know if I need to provide more details about import.

Regards

Santosh