Re: VE 7.1.1.1 backup freezing a VM question about megablocks

Andy, These are the only odd messages I saw from these backups. Just to clarify, the backups didn't freeze, but the servers became unresponsive to the end user while the backup was running. As soon as the backup completed, the servers became responsive again. Looking at the Windows app

Re: VE 7.1.1.1 backup freezing a VM question about megablocks

Hi Steve, Off-hand I am not sure what this is, but a couple of things: 1. Are there any anomalous messages in the error log during the timeframe of the backup that exhibits the problem? 2. Consider capturing a dump (*) of the TSM client backup process, e.g., dsmcsc.exe, when the backup is in

Re: VE 7.1.1.1 backup freezing a VM question about megablocks

Thanks Warren, but they are all basic disks. -steve -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Arbogast, Warren K Sent: Sunday, March 08, 2015 11:04 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] VE 7.1.1.1 backup freezing a VM

Re: DB2/Oracle backup reporting and scheduling

Thanks everyone for the feedback/ideas! They reaffirm my initial thoughts that there was no single solution, but collectively it appears that I can marginalize the risk. Ultimately as many have stated the DBA team will need to be held accountable, and they do insist they own their

Re: select * from backups + file size

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@VM.MARIST.EDU] On Behalf

Re: select * from backups + file size

Karel, Join with the CONTENTS table to get FILE_SIZE, keying on OBJECT_ID. Might want to avoid wildcards. Ruth -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Karel Bos Sent: Monday, March 09, 2015 11:44 AM To: ADSM-L@VM.MARIST.EDU Subject:

Re: select * from backups + file size

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, -

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 the object size into this? Kind regards, Karel

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 FILESPACE_NAME HL_NAME LL_NAME BACKUP_DATE and Size. Select * from backup where node_name='' shows all but the requested object

Re: select * from backups + file size

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:

Re: Select Statement Help

Bruce, You could do a group by node_name at the end of your select statement. Best Regards, _ email: ron.delaw...@us.ibm.com Storage Services Offerings From: Kamp, Bruce (Ext) bruce.k...@alcon.com To: ADSM-L@VM.MARIST.EDU

Select Statement Help

I am found a couple TDP SQL nodes that aren't inactivating there backups so TSM isn't expiring them... What I am trying to find is the oldest backup date for each server with a name like _TDP. I can get this: Node Name HL_NAME