Database Settings Field Definitions

You can use the following fields to define database settings.

Field Definition
Automatically Handle Alerts Older Than (Hours) The number of hours after which alerts are automatically moved from the Active Alerts monitor to the Handled Alerts Monitor. If this value is set to 0, no alerts are moved.
Important: If an event is moved or deleted from the IBM® Sterling Control Center Monitor production database, then any corresponding alert is handled automatically before it is deleted from the production database. This action occurs even if the value is set to 0.
Average Delete Time Average time in milliseconds required to move rows from production to staging database. Display only.
Average Insert Time Average time in milliseconds required to add rows to the production database. Display only.
Average Update Time Average time in milliseconds required to update rows in the production database. Display only.
CD Stats table rows Number of table rows of Sterling Connect:Direct® statistical data. Display only.
CE Stats table rows Number of table rows of Sterling Connect:Enterprise® statistical data. Display only.
CX Stats table rows Number of table rows of Sterling Connect:Express statistical data. Display only.
Database Name Name of the production database. Set at installation. Display only.
Database Type Type of production database. Set at installation. Display only. Values include:
  • Oracle
  • DB2®
  • Microsoft SQL
Data Movements Status Whether or not currently running. Display only.
Event table rows Number of table rows of event data in the production database. Display only.
Host Name The computer where the production database is installed. Set at installation. Display only.
Last Data Movement Duration Time that last data movement took. Display only.
Last Data Movement End Date/time of end of last data movement. Display only.
Last Data Movement Start Date/time of beginning of last data movement. Display only.
Last Purge Duration Time that last purge required. Display only.
Last Purge End Date/time of end of last purge. Display only.
Last Purge Start Date/time of beginning of last data purge. Display only.
Movement of Data to Staging Database: Audit Data Older Than (days) The number of days after which audit log data are moved from the production database to the staging database. The default value is 7. The minimum value is 2.
Movement of Data to Staging Database: Data Older Than (days) The number of days after which statistical and event data are moved from the production database to the staging database. The default value is 7. The minimum value is 2.
Note: If the Production Database is partitioned or no Staging Database is defined, the removed data is discarded. If the Production Database is not partitioned and a Staging Database has been defined, the removed data is added to the Staging Database.
Note: This setting determines how far back IBM Sterling Control Center Monitor can resume monitoring when a user pauses and then resumes monitoring. For example if this parameter specifies seven days and the user pauses the server for two weeks, IBM Sterling Control Center Monitor will resume monitoring seven days back, not all the way back to the pause point when data is requested from the server.
Movement of Data to Staging Database: Number of Rows to Select per DB Transaction The maximum number of production database rows IBM Sterling Control Center Monitor reads into memory in preparation for moving to the staging database row by row. The default is 4000.
Movement of Data to Staging Database: When to Begin Moving Data The number of minutes between attempts by IBM Sterling Control Center Monitor to move data from the production database to the staging database. Or, the time of day to begin moving data to the staging database.
Next Scheduled Data Movement Date/time of end of next scheduled data movement. Display only.
Next Scheduled Purge Date/time of end of next scheduled purge. Display only.
Number of Rows to Select per DB Transaction The maximum number of database rows Control Center reads into memory in preparation for purging data from the staging database row by row. The default is 4000.
Oldest Record Oldest record in the production database, in days. Display only.
Port The port number used to access the production database. Set at installation. Display only.
Purge Status Whether or not purge is currently running. Display only.
Purging of Data from Staging Database: Audit Data Older Than (Days) Automatically purge configuration management audit data older than the days defined in this field from the events and statistics tables in the staging database. The default value is 30.
Purging of Data from Staging Database: Data Older Than (Days) Automatically purge data older than the days defined in this field from the events and statistics tables in the IBM Sterling Control Center Monitor staging database. The default value is 30.
Purging of Data from Staging Database: When To Begin Purging Data: Run Daily at time. The time at which to do a daily purge. Defined as IBM Sterling Control Center Monitor engine time.
Purging of Data from Staging Database: When To Begin Purging Data: Run Every n Minutes The number of minutes between database purge attempts.
Purge summary data older than (days) The time period in which you want the summarized process and file transfer data to be retained in the CC_PROCESS, CC_PROCESS_DVG, CC_FILE_TRANSFER, and CC_FILE_TRANSFER_DVG tables of the database. 0 is the default value, which means the system does not purge summary data.
Removal of data from production database: Data Older than (days) The number of days after which statistical and event data are removed from the production database. The default value is 7. The minimum value is 2.
Removal of data from production database: Audit Data Older than (days) The number of days after which configuration management audit data are removed from the production database. The default value is 7. The minimum value is 2.
Removal of data from production database: When to begin moving data The number of minutes between attempts by IBM Sterling Control Center Monitor to remove data from the production database. Or, the time of day to begin removing data.
Removal of data from production database: Number of rows to select per DB transaction The maximum number of production database rows IBM Sterling Control Center Monitor reads into memory in preparation for removing row by row. The default value is 4000.
User ID The user ID you assign to access the database. Display only.