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 AT VM.MARIST DOT EDU] On Behalf Of 
Remco Post
Sent: Monday, March 09, 2015 1:37 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: select * from backups + file size

> Op 9 mrt. 2015, om 17:43 heeft Karel Bos <tsm.wad AT GMAIL DOT 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.post AT plcs DOT 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.