Can you Fool DB2

[John Lowe]

Hi Folks,

Our data raid (/data) got nearly full. Due to design limitation, it is
already at max, no more room to expand. We like to replace /data with
a new and bigger raid and still call it /data so we are consistently
across all servers as far as where db2 data containers are. Our syseng
have proposed building new raid /data2 along side. Use AIX diskcopy
util to clone the data from /data to /data2. ( db2 is stopped of
course ). Drop old /data, and remount /data2
as /data and all should be well. I as DBA think this might throw off
container tags, and also a more seriously problem exists, what about
the indexes, which sits on another mount (/index), they would be
pointing at old locations according to old /data. When /data is
copied, it isn't stored at same locations on /data2. I think this will
corrupt our database.

As anyone done this and come out smilling ?

Thanks in advance for your reply.
John

[Ian]

John Lowe wrote:

Hi Folks,

Our data raid (/data) got nearly full. Due to design limitation, it is
already at max, no more room to expand. We like to replace /data with
a new and bigger raid and still call it /data so we are consistently
across all servers as far as where db2 data containers are. Our syseng
have proposed building new raid /data2 along side. Use AIX diskcopy
util to clone the data from /data to /data2. ( db2 is stopped of
course ). Drop old /data, and remount /data2
as /data and all should be well. I as DBA think this might throw off
container tags, and also a more seriously problem exists, what about
the indexes, which sits on another mount (/index), they would be
pointing at old locations according to old /data. When /data is
copied, it isn't stored at same locations on /data2. I think this will
corrupt our database.

As anyone done this and come out smilling ?

This will work, as long as your admin is very careful. I'd make a
backup of your database first.

FYI you can do this online in AIX by mirroring the logical volume that
holds your /data filesystem (mirror onto second, bigger RAID array),
and then break the mirror once the copy is synchronized.

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---