Introduction

The schema utilities are operative across one or more Dimensions base databases and their use is restricted to the Dimensions System Administrator (normally user dmsys). They are accessed through the dmdba tool, unless indicated otherwise.

The schema utilities enable the administrator to perform the following tasks:

- Start, stop, and restart Dimensions through the dm_control standalone tool.

- Create a new base database.

- Delete an existing Dimensions base databases.

- List all Dimensions base databases.

- Export the Dimensions process model for a database to a file (this fie can then be used when creating a new database to base the new database on the same process model).

- Reset the sequence value for a currently connected base database.

- Change the passwords for databases.

- Report the space usage of Dimensions tablespaces.

- Increase database space available to a tablespace.

- Manage statistics for the database.

- Install report views into a base database.

- Delete report views from a base database.

- Grant to a user the right to access the report views in a base database.

- Revoke from a user the right to access the report views in a base database.

- List all users who have been granted the right to access the report views in a base database.

- Grant to a user the right to access the report views in a base database.

- Revoke from a user the right to access the report views in a base database.

- Migrate a Serena-Supplied Runtime RDBMS or Oracle Enterprise MBCS encoded database to UTF-8.

- Configure connection pooling,. These actions are executed using Dimensions standalone tools.

- Displaying connection pooling statistics. These actions are executed using Dimensions standalone tools and the Administration Console.

- Managing remote jobs. These actions are executed using the Administration Console.

- Administering Dimensions users. These actions are executed using Dimensions dmcli and the Administration Console.

- Backing up item libraries.

For details on how to launch the dmdba tool and connect to a particular Dimensions base database, see the Administration Guide.

This topic assumes that the dmdba tool has been launched and connection has been made to the relevant base database.

NOTES

- For the system administration schema utilities described in this chapter, when dmdba is used, the connection must be, by default, to the SYSTEM base database unless stated otherwise. However, if you are using a "locked down" Oracle Enterprise where you cannot use the Oracle account SYSTEM for DMDBA commands, you can set up another Oracle account and grant it the requisite privileges. For details, see general prerequisites in the Administration Guide.

- Do not attempt to use RDBMS-specific commands to perform functions similar to CRDB, DLDB, LSDB, or EXPM.

- The individual dmdba tool commands accept hyphen (-) as a continuation character if you want to type parameters on more than one line. Each continuation line will begin with a right angle-bracket (>).

- The dmdba tool also supports the limited processing of SQL statements for querying and update purposes. The use of dmdba in this mode is not generally discussed in this guide (the ability to process SQL statements is primarily intended to enable experienced RDBMS DBAs to troubleshoot database problems).

- If you specify a UNIX path in a Dimensions command in the dmdba tool you must enclose it in double quotes otherwise the command will not recognize the path. For example:

SYSTEM> expm "/tmp/payroll_01.exp" payroll /basedb=intermediate