Configuration Variables

Owned by Anonymous
Last updated: Feb 11, 2016 by Jakub Sejba
2 min read

All the persistent variable settings are stored in the DDC, which stands for "Dbvisit Database Configuration". This comes in two flavors:

  • DDC file: a text file stored on the filesystem
  • DDC DB: a table in an Oracle database, by default the MINE database is used

The DDC DB is optional; if it is used, DDC file contains only credentials to the database:

  • DDC_DATABASE
  • DDC_USER
  • DDC_PASSWORD
  • DDC_SCHEMA
  • TNS_ADMIN
  • ORACLE_HOME
  • and instruction to load the rest from DDC DB (LOAD DDCDB command).

If the DDC DB is not used, the DDC file contain all variable settings. The main purpose of DDC DB is to enable easier setting changes – issuing a SET command updates the setting in database, obliterating the need to edit the DDC files on every machine.The DDC DB can contain any variable, except those listed above that must be known in order to connect to the DDC database. When DDC DB is used, the SET command automatically updates the DDC DB. If this is not desired, MEMORY_SET command can be used to set the setting in memory only. This is useful for temporary variable setting in scripts, when the variable change is not meant to be persistent.

To configure Replication for using DDC file instead of DDC DB see Configuring Replicate with DDC file.

DDC Commands

A DDC file can be created from the DDCDB. The command is:

CREATE DDCFILE filename FROM DDCDB

The DDC file will be created in the filename specified.

 

A DDC DB can be created from a DDC file. The command is:

CREATE DDCDB FROM DDCFILE

This takes the active DDC file that dbvrep has been loaded with (through readddc or --ddfile commands) and loads the settings into the DDC DB.


DDC_BACKUP_DIR 

On every startup of a process a backup of all DDC settings is made into the DDC_BACKUP_DIR directory as a backup, e.g. for use with CREATE DDCDB FROM DDCFILE, or just for reference.