Configuring the transaction log location for DB2
To increase database performance, move the DB2® transaction log to a file system that is separate from the DB2® file system.
About this task
Medium environments: | Strongly advised |
Large environments: | Required |
Very large environments | Required |
Procedure
- To move the DB2® transaction
log to a file system that is separate from the DB2® file system, update the DB2® NEWLOGPATH parameter
for your BigFix Inventory database:
Where value is a directory on a separate disk (different from the disk where the DB2® database is installed) where you want to keep the transaction logs. This configuration is strongly advised.UPDATE DATABASE CONFIGURATION FOR TEMADB USING NEWLOGPATH value
- For the changes to take effect, restart the database. Run
the following commands:
DEACTIVATE DB TEMADB DB2STOP DB2START ACTIVATE DB TEMADB
- Restart the BigFix Inventory server.