IBM.Data.DB2.iSeries for .NET

[scase]

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]

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, "[e-mail]" <scase[at]rdcdrug.comwrote:

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

[Karl Hanson]

sc***@rdcdrug.com wrote:

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?

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

http://publib.boulder.ibm.com/infoce...estartjobs.htm
http://publib.boulder.ibm.com/infoce...prestrtjob.htm

--
Karl Hanson