Optimize versioned databases

While migrating tenants or single databases, the databases are optimized on the fly. As the optimization can be time-consuming, only the workspace content will be optimized automatically.

In order to ensure database consistency for all change lists, you are recommended to optimize versioned databases after migration manually. During this procedure the database will not be available for users.

Prerequisite

You log in as a system user.

Procedure

  1. Start ARIS Server Administrator from any client computer and access the databases on the server:

    Click Start > Programs > ARIS > Administration > ARIS Server Administrator if you accepted the program group suggested by the installation program. Under a Linux operating system, execute the arisadm.sh shell script instead. The command prompt opens and ARIS Server Administrator is launched in interactive mode.

  2. Establish a connection to the server and tenant:

    Syntax: server <server name>:<port number> <tenant> <user name> <password>

    Example: server arissrv:1080 default system manager

    ARIS Server Administrator is connected to the server.

  3. Run the prepareoptimizedb command to check the versioned database. By default all change lists and the workspace are checked for issues. Enter, for example:

    prepareoptimizedb my_migrated_database1

    If no issue is detected the database is optimized already, and no further action is required.

    If an issue is detected the needs optimization message is displayed. In this case a optimization file is generated and downloaded automatically. It is a good idea to copy the path and file name from the command prompt. Use this copied string later as parameter with the optimizedb command.

  4. Lock the database. It is essential that nobody uses the database while optimizing. Enter, for example:

    lockdb my_migrated_database1

    The database is locked and ready for optimization.

  5. Enter, for example:

    optimizedb <copied path to optimization file>

    The database are optimized. It can be made available for users again.

  6. Enter, for example:

    unlockdb my_migrated_database1

The database is optimized completely and available to authorized users. Every command's output can be retraced reading the dboptimization.log log file.