Vom Scheduler verwendete SQL-Anweisungen für DB2®

SQL-Anweisungen zum Einrichten der Tabellen

CREATE TABLE SCHEDULER_VARIABLES
(
    "NAME"     varchar(100) not null,
    "WERT"     integer,
    "TEXTWERT" varchar(250),
    primary key ( "NAME" )
);

CREATE TABLE SCHEDULER_TASKS
(
    "TASK_ID"           integer not null,
    "SPOOLER_ID"        varchar(100) not null,
    "CLUSTER_MEMBER_ID" varchar(100),
    "JOB_NAME"          varchar(255) not null,
    "ENQUEUE_TIME"      timestamp,
    "START_AT_TIME"     timestamp,
    "PARAMETERS"        clob,
    "TASK_XML"          clob,
    primary key( "TASK_ID" )
);

CREATE TABLE SCHEDULER_HISTORY
(
    "ID"                integer not null,
    "SPOOLER_ID"        varchar(100) not null,
    "CLUSTER_MEMBER_ID" varchar(100),
    "JOB_NAME"          varchar(255) not null,
    "START_TIME"        timestamp not null,
    "END_TIME"          timestamp,
    "CAUSE"             varchar(50),
    "STEPS"             integer,
    "EXIT_CODE"         integer,
    "ERROR"             numeric(1),
    "ERROR_CODE"        varchar(50),
    "ERROR_TEXT"        varchar(250),
    "PARAMETERS"        clob,
    "LOG"               blob,
    primary key( "ID" )
);

CREATE INDEX SCHEDULER_HIST_1 on SCHEDULER_HISTORY ( "START_TIME" );
CREATE INDEX SCHEDULER_HIST_2 on SCHEDULER_HISTORY ( "SPOOLER_ID" );
CREATE INDEX SCHEDULER_HIST_3 on SCHEDULER_HISTORY ( "JOB_NAME" );
CREATE INDEX SCHEDULER_HIST_4 on SCHEDULER_HISTORY ( "CLUSTER_MEMBER_ID" );

CREATE TABLE SCHEDULER_ORDERS
(
    "JOB_CHAIN"                   varchar(255) not null,
    "ID"                          varchar(255) not null,
    "SPOOLER_ID"                  varchar(100) not null,
    "DISTRIBUTED_NEXT_TIME"       timestamp,
    "OCCUPYING_CLUSTER_MEMBER_ID" varchar(100),
    "PRIORITY"                    integer not null,
    "STATE"                       varchar(100),
    "STATE_TEXT"                  varchar(100),
    "TITLE"                       varchar(200),
    "CREATED_TIME"                timestamp not null,
    "MOD_TIME"                    timestamp,
    "ORDERING"                    integer not null,
    "PAYLOAD"                     clob,
    "INITIAL_STATE"               varchar(100),
    "RUN_TIME"                    clob,
    "ORDER_XML"                   clob,
    primary key( "SPOOLER_ID", "JOB_CHAIN", "ID" )
);

CREATE TABLE SCHEDULER_ORDER_HISTORY
(
    "HISTORY_ID" integer not null,
    "JOB_CHAIN"  varchar(255) not null,
    "ORDER_ID"   varchar(255) not null,
    "SPOOLER_ID" varchar(100) not null,
    "TITLE"      varchar(200),
    "STATE"      varchar(100),
    "STATE_TEXT" varchar(100),
    "START_TIME" timestamp not null,
    "END_TIME"   timestamp not null,
    "LOG"        blob,
    primary key( "HISTORY_ID" )
);

CREATE INDEX SCHED_O_HIST_1 on SCHEDULER_ORDER_HISTORY ( "SPOOLER_ID" );
CREATE INDEX SCHED_O_HIST_2 on SCHEDULER_ORDER_HISTORY ( "JOB_CHAIN" );
CREATE INDEX SCHED_O_HIST_3 on SCHEDULER_ORDER_HISTORY ( "START_TIME" );

CREATE TABLE SCHEDULER_ORDER_STEP_HISTORY
(
  "HISTORY_ID"          numeric(9)     not null,
  "STEP"                numeric(9)     not null,
  "TASK_ID"             numeric(9)     not null,
  "STATE"               varchar(100)           ,
  "START_TIME"          timestamp      not null,
  "END_TIME"            timestamp              ,
  primary key ( "HISTORY_ID","STEP" )
);

CREATE TABLE SCHEDULER_CLUSTERS
(
    "MEMBER_ID"              varchar(100) not null, 
    "SCHEDULER_ID"           varchar(100) not null, 
    "PRECEDENCE"             integer, 
    "LAST_HEART_BEAT"        integer,
    "NEXT_HEART_BEAT"        integer, 
    "ACTIVE"                 numeric(1),
    "EXCLUSIVE"              numeric(1),
    "DEAD"                   numeric(1),
    "COMMAND"                varchar(250),
    "HTTP_URL"               varchar(100),
    "DEACTIVATING_MEMBER_ID" varchar(100),
    "XML"                    clob, 
    primary key( "MEMBER_ID" )
);