Modifying the Transaction Log Cache and the Log I/O Buffer Size

Use the Database Properties wizard to modify the transaction log cache and the log I/O buffer size.

Change the size of the transaction log cache and log I/O buffer by binding the log to a cache of different size. The log buffer size determines the number of I/O transactions that can be stored in the transaction log I/O cache.

In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Databases.
Select one of:
- User Databases
- System Databases
- Temporary Databases
- Proxy Databases
Click the Name field of the database.
Click the arrow and select Properties.
Sybase Control Center displays the Properties wizard.
Click Transaction Log.
You see the list of caches; the highlighted cache is the one currently configured for your database I/O buffer.
Select a different cache and click Apply.