Upgrade to 14.2 - Conversion Implementation

1. Upgrade to 14.2 - Conversion Implementation

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 attached Upgrade to 14.2

3. 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 Upgrade to 14.2

4. 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 Upgrade to 14.2

5. 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 Upgrade to 14.2

6. Conversion - Methodology - 1 • Main steps • download ‘old’ data • convert to ‘new’ structure • change data if needed • convert data to Unicode while uploading to ‘new’ Oracle Upgrade to 14.2

7. 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 Upgrade to 14.2

8. Conversion - Methodology - 3 • Convert as described only the ‘basic’ Oracle tables • Recreate all ‘derived’ tables • Special treatment for very big ‘derived’ files Upgrade to 14.2

9. 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/zNNN_old.seq • copy to new $data_files/zNNN.seqaa • convert to Unicode while uploading Upgrade to 14.2

10. ConversionTypes • 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 Upgrade to 14.2

11. Conversion - order • 1 LIB01 (BIBliographic Library) • 2 LIB60 (HOLdings Library) • 3 LIB50 (ADMinistration Library) • 4 LIB20 (ILL Library) • 5 LIB30 (Course Reading Library) Upgrade to 14.2

12. Conversion Kit • Location: under a50_5/versions_upgrade • Name: all_to_14.2 • including sources • c compiler is required • cobol compiler is required Upgrade to 14.2

13. Conversion Kit - 1 • Location: under a50_5/versions_upgrade • Name: all_to_14.2 • including sources • c compiler is required • cobol compiler is required (*) Upgrade to 14.2

14. Conversion Kit - 2 • The all_to _14.2 files can also be found in the ftp server under: • Aleph2/version_500/version.505.14.2/version_upgrade/ Upgrade to 14.2

15. Conversion Start • Login new m505 (m525 ?) • cd ../versions_upgrade/all_to_14.2 • copy and spread the tar for old version to the old tree Upgrade to 14.2

16. Conversion - files • christie=M505=m505>>pwd • /aleph/a50_5/version_upgrade/all_to_14.2 • christie=M505=m505>>ls • 500conv_to_14.2.tar z08/ z18/ z308/ z37h/ z601/ z76/ • all_to_14.2_oldm.tar z09/ z20/ z30h/ z38/ z61/ z77/ • doc/ z104/ z22/ z31/ z40/ z66/ z78/ • gal01_run_cv_to_14.2_newm.sh z108/ z30/ z310/ z41/ z68/ z82/ • gal50_run_cv_to_14.2_newm.sh z12/ z303/ z35/ z44/ z70/ z83/ • move_to_aa.sh z14/ z304/ z36/ z45/ z71/ • run_cv_to_14.2_newm.sh z16/ z305/ z36h/ z501/ z72/ • run_cv_to_14.2_oldm.sh* z17/ z306/ z37/ z52/ z75/ Upgrade to 14.2

17. Conversion - prepare ‘old’ side • tar xvf all_to_14.2_oldm.tar • cd general • cc -o field_size_change field_size_change.c Upgrade to 14.2

18. Conversion - core program • field_size_change.c • alter_column.sh • headings.txt* endings.txt • get_table_columns.sql Upgrade to 14.2

19. Conversion - core program • Examples: • more z18_old_machine/z18_changes.txt • ADD Z18_REC_KEY '00' start • more z70_old_machine/z70_12_changes.txt • ADD Z70_NAME_KEY '**************************************' start • ADD Z70_TERMS_SIGN ' ' end • ADD Z70_TERMS_PERCENT '00' end • ADD Z70_VENDOR_CONTACT SPACEx150 end • ADD Z70_ADDITIONAL_VENDOR_CODE '***' end Upgrade to 14.2

20. Conversion - implement ‘old’ • use main script: run_cv_to_14.2_oldm • the above script activates all stepN 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 • set ver_num = 12.2 (or another) Upgrade to 14.2

21. 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 Upgrade to 14.2

22. Conversion - implement ‘new’ • use main script: run_cv_to_14.2_newm • the above script activates all stepN scripts under all relevant directories • edit the script only for existing files in every library copy their list from the ‘old’ list Upgrade to 14.2

23. 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 Upgrade to 14.2

24. Conversion - implement ‘new’ • Or, for one table, activate • p_file_04_cv LIBnn,zXX,,L,8859_1_TO_UTF • Or, for z303 and z70 • p_file_06_cv LIBnn,zXX.seq,z303,,,,,#,8859_TO_UTF Upgrade to 14.2

25. Conversion - finish • Build indexes • p_manage_01 • p_manage_02 • p_manage_05 • p_manage_12 • p_manage_…… • Notify the customer to check Upgrade to 14.2