Re: [ADSM-L] select * from backups + file size

Subject:	Re: [ADSM-L] select * from backups + file size
From:	Remco Post <r.post AT PLCS DOT NL>
To:	ADSM-L AT VM.MARIST DOT EDU
Date:	Mon, 9 Mar 2015 18:37:09 +0100

> 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

<Prev in Thread]

Current Thread

[Next in Thread>

Previous by Date:

Re: [ADSM-L] select * from backups + file size, Mitchell, Ruth Slovik

Next by Date:

Re: [ADSM-L] select * from backups + file size, Rhodes, Richard L.

Previous by Thread:

Re: [ADSM-L] select * from backups + file size, Mitchell, Ruth Slovik

Next by Thread:

Re: [ADSM-L] select * from backups + file size, Rhodes, Richard L.

Indexes:

[Date] [Thread] [Top] [All Lists]