Re: AS400JDBCConnectionPool and QZDAsoinit -- JAVA400-L

Edwin,

What are you running your web application inside of, WebSphere or Tomcat?
Why are you trying to end the QZDASOINIT jobs?

I know if you are using data sources within WebSphere, WebSphere will keep
a pool of active connections open even if your application closes them, and
this in turn keeps open a pool of QZDASOINIT jobs.  Also it depends on how
the subsystem is configured, for example we have a special subsystem set up
just to run these prestart jobs which is configured to keep at least 2
QZDASOINIT running at all times.  So you can kill the QZDASOINIT jobs, but
as soon as you do another one appears.  Having these jobs running
beforehand slightly reduces the time it takes to then open up a new JDBC
connection.

HTH,

Nigel Gay.



|---------+------------------------------>
|         |           Edwin Gómez        |
|         |           Alméstar           |
|         |           <edgoal@xxxxxxxxx> |
|         |           Sent by:           |
|         |           java400-l-bounces@m|
|         |           idrange.com        |
|         |                              |
|         |                              |
|         |           07/05/2005 11:48 AM|
|         |           Please respond to  |
|         |           Java Programming on|
|         |           and around the     |
|         |           iSeries / AS400    |
|         |                              |
|---------+------------------------------>
  
>--------------------------------------------------------------------------------------------------------------|
  |                                                                             
                                 |
  |       To:       java400-l@xxxxxxxxxxxx                                      
                                 |
  |       cc:                                                                   
                                 |
  |       Subject:  AS400JDBCConnectionPool and QZDAsoinit                      
                                 |
  
>--------------------------------------------------------------------------------------------------------------|




I am developing Web application with Java Bean and use
AS400JDBCConnectionPool.
I have a ContextListener in my web Application, this might close
AS400JDBCConnectionPool with close method but in iSeries, the QZdasoinit
  process don't kill.
I create a CL program for this operation.i have v5R3 and JTOpen 4.7.
How can I kill the QZdasoinit process using close
AS400JDBCConnectionPool?
--
_______________________________
Ing. Edwin Gómez Alméstar
Ingeniero Informático
C.I.P #65909
Teléfono: (073) 9750602

--
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.








********************************************************************************
The information in this message is confidential and may be legally
privileged. It is intended solely for the addressee; access to this
email by anyone else is unauthorised.

If you are not the intended recipient: (1) you are kindly requested
to return a copy of this message to the sender indicating that you
have received it in error, and to destroy the received copy; and (2)
any disclosure or distribution of this message, as well as any action
taken or omitted to be taken in reliance on its content, is prohibited
and may be unlawful.
********************************************************************************