Prepare IBM DB2 for i
DB2 is integrated with IBM i. However, the databases and users required for WebSphere Portal must be created.
- ensure the DB is supported by this version of WebSphere Portal. Refer to the list of supported databases in the WebSphere Portal detailed system requirements.
What to do next
Use the Configuration Wizard to set up and configure the database to work with WebSphere Portal. Use the wizard to create custom scripts that you or the database administrator can use to configure the database. We can also use the wizard to automatically set up and configure the database. The wizard creates instructions and scripts based on the selections and provided data.
When we use the wizard and provide information about the database for our environment, be aware of the following considerations:
- If we choose to use one database to store all WebSphere Portal, Member Manager, and content publishing information, only one user profile is required. Additional user profiles are necessary only if using multiple IBM i systems or separate databases are required.
- Before we enter the database name (dbdomain.DbName) in the Configuration Wizard, check the database documentation for restrictions on character length.
- The Configuration Wizard uses JDBC type 4 drivers by default. The examples in the Configuration Wizard apply only to JDBC type 4 drivers. We can change the default selection in the Configuration Wizard to JDBC type 2 during step 2, Customize values. If we select JDBC type 2, apply these examples to the configuration:
Field label in Configuration Wizard Example value Database name *LOCAL/wpsdb Database URL jdbc:db2:*LOCAL/wpsdb DB2 for IBM i library /QIBM/ProdData/OS400/Java400/ext/db2_classes16.jar DB2 for IBM i driver class name com.ibm.db2.jdbc.app.DB2Driver