224 Migrating from WebSphere Application Server Community Edition to WebSphere Application Server
7.3.2 Creating users for database access
The Adventure Builder application uses two users with the user names adventure
and
adventurebuilder to access the database. To create new user accounts, use
the net user Windows command. Follow these steps:
1. Open a Command Prompt window.
2. To create the adventure account with the user ID
adventure and the password
adventure, enter the following command:
net user adventure * /add
3. At the “Type a password for the user” prompt, enter adventure.
4. At the “Retype the password to confirm” prompt, re-enter the password. A
message displays when the command completes successfully. This step
completes the creation of the user
adventure.
5. Similarly, create the
adventurebuilder user with the user ID adventurebuilder
and the password
adventurebuilder.
7.3.3 Database, data sources, and JMS resources
In this section, we discuss the steps to create a database, data sources, JMS
Queue Connection Factories, and queues.
Adventure Builder database
Adventure Builder database uses tables under two schema names, namely
ADVENTURE and ADVENTUREBUILDER. The SQL scripts necessary to create
the database tables are provided under <adventure_src>\src\SG247433\sql. Use
the following steps to create the Adventure Builder database:
1. Launch a DB2 CLP (Command Line Processor) by running the db2cmd
command using Start → Run.
2. Change the directory to <adventure_src>\src\SG247433\sql. Execute the
following commands:
db2 create db ADVNTRDB
db2 connect to ADVNTRDB user db2admin using db2admin
db2 -tvf adventure-catalog.sql
db2 -tvf adventure-builder.sql
db2 -tvf grant-permissions.sql
These commands create the database and tables, populate the database
with sample data, and grant necessary user permissions to the tables.