Legacy platform

Manually creating objects on Db2 - setting up scripts

About this task

To set up the scripts:

Procedure

  1. Create tablespaces where the Sterling Call Center tables and indexes reside.
  2. Only complete this step if you are manually creating database tables after installation (instead of having installation create them automatically). Modify the <INSTALL_DIR>/repository/scripts/EFrame_TableChanges.sql file to reference your newly created tablespaces.

Results

The DDLs in the Sterling Call Center scripts create a standard set of indexes. You may need to create additional indexes according to your business practice.