Ubik Batch Server Installation Guide

From UbikWiki

(Difference between revisions)
(→End installation)
(→Add a Server)

Line 1,606:

Line 1,606:

=== Open menu Configuration > Manage Consoles ===
=== Open menu Configuration > Manage Consoles ===
=== Add a Server ===
=== Add a Server ===
-
Click on [[Image:]]
+
Click on [[Image:Image015.png]]
=== Fill this form ===
=== Fill this form ===

Revision as of 15:31, 4 November 2007


Contents

Requirements:

JDK

First install a JDK 5 or an upper version:


Install only JDK (JRE, demo and source code are not necessary).

Install in directory E:\local\jdk1.5.x_xx


The location will be further referenced as <JAVA_HOME>


The installation procedure requires the following elements:

  • LAST_VERSION\installer\console-install-pack-4.0.0.x.jar
  • LAST_VERSION\scripts-sql\console-oracle.ddl


Database

You must have a dedicated schema to the repository server.


Batch Server Installation steps:

Create the Database:

Play the following script:

  • Oracle Script: 
DROP TABLE batch_appender cascade constraints;
 
    DROP TABLE batch_config cascade constraints;
 
    DROP TABLE batch_console_trace cascade constraints;
 
    DROP TABLE batch_duration cascade constraints;
 
    DROP TABLE batch_head cascade constraints;
 
    DROP TABLE batch_head_history cascade constraints;
 
    DROP TABLE batch_head_synthesis cascade constraints;
 
    DROP TABLE batch_launch cascade constraints;
 
    DROP TABLE batch_launch_parameter cascade constraints;
 
    DROP TABLE batch_launch_trigger cascade constraints;
 
    DROP TABLE batch_linker cascade constraints;
 
    DROP TABLE batch_linker_batches cascade constraints;
 
    DROP TABLE batch_lock cascade constraints;
 
    DROP TABLE batch_start cascade constraints;
 
    DROP TABLE batch_start_do cascade constraints;
 
    DROP TABLE batch_start_parameter cascade constraints;
 
    DROP TABLE batch_stat cascade constraints;
 
    DROP TABLE batch_trigger cascade constraints;
 
    DROP TABLE batch_trt cascade constraints;
 
    DROP TABLE bs_group_columns cascade constraints;
 
    DROP TABLE cb_deployment cascade constraints;
 
    DROP TABLE cb_deployment_event cascade constraints;
 
    DROP TABLE cb_memory_monitoring_info cascade constraints;
 
    DROP TABLE cb_pool_monitoring_info cascade constraints;
 
    DROP TABLE cg_batch_start cascade constraints;
 
    DROP TABLE cg_file_config cascade constraints;
 
    DROP TABLE cg_file_m_cfg cascade constraints;
 
    DROP TABLE cg_file_s_cfg cascade constraints;
 
    DROP TABLE cg_id_record cascade constraints;
 
    DROP TABLE cg_id_record_keys cascade constraints;
 
    DROP TABLE cg_mfcg_positions cascade constraints;
 
    DROP TABLE cg_multi_file_cfg cascade constraints;
 
    DROP TABLE console_lifecycle cascade constraints;
 
    DROP TABLE dao_file_batch_start cascade constraints;
 
    DROP TABLE do_sql_batch_start cascade constraints;
 
    DROP TABLE do_sql_batch_start_gc cascade constraints;
 
    DROP TABLE fcg_positions cascade constraints;
 
    DROP TABLE file_batch_start cascade constraints;
 
    DROP TABLE file_config cascade constraints;
 
    DROP TABLE file_transfert_config cascade constraints;
 
    DROP TABLE group_lock cascade constraints;
 
    DROP TABLE id_record cascade constraints;
 
    DROP TABLE id_record_keys cascade constraints;
 
    DROP TABLE last_batch_exec cascade constraints;
 
    DROP TABLE launch_family_status cascade constraints;
 
    DROP TABLE mail_target cascade constraints;
 
    DROP TABLE multi_file_config cascade constraints;
 
    DROP TABLE no_batch_start cascade constraints;
 
    DROP TABLE record_key_len cascade constraints;
 
    DROP TABLE record_key_pos cascade constraints;
 
    DROP TABLE scheduled_batch cascade constraints;
 
    DROP TABLE simple_file_config cascade constraints;
 
    DROP TABLE sql_batch_start cascade constraints;
 
    DROP TABLE timezone_console cascade constraints;
 
    DROP sequence seq_batch_appender;
 
    DROP sequence seq_batch_config;
 
    DROP sequence seq_batch_head;
 
    DROP sequence seq_batch_head_synthesis;
 
    DROP sequence seq_batch_linker;
 
    DROP sequence seq_batch_start;
 
    DROP sequence seq_batch_trigger;
 
    DROP sequence seq_cb_deployment;
 
    DROP sequence seq_cb_deployment_event;
 
    DROP sequence seq_console_trace;
 
    DROP sequence seq_ct_file_cfg;
 
    DROP sequence seq_file_config;
 
    DROP sequence seq_id_record;
 
    DROP sequence seq_lifecycle;
 
    DROP sequence seq_memory_monitor;
 
    DROP sequence seq_scheduled_batch;
 
    CREATE TABLE batch_appender (
        bcf_id number(19,0) NOT NULL,
        bar_class_name varchar2(200 char) NOT NULL,
        bar_console_id varchar2(100 char) NOT NULL,
        bar_jndi_connection varchar2(75 char),
        bar_id_computer varchar2(150 char),
        bar_saving_dir varchar2(200 char),
        bca_bcf_id number(10,0) NOT NULL,
        ba_index number(10,0),
        PRIMARY KEY (bcf_id)
    );
 
    CREATE TABLE batch_config (
        bcf_id number(10,0) NOT NULL,
        bcf_console_id varchar2(100 char) NOT NULL,
        bcf_group varchar2(100 char) NOT NULL,
        bcf_name varchar2(100 char) NOT NULL,
        bcf_class varchar2(150 char) NOT NULL,
        bcf_desc varchar2(150 char),
        bcf_min_job number(10,0) NOT NULL,
        bcf_max_job number(10,0) NOT NULL,
        bcf_min_threads number(10,0) NOT NULL,
        bcf_max_threads number(10,0) NOT NULL,
        bcf_wait_time number(19,0),
        bcf_tempo number(19,0),
        bcf_action_error varchar2(50 char) NOT NULL,
        bcf_disabled char(1 char) NOT NULL,
        bcf_id_computer varchar2(150 char),
        PRIMARY KEY (bcf_id)
    );
 
    CREATE TABLE batch_console_trace (
        cte_id number(19,0) NOT NULL,
        cte_console_id varchar2(100 char) NOT NULL,
        cte_user varchar2(255 char) NOT NULL,
        cte_object varchar2(255 char) NOT NULL,
        cte_operation varchar2(100 char) NOT NULL,
        cte_arguments_names clob NOT NULL,
        cte_arguments_values clob NOT NULL,
        cte_date timestamp NOT NULL,
        PRIMARY KEY (cte_id)
    );
 
    CREATE TABLE batch_duration (
        bdn_console_id varchar2(255 char) NOT NULL,
        bdn_name varchar2(255 char) NOT NULL,
        bdn_duration number(19,0) NOT NULL,
        bdn_incremental_alert number(10,0) NOT NULL,
        PRIMARY KEY (bdn_console_id, bdn_name)
    );
 
    CREATE TABLE batch_head (
        bch_console_id varchar2(255 char) NOT NULL,
        bch_id number(19,0) NOT NULL,
        bch_name varchar2(255 char) NOT NULL,
        bch_group varchar2(255 char) NOT NULL,
        bch_launch_name varchar2(255 char),
        bch_dt_start timestamp NOT NULL,
        bch_dt_end timestamp,
        bch_lines_read number(10,0),
        bch_nb_err number(10,0),
        bch_err varchar2(255 char),
        bch_status varchar2(255 char) NOT NULL,
        PRIMARY KEY (bch_console_id, bch_id)
    );
 
    CREATE TABLE batch_head_history (
        bch_id number(19,0) NOT NULL,
        bch_console_id varchar2(255 char) NOT NULL,
        bch_name varchar2(255 char) NOT NULL,
        bch_group varchar2(255 char) NOT NULL,
        bch_launch_name varchar2(255 char),
        bch_dt_start timestamp NOT NULL,
        bch_dt_end timestamp,
        bch_lines_read number(10,0),
        bch_nb_err number(10,0),
        bch_err varchar2(255 char),
        bch_status varchar2(255 char) NOT NULL,
        PRIMARY KEY (bch_id)
    );
 
    CREATE TABLE batch_head_synthesis (
        bhs_id number(19,0) NOT NULL,
        bhs_console_id varchar2(100 char) NOT NULL,
        bhs_group_name varchar2(100 char) NOT NULL,
        bhs_batch_name varchar2(100 char) NOT NULL,
        bhs_launch_name varchar2(150 char),
        bhs_avg_exec_time number(10,0),
        bhs_avg_exec_tzlr number(10,0),
        bhs_min_exec_time number(10,0),
        bhs_max_exec_time number(10,0),
        bhs_nb_exec number(10,0),
        bhs_nb_exec_zlr number(10,0),
        bhs_nb_exec_szl number(10,0),
        bhs_nb_errors number(10,0),
        bhs_record_date timestamp NOT NULL,
        PRIMARY KEY (bhs_id)
    );
 
    CREATE TABLE batch_launch (
        blh_console_id varchar2(100 char) NOT NULL,
        blh_group_name varchar2(50 char) NOT NULL,
        blh_batch_name varchar2(50 char) NOT NULL,
        blh_launch_name varchar2(150 char) NOT NULL,
        blh_disabled char(1 char),
        blh_disabled_bkp char(1 char),
        blh_min_job number(10,0),
        blh_max_job number(10,0),
        blh_max_threads number(10,0),
        blh_tempo number(19,0),
        blh_jndi_connection varchar2(25 char) NOT NULL,
        blh_nb_traitement number(10,0),
        blh_timestamp timestamp,
        PRIMARY KEY (blh_console_id, blh_group_name, blh_batch_name, blh_launch_name)
    );
 
    CREATE TABLE batch_launch_parameter (
        blp_console_id varchar2(100 char) NOT NULL,
        blp_group_name varchar2(25 char) NOT NULL,
        blp_batch_name varchar2(50 char) NOT NULL,
        blp_launch_name varchar2(150 char) NOT NULL,
        blp_parameter_position number(10,0) NOT NULL,
        blp_parameter_value varchar2(255 char),
        blp_parameter_class varchar2(255 char),
        blp_timestamp timestamp,
        PRIMARY KEY (blp_console_id, blp_group_name, blp_batch_name, blp_launch_name, blp_parameter_position)
    );
 
    CREATE TABLE batch_launch_trigger (
        blt_id number(10,0) NOT NULL,
        blt_class_name varchar2(100 char) NOT NULL,
        blt_console_id varchar2(100 char) NOT NULL UNIQUE,
        blt_batch_group varchar2(50 char) NOT NULL UNIQUE,
        blt_batch_name varchar2(50 char) NOT NULL UNIQUE,
        blt_launch_name varchar2(150 char) NOT NULL UNIQUE,
        blt_group varchar2(150 char) NOT NULL UNIQUE,
        blt_name varchar2(150 char) NOT NULL UNIQUE,
        blt_desc varchar2(200 char),
        blt_start_time timestamp NOT NULL,
        blt_end_time timestamp,
        blt_misfire_inst number(10,0) NOT NULL,
        blt_calendar varchar2(150 char),
        blt_timestamp timestamp,
        blt_repeat_count number(10,0),
        blt_repeat_interval number(20,0),
        blt_cron_expr varchar2(50 char),
        blt_timezone varchar2(50 char),
        PRIMARY KEY (blt_id)
    );
 
    CREATE TABLE batch_linker (
        bcl_id number(10,0) NOT NULL,
        bcl_class_name varchar2(100 char) NOT NULL,
        bcl_bcf_id number(10,0) NOT NULL,
        bcl_console_id varchar2(100 char) NOT NULL,
        bcl_position number(10,0) NOT NULL,
        bcl_strategy varchar2(50 char) NOT NULL,
        bcl_stop_on_error char(1 char),
        PRIMARY KEY (bcl_id)
    );
 
    CREATE TABLE batch_linker_batches (
        blb_bcl_id number(10,0) NOT NULL,
        blb_name varchar2(255 char)
    );
 
    CREATE TABLE batch_lock (
        blk_console_id varchar2(255 char) NOT NULL,
        blk_group varchar2(255 char) NOT NULL,
        blk_name varchar2(255 char) NOT NULL,
        blk_lock_date timestamp NOT NULL,
        PRIMARY KEY (blk_console_id, blk_group, blk_name)
    );
 
    CREATE TABLE batch_start (
        bcf_id number(19,0) NOT NULL,
        bst_console_id varchar2(100 char) NOT NULL,
        bst_multiple char(1 char) NOT NULL,
        bca_bcf_id number(10,0) NOT NULL,
        bs_index number(10,0),
        PRIMARY KEY (bcf_id)
    );
 
    CREATE TABLE batch_start_do (
        bsd_bst_id number(19,0),
        bsd_position number(10,0),
        bsd_class_name varchar2(200 char)
    );
 
    CREATE TABLE batch_start_parameter (
        bsp_bst_id number(19,0) NOT NULL,
        bsp_position number(10,0),
        bsp_value varchar2(1000 char),
        bsp_class_name varchar2(200 char)
    );
 
    CREATE TABLE batch_stat (
        bhs_console_id varchar2(100 char) NOT NULL,
        bhs_group varchar2(150 char) NOT NULL,
        bhs_batch varchar2(150 char) NOT NULL,
        bhs_launch varchar2(150 char) NOT NULL,
        bhs_min_exec_time number(19,0) NOT NULL,
        bhs_max_exec_time number(19,0) NOT NULL,
        bhs_avg_exec_time number(19,0) NOT NULL,
        PRIMARY KEY (bhs_console_id, bhs_group, bhs_batch, bhs_launch)
    );
 
    CREATE TABLE batch_trigger (
        bct_id number(10,0) NOT NULL,
        bct_class_name varchar2(100 char) NOT NULL,
        bct_bcf_id number(10,0) NOT NULL,
        bct_console_id varchar2(100 char) NOT NULL,
        bct_group varchar2(150 char) NOT NULL,
        bct_name varchar2(150 char) NOT NULL,
        bct_desc varchar2(200 char),
        bct_misfire_inst number(10,0) NOT NULL,
        bct_start_time timestamp,
        bct_end_time timestamp,
        bct_repeat_count number(10,0),
        bct_repeat_interval number(19,0),
        bct_calendar varchar2(150 char),
        bct_cron_expr varchar2(50 char),
        bct_timezone varchar2(50 char),
        PRIMARY KEY (bct_id)
    );
 
    CREATE TABLE batch_trt (
        bch_console_id varchar2(255 char) NOT NULL,
        bch_id number(19,0) NOT NULL,
        bct_id number(19,0) NOT NULL,
        bct_data clob,
        bct_err varchar2(255 char),
        PRIMARY KEY (bch_console_id, bch_id, bct_id)
    );
 
    CREATE TABLE bs_group_columns (
        bsgc_bcf_id number(19,0) NOT NULL,
        bsgc_table_column varchar2(255 char),
        bsgc_index number(10,0) NOT NULL,
        PRIMARY KEY (bsgc_bcf_id, bsgc_index)
    );
 
    CREATE TABLE cb_deployment (
        cbd_id number(19,0) NOT NULL,
        cbd_console_id varchar2(255 char),
        cbd_bar_id varchar2(255 char),
        cbd_last_event varchar2(255 char),
        PRIMARY KEY (cbd_id)
    );
 
    CREATE TABLE cb_deployment_event (
        cbde_id number(19,0) NOT NULL,
        cbde_event varchar2(255 char),
        cbde_date timestamp,
        cbde_message varchar2(255 char),
        cbde_event_id number(19,0) NOT NULL,
        PRIMARY KEY (cbde_event_id)
    );
 
    CREATE TABLE cb_memory_monitoring_info (
        mmi_id number(19,0) NOT NULL,
        mmi_console_id varchar2(100 char) NOT NULL,
        mmi_name varchar2(25 char) NOT NULL,
        mmi_date timestamp NOT NULL,
        mmi_value number(10,0),
        PRIMARY KEY (mmi_id)
    );
 
    CREATE TABLE cb_pool_monitoring_info (
        pmi_console_id varchar2(255 char) NOT NULL,
        pmi_id number(19,0) NOT NULL,
        pmi_pool_name varchar2(50 char) NOT NULL,
        pmi_date timestamp NOT NULL,
        pmi_name varchar2(25 char) NOT NULL,
        pmi_value number(10,0),
        PRIMARY KEY (pmi_console_id, pmi_id)
    );
 
    CREATE TABLE cg_batch_start (
        cbs_bcf_id number(19,0) NOT NULL,
        cbs_nb_lines number(10,0),
        PRIMARY KEY (cbs_bcf_id)
    );
 
    CREATE TABLE cg_file_config (
        bcf_id number(19,0) NOT NULL,
        cfsc_nb_synch number(10,0),
        PRIMARY KEY (bcf_id)
    );
 
    CREATE TABLE cg_file_m_cfg (
        cfmc_acfc_id number(19,0) NOT NULL,
        dcgmf_cbs number(19,0),
        dcgmf_index number(10,0),
        PRIMARY KEY (cfmc_acfc_id)
    );
 
    CREATE TABLE cg_file_s_cfg (
        cfsc_acfc_id number(19,0) NOT NULL,
        cfsc_file_name varchar2(200 char),
        cfsc_dao_class varchar2(200 char),
        dcgsf_cbs number(19,0),
        dcgsf_index number(10,0),
        PRIMARY KEY (cfsc_acfc_id)
    );
 
    CREATE TABLE cg_id_record (
        circ_id number(10,0) NOT NULL,
        circ_record varchar2(255 char),
        circ_irc_id number(10,0),
        circ_index number(10,0),
        PRIMARY KEY (circ_id)
    );
 
    CREATE TABLE cg_id_record_keys (
        cirk_id_cir number(10,0) NOT NULL,
        cirk_id varchar2(255 char),
        cirk_idx number(10,0) NOT NULL,
        PRIMARY KEY (cirk_id_cir, cirk_idx)
    );
 
    CREATE TABLE cg_mfcg_positions (
        cmp_fcg_id number(10,0) NOT NULL,
        cmp_position number(10,0),
        cmp_index number(10,0) NOT NULL,
        PRIMARY KEY (cmp_fcg_id, cmp_index)
    );
 
    CREATE TABLE cg_multi_file_cfg (
        cdmfc_id number(10,0) NOT NULL,
        cdmfc_file_name varchar2(250 char) NOT NULL,
        cdmfc_dfmc_id number(19,0) NOT NULL,
        cdmfc_index number(10,0),
        PRIMARY KEY (cdmfc_id)
    );
 
    CREATE TABLE console_lifecycle (
        bcl_event_id number(19,0) NOT NULL,
        bcl_console_id varchar2(300 char) NOT NULL,
        bcl_event varchar2(100 char) NOT NULL,
        bcl_date timestamp NOT NULL,
        bcl_user varchar2(300 char) NOT NULL,
        PRIMARY KEY (bcl_event_id)
    );
 
    CREATE TABLE dao_file_batch_start (
        dfbsc_bcf_id number(19,0) NOT NULL,
        bst_nb_lines number(10,0),
        PRIMARY KEY (dfbsc_bcf_id)
    );
 
    CREATE TABLE do_sql_batch_start (
        do_sql_bs_id number(19,0) NOT NULL,
        PRIMARY KEY (do_sql_bs_id)
    );
 
    CREATE TABLE do_sql_batch_start_gc (
        bst_v2_sqlbs_id number(19,0) NOT NULL,
        PRIMARY KEY (bst_v2_sqlbs_id)
    );
 
    CREATE TABLE fcg_positions (
        bsgc_fcg_id number(10,0) NOT NULL,
        fcgp_position number(10,0),
        fcgp_index number(10,0) NOT NULL,
        PRIMARY KEY (bsgc_fcg_id, fcgp_index)
    );
 
    CREATE TABLE file_batch_start (
        fbsc_bcf_id number(19,0) NOT NULL,
        fbsc_nb_lines number(10,0),
        fbsc_file_name varchar2(150 char),
        fbsc_line_desc varchar2(150 char),
        PRIMARY KEY (fbsc_bcf_id)
    );
 
    CREATE TABLE file_config (
        fcg_id number(10,0) NOT NULL,
        fcg_file_name varchar2(250 char) NOT NULL,
        dfbs_file_config number(19,0),
        dfbs_index number(10,0),
        PRIMARY KEY (fcg_id)
    );
 
    CREATE TABLE file_transfert_config (
        trf_console_id varchar2(100 char) NOT NULL,
        trf_ip_address varchar2(15 char) NOT NULL,
        trf_upload_dir varchar2(255 char) NOT NULL,
        trf_port number(10,0) NOT NULL,
        PRIMARY KEY (trf_console_id)
    );
 
    CREATE TABLE group_lock (
        glk_console_id varchar2(255 char) NOT NULL,
        glk_group varchar2(255 char) NOT NULL,
        glk_lock_date timestamp NOT NULL,
        PRIMARY KEY (glk_console_id, glk_group)
    );
 
    CREATE TABLE id_record (
        idr_id number(10,0) NOT NULL,
        idr_record varchar2(255 char),
        bsir_bcf_id number(10,0),
        bsir_index number(10,0),
        PRIMARY KEY (idr_id)
    );
 
    CREATE TABLE id_record_keys (
        idrk_bcf_id number(10,0) NOT NULL,
        idr_id varchar2(255 char),
        idrk_idx number(10,0) NOT NULL,
        PRIMARY KEY (idrk_bcf_id, idrk_idx)
    );
 
    CREATE TABLE last_batch_exec (
        lbe_console_id varchar2(100 char) NOT NULL,
        lbe_id number(19,0) NOT NULL,
        lbe_name varchar2(100 char) NOT NULL,
        lbe_group varchar2(100 char) NOT NULL,
        lbe_launch_name varchar2(150 char) NOT NULL,
        lbe_dt_start timestamp NOT NULL,
        lbe_dt_end timestamp,
        lbe_lines_read number(10,0),
        lbe_nb_err number(10,0),
        lbe_err varchar2(255 char),
        lbe_status varchar2(20 char) NOT NULL,
        PRIMARY KEY (lbe_console_id, lbe_id, lbe_name, lbe_group, lbe_launch_name)
    );
 
    CREATE TABLE launch_family_status (
        lfs_console_id varchar2(100 char) NOT NULL,
        lfs_launch_name varchar2(150 char) NOT NULL,
        lfs_status varchar2(1 char) NOT NULL,
        PRIMARY KEY (lfs_console_id, lfs_launch_name)
    );
 
    CREATE TABLE mail_target (
        mt_console_id varchar2(100 char) NOT NULL,
        mt_user_mail varchar2(255 char) NOT NULL,
        mt_batch_or_group_name varchar2(255 char) NOT NULL,
        mt_type varchar2(1 char) NOT NULL,
        PRIMARY KEY (mt_console_id, mt_user_mail, mt_batch_or_group_name)
    );
 
    CREATE TABLE multi_file_config (
        mfc_id number(10,0) NOT NULL,
        PRIMARY KEY (mfc_id)
    );
 
    CREATE TABLE no_batch_start (
        bst_no_bs_id number(19,0) NOT NULL,
        PRIMARY KEY (bst_no_bs_id)
    );
 
    CREATE TABLE record_key_len (
        rkl_len_id number(19,0) NOT NULL,
        fcgp_length number(10,0),
        cfsc_len_index number(10,0) NOT NULL,
        PRIMARY KEY (rkl_len_id, cfsc_len_index)
    );
 
    CREATE TABLE record_key_pos (
        rkp_pos_id number(19,0) NOT NULL,
        cfsc_position number(10,0),
        cfsc_pos_index number(10,0) NOT NULL,
        PRIMARY KEY (rkp_pos_id, cfsc_pos_index)
    );
 
    CREATE TABLE scheduled_batch (
        scb_id number(10,0) NOT NULL,
        scb_bcf_id number(10,0) UNIQUE,
        scb_console_id varchar2(100 char) NOT NULL,
        PRIMARY KEY (scb_id)
    );
 
    CREATE TABLE simple_file_config (
        sfc_id number(10,0) NOT NULL,
        fcg_dao_class varchar2(255 char),
        PRIMARY KEY (sfc_id)
    );
 
    CREATE TABLE sql_batch_start (
        bst_sbs_id number(19,0) NOT NULL,
        bst_nb_lines number(10,0),
        bst_jndi_connection varchar2(75 char),
        bst_sql_query varchar2(1000 char),
        bst_stored_proc char(1 char),
        PRIMARY KEY (bst_sbs_id)
    );
 
    CREATE TABLE timezone_console (
        tz_console_id varchar2(100 char) NOT NULL,
        tz_zone varchar2(100 char) NOT NULL,
        PRIMARY KEY (tz_console_id, tz_zone)
    );
 
    ALTER TABLE batch_appender 
        ADD constraint fk_ba_bc 
        FOREIGN KEY (bca_bcf_id) 
        REFERENCES batch_config;
 
    ALTER TABLE batch_launch_parameter 
        ADD constraint fk_blp_bl 
        FOREIGN KEY (blp_console_id, blp_group_name, blp_batch_name, blp_launch_name) 
        REFERENCES batch_launch;
 
    ALTER TABLE batch_launch_trigger 
        ADD constraint fk_blt_bl 
        FOREIGN KEY (blt_console_id, blt_batch_group, blt_batch_name, blt_launch_name) 
        REFERENCES batch_launch;
 
    ALTER TABLE batch_linker 
        ADD constraint fk_bl_bc 
        FOREIGN KEY (bcl_bcf_id) 
        REFERENCES batch_config;
 
    ALTER TABLE batch_linker_batches 
        ADD constraint fk_blb_bl 
        FOREIGN KEY (blb_bcl_id) 
        REFERENCES batch_linker;
 
    ALTER TABLE batch_start 
        ADD constraint fk_bs_bc 
        FOREIGN KEY (bca_bcf_id) 
        REFERENCES batch_config;
 
    ALTER TABLE batch_start_do 
        ADD constraint fk_bsd_dsbs 
        FOREIGN KEY (bsd_bst_id) 
        REFERENCES do_sql_batch_start;
 
    ALTER TABLE batch_start_parameter 
        ADD constraint fk_bsp_abs 
        FOREIGN KEY (bsp_bst_id) 
        REFERENCES sql_batch_start;
 
    ALTER TABLE batch_trigger 
        ADD constraint fk_bt_bc 
        FOREIGN KEY (bct_bcf_id) 
        REFERENCES batch_config;
 
    ALTER TABLE batch_trt 
        ADD constraint fk_bt_bh 
        FOREIGN KEY (bch_console_id, bch_id) 
        REFERENCES batch_head;
 
    ALTER TABLE bs_group_columns 
        ADD constraint fk_bgc_abs 
        FOREIGN KEY (bsgc_bcf_id) 
        REFERENCES sql_batch_start;
 
    ALTER TABLE cb_deployment_event 
        ADD constraint fk_de_d 
        FOREIGN KEY (cbde_id) 
        REFERENCES cb_deployment;
 
    ALTER TABLE cg_batch_start 
        ADD constraint fk_cbs_abs 
        FOREIGN KEY (cbs_bcf_id) 
        REFERENCES batch_start;
 
    ALTER TABLE cg_file_m_cfg 
        ADD constraint fk_cfmc_acfc 
        FOREIGN KEY (cfmc_acfc_id) 
        REFERENCES cg_file_config;
 
    ALTER TABLE cg_file_m_cfg 
        ADD constraint fk_dcgmf_cbs 
        FOREIGN KEY (dcgmf_cbs) 
        REFERENCES cg_batch_start;
 
    ALTER TABLE cg_file_s_cfg 
        ADD constraint fk_cfsc_acfc 
        FOREIGN KEY (cfsc_acfc_id) 
        REFERENCES cg_file_config;
 
    ALTER TABLE cg_file_s_cfg 
        ADD constraint fk_dcgsf_cbs 
        FOREIGN KEY (dcgsf_cbs) 
        REFERENCES cg_batch_start;
 
    ALTER TABLE cg_id_record 
        ADD constraint fk_cir_cdmfc 
        FOREIGN KEY (circ_irc_id) 
        REFERENCES cg_multi_file_cfg;
 
    ALTER TABLE cg_id_record_keys 
        ADD constraint fk_cirk_circ 
        FOREIGN KEY (cirk_id_cir) 
        REFERENCES cg_id_record;
 
    ALTER TABLE cg_mfcg_positions 
        ADD constraint fk_cfp_cdmfc 
        FOREIGN KEY (cmp_fcg_id) 
        REFERENCES cg_multi_file_cfg;
 
    ALTER TABLE cg_multi_file_cfg 
        ADD constraint fk_dmfc_cdmfc 
        FOREIGN KEY (cdmfc_dfmc_id) 
        REFERENCES cg_file_m_cfg;
 
    ALTER TABLE dao_file_batch_start 
        ADD constraint fk_dfbs_abs 
        FOREIGN KEY (dfbsc_bcf_id) 
        REFERENCES batch_start;
 
    ALTER TABLE do_sql_batch_start 
        ADD constraint fk_dsbs_sbs 
        FOREIGN KEY (do_sql_bs_id) 
        REFERENCES sql_batch_start;
 
    ALTER TABLE do_sql_batch_start_gc 
        ADD constraint fk_dsbsg_dsbsc 
        FOREIGN KEY (bst_v2_sqlbs_id) 
        REFERENCES do_sql_batch_start;
 
    ALTER TABLE fcg_positions 
        ADD constraint fk_fp_mfc 
        FOREIGN KEY (bsgc_fcg_id) 
        REFERENCES multi_file_config;
 
    ALTER TABLE file_batch_start 
        ADD constraint fk_fbs_abs 
        FOREIGN KEY (fbsc_bcf_id) 
        REFERENCES batch_start;
 
    ALTER TABLE file_config 
        ADD constraint fk_fc_dfbs 
        FOREIGN KEY (dfbs_file_config) 
        REFERENCES dao_file_batch_start;
 
    ALTER TABLE id_record 
        ADD constraint fk_ir_mfc 
        FOREIGN KEY (bsir_bcf_id) 
        REFERENCES multi_file_config;
 
    ALTER TABLE id_record_keys 
        ADD constraint fk_irk_ir 
        FOREIGN KEY (idrk_bcf_id) 
        REFERENCES id_record;
 
    ALTER TABLE multi_file_config 
        ADD constraint fk_mfc_fc 
        FOREIGN KEY (mfc_id) 
        REFERENCES file_config;
 
    ALTER TABLE no_batch_start 
        ADD constraint fk_nbs_abs 
        FOREIGN KEY (bst_no_bs_id) 
        REFERENCES batch_start;
 
    ALTER TABLE record_key_len 
        ADD constraint fk_rkl_csfc 
        FOREIGN KEY (rkl_len_id) 
        REFERENCES cg_file_config;
 
    ALTER TABLE record_key_pos 
        ADD constraint fk_rkp_csfc 
        FOREIGN KEY (rkp_pos_id) 
        REFERENCES cg_file_config;
 
    ALTER TABLE scheduled_batch 
        ADD constraint fk_sb_bc 
        FOREIGN KEY (scb_bcf_id) 
        REFERENCES batch_config;
 
    ALTER TABLE simple_file_config 
        ADD constraint fk_sfc_fc 
        FOREIGN KEY (sfc_id) 
        REFERENCES file_config;
 
    ALTER TABLE sql_batch_start 
        ADD constraint fk_sbs_abs 
        FOREIGN KEY (bst_sbs_id) 
        REFERENCES batch_start;
 
    CREATE sequence seq_batch_appender;
 
    CREATE sequence seq_batch_config;
 
    CREATE sequence seq_batch_head;
 
    CREATE sequence seq_batch_head_synthesis;
 
    CREATE sequence seq_batch_linker;
 
    CREATE sequence seq_batch_start;
 
    CREATE sequence seq_batch_trigger;
 
    CREATE sequence seq_cb_deployment;
 
    CREATE sequence seq_cb_deployment_event;
 
    CREATE sequence seq_console_trace;
 
    CREATE sequence seq_ct_file_cfg;
 
    CREATE sequence seq_file_config;
 
    CREATE sequence seq_id_record;
 
    CREATE sequence seq_lifecycle;
 
    CREATE sequence seq_memory_monitor;
    CREATE sequence seq_scheduled_batch;

