Adaptive Server contains a separate user log cache (ULC) for the temporary database assigned to the session. The ULC allows Adaptive Server to avoid log flushes when users switch between a user database and session’s temporary database, or if all the following conditions are met:
Adaptive Server is currently committing the transaction.
All the log records are in the ULC.
There are no post-commit log records.
The configuration option, session tempdb log cache size, which allows you to configure the size of the ULC, helps determine how often it needs flushing. See Chapter 5, “Setting Configuration Parameters,” in the System Administration Guide: Volume 1.
