Memory Usage

[Former Member]

We are frequently experiencing failure of our process chains. The error message from ST22 is: TSV_TNEW_PAGE_ALLOC_FAILED. It appears that the work process memory quota (ztta/roll_extension) is being exceeded. The parameter ztta/roll_extension is currently set to 6GB. After testing we have observed that by reducing the number of CVCs the memory utilization also goes down. Are there any recommendations for setting ztta/roll_extension for 400,000 CVCs * 78

weekly buckets * 10 key figures?

[former_member187488]

Hello,

If your job is a DP job, please refer to SAP note 864950 and follow the suggestions in the note.

Basically. there're following points:

1)If the job is relevant to planning book/data view, make sure only needful key figures are loaded in the data view.

2)Macros should only be executed on detailed level, except when aggregate level execution is also necessary.

3)Try not to use navigational attributes.

4)Make sure the consisteny of the planning area by:

/sapapo/ts_lcm_reorg

/sapapo/ts_lcm_cons_check

5)If you use fixed aggregates, they may affect the performance very much.

Try to deactivate them and run /sapapo/ts_lcm_cons_check before the job (if the job changes relevant data).

Then activate and fill the fixed aggregates afterwards.

Best Regards,

Ada