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