>> 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

I am using v3.1.2.20 on AIX 4.3.2. I asked support if this had been resolved
in 3.7 and they said no, it is still an issue, but that was before 3.7.3 was
released. We will soon be going to v 4.1, so I will change my scripts back
at that time and see what happens. Thank you for your input.

Roger C Cook
RCG Information Services