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