First of all thanks for the help ...this is good learning for me.I ran the following select commands
>select node_name,sum(num_files),sum(physical_mb) from occupancy group by >node_name NODE_NAME Unnamed[2] Unnamed[3] ------------------ ----------- --------------------------------- DATACAP 25528196 353004.93 >select node_name,backup_mb,backup_copy_mb,archive_copy_mb from auditocc NODE_NAME BACKUP_MB BACKUP_COPY_MB ARCHIVE_COPY_MB ------------------ ----------- -------------- --------------- DATACAP 87774 260633 0 Question: Does backup _copy_mb from audittocc is the summ of all copy pools( copy LTO & DR pools) or just the primary copy pool. First we use disk then copy it to LTO tape pool and then we copy from LTO tape pool to three DR pools which are in rotation for DR offsite. Looks like occupanct group is the TOTAL sum of all LTO pools correct ? Thanks, AShok Vats -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Bos, Karel Sent: Wednesday, May 03, 2006 8:56 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TASM 5.3.0.0 on AIX 5.3.0.0 quick question Hi, 'select node_name,sum(num_files),sum(physical_mb) from occupancy group by node_name' Regards, Karel -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Vats.Ashok Sent: woensdag 3 mei 2006 17:48 To: ADSM-L@VM.MARIST.EDU Subject: TASM 5.3.0.0 on AIX 5.3.0.0 quick question Hi All, We need to find how much storage is being used by each TSM client. I get reports which indicate how much data is being backed up by each tsm client but I am not able to find how much data is being stored for each client. Is there any query or select statement I can use to get the info from TSM ? Thanks, Ashok
