× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: Database server jobs and SQL tuning
  • From: "McCallion, Martin" <MccalliM@xxxxxxxxxxxxxxxx>
  • Date: Wed, 17 May 2000 14:45:36 +0100

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
+---

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.