ADSM-L

Re: Online DB Reorg

2003-10-21 07:30:38
Subject: Re: Online DB Reorg
From: Andy Carlson <andyc AT ANDYC.CARENET DOT ORG>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 20 Oct 2003 16:05:19 -0500
I did this for a subset of our clients, mainly the Unix clients, because
they were more copperative than the Intel clients.


Andy Carlson                                    |\      _,,,---,,_
Senior Technical Specialist               ZZZzz /,`.-'`'    -.  ;-;;,_
BJC Health Care                                |,4-  ) )-,_. ,\ (  `'-'
St. Louis, Missouri                           '---''(_/--'  `-'\_)
Cat Pics: http://andyc.dyndns.org/animal.html


On Sat, 18 Oct 2003, Talafous, John G. wrote:

> I too will some day in the future need to reorg a TSM database. I am
> currently working to split our 122GB database into two TSM instances. I will
> be doing the same as Andy!!!
>
> Andy,
>   Do I understand correctly that you simply pointed clients to the new
> server and did a full backup and some time later deleted the old node from
> the old server?
>
> Remco,
>   Would you be willing to share your SQL query that reports on DB
> fragmentation?
>
> Thanks to all,
> John G. Talafous              IS Technical Principal
> The Timken Company            Global Software Support
> P.O. Box 6927                 Data Management
> 1835 Dueber Ave. S.W.         Phone: (330)-471-3390
> Canton, Ohio USA  44706-0927  Fax  : (330)-471-4034
> talafous AT timken DOT com           http://www.timken.com
>

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