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 <storman AT US.IBM DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
08/02/2005 10:51 AM
Please respond to "ADSM: Dist Stor Manager"
To: ADSM-L AT VM.MARIST DOT EDU
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/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com
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" <ADSM-L AT VM.MARIST DOT EDU> 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
|