Looking for query for usage per filespace
1999-12-23 10:05:18
Subject: |
Looking for query for usage per filespace |
From: |
"Loon, E.J. van - SPLXM" <Eric-van.Loon AT KLM DOT NL> |
Date: |
Thu, 23 Dec 1999 16:05:18 +0100 |
Hi *SM-ers!
I'm trying to create an SQL query to see which filespace is responsible for
generating a lot of backup data for a specific node.
I have tried the following query:
SELECT OCCUPANCY.PHYSICAL_MB, OCCUPANCY.FILESPACE_NAME FROM OCCUPANCY
OCCUPANCY WHERE (OCCUPANCY.NODE_NAME='OD0')
When I execute this query it returns all filespaces at least twice, some of
them even multiple times. I'm not an SQL expert, so I don't even know if the
query is correct for what I'm trying to accomplish.
Can somebody please help me with creating the correct query?
Thank you very much in advance!!
Kindest regards,
Eric van Loon
|
|
|