Try:
Select volume_name,date(last_read_date) from volumes
Al
Alan Davenport
Senior Storage Administrator
Selective Insurance
[EMAIL PROTECTED]
(973)948-1306
+ -----Original Message-----
+ From: Matthew Large [mailto:[EMAIL PROTECTED]]
+ Sent: Thursday, September 27, 2001 10:31 AM
+ To: [EMAIL PROTECTED]
+ Subject: Select Statement
+
+
+ I need to find out which volumes from a particular storage
+ pool were used
+ least recently.
+
+ so far I have
+
+ tsm> select last_read_date from volumes
+
+ LAST_READ_DATE
+ ------------------
+
+
+
+
+ 2001-09-05
+ 16:26:59.000000
+ 2001-09-12
+ 09:35:36.000000
+ 2001-08-24
+ 11:28:11.000000
+
+
+
+ Clearly my select statement skills are highly inadequate and
+ this output
+ isn't enough, I need the volume names aswell. I assume display by
+ chronological order is default.
+ Can anyone offer some assistance?
+
+ Many Thanks All.
+
+
+ http://www.phoenixitgroup.com
+ ******************Internet Email Confidentiality
+ Footer*******************
+
+ Phoenix IT Group Limited is registered in England and Wales
+ under company
+ number 3476115. Registered Office: Technology House,
+ Hunsbury Hill Avenue,
+ Northampton, NN4 8QS
+
+ Opinions, conclusions and other information in this message
+ that do not
+ relate to the official business of our firm shall be
+ understood as neither
+ given nor endorsed by it.
+
+ No contracts may be concluded on behalf of our firm by means of email
+ communications.
+
+ Confidentiality: Confidential information may be contained in
+ this message.
+ If you are not the recipient indicated (or responsible for
+ delivery of the
+ message to such person), you may not take any action based on
+ it, nor should
+ you copy or show this to anyone; please reply to this email
+ and highlight
+ the error to the sender, then delete the message from your system.
+
+ Monitoring of Messages: Please note that we reserve the right
+ to monitor and
+ intercept emails sent and received on our network.
+ Warning: Internet email is not 100% secure. We ask you to
+ understand and
+ observe this lack of security when emailing us. We do not accept
+ responsibility for changes made to this message after it was sent
+
+ Viruses: Although we have taken steps to ensure that this
+ email and any
+ attachments are free from any virus, we advise that in
+ keeping with good
+ computing practice the recipient should ensure they are
+ actually virus free.
+
