Re: [foxboro] Questions about Foxboro, Venix 2.1 and informix...
- From: "Ernesto Castro" <erne.castro@xxxxxxxxx>
- To: foxboro@xxxxxxxxxxxxx
- Date: Fri, 26 Jan 2007 11:37:38 -0300
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=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
>
>
_______________________________________________________________________
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:
