IBM WS Admin server Doesn't Start

[mithra]

Hi ..
I installed IBM WS Advanced Edition Version 4.x.
And also installed DB2 7.2 as per instructins.And also updated to use Jdbc2.0.
When I start WS Admin server , its not starting and giving the following error in the log.
Please any one knows this problem help me.

[03.03.10 13:03:52:656 GMT+05:30] 149d5f19 DBMgr F SMTL0026E: Failure to create a data source: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL1013N The database alias name or database name "WAS40" could not be found. SQLSTATE=42705

at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:174)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:431)
at COM.ibm.db2.jdbc.app.DB2Connection.connect(DB2Connection.java:445)
at COM.ibm.db2.jdbc.app.DB2Connection.<init>(DB2Connection.java:354)
at COM.ibm.db2.jdbc.app.DB2ReusableConnection.<init>(DB2ReusableConnection.java:66)
at COM.ibm.db2.jdbc.DB2PooledConnection.getConnection(DB2PooledConnection.java:183)
at com.ibm.ejs.cm.pool.ConnectO.<init>(ConnectO.java:85)
at com.ibm.ejs.cm.pool.JDBC1xConnectionFactory.createConnection(JDBC1xConnectionFactory.java:42)
at com.ibm.ejs.cm.pool.ConnectionPool.createConnection(ConnectionPool.java:914)
at com.ibm.ejs.cm.pool.ConnectionPool.createOrWaitForConnection(ConnectionPool.java:846)
at com.ibm.ejs.cm.pool.ConnectionPool.findFreeConnection(ConnectionPool.java:764)
at com.ibm.ejs.cm.pool.ConnectionPool.findConnectionForTx(ConnectionPool.java:676)
at com.ibm.ejs.cm.pool.ConnectionPool.allocateConnection(ConnectionPool.java:610)
at com.ibm.ejs.cm.pool.ConnectionPool.getConnection(ConnectionPool.java:274)
at com.ibm.ejs.cm.pool.ConnectionPool.getConnection(ConnectionPool.java:269)
at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java:99)
at com.ibm.ejs.sm.util.db.DBMgr.initialize(DBMgr.java:206)
at com.ibm.ejs.sm.server.AdminServer.initializeConnectionManager(AdminServer.java:1135)
at com.ibm.ws.runtime.Server.initializeRuntime0(Server.java:943)
at com.ibm.ejs.sm.server.ManagedServer.initializeRuntime0(ManagedServer.java:407)
at com.ibm.ejs.sm.server.AdminServer.initializeRuntime0(AdminServer.java:1104)
at com.ibm.ws.runtime.Server.initializeRuntime(Server.java:882)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:391)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.ws.bootstrap.WSLauncher.main(WSLauncher.java:158)

Thanks and regards
Mithra

 

[dabump]

Hi Mithra.

This might happen because of security problems. Create a user called 'DB2Admin' and give this user full administrative rights. When starting up the websphere admin program, websphere stores its own information into the db2 database. So...what I'm trying to say, re-install websphere, and at the point where it asks you for the location of db2, provide the username and password of the 'DB2ADMIN' username you created, and also the database name to where websphere must store it's information. Websphere will then try to create this table, specified in the installation.

From the trace above, it tries to connect to the database, but can't. Also, maybe try to create the WAS40 table manually, and see what happens.

Regards
Martin Coetzee

 

[MoreFeo]

After installing WAS and before running the Admin Server you've got to execute /SQLLIB/java12/usejdbc2.bat
Hope this helps.

 

[Chowdhry]

You need to have enterprise version of DB2 . Its better to install DB2 first and then followed by WebSphere Application Server.

Uninstall existing DB2 and WebSphere Try this method. It should work then.