Upgrade to version 6, and just run your SQL without fear. :) -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Mark Devine Sent: Tuesday, April 21, 2009 10:10 AM To: [email protected] Subject: [ADSM-L] Object size query
I would like to query the DB for any stored objects > 1GB. The output will help improve our incl/excl specifications. The only table/column I see is CONTENTS/FILE_SIZE. My select works, but obviously it's an intense scan. Is CONTENTS the only place? Please suggest the best approach.
