I actually opened a PMR on this same problem (PMR#45713,519) and they told
me that (this is almost a direct quote) "...that is the way it works." In
asking, of course, they wouldnt put any of that in writing, but here is some
text cut out from the PMR itself...
Action Taken:Explained that Select statements are database intensive
and use up a lot of resources. Depending on complexity of the query it
quite possible for the server to hang. If cancel session doesn't work
then recycling Tsm is the only way out.
Customer wants something in writing confirming this. Directed to the
Admin Guide: Monitoring TSM server subsection entilted Using Sql to
Query the TSM DB, issuing select commands where it states that complicat
ed queries can interfere with normal server operations.
The problem I was having is that a select that worked on one system would
hang on another. According to the Admin Guide, it is perfect acceptable to
cancel that session with another administrator session; however from what I
have seen I wouldnt recommend it - unless you have the time to cycle your
TSM_server process.
-Dustin
============================================================================
=====
Dustin Hamilton; EDS Auburn Hills SMC; Enterprise Backup and Restore
Phone: 248/276.5717 Pager: 248/316.5089
Schedule and more info: http://205.239.25.218/
Backup Client Software: ftp://205.239.25.218/
============================================================================
=====
eMail: [EMAIL PROTECTED]
Text-Pager: [EMAIL PROTECTED]
============================================================================
=====
-----Original Message-----
Date: Sun, 16 Sep 2001 16:17:59 -0700
From: Joel Fuhrman <[EMAIL PROTECTED]>
Subject: Re: cannot cancel a session
My experience is that the select processes all the data. The cancel only
stops the display.
On Fri, 14 Sep 2001, Guan, Phillip wrote:
> Hi all,
>
> When I run 'select * from backups' or ' select * from archives', it will
> list a lots of records. Because it is a very long list, I press 'C' to
quit
> but it hung there for long time; and finally I press CTRL-C to exit to
> shell. Now that session is still there and I run the 'cancel session'
> command to stop it. Does anyone have such experience before?
>
> My TSM server is 4.1.2.0 and I know our backup and archive table is very
> big.
>
> Appreciated your help.
>
> Best regards,
> Phillip Guan
>
------------------------------
End of ADSM-L Digest - 15 Sep 2001 to 16 Sep 2001 (#2001-254)
*************************************************************
