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?
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
Dig deeper on SAP Basis administration and NetWeaver administration
Related Q&A from Giovanni Davila
Learn how to transfer a client from one server to another in this administration tip from Basis guru Giovanni Davila.continue reading
Learn how to access tables from the OS level in this expert tip by Basis guru Giovanni Davila.continue reading
Learn how to return a list of 1,000 transport requests in SAP R/3 PRD in this tip from SearchSAP.com's Basis expert.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.