Home > SAP FAQs > SearchSAP.com expert FAQ > SearchSAP.com FAQs > SAP BI FAQ > SAP BI FAQ > Our database is full -- how should we proceed?
FAQs: SearchSAP.com expert FAQ:
EMAIL THIS
 START   SEARCHSAP.COM FAQS   
SearchSAP.com FAQs


SAP BI FAQ
<< PREVIOUS | NEXT >>: How do I replicate and transfer datasources?

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   


<< PREVIOUS | NEXT >>: How do I replicate and transfer datasources?
VIEW ALL IN THIS CATEGORY

RELATED CONTENT
SAP BI/BW
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
The difference between ODS and DSO
The pros and cons of destination types, DB tables and 3rd party tools
What is the use of DTP in BI 7.0?
Measure the performance of an InfoCube
ECC COPA and transaction currency
Problem loading data into a DSO

SAP BW (business information warehouse)
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
The difference between ODS and DSO
The pros and cons of destination types, DB tables and 3rd party tools
What is the use of DTP in BI 7.0?
Measure the performance of an InfoCube
Problem loading data into a DSO
SAP's Business Objects deal presents opportunities, pitfalls for customers
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 ExpertsWebcastsWhite 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