This parameter allows you to change the location where log files are stored. The path name that you specify must be a fully qualified path name, not a relative path name, and it cannot exceed 242 bytes.
| Note: | In a partitioned database environment, the node number is automatically appended to the path. This is done to maintain the uniqueness of the path in multiple logical node configurations. |
This path does not become the value of logpath until both of the following occur:
When the first new connection is made to the database, the database manager will move the logs to this location.
Recommendation: Ideally, the log files will be on a physical disk which does not have high I/O. For instance, avoid putting the logs on the same disk as the operating system or high volume databases. This will allow for efficient logging activity with a minimum of overhead such as waiting for I/O.
You may use the database system monitor to track the number of I/O's related to database logging.
For more information see:
The preceding data elements return the amount of I/O activity related to database logging. You can use an operating system monitor tool to collect information about other disk I/O activity, then compare the two types of I/O activity.
[ Top of Page | Table of Contents | Glossary | Index ]