Symantec logo

Creating the file system for the DB2 non-MPP instances

To create a file system, first create a disk group on the physically shared disk, and create a volume of sufficient size within the disk group.

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

  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 three 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:

    # mkdir /db2_mnt/db2inst1

		# mount -V vxfs /dev/vx/dsk/db2db_dg/db2db_vol \

		  /db2_mnt/ db2inst1
 

 To create a file system on Linux systems for non-MPP instances

  1. Create a disk group on the shared disk. List the disks using the vxdisk list command. In this case the group consists of one disk, sdc. For example:

    # vxdg init db2db_dg /dev/sdc

    Deport and import the disk group:

    # vxdg deport db2db_dg

    # vxdg import db2db_dg

  2. Create a volume of three GB using the vxassist command:

    # vxassist -g db2db_dg make db2db_vol 3g

  3. Create the file system:

    # mkfs -t vxfs /dev/vx/dsk/db2db_dg/db2db_vol

  4. Create the mount point directory and mount the file system:

    # mkdir /db2_mnt/db2inst1

    # mount -t vxfs /dev/vx/dsk/db2db_dg/db2db_vol \

      /db2_mnt/db2inst1

  5. Create the mount point directory and mount the file system:

    # mkdir /db2_mnt/db2inst1

    # mount -t vxfs /dev/vx/dsk/db2db_dg/db2db_vol \

      /db2_mnt/db2inst1

 To create a file system on Solaris systems for non-MPP instances

  1. Create a disk group on the shared disk. List the disks using the vxdisk list command. In this case the group consists of one disk, c4t0d0s2. For example:

    # vxdg init db2db_dg c4t0d0s2

    Deport and import the disk group:

    # vxdg deport db2db_dg

    # vxdg import db2db_dg

  2. Create a volume of three GB using the vxassist command:

    # vxassist -g db2db_dg make db2db_vol 3g

  3. Create the file system:

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

  4. Create the mount point directory and mount the file system:

    # mkdir /db2_mnt/db2inst1

    # mount -F vxfs /dev/vx/dsk/db2db_dg/db2db_vol

    /db2_mnt/db2inst1

  5. Create the mount point directory and mount the file system:

    # mkdir /db2_mnt/db2inst1

		# mount -V vxfs /dev/vx/dsk/db2db_dg/db2db_vol \

		  /db2_mnt/db2inst1