Re: [foxboro] Questions about Foxboro, Venix 2.1 and informix...

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:             http://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:             http://www.freelists.org/list/foxboro
to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave

Other related posts: