on 07-02-2013 2:31 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Avishek,
please also have a look at
by creating indexes you can reduce the runtime significantly
Best Regards
Marius
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.