DT346 Database instance

DI024676 License

License number

DI025404 DB instance

Database instance

DI024675 DB schema

Database schema for which database access is to be set up.

DI025152 DB schema

Name of the DB schemas

DI024860 DBMS

Database management system

Values

• 000002 - ORACLE database
• 000004 - MS SQL server database

DI025156 DBMS

Name of the DBMS

DI024903 Active

Values

• : DB instance not activated - inactive
• : DB instance activated - active

DI024906 Archive

Values

• : DB instance is no archive DB
• : DB instance is an archive DB

DI025786 Language

Database instance language overwrites other language settings

• e.g. user language

DI024687 Name

DI024723 Path

For SQL databases the database name e.g. ORACLE_SID.

DI024724 Name

For SQL databases the database name e.g. ORACLE_SID.

DI024729 Connect string

• For SQL databases normally by clicking on the Copy connect string from template button. Exception: in particular cases a manual entry can be made after consulting PLANTA.

Further use (in preparation):

• Protocol = tcp
• Host = 192.168.121.2
• Port = 25005
• Path = /u/db/dnew
• Name = P01B
• This generates the following connect string:
  • tcp:192.168.121.2:25005:/u/db/dnew/P01B

DI025151 Conn. string template

DI024737 Code page

Specification of a character set which is used in an external SQL database.

DI024728 Schema file name

File name of the schema file.

DI024725 User

For SQL databases it is the name of the schema (=user).

DI024726 Password 1

For SQL databases it is the password of the user.

DI024727 Password 2

Always the same as Password 1

DI025155 DBIF

Database interface; depending on the DBMS used. No input option for the user.

Values

• 2 = Oracle
• 4 = MS SQL

DI024732 Open only if needed

Open only if needed. This function is in development.

DI024735 ZERO date behavior

The parameter is deactivated and is no longer used.

DI024736 Access prot. type

One access protection type can be specified per database instance. The new access protection type will take effect the next time you log in.

Values

• 0: No access protection (default)
• 1: Owner-based
• 2: ACR-based, not functional in Release 38

You can enter the access rights when you create a record. However, they can also be changed retroactively by the system manager via data protection modules.

DI024730 Def. Tablespace Tab.

Default tablespace tables

• Here, a storage location (=tablespace) deviating from the PLANTA presets (DATA) is defined for tables.

Information

• For databases, a tablespace describes the storage location in which tables, indexes, and other data objects are written.
• In general, 4 types of tablespaces are to be distinguished:
• Regular tablespaces are tables and indexes.
• They are definitions under DBMS ORACLE.

DI024731 Def. Tablespace Ind.

Default tablespace. Here a storage location (=tablespace) deviating from the PLANTA presets (INDEX) is defined for indexes.