cancel
Showing results for 
Search instead for 
Did you mean: 

BDLS issue

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

ACE-SAP
Active Contributor
0 Kudos
Former Member
0 Kudos

Hello All,

Thanks for your valuable reply .

Any advise any Tables can be ignored during BDLS (If it is not related to BDLS) ?

Thanks

Former Member
0 Kudos

Hi,

I would not suggest you to go table wise as its risk is involved in to it. So advise to use BDLS but in optimised way and in parallel.

Sap will also suggest you the same.

Thanks

Rishi abrol

Former Member
0 Kudos

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 .

Former Member
0 Kudos

Hi,

Did you actually read the note that were posted earlier.

  • Run in Parallel.

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.

  • Specific conversion for large tables.

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

1547980 - BDLS Performance

Thanks

Rishi abrol

Former Member
0 Kudos

Hi John,

Please follow the link below,

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

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

Former Member
0 Kudos

Hi,

First of all you can run the BDLS in Parallel.

Please see the below note .

1638843 - Performance problems running BDLS

1547980 - BDLS Performance

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

former_member201800
Participant
0 Kudos

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