Divide the amount of data on your FULL tape volumes by the native capacity. Here's a sample SQL statement. You'll need to filter it for your tape storagepools and only FULL volumes.
select volume_name,cast(est_capacity_mb/xxxx as decimal(3,1)) from volumes Use these values for xxxx: 3590B 10240 (10GB native) 3590E 20480 (20GB native) Extended length cartriges double the value. Bill Boyer DSS, Inc. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Mahesh Tailor Sent: Friday, May 31, 2002 3:01 PM To: [EMAIL PROTECTED] Subject: Compression Hello! Is there any way to find out how much compression I am getting on a IBM 3494 library? Thanks. Mahesh