Lo Cockpit Loading in Production

[Former Member]

Hi All

Its a fact that whenever we are loding the data for LO extractors we need to fill the setup tables first with no activity in the system.

Here at the client due to existance of client worldwide they are asking us to explore if there is any way to load the data with minimul downtime or no downtime.We might get maximum a day for downtime .

Is there any process that we can follow to get all the records properly for LO loaded into BI without downtime.

Regards

Vijay Thammineni

[Former Member · Accepted solution]

Hi,

if the request are loaded to an DSO in the overwrite mode and if the RECORDMODE field is mapped to ROCANCEL from R/3 then you do not need downtime.You can do this in the normal working day.

You can do an init withour data transfer first and then fill the set up tables and then schedule full repair loads to the the DSO.

Once the history is loaded then schedule the delta.

This will work for any kind of delta mode.

Thanks

Ajeet

[Former Member]

Hi Vijay......

We need to fill set up table only for Full upload and init Upload.........U set the delta mechanism.........

1) Fill the set up table

2) Execute init with data transfer..........this will set the init flag.........and Delta queue will get created......after this any new or changed records will go to Delta queue.....

3)Then run Delta Ip...........

And every time if u run the delta IP....no need to fill the set up table any more...........If u use Direct delta .....then changes will be directly get recorded in the Delta queue............But if u r using Unserialized V3 Update or Queued Delta........then data will get accumulated in the Update table or the Extraction queue respectively..........then u hav to schedule the V3 jobs.........to pull the data in the Delta queue.........

Regards,

Debjani......

[Former Member]

Hi,

you only need a downtime when filling the setup tables which is required to do a first initial load. After the initial load the system takes care about the deltas and no additional downtime needed.

Siggi

[Former Member]

Yes I know that but we have four streams that we are going live with huge amounts of data.Data volumes are around 150 million each stream.

I know the generall process the way we load the data for LO.

I was checking if any one of you follwed a process without downtime for Setup tables.

Thanks for your comments

Edited by: Vijayabhaskar Thammineni on Dec 11, 2008 4:02 PM

[Former Member]

Hi Vijay......

U can take a look to SAP Note 753654 >> How can downtime be reduced for setup table update

and 436393 >> Performance improvement for filling the setup tables........

Regards,

Debjani.......