...
TRANSFER schema procedures
All of these scripts were designed to be executed with TRANSFER schema owner privileges--operating within a given database instance and its web of application-specific permissions and configurations.
BOX script
These scripts assist in automating shipboard beginning of expedition (BOX) database preparations.
BOX_ASMAN_CATALOG_DELETE
BOX_LIME_AUDIT_DELETE
BOX_LIMS_CLEANUP
BOX_LIMS_DEFRAG
BOX_LIMS_EXPEDITION_DELETE
BOX_SM_DELETE_REQUEST_CODES
Container load script
One of the shipboard systems (moisture and density) requires data for pre-weighed containers. This script aids in loading content from an Excel file into the shipboard LIMS.
CLHistory. These scripts were once routinely
Data copy script - formerly applied for EOX ETL
These COPY_* scripts were (routinely) applied by shipboard developers to prepare a copy of expedition data for transport to shore via an export of the TRANSFER schema. These EOX activities have been droppedThis EOX activity no longer occurs (since Dec 2022, Exp 398). Prior to Dec 2022 the scripts were named as-shown, but without the COPY_ prefix.
The scripts are retained as they for occasional use. They provide a semi-automated means for aggregating an expedition's data for transport into a test environment via the supporting tables in the TRANSFER schemas.
COPY_ASMAN_CATALOG_TO_NEW
COPY_DESCINFO_TO_NEW
COPY_LIMS_EXPEDITION_TO_NEW
COPY_MERGE_NEW_TO_LIMS
OVERVIEW script
These scripts support the computation of summary data presented by the database OVERVIEW application. Each script summarizes a different kind of data.
...
The OEM (Oracle Enterprise Manager) hosts on shore and ship host an NSF mount point used by each ODA (Oracle Data Appliance). Scripts used for a variety of database management purposes may be found here: /backup/scripts, /backup/scripts/rci_work
EOX load and merge - rci_work/exp
The collection of scripts in this location is used to automate the shore components of EOX processing: retrieve last expedition content from the database dump, create and apply moratorium supports, merge the data into production; provide statistics which give quality assurance/quality control on the process.
These are the scripts (in-order) that are typically used
Code Block |
---|
# Shore EOX processing for a data load # per Sunil Armarni from a Slack thread. export EOX=# chk_eox_count.ksh select sum(bytes)/1024/1024 from dba_free_space where tablespace_name = 'TRANSFER' import_transfer.ksh transfer_upd_stat.ksh data_pre_01_crt_unq.ksh data_pre_01_chk_dup.ksh eox_gen_in_moratorium_script.ksh <GROUP> in_moratorium_<GROUP>.ksh crt_user_exp.ksh $EOX chk_tablespace_free.ksh grp_cnt_transfer.ksh data_pre_03_dis_trig.ksh dis_trig_all_<YYYMMDD_HHMMSS>.sql chk_eox_count.ksh exp# exec transfer.lims_expedition_delete('#') chk_eox_count.ksh grp_cnt_lims.ksh data_pre_05_without_DI_v6.ksh # calls scors also grp_cnt_lims.ksh chk_scale_data.ksh data_pre_05_scale_data.ksh chk_scale_data.ksh enb_trig_all_<YYYMMDD_HHMMSS>.sql merge_descinfo2_data_v2.ksh insert_dbo_#.sql - N/A dbo_compute_v4.sql exp# data_post_06_upd_stat.ksh |
Other script
tbd