/export/home/gam/prod/lnfill/dbaseon srv1. But the way you access it is to log into the gamdb account on srv1 and type 'change_ln_limits'. You will be working from the '/home/gam13/acct/gamdb' directory and the 'change_ln_limits' script is in the scripts directory.
This script will find the database in the directory listed above. The script will create a 'ln.inits' file which is copied to 'home/lncon/prod/lnfill/log' - an NFS mounted disk from lncon. Despite the directory name ('log'), the lnfill IOC will pickup this file and process it in it's startup script:
. . . _gamln_statesave_directory="/vxboot/lnfill/log" _gamln_statesave_file="ln.state" _gamln_history_directory="/vxboot/lnfill/log" _gamln_log_directory="/vxboot/lnfill/log" _gamln_log_filename="ln_log" . . . ln_init(gamln_statesave_directory,"ln.inits") . .
# Device type # | station_id # | | number( hole number for detectors) # | | | supplier_number* # | | | | max_customers(load_count) # | | | | | min_time # | | | | | | max_time # | | | | | | | temperature_threshold # | | | | | | | | filter_coefficient # | | | | | | | | | hold_time # | | | | | | | | | | min_dets_open Supply S1 1 2 2 30 1200 3.50 0.50 1 1 Supply S2 2 4 2 10 1200 4.00 0.50 1 1 Tank T1 1 1 1 3 2500 5.40 0.50 5 1 Tank T2 2 1 1 3 2500 5.60 0.50 5 1 Tank T3 3 1 1 3 1500 4.00 0.50 1 1 Tank T4 4 2 1 3 2500 5.00 0.50 10 1 Tank T5 5 2 1 3 2500 5.60 0.50 1 1 Tank T6 6 2 1 3 2500 5.00 0.50 1 1 Manifold M1 1 1 4 20 1000 4.50 0.90 5 1 Manifold M1A 5 0 1 120 800 3.50 0.70 10 1 Manifold M2 2 2 4 20 800 5.00 0.90 10 1 Manifold M2A 6 0 1 120 800 3.50 0.70 10 1 Manifold M3 3 4 4 20 1000 3.00 0.90 5 1 Manifold M3A 7 0 1 120 800 2.30 0.70 10 1 Manifold M4 4 5 4 20 800 4.10 0.90 10 1 Manifold M4A 8 0 1 120 800 2.50 0.70 10 1 Detector H1-01 105 1 0 30 450 5.00 0.90 10 1 Detector H1-02 101 1 0 30 450 5.45 0.90 10 1 Detector H1-03 109 1 0 30 450 5.30 0.90 10 1 Detector H1-04 89 1 0 30 450 5.60 0.90 10 1 Detector H1-05 107 1 0 30 450 5.30 0.90 10 1 Detector H1-06 103 1 0 30 450 5.10 0.90 10 1 Detector H1-07 97 1 0 30 450 4.90 0.90 10 1 Detector H1-08 65 1 0 30 450 5.40 0.90 10 1 Detector H1-09 81 1 0 30 450 4.90 0.90 10 1 Detector H1-10 73 1 0 30 450 5.00 0.90 10 1 Detector H1-11 99 1 0 30 550 5.00 0.90 10 1 Detector H1-12 91 1 0 30 450 5.30 0.90 10 1 Detector H1-13 93 1 0 30 450 4.80 0.90 10 1 Detector H1-14 61 1 0 30 450 5.60 0.90 10 1 Detector H1-15 0 1 0 30 450 4.80 0.90 10 1 Detector H1-16 77 1 0 30 450 4.50 0.90 10 1 Detector H1-17 0 1 0 30 450 4.90 0.90 10 1 Detector H1-18 83 1 0 30 450 5.50 0.90 10 1 Detector H1-19 57 1 0 30 450 5.45 0.90 10 1 Detector H1-20 0 1 0 30 450 5.60 0.90 10 1 Detector H1-21 55 1 0 30 450 5.30 0.90 10 1 Detector H1-22 41 1 0 30 450 5.60 0.90 10 1 Detector H1-23 47 1 0 30 450 5.20 0.90 10 1 Detector H1-24 37 1 0 30 450 4.00 0.90 10 1 Detector H1-25 45 1 0 30 450 5.50 0.90 10 1 Detector H1-26 21 1 0 30 450 5.40 0.90 10 1 Detector H1-27 35 1 0 30 450 5.00 0.90 10 1 Detector H1-28 23 1 0 30 450 4.00 0.90 10 1 Detector H2-01 87 3 0 30 450 5.00 0.90 10 1 Detector H2-02 85 3 0 30 450 5.60 0.90 10 1 Detector H2-03 95 3 0 30 450 5.40 0.90 10 1 Detector H2-04 71 3 0 30 450 5.20 0.90 10 1 Detector H2-05 63 3 0 30 450 5.30 0.90 10 1 Detector H2-06 51 3 0 30 450 5.20 0.90 10 1 Detector H2-07 79 3 0 30 450 5.10 0.90 10 1 Detector H2-08 49 3 0 30 450 4.70 0.90 10 1 Detector H2-09 29 3 0 30 450 5.60 0.90 10 1 Detector H2-10 69 3 0 30 450 5.40 0.90 10 1 Detector H2-11 0 3 0 30 450 5.80 0.90 10 1 Detector H2-12 31 3 0 30 450 4.40 0.90 10 1 Detector H2-13 43 3 0 30 450 5.65 0.90 10 1 Detector H2-14 17 3 0 30 450 5.60 0.90 10 1 Detector H2-15 21 3 0 30 450 5.40 0.90 10 1 Detector H2-16 11 3 0 30 450 4.70 0.90 10 1 Detector H2-17 39 3 0 30 450 4.80 0.90 10 1 Detector H2-18 33 3 0 30 450 5.00 0.90 10 1 Detector H2-19 5 3 0 30 450 4.80 0.90 10 1 Detector H2-20 0 3 0 30 450 4.00 0.90 10 1 Detector H2-21 0 3 0 30 450 3.80 0.90 10 1 Detector H2-22 17 3 0 30 450 4.20 0.90 10 1 Detector H2-23 15 3 0 30 450 5.60 0.90 10 1 Detector H2-24 13 3 0 30 550 5.20 0.90 10 1 Detector H2-25 9 3 0 30 450 5.60 0.90 10 1 Detector H2-26 27 3 0 30 450 5.50 0.90 10 1 Detector H2-27 19 3 0 30 450 5.50 0.90 10 1 Detector H2-28 7 3 0 30 450 4.20 0.90 10 1 Detector H3-01 0 5 0 20 650 4.45 0.90 30 1 Detector H3-02 78 5 0 30 450 5.60 0.90 10 1 Detector H3-03 100 5 0 30 450 5.10 0.90 10 1 Detector H3-04 71 5 0 30 450 5.10 0.90 10 1 Detector H3-05 110 5 0 30 450 4.30 0.90 10 1 Detector H3-06 0 5 0 30 450 5.65 0.90 10 1 Detector H3-07 98 5 0 30 450 5.00 0.90 10 1 Detector H3-08 92 5 0 30 450 5.60 0.90 10 1 Detector H3-09 108 5 0 30 450 4.00 0.90 10 1 Detector H3-10 104 5 0 30 450 4.50 0.90 10 1 Detector H3-11 84 5 0 30 450 4.25 0.90 10 1 Detector H3-12 90 5 0 30 450 5.60 0.90 10 1 Detector H3-13 102 5 0 30 450 4.10 0.90 10 1 Detector H3-14 88 5 0 30 450 5.45 0.90 10 1 Detector H3-15 70 5 0 30 450 5.10 0.90 10 1 Detector H3-16 56 5 0 30 450 5.50 0.90 10 1 Detector H3-17 64 5 0 30 450 5.60 0.90 10 1 Detector H3-18 76 5 0 30 450 4.30 0.90 10 1 Detector H3-19 28 5 0 30 450 5.60 0.90 10 1 Detector H3-20 34 5 0 30 450 5.60 0.90 10 1 Detector H3-21 74 5 0 30 450 5.60 0.90 10 1 Detector H3-22 36 5 0 30 450 5.60 0.90 10 1 Detector H3-23 54 5 0 30 450 5.40 0.90 10 1 Detector H3-24 50 5 0 30 450 5.40 0.90 10 1 Detector H3-25 44 5 0 30 450 4.75 0.90 10 1 Detector H3-26 18 5 0 30 450 4.00 0.90 10 1 Detector H3-27 20 5 0 30 450 5.60 0.90 10 1 Detector H3-28 12 5 0 30 450 5.60 0.90 10 1 Detector H4-01 0 7 0 30 450 5.40 0.90 10 1 Detector H4-02 80 7 0 30 450 4.00 0.90 10 1 Detector H4-03 86 7 0 30 450 4.10 0.90 10 1 Detector H4-04 94 7 0 30 450 5.10 0.90 10 1 Detector H4-05 96 7 0 30 450 5.60 0.90 10 1 Detector H4-06 68 7 0 30 450 5.60 0.90 10 1 Detector H4-07 72 7 0 30 450 5.65 0.90 10 1 Detector H4-08 42 7 0 30 450 5.60 0.90 10 1 Detector H4-09 82 7 0 30 450 5.60 0.90 10 1 Detector H4-10 52 7 0 30 450 5.60 0.90 10 1 Detector H4-11 62 7 0 30 450 5.60 0.90 10 1 Detector H4-12 60 7 0 30 450 5.60 0.90 10 1 Detector H4-13 48 7 0 30 450 5.00 0.90 10 1 Detector H4-14 66 7 0 30 450 5.60 0.90 10 1 Detector H4-15 46 7 0 30 450 5.60 0.90 10 1 Detector H4-16 14 7 0 30 450 4.90 0.90 10 1 Detector H4-17 32 7 0 30 450 5.60 0.90 10 1 Detector H4-18 10 7 0 30 500 4.50 0.90 10 1 Detector H4-19 24 7 0 30 450 4.10 0.90 10 1 Detector H4-20 40 7 0 30 450 5.60 0.90 10 1 Detector H4-21 6 7 0 30 451 4.00 0.90 10 1 Detector H4-22 16 7 0 30 450 4.50 0.90 10 1 Detector H4-23 26 7 0 30 450 4.50 0.90 10 1 Detector H4-24 30 7 0 30 450 5.25 0.90 10 1 Detector H4-25 22 7 0 30 450 4.75 0.90 10 1 Detector H4-26 2 7 0 30 450 4.10 0.90 10 1 Detector H4-27 8 7 0 30 450 5.60 0.90 10 1 Detector H4-28 4 7 0 30 450 3.90 0.90 10 1 GNpurger G1-01 1 0 2 3 3600 1.00 0.50 1 1 GNpurger G1-02 2 1 2 3 3600 1.00 0.50 1 1 GNpurger G2-01 3 0 2 3 3600 1.00 0.50 1 1 GNpurger G2-02 4 3 2 3 3600 1.00 0.50 1 1 # * supplier_number is supply number for tanks # tank number for manifolds # manifold number for detectors
/export/home/gam/prod/daq/database/ver_5on srv1. You need to be on srv1 to acccess the Informix database.
Here is a simple example of accessing the data base:
INFORMIX-SQL Version 4.10.UC1 Copyright (C) 1984-1991 Informix Software, Inc. All Rights Reserved Software Serial Number AAA#C015339and then after a short while this menu:
INFORMIX-SQL: Form Report Query-Language User-menu Database Table Exit Run, Modify, Create, or Drop a form. ------------------------------------------------ Press CTRL-W for Help --------
FORM: Run Modify Generate New Compile Drop Exit Use a form to enter data or query a database. ------------------------------------------------ Press CTRL-W for Help --------
RUN FORM >> Choose a form with Arrow Keys, or enter a name, then press Return. ------------------------------------------------ Press CTRL-W for Help -------- backplugs slope_box bgo_asms sph_cons bgo_stat sph_locs cables vxi_cards change_det vxi_stat find_ge ge_modules ge_stat s_box_stat
PERFORM: Query Next Previous View Add Update Remove Table Screen ... Searches the active database table. ** 1: sphere_connections table* sphere_location [ ] ge_id [ ] bgo_id [ ] backplug_id [ ] cable_id [ ] vxi_card_id [ ] vxi_crate_number [ ] vxi_slot_number [ ] vxi_card_section [ ] comment [ ] [ ]
PERFORM: Query Next Previous View Add Update Remove Table Screen ... Searches the active database table. ** 1: sphere_connections table* sphere_location [1 ] ge_id [20 ] bgo_id [7 ] backplug_id [20 ] cable_id [33 ] vxi_card_id [ ] vxi_crate_number [1 ] vxi_slot_number [2 ] vxi_card_section [A] comment [ ] [ ]Which tells you that detector 20 is in sphere 1 and using BGO shield number 20 and backplug 20. The grey cable is labeled 33. The detector is 'serviced' by the GeBGO board in slot 2 of crate 1 and the grey cable is hooked up to the upper unout of the board.
PERFORM: Query Next Previous View Add Update Remove Table Screen ... Searches the active database table. ** 1: sphere_locations table** sphere_location [1 ] hole_shape [B] hole_number [34 ] heading [207.6279 ] orientation_type [6 ] theta [17.27 ] phi [72.0 ] adjacent_1 [3 ] adjacent_2 [7 ] adjacent_3 [11 ] adjacent_4 [5 ] adjacent_5 [6 ] adjacent_6 [0 ] comment [ ] [ ]
PERFORM: Query Next Previous View Add Update Remove Table Screen ... Searches the active database table. ** 1: bgo_backplugs table** backplug_id [12 ] nominal_volts_a [650 ] nominal_volts_b [650 ] manufacturer [ ] mfgr_serial_no [ ] purchase_order_no [ ] date_received [ ] comment [ ] [ ]
PERFORM: Query Next Previous View Add Update Remove Table Screen ... Searches the active database table. ** 1: bgo_assemblies table** bgo_id [20 ] bgo_shape_code [C] orientation_type [1 ] nominal_volts_1_a [ ] nominal_volts_1_b [ ] nominal_volts_2_a [ ] nominal_volts_2_b [ ] nominal_volts_3_a [ ] nominal_volts_3_b [ ] nominal_volts_4_a [ ] nominal_volts_4_b [ ] nominal_volts_5_a [ ] nominal_volts_5_b [ ] nominal_volts_6_a [ ] nominal_volts_6_b [ ] manufacturer [ ] mfgr_serial_no [GS92/129 ] purchase_order_no [ ] date_received [02/26/1993] comment ["LBL, BLDG 88" ]
PERFORM: Query Next Previous View Add Update Remove Table Screen ... Searches the active database table. ** 1: ge_modules table** ge_id [20 ] slope_box_id [41 ] ge_max_volts [3500 ] ge_type [ ] ge_size [ ] manufacturer [ ] mfgr_resolution [ ] mfgr_volts [3500 ] mfgr_serial_no [32-N30793A ] purchase_order_no [ ] date_received [11/23/1992] doe_number [ ] comment [ ] [ ]
RUN: Next Restart Exit Display the next page of query results. ----------------------- daq_data --------------- Press CTRL-W for Help -------- bgo_id a1 a2 a3 a4 a5 a6 1 628 611 586 674 679 588 2 595 591 665 739 647 623 3 635 604 748 643 665 626 4 724 677 668 678 586 575 5 703 675 680 705 635 675 6 617 646 607 632 666 667 7 666 623 593 592 621 578 8 651 644 682 681 597 648 9 674 713 677 679 684 697 10 656 651 691 625 641 651 11 663 669 663 681 724 739 12 606 619 655 659 597 609 13 678 643 659 592 603 663 14 637 639 640 606 670 677 15 655 601 617 640 593 602 16 611 621 590 658 660 590 17 642 599 617 576 623 626 18 709 648 647 642 645 633 19 633 646 630 645 583 582 20pressing next gives the next page, etc.
ge_id ge_max_volts slope_box_id 0 0 1 4000 1 2 3600 10 3 3500 33 4 3700 21 5 3500 27 6 3600 35 7 4000 28 8 3500 10 9 4800 12 10 4000 38 11 4000 4 12 4000 44 13 4000 42 14 4000 11 15 4000 23 16 3500 14 17 4500 7 18 3300 37 19 3000 36 20 3500 41 21 3500 24 22 3500 2 23 3650 26 24 3500 34 25 3000 19 26 3500 40 27 3600 25 28 4300 29 29 3200 5 30 3700 31 3000 63 32 3500 17 33 4900 34 3000 35 3000 5 36 4000 31 37 3000 3 38 3500 18 39 0 40 3500 30 41 3100 2 42 4500 6 43 3500 47 44 3000 9 45 3500 116 46 3700 98 47 3700 113 48 3700 123 49 3500 71 50 3200 73 51 3300 96 52 3300 115 53 3700 94 54 4500 51 55 3700 91 56 3000 46 57 2800 56 58 3500 111 59 3800 48 60 4500 62 61 3700 70 62 3600 110 63 3500 114 64 3200 75 65 4000 101 66 4000 126 67 3500 65 68 4000 103 69 4000 54 70 3000 98 71 4000 105 72 3700 87 73 3900 64 74 4000 60 75 4000 86 76 4000 108 77 4800 67 78 4300 57 79 4800 69 80 3400 117 81 3800 90 82 3800 124 83 4300 100 84 4300 82 85 3000 92 86 4200 74 87 4600 83 88 3500 58 89 4000 77 90 3500 79 91 4500 106 92 4600 88 93 4000 85 94 4000 119 95 4500 121 96 4000 99 98 3000 36 99 4700 106 100 4600 72 101 3800 118 102 3800 127 103 4000 81 104 3500 55 105 4300 52 106 4500 59 107 4600 53 108 3900 95 109 4800 84 110 3500 123 111 4000 49 113 3000 78 114 3500 61
sphere_location ge_id bgo_id backplug_id 1 20 7 20 2 23 17 23 3 15 4 15 4 27 26 27 5 13 28 13 6 35 18 35 7 2 21 2 8 38 9 38 9 18 22 18 10 94 16 94 11 10 34 10 12 53 27 53 13 63 33 63 14 8 38 8 15 17 15 17 16 50 35 50 17 7 94 7 18 47 91 47 19 28 86 28 20 25 80 25 21 36 36 36 22 45 89 45 23 67 85 67 24 42 16 42 25 54 23 54 26 12 49 12 27 96 10 96 28 79 47 79 29 62 109 62 30 37 20 37 31 93 96 93 32 72 70 72 33 113 111 113 34 66 93 66 35 82 95 82 36 56 19 56 37 109 110 109 38 103 98 103 39 106 105 106 40 48 18 48 41 83 99 83 42 78 6 62 43 92 41 92 44 80 67 80 45 61 56 61 46 101 69 101 47 69 88 69 48 99 61 99 49 75 46 75 50 92 53 92 51 70 45 70 52 101 8 101 53 54 88 29 88 55 49 63 49 56 51 39 51 57 43 47 13 58 59 77 55 77 60 90 64 90 61 86 51 86 62 98 60 98 63 104 44 104 64 76 54 76 65 100 104 100 66 99 52 99 67 60 113 60 68 95 5 95 69 89 84 89 70 114 114 71 107 102 107 72 71 68 71 73 0 81 0 74 105 108 105 75 108 107 108 76 102 97 102 77 85 82 85 78 0 101 0 79 111 59 111 80 81 50 81 81 65 39 65 82 55 33 55 83 64 64 64 84 74 57 74 85 44 79 44 86 58 100 58 87 31 72 31 88 32 65 32 89 21 74 21 90 52 73 52 91 5 66 5 92 73 62 73 93 57 78 57 94 59 77 59 95 41 32 41 96 84 76 84 97 68 43 68 98 19 31 19 99 11 30 11 100 87 37 87 101 22 11 22 102 24 14 24 103 9 15 9 104 6 13 6 105 14 2 14 106 40 12 40 107 26 3 26 108 4 1 4 109 3 42 3 110 16 20 16The .sql file looks as
output to gsposi.rep Select Sphere_Location,GE_ID,BGO_ID,Backplug_ID from Sphere_Connections order by Sphere_Location
CHOOSE >> Choose a command file with the Arrow Keys, or enter a name, then press Return. ----------------------- daq_data --------------- Press CTRL-W for Help -------- bgo_rep create ge_volts grant gsgehv gspos load load_bgo_test unload
SQL: New Run Modify Use-editor Output Choose Save Info Drop Exit Run the current SQL statements. ----------------------- daq_data --------------- Press CTRL-W for Help -------- output to gsposi.rep Select Sphere_Location,GE_ID,BGO_ID,Backplug_ID from Sphere_Connections order by Sphere_Location
change_detThis script will take you into the database (wher you can make your changes) and generate a set of new EPICS dabase files "resm?_volts.db". In addition, it will copy these new updated EPICS dabase files into the directories from where the VXI processors load from.