We are getting I/O spool error very frequently, I have reorg the Temsee via sp12 during our monthly maint, but it is still not helping, any suggestions?


    Requires Free Membership to View

A consistency check compares data in table TST0I(TemSe objects) and TST03 (Temse data). You should delete any inconsistencies.

You can also perform consistency checks by using transaction SPAD (select Adnistration-oconsistency Check) or by executing the report RSPOOO43 as a periodic background job. Keep in mind that consistency checks in Temse run online and they may take a long time. It is best to run them when there is nobody logged on.

See these SAPNet notes for further information:
16875 Temse objects do not match Temse files
48400 Reorganization of Temse and Spool
98065 Spool consistency check with RSPO1043 as of 4.0A

If you don't have access to SAPNet just send me an e-mail and request the notes and I will e-mail them to you.

TemSe can store the data inside the database or at the operating system level. To determine where the data is stored, set the parameter rspo/store_location as follows:
db stores the data in the database (default)
G stores the data in an operating system file in the global directory

If storing in the database, make sure that the R/3 database has enough free space. Otherwise, expand the database files. If storing at the OS level, make sure that there's enough free space on disk.

By the way, this topic is covered in my book "SAP Basis Administration ... A Step-by-Step Guide to Practical Daily Tasks and Activities", chapter 8, page 180. Order it at www.giovannidavila.com/sapbasis


This was first published in June 2001

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: