Home > Ask the AS/400 Experts > iSeries Web Development Questions & Answers > Database pooling on iSeries
Ask The iSeries 400 Expert: Questions & Answers
EMAIL THIS

Database pooling on iSeries

Jim Mason EXPERT RESPONSE FROM: Jim Mason

Pose a Question
Other iSeries 400 Categories
Meet all iSeries 400 Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 29 January 2008
My company is developing a Web application (.NET) and uses Webservices to connect to iSeries.

Everything was OK, but recently we noticed that QZDASOINIT jobs are remaining active (with several locks) in the QUSRWRK subs, despite the connections being closed.

I've done some investigation and found out that the pooling property could have something to do with this.

Pooling = true gives us the current scenario; pooling = false gives us the desired scenario, as the QZDASOINIT jobs are terminated once the browser closes, but all the connections are extremely slow.

What we want is this scenario:
Each connection to iSeries creates an QZDASOINIT job and terminates it when is not needed anymore, but the connection is as fast as if we had pooling = true.

Is there any way to do this via .net code, connectionstring, or iSeries configuration?


>
Those QZDASOINIT jobs are database server jobs that sit in a wait state waiting for a request from a remote client looking to run database work. You are correct that those jobs stay active if you use pooled connections. You should check the actual CPU seconds consumed. While the jobs are active, they don't consume any significant CPU and probably get swapped from memory (if that's a constraint) if there is no activity for an extended period of time. In short, in a pooled environment, they are generally not a bad thing at all. Pooled connections avoid the overhead of starting and stopping database jobs on the system, instead sharing existing jobs wherever possible. This is normally a good thing from a performance perspective.

Good luck with it.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
iSeries Web Development
JDBCODBC functionality -- Java to Excel for complex workbooks
Accessing AS/400 data using Excel ODBC drivers
IBM WebSphere Studio Application Developer error
Connecting WebSphere to AS/400 for image retrieval
Retrieving the value selected by a user
Condense ILE service program procedures
WebSphere error during login process
Connecting WebSphere to a DB2 database
WebFacing error: User ID or password invalid
Starting Dominos on a Windows 2000 server

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



iSeries Networking - Printing, Remote Access, TCP/IP
HomeNewsTopicsITKnowledge ExchangeTipsBlogsAsk the ExpertsMultimediaWhite PapersProducts
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 1999 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts