Karel, Join with the CONTENTS table to get FILE_SIZE, keying on OBJECT_ID. Might want to avoid wildcards.
Ruth -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Karel Bos Sent: Monday, March 09, 2015 11:44 AM To: [email protected] Subject: [ADSM-L] select * from backups + file size Hi, Customer wants to get report on DB2 backups containing NODE_NAME FILESPACE_NAME HL_NAME LL_NAME BACKUP_DATE and Size. Select * from backup where node_name='' shows all but the requested object SIZE. Does anyone has a select I can use to get the object size into this? Kind regards, Karel
