> Op 9 mrt. 2015, om 17:43 heeft Karel Bos <[email protected]> het volgende > geschreven: > > 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?
the object size in the contents table is for the bigfile (aggregate), which can be many files. I don’t think there is any select that can give you what you want from the server side. > > > Kind regards, > > Karel -- Met vriendelijke groeten/Kind Regards, Remco Post [email protected] +31 6 248 21 622
