Configuring the transaction log location for DB2

Edit online

To increase database performance, move the DB2® transaction log to a file system that is separate from the DB2 file system.

About this task

Table 1. Recommendation for configuring transaction log location
Environment size Recommendation
Medium environments: Strongly advised
Large environments: Required
Very large environments Required

Procedure

  1. 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 License Metric Tool database: 
    UPDATE DATABASE CONFIGURATION FOR TEMADB USING NEWLOGPATH value
    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.
  2. For the changes to take effect, restart the database. Run the following commands:
    DEACTIVATE DB TEMADB
DB2STOP
DB2START
ACTIVATE DB TEMADB
  3. Restart the License Metric Tool server.
    1. To stop the server, go to the License Metric Tool installation directory, by default /opt/ibm/LMT, open cli folder and run the srvstop.sh script.
    2. To start the server, go to the License Metric Tool installation directory, by default /opt/ibm/LMT, open cli folder and run the srvstart.sh script.