Home | Previous Page | Next Page Logging and Log Administration >

Managing Logical-Log Files

In This Chapter

Estimating the Size and Number of Log Files

Estimating the Log Size When Logging Smart Large Objects

Estimating the Number of Logical-Log Files

Backing Up Logical-Log Files

Backing Up Blobspaces

Backing Up Sbspaces

Switching to the Next Logical-Log File

Freeing a Logical-Log File

Deleting a Log File with Status D

Freeing a Log File with Status U

Freeing a Log File with Status U-B or F

Freeing a Log File with Status U-C or U-C-L

Freeing a Log File with Status U-B-L

Monitoring Logging Activity

Monitoring the Logical Log for Fullness

Monitoring Temporary Logical Logs

Using SMI Tables

Using ON-Monitor (UNIX)

Monitoring Log-Backup Status

Allocating Log Files

Adding Logs Dynamically

Size and Number of Dynamically Added Log Files

Location of Dynamically Added Log Files

Adding Logical-Log Files Manually

Dropping Logical-Log Files

Changing the Size of Logical-Log Files

Moving a Logical-Log File to Another Dbspace

Changing Logging Configuration Parameters

Using ON-Monitor to Change LOGFILES (UNIX)

Displaying Logical-Log Records

Monitoring Events for Dynamically Added Logs

Setting High-Watermarks for Rolling Back Long Transactions

Long-Transaction High-Watermark (LTXHWM)

Exclusive Access, Long-Transaction High-Watermark (LTXEHWM)

Adjusting the Size of Log Files to Prevent Long Transactions

Recovering from a Long Transaction Hang

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]