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:ADSM-L@VM.MARIST.EDU] On Behalf Of Karel Bos Sent: Monday, March 09, 2015 11:44 AM To: ADSM-L@VM.MARIST.EDU 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
