Disabling AIX Extended Shared Memory (EXTSHM) Causes Administrative Server startup failure
 Technote (FAQ)
 
Problem
After stopping WebSphere® Application Server and DB2 in order to install PTF 3 for V4.01, WebSphere Application Server will not restart. "Stale connection" error messages are generated in the error logs. The cause and solution are located in the V4.0.2 Release Notes.
 
Solution
[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.

 
 
Historical Number
21840
379
000
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > Install
Operating system(s): AIX
Software version: 4.0.7
Software edition:
Reference #: 1105584
IBM Group: Software Group
Modified date: Sep 15, 2004