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 10:41:35 -0500
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,
=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: 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=3Djoin
>
> to unsubscribe:
mailto:foxboro-request@xxxxxxxxxxxxx?subject=3Dleave
>
>
>
>
>
>
>
> 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=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:
