HDTenEightyP/NetNews huggingface dataset:
From: leao@BUPHY0.BU.EDU (Joao Leao)
Newsgroups: comp.databases.ingres
Subject: Re: Ingres 6.4/01 and SunOS 4.1.2
Date: 13 Apr 92 20:37:23 GMT
Article-I.D.: bu.83876
Distribution: all

In article <DRB.92Apr2151030@achilles.ams.com>, drb@achilles.ams.com (Drew Burton) writes:
|> 
|> 	In an earlier posting by Alexander Smith and confirmed by Joao
|> Pedro Leao, they had problems with Ingres 6.4 on SUNos 4.1.2.  
|> 
|> 	We have what appears to be the very close to the same setup and
|> Ingres comes up just fine for us.  More specificly, we have SunOS 4.1.2
|> that came installed on a SPARCstation IPX that we just received.  The
|> Ingres tape is
|>   	6.4/01(su4.u42/01)
|> 	QIC-24
|> 	Date:	3/04/92
|> 
|> 	Alexander's Ingres tape was dated two days earlier.  Also, we're
|> working with a pre-installed SUNos 4.1.2.  Maybe Ingres or Sun got
|> something right in the interim?  Or maybe there is something else in the
|> upgrade to 4.1.2?
|> 
|> 	Drew Burton		drb@math.ams.com
|> 	American Math Society

Apparently Ingres Tech Support has passed on the csinstall bug with SunOS
4.1.2 to Sun and the bug is now identified as Bug #1087264 though as of
yesterday it has not been patched. I am afraid that the IPX has a "smarter"
CPU type and that may be the reason you do not have the same problem. The
bug seems to touch only the older Sparcstations and servers. Mine is a
4/260.
							-Joao Pedro Leao
							
Boston University * Physics Dept			leao@buphy.bu.edu
Newsgroups: comp.databases.ingres
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Subject: Re: Compressing Checkpoints
Organization: 
Date: Thu, 9 Apr 1992 19:10:35 GMT

In article <1992Apr7.082440.16845@csc.canberra.edu.au>, 
mmr@asgserver.canberra.edu.au (Micheal Rainford-Watson) writes:
> 
> Has anyone tried compressing their checkpoints as it's being created.
> ie by editing the ../files/cktmpl.def file and running it through
> a compression program or by using a different backup program which
> has a compression feature. We aren't interested in compressing the 
> checkpoint after it's been created.
> 
> We are running INGRES 6.3/01 on Unix (Dynix V3.0)

I don't know about Unix, but there's a similar capability in VMS.  There
are template files in [ingres.files.checkpoint] containing the commands
that actually get run when you do checkpoint.  You can edit them and
make any changes you want.  It sounds like this is the design intention
of ingres/files/cktmpl.def too.  

