Bummer . . .I didn't save it! I once wrote a sql cmd to join backups and contents (v6.2.5). I don't think I ever waited long enough to let it actually return a result, so I threw it away.
Rick -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Remco Post Sent: Monday, March 09, 2015 1:37 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: select * from backups + file size > Op 9 mrt. 2015, om 17:43 heeft Karel Bos <tsm....@gmail.com> 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 r.p...@plcs.nl +31 6 248 21 622 ----------------------------------------- The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message.
