Create IBM DB2 databases manually 

Create IBM DB2 databases with SQL scripts instead of using the IBM Connections database wizard.


Before you begin


Use this procedure if you do not want to use the database wizard to create your databases.

The SQL scripts are located in a compressed file called connections.sql.zip|tar, located in the Lotus_Connections_install/LotusConnections/connections.sql directory of the IBM Connections set-up directory or installation media. Extract this file before proceeding. When extracted, the SQL scripts are located in the LotusConnections/connections.sql/<application_subdirectory> directory of the IBM Connections set-up directory or installation media, where <application_subdirectory> is the directory that contains the SQL scripts for each application. If you are using AIX , see the note in the Preparing the database wizard topic about decompressing TAR files.

Note:

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

(AIX only) Configure the AIX system that hosts 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 you want to use and specify other characteristics as wanted. If you use a Journaled File System, set the Large File Enabled setting to true.

See the AIX documentation for more options.

Notes:


About this task


You must perform this task for each IBM Connections application that you are installing.

Note: To capture the output of each command to a log file, append the following parameter to each command: >> /<file_path>/db_<application>.log

where <file_path> is the full path to the log file and <application> is the name of the log file. For example:

db2 -tvf createDb.sql >> /home/db2inst1/db_activities.log

Ensure that you have write permissions for the directories and log files.

To create the application databases...


Procedure

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

  2. Log in to 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.

      Notes:

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

      • The default administrative ID for Microsoft Windows is db2admin.

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

      db2start

  4. For Home page and Profiles, change to the directory where the SQL scripts for each application are stored, and then enter the following command to run the script:

      db2 -tvf createDb.sql

  5. For Home page, run the following script:

      db2 -tvf initData.sql

  6. For Activities, Communities, Blogs, Bookmarks, Files, Forums, and Wikis, change to the directory where the SQL scripts for each application are stored, and then enter the following command to run the script:

      db2 -td@ -vf createDb.sql
      Note: The Bookmarks SQL scripts are stored in the dogear directory.

  7. Run the following command to grant access privileges to the lcuser account for the Home page and Profiles databases:

      db2 -tvf <application_subdirectory>/appGrants.sql

  8. Run the following command to grant access privileges to the lcuser account for the Activities, Communities, Blogs, Bookmarks, Files, Forums, and Wikis databases:

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

  9. Run the following commands to generate statistics for the Home page database:

      db2 -tvf <application_subdirectory>/reorg.sql

      db2 -tvf <application_subdirectory>/updateStats.sql

  10. Close the DB2 command line processor.

  11. Optional: When you install IBM 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 must 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. See the Create a dedicated DB2 user topic for more information.


What to do next


(DB2 for Linux on System z only.) To improve database performance, enable the NO FILE SYSTEM CACHING option. For more information, see the Enable NO FILE SYSTEM CACHING for DB2 on System z topic.


Parent topic

Create databases with SQL scripts


Related tasks


Preparing the database wizard


April 11, 2011 9:47:24 AM
   

 

Apr 11, 2011 9:47:24 AM Added note about the dogear directory. 1

});