Re: Loooong running SELECT & the Dallas/Ft Worth TSM users group

Try this one (the select statement below).....I presented this one, plus others
at a recent DFW TSM users group....
Anyone interested in coming to Dallas/Ft Worth area TSM user group
meetings...please e-mail me direct..
tim.williams AT fritolay DOT com
FYI Thanks Tim
"Ever wondered (or needed to know) which of your nodes took up the  most DB
(non-"stg") space (had the greatest number of files/dirs)?"
adsm> select sum(num_files) as "Num of files+Dirs",  node_name  from occupancy
group by node_name order by "Num of files+Dirs" desc
(group by example)
Num of files+Dirs     NODE_NAME
-----------------     ------------------
         10756213     xxZZ1BE0
         10756213     xxZZ1BE0
          5688786     xxZZ19E0
          3480486     xx420R04





"Rupp Thomas (Illwerke)" <thomas.rupp AT ILLWERKE DOT AT>
03/09/2000 04:30 PM

To:   ADSM-L AT VM.MARIST DOT EDU@SMTP@Exchange
cc:
Subject:  Loooong running SELECT

Hi ADSM-ers,

today I tried one of the SELECT statements I've seen on this list.

SELECT NODE_NAME, FILESPACE_NAME, HL_NAME, COUNT(*)
  FROM BACKUPS GROUP BY NODE_NAME,FILESPACE_NAME,HL_NAME
  ORDER BY 4 DESC

After 4 1/2 hours I had to cancel the session. Our mainframe 2003/205 was
running
at 80% busy and doing 50 I/O per second. No other ADSM or VM processing was
done at the same time.
I'm running VM/ESA 2.3.0 with ADSM/VM 3.1.2.50.

The DB has app. 3.8 million files and a Query DB F=D gives:

          Available Space (MB): 4.116
        Assigned Capacity (MB): 4.116
        Maximum Extension (MB): 0
        Maximum Reduction (MB): 788
             Page Size (bytes): 4.096
            Total Usable Pages: 1.053.696
                    Used Pages: 709.630
                      Pct Util: 67,3
                 Max. Pct Util: 81,1
              Physical Volumes: 12
             Buffer Pool Pages: 8.192
         Total Buffer Requests: 54.593.523
                Cache Hit Pct.: 97,07
               Cache Wait Pct.: 0,00
           Backup in Progress?: No
    Type of Backup In Progress:
  Incrementals Since Last Full: 0
Changed Since Last Backup (MB): 41,55
            Percentage Changed: 1,50
Last Complete Backup Date/Time: 09.03.2000 07:00:26

Do you think this is OK? If not, what can I do about it?

Kind regards
Thomas Rupp
Vorarlberger Illwerke AG
MAIL:   thomas.rupp AT illwerke DOT at
TEL:    ++43/5574/4991-251
FAX:    ++43/5574/4991-820-8251