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