Welcome! » Log In » Create A New Profile

Re: Select from occupancy numfiles aberration

Posted by Schofield, Neil (Contractor - Storage & Middleware, Backup & Restore) 
Schofield, Neil (Contractor - Storage & Middleware, Backup & Restore)
Re: Select from occupancy numfiles aberration
December 13, 2017 11:59PM
Classification: Public

Classification: Public
Richard

If by 'accumulator' you mean that the NUM_FILES column is actually showing the sum of the current row and the previous row/rows then I don't think this is the case. It looks to me like there is an implicit ORDER BY NUM_FILES on the select statement. Presumably the NUM_FILES column is some sort of primary or clustered index on the OCCUPANCY table?

If you pick a random row from the output, does Q OCC <nodename> <filespacename> match? If so I think you can assume both the SELECT and Q OCC outputs are accurate.

Regards

Neil Schofield
IBM Spectrum Protect SME
Backup & Recovery | Storage & Middleware | Platform Technologies | Infrastructure Technology Services | Group CIO & IT Change
LLOYDS BANKING GROUP
________________________________
I: 75813101 | T: 0113 235 3101 | M: 07979 703303 | E: neil.schofield@lloydsbanking.com<mailto:neil.schofield@lloydsbanking.com>
50 Cote Lane, Dawsons Corner, Pudsey, LEEDS LS28 5ED TNT46 (PUD/FL1/WW/097)



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.

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.

Halifax is a division of Bank of Scotland 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.
This message was imported via the External PhorumMail Module
Sorry, only registered users may post in this forum.

Click here to login