Ask the Expert

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

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: