... WHERE KB_ALLOCATED=0 AND FILE_SIZE>0 Oh, if you are also working with an HSM or HSM-like manager that can migrate files -- then you might have to add some additional tests... -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://gpfsug.org/pipermail/gpfsug-discuss_gpfsug.org/attachments/20190328/e5499e7a/attachment.html>