| Expand | ||||
|---|---|---|---|---|
| ||||
|
| Child pages (Children Display) |
|---|
Overview
This form enables users to create and manage either an ACM database or a FLOWCAL database.
ACM Database
Manage Database
| Info | ||
|---|---|---|
| ||
It is important to close the ACM Configuration client and stop the ACM services before making changes to an existing 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.
...
,
...
view
...
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.
| Info | ||
|---|---|---|
| ||
For installations that make use of the Safe Mode operation, ACM versions 8.0 and later require the "Microsoft ACE OLEDB 12.0" database driver for the safe mode database. The older "Microsoft Jet OLEDB 4.0" driver used by ACM versions 7.1 and earlier is no longer supported. The new database driver can be downloaded from Microsoft here. |
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".
| Info | ||
|---|---|---|
| ||
See Backup the ACM database to an emergency Microsoft Access database. |
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.
...
| title | Oracle Connection Example |
|---|
Sample setup
- FCPROD is the name of the listener on the FLOWCAL machine.
- VMFLOWCAL2 is the name of the FLOWCAL machine.
- FLOWCAL is the name of the FLOWCAL database.
Install Oracle client driver files (available from ACM ftp site). Note: The 32-bit version of the Oracle client is required for the 32-bit version of ACM.
Custom 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.database statistics or establish the connection to a FLOWCAL database used by the asiFlowCalScadaRequest service.