Running BDLS in parallel

[Former Member]

Dear Experts,

I have a situation here and need your advise on the same.

I will have to convert two logical names in my system after refresh to two new logical names. The logical names are:

TDVCLNT210 to PRDCLNT210 and

BWDCLNT100 to BWPCLNT100

Now, my question is what if I run both of these BDLS in parallel at the same time simultaneously? Is this advisable?

I know, the system can get a bit slow but I really need to complete the conversion as early as I can because I am in a time-crunch.

Kindly advise.

Thanks,

Avishek

[Former Member · Accepted solution]

Hi Avishek,

You can run both the conversions in parellel. No issues. Finally check the spool log once jobs are finished to verify the conversion went fine or not.

Running parellel won't have any impact.

Thanks,

Jagadish.

[Former Member · Accepted solution]

Hi Jagadish,

Thanks a lot for the response. I will proceed, and I will get back and let you know the results. Keeping the thread open till then.

[former_member206552 · Accepted solution]

Hi Avishek,

please also have a look at

http://scn.sap.com/people/hari.peruri/blog/2006/11/01/execute-conversion-of-logical-system-names-bdl...

by creating indexes you can reduce the runtime significantly

Best Regards

Marius

[Former Member · Accepted solution]

Maius,

I have read the document before starting the thread, its really informative and helpful. Thanks for sharing.

[Former Member]

Thanks again Jagadish and marius for your prompt replies.

I executed the BDLS in parallel and it worked wonderfully without any hassle.

Additionally, I would like to share/add few points which made my BDLS jobs run fast, these are:

1. First before the conversion's actual run, I did a test run as shown below in tx BDLS.

2. The test run job takes few seconds and after it completes I checked the spool to find out the tables that will be converted.

3. Now, in DB02, I took a note of few of the largest tables. Matched them with the list of tables in spool list generated in step 2. If these large tables are not in the list of "to-be-converted" tables then I keep a note of it.

4. Now coming back to the actual run, after specifying the logical systems and rmoving the test run and Check table existance check boxes, I clicked on the ARROW button on the Tables to be converted area.

In the pop-up, I specified only the tables that I noted in Step 2 under "Select single values" list and the specified the large tables (noted in Step 3) under "Exclude Single Values" list.

This considerably and significantly reduced the BDLS run-time!

Thanks

Avishek

[former_member206552]

Hi Avishek,

thank you for the feedback !

best regards

marius