Q
Problem solve Get help with specific problems with your technologies, process and projects.

Our database is full -- how should we proceed?

Describes how to troubleshoot a full database. SAP BI/BW expert provides advice for uploading data into PSA and cube.

We are loading HR data into our BW development system on a weekly basis. It is a full upload, first to PSA, then to cube. After a few rounds of loading, the database is now full. How do we proceed in such a situation? Do we need to delete the PSA data regularly? Is there a better way to manage this?
This is a DBA responsibility. Check with your DBA and make sure the estimate for the database size was done correctly. You may check using the transaction DB02 and see if you have enough space in the relevant tablespace. If not, add more datafiles with the help of your DBA.

Next check the infocube change screen and make sure the storage parameters have been defined correctly. If not,...

you may have to reorganize the tables and change the storage parameters. It is always better to delete the redundant data stored in PSA after the data loads. Keep only three to four days of data in PSA unless there is a specific need to keep more. You can schedule jobs to delete PSA data. Use transaction RSA15 to go to PSA and schedule the job for specific loads.

This was last published in July 2005

Dig Deeper on SAP business warehouse

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close