Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!samsung!munnari.oz.au!bruce!gdwb.OZ.AU!csb From: csb@gdwb.oz.au (Craig Bishop) Newsgroups: comp.databases Subject: Re: Use of INGRES in a SUN environmnet Message-ID: Date: 18 Sep 90 03:47:01 GMT References: <1990Sep17.150529.4468@cs.umu.se> Sender: news@gdwb.oz.au Lines: 57 krn@cs.umu.se (Kenneth Nilsson) writes: >We are now installing INGRES version 6.2 (including INGRES Net on SUN >(4/490 servers and SPARC SS1 diskless work stations) and have some questions >concerning the best way to organize the use of INGRES for a large number >of students. >1. Registration and deregistration of students as users of INGRES/Net. > INGRES should be available for each of the students (about 200 students) > from each work stations (about 30). As we have understood it, a > student must register as a user of a dbms on a certain server each time > when he starts using a new work station. Since most of the students are > casual users of INGRES we would like to avoid the registration on the > net. Is there any clever way to achieve this? Note that each user is > supposed to use his own private database. Major pain in the rear end, but the way they have designed it, on *EACH* workstation that a student uses that student must Authorise his account. INGRES makes no use at all of BSD network authorisation via the hosts.equiv and .rhosts files. If someone has a better way please tell me. We are running 6.3 on SUNOS 4.1 and the same situation still exists. I have questioned many people in INGRES about this and there seems no other way. Apparently there is a produce due for release in the next 6 months or so call (I think) "NetView" which is supposed to resolve some of these problems. >2. When using INGRES Net a number of processes are presupposed both on the > clients and the server (e.g. iigcc and iigcn). How often does any of > these processes "die" ? Almost never. The major problem I found was sometimes they did not start up for unknown reasons. And once they caused our server to stop in it tracks because on all the clients (INGRES calls them frontends) which had a database active the "iigcc" program started looping on something and was sending enourmous amounts of data to the server (backend). Once I found out what was happening killing and restarting the "iigcc" processes on the clients fixed things. >3. Which are your experience of the load on the server/network when for > example 15 - 20 students are developing applications by means Application > By Form, etc. simultaneously. Don't know. >4. Have you any experience of Windows 4GL in an XWindows environment? Very soon. -- Craig Bishop Geelong & District Water Board Phone: +61 52 262506 61-67 Ryrie St Geelong Fax: +61 52 218236 Victoria 3220 Australia -- Craig Bishop Geelong & District Water Board Phone: +61 52 262506 61-67 Ryrie St Geelong Fax: +61 52 218236 Victoria 3220 Australia