on 02-11-2012 6:24 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
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.