PROUTIL ENABLELARGEKEYS qualifier

Enables large key entry support for a database migrated to Release 10.1B or higher from an earlier version.

proutil db-name -C enablelargekeys

Parameters

db-name

Specifies the name of database to enable for large key entry support.

Large key entries increase the amount of user data in an index from approximately 200 bytes to approximately 1970 bytes.

Notes

Large keys are supported on databases with 4K or 8K block sizes.

Large key support cannot be disabled.

Large key support can cause run time problems for older clients. A client from 10.1A or earlier cannot update or delete any row or field that is referenced by a large index key. PROUTIL ENABLELARGEKEYS issues a warning and requires confirmation before executing, as shown in the following example:

$ proutil docsample -C enablelargekeys
OpenEdge Release 10.1B1P as of Mon Oct 23 19:54:20 EDT 2006

If you enable large key entries support for this database, it may cause runtime issues to pre-10.1B clients that connect to this database.
Do you really want to enable large keys support? (y/n) (13929)
y
Large Key Entry Feature enabled for database docsample. (13700)
$

If the database is online when enabling large keys, only newly connected clients will be able to perform operations with large keys.

The database may be online or offline when enabling large keys.

Databases with 4K and 8K block sizes, created with Release 10.1B or higher, have large key support by default.

There is no need to rebuild indexes after enabling large keys.