Table switch procedure (SAP_BC_XMB_DELETE_xxx)

[Former Member]

I will like to change maximum table entries (see below). But I can't find where to change it.

Job log:

Analyze table container

Current/maximum number of table entries: 1.277.238 / 5.000.000

Current fill level: 26 %

A table switch is required

br

Peter Jacobsen

[Former Member]

Hi Eoin

I tried to change Sizecategory from 4 to 2 but still same problem.

Could It be another table ?

br

Peter Jacobsen

[Eoin_Kierans]

When you changed the size category was the Maximum Number of table entries still the same? What is the current active container SXMSPMAST or SXMSPMAST2. Most likely if you changed the setting for SXMSPMAST but there was no change in the Maximum Number of Table Entries then the current active container is SXMSPMAST2 and therefore the change should also be made for this table.

Can you elaborate on why you need to change this value?

Edited by: Eoin Kierans on May 16, 2011 4:40 PM

Edited by: Eoin Kierans on May 16, 2011 5:03 PM

[Former Member]

Hello Peter! The number of maximum entries does not mean you can't have more messages on the PI. This is used mainly by the Switch Procedure run, to determine the % of messages the job should start (parameter DROP_MAX_TABLE_LOAD). Therefore, you don't need to change the parameter for most basic PI standard behavior.

Please refer to the note below for more information:

#872388 - Troubleshooting Archiving and Deletion in PI

[Eoin_Kierans]

This value was calculated by DDic. Depending on table size category, DB Hardware,etc.

You can see this value by the table size category. ( Transaction SE11 (table e.g. SXMSPMAST) -> Technical Settings -> Sizecategory ).

The description is:

The size category determines the probable space requirement for a table in the database.

You can select the categories 0 to 4 for your table. Each category is assigned a specific fixed storage area value in the database. When you create a table, initial space is saved for it in the database. If more space is required later as a result of data that has been entered, the storage space is increased in accordance with the category selected.

Press F4 on the field Size category to see the number of data records that can be maintained for the individual categories of your table without complications ensuing. These complications could be for example a reorganization becoming necessary because the maximum space to be reserved for the table was exceeded due to the maintained size category."

Edited by: Eoin Kierans on May 13, 2011 3:41 PM