Launch the installer:

Run the following command line:


<JAVA_HOME>\bin\java –jar <Path_To_Installer>\ console-install-pack-4.0.0.x.jar

This screen will appear:

Image:image001.png

Step 1

Click on next

Image:image002.png

Step 2

Click on next:

Image:image003.png


Step 3

Click on next:

Image:image004.png


Step 4: Installation Options

Fill in:

  • Installation Directory: Path where the Batch server will be installed
  • ID of the console: This ID must be unique and will be used in database to identify uniquely the Server Batches,…

Image:image005.jpg


Step 5: JMX Connectivity

Fill in:

  • JNDI Name of the console: Path where the Batch server will be installed
  • Port of the Naming Service: Check the chosen port is free
  • Port of the JMX Service: Check the chosen port is free


Image:image006.jpg

Step 6: Server Repository Database parameters

Fill in:

  • DB User: User of the Server Repository Database
  • DB Password: Password of the Server Repository Database
  • Class of the JDBC Driver
  • URL of the JDBC Connection (ex : jdbc:oracle:thin:@nladbl01.preprod.org:1529:tetrix04)


Image:image007.jpg


Step 7: Embedded BAR Server Configuration

This step configures the BAR Upload server that is shipped inside the Batch Server. This server receives BARs that are sent by the Batch Admin Web Application

