Q
Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

Finding the problem when SAPARCH is approaching 100%

When it is observed that SAPARCH is approaching 100%, what is the basic course of action in researching what is...

causing the problem and why is SAPARCH space so critical? First of all for the whole community: Please, if you want good advice, be specific on what you are asking. Tell us the context, the SAP release, for DB issues the DB brand, release and patch level you are using and in case of a problem describe the nature of the problem.

In this case, I can only guess what the problem is. SAPARCH is the DB archive redo log written with every modification of the DB. If you have large amounts of DB changes in a relatively small time window, the archive log may run out of space. Many DB systems are designed to find the archive log on a streaming tape. In reality the log is written to a disk nowadays. That leads to the situation, that if the HD runs out of space, the system seems to hang, because only a laconic message appears on a console, telling that the log is full and a new medium should be inserted.

To find out what the cause is: read the log and see what table or table space is flooding the DB, this may give you sufficient hints to detect the causing application.

This was last published in July 2004

Dig Deeper on SAP ABAP

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