Database Properties

Overview

This form enables users to create and manage either an ACM database or a FLOWCAL database.

ACM Database

Manage Database

To create a new database, update an existing database or change the database the ACM Configuration client utilizes, click the Manage Database... button.  

Server name

The name of the SQL server the database will reside in.

Database name

The name of the database to be used for ACM Configuration.

Authentication/User name/Password

The authentication information required for secure access to the database.

Azure Database

Default = Not selected. Select this if the database is an Azure database as ACM may not run properly otherwise.

Duplicate Connection for Reports

Default = Not selected.  Select this to use the same connection and authentication for running reports. This information can be later modified in the Reports section of the ACM Monitor if necessary.

Custom Setting

Default = blank.  If a custom setting needs to be appended to the connection, e.g. "MultiSubnetFailover=Yes", enter it here.  If multiple custom settings are entered, they must be separated by a semi-colon.

Create/Update Database

Click the "Create/Update" Database button in order to either create a new database or update an existing database to the latest version.  This will bring up the Create/Update Database Wizard.

Test Connection

Use this to confirm that the authentication information is correct.

Safe Mode Options

Run from backup if connection fails (safe mode)  

Default = Not selected.  Select this to run ACM from a backup Microsoft Access database if the connection to SQL Server were to fail during the startup of ACM. This provides a way for ACM to load the last backed up configuration so polling can take place.  Any modifications to the configuration while in Safe Mode are temporary and will not be saved.

Backup now

Click this button to backup the database. The backup is stored with the ACM system files; the default location is "C:\ProgramData\AutoSol\Communication Manager\7".

Database Statistics

Click "Database Statistics" to view and manage database statistics of the ACM database.

The top grid shows the current overall status of the ACM database.  This screen is a quick view into the database configuration and how much memory is available.  The sizes listed in this table all are recorded in Megabytes (MB).

Table Column Meanings:

• Name:  This is the logical name of the file in the database.
• File ID: This is the ID of the file within the database.
• Size: This is the current size of the file.
• Available: This is the amount of space available.
• Used: This is the amount of space used by the database.
• % Used: This is the percentage of the total size that is in use.
• Growth: This field shows if the database file is set to automatically grow.
• Max Size: This shows the maximum size to which the database is allowed to grow. **This does not mean the computer can support the maximum size.**
• Gr Rate: If the database is set to grow, this is the rate at which it grows. This can be set to a percentage or an absolute growth rate.

Storage Stats: Click to view the storage statics for the tables within the ACM database.

This form contains the ACM Detail Table which is a comprehensive break down of how much memory each individual table is using in the database. 

Table Column Meanings:

• Table Name : This is the name of the table.
• Row Cnt: This is the number of rows in the table.
• Total Size: This is the total amount of space reserved for the table.
• Data Size: This is the total amount of space used by the table.
• Index Size: This is the total amount of space used by all indexes for the table.

Save As

Use the "Save As" button at the top to save the information in the table as CSV, Excel, PDF or HTML.

• CSV:  This is a plain comma delimited text file, that will include the header of the table.
• Excel: This will save the table in .xls format, including all table coloring.
• PDF: This will save the table in .pdf format, including all table coloring and format.
• HTML: This will save the table in .html format without coloring.

Index Statistics

Clicking the "Index Stats" button will bring up the SQL Index Monitor. View the SQL Index Monitor section for more details.

FLOWCAL Database

Manage Database

If ACM will be publishing to a FLOWCAL database, the connection information is entered into the form below.

Provider

The database provider: Microsoft (MSORADB), Oracle or Custom.

Database name

The name of the FLOWCAL database to be used.

Authentication/User name/Password

The authentication information required for secure access to the database. 

If opting to use authentication, user name and password must conform to Microsoft’s guidelines found at: https://docs.microsoft.com/en-us/sql/relational-databases/security/strong-passwords?view=sql-server-ver15 (See note concerning the use of ODBC connection strings).

Custom

If using a Custom provider, enter the custom or provider-specific connection string.

Provider=OraOLEDB.Oracle.1;Data Source=FCPROD;User Id=User1;Password=Pwd;UseSessionFormat = TRUE; 

FCPROD = 
     (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = VMFLOWCAL2)(PORT = 1521))
          (CONNECT_DATA =
                 (SERVER = DEDICATED)
                 (SERVICE_NAME = FLOWCAL)
           )
      )

Test Connection

Use this to confirm that the authentication information is correct.

Test Connection as User

Use this to test the connection under a different windows user.  

Enter the User name (DOMAIN\User) and password for the user in question.