Re: yasq (yet another sql question . . . . )

Well, if you connected to TSM via ACCESS, it would look like this:

SELECT DISTINCTROW OCCUPANCY.STGPOOL_NAME, Sum(OCCUPANCY.NUM_FILES) AS
[Sum Of NUM_FILES], Sum(OCCUPANCY.PHYSICAL_MB) AS [Sum Of PHYSICAL_MB],
Sum(OCCUPANCY.LOGICAL_MB) AS [Sum Of LOGICAL_MB], Count(*) AS [Count Of
OCCUPANCY] FROM OCCUPANCY GROUP BY OCCUPANCY.STGPOOL_NAME;

STGPOOL_NAME    Sum Of NUM_FILES        Sum Of PHYSICAL_MB      Sum Of
LOGICAL_MB      Count Of OCCUPANCY
AIXARCHGRP      2624247         401520.25       
401520.25                                                  7

>>> rrhodes AT FIRSTENERGYCORP DOT COM 01/18/2005 11:34:42 AM >>>
Hi Everyone . . .

I'm trying to do a couple things . . . .

1)  Trying to get a listing as follows, where the occupancy filespace
    stats are sum'ed for each node, with the node domain thrown in:

like this:   <node>  <domain>  <sum-files> <sum-physicalMB>
<sum-logicalMB>

Here is the command I'm trying . . . .

   dsmadmc -id=admin -password=admin -tab  <<EOD
    select -
         occupancy.node_name, -
         nodes.domain_name, -
         sum(occupancy.num_files), -
         sum(occupancy.physical_mb), -
         sum(occupancy.logical_mb) -
      from occupancy, nodes -
        where occupancy.node_name = nodes.node_name -
        group by occupancy.node_name, nodes.domain_name
   EOD

When I run this, I get a ZILLION of the following message, and
the cmd never finishes (or I'm impatient and don't wait long enough).

  "The character '#' stands for any decimal integer.The only valid
  responses are characters from this set: [Y, N]"

question -> What is the above message and what dumb thing am I doing
wrong?


2)  I would like to generate a report that sum's files, physicalMB and
logicalMB
    per domain.

like this:  <domain>  <sum-files>  <sum-physicalMB>  <sum-logicalMB>

question:  Is there a cmd or a sql statement to do this?

I guess it would be very similar to the above sql, except without the
node_name, but
since I can't get that one right, I figure I'll need help with this
one
also.



Thanks

Rick


-----------------------------------------
The information contained in this message is intended only for the
personal
and confidential use of the recipient(s) named above. If the reader of
this
message is not the intended recipient or an agent responsible for
delivering it to the intended recipient, you are hereby notified that
you
have received this document in error and that any review,
dissemination,
distribution, or copying of this message is strictly prohibited. If
you
have received this communication in error, please notify us
immediately,
and delete the original message.