Number range for spooler numbers SPO_NUM

[Former Member]

Hi!

Because of we create a lot of spool requests we set the max. range for object SPO_NUM to 999.999

Our current number is 900.000.

We run daily the standard job SAP_REORG_SPOOL with report RSPO0041 that deletes all the spool requests older than 8 days.

What will happen when the current number reaches the max. range 999.999?

Should we change/increase the max. range for object SPO_NUM to 9.999.999?

Any helpful information will be very appreciated.

[nelis · Accepted solution]

We run daily the standard job SAP_REORG_SPOOL with report RSPO0041

A high number of spool objects can also be a sign of inconsistencies in table entries which are not being deleted. Have you scheduled report RSPO1043 to run ? Also consider using report RSPO1041 instead of the older RSPO0041.

Note 98065 - Spool consistency check with RSPO1043 as of 4.0A

Note 130978 - RSPO1041 - Replacement for RSPO0041

Nelis

[Former Member · Accepted solution]

Hi!

Many thanks for the response!

The other job "SAP_SPOOL_CONSISTENCE" (Step: program "RSPO1043") runs daily.

The question is:

I run daily a job "SAP_REORG_SPOOL" (Step: program "RSPO1041") that deletes all the spool requests older that 8 days.

What will happen when the max. value from "SNRO_NUM" will be reached?

a) the spool numbers from deleted spool requests (Job "SAP_REORG_SPOOL") will be reused

b) no further spool request can be created, until the max. value from "SNRO_NUM" will be increased

Thank you!

[Former Member · Accepted solution]

a) yes exactly, happens regularly on our systems

b) no, this will only happen if you have 999'999 spools still existing in your system

Cheers Michael

BTW funny effect: if for example a job that ran two weeks ago has a certain spool associated and that spool got already deleted by SAP_REORG_SPOOL then it is possible that a new spool will be displayed. That is because the spool id was reused.

[former_member204746 · Accepted solution]

after going through 999.999, it will go to 000.001.

[JPReyes]

In theory if you are deleting the old spools it should reuse the ones that have been deleted

Check RZ20 -> MTE R3SpoolUsedNumbers and it will tell you the porcentage used... if the number is too big then you should consider extending the number range.

Regards

Juan