‎2009 Aug 10 5:39 AM
Hi,
A program to determine YTD was scheduled to run in back ground.
Since the program is processing huge volume of data, the Job fails because of the shortage of shared memory space.
Solution developed:
We split the data into two slice and create another program to handle it.
i.e. previosly some 10M records were processed by a program. Instead 5M will be processed by existing prg and rest by new prg.
Question:
We are going to schedule the two program at the same time. Theoritically, its once again going to consume same memory. Will this once again result in shortage of memory space if we run it in parallel
Regards
Suresh Kumar
‎2009 Aug 10 5:43 AM
Hi,
If you are again trying to run both the programs parallely which access the same combination of tables , as you said it will consume the same amount of memory which might again fail. Its better to schedule the two programs in sequence such that the 2nd prog is run after the completion of the first program.
Regards,
Vik
‎2009 Aug 10 6:46 AM
Hello Suresh,
In memory consumstion lot of things matter it is not just the size of data. I have fetched 60 ~ 70 Million of data in background successfully. May be you need to check following things:
1. Code optimization
2. Memory settings of SAP server
3. How the selected data is stored
4. Most important the hardware configuration you are using
At least in background job it doesn't matter how big data you are selecting as long as above parameters are propperly tunned.
There is lot to explore in SAP! Enjoy SAP!
Thanks,
Augustin.