WebSphere brand IBM WebSphere Premises Server, Version 6.1.x

Creating the database, tablespace, tables, and data

Use this topic to manually create the database, tablespace, tables, and populate the data required for WebSphere® Premises Server. If you are using the WebSphere Premises Server installer to install and create the database, you do not need to follow these steps.

Creating the database manually

Use these instructions when a Database Administrator creates the database and tablespace manually, and then the tables and data are created during the installation of WebSphere Premises Server.

About this task

If you are using Oracle, you should have been prompted to create the SID when you installed the product. If not, refer to the Oracle documentation to set up a SID.

Note: These instructions use the database name, IBMRFID, but you can use a different database name.
Procedure
  1. Create the WebSphere Premises Server database for DB2® or Oracle.

    For a local or remote DB2 database:

    1. Open the DB2 Control Center.
    2. Right-click All Databases and select Create Database > Standard.
      1. Enter IBMRFID as the database name.
        Note: Linux® commands are case-sensitive.
      2. Select the option to Enable database for XML (Code set will be set to UTF-8). For more information on this option, refer to the DB2 information center.
    3. Click Finish. Do not fine tune the database when it is created.
    4. Exit the DB2 Control Center.
    5. (Optional) Catalog the remote database, IBMRFID, to the local machine.
    For an Oracle database, use the Database Configuration Assistant to create the new database called IBMRFID. Be sure to select the Unicode AL32UTF8 character set.
  2. Create the tablespace. You can use the SQL statements provided here or you can use the sample DDL files, amit_tablespace_db2.ddl and amit_tablespace_oracle.ddl, provided in the db_script directory on the WebSphere Premises Server CD. These DDL files can be run from a DB2 command line or from an Oracle sqlplus tool. You must update the tablespace file name and database installation path and make sure the directory and file can be created before running the DDL files or SQL statements.

    For DB2:

    -- Drop tablespaces and buffer pool
    DROP TABLESPACE LONGTABLESPACE;
    DROP TABLESPACE LONGTEMPTABLESPACE;
    DROP BUFFERPOOL "LONGBUFFPOOL";
    
    -- create tablespaces and buffer pool
    CREATE BUFFERPOOL "LONGBUFFPOOL"  SIZE 10000 PAGESIZE 32768 NOT EXTENDED STORAGE;
    CREATE REGULAR TABLESPACE LONGTABLESPACE IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 32768 
    MANAGED BY DATABASE USING (FILE 'C:\DB2\LONGTABLESPACE1' 6400)	 EXTENTSIZE 8 PREFETCHSIZE AUTOMATIC 
    BUFFERPOOL LONGBUFFPOOL OVERHEAD 12.670000 TRANSFERRATE 0.180000 DROPPED TABLE RECOVERY ON;
    CREATE SYSTEM TEMPORARY  TABLESPACE LONGTEMPTABLESPACE PAGESIZE 32 K  MANAGED BY SYSTEM  USING 
    ('C:\DB2\LONGSYSTMP' ) EXTENTSIZE 8 OVERHEAD 12.67 PREFETCHSIZE 8 TRANSFERRATE 0.18 BUFFERPOOL  
    LONGBUFFPOOL ;

    For Oracle:

    -- Drop tablespaces
    DROP TABLESPACE LONGTABLESPACE INCLUDING CONTENTS AND DATAFILES;
    
    -- create tablespaces and buffer pool
    CREATE BIGFILE TABLESPACE "LONGTABLESPACE"
    	DATAFILE 'C:\oracle\product\10.2.0\ORADATA\LONGTABLESPACE.ORA' SIZE 300M REUSE LOGGING EXTENT 
    MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
  3. When installing WebSphere Premises Server, select the option to create tables and populate the data for the database.

Creating the databases using scripts

Run the scripts provided in the db_script directory on the WebSphere Premises Server CD to create the database, tablespace, tables and populate data.

Before you begin

Before running the scripts be aware of the following restrictions and take the appropriate action:

  • You must be a database user (such as db2inst1 or oracle) to run the scripts on Linux.
  • For Oracle, the sqlplus executable must be added in the PATH on Linux.
  • The specified tablespace directory must exist.
  • You must have the authorization to access the specified tablespace directory if you are using Linux only.
  • The specified tablespace file cannot be used by another database.
Example

For DB2:

Windows
createIBMRFID_db2.bat dbName longTablespaceFile longTempTablespaceFile
Linux
createIBMRFID_db2.sh dbName longTablespaceFile longTempTablespaceFile

For Oracle:

Windows
createIBMRFID_oracle.bat dbUser dbPassword dbSpec longTablespaceFile 
Linux
createIBMRFID_oracle.sh dbUser dbPassword dbSpec longTablespaceFile 

The database, tablespace, table and data are created under dbSpec.


Library | Support | Terms of use

(c) Copyright IBM Corporation 2004, 2008. All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.