< Previous  | TOC | Index | Next  >

Creating the shared cluster file system for the DB2 MPP instances

To create a shared file system, first create a shared disk group on the physically shared disk and create a volume of sufficient size within the disk group. You must have installed the Storage Foundation Cluster File System software.

 To create a shared file system on AIX for MPP instances

1. You must issue the commands to create a shared disk group from the CVM master node. To determine whether a node is the master or the slave, enter the command:

   # vxdctl -c mode

   In the output, look for:

   cluster active - MASTER

   Or

   cluster active - SLAVE

2. From the master node, create the disk group. List the disks using the vxdisk list command.
3. Create a shared disk group. In this case, the group consists of one disk. In this example the disk is hdisk5:

   # vxdg -s init db2db_dg hdisk5

4. Deport and import the disk group:

   # vxdg deport db2db_dg

   # vxdg -s import db2db_dg

5. Use the vxassist command to create a seven GB volume:

   # vxassist -g db2db_dg make db2db_vol 7g

6. Create the file system:

   # mkfs -V vxfs -o largefiles /dev/vx/rdsk/db2db_dg/db2db_vol

7. Create the mount point directory and mount the file system.

   # mkdir /db2_mnt/db2inst1

   # mount -V vxfs -o cluster /dev/vx/dsk/db2db_dg/dbq2db_vol \

     /db2_mnt/db2inst1

 To create a shared file system on Linux for MPP instances

1. You must issue the commands to create a shared disk group from the CVM master node. To determine whether a node is the master or the slave, enter the command:

   # vxdctl -c mode

   In the output, look for:

   cluster active - MASTER

   Or

   cluster active - SLAVE

2. From the master node, create the disk group. List the disks using the vxdisk list command.
3. Create a shared disk group. In this case, the group consists of one disk. In this example the disk is sdc:

   # vxdg -s init db2db_dg hdisk5

4. Deport and import the disk group:

   # vxdg deport db2db_dg

   # vxdg -s import db2db_dg

5. Use the vxassist command to create a seven GB volume:

   # vxassist -g db2db_dg make db2db_vol 7g

6. Create the file system:

   # mkfs -t vxfs -o largefiles /dev/vx/rdsk/db2db_dg/db2db_vol

7. Create the mount point directory and mount the file system.

   # mkdir /db2_mnt/db2inst1

   # mount -t vxfs -o cluster /dev/vx/dsk/db2db_dg/dbq2db_vol \

     /db2_mnt/db2inst1

 To create a shared file system on Solaris for MPP instances

1. You must issue the commands to create a shared disk group from the CVM master node. To determine whether a node is the master or the slave, enter the command:

   # vxdctl -c mode

   In the output, look for:

   cluster active - MASTER

   Or

   cluster active - SLAVE

2. From the master node, create the disk group. List the disks using the vxdisk list command.
3. Create a shared disk group. In this case, the group consists of one disk. In this example the disk is c5t0d0s2:

   # vxdg -s init db2db_dg c5t0d0s2

4. Deport and import the disk group:

   # vxdg deport db2db_dg

   # vxdg -s import db2db_dg

5. Use the vxassist command to create a seven GB volume:

   # vxassist -g db2db_dg make db2db_vol 7g

6. Create the file system:

   # mkfs -F vxfs -o largefiles /dev/vx/rdsk/db2db_dg/db2db_vol

7. Create the mount point directory and mount the file system.

   mkdir /db2_mnt/db2inst1

   mount -F vxfs -o cluster /dev/vx/dsk/db2db_dg/db2db_vol \

   /db2_mnt/db2inst1