+

Search Tips   |   Advanced Search

Database transfer: Download the script and setup the DB2 database

Note that manual steps from the Configuration Wizard can be found in the IBM Knowledge Center.

  1. Copy the downloaded script to the database server and extract it.

  2. Run the SQL statements listed in this script in the 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;


Parent Manual Steps: Database Transfer