The following query lists the number of files/physical MB in the primary and
copy
storagepools.
So you can see how much files/MB still have to be copied
select stgpools.pooltype, cast(sum(occupancy.num_files) as decimal(9)) as
"FILES", -
cast(sum(occupancy.physical_mb) as decimal(13,2)) as "MB" -
from stgpools, occupancy where occupancy.stgpool_name = stgppols.stgpool_name
group by stgpools.pooltype
Example:
POOLTYPE FILES MB
------------------ ----------- ---------------
COPY 18108936 13264743.75
PRIMARY 18109346 13511321.49
HTH
Thomas Rupp
-----Ursprüngliche Nachricht-----
Von: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] Im Auftrag
von Adrian Compton
Gesendet: Montag, 21. April 2008 12:07
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: [ADSM-L] Copy Pool Status
Hi fellow TSM'ers
I have a question around the Backup of Storage pools to copy pools, done
daily.
Is there a script/mechanism to see how far the process is while it is
running.
thanks
Adrian Compton
IT Baan Operation/ Group IBM Tivoli Admin
Pharmacare Limited trading as Aspen Pharmacare
P O Box 4002
Korsten
Port Elizabeth
6014
Switchboard Tel No: +27 (0) 41 407 2111
Tel No: +27 (0) 41 407 2855
Fax: +27 (0) 41 453 7452
Cell: +27 (0) 82 320 4495
Email : acompton AT aspenpharma DOT com This email is solely for the named
addressee. Any unauthorised use or interception of this email, or the
review, retransmission, dissemination or other use of, or taking of any
action in reliance upon the contents of this email, by persons or
entities other than the intended recipient, is prohibited. If you are
not the named addressee please notify us immediately by way of a reply
e-mail, and also delete this email and any attached files.
Disclaimer: You must scan this email and any attached files for viruses
and/or any other defects. Pharmacare Limited accepts no liability for
any loss, damages or consequence, whether direct, indirect,
consequential or economic, however caused, and whether by negligence or
otherwise, which may result directly or indirectly from this
communication or of any attached files.
Vorarlberger Illwerke AG ein Unternehmen von illwerke vkw
Rechtsform: Aktiengesellschaft, Sitz: Bregenz, Firmenbuchnummer: FN 59202 m,
Firmenbuchgericht: LG Feldkirch, UID-Nr.: ATU 36737402
|