You can manually install database tables for Business Space powered by WebSphere® on a remote
database server with scripts that are generated by the installation
program. If you are using a deployment environment, or your database
is remote, you must install these tables after configuring Business Space.
Before you begin
Before you complete this task, you must have completed
the following tasks:
- Installed the product.
- Configured a profile, and configured Business Space on that profile.
- Stopped the server.
If you are using DB2® for z/OS® and the required resources have not already
been set up as part of the core product installation, complete the
following additional items before you begin this task:
- Create a TEMP database and a TEMP table space to contain
the declared temporary tables for processing scrollable cursors.
- Create a dedicated STOGROUP to contain the Business Space data.
Procedure
- Log on to the database server as a user with read and write
access on the database. For i5/OS®, log on with the user ID that is in the
authentication alias.



Connect to the database.
- Locate the script in the profile you most recently configured,
and save it to a location on the same system with the database.
By default, the scripts are located in the following directory: profile_root/dbscripts/BusinessSpace/database_product_name/database_name.
The scripts are located in the profile for the server or cluster that
you most recently configured. If you used the Deployment Environment
Configuration wizard, the scripts are located in the deployment manager
profile. When configuring a remote database, copy the scripts from
the system where your product is installed
to a place on the remote system.
For WebSphere Process
Server for z/OS and WebSphere Enterprise Service
Bus for z/OS: If you are
configuring DB2 for z/OS, you can use the createDB.sh script
to configure the Business Space database tables with all other database
objects in one database. For more information, see "Creating DB2 database objects using the createDB.sh
script" in the WebSphere Process
Server for z/OS documentation.
Alternatively, you can run the createTable_BusinessSpace.sql script
using a DB2 for z/OS utility such as SPUFI or DSNTEP2. For more
information, see "Creating the DB2 database
and storage groups using DButility.sh, SPUFI, or DSNTEP2" in the WebSphere Process Server for z/OS and the WebSphere Enterprise Service Bus for z/OS documentation.



Run one of the following
commands in the command line interface for your database software. For i5/OS,
run the command from Qshell. Business Space is supported
on the DB2, Derby, and Oracle
databases listed below to be compatible with the databases you use
with your product.- DB2 : db2
-tf createTable_BusinessSpace.sql
- DB2 for i5/OS: db2 -tvf createTable_BusinessSpace.sql
- DB2 for z/OS: db2 -tf createTable_BusinessSpace.sql
- Derby: java -Dij.protocol=jdbc:derby: org.apache.derby.tools.ij
createTable_BusinessSpace.sql
- Oracle: sqlplus user/password@database_name @createTable_BusinessSpace.sql
where:
- user is a user with DBA access
- database_name is the Oracle ID, for example,
orcl



For DB2 and DB2 for z/OS, bind the command line interface
to the Business Space
database using the following commands: - db2 connect to database_name
- db2 bind DB2_installation_directory\bnd\@db2cli.lst
blocking all grant public
- db2 connect reset
where:- database_name is the name of the Business Space database
- DB2_installation_directory is the directory
where DB2 is installed
- Start the server.
What to do next
- Update the endpoints for widgets that you want to be available
in Business Space.
- Set up security for Business Space and the widgets
that your team is using.