Increase the system stats retention for 1 year on production

[Former Member]

Hello Basis All,

I need to extend the collection of Stats period for 1 year on production.

When i use the st03n, it gets me for three months.

we are using 4.7 on oracle database. What are the changes i need to make with or without disturbing the system.

Appreciate for any quick responce.

Thanks all,

[guillaume-hrc · Accepted solution]

Hi,

I don't think this is easily customizable.

Try <b>transaction RSPFPAR_SPOOL</b>

You should see a parameter called <b>rspo/req_lifetime</b> which indicates a number. The higher the number is, the longer is the spol retention period.

Unfortunately, values are pre-determined and are in days (up to 8 days I think).

You may modify this parameter with the <b>RZ11 transaction</b>.

Here is a workaround solution:

- set the parameter to 9 (which means no deletion)

- periodically runs the job RSPO1041 (which is a standard job for deleting old spool requests) with a dedicated variant.

This way, you can achieve the 1-year retention period you want.

Hope it helps.

Best regards,

Guillaume

Message was edited by: Guillaume Garcia

Message was edited by: Guillaume Garcia

[Former Member · Accepted solution]

Garcia, thank you for the reply. I appreciate your help.This was not regarding spool, but still i would like to give points on this.

[Former Member]

This is not the spool retention. This is regarding the system stats retention for a period of 1 year needed. i have checked this trough the st03n and it is keeping 3 months and i want this to be increased to 1 year.so needed to know what changes are to be made for this and how the system would be affected?

[Former Member]

Hi Sridhar

In ST03N

choose Expert mode

expand Collector & Performance DB >Performance dB>reorganization

Here you have to maintian the retension for ST03 values

More details are at

http://help.sap.com/saphelp_nw04/helpdata/en/c4/3a68d5505211d189550000e829fbbd/frameset.htm

Regards

Ravinder

[Former Member]

First of all, i thank you for the reply. I encourage you to for this active participation.

I had resolved by the time this solution came up through help.sap.com.

Again i appreciate your help.

Thanks a lot.

[Former Member]

can u share what exactly u did?

[Former Member]

Please let us know what exactly you did for the resolution?