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. <rrhodes AT FIRSTENERGYCORP
> DOT COM> het volgende geschreven:
>
> Try something like this.
>
> dsmadmc -se=$i -id=$adminid -password=$adminpwd -noc -tab -dataonly=yes
> <<EOD
> select backups.node_name, -
> backups.filespace_name, -
> backups.filespace_id, -
> backups.state, -
> backups.type, -
> backups.hl_name, -
> backups.ll_name, -
> backups.backup_date, -
> contents.FILE_NAME, -
> contents.FILE_SIZE -
> from backups,contents -
> where backups.OBJECT_ID = contents.OBJECT_ID -
> and backups.node_name = 'YOURNODE'
>
> EOD
>
>
>
>
>
>
>
>
>
>
>
> -----------------------------------------
> 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.
--
Met vriendelijke groeten/Kind Regards,
Remco Post
r.post AT plcs DOT nl
+31 6 248 21 622
|