Problem with DB2

Marcella Attimonelli

Problem with DB2
Hi,
we have encountered this problem on a system based on J2EE. We have
a DB2 8.1.2 on Linux Suse 8.2 with Kernel 2.4.20.
The jdbc app driver doesn't work, so we
have used the jdbc net driver. We have started the db2jstrt on 8888
port, but the process falls with this exception:

- SQL Exception
occurred - SQLSTATE 40003 Message: [IBM][CLI Driver] SQL1224N A
database agent could not be started to service a request, or was
terminated as a result of a database system shutdown or a force
command. SQLSTATE=55032

30 Jul 2005 09:32:16,608||ERROR|
HMDB|Exception .Reason : SQL Exception (SQLState = 40003) Message: [IBM]
[CLI Driver] SQL1224N A database agent could not be started to service
a request, or was terminated as a result of a database system shutdown
or a force command. SQLSTATE=55032
at com.ibm.jtc.hmdb.command.
CountryCommand.handleExecute(CountryCommand.java:60)
at com.ibm.jtc.
hmdb.servlet.RegisterServlet.performTask(RegisterServlet.java:94)
at
com.ibm.jtc.hmdb.servlet.RegisterServlet.doGet(RegisterServlet.java:
27)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.
apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:237)
at org.apache.catalina.core.
ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at
org.apache.catalina.core.StandardWrapperValve.invoke
(StandardWrapperValve.java:214)
at org.apache.catalina.core.
StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.
apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
520)
at org.apache.catalina.core.StandardContextValve.invokeInternal
(StandardContextValve.java:198)
at org.apache.catalina.core.
StandardContextValve.invoke(StandardContextValve.java:152)
at org.
apache.catalina.core.StandardValveContext.invokeNext
(StandardValveContext.java:104)
at org.apache.catalina.core.
StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.
catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at
org.apache.catalina.core.StandardValveContext.invokeNext
(StandardValveContext.java:104)
at org.apache.catalina.valves.
ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.
catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:
102)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:520)
at org.apache.catalina.core.
StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.
catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:
104)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.
invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.
CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.jk.server.
JkCoyoteHandler.invoke(JkCoyoteHandler.java:296)
at org.apache.jk.
common.HandlerRequest.invoke(HandlerRequest.java:372)
at org.apache.jk.
common.ChannelSocket.invoke(ChannelSocket.java:694)
at org.apache.jk.
common.ChannelSocket.processConnection(ChannelSocket.java:626)
at org.
apache.jk.common.SocketConnection.runIt(ChannelSocket.java:807)
at org.
apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.
java:644)
at java.lang.Thread.run(Thread.java:534)

The next message
is:
- SQL Exception occurred - SQLSTATE S1000 Message: [IBM][JDBC
Driver] CLI0601E Invalid statement handle or statement is closed.
SQLSTATE=S1000
30 Jul 2005 19:21:21,210||ERROR| HMDB|Exception .Reason
: SQL Exception (SQLState = S1000) Message: [IBM][JDBC Driver]
CLI0601E Invalid statement handle or statement is closed.
SQLSTATE=S1000

at com.ibm.jtc.hmdb.command.CountryCommand.handleExecute
(CountryCommand.java:60)
at com.ibm.jtc.hmdb.servlet.RegisterServlet.
performTask(RegisterServlet.java:94)
at com.ibm.jtc.hmdb.servlet.
RegisterServlet.doGet(RegisterServlet.java:27)
at javax.servlet.http.
HttpServlet.service(HttpServlet.java:697)
at javax.servlet.http.
HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.
ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:157)
at org.apache.catalina.core.
StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.
apache.catalina.core.StandardValveContext.invokeNext
(StandardValveContext.java:104)
at org.apache.catalina.core.
StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.
catalina.core.StandardContextValve.invokeInternal(StandardContextValve.
java:198)
at org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java:152)
at org.apache.catalina.core.
StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.
apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
520)
at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:137)
at org.apache.catalina.core.
StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.
apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:
117)
at org.apache.catalina.core.StandardValveContext.invokeNext
(StandardValveContext.java:102)
at org.apache.catalina.core.
StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.
catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at org.apache.catalina.core.StandardValveContext.invokeNext
(StandardValveContext.java:104)
at org.apache.catalina.core.
StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.
catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.
apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:296)

