Databases

The Databases tab displays the databases that are defined in the environment.

The Test connection button can be used at any time to test if the database server is reachable with the entered credentials, even if the data is not yet saved.

Under Kind of database, the type of the definition is shown, internal for direct use in an application, external for use in other applications, system for access to the system database, transactionlog for an database for transaction logging and encryption for an encryption database. The name is the name of the database in the database server and the type which can be MSSQL, Oracle, or DB2, depending on the chosen type different options are displayed.

When the Add button is clicked or a database is selected and Edit or Copy is chosen, the next window will appear for MSSQL type databases:

Tab General

In the General tab general settings can be configured.
If Transactions need to be logged, it is necessary to have a Transaction database.
If encryption will be used, an encryption database is needed.

• Database server: 
  • MSSQL: The ADO name of the MSSQL database server instance.
  • Oracle: The logical database name of the Oracle database server.
• Database name: 
  • MSSQL: The name of the database.
  • Oracle: The name of the Oracle Tablespace used for the database.
• Type of database: MSSQL, Oracle, or DB2.
• Schema: The User Schema used for this database.
  For a MSSQL server, schemes can only be used in combination with AmtReorganize.exe (Reo.exe does not support schemas in MSSQL).
• Kind of database: Depends on the purpose the database is used.
  • User database: Used for direct access within the application. This displays as Internal in the database list. 
  • Remote database: Used for remote access to databases from other applications. This displays as External in the database list.
    

    Encryption for Remote databases is not supported.

    
    
  • System database: Used for access to the System database. This displays as System in the database list.
  • Encryption database: Used for encryption settings. This displays as Encryption in the database list.
  • Transaction logging database: Used for the logging of transactions. This displays as Transactionlog in the database list.
• Remote access prefix: Used when accessing remote databases. When the remote database is accessed through a "new connection" in the alias settings then the field can be left blank. When the same database connection is used then it needs to be filled with the full prefix so that the tables can be accessed from the main user database connection. For MsSql this means the prefix is set to "<databasename>.<owner>." and for Oracle to "<schemaname>.".
• Reorganize keep tables: If enabled, all stored tables will be kept after the database is reorganized. If disabled, all tables and indexes not created through AMT will be removed when reorganizing the database.
• Reorganize keep sequences: If disabled, all sequences that have not been created via AMT will be removed when the database is reorganized.
• Reorganize keep procedures: If disabled, all stored procedures that have not been created via AMT will be removed when the database is reorganized.
• Reorganize keep views: If disabled, all stored database views that have not been created via AMT will be removed when the database is reorganized.
• Use non block reads: If enabled, singled records will be read from the database, otherwise reads from the database will be done in large blocks of records. For speed it is advised to leave this disabled.

Database credentials

The database credentials have been split into three sections, which gives the possibility to use different credentials for each section.

• Reo credentials: Used by the AMT reorganization program/service, it is mandatory to fill in this section.
• Business logic credentials: Used by the AMT transaction server and AMT batch controller.
• RtQuery: Used for RTQuery, a database query tool not used in AMT-COBOL.

With the exception of the Reo credentials, it is not mandatory to enter credentials in every section. If a section is left blank, the credentials used as Reo credentials will be used for that section. All credential sections consists of the following options:

• User: Username to access the database
• Password: Password to access the database. The combination of password and user should be a valid one for the database server (not for the AMT-COBOL system).
• Integrated security: If enabled, the database will be accessed by Windows Integrated Security (i.e. the Windows username and password will be used and the username and password fields can be left empty). If disabled, SQL Server Authenticity (user/password) will be used to connect to the database server.

Properties for MsSql only

• SSL connection: If enabled, SSL/TLS will be used when connecting to the database server.
• Mirroring failover partner: If failover mirroring is used on SQL Server, the network name of the failover partner must be set here.
• Isolation level: The Isolation level to set for a SQL Server. Possible values are Read-Commited and Read-Uncommited (dirty read).
• SQL Support Assembly: The location of an optional .NET assembly to be used in the SQL Server as a CLR stored procedure.
  

Properties for Oracle only

• Use cost based optimizer: If enabled, the Oracle cost based optimizer will be used.

Tab Aliases

In the aliases tab an alias can be set for this database together with an application name. If an alias is set then in this application, this database can be accessed under the alias as an external database. Use 'All Applications' if the database should be accessible under that alias in all applications.

Tab FileGroup/TableSpace

In the FileGroup/TableSpace tab, translations for FileGroups/TableSpaces can be set.

Logical FileGroup/TableSpace names set in database objects (tables or indexes) within the AMT Developer Studio, can be translated to new FileGroup/TableSpace names corresponding to physical FileGroups/TableSpaces present in the database. When no translation entry is present for a FileGroup/TableSpace name, the original (logical) name will be kept to be used for the physical FileGroup/TableSpace.

When adding, copying or editing an entry the following entry kinds are available:

• [Default Indexes] : When a database index in the AMT Developer Studio has no FileGroup/TableSpace set, the index will be placed in the physical FileGroup/TableSpace as set in the 'New FileGroup' field. This option can be set only once per database.
• [Default Tables] : When a database table in the AMT Developer Studio has no FileGroup/TableSpace set, the table will be placed in the physical FileGroup/TableSpace as set in the 'New FileGroup' field. This option can be set only once per database.
• Other : With this option, a logical FileGroup/TableSpace name set in a database object (index or table) within the AMT Developer Studio can be translated to a new FileGroup/TableSpace name. This enables the usage of different FileGroups/TableSpaces in duplicated applications using the same sources. (Logical) FileGroup names can only exist in one entry per database, (physical) New FileGroup names however can be used multiple times per database in different entries.

Database objects will be placed in their physical FileGroups/TableSpaces upon reorganization of the database.