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