| Author |
Message
|
| emileke |
 Posted: Fri Sep 21, 2007 6:13 am Post subject: WESB DB2 creation and population scripts |
 |
|
Centurion
Joined: 19 Aug 2001
Posts: 110
Location: South Africa
|
Hi All,
I am installing and configuring WESB outside of Process Server, in other words, we bought WESB without WPS. I cannot find the scripts to create and populate the DB2 database for the standalone product.
Anybody knows where I can find them?
I have searched the entire box where I installed the product.
_________________
Emile M Kearns |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Fri Sep 21, 2007 6:58 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
Hi
Please let me know what is the version of the ESB that you are using
is it the Advanced ESB or the normal ESB
Thanks and Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| emileke |
| Posted: Fri Sep 21, 2007 8:21 am Post subject: |
|
|
Centurion
Joined: 19 Aug 2001
Posts: 110
Location: South Africa
|
WESB 6.0.2
DB2 8.2
Not Message Broker(which I believe is referred too as the Advanced ESB), Websphere Enterprise Service Bus
_________________
Emile M Kearns |
|
| Back to top |
|
|
| emileke |
| Posted: Fri Sep 21, 2007 9:32 am Post subject: |
|
|
Centurion
Joined: 19 Aug 2001
Posts: 110
Location: South Africa
|
Here is the error I get at startup time:
CWSIS0002E: The messaging engine encountered an exception while starting. Exception: com.ibm.ws.sib.msgstore.PersistenceException: CWSIS1501E: The data source has produced an unexpected exception: java.lang.IllegalStateException: CWSIS1529E: The column, DATA, was not found in the table, WAS.SIB000, as expected.
_________________
Emile M Kearns |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sat Sep 22, 2007 5:16 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20767
Location: LI,NY
|
The messaging engine is not the WESB. They should have separate DB2 stores....
WAS SIBUS Messaging Engine is a full java J2EE messaging engine that can interact with MQ. It's persistency store is usually an RDBMS (DB2)
Enjoy 
_________________
MQ & Broker admin
Last edited by fjb_saper on Sat Sep 22, 2007 6:46 pm; edited 1 time in total |
|
| Back to top |
|
|
| emileke |
| Posted: Sat Sep 22, 2007 11:43 am Post subject: |
|
|
Centurion
Joined: 19 Aug 2001
Posts: 110
Location: South Africa
|
Not sure what the last post was about but I think I have the answer, I will implement it on Tuesday and will report back on Wednesday as Monday is a public holiday in RSA.
My sincere thanks to everybody and their ideas.
_________________
Emile M Kearns |
|
| Back to top |
|
|
| emileke |
| Posted: Thu Oct 04, 2007 10:07 am Post subject: |
|
|
Centurion
Joined: 19 Aug 2001
Posts: 110
Location: South Africa
|
Problem solved, needed to populate the SIB database. There is a SIBDDLGENERATOR you can run that creates the tables and this solved the problem
_________________
Emile M Kearns |
|
| Back to top |
|
|
|
|
