Hi Neil!
You're absolutely right. As soon as all data has been expired the node
disappears from the occupancy table. I didn't realize that.
Thank you very much for your help!
Kind regards,
Eric van Loon
AF/KLM Storage Engineering
From: Schofield, Neil (Storage & Middleware, Backup & Restore)
[mailto:Neil.Schofield AT lloydsbanking DOT com]
Sent: maandag 29 februari 2016 15:16
To: ADSM-L AT vm.marist DOT edu
Cc: Loon, EJ van (ITOPT3) - KLM
Subject: Re: [ADSM-L] Identifying empty nodes
Eric
It was my understanding that there was only an entry for a file space in the
occupancy table if it had a non-zero number of objects stored on the server.
If this is true then you probably need something like this:
select node_name from nodes where node_name not in (select node_name from
occupancy)
Regards
Neil Schofield
Tivoli Storage Manager SME
Backup & Recovery | Storage & Middleware | Central Infrastructure Services |
Infrastructure & Service Delivery | Group IT
LLOYDS BANKING GROUP
Lloyds Banking Group plc. Registered Office: The Mound, Edinburgh EH1 1YZ.
Registered in Scotland no. SC95000. Telephone: 0131 225 4555. Lloyds Bank plc.
Registered Office: 25 Gresham Street, London EC2V 7HN. Registered in England
and Wales no. 2065. Telephone 0207626 1500. Bank of Scotland plc. Registered
Office: The Mound, Edinburgh EH1 1YZ. Registered in Scotland no. SC327000.
Telephone: 03457 801 801. Cheltenham & Gloucester plc. Registered Office:
Barnett Way, Gloucester GL4 3RL. Registered in England and Wales 2299428.
Telephone: 0345 603 1637
Lloyds Bank plc, Bank of Scotland plc are authorised by the Prudential
Regulation Authority and regulated by the Financial Conduct Authority and
Prudential Regulation Authority.
Cheltenham & Gloucester plc is authorised and regulated by the Financial
Conduct Authority.
Halifax is a division of Bank of Scotland plc. Cheltenham & Gloucester Savings
is a division of Lloyds Bank plc.
HBOS plc. Registered Office: The Mound, Edinburgh EH1 1YZ. Registered in
Scotland no. SC218813.
This e-mail (including any attachments) is private and confidential and may
contain privileged material. If you have received this e-mail in error, please
notify the sender and delete it (including any attachments) immediately. You
must not copy, distribute, disclose or use any of the information in it or any
attachments. Telephone calls may be monitored or recorded.
********************************************************
For information, services and offers, please visit our web site:
http://www.klm.com. This e-mail and any attachment may contain confidential and
privileged material intended for the addressee only. If you are not the
addressee, you are notified that no part of the e-mail or any attachment may be
disclosed, copied or distributed, and that any other action related to this
e-mail or attachment is strictly prohibited, and may be unlawful. If you have
received this e-mail by error, please notify the sender immediately by return
e-mail, and delete this message.
Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its
employees shall not be liable for the incorrect or incomplete transmission of
this e-mail or any attachments, nor responsible for any delay in receipt.
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch
Airlines) is registered in Amstelveen, The Netherlands, with registered number
33014286
********************************************************
|