Deleting dynamic system settings connection parameters
After you upgrade to Pega Platform version 8.6 or later, delete
your previous connection parameters that you specified by using dynamic system settings
(DSS) or the prconfig
file, to avoid parameter overrides.
For Pega Platform version 8.6 and
later, you specify the connectivity parameters for your JDBC URL external database
instance by using the Data-Admin-DB-Name rule. If you previously
specified connectivity parameters for the JDBC URL external database instance through
dynamic system settings or the
prconfig
file on a previous Pega Platform version, first delete those settings before creating or updating
JDBC URL external database instances. For more information about JDBC URL connection parameters, see Creating and updating external database instance with JDBC URLs.
- Expand the SysAdmin category, and then click Dynamic System Settings.
- In the Setting Purpose column, click the search icon.
- Find your dynamic system settings by entering the associated connection
parameter keystring:
- For the DSS that specifies each database user connection pool size, enter prconfig/database/databases/<database name>/connectionPoolSize.
- For the DSS that specifies the connection timeout in seconds, enter prconfig/database/databases/<database name>/MaxConnectionTime.
- For the DSS that specifies the leak detection threshold in miliseconds, enter prconfig/database/databases/<database name>/leakDetectionThreshold/default.
- For the DSS that specifies the default schema of the external database, enter prconfig/database/databases/<database name>/defaultSchema/default.
- Select the DSS entry that you want to delete.
- In the Edit Dynamic System Settings tab, click Delete.
- In the Delete window, in the Reason for deletion field, enter a note with an explanation why you want to delete the record, and then click Delete.
- Delete all previously configured connection parameter settings by repeating steps 2 through 6.
Previous topic Creating and updating external database instances with JDBC URLs Next topic Deleting connection parameters in the prconfig file