Re: Database server jobs and SQL tuning -- MIDRANGE-L

If you are using several Data controls rather than one ADO connection then
that may be your problem....

______________________________________________
Eric N. Wilson
President
Doulos Software & Computer Services
2913 N Alder St.
Tacoma WA 98407


----- Original Message -----
From: "McCallion, Martin" <MccalliM@Midas-Kapiti.com>
To: <midrange-l@midrange.com>
Sent: Wednesday, May 17, 2000 6:45 AM
Subject: Database server jobs and SQL tuning


> Hi folks.
>
> We're currently in the process of testing an application where we've
> ported the database from SQL Server to the AS/400.  The client is
> written in VB and uses ODBC to communicate with the database.  One of my
> colleagues is currently testing it, and he has _33_ instances of the
> QZDASOINIT job servicing his user profile at present (he is working at a
> single workstation, I should add).  To my mind this seems preposterously
> many.  Does anyone know what causes the system to start a new instance
> of this job when there is an existing connection already?
>
> What testing we have managed to do so far has given very disappointing
> results in terms of performance.  Clearly we'd all expect the AS/400 to
> wipe the floor with NT, and I'm fairly sure that the performance issues
> can be resolved with a little tuning.  Performance way well be related
> to the vast number of jobs referred to above, which is why I raised that
> first.
>
> I spent most of yesterday searching the web and Infocenter for SQL
> performance information, and I'm investigating the DBMON commands
> (STRDBMON and ENDDBMON).  But I wondered whether anyone had any ideas;
> I'm sure some of you have been through something like this.
>
> On specific question was, what would the difference be if we created our
> database as an SQL collection?  I found an IBM page that describes the
> very thing we're trying to do
> (http://www.as400.ibm.com/tstudio/dataware/migrate/Index_M.htm) and we
> had already done most of it, except that we just created a library and
> added the journalling objects manually.
>
> Any thoughts, manuals, web sites, gratefully received.
>
> Cheers,
>
> Martin.
>
> --
> Martin McCallion
> Midas-Kapiti International
> Work:  mccallim@midas-kapiti.com
> Home: martin.mccallion@ukonline.co.uk
>
> Apologies for the length of this sig, but company policy says:
> This email message is intended for the named recipient only.  It may be
> privileged and/or confidential.  If you are not the intended named
> recipient of this email then you should not copy it or use it for any
> purpose, nor disclose its contents to any other person.  You should
> contact Midas-Kapiti International as shown below so that we can take
> appropriate action at no cost to yourself.
>
> Midas-Kapiti International Ltd, 1 St George's Road, Wimbledon, London,
> SW19 4DR, UK
> Email: Postmaster@midas-kapiti.com Tel: +44 (0)208 879 1188 Fax: +44
> (0)208 947 3373
> Midas-Kapiti International Ltd is registered in England and Wales under
> company no. 971479
>
> .:.
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---