RE: Database server jobs and SQL tuning

[Colin Williams <colin.williams@xxxxxxxxxxxxxxxxx>]

Scan the Midarange archives for QZDASOINIT, I was looking for something
else, 
but I'm sure I saw something in there about improving the performance of
QZDASOINIT 

-----Original Message-----
From: McCallion, Martin [mailto:MccalliM@Midas-Kapiti.com]
Sent: Wednesday, May 17, 2000 2:46 PM
To: 'midrange-l@midrange.com'
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
+---