Fill in:

  • BAR Server host: Host of the machine where the Batch Server will be running
  • BAR Server Port: Port of the server (check the port is not used)
  • BARs upload folder : Folder where the BARs will be stored


Image:image008.jpg


Step 8: Batch Server Logging Folder

This step configures the Root Folder for Logs. This folder will be further referenced as a JVM property called LOG_ROOT_PATH

Fill in:

  • Logging directory

Image:image009.jpg


Step 9: Mailer configuration

This step configures the Mail notification system. Each time an error occurs a mail will be sent using the configured parameters

Fill in:

  • Host of the mailer: Host of the Mail server
  • Port of the mailer: Port of the Mail server (defaults to 25)
  • Name of the mailer : Name the will appear in Mails
  • Mail of administrator: Mail of the technical administrator (used only if XML storage is chosen)


Image:image010.jpg

Step 10 : Environment parameters

This step configures environment parameters; it will generate a setenv.bat (for Windows) and setenv.sh (for Linux)

Fill in:

  • Name of the NT service (Identifies the NT service)
  • JAVA_HOME: It must be a JDK 5
  • JVM options: You may change –Xmx and –Xms and add other properties


Image:image011.jpg

End installation

Click on Next

Image:image012.jpg

Click on Next

Image:image013.jpg

