Database transfer: Download the script and view instructions to delete existing databases for DB2 for z/OS

Manual steps from the Configuration Wizard are included in HCL 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. 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;