SAP-PI Table Space.Growth

[former_member186190]

HI SAP Basis Team

How to control PI database growth daily it is increasing Up to 1gb. How can i control this and how to get back my database size back. is there any data saving in Db? b4 it was normal now also it is normal, current condition 10MB or 5 MB per day growth.But few months back Growth is 1 or 1.5 GB per day. now there no disk size in OS level so i need to get back my increased space.is there any logs to delete.

Below Jobs are running currently.Apart from any program or Jobs to get back my database size?

SWEQSRV

SWF_XI_DISPATCH

SWWDHEX

RSXMB_RESTART_MESSAGES

SWWERRE

SAP_CCMS_MONI_BATCH_DP

SAP_REORG_JOBS

SAP_REORG_TOOL_DISP

SAP_COLLECTOR_FOR_PERFMONITOR

/BDL/TASK_PROCESSOR

BTCH_RSORAVSH

SAP_COLLECTOR_FOR_NONE_R3_STAT

SAP_XMB_PERF_AGGREGATE

SAP_XMB_PERF_REORG

DEL_HIST_PROCESSD_XML

DELETE_MESSAGES

SAP_SLD_DATA_COLLECT

SAP_COLLECTOR_FOR_JOBSTATISTIC

SAP_REORG_SPOOL

SAP_REORG_XMILOG

SWWCLEAR

EU_PUT

RSXMB_AGG_DATA_CONDENSE

RSXMB_TABLE_SWITCH

SAP_REORG_BATCHINPUT

EU_REORG

RSWF_XI_INSTANCES_DELETE

SAP_REORG_TSP

SAP_REORG_NONE_R3_STAT_DB

SAP_REORG_SNAP

SAP_SRT_METERING_REORG

RSPO1043

DBA:CHECKDB_________@050000/0001

RSSLGK90_DELETE_OLD_APPLOG

DBA:UPDATESTATS_____@070000/0001

SXMS_REFRESH_ADAPTER_STATUS

SAP_REORG_JOBSTATISTIC

SAP_REORG_PRN

Z:RSXMB_ARCHIVE_PLAN

SAP_REORG_JOB2

DBA:UPDATESTATS_____@040000/5007

Databse: Oracle 10g

Component: EHP1 Netw: 7.10

Basis/Abap/PI-BASIS: patch level: 711/006

Thanks & Reg

engli

SAP Basis.

[Former Member]

Hello,

Regarding database tables, the fastest growing tables in PI are usually SXMSCLUR and SXMSCLUP. You have to schedule periodic jobs, check for example here:http://wiki.sdn.sap.com/wiki/display/XI/PIArchivingConceptual+Overview

And the official documentation here: Note 872388 - Troubleshooting Archiving and Deletion in PI

For general tables (not specific to PI): Note 706478 - Preventing Basis tables from increasing considerably

Another thing you might want to check are java logs: http://forums.sdn.sap.com/thread.jspa?threadID=1643899

Cheers,

Diego.

Edited by: Diego I. Yaryura on Feb 11, 2012 11:14 PM

[former_member186190]

HI Diego.

I can found this much 3586122 entries are in SXMSCLUR and SXMSCLUP. these two table. Is this logs are required or can i delete? and also i run this report RSXMB_SHOW_REORG_STATUS

Reorganization Status of XI Messages in Database

Evaluation

==========

Execution 12.02.2012 10:17:50 UTC+4

Overview

========

Retention periods and message and ad

Number of messages in DB: 1,802,364

Number of messages in client: 1,802,364

Number of messages in client still to be reorganized: 1,802,261

How to delete all these logs?

THanks

engli

Edited by: Yoonus on Feb 12, 2012 7:37 AM

[former_member186190]

Hi Diego

see the messages after running the program RSXMB_SHOW_STATUS

Date: 12.02.2012

Time: 10:34:35 UTC+4

Table Container: SXMSPMAST

================================================================================

Overview (Time Stamp Not Included)

1802368 Number of Messages in Database

1802368 Number of Messages in Client

1802265 Number of Messages for Reorganization in Client

Number of Messages to Be Archived in Client

103 Number of Logically Deleted Messages in Client

Number of Archived and Logically Deleted Messages in Client

================================================================================

Message Status

Message Status: 000

12066 Message Status: 001

Message Status: 002

4395 Message Status: 003

Message Status: 004

Message Status: 005

Message Status: 006

Message Status: 007

Message Status: 008

2 Message Status: 009

Message Status: 010

Message Status: 011

Message Status: 012

Message Status: 013

1785905 Message Status: 014

Message Status: 015

Message Status: 016

Message Status: 017

Message Status: 018

Message Status: 019

Message Status: 020

Message Status: 021

Message Status: 022

Message Status: 023

Message Status: 024

Message Status: 025

Message Status: 026

Message Status: 027

Message Status: 028

Message Status: 029

Message Status: 030

Message Status > 030 to < 100

Message Status: 100

Message Status: 101

Message Status: 102

Message Status: 103

Message Status: 104

Message Status: 105

Message Status: 106

Message Status: 107

Message Status: 108

Message Status: 109

Message Status: 110

Message Status: 111

Message Status: 112

Message Status: 113

Message Status: 114

Message Status: 115

Message Status: 116

Message Status: 117

Message Status: 118

Message Status: 119

Message Status: 120

Message Status: 121

Message Status: 122

Message Status: 123

Message Status: 124

Message Status: 125

Message Status: 126

Message Status: 127

Message Status: 128

Message Status: 129

Message Status: 130

Message Status > 130

================================================================================

Adapter Status

Adapter Status of Messages with Message Status: 003

1644 Adapter Status: 000

Adapter Status: 001

Adapter Status: 002

Adapter Status: 003

Adapter Status: 004

Adapter Status: 005

2661 Adapter Status: 006

90 Adapter Status: 007

Adapter Status: 008

Adapter Status: 009

Adapter Status: 010

Adapter Status > 010

3586261 Number of messages in table CLUR

3586132 Number of messages in table CLUP

3586111 Number of messages in table VERS

1785907 Number of messages in table ERROR

1802368 Number of Messages in Table EMAS

1802368 Number of Messages in Table MAST

thanks

Engli

Edited by: Yoonus on Feb 12, 2012 7:37 AM

[Former Member]

Hello!

You have "a lot" of messages in status 14:

....

1785905 Message Status: 014

....

Check the note I mentioned earlier (872388):

"Messages with status 014 and 017 have to be cancelled first. You can use transaction SXMB_MONI, search for erroneous messages and manually cancel them or you can use the report RSXMB_CANCEL_MESSAGES. SAP does not recommend scheduling this job in productive environment. If you use it to cancel messages in productive environment you have to make sure that the messages to be cancelled have been resend or that it is ok for business to cancel them."

Cheers,

Diego.

[former_member188883]

Hi,

You need to first check with table is growing. You can get a list of top growing tables in db02.

In case a that list contains basis tables which are growing , there could be SAP notes to work on controlling the same.

Regards,

Deepak Kori

[former_member186190]

Dear deepak

SAPSR3 table is increasing.

thanks

engli