ADSM-L

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

2000-11-02 11:31:50
Subject: Re: Really bad performance for a sql query after upgrading to v 3 .7
From: Mark Brown <mark.brown AT MCGILL DOT CA>
Date: Thu, 2 Nov 2000 11:31:34 -0500
To answer your questions, adsm database is as follows:

Available Assigned   Maximum   Maximum    Page     Total      Used
Pct  Max.
    Space Capacity Extension Reduction    Size    Usable     Pages
Util   Pct
     (MB)     (MB)      (MB)      (MB) (bytes)
Pages                  Util
--------- -------- --------- --------- ------- --------- --------- -----
-----
-----
   11,620   11,620         0     2,648   4,096 2,974,720 2,296,359
   11,620   11,620         0     2,648   4,096 2,974,720 2,296,359
77.2  77.2


I also run the process as a batch job.

Mark

John Naylor wrote:
>
> 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
> 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.
> **********************************************************************

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

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