Need to add addition Hard Disk in production system

[Former Member]

Hi All,

Our Production system hard drive is going to be full and  we need to add additional hard drive for further use.

We are using Windows server 2008 and DB is DB2 9.7 with fix pack 5.

Could you  please suggest us  what are activity we need to perform so that all the Data and log file will be on consistence state and DB will write the next data in new hard drive.

Regards,

Pradeep

[sunny_pahuja2 · Accepted solution]

Hi,

You should create new drive from the hard disk and move some of your datafile to new drive. You can use db2relocatedb tool to move the datafiles. Please check below link:

http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.admin.cmd.doc/...

Thanks

Sunny

[Former Member]

Hi ,

Take a backup of the DB before the activity, if possible a File system backup also. Add the disk and create the new datafiles in the newly added drives.Since this is a production Drives should be in Raid and will not be problem in doing so.

Regards

Mukunthan

[Former Member]

Hi Mukunthan,

what we are thinking is we will take the full backup of system at OS level  and then we will add an addition hard disk to server and we will change the drive name  to previous drive letter and  we will copy all previous data file to newly created drive.

Please suggest me it will work or not.

Regards,

Pradeep

[Former Member]

Dear Mr. Pradeep,

Possiablity of success with above method is quiet less. There is chance of data corruption & consistancy.

Adding new hard disk is dependent upon the existing Hardware configuration. In case RAID-5 configuration is already available then you can directly go ahed to add or replace the perticula hard drive.

In case there is no RAID configuration, then my suggestion is to have a Homogeneious System Copy.

Kind rgds,

Ashwin Mane

[Former Member]

Hi,

Yes, your way will work. If you'r server has internal HDD only and if it has the additional bay to accomodate the new HDD you please fill the bays and use it.

Regards

Mukunthan