IEC Database References

References

The product documentation of SAP Convergent Charging 4.1 includes the following database references depending on your business requirements and IT strategy:

All these specilized documents relate to SAP CC IEC Database.

SAP Convergent Charging supports several database technologies and suppliers. Some features and capabilities of SAP CC require specialized technology, edition, version, or license of the RDBMS in your SAP system landscape.

Refer to the SAP CC 4.1 Product Availability Matrix in PAM for more information about the available RDBMS products, versions, and options.

SAP CC IEC Database

SAP CC IEC Database is the back-end database of SAP CC Import/Export Connector (IEC) of the SAP Convergent Charging software product provided by SAP for your industries.

It contains transactional data related to the business managed by an import/export connector (IEC) application customized in the system landscape:

  • Service consumption information (customer service usage) in the form of extended chargeable items (XCIs) exported by an IEC application

You implement the IEC database in an offline charging scenario to:

  • Provide offline acquisition services with low volume data and basic functions
  • Test batch charging operations by simulating an offline mediation system

Note

In most cases, the IEC database is not installed in your system landscape. You need to install the IEC database only if you want an IEC application to collect and store some customer service usages in the form of extended chargeable items (XCIs).

Consult the documentation of the CAT Tool user interface (SAP site) for more information about the use of the Export to Database Action and the Import XCI from Database Action components in a scenario script.

Recommendation

Note that other implementations are now preferred such as using SAP CC BART Server or SAP Convergent Invoicing (SAP CI) with the Consumption Item Management function enabled in SAP ERP/FI-CA.

Refer to the SAP CC Application Help (aka SAP CC Library) for more information.

Technology


Caution

Direct SQL queries on the database are not allowed. Do not modify the data stored in the database system.

Consult first your customer project team during the implementation phase of SAP CC.

Important Note

SAP does not recommend that you use direct SQL queries for statistics or monitoring.

Consult first your SAP Support Team.

Implementation in Your SAP System Landscape

To implement this database in your SAP system landscape, consider the following activities:

  • Sizing
  • Installation
  • Technical configuration in SAP CC
  • Validations
  • Technical operations (administration, software maintenance, purging and archiving, monitoring, and troubleshooting)

Sizing

Refer to the SAP CC Sizing and Performance Tuning Guide and SAP CC Sizing Guidelines for information about the the translation of your business requirements and IT strategy into hardware requirements based on predictions considering:

  • data volume
  • performance
  • robustness
  • scalability
  • high availability

The sizes of the hardware and database are influenced by both business aspects and technological aspects.

Notes

  • The regular growth of data volume and the load of the network must be taken into account as conditions for the initial sizing.
  • Confirm and adapt your initial sizing with performance and validation tests.

Installation

Refer to the SAP CC Installation Guide for information about the installation preparations, initial installation, and follow-up activities of this database system in your SAP CC system landscape.

Note

Refer to the information provided by the database supplier.

Technical Configuration in SAP CC

Refer to the SAP CC System Parameter Reference and SAP CC 4.1 Configuration Guide for more information about the configuration in SAP CC that relates to the databases. See the SQLHELPER_LOGIN system parameter.

Technical Operations in Your SAP System Landscape

During the project implementation phase or during the productive operation phase, consider the following activities:

  • Administration
  • Software maintenance
  • Purging and archiving
  • Monitoring
  • Troubleshooting

Software Maintenance

Refer to the information provided by the database supplier for more information about the software maintenance of your database systems.

Note

The software maintenance of SAP Convergent Charging may change the database schema or the stored data. When the SAP CC system administrator implements a support package (SP) or a patch level of SAP Convergent Charging, the maintenance procedures modify the back-end database. Refer to the delivery notes (SAP Notes) provided with the new versions of SAP CC.

Monitoring

DBA Cockpit

Install and use DBA Cockpit in SAP Solution Manager to monitor the back-end databases of SAP Convergent Charging. Refer to the SAP CC Operations Guide for more information.

SAP CC Activities

You can monitor the performance and health metrics reported by the instances of the running SAP CC Core Server system. These instances are connected to the back-end database system and manage several internal functions. By using CA Introscope for SAP in SAP Solution Manager, you can view the back-end activities that relate to the database commits, rollbacks, and prepared SQL statements.

See the {Database Name} on {Hostname} ({Database Type} DB) metric node in the SAP CC Metric Reference and Performance Troubleshooting for more information and user assistance.

Troubleshooting

Communication From Logs Performance

You use SAP Solution Manager to detect connection or communication problems.

You use the SAP CC Admin+ user interface:

You use the logs of the database system.

You use the logs and traces recorded in the SAP CC system.

You use SAP Solution Manager.

Related Documentation

For more information and user assistance, consult the related product documentation of SAP Convergent Charging 4.1 in SAP Help Portal.

Project Implementation Phase

For more information during the project implementation phase, refer to the:

Production Operation Phase

For more information during the production operation phase, refer to the:

Note

Refer to the appropriate SAP Note before updating your back-end database system when implementing a support package (SP) or a patch level of the SAP Convergent Charging software.

Upgrade Phase

For more information during the upgrade phase, refer to the:

Additional Documentation

For more information about the business services, features, processes, and functions of SAP Convergent Charging, consult the: