ADSM-L

Re: [ADSM-L] select statement

2008-08-29 01:09:28
Subject: Re: [ADSM-L] select statement
From: "Patel, Ankur" <Ankur.Patel AT AU.HARVEYNORMAN DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 29 Aug 2008 15:09:01 +1000
Avy,

I tried your query on my machine and it has worked fine.
See results:

~~~~~~~~~~~~~~~~~~
 AUCFTSM01_PROD>select vu.node_name, ao.total_mb, count(distinct
vu.volume_name) as tapes, ao.total_mb/count(distinct vu.
volume_name) as "AVG MB/tape" from volumeusage vu, auditocc ao where
vu.node_name=ao.node_name group by v                    u.node_name,
ao.total_mb order by 4

Session established with server AUCFTSM01_PROD: AIX-RS/6000
  Server Version 5, Release 4, Level 3.0
  Server date/time: 08/29/08   15:00:01  Last access: 08/29/08
12:46:42

ANR2963W This SQL query may produce a very large result table, or may
require a significant amount of time to compute.

Do you wish to proceed? (Yes (Y)/No (N)) y

NODE_NAME                 TOTAL_MB           TAPES     AVG MB/tape
------------------     -----------     -----------     -----------
FLEMTMH2_FS                 531344             154            3450
FLEMXPS3_FS                1122421             166            6761
FLEMTDM2_FS                 764482              50           15289
FLEMXPS2_FS                2865024             172           16657
AUCFTDWH01_FS              4078174             186           21925
AUCFSAV01_FS               3604114             163           22111
AUDCCFOMX006_EXCH            70208               3           23402
FLEMXPS0_FS                7529458             213           35349
AUCFVSQ1_FS                7168357             159           45084
AUCFNIM01_FS              14523030             190           76437
AUCFDW01_FS               48314333             233          207357
.
.
.
.
.
~~~~~~~~~~~~~~~~~~~~~~~~


 

Regards,

 

Ankur Patel

TSM Administrator.
SYDNEY.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Avy Wong
Sent: Friday, 29 August 2008 5:36 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] select statement

Hello,
      The following is a select statement to provide "a total data
stored and tapes used per node in all storage pools".
I have broken down the sql and double checked the tables and column
names are all there. Can anyone see where the hangs ups are?

select vu.node_name, ao.total_mb, count(distinct vu.volume_name) as
tapes, ao.total_mb/count(distinct vu.volume_name) as "AVG MB/tape" from
volumeusage vu, auditocc ao where vu.node_name=ao.node_name group by
vu.node_name, ao.total_mb order by 4

ANR2956E Unable to access SQL base table 'VOLUMEUSAGE'.

                                   |
         ..........................V....................................
         me) as "AVG MB/tape" from volumeusage vu, auditocc ao where vu.

ANS8001I Return code 26.

thanks,
Avy Wong
Business Continuity Administrator
Mohegan Sun
1 Mohegan Sun Blvd
Uncasville, CT 06382
(860)862-8164
(cell) (860)961-6976
************************************************************************************************
DISCLAIMER

Confidential Communication: This email and any attachments are intended for the 
addressee(s)
only and are confidential. They may contain legally privileged or copyright 
material. If you
are not the intended recipient, please contact the sender immediately by reply 
email and 
delete this email and any attachments. You must not read, copy, use, distribute 
or disclose 
the contents of this email without consent and Harvey Norman Holdings Limited 
ACN 003 237 545
(and its related subsidiaries) (?Harvey Norman?) does not accept responsibility 
for any
unauthorised use or reliance on the contents of this email.

Harvey Norman does not represent or warrant that the integrity of this email 
has been maintained
or that it is free from errors, viruses, interceptions or interference. Any 
views expressed by
the sender do not necessarily represent the views of Harvey Norman.

This notice should not be removed from this email.
************************************************************************************************

<Prev in Thread] Current Thread [Next in Thread>