Skip to Content
0
Former Member
Nov 18, 2008 at 02:48 AM

BW Data Base Maintenance Activities - Help Required

55 Views

Hi,

In my projecect i received complaint from my client is that BW database is growing at an unprecedented speed. As per our analysis by using DB02, we found following places, we need to focuus more to take action on this situation

1) /BIC/B0000259000

8ZSAL_AO1_AA

CHANGELOG

337 231 872

337 231 872

2) /BIC/B0001141000

2LIS_13_VDKON_BA

PSA

136 868 864

474 100 736

3) /BIC/B0000138000

8ZISA_O02_AA

CHANGELOG

116 229 120

590 329 856

4) /BIC/B0001140000

8ZSDO14_AA

CHANGELOG

110 699 520

701 029 376

5) /BIC/AZSDO1400

ZSDO14

ODS

100 457 472

801 486 848

With the reference of above data, i need few clarifications.

1) What is the best Practice to delede the data from PSA? How to perform the deletion of data from PSA? (Point# 2 above)

2) Can we allowed to deleted the Changelogs from ODS? If yes, what is the Best Practice to follow? (Points# 1,3,4)

3) If Specific ODS size is keep on increasing, what is the required action? Do we need to increase Table space? (Point Number 5 above)

Please help me to take action on these issues.

Best regards,

Venkata Challapalli.