ADSM-L

Re: Shrink ITSM-DB

2005-01-06 03:53:59
Subject: Re: Shrink ITSM-DB
From: John Naylor <John.Naylor AT SCOTTISH-SOUTHERN.CO DOT UK>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 6 Jan 2005 08:53:39 +0000
Hans Dieter wrote

> >Hey out there,
> >is there any other possibility than unloading the TSM-DB to "shrink"
> >the dbvol?

# query db

Available Assigned   Maximum   Maximum    Page     Total      Used   Pct
Max.
    Space Capacity Extension Reduction    Size    Usable     Pages  Util
Pct
     (MB)     (MB)      (MB)      (MB) (bytes)     Pages Util
--------- -------- --------- --------- ------- --------- --------- -----
-----
    7.900    4.100     3.800       292   4.096 1.049.600   973.857  92,8
92,8

My advice is do not worry about shrinking your DB.
It is small in TSM terms, and you would gain no real lasting benefit.
Instead to get your PCT Util down to a more comfortable level extend your
DB.
You have 3800 MB.

John




**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy Group.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission. Unless specifically stated otherwise, this email (or 
any attachments to it) is not an offer capable of acceptance or acceptance of 
an offer and it does not form part of a binding contractual agreement.


Scottish Hydro-Electric, Southern Electric, SWALEC and S+S
are trading names of the Scottish and Southern Energy Group.
**********************************************************************

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