You are trying to create a new database in a different path like C:\Dylan in DB2 LUW 9.7. However, you receive an SQL error SQL1052N. How can I create in a new database path I want?
You will have to change one of the db2 registry and environment variables to YES. The variable for that is DB2_CREATE_DB_ON_PATH
1. First, stop you database. Run the following command.-
2. Next, change the DB2_CREATE_DB_ON_PATH using the following command.
3. Start you db2 again using the command below
In addition, you can also use the variable DB2_CREATE_DB_ON_CHANGE to replace DB2_CREATE_DB_ON_PATH from step 2. However, in the information center for DB2 LUW 9.7, you can only find the variable DB2_CREATE_DB_ON_PATH. You can refer to the link below and look for DB2_CREATE_DB_ON_PATH for more information on this.