RE: [sap-basis] Database Growth
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Lars-Erik Hallsten (CEO & Senior Consultant) on Feb 14 at 10:13 AM |  Mark as helpful |
Hi,
What you should do, is to contact the management and flag the need for a
data archiving project in your SAP environment.
Data archiving requires involvement of several different people in your
organization, so it's not something this forum can give you an accurate
answer on what to do.
Regards,
LEH
From: Geras via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 14. februar 2010 3:27
To: Lars-Erik Hallsten
Subject: Re: [sap-basis] Database Growth
Posted by Geras
on Feb 14 at 9:27 AM
<http://it.toolbox.com/api/ContentVote/3305374/1/1/> Mark this reply as
helpfulMark as helpful
Hi,
Since you have been succesful, scheduling RSPO1041 for TST03, I would
recommend also to verify this job has been created using sap standard user
as ddic, otherwise if the account u used to schedule is canceled job will
fail and TST03 will grow again.
Also you should consider to perform a table reorg TST03 reorg, you might
gain free space within database. Ive done this in oracle not so sure about
MSSQL, after reorg I was able to resize some datafiles and gain not only DB
free space but OS Filesystem free space.
Regards.
On Sun, Feb 14, 2010 at 2:26 AM, Awnindra Tiwary via sap-basis <
sap-basis@groups.ittoolbox.com> wrote:
>
> Posted by Awnindra Tiwary (Manager
> IT)
> on Feb 14 at 9:08 AM
> Hi All,
> I have scheduled the job RSPO1041(FOR TABLE TST03) now my database growth
> is
> decreased to about 96 MB per day from 300MB.
> Now following tables are growing fast. Please suggest me what should i do
> for BASIS related tables. For users table(transactional table) i m taking
> care. and what is idle growth in my case.
> Table name Sample dt Dt delta Data Data delta Index Idx
> delta Reserved Res. delta Rows Rows delta OCSCMPLOBJ 13.02.2010
> 16.09.2009 1,342,648 68,488 286,864 41,928 1,629,752 110,360 1,956,300
> 100,901 ACCTIT 13.02.2010 11.02.2010 1,097,336 17,368 113,200 1,800
> 1,210,960 19,136 841,121 13,313 MSEG 14.02.2010 12.02.2010 1,185,672
16,520
>
> 276,080 3,656 1,463,296 20,160 738,183 10,293 TTREEI 14.02.2010 21.08.2009
> 215,624 14,200 319,152 120,168 534,840 134,344 1,482,320 97,548 COSP
> 14.02.2010 12.02.2010 727,488 10,664 266,288 3,928 994,544 14,600 439,848
> 6,103 TPR_XREF_D 14.02.2010 21.08.2009 10,008 10,008 14,064 14,064 24,096
> 24,096 75,022 75,022 QASE 14.02.2010 12.02.2010 523,488 8,040 11,216 192
> 534,832 8,192 898,046 14,378 BSIS 14.02.2010 12.02.2010 476,216 6,888
> 90,656 1,328 567,792 7,936 585,905 8,741 S033 13.02.2010 11.02.2010
363,168
>
> 5,568 307,168 4,056 671,056 9,664 674,232 10,124 COEP 13.02.2010
11.02.2010
>
> 308,456 4,936 145,104 2,312 454,040 7,232 410,480 6,460 FAGL_SPLINFO
> 14.02.2010 12.02.2010 254,336 3,928 166,160 2,688 422,224 6,592 386,039
> 5,906 RFBLG 13.02.2010 11.02.2010 235,704 3,904 3,984 56 239,880 3,968
> 121,988 1,906 BDLSADATA 13.02.2010 16.07.2009 9,296 3,296 224 72 9,576
> 3,408 64,783 21,375 S094 14.02.2010 25.08.2009 3,016 3,016 1,096 1,096
> 4,192 4,192 7,362 7,362
> rgds
> Awnindra Dutt Tiwary
>
> On Fri, Feb 12, 2010 at 2:56 PM, D. Caddick via sap-basis <
> sap-basis@groups.ittoolbox.com> wrote:
> >
> > Posted by D. Caddick (SAP
> > NetWeaver/BASIS Consultant)
> > on Feb 12 at 4:36 AM
> >
> > Hi Awnindra,
> >
> > You can also use Tx SP01 and select all the Spool requests up to a
> selected
> > date and delete them.
> >
> > Regards
> >
> > ---------------Original Message---------------
> > From: kalyan11
> > Sent: Thursday, October 09, 2008 12:55 PM
> > Subject: Database Growth
> >
> > > Hi there<br/><br/>Is there any SAP Function module or report that
would
>
> > report the database growth for a month or so or thereabouts.....Other
> than
> > all the wonderful information that you get from DB02 ofcourse. Our
> database
> > is oracle 9.x and sap version is Enterprise 4.7. Any thoughts would be
> > appreciated.<br/><br/>Regards<br/>Kalyan
__.____._ What you should do, is to contact the management and flag the need for a
data archiving project in your SAP environment.
Data archiving requires involvement of several different people in your
organization, so it's not something this forum can give you an accurate
answer on what to do.
Regards,
LEH
From: Geras via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 14. februar 2010 3:27
To: Lars-Erik Hallsten
Subject: Re: [sap-basis] Database Growth
Posted by Geras
on Feb 14 at 9:27 AM
<http://it.toolbox.com/api/ContentVote/3305374/1/1/> Mark this reply as
helpfulMark as helpful
Hi,
Since you have been succesful, scheduling RSPO1041 for TST03, I would
recommend also to verify this job has been created using sap standard user
as ddic, otherwise if the account u used to schedule is canceled job will
fail and TST03 will grow again.
Also you should consider to perform a table reorg TST03 reorg, you might
gain free space within database. Ive done this in oracle not so sure about
MSSQL, after reorg I was able to resize some datafiles and gain not only DB
free space but OS Filesystem free space.
Regards.
On Sun, Feb 14, 2010 at 2:26 AM, Awnindra Tiwary via sap-basis <
sap-basis@groups.ittoolbox.com> wrote:
>
> Posted by Awnindra Tiwary (Manager
> IT)
> on Feb 14 at 9:08 AM
> Hi All,
> I have scheduled the job RSPO1041(FOR TABLE TST03) now my database growth
> is
> decreased to about 96 MB per day from 300MB.
> Now following tables are growing fast. Please suggest me what should i do
> for BASIS related tables. For users table(transactional table) i m taking
> care. and what is idle growth in my case.
> Table name Sample dt Dt delta Data Data delta Index Idx
> delta Reserved Res. delta Rows Rows delta OCSCMPLOBJ 13.02.2010
> 16.09.2009 1,342,648 68,488 286,864 41,928 1,629,752 110,360 1,956,300
> 100,901 ACCTIT 13.02.2010 11.02.2010 1,097,336 17,368 113,200 1,800
> 1,210,960 19,136 841,121 13,313 MSEG 14.02.2010 12.02.2010 1,185,672
16,520
>
> 276,080 3,656 1,463,296 20,160 738,183 10,293 TTREEI 14.02.2010 21.08.2009
> 215,624 14,200 319,152 120,168 534,840 134,344 1,482,320 97,548 COSP
> 14.02.2010 12.02.2010 727,488 10,664 266,288 3,928 994,544 14,600 439,848
> 6,103 TPR_XREF_D 14.02.2010 21.08.2009 10,008 10,008 14,064 14,064 24,096
> 24,096 75,022 75,022 QASE 14.02.2010 12.02.2010 523,488 8,040 11,216 192
> 534,832 8,192 898,046 14,378 BSIS 14.02.2010 12.02.2010 476,216 6,888
> 90,656 1,328 567,792 7,936 585,905 8,741 S033 13.02.2010 11.02.2010
363,168
>
> 5,568 307,168 4,056 671,056 9,664 674,232 10,124 COEP 13.02.2010
11.02.2010
>
> 308,456 4,936 145,104 2,312 454,040 7,232 410,480 6,460 FAGL_SPLINFO
> 14.02.2010 12.02.2010 254,336 3,928 166,160 2,688 422,224 6,592 386,039
> 5,906 RFBLG 13.02.2010 11.02.2010 235,704 3,904 3,984 56 239,880 3,968
> 121,988 1,906 BDLSADATA 13.02.2010 16.07.2009 9,296 3,296 224 72 9,576
> 3,408 64,783 21,375 S094 14.02.2010 25.08.2009 3,016 3,016 1,096 1,096
> 4,192 4,192 7,362 7,362
> rgds
> Awnindra Dutt Tiwary
>
> On Fri, Feb 12, 2010 at 2:56 PM, D. Caddick via sap-basis <
> sap-basis@groups.ittoolbox.com> wrote:
> >
> > Posted by D. Caddick (SAP
> > NetWeaver/BASIS Consultant)
> > on Feb 12 at 4:36 AM
> >
> > Hi Awnindra,
> >
> > You can also use Tx SP01 and select all the Spool requests up to a
> selected
> > date and delete them.
> >
> > Regards
> >
> > ---------------Original Message---------------
> > From: kalyan11
> > Sent: Thursday, October 09, 2008 12:55 PM
> > Subject: Database Growth
> >
> > > Hi there<br/><br/>Is there any SAP Function module or report that
would
>
> > report the database growth for a month or so or thereabouts.....Other
> than
> > all the wonderful information that you get from DB02 ofcourse. Our
> database
> > is oracle 9.x and sap version is Enterprise 4.7. Any thoughts would be
> > appreciated.<br/><br/>Regards<br/>Kalyan
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Lars-Erik HallstenSAP Basis Helper
Posted helpful replies on 50 threads in a group to earn a Silver Achievement
Related Content
In the Spotlight
White Papers
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
