Skip to Content

SAP-PI Table Space.Growth

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 11, 2012 at 02:28 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 11, 2012 at 09:48 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member yoonus ch

      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.