Re: Loooong running SELECT

Sorry Thomas

I posted the original select and it worked for me in my small environment with
AIX and Oracle clients mostly.
For AIX and windows clients the node_name/filespace_name/hl_name gives the
directory from which the files came.
Different clients (e.g. Mac or VMS or VM or Notes) may well populate these
columns differently, I haven't seen them so I can't say.

Probably you should use q occ first to determine which filespaces are of
interest and add some where clauses to make the query more specific.
e.g where node_name='SOMENODE' and filespace_name in ('/xyz', '/abc', '/def')

 Regards

Steve.








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

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








 To:      ADSM-L AT VM.MARIST DOT EDU

 cc:      (bcc: Steve Harris/Wesley)



 Subject: Loooong running SELECT



Fax to:




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


===========================================
This email message has been swept by MIMESweeper





===========================================
This email message has been swept by MIMESweeper