Try OpenEdge Now
skip to main content
Database Administration
Maintaining and Monitoring Your Database : Multi-tenant database : Database utilities : Multi-tenant aware utilities
 
Multi-tenant aware utilities
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 chapter in Part 4, "Reference." The list impacted utilities follows:
*PROUTIL specific to multi-tenant databases commands
*ENABLEMULTITENANCY
*DISABLEMULTITENANCY
*DEALLOCATE
*DATAMOVE (See Tenant DataRecovery)
*MTIDXBUILD (See Multi-tenantindex 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.