| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCross-Application Components |
1 | CCMSBI_CPH_BWPTR | CPH/BW: Reader Pointer for the Extraction of CPH Data | 5 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
2 | CCMSBI_CUSTDATA | Time-Dependent General MTE Data | 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
3 | CCMSBI_METHODS | Time-Dependent Reaction Methods | 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
4 | CCMSBI_THRH_VAL | Time-Dependent Threshold Values | 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
TOPDirectory |
5 | LDAPGATEW | LDAP Connector | 8 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
TOPMonitoring |
6 | ALALERTDB | Alert: alert database (general alert structure, raw message) | 11 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
7 | ALALERTX | CCMS Monitoring: Cache for Alerts Already Read | 18 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
8 | ALALRTGUID | GUIDs for CCMS Alert IDs (for Alert Framework) | 11 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
9 | ALDBSMTE | CCMS Monitoring Arch.: Database Segment: General MTE Data | 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
10 | ALDBSPERF | CCMS Monitoring Arch.: Database Segment: Performance MTE | 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
11 | ALDBSSMES | CCMS Monitoring Arch.: Database Segment: Status AttributeMTE | 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
12 | ALDBSTOOL | CCMS Monitoring Arch.: Database Segment: MTE Method Data | 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
13 | ALDWNTIME | Downtime of systems for availability calculations | 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
14 | ALMBCDATA | CCMS Monitoring Cache: Data for "MTEs of one Class" | 5 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
15 | ALMBRDATA | CCMS Monitoring Cache: Data for "MTEs of one Class" | 5 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
16 | ALMONIDEF | Alerts: Description of Monitor Definition Nodes | 15 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
17 | ALMTCUSGEN | Alert: MT-specific Customizing Class-independent | 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
18 | ALMTCUSMSC | Alert: MTE-specific Customizing: message container | 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
19 | ALMTCUSPER | Alert: MT-specific Customizing Performance-Class | 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
20 | ALMTCUSSMG | Alert: MT-specific Customizing: Single Message Class | 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
21 | ALMTMSCFIL | Alert: MTE-Specific Message Container Filter | 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
22 | ALPERFDB | Alert: Performance database | 5 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
23 | ALPERFDB_C | Alert: Performance Database | 5 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
24 | ALPERFOB | Alert: Performance Database Object Part | 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
25 | ALPFASSIGN | Alert: Assignment of Reorg/Coll Schema to MTE (New Version) | 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
26 | ALPFCOLLTID | TID List Created from ALPFREORG:Objects to Collect in PerfDB | 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
27 | ALPFTHRHIST_RWS | Performance Threshold History: Number of Records | 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
28 | ALPFTHRHIST_TB | Performance Threshold History | 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
29 | ALTIDTOOL | Alert: Assignment of tools to Tid | 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
30 | ALXMBALERT | Persistence Table for XMB Alert IDs | 5 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
31 | CCMSBIDATA | Time-Dependent General MTE Data | 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
32 | CCMSBIMETH | Time-Dependent MTE Reaction Methods | 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
33 | CCMSBITHRH | Time-Dependent MTE Threshold Values | 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
34 | CCMSBI_MTE_DATA | Time-Dependent General MTE Data | 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
35 | CCMSBI_MTE_METH | Time-Dependent MTE Reaction Methods | 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
36 | CCMSBI_MTE_THRH | Time-Dependent MTE Threshold Values | 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
37 | CSMBK_SEM | CSM_BK: Semantic and Token Definitions | 8 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
38 | CSMCENTOOL | CCMS Monitoring: Container for Methods Started Centrally | 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
39 | SCMC_NODE | Basic Data of Executed Monitors | 11 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
40 | SCMC_NODE_MSC | Additional Attributes for Message Container Nodes | 5 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
41 | SCMC_NODE_PERF | Additional Attributes for Performance Nodes | 5 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
42 | SCMC_NODE_SMES | Additional Attributes for Log Nodes | 5 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |
TOPProcess Monitoring Infrastructure |
43 | SSPIMOALERTS | PMI: Self-Monitoring, Table of Triggered Alerts | 14 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | | |