SUNDM Keywords

The following configuration keywords are available to alter or tailor the execution of the Data Manager:

Keyword	Usage
ALLOW_ALL_FILES	Controls scanning of file names beginning with an underscore.
ALLOW_AUTO_ROLLBACK	Controls the auto rollback feature.
ALLOW_CHILD_LOGON	Controls user access to secondary or backup replication servers.
BACKUP_OPEN_SHARED	Forces the replication task to open files in shared mode.
BYPASS	Replication is started the same as when the '-b' command line option has been specified.
CACHE_BUFFER_SIZE	Defines the buffer size used during replication.
DM_ALLOWPATH	Controls client PATH and SEARCHPATH verb access.
DM_ANSIIO	Controls the ANSI IO behavior.
DM_AUTH	Overrides a previously installed authorization number.
DM_AUTOISICOMPACT	Controls the auto compaction feature for ISAM files
DM_CHECKFILE2GB	Control the server's file size checking.
DM_CHILDRECOVERY	Control the server's child connection recovery logic.
DM_COPYFILECHILDRECOVERY	Control the server's child connection recovery logic for COPYFILE operations.
DM_DEFAULTCWD	Establish the default working directory for the data manager process.
DM_DELAYCLOSE	Delays closing of file variables opened at the server.
DM_DPTFILENAME	Control Datapoint file name processing.
DM_EXTENDENQERRORS	Control locking errors.
DM_HOSTNAME	Specify the IP address or host name of the server.
DM_IPFILE	Define an IP filter for client connections.
DM_KEEPALIVE	Enable detection of stalled clients by the server.
DM_KEYFILE	Define the client access control information.
DM_LOCALIP	Define the local IP address.
DM_LOG_RECSIZE	Defines the maximum log file record length.
DM_LOG_RECVAR	Allows log file records to be variable length.
DM_LOGFILE	Enable data manager logging.
DM_LOGMAX	Specify the log file maximum size.
DM_LOGONTIMEOUT	Configure the log on timeout value.
DM_LONGKEEPALIVE	Define the long keep-alive duration.
DM_NO_SHUTDOWN	Prevents a user logoff or shutdown.
DM_OPENONCE	Modify the data manager's internal open logic.
DM_OPENONCE_ALLOWREAD	Allow read access to third party programs..
DM_OPENONCE_CACHED	Control caching of isam header information.
DM_OPENONCE_SHARED	Modify the data manager's internal open once logic to allow shared access.
DM_OPENONCE_FLUSH	Modify the data manager's internal open once logic.
DM_PORTNUM	Specify the IP port number assigned to the data manager task.
DM_PREP87	Create ISAM and AAM files using the version 8.7 file format.
DM_PUBLIC	Defines an optional key used to encrypt messages to and from all clients.
DM_RUNSUBSTITUTE	Control file name substitutions.
DM_SCHEMA	Defines the default schema database file
DM_TERMTIME	Defines the number of seconds the server will wait for tasks to terminate before aborting.
DM_USELONGTIMEOUT	Increases the lost connection time-out value in the server.
DM_WATCHDOG	Force the creation of a new listening socket after an idle period.
FAIL_TIME	Defines the number of seconds required before a secondary server assumes control.
HOSTnn	Identify hosts in a replication network.
IDLE_CLOSE	Define the number of seconds a secondary server will keep a file open.
LOGON_HOST	Define the log on server's address.
MANAGED_DIRnn	Define replicated drives and directories.
MANAGED_RECURS_DIRnn	Define replicated drives and directories.
NO_FILE_DELETES	Control file deletion on secondary or backup servers.
PLB_AAMUPPER	Specifies the uppercase translation table.
PLBENV	Define path and name substitutions.
PLB_ERRLOCKTIMEOUT	Specify how long the runtime should wait when a Windows ERROR_LOCK_VIOLATION occurs.
PLB_NOPATH	Controls the storage of path information in ISAM and AAM files.
PLB_OSIDLETIME	Control idle time when waiting for a lock.
PLB_PATH	Provide data file path information.
PLB_PREP	Define default path for files created.
PLBVOL	Define Datapoint drive and evironment aliases.
PLBWIN_XPIO	Perform specialized code during write statements.
PUBLIC	Identifies a public encryption key for replication.
SCAN_ON_ROLLOVER	Controls directory scanning after a rollover.
SCAN_TIME	Define the seconds between directory scans.
SECONDARY_SCAN	Control secondary scanning of secondary or backup servers.
TRANSACTION_WINDOW	Define the number of I/O operations to buffer.
TRANSACTIONAL_IO	Control the replication transaction processing.
TYPE	Define the server type.
UNMANAGED_DIRnn	Define replicated drives and directories.
UNMANAGED_RECURS_DIRnn	Define replicated drives and directories.
UPDATE_DIR_ATTRIBUTES	Controls the replication of time stamp and attributes for directories.
UPDATE_FILE_ATTRIBUTES	Controls the replication of time stamp and attributes for files.
V2_REPLICATION	Controls the enhanced replication support.
VALIDATE_ADDR	Define a communication validation address.
WAL_DIR	Defines the WAL file directory.
WAL_SEGMENT_MAX	Defines the segments in a WAL file.
WAL_SEGMENT_TIMEOUT	Defines the number of seconds a dirty WAL file can remain in memory before being written.

