Database Setup

Before you proceed with the Installation of Kony Push Notification Server, ensure that you install the Kony Databases. For further information on Kony Database Setup, following are the databases supported by Kony MobileFabric Engagement Services.

MySQL

Follow these steps to execute MySQL DB scripts:

1. Create a database with a name "kpnsdb" with character set as "utf8" and collate as "utf8_unicode_ci" using following command

   -> CREATE DATABASE kpnsdb CHARACTER SET utf8 COLLATE utf8_unicode_ci;

2. Execute the scripts in below order:
   1. V1__KPNSDB_MYSQL_Tables_7.0.0.sql
   2. V2__KPNSDB_MYSQL_Views_7.0.0.sql
   3. V3__KPNSDB_MYSQL_MasterData_7.0.0.sql
   4. V4__KPNSDB_MYSQL_STORED_FUNCS_7.0.0.sql
   5. V5__KPNSDB_MYSQL_STORED_PROCS_7.0.0.sql
   6. V7__UPGRADE_TO_7.0.0.M2.sql
   7. V8__UPGRADE_TO_7.0.0.M3.sql
   8. V9__UPGRADE_TO_7.0.0.GA.sql
   9. V10__UPGRADE_TO_7.0.1.sql
   10. V11__UPGRADE_TO_7.1.sql
   11. V12__UPGRADE_TO_7.1.0.3.sql
   12. V13__UPGRADE_TO_7.2.sql

Oracle

Follow these steps to execute Oracle DB scripts:

1. Create a user / schema with a name "kpnsdb" and provide below grants to "KPNSDB" User schema.

   Note: Below grants commands need to be executed with role "sysdba" from SQL*Plus.

   GRANT CONNECT,RESOURCE,CREATE VIEW TO KPNSDB;
GRANT CREATE JOB to KPNSDB;
GRANT MANAGE SCHEDULER to KPNSDB;
   

2. Execute the scripts in below order:
   1. V1__KPNSDB_ORACLE_Tables_7.0.0.sql
   2. V2__KPNSDB_ORACLE_Views_7.0.0.sql
   3. V3__KPNSDB_ORACLE_MasterData_7.0.0.sql
   4. V4__KPNSDB_ORACLE_STORED_FUNCS_7.0.0.sql
   5. V5__KPNSDB_ORACLE_STORED_PROCS_7.0.0.sql
   6. V7__UPGRADE_TO_7.0.0.M2.sql
   7. V8__UPGRADE_TO_7.0.0.M3.sql
   8. V9__UPGRADE_TO_7.0.0.GA.sql
   9. V10__UPGRADE_TO_7.0.1.sql
   10. V11__UPGRADE_TO_7.1.sql
   11. V12__UPGRADE_TO_7.1.0.3.sql
   12. V13__UPGRADE_TO_7.2.sql

DB2

Follow these steps to execute DB2 DB scripts:

1. Create a database with a name KPNS.
2. Execute the below script to create tablespace <tablespace-name>
   DB2_CREATE-BIG-TABLESPACE.sqlcommand > db2 -td';' -vf DB2_CREATE-BIG-TABLESPACE.sql > kpns_tbs.log
3. Create the required (kpnsdb) schemas in KPNS database using the below script:

   DB2_CREATE_USERS.SQL

   command > db2 -td';' -vf DB2_CREATE_USERS.SQL > kpns_create_users.log

4. Execute the scripts in below order:

   1. V1__KPNSDB_DB2_Tables_7.0.0.sql

      command > db2 -td';' -vf V1__KPNSDB_DB2_Tables_7.0.0.sql > kpnsdb_create.log

   2. V2__KPNSDB_DB2_Views_7.0.0.sql

      command > db2 -td';' -vf V2__KPNSDB_DB2_Views_7.0.0.sql > kpnsdb_view.log

   3. V3__KPNSDB_DB2_MasterData_7.0.0.sql

      command > db2 -td';' -vf V3__KPNSDB_DB2_MasterData_7.0.0.sql > kpnsdb_master_data.log

   4. V4__KPNSDB_DB2_STORED_FUNCS_7.0.0.sql

      command > db2 -td':' -vf V4__KPNSDB_DB2_STORED_FUNCS_7.0.0.sql

   5. V5__KPNSDB_DB2_STORED_PROCS_7.0.0.sql

      command > db2 -td':' -vf V5__KPNSDB_DB2_STORED_PROCS_7.0.0.sql

   6. V7__UPGRADE_TO_7.0.0.M2.sql

      command > db2 -td':' -vf V7__UPGRADE_TO_7.0.0.M2.sql

   7. V8__UPGRADE_TO_7.0.0.M3.sql

      command > db2 -td':' -vf V8__UPGRADE_TO_7.0.0.M3.sql

   8. V9__UPGRADE_TO_7.0.0.GA.sql

      command > db2 -td':' -vf V9__UPGRADE_TO_7.0.0.GA.sql

   9. V10__UPGRADE_TO_7.0.1.sql

      command > db2 -td':' -vf V10__UPGRADE_TO_7.0.1.sql

   10. V11__UPGRADE_TO_7.1.sql
5. Update DB2_KPNSDB_JOB_SCHEDULE.sql with the database userid and the password.
6. Use DB2_kpns_job.sh to configure a scheduled job to run at 02:00 AM every day. Refer DB2_crontab-schedule.txt file for configuring the schedule job.

Microsoft SQL

Follow these steps to execute MS SQL Server DB scripts:

1. Execute the below command to create a database with name as KPNS and schema with name as KPNSDB.

   V1__KPNSDB_SQLServer_CREATE_DB_SCHEMAS_7.0.0.SQL

2. Execute the scripts in below order:
   1. V2__KPNSDB_SQLServer_Tables_7.0.0.sql
   2. V3__KPNSDB_SQLServer_Views_7.0.0.sql
   3. V4__KPNSDB_SQLServer_MasterData_7.0.0.sql
   4. V5__KPNSDB_SQLServer_STORED_FUNCS_7.0.0.sql
   5. V6__KPNSDB_SQLServer_STORED_PROCS_7.0.0.sql
   6. V7__UPGRADE_TO_7.0.0.M2.sql
   7. V8__UPGRADE_TO_7.0.0.M3.sql
   8. V9__UPGRADE_TO_7.0.0.GA.sql
   9. V10__UPGRADE_TO_7.0.1.sql
   10. V11__UPGRADE_TO_7.1.sql
   11. V12__UPGRADE_TO_7.1.0.3.sql
   12. V13__UPGRADE_TO_7.2.sql
3. Use SQL_KPNSDB_JOB_SCHEDULE.sql to configure the schedule job that should run at 02:00 AM every day.

Copyright © 2015 Temenos AG. All rights reserved.