The Core Database of SAP Convergent Charging includes the following database tablespaces. They are defined to optimize the storage of data in the database system (IBM DB2).
The database always includes tablespaces dedicated to the data and relating tablespaces that include the database indexes.
To optimize the data storage, the database administrator (dba) creates and maintains the following tablespaces in the database:
| Name | Description |
|---|---|
| ACCESS_DATA | This tablespace contains the tables used to store the chronologies of the mappings |
| ACCESS_INDX | This tablespace contains the indexes used to store the chronologies of the mappings |
| ALLOWANCE_DATA | This tablespace contains the tables used to store data related to the allowances |
| ALLOWANCE_INDX | This tablespace contains the indexes used for the allowances |
| CATALOG_DATA | This tablespace contains the tables used to store the objects belonging to the catalog |
| CATALOG_INDX | This tablespace contains the indexes used for the objects belonging to the catalog |
| COUNTER_DATA | This tablespace contains the table used to store the counters declared in subscriptions and provider contracts |
| COUNTER_INDX | This tablespace contains the indexes used for counters |
| C_SNAPSHOT_DATA | This tablespace contains the table used to store counter values for subscriptions and provider contracts |
| C_SNAPSHOT_INDX | This tablespace contains the indexes used for counter values |
| MONITORING_DATA | This tablespace contains the tables used to store the objects used for monitoring purpose, such as data files metadata |
| MONITORING_INDX | This tablespace contains the indexes used for the objects used for monitoring purpose, such as data files metadata |
| OBJECT_CHANGE_DATA | This tablespace contains the tables used to store data related to the object change log of detailed audit |
| OBJECT_CHANGE_INDX | This tablespace contains the indexes used for object change log of detailed audit |
| PRERATING_DATA | This tablespace contains the tables used to store prerating data |
| PRERATING_INDX | This tablespace contains the indexes used for prerating data |
| SESSION_DATA | This tablespace contains the tables used to store session-based events and charging session histories for failover purposes |
| SESSION_INDX | This tablespace contains the indexes used for session-based events and charging session histories for failover purposes |
| SUBSCRIBER_DATA | This tablespace is used to store the tables containing objects belonging to provider contracts and subscriptions |
| SUBSCRIBER_INDX | This tablespace contains the indexes used for the objects belonging to provider contracts and subscriptions |
Refer to the SAP CC Operations Guide for more information about the database monitoring, maintenance, or purging and archiving operations.
