Database utilities

Database utility changes in support of multi-tenancy fall into three categories: unchanged, indirectly changed, and multi-tenant aware.

Unchanged database utilities continue to operate across the database, and are not impacted by multi-tenancy. These utilities include:

Backup and restore

After-imaging and Replication

Failover clusters

Prostrct

Transparent Data Encryption

Auditing is a utility that is indirectly changed. The mechanics of how auditing is managed remain unchanged, but auditing has the following changes:

New audit policies and auditing events are added and extended to support multi-tenancy. An incremental audit policy, multi-tenant.xml, is included in the %DLC%/auditing directory. The full auditing policy will also have the incremental one appended to it.

Audit event triggers are included in the implementation of the new enable and disable multi-tenant feature commands in PROUTIL.

Existing database record auditing event triggers are updated to include the tenant-name information.

Tenant aware utilities allow the database administrator to execute the utilities on a per-tenant, per-group, or database-wide basis. Database utilities that can manipulate and display data based on multi-tenant characteristics are added or updated. The list of impacted utilities follows:

New PROUTIL commands

ENABLEMULTITENANCY

DISABLEMULTITENANCY

DEALLOCATE

IDXDEACTIVATE

Modified PROUTIL commands:

BULKLOAD

DBANALYS/IDXANALYS/TABANALYS

DESCRIBE

DISPTOSSCREATELIMITS

DUMP/DUMPSPECIFIED

IDXACTIVATE

IDXBUILD/IDXCHECK/IDXFIX

IDXDEALLOCATE

IDXMOVE

LOAD

Create and Toss limits (SETAREACREATELIMIT, SETAREATOSSLIMIT, SETLOBCREATELIMIT,SETLOBTOSSLIMIT,SETTABLECREATELIMIT,SETTABLETOSSLIMIT)

TABLEMOVE

VIEWB2

DBTOOL

SQLDUMP/SQLLOAD/SQLSCHEMA

PROMON

The OpenEdge RDBMS and utilities fully support the authentication and authorization enhancements that are part of the Identity Management enhancements to OpenEdge Release 11.0 and higher. The utilities accept the -U/-P parameters. If no user name and password are included, the utilities trust the underlying operating system authentication and authorization.