The best time for encrypting databases is during backup.
However, you can also back up databases in encrypted form using ARIS Server Administrator.
Prerequisite
Your user account has been assigned the Database administrator function privilege in ARIS Administration.
Procedure
You can start ARIS Server Administrator from any computer on which the ARIS Client is installed either in interactive mode or command-line mode. In command-line mode you can perform actions automatically as there are no prompts in this mode. If you log in as a system user that has at least the Database administrator function privilege in ARIS Administration for each tenant, you can manage all databases of this tenant.
You start interactive mode by clicking Start > Programs > ARIS > Administration > ARIS Server Administrator 10.0.
You start command-line mode by opening the command prompt from the directory <ARIS installation directory>\tools\ArisAdm.
You can use the following commands and options for the syntax of command-line mode:
<_arisadm><version> [<option>] <command> [<command argument 1>]
or for the syntax of interactive mode:
<command> [<command argument 1>]
Option |
Description |
---|---|
-s <server[:<port>]> |
Server on which the command should be carried out. |
-u <user> <password> |
User name and password of a system user with the required privileges. |
-l <file name> |
Enables the logging of all program operations in the specified log file. The file indicates which operation was performed at what time and with what result. |
-cf <command file> |
Starts a command file containing executable commands. |
-sc <schema context> |
Context the schema uses. ARIS is set as the default. |
-t <tenant> |
Tenant for which the command should be carried out. The default is no tenant. |
-ssl |
The SSL connection used. |
The parts of the command that are surrounded by [brackets] are optional. You can use them if necessary.
Command |
Description and syntax |
backup |
Saves a database <dbname> as an adb file in a directory <archivedir>. Syntax backup <dbname>|all <archivedir> [-p <password for encryption>] [<alternatename>] |
backupasn |
Extracts the state that corresponds to the specified change list number <asn> from a versioned database <dbname> to an ADB file in the directory <archivedir>. You can select either a change list number <asn> or 'head' as a state. 'head' represents the last versioned state Syntax backupasn <dbname>|all <archivedir> <asn>|head [-p <password for encryption>] [<alternatename>] |
backupsystemdb |
Saves the central system database that contains data such as filters, model templates, and scripts in an ADB file in a directory <archivedir>. Syntax backupsystemdb <archivedir> [<alternatename>] |
backupunversioned |
Saves a versioned database <dbname> as a non-versioned ADB file in a directory <archivedir>. Syntax backupunversioned <dbname> <archivedir> |
copy |
Copies a database from <fromdbname> to <todbname>. Syntax copy <fromdbname> <todbname> |
createdb |
Creates a new ARIS database with the name <dbname>. Syntax createdb <dbname> [versioned] |
delete |
Deletes the database <dbname>. When using the force option, the database will be deleted even if users are logged in. Syntax delete <dbname>|all [force] |
dropversions |
Deletes all versions of a database <dbname> up to the version <new min version>. Syntax dropversions <dbname> <new min version> |
encrypt |
Encrypts passwords <password> for use in batch files. Syntax encrypt <password> |
exit |
Exits the interactive mode. |
exportscript |
Exports a script of type <MACRO|REPORT|REPORTTEMPLATE|SEMCHECK|PROFILE> with the identifier <scriptid> to an export directory <exportdirectory>. Syntax <MACRO|REPORT|REPORTTEMPLATE|SEMCHECK|PROFILE> <scriptid> <exportdirectory> |
help |
help provides an overview of all commands including syntax description and possible parameters. help <command> provides help for the command you specified. Syntax help [<command>] |
importfilter |
Imports a method filter <importfile>. Syntax importfilter <importfile> |
importscript |
Imports a script <importfile> of type <MACRO|REPORT|REPORTTEMPLATE|SEMCHECK|PROFILE> in the specified category <categoryname>. Syntax importscript <MACRO|REPORT|REPORTTEMPLATE|SEMCHECK|PROFILE> <importfile> <categoryname> |
indexstate |
Displays the status of the internal cloud search data index. Syntax indexstate <database name> |
interactive |
Starts the program in the interactive mode. |
kill |
Closes the connection <sessionid> of the current tenant. Syntax kill <sessionid>|all |
killtask |
Terminates the given server activity <taskid> on instance <instanceid>, for example, a report that is unable to complete. Syntax killtask <instance id> <task id> [force] To obtain the <instanceid> and <taskid> identifiers, use the monitor command. |
list |
Lists all of the tenant's registered databases. By default, only the databases of the current schema context will be listed. When using the all option, all databases will be listed (including BO databases, for example). Syntax list [all] |
lockdb |
Locks the database with the name <dbname>, or all databases. Users can no longer log in. Syntax lockdb <dbname>|all |
maintain |
Starts the regeneration of search indexes (Cloud Search) for the specified ARIS database or all ARIS databases. Given the fact that running this command may be very time-consuming, it is recommended that you run it only if an error occurs and that you schedule a corresponding maintenance window. Syntax maintain <dbname>|all |
migrate |
Migrates an ARIS 7.1 or 7.2 database <dbname> from an ADB file <archive>, or migrates all ADB files from a directory <archivedir>. You need the password of the system user system to migrate an individual database. To migrate multiple databases the passwords must be supplied to every single database in command-line mode. Syntax migrate [<archive>|<archivedir>]|<systempassword> |
monitor |
Displays all tenant activities in progress, such as backup, XML export etc. |
rename |
Renames the database from <olddbname> to <newdbname>. When using the force option, the database will be renamed even if users are still logged in. Syntax rename <olddbname> <newdbname> [force] |
reorg |
Semantically reorganizes the database <dbname> or all databases by deleting all objects and connection definitions that do not have occurrences in any model. Options available:
Syntax <dbname>|all [options] |
restore |
Restores a database <dbname> from an ADB file <archive>, or restores all ADB/BDB files from a directory. Syntax restore <archive>|<archivedir> [<dbname>] [-p <password for decryption>] [-b <bucket ID>] |
restoresystemdb |
Restores the central system database that contains data such as filters, model templates, and scripts from a system database backup file (ADB) <archive>. You can also update the system database using the After performing an update setup, update the system configuration of each operational tenant (filters, templates, and scripts) based on the supplied system database (ARIS_DVD/Content/SystemDB/*.adb). Any content you have created is retained. Syntax updatesystemdb <archive> You can execute the command for several tenants at the same time. Syntax restoresystemdb <archive> |
restoreunversioned |
Generates a non-versioned database <dbname> from an ADB file <archive> of a versioned database. Also restores databases based on multiple ADB/BDB files of a directory. Syntax restoreunversioned <archive>|<archivedir> [<dbname>] [-p <password for decryption>] |
restoreversioned |
Generates a versioned database <dbname> from an ADB file <archive> of a non-versioned database. Also restores databases based on multiple ADB/BDB files of a directory. In case the option -no_baseline is specified, no initial version in archive is created. Syntax restoreversioned <archive>|<archivedir> [<dbname>] [-p <password for decryption>] [-no_baseline] |
schemacontext |
Changes the schema context of the current tenant. Thus, it is possible to save ARIS Optimizer databases. Possible values are aris and bo. Syntax schemacontext <new schema context> |
server |
Changes the current ARIS Server. Syntax server <server[:<port>]> <tenant> <user> [<password>] [-ssl] |
sessions |
Displays all database connections of the current tenant. Syntax sessions [byuser|bydatabase] |
set |
Displays or changes tenant settings. If no parameters are specified, all settings are displayed. If only <key> is entered, all settings are deleted. If <key> is entered together with <value>, the settings are changed accordingly. Syntax set [<key>] [<value>] |
setindexbucket |
Specifies the bucket ID for a database. Syntax setindexbucket <dbname> <bucket ID> |
setindexrank |
Sets the initial index rank for a database <dbname>. The higher the rank <rank>, the earlier the index is started during cloud search startup. The rank is a number, for example, 5. Syntax setindexrank <dbname> <rank> |
statistic |
Returns the number of all database objects. Syntax statistic <dbname>|all |
unlockdb |
Unlocks the database with the name <dbname>, or all databases. Syntax unlockdb <dbname>|all |
updatesystemdb |
After performing an update setup, update the system configuration of each operational tenant (filters, templates, and scripts) based on the supplied system database (ARIS_DVD/Content/SystemDB/*.adb). Any content you have created is retained. Syntax updatesystemdb <archive> You can execute the command for several tenants at the same time. |
userwipeout |
Clears the user identification of one or multiple deleted users from one or all databases. The attributes Last modifier, Creator, and the user name in change list descriptions is set to unknown. Syntax userwipeout <dbname>|all [<user>][,<user>] |
version |
Displays the versions of the programs and libraries in use. |
In the following example, a database is reorganized, whereby all of the objects and connections in the database that do not have an occurrence are deleted.
Warning
If you are using an object library, you should reorganize databases only when each object definition occurs in at least one overview model. If elements have already been created for later use but do not yet occur in models, these elements are deleted during the consolidation.
Reorganization in interactive mode
Syntax
server <server name>[:<port number>] <tenant> <user name>
The parts of the command that are surrounded by brackets are optional, that is, you can use them if necessary.
Example
server arissrv.eur.ag:80 default system
The password is requested.
reorg "United Motor Group"
The database is reorganized. The deleted items are listed.
Reorganization in command-line mode
Syntax
arisadm<version> -s <server name> -t <tenant> -u <user name> <password> reorg <database name>
Example
arisadm.bat -s arissrv.eur.ag -t default -u system manager reorg "United Motor Group"
The database is reorganized. The deleted items are listed.
Syntax: backup <database name> <path to archive directory> -p <password> [<database name>]
Example: backup database1 "c:\ARIS 9.0" -p DBADMIN database2
The database is backed up in the specified directory under the name you specified.
You can restore backup copies of databases on any ARIS Design Server and the server LOCAL and thus restore the database to its state before these changes were made.
When restoring encrypted databases, you must enter the password you specified when creating the backup.