Home

 

Create IBM DB2 databases manually

Create DB2 databases with SQL scripts instead of using the Lotus Connections database wizard.
Follow this procedure if you do not want to use the database wizard to create your databases.

If the database server and Lotus Connections are installed on different systems, copy the SQL scripts to the system that hosts the database server.

The SQL scripts are located in the subdirectory...

..of the Lotus Connections set-up directory or installation media.

When you are creating a database either with the database wizard or SQL scripts, log into the system where the database is hosted with the database administrator account. The default values for DB2 are db2admin on Microsoft Windows and db2inst1 on Linux and AIX. For Oracle, the default value is oracle on AIX or Linux, and system administrator on Windows . For SQL Server, the default value is the system administrator

AIX only: Configure the AIX system that will host the DB2 databases to use the enhanced journaled file system (JFS2), which supports file sizes larger than 2 GB. To enable large files in the JFS system, perform the following steps:

  1. In the SMIT tool, select...

      System Storage Management | File System | Add/Change/Show/Delete File Systems

  2. Select the file system type to use and specify other characteristics as desired. If you choose to use a Journaled File System, set the Large File Enabled setting to true.

Perform this task for each Lotus Connections feature that you are installing.


To create feature databases

  1. Optional: (Only required if the database server and Lotus Connections are installed on different systems.) Copy the Lotus Connections SQL scripts to the DB2 database system. Authorize a user ID that can create the databases.

  2. Log into the DB2 database system with the user ID of the owner of the database instance. The user ID must have privileges to create a database, a tablespace, tables, and indexes.

  3. If you created multiple database instances, specify the user ID for the first instance.

  4. The default administrative ID for Microsoft Windows is db2admin.

  5. Start the DB2 command line processor in command mode and enter the following command:

    db2start

  6. For Activities, Blogs, Dogear, Profiles, and Home page, change to the where the SQL scripts for each feature are stored, and then enter the following command to run the script:

    db2 -tvf createDb.sql

  7. For Home page, you also need to run the following script:

    db2 -tvf initData.sql

  8. For Communities, Files, and Wikis, change to the where the SQL scripts for each feature are stored, and then enter the following command to run the script:

    db2 -td@ -vf createDb.sql

  9. Optional: (Required only if you are installing the Communities forum.) Enter the following command:

    db2 -tvf createDb_forum.sql

  10. Grant access privileges to the lcuser account for each feature:

    db2 -tvf <feature_subdirectory>/appGrants.sql

    For the Files and Wikis features, run the following command:

    db2 -td@ -vf <feature_subdirectory>/appGrants.sql

  11. Optional: (Communities forums only.) Grant access privileges to the lcuser account for forums:

    db2 -tvf <feature_subdirectory>/appGrants_forum.sql

  12. (For DB2 9.1 users only.) If you are using DB2 9.1, configure the DB2 environment.

    If you have installed Activities, Blogs, Dogear, Communities, or Profiles, run the following command in the DB2 command line processor:

    db2 -tvf <feature_subdirectory>/db291settings.sql

    If you have installed Files or Wikis, run the following command in the DB2 command line processor:

    db2 -td@ -vf <feature_subdirectory>/db291settings.sql

    The db291settings.sql file is located in...

      connections.sql/<feature_subdirectory>/DB2

    ..on the installation media.

  13. Close the DB2 command line processor.

  14. Optional: When you install Lotus Connections, the JDBC configuration page of the installation wizard asks you to provide a user ID and password for the Application User. The user ID that you specify on that page needs to have read and write access to the database. You can provide the user ID of an administrative user or you can create a dedicated user ID with fewer privileges.

 

Related tasks

Create databases with SQL scripts
Create a dedicated DB2 user

+

Search Tips   |   Advanced Search