Where can i get a listing of the database catagories and the description of
what's in each one so that i can create my own queries?

Thanks,
Mooney
Siemens WestingHouse
(407) 249-7606




From: Joerg Pohlmann <jpohlman AT CA.IBM DOT COM> on 12/21/99 13:54

To:   ADSM-L AT VM.MARIST DOT EDU@SMTP@Exchange
cc:

Subject:  Re: SHOW VOLUMEUSAGE <node>

There are many ways of getting volume information for a node based on
storage pool. For example, I use the following command to see on which
volumes in  on-site storage pools a node resides (b.t.w. I defined a script
to do this so that parameter $1 is the node name):

select distinct volume_name from volumeusage where node_name= UPPER('$1')
and stgpool_name<>'COPYPOOL'

Regards,

Joerg Pohlmann
(604) 535-0452


Nathan King <nathan.king AT USAA DOT COM> on 99 12 21 10:35:19

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

To:   ADSM-L AT VM.MARIST DOT EDU
cc:
Subject:  Re: SHOW VOLUMEUSAGE <node>




That's what the SQL Query was designed to do... I use it to generate a
report for chargeback.
If you want to see the volume numbers then just alter the query.

select distinct volume_name,node_name from volumeusage

should work



        -----Original Message-----
        From:   Michael Dummitt [SMTP:Michael.Dummitt AT ROSSNUTRITION DOT COM]
        Sent:   Tuesday, December 21, 1999 12:25 PM
        To:     ADSM-L AT VM.MARIST DOT EDU
        Subject:        Re: SHOW VOLUMEUSAGE <node>

        Well I tried this command and I recvd the below output. I still do
not know
        which volumes....it just tellsme how many. Any more hints? The
would
be
        appreciated.

        adsm> select node_name as aixs70a,count(distinct volume_name) as
"Number of tap
              es used" from volumeusage group by node_name
        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/No) y
        AIXS70A                Number of tapes used
        ------------------     --------------------
        ADSMRS                                   58
        AF_REMOTE                                 2
        AIX01                                    94
        AIX02                                    56
        AIX03                                    95
        AIX07                                    75
        AIX08                                    51
        AIX0A                                    41