Click on Install:

Image:image014.jpg

Installing from properties file

You have another option if you don’t want to re seize all options on each installation. The installer writes a file called “ant.install.properties” after each installation. This file contains all seized properties.

So you can use this properties file “ant.install.properties” for next installs, this file must be located in the folder from which you launch the installer.

To make the installer use it:


<JAVA_HOME>\bin\java –jar <Path_To_Installer>\ console-install-pack-4.0.0.x.jar text-auto

You will be asked:


Installation configuration found. Load the existing configuration?

Answer yes.


Example of a generated “ant.install.properties” file:


### Ant Installer - properties auto generated on Mon\ Aug\ 20\ 09\:45\:32\ CEST\ 2007


basedir = D\:\\tmp\\.

ant.install.config.version = 0.0


## Properties from Page:splash


## Properties from Page:intro


## Properties from Page:license


## Properties from Page:properties

# .DirectoryInput

INSTALL_DIRECTORY = D\:\\console-batch

# .UnvalidatedTextInput

CONSOLE_ID = Console4005


## Properties from Page:properties

# .UnvalidatedTextInput

CONSOLE_JNDI_NAME = Console

# .ValidatedTextInput

NAMING_SERVICE_PORT = 5001

# .ValidatedTextInput

JMX_SERVICE_PORT = 5002


