Creating a default restart table after installation

You can also run the installation wizard again to create the default restart table (To start the installation wizard). Completing this procedure is useful when you have multiple target databases and are using one High-speed Apply Engine installation.

To create a restart table by using a command prompt

1. Locate the appropriate sample file for your database platform from the directory: installationDirectory/HighSpeedApply/highspeedapply/examples/

   • For Windows: installationDirectory/highspeedapply/examples
   • For UNIX: installationDirectory/highspeedapply/examples

   • oracle/CrtOraDefaultRestartTbl.sql
   • db2udb/CrtUDBDefaultRestartTbl.sql

   The following figure shows a sample DDL for a restart table.

   CREATE TABLE APERSCLT
    (  RESTART_ID         CHAR(16)     NOT NULL,
       REQUEST_ID         CHAR(4)      NOT NULL,
       RECORD_TYPE        CHAR         NOT NULL,
       AGENT_ID           SMALLINT     NOT NULL,
       RECORD_SEQUENCE    SMALLINT     NOT NULL,
       REQUEST_TIMESTAMP  DATE         NOT NULL,
       RECORD_TIMESTAMP   DATE         NOT NULL,
       TOTAL_LENGTH       INTEGER      NOT NULL,
       DATA               LONG VARCHAR NOT NULL
    )  ;
   
    CREATE UNIQUE INDEX APERSCLX ON APERSCLT
    (  RESTART_ID,
       RECORD_TYPE,
       AGENT_ID,
       RECORD_SEQUENCE
    )  ;
   
    CREATE PUBLIC SYNONYM BMCAPE_APERSCL FOR APERSCLT;
   
    GRANT SELECT, UPDATE, DELETE, INSERT ON APERSCLT TO PUBLIC;

2. Accept the default names and skip to the next step, or if necessary, edit the DDL as appropriate for your site.

   Important

   Do not edit the name of the public synonym. This synonym is the default value for the TableName parameter in the [Restart] section. If an apply request does not specify a restart table name, High-speed Apply Engine uses the table referenced by the public synonym.

3. Run the DDL file by issuing one of the following commands:

   • For Db2 LUW, from the DB2CMD prompt:

     Db2-t-f CrtUDBDefaultRestartTbl.sql

   • From a UNIX command prompt:

     sqlplus userid/password@CrtUDBRestartTbl tableName

   • For Oracle, from SQL*Plus:

      @CrtOraDefaultRestartTbl tableName

   Important

   If you are not already running SQL*Plus, you must supply your user ID and password to start the utility from a UNIX command prompt:

   sqlplus userid/password@CrtOraRestartTbl tableName