home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 10 Tools
/
10-Tools.zip
/
datatl25.zip
/
DCTDSGN.Z
/
EWSQMVU.QRY
< prev
next >
Wrap
Text File
|
1997-09-11
|
667b
|
30 lines
#NAME#
DA_OS390VolumeUsage
#DESCRIPTION#
The OS/390 volume usage impact query returns the names of all the storage groups which use the MVS Volume specified in the WHERE clause.
View type: DAQMVSVolume
Modifications:
Change the search criteria of the OS/390 volume name or volumeID using the = (equals), IN or LIKE elements in the SQL WHERE clause.
#MODIFIED#
#VERSION#
#SQL STATEMENT#
--DA_OS390VolumeUsage
SELECT DISTINCT
v.MVSVolume,
v.volumeID,
v.usedbyStoragegroup..db2390Storagegroup,
p.lastUpdate
FROM
DAQMVSVolume v,
PartView p
WHERE
v.MVSVolume LIKE '<>%' AND
v.MVSVolume=p.baseName
ORDER BY
v.MVSVolume;