## Properties from Page:selector

# .UnvalidatedTextInput

DB_USER = console_batch4

# .UnvalidatedTextInput

DB_PASSWORD = console_batch4

# .LargeSelectInput

DB_DRIVER_CLASS = oracle.jdbc.OracleDriver

# .UnvalidatedTextInput

DB_URL = jdbc\:oracle\:thin\:@TLADBXD1.dktetrix.net\:1529\:tetrix01


## Properties from Page:properties

# .UnvalidatedTextInput

BAR_SERVER_HOST = localhost

# .ValidatedTextInput

BAR_TRANSFER_PORT = 5003

# .DirectoryInput

BAR_UPLOAD_DIRECTORY = D\:\\console-batch\\bar-upload-directory


## Properties from Page:properties

# .DirectoryInput

LOG_DIRECTORY = D\:\\console-batch\\logs


## Properties from Page:properties

# .UnvalidatedTextInput

MAIL_HOST = 172.16.4.25

# .ValidatedTextInput

MAIL_PORT = 25

# .UnvalidatedTextInput

MAILER_NAME = CB4005

# .UnvalidatedTextInput

ADMINISTRATOR_MAIL = admin@foo.com

# .SelectInput

MAIL_MANAGER_TYPE = salto.batch.system.MailManagerDBStore


