IBM Support

Change DB2 database file storage location path for installation of i2 Analyze and Enterprise Insight Analysis

How To


Summary

How do I change the DB2 database file storage location path to D drive from the default C drive for an existing installation of i2 Analyze and Enterprise Insight Analysis?

Objective

Installation would like to change to use a D drive that has a large disk space rather than the default C drive location.  Objective is to keep the DB2 program installation files on C drive, and the database storage files on D.

Steps

Perform the following steps:
- Drop the database. (you lose all data)
setup -t dropDatabases
- Change C:\IBM\i2analyze\toolkit\configuration\environment\onyx-server\environment.properties file to use D drive. 
# The root path of the database file storage. 
db.database.location.dir=D:
- Check the topology.xml file to make sure and create the database.
<data-source database-id="write1" create-database="true"/> 
- Run deploy.
setup -t deploy
Check the D drive to see that a new DB2 folder was created with D:\DB2\NODE0000

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSXVTH","label":"i2 Analyze"},"Component":"","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

Modified date:
30 January 2020

UID

ibm11165996