Regarding Re-organizing ST22

[Former Member]

Hi Experts,

I want to re-organize ST22 and want to change the keep days to 8 (right now it is 0)

Before changing that I want to know more about the impacted tables

Moreover , I had some queries on the program RSSNAPDL .

In our system , the SNAP table can hold a max of 2000000 and Max. delete at once =1000

Whenever I check the SAP_REORG_JOBS in our system . It usually deletes more than 1000 entries .

I couldn't able to catch the logic behind the program RSSNAPDL (Which uses the default variant of sap)

Could you guys explain me in detail ?

Thanks in Advance

Regards

Sandeep

[Former Member]

Hello Gurus ,

Please help me out ...

In our production system , ST22 holds only last 24 hrs dumps. I couldn't see last few days dumps.

When I checked the program RSSNAPDL .

We have a scheduled job which runs with prog. RSSNAPDL everyday with variant "DEFAULT".

when I checked the variant. I found the following things

1000 Max. entries to be kept P 100,000

1000 Entries which can be deleted P 500

1000 Storage Date P 28

But when I checked the joblog of the job , I found that the job is deleting last days dumps

FYI :

06/14/2011 01:00:01 Job started

06/14/2011 01:00:01 Step 001 started (program RSSNAPDL, variant DEFAULT, user ID BASIS-BATCH

06/14/2011 01:03:06 874 entries deleted from table SNAP

06/14/2011 01:03:07 794 entries deleted from table SNAP

06/14/2011 01:03:07 553 entries deleted from table SNAP

06/14/2011 01:03:08 531 entries deleted from table SNAP

06/14/2011 01:03:08 842 entries deleted from table SNAP

06/14/2011 01:03:09 601 entries deleted from table SNAP

06/14/2011 01:03:09 794 entries deleted from table SNAP

06/14/2011 01:03:10 529 entries deleted from table SNAP

06/14/2011 01:03:10 794 entries deleted from table SNAP

06/14/2011 01:03:10 553 entries deleted from table SNAP

06/14/2011 01:03:11 846 entries deleted from table SNAP

06/14/2011 01:03:11 650 entries deleted from table SNAP

06/14/2011 01:03:11 794 entries deleted from table SNAP

06/14/2011 01:03:12 794 entries deleted from table SNAP

06/14/2011 01:03:12 529 entries deleted from table SNAP

06/14/2011 01:03:12 553 entries deleted from table SNAP

06/14/2011 01:03:13 794 entries deleted from table SNAP

06/14/2011 01:03:13 794 entries deleted from table SNAP

06/14/2011 01:03:14 530 entries deleted from table SNAP

06/14/2011 01:03:14 553 entries deleted from table SNAP

06/14/2011 01:03:15 794 entries deleted from table SNAP

'

'

'

06/14/2011 01:04:19 837 entries deleted from table SNAP

06/14/2011 01:04:19 156 entries deleted from table SNAP

06/14/2011 01:04:19 Short dumps from 06/12/2011 05:56:07 to 06/13/2011 10:31:04 deleted

06/14/2011 01:04:19 Job finished

[Former Member]

Here , My quesyions are

1).If it needs to delete a max of 500 entries at once. Why I could see entries with more than 500 entries deleted almost all the time

2).If the keep parameter is set to 28 .

It should not delete the last old 28 days dumps.

In my case , the job is deleting the previous days dumps as well .

Please correct me if my understanding is wrong

Thanks All in Advance

Regards

Sandy

[Former Member]

Have you checked this note:

https://service.sap.com/sap/support/notes/1091769

Thanks

SM

[Former Member]

The SNAP is also automatically reorganized. With each short dump that occurs in the dialog box (the dump is displayed as soon as it occurs), a maximum of 20 short dumps are deleted from the SNAP that are older than 7 days. In normal production operation this reorganization should be sufficient.

Run a reorg on this table .. i think this should be ok .. instead of running the background job ..

[Former Member]

Hi All,

Thanks for the responses

@SM : Thanks for your note .. but my SAP_BASIS version is 701 ( good stuff in the note)

The problem in our system is daily there around 600-900 dumps and it fiils around 100000 entries in SNAP.

As my SNAPMAX is 100000 , It removes all previous days dumps.

So , I hope increasing this parameter to some extend will work for us.

Thank again

Regards

Sandy

[Former Member]

Hi All,

Thanks for the responses

@SM : Thanks for your note .. but my SAP_BASIS version is 701 ( good stuff in the note)

The problem in our system is daily there around 600-900 dumps and it fiils around 100000 entries in SNAP.

As my SNAPMAX is 100000 , It removes all previous days dumps.

So , I hope increasing this parameter to some extend will work for us.

Thank again

Regards

Sandy