the object_ID is not unique in the backups table, so you might count data
multiple times, up to 2000 files in a transaction, of 2 GB…. 2000 times
inflated, 4 TB reported for 2 GB data.
> Op 9 mrt. 2015, om 19:08 heeft Rhodes, Richard L.
> het volgende geschreven:
>
> Try something like this.
Try something like this.
dsmadmc -se=$i -id=$adminid -password=$adminpwd -noc -tab -dataonly=yes
<
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 het volgende
> geschreven:
>
> Hi,
>
> Customer wants to get report on DB2 backups containing NODE_N
> Op 9 mrt. 2015, om 17:43 heeft Karel Bos 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
: [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
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
