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 Identity Management. 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.