[02.05.03 16:33:26:358 CDT] 7150873c ConnectionPoo X
CONM6009E:
Failed to get connection to the database from datasource
(SM_DATASOURCE). [02.05.03 16:33:26:435 CDT] 7150873c StaleConnecti A
CONM7007I: Mapping the following SQLException, with ErrorCode -1,224
and SQLState 08001, to a StaleConnectionException:
COM.ibm.db2.jdbc.DB2Exception: [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.
From the V4.0.2 Release Notes:
If WebSphere Application Server Advanced Edition is installed on an AIX
system with a local DB2 server and the commands below (as described in the
Information Center) were executed previously to configure DB2, the
administrative server should start successfully the first time.
Issue the following commands to set the EXTSHM environment variable:
$ EXTSHM=ON
$ export EXTSHM
$ db2set DB2ENVLIST=EXTSHM
Later, when the administrative server is stopped or the system is shut
down, DB2 will stop as well. However, when you next start DB2, the
administrative server might fail with the following error when you try to
start it:
Could not initialize persistent storage for serious events.
Got exception COM.ibm.db2.jdbc.DB2Exception: [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
To recover from this problem, type the above commands that set the EXTSHM
environment variable and restart the server.
To prevent the environment variable from being turned off accidentally
again, add the above three lines of commands to the db2profile (assuming
the db2profile is sourced using .profile) to ensure that the variable is
always valid.
|