Installing the TELCO database

To install the TELCO database on the data node, you run a script that creates the TELCO database, tables, constraints, and indexes.

Procedure

Log on to the data node with a user ID that has access to the IBM® DB2® database. For example, db2inst1.
Navigate to /opt/IBM/IS_CSP_CustomerInsight_1.0.4/CSP_CustomerInsight_DBLoader/script/
Enter the following command to run the script:
```
db2 -tvf TELCO_Db2.sql
```

Verify that the database tables exist. Type the following commands:

db2 connect to TELCO;
db2 list tables for schema NPS;

Information similar to the following message is displayed:

FACTOR_IMPORTANCE              NPS             T     2015-06-07-22.46.41.072519
FACT_SCORE                     NPS             T     2015-06-07-22.46.41.815746
MASTER_CUSTOMER                NPS             T     2015-06-07-22.46.41.833610
MASTER_DATA_ACTIVITY_LOCATION  NPS             T     2015-06-07-22.46.41.848970
MASTER_DEVICE                  NPS             T     2015-06-07-22.46.41.864207
PREDICTED_NETWORK_NPS_SCORE    NPS             T     2015-06-07-22.46.41.864587
PREDICTED_SUBSCRIBER_NPS_SCORE NPS             T     2015-06-07-22.46.41.864940
STAGING_NPS_SCORE_TABLE        NPS             T     2015-06-07-22.46.41.865220

db2 list tables for schema BBCI

Information similar to the following message is displayed:

CGR_DEVICE                       BBCI             T     2015-09-09-02.12.13.907406
CHURN_DATA                       BBCI             T     2015-08-20-15.56.39.964202
CHURN_MANAGEMENT                 BBCI             T     2015-08-19-01.33.27.083252
CHURN_MANAGEMENT_HISTORY         BBCI             T     2015-09-11-16.47.45.466452
SUBSCRIBER_BILLING               BBCI             T     2015-09-11-16.03.21.410002
SUBSCRIBER_CARE                  BBCI             T     2015-09-11-16.04.12.393064
SUBSCRIBER_CRM                   BBCI             T     2015-09-11-16.05.00.176739
SUBSCRIBER_LEVEL_CX_SCORE_WEEKLY BBCI             T     2015-08-20-16.02.13.778290
CHURN_TREND                      BBCI             T     2015-08-20-16.01.00.876379
TOP_CHURN_FACTORS                BBCI             T     2015-08-20-16.00.52.486780