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
-
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
-
Create a volume of three GB using the vxassist command:
# vxassist -g db2db_dg make db2db_vol 3g
-
Create the file system:
# mkfs -V vxfs -o largefiles /dev/vx/dsk/db2db_dg/db2db_vol
-
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
-
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
-
Create a volume of three GB using the vxassist command:
# vxassist -g db2db_dg make db2db_vol 3g
-
Create the file system:
# mkfs -t vxfs /dev/vx/dsk/db2db_dg/db2db_vol
-
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
-
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
-
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
-
Create a volume of three GB using the vxassist command:
# vxassist -g db2db_dg make db2db_vol 3g
-
Create the file system:
# mkfs -F vxfs /dev/vx/rdsk/db2db_dg/db2db_vol
-
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
-
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