Database transfer: Download the script and setup your DB2 database | HCL Digital Experience

Manual steps from the Configuration Wizard are included in HCL Digital Experience Product Documentation for reference and for advanced users. The procedure includes variables and steps for different databases. When you use the wizard to configure your deployment, it replaces the variable with information that you provided in the wizard. It also shows only the steps that are specific to your environment. The instructions that the wizard generates are specific to your environment.

About this task

Attention: All steps for all database environments are included without consideration for your environment. Use the Configuration Wizard to generate custom instructions for your environment.

Procedure

  1. Copy the downloaded script to the database server and extract it.
  2. Run the SQL statements that are listed in this script in your SQL processor.
    db2 -tvf SetupDB2Database.sql
    CONNECT TO WPSDB USER dba_ID USING dba_pwd;
CREATE SCHEMA release AUTHORIZATION configID;
COMMIT;

GRANT CONNECT, CREATETAB ON DATABASE TO GROUP WP_BASE_CONFIG_USERS;
GRANT EXECUTE ON PACKAGE NULLID.SYSSH200 TO GROUP WP_BASE_CONFIG_USERS;
GRANT ALTERIN, CREATEIN, DROPIN ON SCHEMA release TO GROUP WP_BASE_CONFIG_USERS;
GRANT USE OF TABLESPACE USERSPACE1 TO GROUP WP_BASE_CONFIG_USERS;
GRANT USAGE ON WORKLOAD SYSDEFAULTUSERWORKLOAD TO GROUP WP_BASE_CONFIG_USERS;



GRANT CONNECT ON DATABASE TO GROUP WP_BASE_RUNTIME_USERS;
GRANT EXECUTE ON PACKAGE NULLID.SYSSN100 TO GROUP WP_BASE_RUNTIME_USERS;
GRANT EXECUTE ON PACKAGE NULLID.SYSSN200 TO GROUP WP_BASE_RUNTIME_USERS;
GRANT EXECUTE ON PACKAGE NULLID.SYSSN300 TO GROUP WP_BASE_RUNTIME_USERS;
GRANT USAGE ON WORKLOAD SYSDEFAULTUSERWORKLOAD TO GROUP WP_BASE_RUNTIME_USERS;

CONNECT RESET;

CONNECT TO WPSDB USER dba_ID USING dba_pwd;
CREATE SCHEMA community AUTHORIZATION configID;
COMMIT;

GRANT CONNECT, CREATETAB ON DATABASE TO GROUP WP_BASE_CONFIG_USERS;
GRANT EXECUTE ON PACKAGE NULLID.SYSSH200 TO GROUP WP_BASE_CONFIG_USERS;
GRANT ALTERIN, CREATEIN, DROPIN ON SCHEMA community TO GROUP WP_BASE_CONFIG_USERS;
GRANT USE OF TABLESPACE USERSPACE1 TO GROUP WP_BASE_CONFIG_USERS;
GRANT USAGE ON WORKLOAD SYSDEFAULTUSERWORKLOAD TO GROUP WP_BASE_CONFIG_USERS;



GRANT CONNECT ON DATABASE TO GROUP WP_BASE_RUNTIME_USERS;
GRANT EXECUTE ON PACKAGE NULLID.SYSSN100 TO GROUP WP_BASE_RUNTIME_USERS;
GRANT EXECUTE ON PACKAGE NULLID.SYSSN200 TO GROUP WP_BASE_RUNTIME_USERS;
GRANT EXECUTE ON PACKAGE NULLID.SYSSN300 TO GROUP WP_BASE_RUNTIME_USERS;
GRANT USAGE ON WORKLOAD SYSDEFAULTUSERWORKLOAD TO GROUP WP_BASE_RUNTIME_USERS;

CONNECT RESET;

CONNECT TO WPSDB USER dba_ID USING dba_pwd;
CREATE SCHEMA customization AUTHORIZATION configID;
COMMIT;

GRANT CONNECT, CREATETAB ON DATABASE TO GROUP WP_BASE_CONFIG_USERS;
GRANT EXECUTE ON PACKAGE NULLID.SYSSH200 TO GROUP WP_BASE_CONFIG_USERS;
GRANT ALTERIN, CREATEIN, DROPIN ON SCHEMA customization TO GROUP WP_BASE_CONFIG_USERS;
GRANT USE OF TABLESPACE USERSPACE1 TO GROUP WP_BASE_CONFIG_USERS;
GRANT USAGE ON WORKLOAD SYSDEFAULTUSERWORKLOAD TO GROUP WP_BASE_CONFIG_USERS;



GRANT CONNECT ON DATABASE TO GROUP WP_BASE_RUNTIME_USERS;
GRANT EXECUTE ON PACKAGE NULLID.SYSSN100 TO GROUP WP_BASE_RUNTIME_USERS;
GRANT EXECUTE ON PACKAGE NULLID.SYSSN200 TO GROUP WP_BASE_RUNTIME_USERS;
GRANT EXECUTE ON PACKAGE NULLID.SYSSN300 TO GROUP WP_BASE_RUNTIME_USERS;
GRANT USAGE ON WORKLOAD SYSDEFAULTUSERWORKLOAD TO GROUP WP_BASE_RUNTIME_USERS;

CONNECT RESET;

