Configuring database options
Database options are available only for on-premises deployments.
You can view and configure information about the database that you are using from the Server Information form.
To display and update information about the database
- In a browser, open the AR System Administration Console, and select System > General > Server Information.
The AR System Administration: Server Information form appears. - Click the Database tab.
The information displayed on this tab varies depending on the relational database that you have installed.
Enter the following information as needed:
Database tab fields- Click Apply.
Considerations when generating reports against a read-only database
When you generate reports against a read-only database, and you modify objects such as forms, fields, or active links, you must restart the AR System server pointing to the read-only database so that the schema changes are reflected.
This applies to all objects that the AR System server caches. The objects can be modified through Developer Studio, Innovation Studio, D2P deployment, bundle deployment, or any other mechanism.
Using a read-only database
The AR System server automatically detects if you have a read-only database. AR System does not support the following features with a read-only database. You need to disable the following features through Java Driver when you are using a Read-only database. Refer to Runtime-configuration to run the Java Driver program.
Use the procedure shown below in the example to disable the features.
SET SERVER INFO
Number of server info operations (0): 1
Operation (1-443) (1):419
Datatype
Null/Key/Int/Real/Char/DiaryList/Enum/Time/Bitmask/Byte
Decimal/attach/currency/date/timeofday/join/trim/control/Table/Column/ulong/coords/view/display
(0 - 14, 30-34, 40-43) (0): 2
Integer Value (0): 1
Set Server Information Status
ReturnCode: OK
Status List : 0 items
Enter the ID for the feature to be disabled on the line below:
Operation (1-443) (1):419
Replace 419 with the ID for the feature to be disabled. Refer to the table below for IDs.
Feature | ID |
|---|---|
Archiving | ID for single server environment – 191 ID for server group environment – 419 |
Escalation | ID for single server environment – 143 ID for server group environment – 422 |
ID – 190 | |
Vendor form search | You cannot search Vendor form if you have read-only database because Vendor form search results in creating temporary tables. |
To enable dual database connection for read-write and read-only databases
The AR System server supports dual connection to the read-write primary database and the read-only database. Transactional workloads use the read-write primary database. Reporting workloads are routed to the read-only database through a dedicated private RPC queue to prevent impact on transactional workloads.
- Enter the read-only database parameters and their corresponding values in the ar.cfg file:
Parameter Description Secondary-Db-Jdbc-Url Specifies the JDBC connection URL for the read-only database. Secondary-Db-Jdbc-User-Name Specifies the username that connects to the read-only database. Secondary-Db-Jdbc-User-Password Specifies the password that connects to the read-only database. For more information, see ar.cfg or ar.conf options S-Z.
- (Optional) Configure report-max-entries-per-query parameter to set the maximum rows returned per reporting request. For more information, see ar-cfg-or-ar-conf-options-N-R.