IBM Sterling Control Center Monitor internal tables

IBM® Sterling Control Center Monitor internal tables are used for many purposes by the product. You can use internal tables for external reporting, queries, or other purposes; however, they are not available for third-party reporting.

Attention: IBM does not guarantee compatibility with an earlier version of IBM Sterling Control Center Monitor, and tables might change without notice.

Tables introduced or updated in V6.1

See the API Reference on the IBM Sterling Control Center Monitor launch page to access the API interface for the following tables that are introduced in IBM Sterling Control Center Monitor V6.1:

  • CC_FILE_TRANSFER
  • CC_FILE_TRANSFER_DVG
  • CC_FILES
  • CC_META_DATA_LABELS
  • CC_PROCESS
  • CC_PROCESS_DVG
  • CC_REPORT
  • CC_SERVER_COMPONENT
  • CC_SERVER_PROPERTY
  • CC_TABLE_LAYOUT
  • CC_TABLE_VIEW
  • CC_TAG_MAPPING
  • CC_TOKEN
  • CC_UNPROCESSED_EVENT
  • CC_USER_LOCK
  • CC_USER_SESSION
  • ROLL_UP
  • X_CHANGE_HISTORY
  • X_PASSWORD_HISTORY
  • X_PROPERTY
  • X_TENANT
Important:
  • The CC_CLUSTER_EVENT table is now purged with a scheduled job once a day to avoid becoming oversized.
  • The CC_SERVER table is updated with several new columns.

Tables introduced in V6.0

See the API Reference on the IBM Sterling Control Center Monitor launch page to access the API interface for the following tables that were introduced in IBM Sterling Control Center Monitor V6.0:

  • CC_ACTION
  • CC_ACTION_GROUP
  • CC_ACTION_GROUP_ROLE
  • CC_CALENDAR
  • CC_CALENDAR_ROLE
  • CC_CALENDAR_DATE
  • CC_CLUSTER
  • CC_CLUSTER_EVENT
  • CC_DATA_VISIBILITY_GROUP
  • CC_DVG_CRITERIA
  • CC_EMAIL_LIST
  • CC_EMAIL_LIST_EMAIL_LIST
  • CC_EMAIL_LIST_ROLE
  • CC_EMAIL_LIST_USER
  • CC_EMAIL_RECIPIENT
  • CC_EMAIL_TEMPLATE
  • CC_ROLE
  • CC_ROLE_DVG
  • CC_ROLE_SERVER_GROUP
  • CC_RULE
  • CC_RULE_CRITERIA
  • CC_RULE_CRITERIA_ELEMENT
  • CC_RULE_SCHEDULE
  • CC_RULE_SERVER
  • CC_RULE_SERVER_GROUP
  • CC_SCHEDULE
  • CC_SCHEDULE_ROLE
  • CC_SEQUENCE
  • CC_SERVER
  • CC_SERVER_GROUP
  • CC_SERVER_MESSAGE
  • CC_SVR_MSG_CATEGORY
  • CC_USER_ALERT_CAT_LIMIT
  • CC_TEXT
  • CC_USER
  • CC_USER_ROLE
  • CC_SLC
  • CC_SLC_MESSAGE_LIST
  • CC_SLC_MILESTONE
  • CC_MESSAGE_LIST_ROLE CC_SLC_MILESTONE_PROPERTY
  • CC_MESSAGE_LIST_SERVER_MESSAGE
  • CC_SLC_SCHEDULE
  • CC_SERVER_SERVER_GROUP
  • CC_SERVER_GROUP_GROUP
  • CC_TIMEZONE
  • CC_REQUEST

Tables prior to V6.0

IBM Sterling Control Center Monitor contained the following tables prior to V6.0:

  • DURATION_MONITORS (No longer used)
  • TIME_MONITORS
  • LICENSES
  • CCC_INFO
  • CONFIG_JOBS
  • CONFIG_OBJECTS
  • CONFIG_SERVER_IDS
  • CONFIG_VERSIONS
  • AUDIT_LOG
  • FILE_COUNTS