Configure MDS Database

Home

 

Up

 

1    Configure the MDS database

The database contains configuration settings for each instance of the application, as well as a repository for messages. There are also user validation tables and extensive logging facilities all of which require configuration before the system can operate.

There are many tables in the MDSMKII database. Each table provides one of three functions.

  • Information Storage

  • Client and System Configuration

  • User Information

Information Storage:

The following tables simply collect information. SQLServer is then configured to backup and archive these tables.

  1. MDSIncoming    Log of incoming SMS responses.

  2. MDSLog            Log of all client activity.

  3. MDSMessages    The main message log.

Client Configuration:

The following tables configure the instance of client. The IPC, OPC, SMSC, SMTPServer applications all have the ability to clone to provide redundant services. This means each time the application is started it uses the tables to determine what tasks it should perform particularly if there are more than one instance of the same application running. Each instance is designated a client label such as a01, a02 etc for the IPC Clients.

  1. MDSClient    Client activity and initial start-up variables and flags that uniquely identify every instance of the applications.

This is a dynamic table. It defines the states of all the applications. The Switch application carefully monitors the activity of this table to determine the health of the MDS system.

System Configuration:

The following tables configure the initial start-up of the applications and general system variables and flags.

  1. MDSModule  Generic definition of all the clients.

  2. MDSMonitorMessage    System alarm messages

  3. MDSMStatus    List of Inter-Client communication status information

  4. MDSSystem    List of system information       

  5. MDSTCPClient    List of client inter-communication limits.

User Information:

The following tables are the look-up lists of users, their grouping and the networks the networks the messages are being sent to.

  1. MDSGroups    List of Groups of Users

  2. MDSUser        List of valid users

  3. MDSNetwork    List of available networks.

 

[ Home ] [ Up ]  
Copyright © 2012-2021 MTEL Communications Pty Ltd
Last modified: 01-Jun-2022