Configuring the Entity Move/Rename utility for a Db2 database

You must configure parameters in the OpenPages® Entity Move/Rename utility before you use it in an IBM® Db2® database environment.

Procedure

  1. Go to the Entity Move/Rename utility installation location as follows:

    OP_Home|aurora|bin|batch_entity_move_rename_relative

  2. Open the batch-entity-move-rename.ini configuration file for editing.
  3. Specify appropriate values for the following parameters for a Db2 database environment:
    Table 1. Parameters for a Db2 database in the batch-entity-move-rename.ini file:

    Parameter Name

    Description

    server_name

    Db2 database server.

    port_number

    Db2 service port number.

    db_Name

    OpenPages database name on Db2.

    user_name

    OpenPages database user name.

    password

    OpenPages database user password.

    data_format

    Format of the input file to the utility.

    Example: csv or unicode-text.

    input_file

    Name of the input file (including extension).

    Example: ‘Sample-batch-entity-move-rename.txt’

    code_page

    Code page that is used in the Db2 database.

    If the data_format parameter is set to the following value:
    • csv saved from Microsoft Excel, it is encoded in ANSI, then the code page must be set to 1252.
    • unicode-text and encoded in UTF-8 without BOM, then the code page must be set to 1208.

    skip_rows

    The number of rows in the input files to skip on load.

    Example

    If the first row of the file:

    • Contains a list of column names, set the value to '1'.
    • Does not contain a list of column names, set this value to '0'.
  4. Save and close the batch-entity-move-rename.ini configuration file.
  5. Prepare the input file. See Prepare the input file for the Entity Move/Rename utility.