WebSphere eXtreme Scale (formerly Data Grid), Version 6.1
             Operating Systems: AIX, HP-UX, Linux, Solaris, Windows


Configure your database

In order to run the sample, create two databases, either in one database node or two database nodes. In the production mode, these database nodes are usually deployed in different machines. However, for this example, you can create two databases in one database node. These two databases have same table schemas, security configuration, etc.

DB2 UDB is used as a sample.

[For z/OS operating system] The following example is for DB2 UDB only. DB2 for z/OS details are not shown.

Create two DB2 databases. For example, two databases with the names westtest and easttest. You need a user ID and password to connect to them. In this example, dbuser1 and xxxxxx are used as the user name and password. Note that the user ID and password to connect to these two databases are the same.

Extract the ProxyDSAccountEJB.jar from the <WAS_BASE_HOME>\installableApplications\D_ProxyDSAccountSample.ear, and then extract the META-INF/Table.ddl from the ProxyDSAccountEJB.jar. Run the following commands to create tables in the two databases:
>db2 create database westtest
>db2 create database easttest
>db2 connect to westtest user dbuser1 using xxxxxx
>db2 -tvf Table.ddl
>db2 connect to easttest user dbuser1 using xxxxxx
>db2 -tvf Table.ddl



Related concepts
Configure Proxy DataSource in WebSphere eXtreme Scale
Reference topic    

Terms of Use | Feedback

Last updated: Oct 30, 2009 6:09:57 PM EDT
http://publib.boulder.ibm.com/infocenter/wxdinfo/v6r1/index.jsp?topic=/com.ibm.websphere.dataint.doc/info/WPF51/rwpfconfigureDB.html