|
Problem(Abstract) |
When WebSphere Application Server attempts to start the
first XA transaction with a remote DB2 for z/OS database, the following
exception occurs in SystemOut.log:
[2/7/03 8:23:09:165 CET] 5a3ff7ab Engine E com.ibm.bpe.engine.Engine
TRAS0014I: The following exception was logged
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2] SQL30090N Operation
invalid for application execution environment. Reason code = "1".
SQLSTATE=25000
at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:270)
at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:207)
at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:458)
at
COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(DB2PreparedStatement.java:2110)
at
COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeUpdate(DB2PreparedStatement.java:1642)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:578)
at
com.ibm.bpe.database.TomInstanceCache.flushDirtyObjects(TomInstanceCache.java:131)
at com.ibm.bpe.database.Tom.beforeCompletion(Tom.java:667)
at
com.ibm.bpe.admin.AdminService.installProcessModule(AdminService.java:307)
at
com.ibm.bpe.processarchive.ProcessModuleInstallTask.performTask(ProcessModuleInstallTask.java:110)
at
com.ibm.ws.management.application.SchedulerImpl.run(SchedulerImpl.java:216)
at java.lang.Thread.run(Thread.java:512)
|
|
|
|
Cause |
SQL code 30090N indicates problems with the syncpoint
manager. These exceptions seem to be caused by invalid syncpoint manager
log entries in the sqllib/spmlog directory. |
|
|
Resolving the
problem |
Perform the following:
- Clear the entries in the sqllib/spmlog directory and
restart.
- You may also have to increase SPM_LOG_FILE_SZ.
- Make sure that the instance configuration variable SPM_NAME
points to the local machine with a hostname not longer than eight
characters. If the hostname is longer than eight characters, define a
short alias in /etc/hosts.
Note: The syncpoint manager is a component of the local DB2 Connect
system. It is responsible for managing distributed transactions with a
remote DB2 host system. |
|
|