When you take an offline checkpoint, it just takes an exclusive lock on
the database and then uses the standard OS backup command to copy the
data directories for the database (ingres/data/dbname/*) to backup files
on the checkpoint disk (ingres/ckp/dbname/*).  In VMS, there is one
backup save set for each data directory for the database.  Use infodb to
find out what those directories are.

For you VMS users, here's a tip.  We reduced the wall time of taking a
400 MB checkpoint from an hour to 15 minutes by adding this line right
before the VMS "backup" command in [ingres.files.checkpoint]ckp_to_disk.com:

	$ set rms_default /block_count = 127 /extend_quantity = 65535

Because of the last setting, you need at least 65,535 blocks free on
your checkpoint disk, over and above the space needed to take the
checkpoint.

--Mark Jaeger
University of Chicago			phone: (312) 702-0328
Graduate School of Business		  fax: (312) 702-0233
1101 East 58th Street, W309		email: cs_mj@gsbvax.uchicago.edu 
Chicago, IL  60637-1511, USA		       (internet)
Disclaimer: My opinions are my own and not those of my employer.

Newsgroups: comp.databases.ingres
From: mmr (Micheal Rainford-Watson)
Subject: Re: Row level locking?
To: alexk@otc.otca.oz.au
Originator: mmr@asgserver.canberra.edu.au
Organization: University of Canberra
Date: Fri, 10 Apr 92 18:43:54 EST
Return-Path: <mmr>

In article <5413@otc.otca.oz> you write:
>In the ULTRIX/SQL version of Ingres, I haved noticed that there is no row level locking.
>

It's the same with all ingres platforms

>Page locking yes - 2048 bytes of data can be locked at a time, by not at row level. :-(
>
>Anyone over come this "feature" without making all rows pages?
>
Implement you own row level locking, eg add a column to each row and flag it
when updating, then reset when finished. And there are other stratergies....

BUT, I wouldn't recommend this! 

Better to briefly ...

SELECT into fields, then COMMIT (release locks)
Update the fields on the form.
Then UPDATE the database with these changed fields, then COMMIT (release locks).

ie Dont hold any locks longer than necessary
From: hevern@cac.washington.edu (M. Hevern)
Newsgroups: comp.databases.ingres
Subject: Re: INGRES Client/Server Security
Date: 13 Apr 92 20:16:19 GMT
Organization: U.W. Information Systems

In article <1992Apr13.140258.23153@bronze.ucs.indiana.edu>, jpolivic@silver.ucs.indiana.edu (Joe Polivick) writes:
> We are interested in any information on how people have implemented
> security for INGRES client/server applications in a production
> environment.  We are currently developing an application using
> JYACC's JAM for the client, and the server is INGRES 6.3 on a Sun
> Sparcstation II running UNIX.  Specifically, we would like to know
> whether anyone has used INGRES groups and roles in the client/server
> environment; and generally, information on security using client/server
> applications with INGRES.

We use roles for our production instalation databases. They keep any user who is not the DBA or doesn't have the role name and password out of SQL, ISQL, VIFRED, etc... They work best with ABF, because the password is not available to anyone searching the source directories. The catch is that you need application level security, but all of the Ingres applications I've develop/maintained already needed/had this.

Groups are tedious to maintain, but function well with roles if a small group of users need to do on the fly SQL queries outside of the application(s).

-- 	MH
       *--------------------------------*------------------------------*
       | Michael Hevern			| Voice: (206) 685-3229        |
       | University Of Washington	| * "I can't dance...          |
       | Information Systems		|    I can't talk...           |
       | 4545 15th Ave. NE		|    The only funny thing about|
       | Seattle, WA 98105		|    me is the way I walk."    |
       | Mail Stop: JE-41               |       -- Genesis             |
       *--------------------------------*------------------------------*
	Disclaimer: If I said it I probably meant it.  My employer isn't
		responsible for my opinions.
From: hagadorn@amsaa-cleo.brl.mil (Thomas Hagadorn)
Newsgroups: comp.databases.ingres
Subject: termcap for ibm3278
Date: 9 Apr 92 20:46:51 GMT
Organization: Army Materiel Systems Analysis Activity


Earlier, I posted this to comp.terminals and comp.protocols.ibm, but
forgot about comp.databases.ingres (that's the application in question).
Is there anyone who has been in this situation out there?  Ingres tech
support suggested I roll my own termcap [fun,fun,fun --not-- :(]

|  I have a user with an ibmpc using a 3278 emulation card to connect to
|an IBM3090.  He is now from there trying to connect to (via telnet) and
|run an application on a Unix machine (Sun).  He's able to log on, but
|naturally all the box frames in the application windows are messing
|up.  My first thought was to find a termcap for an ibm3278, but since
|no one 'ever' uses one of those in a Unix environment, I haven't got
|one.  My second thought was to see if some procedural work around with
|tn3270 might do the trick, but before I ftp and load the sources, I
|thought perhaps the net might have some ideas.  E-mail responses
|preferred with summary for those interested.
|
|regards,
|Tom Hagadorn       hagadorn@brl.mil
From: jarnot@kin.lap.upenn.edu (Kevin J. Jarnot)
Newsgroups: comp.databases.ingres
Subject: XView vs INGRES Windows 4GL
Date: 7 Apr 92 21:21:34 GMT
Organization: University of Pennsylvania, Language Analysis Center

I'm about to embark on a medium-sized, two month project that will involve
writing an X11 interface with embedded SQL in C on a Sun SPARCStation 330 with
INGRES 6.3.  We have Windows 4GL available to us, but I'm worried about being 
constrained by it.  I've also thought about using XView or possibly Xt, but 
here I'm worried about running into time overruns.

Has anyone out there implemented a Windows 4GL project and/or XView/Xt with
embedded SQL?  Any pros/cons/miscellaneous comments on either?  How versatile
is 4GL?  

Thanks for any responses!

Kevin J. Jarnot


-- 
Kevin J. Jarnot	(jarnot@kin.lap.upenn.edu)    	"We're not hitchhiking anymore,
Programmer/Analyst II				 WE'RE RIDING!!!!" 
Univ. of Pennsylvania Language Analysis Center		- Cap'n Ren Hoek
3700 Market St, Suite 202  Phila, PA 19104
Newsgroups: comp.databases.ingres
From: jdr@sloth.mlb.semi.harris.com (Jim Ray)
Subject: ingres newsgroup back issues
Date: Tue, 14 Apr 1992 15:46:26 GMT
Organization: Harris Semiconductor, Melbourne FL
Keywords: ingres, archive

Is the ingres newsgroup archived?  If so, where?

Looking specifically for articles with subject "DISTINCT and SUM".

Thanks,

--
Jim Ray                                Harris Semiconductor
Internet:  jdr@semi.harris.com         PO Box 883   MS 62B-022
Phone:     (407) 729-5059              Melbourne, FL  32901
Newsgroups: comp.databases.ingres
From: amiranda@deveel.aero.org (Ann Miranda)
Subject: Screenform interface link to Ingres database
Organization: The Aerospace Corporation; El Segundo, CA
Date: Tue, 7 Apr 1992 19:42:26 GMT

	I am looking for a screenform interface for use with the
Ingres DBMS.  I want to use it to retrieve, add, and modify data
in the database.  I want the screens directly linked to the database
tables -- ie. I don't want to have to write the behind-the-scenes
queries to retrieve and manipulate the data.  
	I am a newcomer to Ingres, but I am familiar with "Ingmenu",
and it is not what I want (the interface is not specialized enough
for the application I am building).  I have seen "4GL", and I like
the look of it, but not the fact that it isn't directly linked to the
database.
	An Ingres salesperson has pointed out "Vision" to me, and
it looks fairly good, except that, from the brochure, it looks a lot
like "Ingmenu", and  I want a nice GUI windows type interface, not a
VT100 looking interface.  Is it possible to combine Vision with 4Gl?
 

	Does anyone have experience with Vision, or any other 
application I haven't mentioned?  I would greatly appreciate your
comments on this.
Thanks!
From: expert@diku.dk (Stephan Grubbe)
Newsgroups: comp.databases.ingres
Subject: my wiew on ingres
Date: 13 Apr 92 16:14:25 GMT
Organization: Department of Computer Science, U of Copenhagen

We just finished a report where we had to use ingres system.
The only conclusion is that


INGRES SUCKS


This is because the damn system is so slow that you can go eat
dinner before anything show up on the screen. Maybe it's my
institutes implementation that is wrong, but anyhow...
BTW this is not out of anger regarding my grade for the report,
cause that was ok.

Stephan, the very angry user



INGRES - The intelligent database   <------ hahahahahahahahahahaahhah
From: gnb@duke.bby.oz.au (Gregory N. Bond)
Newsgroups: comp.databases.ingres
Subject: Re: Ingres/Net Management
Date: 13 Apr 92 05:19:11 GMT
Organization: Burdett, Buckeridge & Young, Melbourne, Australia

>>>>> On 9 Apr 92 03:12:57 GMT, rayt@cix.compulink.co.uk (Ray Turner) said:


Ray> Does anyone know of any tools, or ideas for tools to manage Ingres/Net
Ray> configuration for 100+ users. If you set up global vnodes its not to
Ray> bad, but if you want each user to be connected with his/her own logon
Ray> you have to run netu from each user account. This seems to be a
Ray> management nightmare as the netu passwords have to be kept in step
Ray> with the unix passwords.

It is indeed an absolute nightmare.  Worse than that, it is a massive
potential security hole (think: where are those passwords you type
into netu?) I have hashed over this with the local Ingres support
people and have an SIR pending on this.  Three solutions spring to mind
(assuming you have something like NIS/YP to share uid's across all the
relevant machines):

1) You could hard-link all the per-node name files together (these are
called $II_SYSTEM/ingres/files/name/IILOGIN_<nodename>); that means
you only need to run netu on one node, the rest get the same info. 

2) There is an environment variable you can set (II_CLUSTER) that has
the same sort of effect - it causes all the name servers to use a
single file.  I got a fax from our support person on this, but it has
no identifying marks so I can't tell you what to ask for.  It looks
like some sort of internal tech note.

3) There is an environment variable called "II_DBMS_SERVER".  If you
set this on the remote machine (via ingsetenv, value "hostname::port"
where port is determined by doing a ps on the server and looking at
the iidbms args) then you don't need the name server or the net server
running on the remote node.  The disadvantage is that the port number
will change each time the dbms is restarted, and you can only have one
backend running (not a problem on a single-CPU DB server).  And if the
install is done right (in particular, if the remote node has an
II_GCN<installation>_RMT_VNODE env variable) then "sql dbname" will
work on any machine and you don't need INGRES/Net.

All these are UNSUPPORTED hacks; we intend to use the third which does
the right sort of things for us (6.3/02 on a SPARC), although there is
some hint that the II_DBMS_SERVER hack will disappear in 6.4.

Greg, in the middle of a 5->6 conversion.
--
Gregory Bond <gnb@bby.oz.au> Burdett Buckeridge & Young Ltd Melbourne Australia
"Take my archetypes - please!" - Henny Jungman (geoffm@purplehaze.Corp.Sun.COM)
From: jarnot@kin.lap.upenn.edu (Kevin J. Jarnot)
Newsgroups: comp.databases.ingres
Subject: XView vs Windows 4GL - SUMMARY
Date: 15 Apr 92 15:09:41 GMT
Organization: University of Pennsylvania, Language Analysis Center

Here's the summary posting that many of you asked for regarding my question
about implementing embedded SQL in XView vs Windows 4GL.

Well, it seems that Windows 4GL has many fans out there.  The overwhelming 
majority of responses were in favor of implementing X/Ingres projects with
W4GL as opposed to C with an X library...


W4GL - 
Pro: 
	+ Easy to use
	+ Quick learning curve
	+ Runs quickly
	+ Enhanced productivity
	+ More robust system
	+ Open-ended
	+ Versatile

Con:
	+ Only Motif - no OpenLook
	+ Heavy on system resources
	+ Limited to whatever X resources are provided with it
	+ Slow application start-up time


XView/ESQL -
Pro:	
	+ OpenLook
	+ Easy to program
	+ Fast application start-up time
	+ Lighter on system resources
	+ Can use low-level Xlib code
	+ Full access to widget sets

Con:
	+ Harder to program
	+ Longer production time
	+ INGRES uses a SIGALRM that may clash with XView, as XView 
	  wants to trap all signals to provide a uniform event 
	  handling scheme


As for my decision, still not sure.  To be honest, it seems that the "higher
ups" want an OpenLook-style interface, and that may be the deciding factor.
After writing several quick ESQL/XView programs over the past week, I've
found it very easy to use (although designing the look of the interfaces is
much harder...reminds me of when I started using SunView and it took me a 
week just to place the widgets correctly!).

If anyone has any further questions, feel free to mail me.

Take care...

Kevin


	

-- 
Kevin J. Jarnot	(jarnot@kin.lap.upenn.edu)    	"We're not hitchhiking anymore,
Programmer/Analyst II				 WE'RE RIDING!!!!" 
Univ. of Pennsylvania Language Analysis Center		- Cap'n Ren Hoek
3700 Market St, Suite 202  Phila, PA 19104
Newsgroups: comp.databases.ingres
From: disc3nh@Rosie.UH.EDU
Subject: INGRES User Groups
Reply-To: disc3nh@Rosie.UH.EDU
Organization: University of Houston
Date: Fri, 17 Apr 1992 01:22:00 GMT

Hi:

I would like to contact Ingres User Groups in Houston and Bay Area.
If you know the contact and his/her phone number, Could you please 
pass them on to me? Thanks in advance.

Vishakh.
From: rao@moose.cccs.umn.edu (Rao V. Akella)
Newsgroups: comp.databases.ingres
Subject: Re: Compressing Checkpoints
Summary: "The steady state of disks is full." -- Ken Thompson
Date: 9 Apr 92 23:51:00 GMT
Article-I.D.: moose.9APR199218514052
Reply-To: rao@moose.cccs.umn.edu
Organization: Colon Cancer Control Study, University of Minnesota, Minneapolis
News-Software: VAX/VMS VNEWS 1.41
X-Lunar-Date: 0 days, 15 hrs, 24 mins until the first quarter of the moon (U.T.)

In article <1992Apr9.131035.1@gsbacd.uchicago.edu>, cs_mj@gsbacd.uchicago.edu (Mark Jaeger) writes:
> For you VMS users, here's a tip.  We reduced the wall time of taking a
> 400 MB checkpoint from an hour to 15 minutes by adding this line right
> before the VMS "backup" command in [ingres.files.checkpoint]ckp_to_disk.com:
> 	$ set rms_default /block_count = 127 /extend_quantity = 65535
> Because of the last setting, you need at least 65,535 blocks free on
> your checkpoint disk, over and above the space needed to take the
> checkpoint.

Lucky you -- I haven't seen this kind of free disk space on my system in ages!
:-)  I never checkpoint to disk -- never had the space for it.  In fact, I
usually run with so little free space that I don't even have enough blocks to
merge my cluster journal files during checkpointing, thereby requiring me to
reDEFINE II_JOURNAL to various interesting places for the duration.

So, if you're checkpointing to tape (like me), here's another tip for you VMS
users: I reduced the wall time of taking a 450 MB checkpoint from an hour to 15
mins (per tape) by modifying II_SYSTEM:[INGRES.FILES.CHECKPOINT]CKP_TO_TAPE.COM
to take the /VERIFY out of BACKUP.  In fact, I modified
	$ backup/verify/ignore=label_processing...
to
	$ backup/ignore=(interlock,label_processing)...

BACKUP by itself does such a good job that the /VERIFY is largely redundant
(IMHO).  A problem with /VERIFY is that BACKUP writes to a 225,000 block tape
in only 12 minutes on the first pass -- and then takes 45 minutes on the second
pass verifying the save-set!

The /ignore=interlock is required if you're taking on-line checkpoints.  I
strongly urge you to modify your file to include this option too.
-- 
Rao Akella, Research Assistant, Colon Cancer Control Study
University of Minnesota, Minneapolis        NIC Handle: RVA3
Internet: rao@moose.cccs.umn.edu    BITNET: RAO%MOOSE@UMNACVX.BITNET
            "I programmed three days, And heard no human voices.
             But the hard disk sang."    -- "The Zen of Programming"
From: judym@col.hp.com (Judy Miller)
Date: Wed, 8 Apr 1992 21:35:38 GMT
Subject: Re: maxrows ?
Organization: HP Colorado Springs Division
Newsgroups: comp.databases.ingres

>What I want, is a SELECT which just delivers one row, even if
>the selection criteria would usually deliver many rows. I believe, 
>this would speedup my application. I don't care which of the rows will
>be delivered first.

Is SELECT DISTINCT what you are looking for?

Judy
From: alexk@otc.otca.oz.au (Alex Kowalenko)
Newsgroups: comp.databases.ingres
Subject: Row level locking?
Date: 9 Apr 92 06:18:12 GMT
Reply-To: alexk@otc.otca.oz.au (Alex Kowalenko)
Organization: R&D, OTC Sydney, Australia

In the ULTRIX/SQL version of Ingres, I haved noticed that there is no row level locking.

Page locking yes - 2048 bytes of data can be locked at a time, by not at row level. :-(

Anyone over come this "feature" without making all rows pages?

-- 

    Alex Kowalenko                 ACSnet: alexk@otc.otca.oz
    R&D Contractor                   UUCP: {uunet,mcvax}!otc.otca.oz!alexk
    |||| OTC ||                       Fax: +6 2 287 3299
                                    Phone: +6 2 287 3131
                                    Snail: GPO Box 7000, Sydney 2001, Australia
Newsgroups: comp.databases.ingres
From: Joe Polivick <jpolivic@silver.ucs.indiana.edu>
Subject: INGRES Client/Server Security
Organization: Indiana University
Date: Mon, 13 Apr 92 14:02:58 GMT

We are interested in any information on how people have implemented
security for INGRES client/server applications in a production
environment.  We are currently developing an application using
JYACC's JAM for the client, and the server is INGRES 6.3 on a Sun
Sparcstation II running UNIX.  Specifically, we would like to know
whether anyone has used INGRES groups and roles in the client/server
environment; and generally, information on security using client/server
applications with INGRES.
From: kortikar@mipos2.intel.com (Aniruddha Kortikar)
Newsgroups: comp.databases
Subject: Implementing Referential Integrity ( Possible in Oracle ?)
Date: 15 Apr 92 00:01:30 GMT
Reply-To: kortikar@mipos2.intel.com (Aniruddha Kortikar)
Distribution: usa
Organization: Microprocessor Component Group, Intel Corp., Santa Clara, CA

Consider following tables

Item-vendor table				Vendor Table
-----------------------				----------------------------
Item_code,vendor_code				vendor_code,name,address etc.

Following rules have to observed

1. Vendor can not be deleted if used in item-vendor table.
2. every vendor in item-vendor table must be present in vendor table.

Rule 1 - can be enforced by putting appropriate triggers (key-delrec etc)
	 in data entry programs of vendor table.

Rule 2 - this is a problem issue.


Consider following scenario

Time 	User1 Action			User 2 Action

10:30   Selected Add data 
        For Adding Data into 
	Item-vendor table

10:31  Checked existence of vendor     
       code v1

10:33					deleted vendor v1
					(Succedded because there was
  					 no entry in item-vendor table)

					Commited.
10:35  commited transaction.

Now item-vendor table contains vendor which does not exist.

Checking the reference at commit time also DOES NOT solve the problem, because
there is still a time gap however small between two statements which check the
existence of reference and commiting of data. (essentially the refrence checking
and commit is not atomic.)

If my understanding is correct Oracle does not allow me to put lock on a row
so that user 2 will not be able to delete it. (select for update type of lock
is no good becuase then TWO people can not add different items for same vendor)

I need a lock of type xxx that will prevent write or delete or update but will
allow another lock of type xxx (or any number of those.), hence the delete has 
to fail if ANY occurance of xxx type of lock exists.

there is no direct way of doing this by using oracle supplied lock(s).

Is my understanding correct or am I missing something.

(In any case how do other major RDBMS's handles issue of refrence checking ?)

Thanks In Advance. 

kortikar (kortikar@mipos2.intel.com)

-------------------------------------------------------------------------------
Views expressed here are entirely mine.
-------------------------------------------------------------------------------
From: jonog@g2syd.genasys.com.au (Jonathan Gowland)
Newsgroups: comp.databases
Subject: C access to dBase IV on Sun
Keywords: dBase IV, Sun, C, CodeBase
Date: 16 Apr 92 07:28:25 GMT
Organization: Genasys II, Sydney, Australia

My company needs to write a program which accesses (and possibly
updates) data managed by dBase IV running on a Sun workstation (i.e.
SunOS).  For various reasons, the program must be written in C, so we
are looking for a C library package which will do the job.  One such
package, CodeBase, has been suggested, but I have also heard that the
version running on the Sun has only just been released, so I am
concerned about how reliable it is.  My questions are:

        How reliable is CodeBase on the Sun?

        What sort of facilities does it provide?

        Are there any other tools available that would provide access
        to dBase IV tables from a C program?


Jonathan Gowland  |  Genasys II Pty Ltd
                  |  13th Level, 33 Berry St, North Sydney, NSW, Australia
                  |  Phone:    +61-2-954-0022 (-9930 FAX)
                  |  Internet: jonog@g2syd.genasys.com.au