ADSM-L

SQL results

2002-08-05 10:05:54
Subject: SQL results
From: "Large, Matthew" <Matthew.Large AT LLOYDSTSB.CO DOT UK>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 5 Aug 2002 12:24:17 +0100
Hi all,

We're trying to issue this

tsm> select volume_name,count(*) from volumeusage where node_name=xxx group
by volume_name

VOLUME_NAME             Unnamed[2]
------------------     -----------
020259                          12
020266                           4
030298                          12
030357                           4

to find out how many volumes contain data from a particular node.

What do these results tell me? From querying the contents of the vols, it
looks like number of filespaces per volume.

And my unnamed column seems to have the answer to my original question -
'2'.
Anyone seen this before or it is WAD?

Regards

Matthew Large
TSM Infrastructure Engineer
Lavington Street
Int: 7430 4995
Ext: 07736 448 808



-----------------------------------------------------------------------------------------------------------------------
This e-mail is intended only for the above addressee.  It may contain
privileged information. If you are not the addressee you must not copy,
distribute, disclose or use any of the information in it.  If you have
received it in error please delete it and immediately notify the sender.

evolvebank.com is a division of Lloyds TSB Bank plc.
Lloyds TSB Bank plc, 71 Lombard Street, London EC3P 3BS.  Registered in
England, number 2065.  Telephone No: 020 7626 1500
Lloyds TSB Scotland plc, Henry Duncan House, 120 George Street,
Edinburgh EH2 4LH.  Registered in Scotland, number 95237.  Telephone
No: 0131 225 4555

Lloyds TSB Bank plc and Lloyds TSB Scotland plc are regulated by the
Financial Services Authority and represent only the Scottish Widows
and Lloyds TSB Marketing Group for life assurance, pensions and
investment business.

Signatories to the Banking Codes.
-----------------------------------------------------------------------------------------------------------------------

<Prev in Thread] Current Thread [Next in Thread>