Home > Ask the SAP Experts > SAP BI/BW Questions & Answers > Our database is full -- how should we proceed?
Ask The SAP Expert: Questions & Answers
EMAIL THIS

Our database is full -- how should we proceed?

Jay Narayanan EXPERT RESPONSE FROM: Jay Narayanan

Pose a Question
Other SAP Categories
Meet all SAP Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 18 July 2005
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?

>
EXPERT RESPONSE
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.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
SAP BI/BW
Working with SD and MM data in tables
The difference between an SAP system and a non-SAP system
Preparing for an SAP BI interview
Job prospects after SAP BI training
An SAP BW 3.1 to BI 7.0 upgrade should not take one year
Is SAP BI knowledge advantageous to an ABAP user?
Key figures and web templates in SAP BI
Is ABAP knowledge necessary for SAP BI?
The prerequisites for SAP BI training
Using transactional and master data when creating an InfoCube

SAP BW (business information warehouse)
Preparing for an SAP BI interview
Job prospects after SAP BI training
An SAP BW 3.1 to BI 7.0 upgrade should not take one year
Is SAP BI knowledge advantageous to an ABAP user?
Key figures and web templates in SAP BI
Is ABAP knowledge necessary for SAP BI?
The prerequisites for SAP BI training
Using transactional and master data when creating an InfoCube
The tables/views used to populate extractors
Useful transaction codes in SAP BI
SAP BW (business information warehouse) Research

SAP BI FAQ
What is the difference between SAP BI and BW?
What are the responsibilities of an SAP BW administrator?
Is SAP BI/BW the right career area for an experienced software developer?
What is a return table in SAP BI update rules?
What are the prerequisites for an SAP BI career?
Should I consider SAP BI as a BW upgrade?
How do I replicate and transfer datasources?
SAP's business intelligence strategy: the NetWeaver platform
Can you give me an introduction to BI security?

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
BEx  (SearchSAP.com)
Business Information Warehouse  (SearchSAP.com)
Enterprise Services Architecture  (SearchSAP.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice

HomeNewsTopicsBlogsTipsAsk the ExpertsMultimediaWhite PapersProducts
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2000 - 2008, TechTarget | Read our Privacy Policy
SearchSAP.com is a search service provided by TechTarget and is completely
independent of and not affiliated with SAP AG.
  TechTarget - The IT Media ROI Experts