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
|