>> This thread reminds me of a question I've been meaning to ask. I have
>> several SQL queries that run as cron jobs to keep me current on system
>> status. About two months ago the server started crashing every Sunday at the
>> same exact time. The problem was traced to an automated query that runs
>> every day, which has been running for almost two years. Once I modified the
>> statement, the crashes stopped. Support said that it was because of the
>> "group by" portion of the query, and that this is a know issue. My questions
>> are:
>>
>> 1. Why would this start happening when I have been using this script every
>> day for over a year?
>
>Well, the crash should not be happening - we would more expect a message like
>ANR2958E SQL temporary table storage has been exhausted.
>But SQL queries require workspace, and that comes from the TSM database, and
>certainly yours has grown, been used, and changed over time.  The workspace
>usually needs to be contiguous, as well, and when things get tight, untoward
>events can transpire.  How TSM is actually servicing some of these queries
>also plays a part.  Your mileage may vary, things change, and all that.
>   Richard Sims, BU


What level of the server are you running?  The crash is fixed in the 3.7.3.0
level of the TSM server.

David Bohm
TSM server development
email - dbohm AT tivoli DOT com