Creating the database in a GDPC environment

In a geographically dispersed DB2® pureScale® cluster (GDPC) environment, create a database table with the datafs file system, with database logs stored in the logfs file system.

1. Create the database.
2. As root, change the permissions on the file systems to allow the instance user to write to them:

   root@hostA1:/> mkdir /logfs/db2inst1
   root@hostA1:/> chown db2inst1 /logfs/db2inst1
   root@hostA1:/> mkdir /datafs/db2inst1
   root@hostA1:/> chown db2inst1 /datafs/db2inst1
   
   db2inst1@hostA1:/home/db2inst1> db2start
   02/25/2011 04:00:44 0 0 SQL1063N DB2START processing was successful.
   02/25/2011 04:00:46 3 0 SQL1063N DB2START processing was successful.
   02/25/2011 04:00:47 2 0 SQL1063N DB2START processing was successful.
   02/25/2011 04:00:47 1 0 SQL1063N DB2START processing was successful.
   SQL1063N DB2START processing was successful.
   
   db2inst1@hostA1:/home/db2inst1> db2 create database MYDB on /datafs/db2inst1 dbpath
   on /logfs/db2inst1
   
   DB20000I The CREATE DATABASE command completed successfully.