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:[EMAIL PROTECTED] Im Auftrag von Adrian Compton Gesendet: Montag, 21. April 2008 12:07 An: [email protected] 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 : [EMAIL PROTECTED] 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
