Creating base database on a remote Db2 server

Create a base database on your remote Db2 server for your Document Processing Extension environment. If you plan to use a user-provided remote Db2 server for your Document Processing Extension environment, you must create the base database on your remote Db2 server before installing the Document Processing Extension stack.

Before you begin

Download and extract the dpedeploy tool and copy the database scripts to your database server. For more information, see Downloading and extracting the dpedeploy tool.

About this task

The provided DB scripts in ibm_assets/databases/DB2 folder from the dpedeploy tool can be used to both create and initialize the base database for Document Processing Extension. If you prefer to create your own database and use the scripts only to initialize the database, then the databases that you create must meet the following minimum requirements:

  • For performance reasons, create table spaces by using automatic storage rather than database-managed or system-managed table spaces.
  • Set the Db2 code to UTF-8 encoding.
  • Set the page size to 32 KB.
  • Grant the following privileges to the database user allowed to access the database.
    • CONNECT
    • DATAACCESS
    • CREATETAB

Procedure

  1. To create and initialize the base database by using the provided script.
    1. Go to the Db2 folder.
    2. Run the CreateBaseDB.sh script on the Db2 server.
      Note: The user must have privileges to run the Db2 command line and admin privileges on Db2.
  2. Manually initialize the base database if you created your own base database instead of running the CreateBaseDB.sh script.
    Note: You can skip this step if you have already created and initialized the base database by using the CreateBaseDB.sh script.
    1. Go to the Db2 folder.
    2. Run the InitBaseDB.sh script on the Db2 server.
      Note: The user must have privileges to the Db2 command line and admin privileges on Db2.
    3. When prompted, enter the following information:
      1. Name of the base database that you created.
      2. Name of an existing database user with read and write privileges for the base database

What to do next

Go to and complete the steps in Installing Document Processing Extension.