Author: Richard Rhodes <rrhodes AT FIRSTENERGYCORP DOT COM>
Date: Mon, 2 Jun 2008 14:08:34 -0400
I'm trying to get a handle around the compression ratio on our 3494 tapes. I'm trying to generate a table showing each compression ratio and the number of volumes of that ratio. All the tapes in the
Author: Anil Maurya <Anil.Maurya AT SANOFI-AVENTIS DOT COM>
Date: Mon, 2 Jun 2008 14:24:03 -0400
Try without distinct Goodl luck I'm trying to get a handle around the compression ratio on our 3494 tapes. I'm trying to generate a table showing each compression ratio and the number of volumes of t
Author: Andrew Raibeck <storman AT US.IBM DOT COM>
Date: Mon, 2 Jun 2008 11:42:31 -0700
The problem is that unless est_capacity_mb matches exactly between multiple volumes, the results of the "from" will return a single record from the VOLUMES table consisting of the est_capacity_mb fie
Author: Andrew Raibeck <storman AT US.IBM DOT COM>
Date: Mon, 2 Jun 2008 11:51:30 -0700
Clarification: The first (long) sentence of my earlier response(below) should read: est_capacity_mb field and the Andy Raibeck IBM Software Group Tivoli Storage Manager Client Product Development Lev
Author: Richard Rhodes <rrhodes AT FIRSTENERGYCORP DOT COM>
Date: Mon, 2 Jun 2008 14:58:06 -0400
That's what I was beginning to think, and where I'll head. Thanks! Rick -- The information contained in this message is intended only for the personal and confidential use of the recipient(s) named
Author: Anil Maurya <Anil.Maurya AT SANOFI-AVENTIS DOT COM>
Date: Mon, 2 Jun 2008 15:21:43 -0400
Try following ( group by volume_name ) too. Since i don't have two volume same capacity so can't check. Let me know what worked with you. select distinct cast((est_capacity_mb/600/100) as decimal(10,
Permit me to recommend 'sqlite'. Free, easy, straightforward, lightweight. It's my favorite storage place for the columns IBM left out of TSM tables. - Allen S. Rout
Author: Richard Rhodes <rrhodes AT FIRSTENERGYCORP DOT COM>
Date: Tue, 3 Jun 2008 13:36:22 -0400
I got my numbers via a sql cmd and a ksh script. It was kind of fun. I've been looking at sqllite. Do you know of any place to get precompiled binaries for AIX? Thanks Rick (my hack to get a guestima