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
: [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 to get
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, -
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
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
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.
rrho...@firstenergycorp.com het volgende geschreven: