Re: [foxboro] Questions about Foxboro, Venix 2.1 and informix...
- From: "Johnson, Alex P \(IPS\)" <alex.johnson@xxxxxxxxxxxxxxxx>
- To: <foxboro@xxxxxxxxxxxxx>
- Date: Fri, 26 Jan 2007 09:22:45 -0500
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=join
to unsubscribe: mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave
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=join
to unsubscribe: mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave
Other related posts:
