...
Into the publicly accessible LIMS. - DBA
chk_tablespace_free.ksh
Review the space available in LABWARE, LABWAREIDX.
grp_cnt_transfer.ksh, grp_cnt_lims.ksh
Review. Run both of these scripts to gather baseline row counts by moratorium group, expedition, and record status. Preparatory step before data is merged.
data_pre_03_dis_trig.ksh
Run this script to generate a pair of scripts that respectively enable and disable triggers.
dis_trig_all_<yyyymmdd_hhmmss>.sql
Run this script via SQL to disable all schema triggers.
- Ensures the data goes in faster. And
- Doesn't get modified (again) on the way by.
data_pre_05_without_DI_v6.ksh
Script deprecated--not modified for current use. Superseded for now by the script below.
call transfer.eox_shore_merge_transfer_new_to_lims()
This procedure merges TRANSFER schema NEW_* table content into LIMS. Including
- scales, depth, samples, tests, results; and
- two (recently added) GEODESC tables.
Please review the procedure. To run it
| Code Block |
|---|
sql / as sysdba
SQL>
call transfer.eox_shore_merge_transfer_new_to_lims() |
- Without indexes, the bulk merging of the NEW_RESULT content took upwards of 6 hours.
- With a unique index on NEW_RESULT.RESULT_NUMBER the bulk merge was observed to complete in 30 minutes.
grp_cnt_lims.ksh
Re-run this script for review purposes. Data formerly only in the TRANSFER schema should now be present in the same numbers in the LIMS schema.
enb_trig_all_<yyyymmdd_hhmmss>.sql
If the row counts match, reenable operational triggers.
Notify interested parties that new moratorium data is available in LIMS.
Spot-check and test its availability and completeness.
5. Update the Database Overview
Configuration updates provide summary of the expedition data for participants and future users. - DBA
...
dbo_compute_v4.sql <exp>
Run this script to compute new expedition summaries for display in the database OVERVIEW application: https://web.iodp.tamu.edu/OVERVIEW/
Original process notes below.
Re-worked below into process above--polishing and efficiency improvements welcome.
The scripts below are applicable to steps 2. thru 5.
EOX load and merge - rci_work/exp
...
|
Other script
...