Manual steps
from the Configuration Wizard are included in IBM Knowledge Center
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
- Copy the downloaded script to the database server and extract
it.
- Use your preferred
SQL processor, such as SPUFI, to run the script on the database server.
Run the DB2® commands
on z/OS® in the order
that is listed in the script.
Note: When you run this script when
no other database exists, you might receive a message that this script
is unsuccessful. You can ignore this message.
Example of the script that the Configuration Wizard generates.
SET CURRENT SQLID = 'dbadmin';
REVOKE CREATEIN, DROPIN ON SCHEMA jcr
FROM dbconfig_ID;
REVOKE SELECT ON SYSIBM.SYSTABLESPACE FROM dbconfig_ID;
REVOKE SELECT ON SYSIBM.SYSVIEWS FROM dbconfig_ID;
REVOKE SELECT ON SYSIBM.SYSDUMMY1 FROM dbconfig_ID;
REVOKE SELECT ON SYSIBM.SYSTRIGGERS FROM dbconfig_ID;
REVOKE SELECT ON SYSIBM.SYSINDEXPART FROM dbconfig_ID;
REVOKE SELECT ON SYSIBM.SYSINDEXES FROM dbconfig_ID;
REVOKE SELECT ON SYSIBM.SYSSYNONYMS FROM dbconfig_ID;
REVOKE SELECT ON SYSIBM.SYSDATABASE FROM dbconfig_ID;
COMMIT;
DROP TABLESPACE WPFDBK.fdbkdbts;
COMMIT;
DROP TABLESPACE WPLM.lmdbts;
COMMIT;
DROP DATABASE WPREL;
COMMIT;
DROP DATABASE WPCOMM;
COMMIT;
DROP DATABASE WPCUST;
COMMIT;
DROP DATABASE WPJCR;
COMMIT;
DROP DATABASE WPFDBK;
COMMIT;
DROP DATABASE WPLM;
COMMIT;
DROP STOGROUP WPSSG;
COMMIT;
REVOKE SELECT ON SYSIBM.SYSCOLUMNS FROM dbconfig_ID;
REVOKE SELECT ON SYSIBM.SYSTABLES FROM dbconfig_ID;
REVOKE SELECT ON SYSIBM.SYSRELS FROM dbconfig_ID;
REVOKE SELECT ON SYSIBM.SYSFOREIGNKEYS FROM dbconfig_ID;
COMMIT;
REVOKE USE OF BUFFERPOOL BP2 FROM dbconfig_ID;
COMMIT;
REVOKE USE OF BUFFERPOOL BP32K1 FROM dbconfig_ID;
COMMIT;
REVOKE USE OF BUFFERPOOL BP3 FROM dbconfig_ID;
COMMIT;