Windows stand-alone: Prepare IBM DB2 for 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 we can use the tasks, modify properties files.
- Windows stand-alone: Modify properties for IBM DB2 for i
Learn how to modify the wkplc.properties, wkplc_dbdomain.properties, and wkplc_dbtype.properties files to work with the database. Modify these property files before running tasks to create databases, create users, or transfer data.- Windows stand-alone: Create groups and assign users for IBM DB2 for i
Before transferring the databases to IBM DB2 Universal Database™ for i, create the users and groups 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.- Windows stand-alone: Create user profiles for IBM DB2 for i
View information on setting up user profiles for IBM DB2 for i to work with WebSphere Portal.- Windows stand-alone: Set up IBM DB2 for i databases automatically
This section provides information on using a ConfigEngine task to create databases and users.- Windows stand-alone: Grant 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. We can create a copy of the SQL scripts and edit this copy to manually grant permissions to configuration and runtime database users.- Windows stand-alone: Configure 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, we can use the configuration wizard to complete the database transfer task. However, we 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.
- Windows stand-alone: Verify the DB2 for IBM i configuration
After WebSphere Portal is configured to work with the database, test the database connection to ensure that it operates correctly.
Parent: Windows stand-alone: Configure the portal to use a database