This is the script which is executing; set sqldatetimeformat usa set sqldisplaymode wide select a.entity,a.successful,b.msgno,substr(b.message,posstr(b.message,'transferred:')+14,8)as Bytes_Backedup, substr(cast(min(a.start_time)as varchar(10)),1,10) as Start_Date, substr(cast(min(a.start_time)as varchar(16)),12,12) as Start_time,substr(cast(max(a.end_time)as varchar(16)),12,12) as End_Time,substr(cast(min(a.End_time)as varchar(10)),1,10) as End_Date, substr(cast(max(a.end_time)-(min(a.Start_time)) as varchar(10)),3,5) as Elapsed_Time,sum(a.mediaw) as media_Wait,sum(a.affected)as number_files,sum(a.failed) as Number_Failed,sum(a.bytes) as Bytes_Transferred, max(a.number)as Number from summary a, actlog b where b.msgno= 4961 and a.schedule_name = b.schedname and (date(a.end_time)=current date -1 days and time(a.end_time)>='18.00.00') or( date(a.end_time)=current date) and time(a.end_time)<='08.00.00' and a.activity = 'BACKUP' group by a.entity, a.successful,b.msgno,b.message
The bytes sent, bytes received and wait time are all 0. I used a predefined script, written by someone else, and wasn't aware it didn't work. I should have taken a closer look. Thanks for all the input, Debbie Andrew Raibeck <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[email protected]> 08/02/2005 10:51 AM Please respond to "ADSM: Dist Stor Manager" To: [email protected] cc: Subject: Re: [ADSM-L] Cancel Session Look through your activity log and try to figure out the last command that your script executed (i.e., exactly what command did the script issue that is hung?) The "run" state would suggest that the TSM server is doing processing of a long-running command. If you do "query session" multiple times, do you see any of the counters for the hung session changing? You could search the IBM TSM web site http://www-306.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html for "cancel session" to see if any hits match your scenario. If that doesn't yield anything useful, I'd suggest contacting IBM technical support for further assistance. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" <[email protected]> wrote on 2005-08-02 06:13:37: > I executed a script, yesterday, and it is still executing. The session > won't cancel it because it's in a run status. Is there a way to force a > session to cancel? > > Thanks, > Debbie
