Re: Help on Tsm 6 script

2011-10-23 Thread Erwann SIMON
ssage- From: Robert Ouzen Sender: "ADSM: Dist Stor Manager" Date: Sun, 23 Oct 2011 07:48:24 To: Reply-To: "ADSM: Dist Stor Manager" Subject: Re: [ADSM-L] Help on Tsm 6 script Another question , anybody know how to get the output as a table view. Now in version 6 the

Re: Help on Tsm 6 script

2011-10-23 Thread Grigori Solonovitch
Maybe look for "dsmadmc -displaymode=table ..." Grigori G. Solonovitch -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Robert Ouzen Sent: Sunday, October 23, 2011 10:48 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Help on Ts

Re: Help on Tsm 6 script

2011-10-22 Thread Robert Ouzen
Hi Rainer Just what I needed ... Thanks, Regards Robert -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rainer Sch?pf Sent: Friday, October 21, 2011 10:52 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Help on Tsm 6 script Hi Robert, I

Re: Help on Tsm 6 script

2011-10-21 Thread Rainer Schöpf
Hi Robert, I believe the difference of two timestamps is given in seconds. To convert that to minutes or hours, you can use the timestampdiff function: http://publib.boulder.ibm.com/infocenter/db2luw/v8/topic/com.ibm.db2.udb.doc/admin/r861.htm E.g., select - timestampdiff(4,char(cu

Help on Tsm 6 script

2011-10-20 Thread Robert Ouzen
Hi to all This week I upgrade one my Tsm server from V5.5.4.0 to V6.2.3.0 in Windows platform 2008R2, everything work fine …. Now trying to update some scripts by example this one (Report of backup / archive in specific period). set sqlmathmode round set sqldatetimeformat eur select entity as