Re: Hail the power of SQL!
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 - [EMAIL PROTECTED] 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
Hail the power of SQL!
Today I've been learning SQL to help gather info about my ADSM setup, and I'm absolutely ecstatic it's power and flexibility. A week ago, a 'SQL for ADSM' cheat sheet would have been indispensible to me, but I didn't know of one. Does such a thing exist? If it doesn't, I think I'll write one up and post it to the list, for the sake of other ADSM newbie admins. ("help select" was somewhat useful, but doesn't really make the grade). While we are on the topic, does anyone have any favorite SQL statements they'd like to share?
Re: Hail the power of SQL!
dsmadmc -id=admin -pa=x 'select stgpool_name,count(*) from volumes group by stgpool_name' [EMAIL PROTECTED] 08/09/00 03:15PM Today I've been learning SQL to help gather info about my ADSM setup, and I'm absolutely ecstatic it's power and flexibility. A week ago, a 'SQL for ADSM' cheat sheet would have been indispensible to me, but I didn't know of one. Does such a thing exist? If it doesn't, I think I'll write one up and post it to the list, for the sake of other ADSM newbie admins. ("help select" was somewhat useful, but doesn't really make the grade). While we are on the topic, does anyone have any favorite SQL statements they'd like to share?
Re: Hail the power of SQL!
A week ago, a 'SQL for ADSM' cheat sheet would have been indispensible to me, but I didn't know of one. Does such a thing exist? Daniel - That and much more misc. accumulated tidbits are to be found in my ADSM functional directory at http://people.bu.edu/rbs . Look under "REFERENCES AND OTHER RESOURCES" toward the bottom of the file, and "SQL" therein. There are also various sample SELECT statements sprinkled throughout the categorized file. Richard Sims (just another ADSMer, and compulsive documenter), BU
Re: Hail the power of SQL!
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