Spool logs: The basics about spool log maintenance

Can you please answer a few questions about spool logs?
1. Where are spool logs stored?
2. Why do we clean them? Why can't we just delete them?

    Requires Free Membership to View

The TemSe database is the store for temporary sequential data -- objects that are not permanently stored in the system. Spool requests can be kept in the filesystem or inside the database in table TST03. With parameter 'rspo/store_location' you can specify the location. Parameter G stands for filesystem, db for database table TST03.

The TemSe database is not an archiving system. The maximum accessible number of spool requests is limited to 32,000. The default value can be increased if needed. However, this affects performance.

This was first published in August 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.