ADSM-L

DB consolidation

1997-04-02 11:53:03
Subject: DB consolidation
From: Ted Spendlove <SPENDEE AT THIOKOL DOT COM>
Date: Wed, 2 Apr 1997 09:53:03 -0700
DB consolidation

Betsy,
The process  I have use is much simpler than the DUMPDB/LOADDB commands.

1. Allocate and then DEFINE DBVOLUME for each of the new, larger volumes.  In 
effect
this will dramatically extend the size of your DB>

2. DELETE DBVOLUME for each of the old volumes.  This will cause a real-time 
move of
DB data from the old to the new volumes.

When step two is finished you can scratch the old volumes and you are done - 
with no
weekend work and no user service interruption.  Ain't ADSM great!

My reference is ADSM Administrators Guide (for MVS).  This is an amalgam of 
steps from
the Chapter on "Managing the Database and Recovery Log."  In separate sections 
it details
how to extend the DB and reduce the DB.  I just combined the two processes.

There have been much more detailed postings on this process on this list in the 
past.  You can
check the archives for more info.

Ted Spendlove
Thiokol, Corp.

>>> "Moir,Elizabeth" <Elizabeth.Moir AT VM.SSW.ABBOTT DOT COM> 04/02/97 07:47am 
>>> >>>
To: OAS     --LMS1

FROM: Betsy Moir (TTCEDM) Ext 85020
      VM Tech Services
      email:  elizabeth.moir AT vm.ssw.abbott DOT com
Subject: DumpDB and Volume Change

I hope somebody can help me with this question.  We are running Version 1 of
the ADSM server on VM.  We 10 volumes of varying sizes being used by the
ADSM database.  The storage administrator here wants to consolidate these
10 volumes into 4 much larger volumes.  In studying the documentation we
think the DUMPDB and LOADDB commands are what we should use...Dump the
database, define the new volumes, delete the old volumes and Load the
database back on.

In all my reading, however, it seems to be that in order to use the Dump
DB Load DB scenario, the volumes that the database is being loaded back
onto have to be the same size.  Is this true?  If so, does anyone have
any ideas on what we CAN do in order to achieve our ultimate goal of fewer,
larger volumes for the database.

Thanks in advance for any and all suggestions.

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