on 01-17-2014 3:05 PM
Hello expert,
Regarding table SXMSCLUR and SXMSCLUP, there are a lot of blog and notes on it.
Most of them are talking on using a program to delete surplus data,or archive,deletion job.
The notes give solution to delete table content,but it didn't explain the reason.
Deletion and archive jobs iwill delete message,but it seems no jobs will delete content of SXMSCLUR and SXMSCLUP.
In recent days,we met a issue related to these two tables.
DBA found one of our table-space increased quickly in recent days,in DB02 we found the remarkable increase were in table SXMSCLUR and SXMSCLUP and related SYS_LOB0000$$ table.
We checked our regular deletion program:
RSXMB_DELETE_MESSAGES
RSXMB_TABLE_SWITCH
RSXMB_DELETE_HISTORY
They ran normally everyday.
We don't understand why the content of SXMSCLUR and SXMSCLUP increase so quickly after a certain date?
Actually,we didn't find remarkable increase of SXMSCLUR and SXMSCLUP before that date.
Is there any auto housekeeping mechanism to clean the table content, and it is easy to break?
Pls help.
Thanks.
Hello
The delete jobs in PI will do just that i.e. they delete the PI messages from the DB. But they do not release the DB tablespace. This is up to the DB Administrator. Depending on your DB, it will be necessary to run
DB reorganization jobs to release the space. See note 1791627 PI DB tables relevant for Reorg jobs, for more details.
Some possible reasons why these tables would increase greatly in size:
Regards
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The above suggested report (RSXMB_DEL_CLUST_TABLE) is applicable only if you are under XI 3.0 SP 31.
However please check if you have scheduled multiple archive/deltion jobs.
go to SXMB_MONI->background job monitor -> It'll give an overview and schedule details.
You must not setup multiple archival/deletion jobs.
Also please go through the troubleshooting guide :
872388 - Troubleshooting Archiving and Deletion in PI
We had the same issue. In our case unfortunatly there were multiple jobs scheduled and not all the messages were getting deleted.
When you are in the process of troubleshooting, i would also suggest you to create an OSS message.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please check the below discussion
check the below in the discussion
You should run report "RSXMB_DEL_CLUST_TABLE" to delete entries from this two tables.
Yo need activate Archiving and Deletion Jobs.
To find the relevant jobs, call transaction SXMB_ADM and choose: Administration > Schedule Archiving Jobs
If you using BPM see this notes:
SAP Note 836092: Archiving/deleting work items in the XI
SAP Note 874708: BPE HT: Deleting message persistence data in SWFRXI*
you can also check the retention period configuration in SXMB_ADM (retention period should not be too large).
to check why the size is increasing, check the reply from Daniel in below discussion
regards,
Harish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
11 | |
11 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.