WebSphere

Configuring Business Space database tables

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
  1. 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.
  2. For i5/OS operating systemFor Linux operating systemFor UNIX operating systemFor Windows operating system Connect to the database.
  3. 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.

  4. This topic applies to WebSphere Process Server and WebSphere Enterprise Service Bus only 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.
  5. For i5/OS operating systemFor Linux operating systemFor UNIX operating systemFor Windows operating system 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
  6. For i5/OS operating systemFor Linux operating systemFor UNIX operating systemFor Windows operating system 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
  7. 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.

task Task topic

Terms of use | Feedback


Timestamp icon Last updated: 22 June 2010


http://publib.boulder.ibm.com/infocenter/dmndhelp/v6r2mx/topic/com.ibm.websphere.wbpm.bspace.config.620.doc/doc/tcon_bsp_inst_remotedb_ddl.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).