On windows platform when you create a DB2 database as per following syntax, it gets created in C:\DB2\NODE0000 location where DB2 is the name of the instance.
C:\>db2 "CREATE DB TESTDB AUTOMATIC STORAGE YES ON C: USING CODESET UTF-8 TERRITORY US"
What if, you want to create a database on a mount point that was made available to you by your storage people. Say, for example you want to create DB2 database at location C:\NETDATA and this location is mounted on a SAN device.
For this, you need to set a registry variable DB2_CREATE_DB_ON_PATH=YES.
C:\>db2set DB2_CREATE_DB_ON_PATH=YES C:\>db2stop C:\>db2start C:\>db2 "CREATE DB TESTDB AUTOMATIC STORAGE YES ON C:\NETDATA USING CODESET UTF-8 TERRITORY US"