on 10-03-2013 3:38 PM
Hello All,
I have few queries about BDLS .
Last time i have faced lot of issues (BDLS ran more than 4 days).
Please letme know what are the tables (not related to BDLS) we can ignore while doing BDLS ?
Below forum i have checked and could you please provide more details about index creation for large tables ?, this will help to increase the speed the BDLS for Large tables
http://scn.sap.com/thread/1614795
Thanks
Hi
Check these great posts about speeding up BDLS
http://scn.sap.com/community/it-management/alm/blog/2012/06/01/bdls-in-less-than-2-hours--part-1
http://scn.sap.com/people/muniraju.h/blog/2012/06/01/bdls-in-less-than-2-hours--part-2
http://scn.sap.com/people/muniraju.h/blog/2012/06/04/bdls-in-less-than-2-hours--part-3
http://scn.sap.com/people/muniraju.h/blog/2012/06/04/bdls-in-less-than-2-hours--part-4
Best regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello All,
DBsze is below .
DB system: ORA
Size: 1,671.00 GB
Below list i have taken from DB02old (large table) .
Owner Object Type Tablespace KBytes
SAPR3 STXH TABLE PSAPSTABD 58,597,376
SAPR3 GLPCA TABLE PSAPBTABD 35,446,784
SAPR3 TST03 TABLE PSAPBTABD 31,742,976
SAPR3 PPOIX TABLE PSAPBTABD 30,408,704
SAPR3 SWWCNTP0 TABLE PSAPBTABD 29,053,952
SAPR3 PCL2 TABLE PSAPBTABD 27,832,320
SAPR3 STXL TABLE PSAPBTABD 25,824,256
SAPR3 BSIS TABLE PSAPBTABD 25,202,688
SAPR3 VBAP TABLE PSAPBTABD 18,867,200
SAPR3 RFBLG TABLE PSAPCLUD 18,546,688
SAPR3 COEP TABLE PSAPBTABD 16,990,208
SAPR3 CMFP TABLE PSAPBTABD 16,099,328
SAPR3 EDI40 TABLE PSAPCLUD 15,794,176
SAPR3 CDCLS TABLE PSAPCLUD 14,483,456
SAPR3 VBRP TABLE PSAPBTABD 14,249,984
SAPR3 APQD TABLE PSAPBTABD 12,734,464
SAPR3 DBTABLOG TABLE PSAPPROTD 12,721,152
SAPR3 SNAP TABLE PSAPSTABD 9,065,472
SAPR3 BKPF TABLE PSAPBTABD 8,978,432
SAPR3 PPOPX TABLE PSAPBTABD 8,519,680
SAPR3 BSAS TABLE PSAPBTABD 8,413,184
SAPR3 MSEG TABLE PSAPBTABD 8,228,864
SAPR3 ACCTIT TABLE PSAPBTABD 7,946,240
How can i proceed BDLS for the above large tables ?
Please adivse if any thing iam taking wrong or misunderstanding .
Hi,
Did you actually read the note that were posted earlier.
With release 620 the design and technique was changed and with this change the ability to run BDLS in parallel was lost. Because of the design, we can't run parallel runs with the new report. However, it's possible to use the old report RBDLS2LS for the conversion and there is no disadvantage to using this. When you execute this report from SE38 it generates a report RBDLSXXX (XXX is the client number) which can be used for the conversion. So execute RBDLS2LS directly for parallel conversions.
It is also possible to exclude tables from BDLS or to convert specific tables in parallel (e.g. COEP). To do this, you can either do it maually by making the required entries in the table "BDLSEXZ" as specified in note 932032
- OR -
You can run the report RBDLS2LS directly and enter the tables you DO want to convert in the "Tables for conversion" selection box and leave out the tables you don't want to convert. You can run the report multiple times and use specific conversions for the larger tables like COEP. Below is the view of generated report RBDLSXXX
Thanks
Rishi abrol
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi John,
Please follow the link below,
In short, please create indexes on the mentioned tables and run the BDLS in chunks, like A* to F*, G* to K* etc
Don't forget to include tables starting from /* and 0* if any.
Run BDLS first in Test mode and then in real mode.
We followed the above blog and complete BDLS in roughly 24 hrs for 1.5 TB of data
Regards, Jatin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
First of all you can run the BDLS in Parallel.
Please see the below note .
1638843 - Performance problems running BDLS
Second thing you are try to run the below command to update the stat and then start bdls.
brconnect -u / -c -f stats -t all -f collect
Another thing i wanted to ask you what patch level you are .
have you installed the BDLS enhancement.
Note 1774236 - System Copy: BDLS optimization
Note 1750330 - System Copy: BDLS Task (1. Improvements)
Thanks
Rishi abrol
Hi John,
While executing the BDLS, you can enter the entries as per your choice in the field "Tables to be converted". There you can enter A* to B*. It should take less time. Similarly you can choose B* to C* and so on.. By doing this steps, you can see that for which type of table it is taking too much time.
Regards,
Shyam Kumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.