Creating the file systems for non-MPP instances for DB2

To create a file system for non-MPP instances, you first create a disk group on the physically shared disk. You then create a volume of sufficient size within the disk group.

To create a file system for non-MPP instances on AIX

  1. Create a disk group on the shared disk. List the disks using the lsdev -Cc disk command. In this case the group consists of one disk, hdisk5. For example:
    # vxdg init db2db_dg hdisk5

    Deport and import the disk group:

    # vxdg deport db2db_dg
    # vxdg import db2db_dg
  2. Create a volume of 3 GB using the vxassist command:
    # vxassist -g db2db_dg make db2db_vol 3g
  3. Create the file system:
    # mkfs -V vxfs -o largefiles /dev/vx/dsk/db2db_dg/db2db_vol
  4. Create the mount point directory and mount the file system. Make sure that the mount point exists on all nodes in the cluster on the local file system - not on shared storage.
    # mkdir /db2_mnt/db2inst1
    # mount -V vxfs /dev/vx/dsk/db2db_dg/db2db_vol \
      /db2_mnt/db2inst1