Administrative Access Keywords

Keyword	Usage
ADMIN_DATACLR	Clears data items kept by the main server task.
ADMIN_DATASET	Sets data items kept by the main server task.
ADMIN_HOSTNAME	Specifies the admin host address.
ADMIN_IPFILE	Enables IP Filtering.
ADMIN_KEYFILE	Defines the LOGON key file.
ADMIN_LOGCHILD	Control logging of child tasks.
ADMIN_LOGLEVEL	Define the initial logging level for all tasks.
ADMIN_LOGON	Specifies a user provided logon encryption key.
ADMIN_MAIL	Enabled or Disable administrative emails
ADMIN_MAIL_OUT	Defines the administrative email outgoing mail server
ADMIN_MAIL_TO	Configures the administrative email receipients
ADMIN_MAIL_FROM	Defines the administrative email sender
ADMIN_MAIL_REPLICATION	Configures administrative emails for the replicator
ADMIN_MAIL_MAXUSERS	Triggers an email when the maximum users for the Data Manager has been reached.
ADMIN_MAIL_STARTUP	Sends an email when the Data Manager has been started.
ADMIN_MAIL_SHUTDOWN	Sends an email when the Data Manager has been stopped.
ADMIN_MAIL_SUBJECT	Defines the subject of the administrative emails.
ADMIN_MAIL_BCC	Defines the blind carbon copy recipients of the administrative email.
ADMIN_MAIL_CC	Defines the carbon copy recipients of the administrative email.
ADMIN_MAIL_USER	Configure the user login for the email server.
ADMIN_MAIL_PASSWORD	Configures the user password for the email server
ADMIN_MAIL_PORT	Defines the port for the email server.
ADMIN_MAIL_SSL	Enables SSL for the email server.
ADMIN_MAIL_TIMEOUT	Defines a timeout value when communicating with the email server.
ADMIN_MAIL_TRACE	Provides debug tracing via email.
ADMIN_MAIL_TRACEAPPEND	Provides debug tracing via email.
ADMIN_MAIL_DSNRECEIPT	Provides delivery confirmation of the administrative emails.
ADMIN_MAIL_MDNRECEIPT	Reports receipt of the administrative emails.
ADMIN_MAIL_RETURN	Defines the administrative email return address.
ADMIN_MAIL_REPLYTO	Defines the administrative email Reply To address
ADMIN_MAINLOGON	Control administrative access via the main logon port.
ADMIN_PORTNUM	Defines the port number of the admin task.
ADMIN_PUBLIC	Specifies a user provided public encryption key.
ADMIN_SHELLICON	Controls the file manage via a task bar icon.
ADMIN_SUPPORT	Controls the creation of the admin task.

SQLIO Access Keywords

Keyword	Usage
DM_SQLIO_CONN	Defines the database connection string.
DM_SQLIO_DEBUG_LOG	Defines the logging level for the SQLIO subsystem.
DM_SQLIO_DRIVER	Defines the driver used by SQLIO..
DM_SQLIO_EXT	Defines the extension parameters used to make the connection.
DM_SQLIO_FLAGS	Defines the optional database connection flags.
DM_SQLIO_HOST	Defines the host used to make the connection.
DM_SQLIO_PASS	Defines the password used to make the connection.
DM_SQLIO_SQLTYPE	Defines the type of SQL used..
DM_SQLIO_SCOPEID	Forces the use of the SQL SERVER 'SCOPE_IDENTITY' function to get the last IDENTIFY value
DM_SQLIO_SQLTYPE	Defines the type of SQL used..
DM_SQLIO_USER	Defines the user named used to make the connection.
DM_SQLSCHEMADB	Defines the schema database name.
DM_SQLTABLEDB	Defines the database name where current application SQL data tables are accessed.

In addition, the Data Manager allows the SQLite database engine to be loaded and used as a driver using keywords from the Sundm CFG file. This feature allows a PLB program to access the SQLite database engine by referencing user defined keywords in the runtime INI and the Data Manager CFG files.

Example 1:

PLBWIN INI keyword to access SUNDM:

SOMEKEYDM=FILEMAN,127.0.0.1

SUNDM CFG keyword to access SQLite database engine:

SOMEKEYDM=SQLite

PLB Program sample:

`MYDB`	`DBFILE`
`.`
	`DBCONNECT`	`MYDB,"SOMEKEYDM;;c:\mypath\mydata.db","",""`
`.`

Example 2:

PLBWIN INI keyword to access SUNDM:

SOMEKEYDM=FILEMAN,127.0.0.1

SUNDM CFG keyword to access SQLite database engine:

SOMEKEYDM=SQLite,c:\sundmpath\mydm.db

PLB Program sample:

`MYDB`	`DBFILE`
`.`
	`DBCONNECT`	DBCONNECT MYDB, "SOMEKEYDM;;","",""
`.`

See Also: SUNDM, SUNADMIN, MAKEMFD, WATCH