Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*\[ADSM\-L\]\s+yasq\s+$yet\s+another\s+SQL\s+question$\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*\[ADSM\-L\]\s+yasq\s+$yet\s+another\s+SQL\s+question$\s*$/: 8 ]

Total 8 documents matching your query.

1. [ADSM-L] yasq (yet another SQL question) (score: 1): 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; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2008-06/msg00008.html (13,362 bytes)
2. Re: [ADSM-L] yasq (yet another SQL question) (score: 1): 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; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2008-06/msg00009.html (13,702 bytes)
3. Re: [ADSM-L] yasq (yet another SQL question) (score: 1): 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; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2008-06/msg00011.html (15,930 bytes)
4. Re: [ADSM-L] yasq (yet another SQL question) (score: 1): 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; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2008-06/msg00013.html (17,842 bytes)
5. Re: [ADSM-L] yasq (yet another SQL question) (score: 1): 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; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2008-06/msg00014.html (12,057 bytes)
6. Re: [ADSM-L] yasq (yet another SQL question) (score: 1): 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,; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2008-06/msg00017.html (16,645 bytes)
7. Re: [ADSM-L] yasq (yet another SQL question) (score: 1): Author: "Allen S. Rout" <asr AT UFL DOT EDU>; Date: Tue, 3 Jun 2008 10:38:54 -0400; 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; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2008-06/msg00024.html (11,695 bytes)
8. Re: [ADSM-L] yasq (yet another SQL question) (score: 1): 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; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2008-06/msg00026.html (14,789 bytes)

Current List: 1 - 8
Page: [1]