The PROUTIL CONV1213 utility converts the schema and structure of an OpenEdge Release 12 database to OpenEdge Release 13. This conversion is required to support enhancements introduced in OpenEdge Release 13.
Note: You must perform the conversion offline. Once started, the conversion process should not be interrupted.

Conversion prerequisites

Before running the PROUTIL CONV1213 conversion utility, ensure the following conditions are met:
  • The database must be a valid OpenEdge Release 12 database. Databases from earlier releases are not supported.
  • A full backup of the database must be completed. If the user responds no when prompted to confirm whether a backup of the OpenEdge Release 12 database has been performed, the database remains unaltered.

Conversion procedure

To convert the schema of an OpenEdge Release 12 database:

  1. Back up the database using OpenEdge Release 12.
    Note: There is always a chance that your schema could become corrupt during conversion. If the conversion fails, your database cannot be recovered. If this happens, you must restore the backup copy of your database and begin the conversion again.
  2. Verify that the database is not in use.
  3. Use the PROUTIL TRUNCATE BI utility from OpenEdge Release 12 to truncate the before-image file of a Release 12 database. The before-image file of a Release 12 database cannot be truncated using the PROUTIL utility from OpenEdge Release 13.
    Note: If you forgot to truncate the OpenEdge Release 12 database after installing OpenEdge Release13 in the new installation and need to convert your OpenEdge Release 12 databases to OpenEdge Release 13, you should:
    1. Copy the 128_dbutil utility from <install-dir>/bin/128dbutils/ to <install-dir>/bin.
    2. Use this utility to truncate the BI areas on the databases before starting the conversion process.
    This step is required because the External Security Administration Manager (ESAM) does not support running utilities from subdirectories under <install-dir>/bin.
    For example, if you attempt to run:
    $DLC/bin/128dbutils/128_dbutil sports -C truncate

    Where, $DLC is an environment variable that points to the OpenEdge installation directory and in this case, it resolves to <install-dir>.

    You may encounter the following error:
    ESAM action error (00000009): {00000045} The client's DLC path does not appear to be an OpenEdge installation
ESAM validation of DLC failed.
    Workaround: Copy 128_dbutil to <install-dir>/bin and run it from there.
  4. If two-phase commit is enabled, disable it using the Release 12 PROUTIL 2PHASE END utility. If you do not disable it manually, PROUTIL CONV1213 automatically turns it off.

    For information, see PROUTIL 2PHASE END qualifier.

  5. Verify your Release 12 backup, and then install OpenEdge Release 13, if you have not already done so.

    For information about how to install OpenEdge, see Before You Install.

  6. If Hardware Security Module (HSM) is enabled, disable it in OpenEdge Release 12.

    For more information about how to disable HSM, see PROUTIL EPOLICY MANAGE qualifier.

  7. To convert a non-replication-enabled database, run:
    proutil db-name -C conv1213
    The conversion utility performs the following actions:
    • Replaces 32-bit time values with 64-bit equivalents in the master block, extent headers, and after-image and before-image headers and notes.
    • Updates the SQL width of the _user._password field to 1024.
    • During conversion to OpenEdge Release 13, the SQL engine automatically creates a default _sql_properties record to support internal encryption and decryption. If the required record does not exist, the following entry is inserted:
      INSERT INTO Pub."_sql_properties" ("_Properties", "_Attribute", "_Tblid", "_value_ch")
VALUES (15, 9, 0, "AES_CFB_128");
      If a _syscharstat record exists with _Tblid = 0, _Colid = 0, and _Property = 9, it is deleted. After deletion, a new _sql_properties record is created with:

      • _Properties = 15

      • _Attribute = 9

      • _Tblid = 0

      • _value_cn = "_Value"

    • Removes the following obsolete feature bits:
      • Large File
      • 64-bit DBKEYS
      • Large Keys
      • 64-bit Sequences
      Note: Starting from OpenEdge Release 13, these features are always supported. As a result, they are no longer maintained as conditional features and have been removed from the database feature list.
    • Converts the master block to OpenEdge Release 13 format.
    • Enhances security of the TDE keystore.
    After conversion, the database cannot be opened in OpenEdge Release 12.

  8. After you have successfully converted your database, back up your OpenEdge Release 13 database using PROBKUP in the same release.

For information, see PROUTIL CONV1213 qualifier.