× 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: Re: Database server jobs and SQL tuning
  • From: jkrueger@xxxxxxxxxxxx
  • Date: Wed, 17 May 2000 13:56:21 -0500

The AS/400 PartnerWorld group has a web site that might help:

http://www.as400.ibm.com/developer/client/index.html

There is a good amount of information there on performance tuning and
troubleshooting ODBC problems...

Janet Krueger
D H Andrews Group






"McCallion, Martin" <MccalliM@Midas-Kapiti.com> on 05/17/2000 08:45:36 AM

Please respond to MIDRANGE-L@midrange.com

To:   "'midrange-l@midrange.com'" <midrange-l@midrange.com>
cc:    (bcc: Janet Krueger/dhagroup/US)
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.







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