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
select sum(backup_mb/1024) as All Primary Data -
GB,sum(backup_copy_mb/1024) as All Copy Data - GB from auditocc
you could include archive data also if needed
Regards,
Jim Bollard.
Technical Consultant.
Unitech Systems Ltd.
Mobile: +353 86 353 2761
Office: +353 1 2942300
Office Direct: +353 1
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
select node_name,backup_mb,backup_copy_mb,archive_copy_mb from auditocc
Is what you need, this tells you each clients data in MB.
Regards,
Jim Bollard.
Technical Consultant.
Unitech Systems Ltd.
Mobile: +353 86 353 2761
Office: +353 1 2942300
Office Direct: +353 1 2999356
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
Backup_Copy is your pri tape pool(onsite copy), backup_copy_mb (offsite
copy) is your copypool data.
Sum will total all data in these pools, handy for making sure your stg
pools are in sync for DR as your pri will be destroyed.
You could add that SQL statement I gave you to you TSM servers