+

Search Tips   |   Advanced Search

AIX stand-alone: Modify DB2 database properties


Modify the appropriate properties files before transferring the data from the default database to the DB2 database.

Work with properties files:

For JDBC Type 2 drivers, perform additional steps.

See the Type 2 configuration section for more instructions.

  1. Make backup copies of the following files:

    • WP_PROFILE/ConfigEngine/properties/wkplc.properties

    • WP_PROFILE/ConfigEngine/properties/wkplc_dbdomain.properties

    • WP_PROFILE/ConfigEngine/properties/wkplc_dbtype.properties

    • If we are transferring from a database other than Derby:

      WP_PROFILE/ConfigEngine/properties/wkplc_sourceDb.properties

    Default values are listed in these files. Unless otherwise noted, all values are of type alphanumeric text string. Set the appropriate values for each instance of each property. In wkplc_dbdomain.properties, most properties are repeated for each domain.

  2. Set properties in wkplc_dbdomain.properties

    1. dbdomain.DbType=db2

    2. dbdomain.DbName=domain_db_name

      DB2 database names cannot exceed eight (8) characters.

      • This value is also the database element in dbdomain.DbUrl.
      • TCP-IP alias for the database.

    3. dbdomain.DbSchema=domain_schema_name

      Some database management systems have schema name restrictions.

    4. dbdomain.DataSourceName=data_source_name

      Do not use the following reserved words:

      • releaseDS
      • communityDS
      • customizationDS
      • jcrDS
      • lmdbDS
      • feedback

    5. dbdomain.DbUrl=JDBC_DB_URL

      The value must conform to the JDBC URL syntax specified by the database.

      The database element of this value should match the value of DbName.

    6. For dbdomain.DbUser, set the user ID for the database configuration user.

    7. For dbdomain.DbPassword, set the password for the database configuration user.

    8. For dbdomain.DbConfigRoleName, set the name of the group for database configuration users. Database rights are granted to this group instead of individuals. The user specified for dbdomain.DbUser must be assigned to this group.

    9. Optional: For dbdomain.DbRuntimeUser, set the user ID of the database user that should be used by WebSphere Portal to connect to the database at runtime. If no value is specified for this setting, the database configuration user will be used to connect to the databases at runtime.

    10. If dbdomain.DbRuntimeUser is specified, set dbdomain.DbRuntimePassword to be the password of the runtime database user.

    11. For dbdomain.DbRuntimeRoleName, set the name of the group for database runtime users. Database rights are granted to this group instead of individuals. The user specified for dbdomain.DbRuntimeUser must be assigned to this group.

    12. Optional: For dbdomain.DBA.DbUser.

      DB administrator user ID for privileged access operations during database creation and setup. Required.if you run the create-database and setup-database ConfigEngine tasks . If you do not need this parameter, we can either accept the default value or leave blank.

    13. Optional: For dbdomain.DBA.DbPassword, set the database administrator password for privileged access operations during database creation. If you do not need this parameter, we can either accept the default value or leave blank.

    14. For dbdomain.DbNode, type the value for the database node name. Set this value to call create-database.

      Required only for local databases.

  3. Save and close the file.

  4. Update the following properties in wkplc_dbtype.properties.

    1. For db2.DbDriver, set the name of the JDBC driver class.

    2. For db2.DbLibrary, type the directory and name of the .zip or .jar file containing the JDBC driver class.

    3. For db2.JdbcProviderName, set the name of the JDBC provided that WebSphere Portal uses to communicate with its databases.

  5. Save and close the file.

  6. Update the WasPassword value in wkplc.properties. This value is the password for the WAS security authentication used in the environment.

  7. Save and close the file.


Parent: AIX stand-alone: Set up a DB2 database
Previous: AIX stand-alone: Create groups and assign users
Next: AIX stand-alone: Create DB2 databases