CONNECT TO WPSDB USER dba_ID USING dba_pwd;
CREATE SCHEMA jcr AUTHORIZATION configID;
COMMIT;

GRANT CONNECT, CREATETAB ON DATABASE TO GROUP WP_JCR_CONFIG_USERS;
GRANT EXECUTE ON PACKAGE NULLID.SYSSH200 TO GROUP WP_JCR_CONFIG_USERS;
GRANT ALTERIN, CREATEIN, DROPIN ON SCHEMA jcr TO GROUP WP_JCR_CONFIG_USERS;
GRANT USE OF TABLESPACE USERSPACE1 TO GROUP WP_JCR_CONFIG_USERS;
GRANT USAGE ON WORKLOAD SYSDEFAULTUSERWORKLOAD TO GROUP WP_JCR_CONFIG_USERS;


GRANT USE OF TABLESPACE ICMLFQ32 TO GROUP WP_JCR_CONFIG_USERS;
GRANT USE OF TABLESPACE ICMLNF32 TO GROUP WP_JCR_CONFIG_USERS;
GRANT USE OF TABLESPACE ICMVFQ04 TO GROUP WP_JCR_CONFIG_USERS;
GRANT USE OF TABLESPACE ICMSFQ04 TO GROUP WP_JCR_CONFIG_USERS;
GRANT USE OF TABLESPACE CMBINV04 TO GROUP WP_JCR_CONFIG_USERS;
GRANT USE OF TABLESPACE ICMLSUSRTSPACE4 TO GROUP WP_JCR_CONFIG_USERS;


GRANT CONNECT ON DATABASE TO GROUP WP_JCR_RUNTIME_USERS;
GRANT EXECUTE ON PACKAGE NULLID.SYSSN100 TO GROUP WP_JCR_RUNTIME_USERS;
GRANT EXECUTE ON PACKAGE NULLID.SYSSN200 TO GROUP WP_JCR_RUNTIME_USERS;
GRANT EXECUTE ON PACKAGE NULLID.SYSSN300 TO GROUP WP_JCR_RUNTIME_USERS;
GRANT USAGE ON WORKLOAD SYSDEFAULTUSERWORKLOAD TO GROUP WP_JCR_RUNTIME_USERS;

CONNECT RESET;

CONNECT TO WPSDB USER dba_ID USING dba_pwd;
CREATE SCHEMA feedback AUTHORIZATION configID;
COMMIT;

GRANT CONNECT, CREATETAB ON DATABASE TO GROUP WP_PZN_CONFIG_USERS;
GRANT EXECUTE ON PACKAGE NULLID.SYSSH200 TO GROUP WP_PZN_CONFIG_USERS;
GRANT ALTERIN, CREATEIN, DROPIN ON SCHEMA feedback TO GROUP WP_PZN_CONFIG_USERS;
GRANT USE OF TABLESPACE USERSPACE1 TO GROUP WP_PZN_CONFIG_USERS;
GRANT USAGE ON WORKLOAD SYSDEFAULTUSERWORKLOAD TO GROUP WP_PZN_CONFIG_USERS;



GRANT CONNECT ON DATABASE TO GROUP WP_PZN_RUNTIME_USERS;
GRANT EXECUTE ON PACKAGE NULLID.SYSSN100 TO GROUP WP_PZN_RUNTIME_USERS;
GRANT EXECUTE ON PACKAGE NULLID.SYSSN200 TO GROUP WP_PZN_RUNTIME_USERS;
GRANT EXECUTE ON PACKAGE NULLID.SYSSN300 TO GROUP WP_PZN_RUNTIME_USERS;
GRANT USAGE ON WORKLOAD SYSDEFAULTUSERWORKLOAD TO GROUP WP_PZN_RUNTIME_USERS;

CONNECT RESET;

CONNECT TO WPSDB USER dba_ID USING dba–pwd;
CREATE SCHEMA likeminds AUTHORIZATION configID;
COMMIT;

GRANT CONNECT, CREATETAB ON DATABASE TO GROUP WP_PZN_CONFIG_USERS;
GRANT EXECUTE ON PACKAGE NULLID.SYSSH200 TO GROUP WP_PZN_CONFIG_USERS;
GRANT ALTERIN, CREATEIN, DROPIN ON SCHEMA likeminds TO GROUP WP_PZN_CONFIG_USERS;
GRANT USE OF TABLESPACE USERSPACE1 TO GROUP WP_PZN_CONFIG_USERS;
GRANT USAGE ON WORKLOAD SYSDEFAULTUSERWORKLOAD TO GROUP WP_PZN_CONFIG_USERS;



GRANT CONNECT ON DATABASE TO GROUP WP_PZN_RUNTIME_USERS;
GRANT EXECUTE ON PACKAGE NULLID.SYSSN100 TO GROUP WP_PZN_RUNTIME_USERS;
GRANT EXECUTE ON PACKAGE NULLID.SYSSN200 TO GROUP WP_PZN_RUNTIME_USERS;
GRANT EXECUTE ON PACKAGE NULLID.SYSSN300 TO GROUP WP_PZN_RUNTIME_USERS;
GRANT USAGE ON WORKLOAD SYSDEFAULTUSERWORKLOAD TO GROUP WP_PZN_RUNTIME_USERS;

CONNECT RESET;