[log in to unmask] (Nils-Olov Fransson) wrote:
>Susan Lui <[log in to unmask]> wrote:
>>I have ASK image database that needs to re-size (change capacity) once it
>>reached to 80% full. I usually view the SYUT979, then run Adager, parm = 8
>>to create a stream job. But I wonder if there is a way to automate the
>>process, the system will wake up and knows the data sets reached to 80% and
>>automatically create a Adager job to run at night?
>>Any idea?
>>//Susan
>As far as I know there is no easy way to do this, and I think this is
>the only weakness in Adager. DB-general on the other hand have this
>feature built in. You define the max and min limits and how much you
>want to increase or decrease each dataset, and store this information
>in DB-generals database. Then you can run DB-general as a batch job on
>a regular base and it will check the caoacities against the stored
>limits and fix the capacities as needed.
>I have worked with it and I know companies using it successfully.
Sorry to contradict you but as far as I remember there is a way:
If you own Vesoft's MPEX, there is a command you can use to say for
example "If dataset capacity reaches 80%, put that back to 60%).
Vesoft is then using Adager to do it...
Here is a part of MPEX documentation:
-------------------------------------------
%DBADGALT
Syntax: %DBADGALT dbfileset, ratio
Examples: %DBADGALT @.DB, .50
%DBADGALT @.DB (DBSETFULLNESS>.8 and MODDATE>TODAY-30), 0.6
The %DBADGALT command uses ADAGER to change the capacity of IMAGE
datasets so that they are a given percentage full (this command will
only work if you own ADAGER, the "Adapter/Manager for IMAGE
Databases", a product of Adager).
For instance,
%DBADGALT @.DB (DBSETFULLNESS>.8), 0.6
increases the capacity of all databases in the DB group that are
currently greater than 80% full so that they are only 60% full.
------------------------------------------
Hope it helps...
Denis St-Amand ([log in to unmask] / [log in to unmask] )
=========================================================================
"Racing, competing, is in my blood, it's part of me, part of my life"
Ayrton Senna (1960-1994)
=========================================================================
|