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