ADSM-L

Re: Really bad performance for a sql query after upgrading to v 3 .7

2000-11-02 10:01:13
Subject: Re: Really bad performance for a sql query after upgrading to v 3 .7
From: John Naylor <John.Naylor AT SCOTTISH-SOUTHERN.CO DOT UK>
Date: Thu, 2 Nov 2000 15:00:52 +0000
Mark,
Couple of suggestions.
1) How full is your database, sql queries use free space in the database as a
work area.
2) Run as a batch job, then you can just cancel the session if it is using too
much resource, and or taking too long.






Mark Brown <mark.brown AT MCGILL DOT CA> on 11/02/2000 02:45:05 PM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

To:   ADSM-L AT VM.MARIST DOT EDU
cc:    (bcc: John Naylor/HAV/SSE)
Subject:  Really bad performance for a sql query after upgrading to v 3.7



Hello,

We are currently running TSM Version 3, Release 7, Level 3.6 on OS/390.
We upgraded from version 3.1. On the 3.1 version I used to run a select
command to show me how many tapes each node was using. Here is the
select
command:

select node_name, count (distinct volume_name) as Numvols from
volumeusage -
where stgpool_name='TAPEMCO' group by node_name order by Numvols desc >
tapem.txt

This select used to take about 45 minutes to run on the 3.1 version but
now this
select command simply grinds the server to a halt. I eventually have to
cancel adsm
to recover the server. Is there something about the 3.7 version or my
select command
that would cause this kind of problem. If the command takes 2 hours to
run then that
is fine but I can't have the server slowed down so much that I cannot do
other things.


--
Mark Brown
Mark Brown
Operations Supervisor
=====================

Tel      ---> 514-398-2321
Fax      ---> 514-398-6876
E-mail   ---> Mark.Brown AT mcgill DOT ca






**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric and Southern Electric are trading names of
Scottish and Southern Energy Group.
**********************************************************************