at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:372)

at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:694)

at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.
java:626)
at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.
java:807)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.
run(ThreadPool.java:644)
at java.lang.Thread.run(Thread.java:534)

Thank you very much.

Marcella Attimonelli
Associate Professor in Molecular Biology
Department of Biochemistry and Molecular Biology
Bari University
Via E.Orabona 4
7026 Bari (IT)
tel.+390805442399
fax +390805443317
e-mail [login to unmask email]

---------------------------------------------------------------------------------
Benvenuti alla lista DB2 User Group Italia.Per annullare l ' iscrizione collegarsi a : http://www.idugdb2-l.org/archives/DB2-UG-Italy.html. Selezionare "Join or Leave the list". Per consultare le IDUG Listserv FAQ collegarsi a :http://www.idugdb2-l.org. L'amministratore della lista DB2 User Group - Italy può essere raggiunto al seguente indirizzo: [login to unmask email] Per sapere le ultime novità sulle conferenze IDUG potete consultare : http://conferences.idug.org/index.cfm

Silvia Savino

Re: Problem with DB2
(in response to Marcella Attimonelli)
Hi there,
...can your problem be pointed by this tech note? :



DB2 issues SQL1224N and WebSphere Application Server (WAS) admin server
fails with StaleConnectionException when attempting more than 10 local
concurrent DB2 connections from a single process.



It can be found at this link:

http://www-1.ibm.com/support/docview.wss?rs=71&context=SSEPGG&q1=EXTSHM+
Sql1224n&uid=swg21009742&loc=en_US&cs=utf-8&lang=en

Have a nice day !

Cordiali Saluti / Regards
Silvia.

Silvia Savino
Senior IT Specialist - Data Management
IBM Sales Distribution, Software Sales
Via Sciangai 53, 00100 Roma
Phone (+39)06/59665036 mobile 335-7248374
Internet Address: [login to unmask email]



Marcella
Attimonelli
<[login to unmask email] To
OLOGIA.UNIBA.IT> [login to unmask email]
Sent by: DB2 User cc
Group - Italy
List Subject
<[login to unmask email] Problem with DB2
GDB2-L.ORG>


15/09/2005 11.25


Please respond to
Marcella
Attimonelli






Hi,
we have encountered this problem on a system based on J2EE. We have
a DB2 8.1.2 on Linux Suse 8.2 with Kernel 2.4.20.
The jdbc app driver doesn't work, so we
have used the jdbc net driver. We have started the db2jstrt on 8888
port, but the process falls with this exception:

- SQL Exception
occurred - SQLSTATE 40003 Message: [IBM][CLI Driver] SQL1224N A
database agent could not be started to service a request, or was
terminated as a result of a database system shutdown or a force
command. SQLSTATE=55032

30 Jul 2005 09:32:16,608||ERROR|
HMDB|Exception .Reason : SQL Exception (SQLState = 40003) Message: [IBM]
[CLI Driver] SQL1224N A database agent could not be started to service
a request, or was terminated as a result of a database system shutdown
or a force command. SQLSTATE=55032
at com.ibm.jtc.hmdb.command.
CountryCommand.handleExecute(CountryCommand.java:60)
at com.ibm.jtc.
hmdb.servlet.RegisterServlet.performTask(RegisterServlet.java:94)
at
com.ibm.jtc.hmdb.servlet.RegisterServlet.doGet(RegisterServlet.java:
27)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.
apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:237)
at org.apache.catalina.core.
ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at
org.apache.catalina.core.StandardWrapperValve.invoke
(StandardWrapperValve.java:214)
at org.apache.catalina.core.
StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.
apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
520)
at org.apache.catalina.core.StandardContextValve.invokeInternal
(StandardContextValve.java:198)
at org.apache.catalina.core.
StandardContextValve.invoke(StandardContextValve.java:152)
at org.
apache.catalina.core.StandardValveContext.invokeNext
(StandardValveContext.java:104)
at org.apache.catalina.core.
StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.
catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at
org.apache.catalina.core.StandardValveContext.invokeNext
(StandardValveContext.java:104)
at org.apache.catalina.valves.
ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.
catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:
102)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:520)
at org.apache.catalina.core.
StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.
catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:
104)
at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.
invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.
CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.jk.server.
JkCoyoteHandler.invoke(JkCoyoteHandler.java:296)
at org.apache.jk.
common.HandlerRequest.invoke(HandlerRequest.java:372)
at org.apache.jk.
common.ChannelSocket.invoke(ChannelSocket.java:694)
at org.apache.jk.
common.ChannelSocket.processConnection(ChannelSocket.java:626)
at org.
apache.jk.common.SocketConnection.runIt(ChannelSocket.java:807)
at org.
apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.
java:644)
at java.lang.Thread.run(Thread.java:534)

