D2000 system uses SQL databases, that are accessible via ODBC interface, as data storage. By default, the following databases are supported:

  • PostgreSQL
  • SQL Adaptive Server Anywhere from the Sybase company
  • Microsoft SQL Server respectively its freeware version Microsoft Desktop Engine (MSDE)

The following table displays the number of connections to the database server:

ProcesConnection nameNumber
D2000 ServerConfiguration3

Log database depository+3

Backup (triggered externally)+1
ArchiveArchive database3 (and more, depending on performance configuration)

Archive depository+3

Backup+1
DBManager(configuration dependent)


The table above shows, that any simple application with enabled both the log database depository and the process Archive can use as many as 14 connections to the database server. Selecting the option DB Engines in the process D2000 Application Manager, the window has looks like this one:


Clicking the right mouse button on an existing server, you can carry out the following operations:

New ServerCreates a new DB server
EditAllows to modify the selected DB server
DeleteDeletes the selected DB server
RunRuns the selected DB server
StopStops the selected DB server

Creating new MSDE database servers (engines) through the D2000 Application Manager process is not supported, because the servers are created by the MSDE installation.

Creating a new PostgreSQL through the D2000 Application Manager process is not supported, because the servers are created by the PostgreSQL installation.


Sybase database server parameters:

The following dialog box will appear after selecting the New Server item in the pop-up menu:


Service NameThe name of a system service,  used for the database server. The server name is appended automatically according to Service Name, but it may be changed - it is a word placed after the parameter -n in the input field Parameters.
Service TypeIf the Sybase Network server is installed, it is possible to configure it. The network server is not limited to a number of connections.
VersionSelection of a version.
Path for executable

Path to an exe file representing the database server. The file is different according to the selected Service Type.

Startup

Definition of the server start-up. In this case, if the radio button Automatic is not selected, the service will be started automatically by the process D2Start that starts the process D2000 Server, too.

ParametersServer start parameters:


-c 8Mcache size


-nD2000_Xname of the database server (Engine Name)


-mdeleting the log file after finishing the use of the database


-gp 4096page size


-gd ALLthe setting of database access level

0 komentárov

Nie ste prihlásený. Akékoľvek zmeny, ktoré vykonáte, sa označia ako anonymné. Ak už máte svoj účet, pravdepodobne sa budete chcieť prihlásiť .