Re: [foxboro] Questions about Foxboro, Venix 2.1 and informix...
- From: "Johnson, Alex P \(IPS\)" <alex.johnson@xxxxxxxxxxxxxxxx>
- To: <foxboro@xxxxxxxxxxxxx>
- Date: Mon, 29 Jan 2007 02:00:00 -0500
There are two data stores in the I/A Series Historian:
1) Sample data (real-time value collected and recorded) that is in a
flat file that cannot be read directly.
2) Reduced data (averages, for example) that are stored in Informix.
Prelude can read:
1) Real-time snapshots (not the sample file, but live values)
2) Reduced data
Regards,
=20
Alex Johnson
Invensys Systems, Inc.
10900 Equity Drive
Houston, TX 77041
713.329.8472 (voice)
713.329.1700 (fax)
713.329.1600 (switchboard)
alex.johnson@xxxxxxxxxxxxxxxx
-----Original Message-----
From: foxboro-bounce@xxxxxxxxxxxxx [mailto:foxboro-bounce@xxxxxxxxxxxxx]
On Behalf Of Ernesto Castro
Sent: Monday, January 29, 2007 3:41 AM
To: foxboro@xxxxxxxxxxxxx
Subject: Re: [foxboro] Questions about Foxboro, Venix 2.1 and
informix...
The historical values (i mean, the one accessibles with prelude only)
are
stored in a flat text file? Can they be accessed just by vi or so?
2007/1/26, Johnson, Alex P (IPS) <alex.johnson@xxxxxxxxxxxxxxxx>:
>
> Re: Prelude
>
> Prelude was an optional package. We don't sell it any more so if you
> don't have it, you can't get it (at least not through normal
channels).
>
>
> Re: Hypothetical approach
>
> Your suggested approach would work.
>
>
> Re: cron
>
> crontab is used to setup cron. The Venix manuals (a set of 6 blue
bound
> books if you have them) has the syntax. (PDF's didn't exist in the
late
> 80s.)
>
> If not, a good UNIX reference will help. Remember that Venix is UNIX
> System V not BSD.
>
>
> Re: Other options
>
> If you can program, the C compiler and linker are on the PWs and APs.
> With those tools and the API documentation, you could get the data
with
> a user written program.
>
> This might be your only route.
>
>
> Your
>
> Regards,
> =3D20
> Alex Johnson
> Invensys Systems, Inc.
> 10900 Equity Drive
> Houston, TX 77041
> 713.329.8472 (voice)
> 713.329.1700 (fax)
> 713.329.1600 (switchboard)
> alex.johnson@xxxxxxxxxxxxxxxx
>
> -----Original Message-----
> From: foxboro-bounce@xxxxxxxxxxxxx
[mailto:foxboro-bounce@xxxxxxxxxxxxx]
> On Behalf Of Ernesto Castro
> Sent: Friday, January 26, 2007 2:38 PM
> To: foxboro@xxxxxxxxxxxxx
> Subject: Re: [foxboro] Questions about Foxboro, Venix 2.1 and
> informix...
>
> Alex, first of all thanks for your reply. I have some further
> questions...
> About accessing to informix... what i have done is to run
> /usr/informix/bin/isql on every vt100 terminal corresponding to each
of
> the
> PW and AP. In any of them when i went to the database option I could
get
> a
> list of the available databeses. But im sure the historian is working.
>
> About prelude, if i understood you well with prelude i could make
> periodically reports (using cron, that i know it because i'm used to
use
> linux) and then chat "cat" them to /dev/lpXX and capture this with a
pc
> and
> make something in the pc in order to save it to a file. I would like
to
> know
> a little more about prelude and how to write the script to be run by
> cron to
> periodically run the report. It would be great if you have some pdf o
> any
> other kind of documentation to help me out.
>
> About upgrading, it has been in the budget of the company for two
years
> but
> we havent been lucky yet. So for the time being we are going to have
to
> deal
> with this old system for some more time (i hope no more than a year).
>
> Again, thanks a lot!
>
> 2007/1/26, Johnson, Alex P (IPS) <alex.johnson@xxxxxxxxxxxxxxxx>:
> >
> > Re: Your situation
> > Best advice -> Upgrade.
> >
> >
> >
> > Second best advice follows...
> >
> >
> >
> > Re: Reporting
> >
> >
> >
> > 1) The I/A Series Historian stored:
> >
> > a. Real-time data in a flat file to support DM trends
> >
> > b. Reduced data (average, min, max, etc.) in Informix
> >
> > 2) The real-time data is basically inaccessible.
> >
> > 3) The reduced data is accessible using Informix tools and the
> > Prelude spreadsheet.
> >
> > 4) There are two basic reporting packages:
> >
> > a. Informix ACE - The ACE report writer could be used to
> generate
> > a report of reduced data, but only reduced data.
> >
> > b. Prelude - A spreadsheet package that could access
> instantaneous
> > values from the OM and reduced data in Informix
> >
> > c. Isql can be invoked from a script, but it is a pretty
> primitive
> > reporting tool. Like ACE, it can only access reduced data.
> >
> > Note: Neither package can access the data that the Historian makes
> > available to the DM for trending. (Yes, the I/A Series Historian was
> the
> > world's first write-only historian.)
> >
> > 5) Reports could be scheduled to run using cron
> >
> > 6) Reports could be:
> >
> > a. Sent to a printer port on a COM10 and a PC could be used to
> > capture it and process it.
> >
> > b. Sent to a file and the file could be placed on a 5.25"
floppy
> > diskette.
> >
> >
> >
> > So, your steps would be:
> >
> >
> >
> > 1) Choose your tool (ACE, isql, or Prelude)
> >
> > 2) Write your report
> >
> > 3) Schedule it
> >
> > 4) Publish it to printer, PC on printer port, or 5.25" floppy
> > diskette.
> >
> >
> >
> >
> >
> > Re: Nodebus
> >
> >
> >
> > You cannot attach other devices directly to the Nodebus. The
physical
> > layer is not standard Ethernet nor does it have standard connectors.
> >
> >
> >
> > The PWs attach using a device (MAU) that deals with the electrical
> > differences so a generic PC could be attached, but the AP20s and PWs
> do
> > not support IP (that I can recall) so they would not be able to talk
> to
> > a normal PC attached to the network.
> >
> >
> >
> >
> >
> > Re: Not seeing Informix
> >
> > If you run isql and can't see an Informix database on any of your
> > systems, I would say that it is reasonable to conclude that the I/A
> > Series Historian is not running or you are using the wrong commands
to
> > view it.
> >
> >
> >
> >
> >
> > I hope this helps.
> >
> >
> >
> > Regards,
> >
> >
> >
> > Alex Johnson
> >
> > Invensys Systems, Inc.
> >
> > 10900 Equity Drive
> >
> > Houston, TX 77041
> >
> > 713.329.8472 (voice)
> >
> > 713.329.1700 (fax)
> >
> > 713.329.1600 (switchboard)
> >
> > alex.johnson@xxxxxxxxxxxxxxxx
> >
> >
> >
> > -----Original Message-----
> > From: foxboro-bounce@xxxxxxxxxxxxx
> [mailto:foxboro-bounce@xxxxxxxxxxxxx]
> > On Behalf Of Ernesto Castro
> > Sent: Friday, January 26, 2007 12:08 PM
> > To: foxboro@xxxxxxxxxxxxx
> > Subject: [foxboro] Questions about Foxboro, Venix 2.1 and
informix...
> >
> >
> >
> > I have to do something in a Foxboro running Venix 2.1 and Informix.
> What
> > i
> >
> > have to do is to make some app that save the history of some
variables
> > and
> >
> > send it over an ethernet network. I have never used Foxboro so I am
> > quite
> >
> > lost here.
> >
> > I was thinking about making remotely (from a normal PC) queries in
the
> >
> > informix DB to retrieve the historics values that, supposedly, are
> > stored in
> >
> > the Informix DB. The first problem i found was that i werent able to
> > access
> >
> > to the informix db. I run isql in both the ap20 and the three pw
> > workstation
> >
> > and it show me no databases. How can i access to the db so?
> >
> >
> >
> > The other thing is how to hook any point of this system to some
> network
> >
> > technology used theese days. I read something about NodeBus being
some
> > kind
> >
> > of ethernet modified. Is this possible to hook a normal pc with an
> > ethernet
> >
> > card to this nodebus and access the network of the ap20 and pw's?
> >
> >
> >
> > Finally, i dont know if the historics values are stored in the
> informix
> > db
> >
> > or somewhere else. I found out that the alarm history is kept in a
> > normal
> >
> > txt file.
> >
> >
> >
> > I would really appreciate any help you could give me about this. And
> >
> > generally any information about foxboro and venix in general in
order
> to
> >
> > help me solve this issue.
> >
> >
> >
> > Thanks in advance!
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
_______________________________________________________________________
> >
> > This mailing list is neither sponsored nor endorsed by Invensys
> Process
> >
> > Systems (formerly The Foxboro Company). Use the info you obtain here
> at
> >
> > your own risks. Read
> http://www.thecassandraproject.org/disclaimer.html
> >
> >
> >
> > foxboro mailing list:
> //www.freelists.org/list/foxboro
> >
> > to subscribe:
> mailto:foxboro-request@xxxxxxxxxxxxx?subject=3D3Djoin
> >
> > to unsubscribe:
> mailto:foxboro-request@xxxxxxxxxxxxx?subject=3D3Dleave
> >
> >
> >
> >
> >
> >
> >
> > Confidentiality Notice:
> > The information contained in this electronic message and any
> attachment(s)
> > to this message are intended for the exclusive use of the
recipient(s)
> and
> > may contain confidential, privileged or proprietary information. If
> you are
> > not the intended recipient, please notify the sender immediately,
> delete all
> > copies of this message and any attachment(s). Any other use of the
> E-Mail by
> > you is prohibited.
> >
> >
> >
> >
> >
>
_______________________________________________________________________
> > This mailing list is neither sponsored nor endorsed by Invensys
> Process
> > Systems (formerly The Foxboro Company). Use the info you obtain here
> at
> > your own risks. Read
> http://www.thecassandraproject.org/disclaimer.html
> >
> > foxboro mailing list:
> //www.freelists.org/list/foxboro
> > to subscribe:
> mailto:foxboro-request@xxxxxxxxxxxxx?subject=3D3Djoin
> > to unsubscribe:
> mailto:foxboro-request@xxxxxxxxxxxxx?subject=3D3Dleave
> >
> >
>
>
> =3D20
> =3D20
>
_______________________________________________________________________
> This mailing list is neither sponsored nor endorsed by Invensys
Process
> Systems (formerly The Foxboro Company). Use the info you obtain here
at
> your own risks. Read
http://www.thecassandraproject.org/disclaimer.html
> =3D20
> foxboro mailing list:
//www.freelists.org/list/foxboro
> to subscribe:
mailto:foxboro-request@xxxxxxxxxxxxx?subject=3D3Djoin
> to unsubscribe:
mailto:foxboro-request@xxxxxxxxxxxxx?subject=3D3Dleave
> =3D20
>
>
>
> Confidentiality Notice: =3D0AThe information contained in this
electronic m=3D
> essage and any attachment(s) to this message are intended for the
exclusi=3D
> ve use of the recipient(s) and may contain confidential, privileged or
pr=3D
> oprietary information. If you are not the intended recipient, please
noti=3D
> fy the sender immediately, delete all copies of this message and any
atta=3D
> chment(s). Any other use of the E-Mail by you is prohibited.=3D0A
>
>
>
>
_______________________________________________________________________
> This mailing list is neither sponsored nor endorsed by Invensys
Process
> Systems (formerly The Foxboro Company). Use the info you obtain here
at
> your own risks. Read
http://www.thecassandraproject.org/disclaimer.html
>
> foxboro mailing list:
//www.freelists.org/list/foxboro
> to subscribe:
mailto:foxboro-request@xxxxxxxxxxxxx?subject=3Djoin
> to unsubscribe:
mailto:foxboro-request@xxxxxxxxxxxxx?subject=3Dleave
>
>
=20
=20
_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at
your own risks. Read http://www.thecassandraproject.org/disclaimer.html
=20
foxboro mailing list: //www.freelists.org/list/foxboro
to subscribe: mailto:foxboro-request@xxxxxxxxxxxxx?subject=3Djoin
to unsubscribe: mailto:foxboro-request@xxxxxxxxxxxxx?subject=3Dleave
=20
Confidentiality Notice: =0AThe information contained in this electronic m=
essage and any attachment(s) to this message are intended for the exclusi=
ve use of the recipient(s) and may contain confidential, privileged or pr=
oprietary information. If you are not the intended recipient, please noti=
fy the sender immediately, delete all copies of this message and any atta=
chment(s). Any other use of the E-Mail by you is prohibited.=0A
_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at
your own risks. Read http://www.thecassandraproject.org/disclaimer.html
foxboro mailing list: //www.freelists.org/list/foxboro
to subscribe: mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe: mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave
Other related posts:
