IBM DB2 Tablespaces
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.
A-Z Index
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 |
| 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 |
Additional Information
Implementation Project Phase
- Refer to the SAP CC Sizing Guidelines for more information about the hardware sizing with SAP Convergent Charging.
- Refer to the SAP CC Installation Guide for more information about the installation preparations.
Production Operation Phase
Refer to the SAP CC Operations Guide for more information about the database monitoring, maintenance, or purging and archiving operations.
- The SAP CC Admin+ Tool user interface provides you with some purge commands to maintain the back-end database.