Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / February 2007

Tip: Looking for answers? Try searching our database.

IBM.Data.DB2.iSeries for .NET

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
scase@rdcdrug.com - 27 Feb 2007 19:59 GMT
I need some trying to figure out what is happening on our AS/400.

I am not an AS/400 programmer, but I am using ASP.NET (VB) and the
IBM.Data.DB2.iSeries control for .NET to access our DB2 databases.

The problem we seem to be having is after I am all done with my queries
and I close out of everything there are still jobs (QZDAOSINIT?) sitting
idle for my profile.

My web application can hit our AS/400 hundreds of times at once depending
on how many people are using the web application.

At one point there were over a hundred QZDAOSINIT jobs with my user
profile just sitting there idle. Why do those not close immediately after
I disconnect from the database?

Forgive if I am not getting the terminology correct. I am not really all
that familar with the workings of the AS/400 and our AS/400 people are
not all that familar with .NET Programming. So we're kind of stuck as to
why these jobs are still running.

Does any of this make any sense?

Any feedback would be GREATLY appreciated.

Sincerely,
Shannon
dotyet - 27 Feb 2007 22:05 GMT
maybe you may want to execute terminate statement once you are done
with your processing

db2 "terminate" (this one is for LUW... I don't know whats the
equivalent for iseries.)

This will close the server side process which was entertaining your
requests.

I don't recall precisely, but a look on num_poolagents might be
related, i suggest you refer to the documentation for some info on
that if thats the culprit.

regards,
dotyet

On Feb 27, 2:59 pm, "s...@rdcdrug.com" <scase[at]rdcdrug.com> wrote:
> I need some trying to figure out what is happening on our AS/400.
>
[quoted text clipped - 23 lines]
> Sincerely,
> Shannon
Karl Hanson - 28 Feb 2007 15:54 GMT
> I need some trying to figure out what is happening on our AS/400.
>
[quoted text clipped - 11 lines]
> profile just sitting there idle. Why do those not close immediately after
> I disconnect from the database?

These are a type of job called "prestart" jobs, that can be recycled to
handle multiple clent work requests:

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/rzaks/rza
ksaboutprestartjobs.htm

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/rzaii/rza
iimstprestrtjob.htm


--
Karl Hanson
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.