The next message
is:
- SQL Exception occurred - SQLSTATE S1000 Message: [IBM][JDBC
Driver] CLI0601E Invalid statement handle or statement is closed.
SQLSTATE=S1000
30 Jul 2005 19:21:21,210||ERROR| HMDB|Exception .Reason
: SQL Exception (SQLState = S1000) Message: [IBM][JDBC Driver]
CLI0601E Invalid statement handle or statement is closed.
SQLSTATE=S1000

at com.ibm.jtc.hmdb.command.CountryCommand.handleExecute
(CountryCommand.java:60)
at com.ibm.jtc.hmdb.servlet.RegisterServlet.
performTask(RegisterServlet.java:94)
at com.ibm.jtc.hmdb.servlet.
RegisterServlet.doGet(RegisterServlet.java:27)
at javax.servlet.http.
HttpServlet.service(HttpServlet.java:697)
at javax.servlet.http.
HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.
ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:157)
at org.apache.catalina.core.
StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.
apache.catalina.core.StandardValveContext.invokeNext
(StandardValveContext.java:104)
at org.apache.catalina.core.
StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.
catalina.core.StandardContextValve.invokeInternal(StandardContextValve.
java:198)
at org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java:152)
at org.apache.catalina.core.
StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.
apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:
520)
at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:137)
at org.apache.catalina.core.
StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.
apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:
117)
at org.apache.catalina.core.StandardValveContext.invokeNext
(StandardValveContext.java:102)
at org.apache.catalina.core.
StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.
catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at org.apache.catalina.core.StandardValveContext.invokeNext
(StandardValveContext.java:104)
at org.apache.catalina.core.
StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.
catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.
apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:296)

at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:372)

at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:694)

at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.
java:626)
at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.
java:807)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.
run(ThreadPool.java:644)
at java.lang.Thread.run(Thread.java:534)

Thank you very much.

Marcella Attimonelli
Associate Professor in Molecular Biology
Department of Biochemistry and Molecular Biology
Bari University
Via E.Orabona 4
7026 Bari (IT)
tel.+390805442399
fax +390805443317
e-mail [login to unmask email]
---------------------------------------------------------------------------------
Benvenuti alla lista DB2 User Group Italia.Per annullare l ' iscrizione
collegarsi a : http://www.idugdb2-l.org/archives/DB2-UG-Italy.html.
Selezionare "Join or Leave the list". Per consultare le IDUG Listserv FAQ
collegarsi a :http://www.idugdb2-l.org. L'amministratore della lista DB2
User Group - Italy può essere raggiunto al seguente indirizzo:
[login to unmask email] Per sapere le ultime novità sulle
conferenze IDUG potete consultare : http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Benvenuti alla lista DB2 User Group Italia.Per annullare l ' iscrizione collegarsi a : http://www.idugdb2-l.org/archives/DB2-UG-Italy.html. Selezionare "Join or Leave the list". Per consultare le IDUG Listserv FAQ collegarsi a :http://www.idugdb2-l.org. L'amministratore della lista DB2 User Group - Italy può essere raggiunto al seguente indirizzo: [login to unmask email] Per sapere le ultime novità sulle conferenze IDUG potete consultare : http://conferences.idug.org/index.cfm