IBM i stand-alone: Preparing DB2 for IBM i

To setup a remote IBM® DB2® for i database, create user IDs and databases on a remote server. Tasks are provided to assist with creating the user IDs and the databases. Before you can use the tasks, you must modify properties files.

Prerequisites
Preparing your IBM i operating system in a stand-alone environment
Installing WebSphere Portal on IBM i
  1. IBM i stand-alone: Modifying properties for DB2 for IBM i
    Learn how to modify the wkplc.properties, wkplc_dbdomain.properties, and wkplc_dbtype.properties files to work with your database. Modify these property files before running tasks to create databases, create users, or transfer data.
  2. IBM i stand-alone: Creating groups and assigning users for IBM DB2 for i
    Before transferring the databases to IBM DB2 Universal Database™ for i, you must first create the users and groups you have specified in wkplc_dbdomain.properties and assign the users to their corresponding group. The user and group names must comply with both the database management system software requirements and WebSphere Portal requirements.
  3. IBM i stand-alone: Creating user profiles for DB2 for IBM i
    View information on setting up user profiles for IBM DB2 for i to work with WebSphere Portal.
  4. IBM i stand-alone: Creating databases on DB2 for IBM i
    A remote database resides on a different system than WebSphere Portal. When you use a remote server, you must manually create the databases that are required by WebSphere Portal.
  5. IBM i stand-alone: Granting privileges to IBM DB2 for i database users
    Configuration and runtime database users are granted a different set of privileges, depending on whether these users are schema owners or not. You can create a copy of the SQL scripts and edit this copy to manually grant permissions to configuration and runtime database users.
  6. IBM i stand-alone: Configuring the portal to use DB2 for IBM i
    View the steps to manually transfer data to the IBM DB2 Universal Database for i database you have set up. As an alternative to the manual database transfer procedure described here, you can use the configuration wizard to complete the database transfer task. However, you cannot specify all settings through the configuration wizard. For example, regardless of the method used to transfer data, you must run a configuration task to create JMS resources as described in this topic.
  7. IBM i stand-alone: Verifying the DB2 for IBM i configuration
    After WebSphere Portal is configured to work with your database, test the database connection to ensure that it operates correctly.
  • Parent topic: Setting up a stand-alone production server on IBM i
  • Previous topic: Stand-alone: Performing post-installation tasks on IBM i
  • Next topic: IBM i stand-alone: Preparing a remote Web server