> 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