HTTP Session replication to DB2/i5 database

[pedr...@hotmail.com]

Hello,
I'm trying to set up a WAS V6.1 ND cluster (made of 2 members at the moment) on Linux (under RedHat Enterprise Linux 5). This works perfectly.
I would like to configure the HTTP Session replication to a DB2 database, which is hosted on a V5R4 i5 OS.
I've declared the JDBC Provider and the datasource pointing to my DB2 instance and it works (using JTOpen driver). The problem is that WAS wants to store the HTTP sessions in table QEJBASSN.SESSIONS and QEJBASSN does not exists! I can't find where I can configure the name of the collection to be used.
I've found the SessionTableName custom property for the web server, but as I understand it, it is not what I need.
Here are the logs I'm getting during server execution:
[19/11/08 19:11:36:273 CET] 00000010 SessionContex E Exception is : java.sql.SQLException: [SQL0204] SESSIONS of type *FILE in QEJBASSN not found.
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:650)
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:621)
at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1576)
at com.ibm.as400.access.AS400JDBCPreparedStatement.(AS400JDBCPreparedStatement.java:193)
at com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:2023)
at com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:1965)
at com.ibm.as400.access.AS400JDBCConnectionHandle.prepareStatement(AS400JDBCConnectionHandle.java:916)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.pmiPrepareStatement(WSJdbcConnection.java:1826)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:2065)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:2017)

During server startup, I also have this log, which doesn't help either:
was.install.library not set. Using collection QEJBASSN for session persistance.

Thanks in advance for your help.

Pierre Casenove

[henk]

Pierre,

I saw you logged a PMR for this issue and was pointed to
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp?topic=/com.ibm.websphere.base.iseries.doc/info/iseries/ae/tprs_table_creation.html
Was that of help?

Henk

<pedr...@hotmail.com> wrote in message
news:2103426498.1227119391226.JavaMail.wassrvr@ltsgwas009.sby.ibm.com...