Re: [foxboro] Questions about Foxboro, Venix 2.1 and informix...
- From: "Ernesto Castro" <erne.castro@xxxxxxxxx>
- To: foxboro@xxxxxxxxxxxxx
- Date: Mon, 29 Jan 2007 05:05:30 -0300
Do you know exactly in which file the sample data is stored? Or at least
where to look for it?
Thanks!
2007/1/29, Johnson, Alex P (IPS) <alex.johnson@xxxxxxxxxxxxxxxx>:
>
> 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
>
>
_______________________________________________________________________
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:
