Skip to Content
1
Former Member
Aug 19, 2012 at 03:33 AM

Query about Distribution Monitor

177 Views

Hi Friends,

I am working on migrations in my organization. Now we have a requirement to migrate database of about 10 TB and we have downtime only of 60 hours. We planned to use the concept of distribution monitor and try running multiple R3loads for parallel export & import on three applications servers.

We are migrating SAP from HP-UX to Linux. I haven't worked on distribution monitor so far. But have worked on MIGMON couple of times.

Now my query is:

1. As per the distribution monitor guide, i could see that we should use additional dialog application servers to connect to database and take the export/import. During parallel Import, do we need to install additional dialog servers that are pointing to target database before installation of Database? I mean installing Central instance & additional dialog instance prior to installing Database instance.

2. I guess we need to use shared disk which is available on all the source and target applications servers where R3load is running for both export & import. Is that correct?

3. Will we using only DISTMON.SAR or MIGMON.SAR for export/ import on multiple systems? If DISTMON.SAR , then we just need to uncar in a directory and run the distribution_monitor.sh. Correct?

4. We would need to execute table splitting option to split tables for larger tables from DB02. Please let me know how to achieve this. I learnt that if a table is splitted on a data directory during export, we need to use the same directory for import as well. In that case, please let me know how to use this split option?

5. I think the procedure to use Distribution monitor is as follows :

  • Unpack DISTMON.SAR file on all the systems where we are going to execute export and import.
  • Maintain distribution_monitor_cmd.properties with the name of the servers where R3load is running and execute. / distribution_monitor.sh on all the servers where export/ Import is running.

Finally please explain the usage of orderbytext file using export as well as difference between DDL<DB_TYPE>.TPL & DDL_<DB_TYPE>_LRG.TPL

Sorry for such a long texts

Thanks and Regards,

Vimal