Wednesday, February 29, 2012

Installing a Dell R810 Server with 12Tb Storage for a DB2 Database


Installing a Dell R810 Server with 12Tb Storage for a DB2 Database

This wasn’t a regular install as I had to create 2 partitions and 2 volume groups from scratch.

In this document we will go step by step installing the hardware and software.
1.        Hardware:
Dell R810 Server, 128Gb RAM, with 2 160Gb SAS drives on local storage
Dell MD1200 Storage array, connected to a LSI H800 Card.
First off, we connect the hardware; Power, Ethernet and the SAS cables from the H800 to the storage. 
You *could* connect only one SAS cable from the H800 to the MD1200, however for redundancy we connect two SAS cables:

 Then we need to configure RAID 50 on the MD1200, you press CTRL-R when you see the prompt:


You will then be on a screen as below:

Press Enter when the controller H800 is selected, then press F2 to get into operations to create a new disk:



 
Choose the RAID level (in our case RAID 50 with no spares) and then do a quick initialization.
We are now ready to reboot the system, after the MD1200 storage was configured, and when the system is powered up, press F12 to do  a PXE Boot, and we kickstart it with RHEL 5.6
After the OS finishes installing, we need to configure the volumes for the DB2 storage.
Since we wanted to put the storage on one volume group, and the backup on another volume group, since you can only have one volume group per partition, we will partition the array to 2 partitions:

See comments in   blue

      Start parted, by issuing the command parted (physical device – in our case /dev/sda)
[root@server-01 ~]# parted /dev/sda
Model: DELL PERC H800 (scsi)
Disk /dev/sda: 12.0TB
Sector size (logical/physical): 512B/512B
Partition Table: gpt

      Choose your partition sizes, and issue “mkpart primary start end” in this case we are making one partition of 8.5TB and another of 3TB

(parted) mkpart primary 0 8500000
(parted) mkpart primary  8500001 11500000

      Lets see the partitions by issuing a “print” command:

(parted) p
Number  Start   End     Size    File system  Name     Flags
 1      17.4kB  8500GB  8500GB               primary
 2      8500GB  11.5TB  3000GB               primary

Step 2:  create the physical storage: 
       pvcreate /dev/sda1 /dev/sda2
[root@server-01 ~]# pvcreate /dev/sda1
  Physical volume "/dev/sda1" successfully created
[root@server-01 ~]# pvcreate /dev/sda2
  Physical volume "/dev/sda2" successfully created

Step 3:  initialize the /etc/lvmtab and /etc/lvmtab.d files by running the following command:
  vgscan
[root@server-01 ~]# vgscan
  Reading all physical volumes.  This may take a while...
  Found volume group "vg04" using metadata type lvm2
  Found volume group "vg01" using metadata type lvm2

Step 3.1: create a volume group and assign one or more physical volumes to the volume group:
vgcreate -s (extent size)M (volume-group) (physical partition)
[root@server-01 ~]# vgcreate -s 256M vg01 /dev/sda1
  Volume group "vg01" successfully created
[root@server-01 ~]# vgcreate -s 256M vg04 /dev/sda2
  Volume group "vg04" successfully created

Step 4: creation of "logical volumes"
  lvcreate -L (size)G -n (name) (volume group)
# lvcreate -L 200G -n lvol3 vg01
# lvcreate -L 300G -n lvol2 vg01
# lvcreate -L 7TB -n lvol1 vg01
# lvcreate -L 2.7TB -n lvol4 vg04

Step 5: creation of the filesystem:
  mke2fs -j (volume)
mke2fs -j /dev/vg01/lvol4
mke2fs -j /dev/vg01/lvol1
mke2fs -j /dev/vg01/lvol2
mke2fs -j /dev/vg01/lvol3
mke2fs -j /dev/vg04/lvol4

Step 6: create mount points:
mkdir /db2backup /db2onlinelog2 /data2 /db2dump2  /db2log2

step 7: Mount logical volumes on mount points:
  mount (volume) (mountpoint)
mount /dev/vg01/lvol1 /data2
mount /dev/vg01/lvol3 /db2onlinelog2
mount /dev/vg01/lvol4 /db2dump2
mount /dev/vg04/lvol4 /db2backup
mount /dev/vg01/lvol2 /db2log2 

Step 8: Add corresponding line in the /etc/fstab file:
/dev/vg01/lvol1         /data2                  ext3    defaults        0 0
/dev/vg01/lvol2         /db2log2                ext3    defaults        0 0
/dev/vg01/lvol3         /db2onlinelog2          ext3    defaults        0 0
/dev/vg01/lvol4         /db2dump2               ext3    defaults        0 0
/dev/vg04/lvol4         /db2backup              ext3    defaults        0 0
10.2.6.20:/vol/database/              /mnt/rrr_bk nfs defaults 0 0





 

No comments:

Post a Comment