on 12-17-2014 10:46 AM
Hi
In our Production system running on HP-UX, DB2 10.1, tablespace SAPTOLLS growing rapidly, we have added the containers but the same get utlized in couple of days. before 1 month never this tablespace came into picture, this was happening from last 1 month. Kindly suggest what could be the possible reason.
Regards
Hi,
How about reorg...?
2006899 - How to configure Reorg on saptools database in DBACockpit
1775273 - DB6: SAPTOOLS tables are not properly reorganized
Regards,
Prithviraj.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Srenivasan
thanks for the reply
as per the mention note the correction is applicable for SAP_BASIS SAPKB70211 and our system is running on 20212, so this already been applied, i checked the table SP_MSG_LOG and its size is very less < 2MB and no other table extended beyond 50 MB. due to increase in tablespace we have added 2 GB of containers which again has been utilized. we observed it happens during night where 1.8 % growth is happening and through out the day it will be on the same size. it seems some background job is running during night which is effecting in growing the utilization. kindly suggest is there any specific job which is hampering, its quite difficult to look on each jons as many jobs are scheduled during nights.
Regards.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
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.