|
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 +---
As an Amazon Associate we earn from qualifying purchases.
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.