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. For the complete syntax of each utility, see the corresponding topic in Part 4, "Reference." The list impacted utilities follows:

• PROUTIL specific to multi-tenant databases commands
  • ENABLEMULTITENANCY
  • DISABLEMULTITENANCY
  • DEALLOCATE
  • DATAMOVE (See Tenant Data Recovery)
  • MTIDXBUILD (See Multi-tenant index rebuild)
• 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 OpenEdge Identity Management. The utilities accept the -U/-P parameters. If no username and password are included, the utilities trust the underlying operating system authentication and authorization. For more information on Identity Management, see OpenEdge Getting Started: Identity Management.