ADSM-L

[ADSM-L] R: [ADSM-L] Finding out how much active api data exists on a server

2011-07-26 10:57:13
Subject: [ADSM-L] R: [ADSM-L] Finding out how much active api data exists on a server
From: Carlo Zanelli <Carlo.Zanelli AT REGIONE.VENETO DOT IT>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 26 Jul 2011 16:48:22 +0200
Hi Gary,

this select shows you occupancy and number of the active files node by node:

select node_name, sum(logical_mb) as Data_In_MB, sum(num_files) as Num_of_files 
from occupancy group by node_name order by Data_In_MB

Regards,

Carlo. 

-----Messaggio originale-----
Da: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] Per conto di 
Lee, Gary D.
Inviato: martedì 26 luglio 2011 16.44
A: ADSM-L AT VM.MARIST DOT EDU
Oggetto: [ADSM-L] Finding out how much active api data exists on a server

Tsm server 6.2.2 running on redhat enterprize 6.

When doing a q filespace I note that all tdp for sqlserver, and tdp for 
exchange filespaces have capacity 0 and data 0.


What is the most effective way to get some semblance of active data stored out 
of this server?

Export server  preview=yes takes far too long.
Last time, 36 hours.
Any help appreciated.


Gary Lee
Senior System Programmer
Ball State University
phone: 765-285-1310

 

-----   
Ai sensi del D.Lgs. 196/2003 si precisa che le informazioni contenute nel 
messaggio e negli eventuali allegati sono riservate al/ai destinatario/i 
indicato/i. Nel caso di erroneo recapito, si chiede cortesemente a chi legge di 
dare immediata comunicazione al mittente e di cancellare il presente messaggio 
e gli eventuali allegati. Si invita ad astenersi dall'effettuare: inoltri, 
copie, distribuzioni e divulgazioni non autorizzate del presente messaggio e 
degli eventuali allegati.

----------   
According to Italian law (D.Lgs 196/2003) information contained in this message 
and any attachment contained therein is addressed exclusively to the intended 
recipient. If you have received this message in error would you please inform 
immediately the sender and delete the message and its attachments. You are also 
requested not to make copies, nor to forward the message and its attachments or 
disclose their content unless authorised. 


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