Upgrade to 14 2 Conversion Implementation 17092020 Upgrade

Upgrade to 14. 2 Conversion Implementation 17/09/2020 Upgrade to 14. 2

Upgrade Documentation. 1 User Tables Customization A WORD document: Tables 12. 2 -14. 2 attached • updated to 14. 2 rep_change 806. 2 Oracle Tables Conversion A WORD document: Upgrading to Aleph 505. 14. 2 17/09/2020 attached Upgrade to 14. 2

Conversion Start - User Tables • Read carefully the user tables conversion instructions • Learn the user’s needs from the filled questionnaire • Proceed with the tables customization as in the instructions 17/09/2020 Upgrade to 14. 2

Conversion - User Tables Main steps • customize tables in $alephe_tab • create libraries in the 14. 2 environment • customize tables in $data_tab • customize web screens 17/09/2020 Upgrade to 14. 2

Conversion Start - Oracle • Read carefully the data conversion instructions • Make sure that enough disk space is available • Coordinate with the library • Proceed with the data conversion 17/09/2020 Upgrade to 14. 2

Conversion - Methodology -1 Main steps • • 17/09/2020 download ‘old’ data convert to ‘new’ structure change data if needed convert data to Unicode while uploading to ‘new’ Oracle Upgrade to 14. 2

Conversion - Methodology -2 • One kit for all upgraded versions 11. 4 to 12. 2 (ver_num( • Separate kits for 12. 3 and 12. 4 • Build sql scripts, according to ver_num, to convert the structure of the ‘old’ data while downloading from Oracle • Cobol programs to change data during the conversion 17/09/2020 Upgrade to 14. 2

Conversion - Methodology -3 • Convert as described only the ‘basic’ Oracle tables • Recreate all ‘derived’ tables • Special treatment for very big ‘derived’ files 17/09/2020 Upgrade to 14. 2

Conversion - Terminology • Old database - version to be upgraded • New database - 14. 2 • doc files in old $data_scratch – copy to new $data_scratch • seq files in $data_files/z. NNN_old. seq – copy to new $data_files/z. NNN. seqaa 17/09/2020 Upgrade to 14. 2

Conversion Types 4 types of Oracle tables: • Converted tables on both databases • Converted tables on new database only, from *seq file in old format • Copied tables as are • Derived tables to rebuild 17/09/2020 Upgrade to 14. 2

Conversion - order 1 LIB 01 (BIBliographic Library( 2 LIB 60 (HOLdings Library( 3 LIB 50 (ADMinistration Library( 4 LIB 20 (ILL Library( 5 LIB 30 (Course Reading Library( 17/09/2020 Upgrade to 14. 2

Conversion Kit Location: under a 50_5/versions_upgrade Name: all_to_14. 2 • including sources • c compiler is required • cobol compiler is required 17/09/2020 Upgrade to 14. 2

Conversion Kit - 1 Location: under a 50_5/versions_upgrade Name: all_to_14. 2 • including sources • c compiler is required • cobol compiler is required(*) 17/09/2020 Upgrade to 14. 2

Conversion Kit - 2 The all_to _14. 2 files can also be found in the ftp server under: Aleph 2/version_500/version. 5 05. 14. 2/version_upgrade/ 17/09/2020 Upgrade to 14. 2

Conversion Start Login new m 505 (m 525(? cd. . /versions_upgrade/all_to _14. 2 copy and spread the tar for old version to the old tree 17/09/2020 Upgrade to 14. 2

Conversion - files christie=M 505=m 505>>pwd /aleph/a 50_5/version_upgrade/all_to_14. 2 christie=M 505=m 505>>ls 500 conv_to_14. 2. tar z 08/ z 18/ z 308/ z 37 h/ z 601/ z 76/ all_to_14. 2_oldm. tar z 09/ z 20/ z 30 h/ z 38/ z 61/ z 77/ doc/ z 104/ z 22/ z 31/ z 40/ z 66/ z 78/ gal 01_run_cv_to_14. 2_newm. sh z 108/ z 30/ z 310/ z 41/ z 68/ z 82/ gal 50_run_cv_to_14. 2_newm. sh z 12/ z 303/ z 35/ z 44/ z 70/ z 83/ move_to_aa. sh z 14/ z 304/ z 36/ z 45/ z 71/ run_cv_to_14. 2_newm. sh z 16/ z 305/ z 36 h/ z 501/ z 72/ 17/09/2020 run_cv_to_14. 2_oldm. sh* z 17/ z 306/ z 37/ z 52/ z 75/ Upgrade to 14. 2

Conversion - prepare ‘old’ side tar xvf all_to_14. 2_oldm. tar cd general cc -o field_size_change. c 17/09/2020 Upgrade to 14. 2

Conversion - core program field_size_change. c alter_column. sh headings. txt* endings. txt get_table_columns. sql 17/09/2020 Upgrade to 14. 2

Conversion - core program Examples: more z 18_old_machine/z 18_changes. txt ADD Z 18_REC_KEY '00' start more z 70_old_machine/z 70_12_changes. txt ADD Z 70_NAME_KEY '*****************' start ADD Z 70_TERMS_SIGN ' ' end ADD Z 70_TERMS_PERCENT '00' end ADD Z 70_VENDOR_CONTACT SPACEx 150 end ADD Z 70_ADDITIONAL_VENDOR_CODE 17/09/2020 '***' end Upgrade to 14. 2

Conversion - implement ‘old’ • use main script: run_cv_to_14. 2_oldm the above script activates all step. N scripts under all relevant directories • edit the script only for existing files in every library creating their list using util a 17 11 • activate the edited script after dlib lib_name 17/09/2020 Upgrade to 14. 2

Conversion - ftp / copy Intermediate files should be copied from the ‘old’ library to the ‘new’ environment: • doc - in the $data_scratch • others - in the $data_files 17/09/2020 Upgrade to 14. 2

Conversion - implement ‘new’ • use main script: run_cv_to_14. 2_newm • the above script activates all step. N scripts under all relevant directories • edit the script only for existing files in every library copy their list from the ‘old’ list 17/09/2020 Upgrade to 14. 2

Conversion - implement ‘new’ • activate the edited script – set conv_alpha = L – set conv_type = 8859_1_TO_UTF – set ver_num = 12. 2 (or another) – source run_cv_to_14. 2_newm. sh 17/09/2020 Upgrade to 14. 2

Conversion - implement ‘new’ • Or, for one table, activate p_file_04_cv LIBnn, z. XX, , L, 8859_1_TO_UTF • Or, for z 303 and z 70 p_file_06_cv LIBnn, z. XX. seq, z 303, , , #, 8859_TO_UTF 17/09/2020 Upgrade to 14. 2

Conversion - finish Build indexes • • • p_manage_01 p_manage_02 p_manage_05 p_manage_12 p_manage……_ Notify the customer to check 17/09/2020 Upgrade to 14. 2