AIX stand-alone: Modify database properties for DB2 for z/OS

This section provides information on how to modify wkplc.properties, wkplc_dbdomain.properties, and wkplc_dbtype.properties before running tasks to create databases, create users, or transfer data.


Prerequisites


Install DB2 for z/OS


To successfully transfer data from the JCR domain, use the DDF location value for the value of jcr.DbName field when setting up IBM DB2 Universal Databaseā„¢ for z/OSĀ®. You can locate the name of the DDF location value in the IBM DB2 Universal Database for z/OS sdsnsamp dataset, member DSNTIJUZ, or by running the following DB2command:

db2 subsystem prefix display ddf

  1. Create backups:

    • WP_PROFILE/ConfigEngine/properties/wkplc.properties
    • WP_PROFILE/ConfigEngine/properties/wkplc_dbdomain.properties
    • WP_PROFILE/ConfigEngine/properties/wkplc_dbtype.properties

    • If you 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. Print out the steps below for reference before modifying the properties files. Make sure to enter the appropriate values for each instance of each property. In wkplc_dbdomain.properties, most properties are repeated for each domain.

  2. Edit wkplc_dbdomain.properties

    1. For dbdomain.DbType, type db2_zos.

    2. dbdomain.DbName=domain_db_name

        This value is also the database element in the dbdomain.DbUrl property.

    3. dbdomain.DbSchema=domain_schema_name

    4. For dbdomain.DbNameOnZos, type the name of the WebSphere Portal database on DB2 for z/OS.

        • If running DB2 for z/OS as a remote database, set the value to the name of the remote database for the domain.

        • If WebSphere Portal is running on z/OS with DB2 for z/OS, set the value equal to the value of DbName.

    5. For dbdomain.DataSourceName, type the name of the data source that WebSphere Portal uses to communicate with its databases.

        Do not use the following reserved words:

          releaseDS
          communityDS
          customizationDS
          jcrDS
          lmdbDS

          feedback

    6. dbdomain.DbUrl=jdbc_db_url

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

    7. dbdomain.DbUser = database configuration user.

    8. dbdomain.DbPassword = password for database configuration user.

    9. dbdomain.DbConfigRoleName = 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.

    10. Optional. For dbdomain.DbRuntimeUser, type 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.

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

    12. For dbdomain.DbRuntimeRoleName, type 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.

    13. For dbdomain.DbTablespace, type the name of the DB2 for z/OS tablespace.

    14. For dbdomain.DbStorageGroup, type the name of the storage group for the database.

    15. For dbdomain.DbVolumes, type the volumes for the database.

    16. For dbdomain.DbVcat, type the VCAT for the database.

    17. For dbdomain.Db4KBufferPoolName, type the 4K bufferpool name for the database.

    18. For dbdomain.Db32KBufferPoolName, type the 32K bufferpool name for the database.

    19. For dbdomain.DbIndex4KBufferPoolName, type the 4K bufferpool name for the database.

        If you choose to use the default bufferpool value BP3, verify that this bufferpool is active.

    20. For dbdomain.TablespaceTrackMod , set the value to determine TRACKMOD attribute of all tablespaces to use the specified value.

        Refer to the DB2 for z/OS documentation before changing this value.

  3. Save and close the file.

  4. Update the following properties in wkplc_dbtype.properties.

    1. For db2_zos.DbDriver, type the name of the JDBC driver class.

    2. For db2_zos.DbLibrary, type the directory and name of the .zip or .jar file that contains the JDBC driver class.

    3. For db2_zos.JdbcProviderName, type the name of the JDBC provider that WebSphere Portal uses to communicate with its databases.

    4. For db2_zos.DbDriverType, type the number of the driver type for the database.

  5. Save and close the file.

  6. Update the WasPassword value in wkplc.properties. Password for the WAS security authentication used in environment.

  7. Save and close the file.


Parent

Prepare DB2 for z/OS


Previous

Install DB2 for z/OS


Next topic

Create users for DB2 for z/OS

 


+

Search Tips   |   Advanced Search