Managing Databases - Configuration


Legacy SQL.ini File

While this topic addresses configuring databases using the BBj Enterprise Manager, it is important to understand the precedence rules when using an optional SQL.ini with BBj. When executing an SQLOPEN call, BBj follows this order of precedence when finding a match for the string specified in the SQLOPEN verb:

  1. If the string begins with jdbc:, assume it is a complete JDBC connection URL
  2. Check for a named connection pool
  3. Check the SQL.ini file (required file for PRO/5 and Visual PRO/5 but optional in BBj)
  4. Check for a local BBj database (as described below)
  5. Check for an ODBC DSN

Attach to an Existing Database

To add a new database alias that is attached to an existing data dictionary:

  1. Click the [Attach to Existing Dictionary] button located at the bottom left corner of the Enterprise Manager window.

  2. When prompted, enter the alias name to use for the database, location of the data files, and the location of the data dictionary files.

    Note: Names are case sensitive and must be referred to exactly as they are entered.

Create a New Database and Dictionary

  1. Click the [Create a New Database] button located at the bottom left corner of the Enterprise Manager window.

  2. Select the type of database to be created. For a "Classic" database that uses normal, MKEYED, XKEYED, etc. files, specify the location of where the data dictionary will be created. For a "Journaled" database, the Journaled Filesystem must first be configured correctly.

Dropping a Database

To drop a database (and delete the dictionary and data files as well):

  1. Select the database to drop from the Databases list.

  2. Click the [Drop Database] button.

  3. When prompted, confirm that this is the database to drop.

  4. When prompted, decide whether to delete all of the data dictionary files and the data files associate with the database.

Managing the Properties and Components of a Database

  1. Each database has a number of properties that must be set before the database can be used for accessing its data such as the location of the data dictionary, location of the data files, date format, etc. To set or change the properties for a database:

  2. Select the appropriate database from the Databases list.

  3. Change the appropriate settings and click the save button at the bottom right corner of the properties panel. For details on each property, see the Information Tab section below.

IMPORTANT NOTE: If the data dictionary and/or data files that the database configuration specifies have the potential of being accessed simultaneously by PRO/5, Visual PRO/5, or the BASIS ODBC Driver version 1.x - 3.x, access to files must be made through a PRO/5 Data Server. This is because the file locking mechanisms used by PRO/5 and the BASIS DBMS are different, leaving the possibility of file corruption when PRO/5 and the BASIS DBMS simultaneously access a file. In this scenario, the PRO/5 Data Server handles all file locking for both systems, eliminating the possibility of file corruption.

See Also

Information Tab

Tables Tab

Views Tab

Procedures Tab

Type Definitions Tab

Sequences Tab

Permissions & Roles Tabs

SQL Tab

Query Analysis Tab



______________________________________________________________________________________

Copyright BASIS International Ltd. BBj®, Visual PRO/5®, PRO/5®, and BBx® are registered trademarks.