## Properties from Page:properties

# .UnvalidatedTextInput

SERVICE_NAME = console-batch

# .DirectoryInput

JAVA_HOME = D\:\\JDKs\\jdk1.5.0_12

# .UnvalidatedTextInput

JAVA_OPTS = -Xms256M -Xmx512M -XX\:MaxPermSize\=128m -DLOG_ROOT_PATH\=D\:\\console-batch\\logs


## Properties from Page:selector

# .TargetInput

install = true

# Targets selected for page

selector-targets = install,


## Properties from Page:progress

# Targets selected for page

progress-targets = cleanuptarget,

After installation

Play the script generated by the installer in <INSTALL_DIRECTORY>/config/oracle-install.sql on the Repository Database

Copy the content of [//nlasrc01/Tetrix/Deploiement/_console/console-4.0.0.1/business/lib LAST_VERSION\business\lib] in folder <INSTALL_DIR>\business\lib

Test installation

Go to <INSTALL_DIRECTORY>/bin

Run console.bat

The JMX URL will be written in <INSTALL_DIRECTORY>/config/jmx-service-url.txt

If the server does not stop, your installation is OK.

You can now register the service by running:

<INSTALL_DIRECTORY>/bin/installConsoleBatchService.bat

If the server stops, see errors logs

Batch Server Uninstallation steps:

Go to <INSTALL_DIRECTORY>/bin

Run uninstallConsoleBatchService.bat

Batch Server Configuration options:

General configuration

This configuration is in file <INSTALL_DIRECTORY>/config/config.properties

Configuration parameters:

Paramter Description Default Value
CONSOLE_ID Unique ID Of the Batch Server See 1.2.2.4
INSTALL_DIR <INSTALL_DIRECTORY> See 1.2.2.4
com.salto.console.PLUGIN_MANAGER_STORE Type of storage for Plugins configuration salto.batch.system.PluginManagerXMLStore
PLUGIN_MANAGER_FILE Path to the file that contains general plugin <INSTALL_DIRECTORY>/config/plugin-manager.xml
LOCK_DIR
CONFIG_ROOT Path to configuration Folder <INSTALL_DIRECTORY>/config
CONFIG_ROOT_BATCH Not Used
CONFIG_DATA Not Used
OUTPUT_DATA Folder used temporarily for Mail Generation and Lifecycle state <INSTALL_DIRECTORY>/output
USER_FILE File that host JMX Authentication informations
com.salto.console.MAIL_MANAGER_STORE Type of Storage for Mail Manager salto.batch.system.MailManagerDBStore (see 1.2.2.9)
MAIL_MANAGER_FILE Used only if Storage is XML
JMX_HTTP_ADAPTOR_PORT Port of the HTTP JMX adaptor if ACTIVATE_HTTP_ADAPTOR is true
ACTIVATE_HTTP_ADAPTOR JMX interface that exposes Operations in a Browser (Do not activate in PRODUCTION) false

JMX connectivity

This configuration is in file <INSTALL_DIRECTORY>/config/config.properties

This configuration is done by Wizard Installer (see 1.2.2.5)

Configuration parameters:

Paramter Description
JNDI_NAME JNDI Name that will appear at the end of the JMX URL
JMX_SERVICE_PORT JMX Port that will appear in the URL (It must be free)
NAMING_SERVICE_PORT Naming service Port

that will appear in the URL (It must be free)

service:jmx:rmi://<HOST OF THE MACHINE>:<JMX_SERVICE_PORT>/jndi/rmi:// <HOST OF THE MACHINE>:<NAMING_SERVICE_PORT>/<JNDI_NAME>

Database connectivity

This configuration is in file <INSTALL_DIRECTORY>/config/datasource.xml

Mailer connectivity

This configuration is in file <INSTALL_DIRECTORY>/config/mail.xml.

This configuration is done by Wizard Installer (see 1.2.2.9)


Configuration parameters:

Paramter Description Default Value
mailHost Host of the Mail Server
mailPort Port of the Mail Server 25
Mailer Name that will appear in Sent mails

Logging configuration

This configuration is in file <INSTALL_DIRECTORY>/config/log.properties.

Logging is based on Log4j, and this file controls the Server log level. Batch Logging configuration is hosted in each BAR


See http://logging.apache.org/log4j/docs/manual.html


Cold deployment

How To

This feature enables the (re)deployment at Server Startup of one or more BARs by:

  • Putting the bar in folder “<INSTALL_DIRECTORY>\batches-cold-deploy”
  • Putting a file called “<BAR_ID>-binding.xml” where BAR_ID is the <display-name > in bar.xml to customize JNDI Mapping (see next paragraph)

JNDI Mapping Customization

If you have to customize the mapping of JNDI resources (Pools), example map jdbc/masterdatas to jdbc/masterdatas_beta, you must put in the folder “<INSTALL_DIRECTORY>\batches-cold-deploy” a file called “<BAR_ID>-binding.xml” where BAR_ID is the <display-name > in bar.xml.

Example:

For STORES where BAR_ID is “STCOM_BATCH”, you will put a file called STCOM_BATCH-binding.xml that contains: [xml] <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE bar-resources PUBLIC "-//Ubik-Ingenierie //DTD BAR Binding Resource Configuration 1.0//EN" "http://www.ubik-ingenierie.com/consolebatch/config/bar-binding.dtd"> <bar-resources> <bar-resource nameinbar="jdbc/nbo0008" boundname="jdbc/nbo0008" /> <bar-resource nameinbar="jdbc/stcom0024" boundname="jdbc/stcom0024" /> <bar-resource nameinbar="jdbc/stcom0016" boundname="jdbc/stcom0016" /> <bar-resource nameinbar="jdbc/nbo0022" boundname="jdbc/nbo0022" /> <bar-resource nameinbar="jdbc/nbo0015" boundname="jdbc/nbo0015" /> <bar-resource nameinbar="jdbc/nbo0009" boundname="jdbc/nbo0009" /> <bar-resource nameinbar="jdbc/nbo0021" boundname="jdbc/nbo0021" /> <bar-resource nameinbar="jdbc/stcom0014" boundname="jdbc/stcom0014" /> <bar-resource nameinbar="jdbc/stcom0004" boundname="jdbc/stcom0004" /> <bar-resource nameinbar="jdbc/nbo0017" boundname="jdbc/nbo0017" /> <bar-resource nameinbar="jdbc/nbo0016" boundname="jdbc/nbo0016" /> <bar-resource nameinbar="jdbc/nbo0020" boundname="jdbc/nbo0020" /> <bar-resource nameinbar="jdbc/stcom0026" boundname="jdbc/stcom0026" /> <bar-resource nameinbar="jdbc/nbo0018" boundname="jdbc/nbo0018" /> <bar-resource nameinbar="jdbc/stcom0005" boundname="jdbc/stcom0005" /> <bar-resource nameinbar="jdbc/stcom0030" boundname="jdbc/stcom0030" /> <bar-resource nameinbar="jdbc/rangechoice0002" boundname="jdbc/rangechoice0002" /> <bar-resource nameinbar="jdbc/stcom0017" boundname="jdbc/stcom0017" /> <bar-resource nameinbar="jdbc/nbo0023" boundname="jdbc/nbo0023" /> <bar-resource nameinbar="jdbc/nbo0030" boundname="jdbc/nbo0030" /> <bar-resource nameinbar="jdbc/nbo0025" boundname="jdbc/nbo0025" /> <bar-resource nameinbar="jdbc/nbo0014" boundname="jdbc/nbo0014" /> <bar-resource nameinbar="jdbc/nbo0019" boundname="jdbc/nbo0019" /> <bar-resource nameinbar="jdbc/stcom0008" boundname="jdbc/stcom0008" /> <bar-resource nameinbar="jdbc/stcom0027" boundname="jdbc/stcom0027" /> <bar-resource nameinbar="jdbc/stcom0003" boundname="jdbc/stcom0003" /> <bar-resource nameinbar="jdbc/stcom0007" boundname="jdbc/stcom0007" /> <bar-resource nameinbar="jdbc/stcom0010" boundname="jdbc/stcom0010" /> <bar-resource nameinbar="jdbc/stcom0006" boundname="jdbc/stcom0006" /> <bar-resource nameinbar="jdbc/stcom0022" boundname="jdbc/stcom0022" /> <bar-resource nameinbar="jdbc/client" boundname="jdbc/client" /> <bar-resource nameinbar="jdbc/nbo0013" boundname="jdbc/nbo0013" /> <bar-resource nameinbar="jdbc/nbo0029" boundname="jdbc/nbo0029" /> <bar-resource nameinbar="jdbc/nbo0024" boundname="jdbc/nbo0024" /> <bar-resource nameinbar="jdbc/stcom0001" boundname="jdbc/stcom0001" /> <bar-resource nameinbar="jdbc/stcom0023" boundname="jdbc/stcom0023" /> <bar-resource nameinbar="jdbc/rangechoice0005" boundname="jdbc/rangechoice0005" /> <bar-resource nameinbar="jdbc/stcom0028" boundname="jdbc/stcom0028" /> <bar-resource nameinbar="jdbc/stcom0002" boundname="jdbc/stcom0002" /> <bar-resource nameinbar="jdbc/rangechoice0001" boundname="jdbc/rangechoice0001" /> <bar-resource nameinbar="jdbc/rangechoice0015" boundname="jdbc/rangechoice0015" /> <bar-resource nameinbar="jdbc/stcom0013" boundname="jdbc/stcom0013" /> <bar-resource nameinbar="jdbc/cdedir" boundname="jdbc/cdedir" /> <bar-resource nameinbar="jdbc/nbo0010" boundname="jdbc/nbo0010" /> <bar-resource nameinbar="jdbc/stcom0021" boundname="jdbc/stcom0021" /> <bar-resource nameinbar="jdbc/masterdatas" boundname="jdbc/masterdatas_vbeta" /> <bar-resource nameinbar="jdbc/nbo0006" boundname="jdbc/nbo0006" /> <bar-resource nameinbar="jdbc/stcom0011" boundname="jdbc/stcom0011" /> <bar-resource nameinbar="jdbc/nbo0001" boundname="jdbc/nbo0001" /> <bar-resource nameinbar="jdbc/nbo0028" boundname="jdbc/nbo0028" /> <bar-resource nameinbar="jdbc/nbo0003" boundname="jdbc/nbo0003" /> <bar-resource nameinbar="jdbc/stcom0020" boundname="jdbc/stcom0020" /> <bar-resource nameinbar="jdbc/nbo0011" boundname="jdbc/nbo0011" /> <bar-resource nameinbar="jdbc/nbo0026" boundname="jdbc/nbo0026" /> <bar-resource nameinbar="jdbc/stcom0029" boundname="jdbc/stcom0029" /> <bar-resource nameinbar="jdbc/nbo0004" boundname="jdbc/nbo0004" /> <bar-resource nameinbar="jdbc/nbo0005" boundname="jdbc/nbo0005" /> <bar-resource nameinbar="jdbc/stcom0025" boundname="jdbc/stcom0025" /> <bar-resource nameinbar="jdbc/stcom0019" boundname="jdbc/stcom0019" /> <bar-resource nameinbar="jdbc/troc" boundname="jdbc/troc" /> <bar-resource nameinbar="jdbc/nbo0027" boundname="jdbc/nbo0027" /> <bar-resource nameinbar="jdbc/stcom0015" boundname="jdbc/stcom0015" /> <bar-resource nameinbar="jdbc/stcom0018" boundname="jdbc/stcom0018" /> <bar-resource nameinbar="jdbc/nbo0002" boundname="jdbc/nbo0002" /> <bar-resource nameinbar="jdbc/nbo0007" boundname="jdbc/nbo0007" /> <bar-resource nameinbar="jdbc/stcom0012" boundname="jdbc/stcom0012" /> <bar-resource nameinbar="jdbc/nbo0012" boundname="jdbc/nbo0012" /> <bar-resource nameinbar="jdbc/stcom0009" boundname="jdbc/stcom0009" /> </bar-resources>

What it does

At Startup, the Batch Server will do the following:

  • If BAR with another version exists, it will be undeployed
  • If file <BAR_ID>-binding.xml exists in batches-cold-deploy folder it will be used
  • If file <BAR_ID>-binding.xml does not exist in batches-cold-deploy but exists batches-deploy it will be used
  • Otherwise a default binding that maps logical to same physical name will be created
  • The BAR will be deployed
  • If it succeeds:
  1. It will appear in deployed BARs on BatchAdmin application
  2. Success will appear in Deployment History on BatchAdmin application
  • If it fails:
  1. old BAR (if there was one) will be undeployed
  2. New BAR will not be deployed and moved to batches-deploy-failure and a file called <BAR File Name>.failure will be written that will contains the Failure
  3. Failure will appear in Deployment History on BatchAdmin application


Batch Administration Webapp:

Create the Database using this script:

  • [//nlasrc01/Tetrix/Deploiement/_console/LAST_VERSION/batchadmin/ddl LAST_VERSION\batchadmin\ddl]

Play the following script in the Database of BatchAdmin:


INSERT INTO parameter(par_context, par_id, par_value, par_description, par_date_upd, par_user_upd, par_date_crt, par_user_crt)

VALUES ('BAR_UPLOAD', 'DIRECTORY', '<PATH TO BAR UPLOAD DIRECTORY>',

'Directory where uploaded BARs in deployment will be stored', SYSDATE, 'PMD', SYSDATE, 'PMD');


INSERT INTO parameter(par_context, par_id, par_value, par_description, par_date_upd, par_user_upd, par_date_crt, par_user_crt)

VALUES ('CONSOLE_SERVICE', 'IMPLEMENTATION', 'com.ubikingenierie.console.connect.service.JMX',

'Service implementation type', SYSDATE, 'PMD', SYSDATE, 'PMD');

commit;

Where <PATH TO BAR UPLOAD DIRECTORY> is the path to a Directory where BARs are uploaded before deployment on servers (This is NOT the same one as the Directory used by the BATCH Server)


PERMIT tasks

PERMIT Task PERMIT Role Description
MANAGE_CONSOLES ADMINISTRATOR Add, Remove,Update a Console connection in the BatchAdmin application and Start/Stop a Server
DEPLOY ADMINISTRATOR Ability to deploy/undeploy/redeploy a BAR
VIEW_DEPLOY ADMINISTRATOR, SUPERVISOR, GUEST View Deployment History
MANAGE_LOGGING ADMINISTRATOR, SUPERVISOR Ability to view loggers, change log levels
MANAGE_BATCHES ADMINISTRATOR, SUPERVISOR Ability to modify Batches configuration,
MANAGE_LAUNCHES ADMINISTRATOR, SUPERVISOR Ability to manage Launches configuration, Add/Remove Cron Triggers
VIEW_BATCH_ERRORS ADMINISTRATOR, SUPERVISOR, GUEST Ability to see Batch Errors and History
MANAGE_TRIGGERS ADMINISTRATOR, SUPERVISOR Ability to Add/Remove/Modify Cron Triggers
MANAGE_LINKERS ADMINISTRATOR, SUPERVISOR Ability to see Linkers
VIEW_SCHEDULING ADMINISTRATOR, SUPERVISOR, GUEST Ability to see Running Batches
VIEW_PREVIOUS_EXECUTIONS ADMINISTRATOR, SUPERVISOR, GUEST View Previous batches executions
VIEW_NEXT_EXECUTIONS ADMINISTRATOR, SUPERVISOR, GUEST View Next batches executions
MAIL_CONFIGURATION ADMINISTRATOR, SUPERVISOR Ability to add/remove Mail recipients
DURATION_CONFIGURATION ADMINISTRATOR, SUPERVISOR Ability to set max duration limits of a Batch
POOL_CONFIGURATION ADMINISTRATOR Ability to add/remove/update a Pool
POOL_VIEW ADMINISTRATOR, SUPERVISOR, GUEST View Pools configuration
VIEW_INDICATORS ADMINISTRATOR, SUPERVISOR, GUEST View Servers Memory state and pools state
VIEW_SYSTEM_PROPERTIES ADMINISTRATOR View Server JVM properties

Deploy the EAR batchadmin-XXX.ear.

Map the pools:

Logical Name Physical Pool Description
jdbc/console jdbc/console Repository of the Batch Server
jdbc/batchadmin jdbc/batchadmin Database of the application
jdbc/permit jdbc/permit PERMIT database
jdbc/cbsecurity No This pool is not used

Adding a Batch Server:

You must have the PERMIT task MANAGE_CONSOLES to add a Batch server in the Administration Tool

Open menu Configuration > Manage Consoles

Add a Server

Click on Image:Image015.png

Fill this form

[[Image:]]


Where the parameters are:


Parameter Description
Console ID The Console ID that identifies uniquely the Batch Server in DB (see 1.2.2.4)
JMX URL The JMX URL that was generated in <INSTALL_DIRECTORY>/config/jmx-service-url.txt (see 1.2.5.3)
JMX User The JMX login
JMX Password The JMX password
File Transfer Host The Host where the Batch Server is running
File Transfer Port The Port of the Embedded BAR Server (see 1.2.2.7)
Console Pool The JDBC Pool to the Batch Server repository of the configured Batch Server
Comments A Comment that will appear when you hover over a link

Finish the Step

Click on [[Image:]]

Retrieved from "http://wiki.ubik-ingenierie.com/ubikwiki/index.php?title=Ubik_Batch_Server_Installation_Guide"
Personal tools