/export/home/gam/prod/lnfill/dbase
on 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#C015339
and 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
20
pressing 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 16
The .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.