Tuesday, May 6, 2014

BDLS. Performance Problem

Every SAP Basis faced with creating test system with another ID. In that case we must use BDLS for changing logical names in database tables. The BDLS processing may take very long time. And increasing the time will depend on the size growth of the database.
How can we reduce the BDLS processing time?
For the answer for this question I have write this article.

So… First key point is “Test run” option. We must always perform the changing of logical names in two steps. The first step is perform with enabled “Test run” option. The test run enables create the tables list to be converted (remember not all tables must have the converted), and speed up the real run, because no longer has to check every table. Below, you may see example pic:



In my case, “Test run” takes longer time unlike real update mode. After the test run was completed, you can find in BDLSS the report with tables which to be updated. Now you can run in real update mode.



Using this simple method i can change the logical names for four hours, on the system with size about 5,5 Tb.
But, we can reduce this time. For this, we must turn to report (BDLSS) and mark the tables with many rows for update, there we find the column names with existing the rows for update. With this information we can manually update some tables using simple SQL expression. Below I explain how you can change the logical names with manually correction with maximum reduction of time.   

Every time you update the test system, you must change the logical names in the same SAP tables (not Z tables, their number can change)!!! So, you can create the list of tables which you want to update using SQL expression. These tables you must put in exception list, transaction BDLSC:



Now BDLS will ignore these tables in both mode test and update mode. While BDLS is running, you can manually update them using SQL. How can you see, is very simple.   

I apologize in advance for my english

7 comments:

  1. This may be of interest - http://www.basistechnologies.com/GT/Run-SAP-System-Copy-Faster-BDLS-Performance-Speed.

    ReplyDelete
  2. Please read my blog.
    BDLS IN LESS THAN 2 HOURS
    http://scn.sap.com/community/it-management/alm/blog/2012/06/01/bdls-in-less-than-2-hours--part-1

    ReplyDelete
  3. bet365 Casino Review 2021 - VieCasino.com
    Bet365 Casino offers a fantastic range of casino bet365 games 퍼스트 카지노 from roulette to rb88 blackjack. In this Bet365 Casino review, we will be able to tell you what makes Bet365

    ReplyDelete
  4. Casino City Online for Real Money - Tricktoactoe
    Play the 토토 사이트 제작 방법 샤오 미 best free casino online for real 넷마블 사이트 money! Sign 메이져 사이트 up and claim your welcome bonus for the best free 골인 벳 casino games and casino games at Tricktoactoe! 메이저벳

    ReplyDelete
  5. Casino games for real money - Trick Toactoe
    With Casino games for real money, you can 슬롯 게임 take advantage of the bonuses, the offers, and other features 바카라 사이트 to get more 스포츠토토 통계 비코리아 free spins. To play the 토토 베이 best casino 넷마블 토토 games, you

    ReplyDelete
  6. Sega Mega Drive Classics - IGN - The King of Dealer
    An in-depth look at Sega's collection of Mega Drive / Genesis classics. 카지노 사이트 that had to be bundled with the Sega Genesis 2 and kirill-kondrashin the Mega Drive Pro.

    ReplyDelete
  7. The King Of Dealer - The Kingdom Of Dealer
    that comes up against the rest 우리카지노 of the casino software giants like Playtech and Microgaming and Betfair. For these they offer a decent range of games and a

    ReplyDelete