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.

  1. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Databases.
  2. Select one of:
    • User Databases
    • System Databases
    • Temporary Databases
    • Proxy Databases
  3. Click the Name field of the database, then click the drop-down arrow and select Properties.
  4. Click Transaction Log.
    You see the list of caches; the highlighted cache is the one currently configured for your database I/O buffer.
  5. Select a different cache and click Apply.
Related tasks
Changing Database Ownership
Modifying Database Storage Allocations
Changing Database Options
Viewing Database Statistics
Related reference
Database Properties