The PROUTIL CONV1213 qualifier is used to convert an OpenEdge Release 12 database to OpenEdge Release 13 format. This utility performs structural and schema-level updates required for compatibility with the new release. For detailed instructions on performing the conversion, see Convert an OpenEdge Release 12 Database to OpenEdge Release 13.

To convert replication source and target databases from OpenEdge Release 12 to OpenEdge Release 13, see PROUTIL CONV1213 REPLSOURCE qualifier and PROUTIL CONV1213 REPLTARGET qualifier.

Syntax

proutil db-name -C conv1213

Parameter

db-name

Specifies the name of the OpenEdge Release 12 database to be converted.

To convert from OpenEdge Release 12 to Release 13, you must perform a full database conversion with CONV1213. Conversion must be performed when the database is offline, and cannot be interrupted. If there is an abnormal exit from CONV1213, you must revert to a backup of your OpenEdge Release 12 database.

Before performing the conversion, you must:

  • Back up your OpenEdge Release 12 database using a Release 12 backup utility.
  • Verify that the database is not in use.
  • Disable after-imaging with Release 12.
  • Disable two-phase commit with Release 12.
  • Disable Hardware Security Module (HSM) feature in the database.
  • Truncate the BI file with Release 12.
    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.
The PROUTIL CONV1213 qualifier performs the following validations and updates:
  • Confirms that the database is in OpenEdge Release 12 format.
  • Verifies that the before-image file is truncated.
  • Prompts the user to confirm that a backup has been performed.
  • Replaces 32-bit time values with 64-bit equivalents in the master block, extent headers, and after-image and before-image headers and notes.
  • Converts the master block to OpenEdge Release 13 format.
  • 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_ch = "_Value"
  • Updates the SQL width of the _user._password field to 1024.
  • Removes the following obsolete feature bits:
    • Large File
    • 64-bit DBKEYS
    • Large Keys
    • 64-bit Sequences.
    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.
  • Enhances security of the TDE keystore.
  • Disables after-imaging if your database has after-imaging enabled and issues a message.
  • Temporarily disables auditing during the conversion if your database has auditing enabled but re-enables it before the conversion completes.
  • Temporarily disables database encryption if your database has encryption enabled, thereby preventing access to the encryption cache and any encrypted data in the database. Encryption is re-enabled when the conversion completes, and access to the encryption cache and any encrypted data restored.
  • Temporarily disables Change Data Capture (CDC) if your database has CDC enables, thereby preventing CDC cache allocation and loading. CDC is re-enabled when the conversion completes.
  • Updates all schemas in your database to the latest version and adds new schema tables, if applicable.
  • Recreates all VSTs in your database and updates them to the latest version and adds new VSTs, if applicable.
  • Populates new auditing events.

Notes

  • The conversion must be performed offline and should not be interrupted.
  • After successfully completing the conversion, back up your OpenEdge Release 13 database as soon as possible.