GAMMASPHERE informix databases






LN databases

The LN databa is located in
    /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")
.
.

Note, the '/vxboot/lnfill/log/ln.inits' file is quite readable:
# 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

Detector database

The detector database is located in
   /export/home/gam/prod/daq/database/ver_5
on srv1. You need to be on srv1 to acccess the Informix database.

Here is a simple example of accessing the data base:

There are the follwing .sql files: To use the .sql scripts do