ADSM-L

Re: Moving the database..

2002-11-04 04:48:52
Subject: Re: Moving the database..
From: David le Blanc <David.leBlanc AT IDENTITY-SOLUTIONS.COM DOT AU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 4 Nov 2002 20:33:14 +1100
Ricky,

All you need to do is create a (or a additional) mirror of the database
at the new location, and go and have a cup of coffee or two. (what is it,
about 1 cup per 10 gig database?? If you have more than two cups, your
database is too big, or your server too slow)

Once complete,  delete the mirror copy you no longer want.

DO NOT TRY TO MOVE THE DATABASE FROM OUTSITE OF TSM.  I've had
customers do this and utterly scramble the database trying to make
it work.  They are still in counselling.

You could always 'dsmserv unload' , delete all your DB and log files,
'dsmserv loadformat' all the new DB and LOG files in all the new locations,
then 'dsmserv load'.   Use 'dsm backup' and 'dsmserv restore' if time is
critical.   DSM unload/load also defrags the database, and guarantees
the final result passes all audit checks.


Regards,
David le Blanc

--
Technical Specialist                    Enterprise IT Systems &
                                        Data Storage Technologies
I d e n t i t y - S o l u t i o n s

Level 7  505 St Kilda Road Melbourne Vic 3004
Ph 03 9868 1661 Fax 03 9820 0777 Mobile 0417 595 550
Email david.leblanc AT identity-solutions.com DOT au



Quoting "Cahill, Ricky" <Ricky.Cahill AT EQUITAS.CO DOT UK>:

> I have a need to move the log files and database as currently they are on a
> raid 5 set shareing this with the diskpools.
>
> I'd like to move the database and log files onto seperate mirrored pairs to
> increase the performance and better use the disk space we have.
>
> I've hunted around in the manuals and cannot find how i can do this.
>
> Can anyone point me in the right direction please??
>
> Thanks in advance.
>
>         ........Rikk
>
>
>
********************************************************************************
********************
> Equitas Limited, 33 St Mary Axe, London EC3A 8LL, UK
> NOTICE: This message is intended only for use by the named addressee
> and may contain privileged and/or confidential information.  If you are
> not the named addressee you should not disseminate, copy or take any
> action in reliance on it.  If you have received this message in error
> please notify postmaster AT equitas.co DOT uk and delete the message and any
> attachments accompanying it immediately.
>
> Equitas reserve the right to monitor and/or record emails, (including the
> contents thereof) sent and received via its network for any lawful business
> purpose to the extent permitted by applicable law
>
> Registered in England: Registered no. 3173352 Registered address above
>
********************************************************************************
********************
>


--


-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/

<Prev in Thread] Current Thread [Next in Thread>