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.