Skip to Content
avatar image
Former Member

2LIS_03_BX setup table run taking too long

Hi Gurus,


I am filling the setup table for the 2LIS_03_BX using the tcode MCNB. I am running the jobs in parallel by giving the selection plant wise.

I have divided them into 6, 7 parallel jobs. But it still it takes few hours to complete! It takes 4, 5 hours to complete.

So how can i speed up the setup table fill?

BR,

Shreesh.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Dec 28, 2014 at 07:50 PM

    Hello Shreesh,

    The setup table activity does takes time/. Probably you are running 7-8 jibs in parallel that's why there is effect on the performance.

    Try going with 3 jos in parallel with smaller selection to check if the reason for this time is hige volume of data. Downtime is required for setup table activity.

    Regards,
    Amit

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Shreesh,

      As already mentioned by others, downtime is essential for setup table activity. Only then you can have correct data in BW, because setup tables filling is done in ECC box which is the OLTP system recording the transactions/postings, so a downtime is required so that no postings are happening in the system while you prepare to load data 1st time in BW

      But once the setup tables are filled for BX and you have done INIT without data transfer, you can unlock the users and perform FULL LOAD

      You can also decrease the downtime by clearing the delta queues prior to downtime, so that during downtime less no of records are in delta queue.

      Also run the whole activity in Quality system to now and understand what all challenges you may come across in Production.

      Regards,

      Amit

  • Dec 27, 2014 at 02:23 PM

    Hi Shreesh,

    As a general advice be careful with activating the option "Zero stock to be transferred". This option will increase the runtime considerably.

    Please also review the following SAP Notes:

    Best regards,

    Sander

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Shreesh,

      I have only three suggestions left:

      • Try out different selections as suggested in SAP Note 728360 (solution 1);
      • Monitor the system (e.g. using t/code ST05 - SQL trace) to detect possible bottlenecks;
      • Let the basis administrators check the technical infrastructure and give an advice on the maximum no. of parallel processes.

      The first and second action you can already execute in another system (e.g. Quality) to prepare for the real production initialization.

      Best regards,

      Sander

  • avatar image
    Former Member
    Dec 27, 2014 at 01:07 PM

    I have selected only valuated stocks option. & num of data recs per LUW as 5000.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 27, 2014 at 01:51 PM

    Hi,

    All jobs run in the background process i think it will take for the filling of set up tables because of the huge data.

    for us also it take 2 or 3 hours.

    Thanks,

    Phani.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi phani, then did you take a downtime of 3 hours? or lock users for such along time?

      BR,

      Shreesh.