HDTenEightyP/NetNews huggingface dataset:
From: rkrithiv@hopi.intel.com (Ramamurthy Krithivas)
Newsgroups: comp.databases.ingres
Subject: H/W Platform for DBMS/Ingres: SUN SS-10 or HP-827 ?
Keywords: Your suggestion would be of great help !!
Date: 17 Nov 92 22:18:44 GMT
Distribution: usa
Organization: Intel Corporation

A financial services company is seeking a hardware platform for 
database management. The choice has been narrowed down to : 

         0] Ingres DBM S/W. 
         1] SUN SS-10 [SS== Super Scalar] 
               [or] 
            HP 827/837. 

The proposed architechture is a client-server based system and to
support upto a maximum of 100-150 users. 

Some questions :
----------------

  0] What outweighing factors between a SUN and HP, makes one 
     of them a clear cut choice as a DBMS platform ? 
      -- Is there somebody out there, who had faced similar dilema ?
      -- Performance/reliability issues.  

  1] Has there been any benchmark that has been run to compare 
     the performances of different platforms for database mgmt ?
     [Especially with Ingres]  

  2] Does the SUN SS-10 performance degrade rapidly with more users ? 
     [Much more than what is considered normal]

  3] Any positive aspect/shorcomings of the hardware platforms 
     [Sun SS-10 or HP 827/837] for DBMS/Ingres use ?

 Could you please email your suggestions/help/hints to 
                rkrithiv@pima.intel.com
 Thanks a lot for your time and patience :

Sincerely :
R. Krithivas

PostScript : The company is based in Madras/New Delhi, India. 
             Some of the posed questions are subjective, but any 
             pointers would be very much appreciated. 

Disclaimer : All opinions expressed in this artice have nothing to
             do with Intel Corporation. 
Newsgroups: comp.databases.ingres
From: "Anthony J. Rzepela" <rzepela@hal.hahnemann.edu>
Subject: Q: slooow access to FE catalogs (ABF,VIFRED)
Organization: National Radio Astronomy Observatory
Date: Fri, 20 Nov 1992 21:59:07 GMT

Hi - 

If anyone is assembling a FAQ, I'm sure this one will make it, 
but I ask anyway: 

Our development database is fairly heavily populated with applications, 
frames, forms, and the like. To battle the EXTREMELY sluggish ABF startup, 
I have run SYSMOD with the INGRES flag (which supposedly optimizes the 
base product's catalogs for VIFRED, ABF, etc.), but still, ABF starts 
up like a tortoise...   Also, choosing 'RUN' from ABF took 
so long just to compare the dates, I could not do it without going insane...

This was with ONE developer on a MVax 3500 on VMS 5.4-2; 

Am I missing something...? 
What can I do...?

-------------------------------------------------------
Tony
Newsgroups: comp.databases.ingres
From: fuglem@idt.unit.no (Ingebrigt Fuglem)
Subject: Keyboard problems in Windows4GL 
Reply-To: fuglem@idt.unit.no (Ingebrigt Fuglem)
Organization: Div. of CS & Telematics, Norwegian Institute of Technology
Date: Mon, 16 Nov 92 06:56:07 GMT

I am running Ingres 6.4/02 and Windows4GL 2.0/01(su4.u42/00) on a SUN Sparc with 
SunOS 4.1.2, and I have a problem!

My keypresses have big problems getting through when I am using a W4GL application, 
and try to enter something in an entryfield. I have to press every key several 
times before it gets registered. This is happening only in the singleline entryfield.
I have tried it from many different computers, with different kind of X setups, but 
with the same result. 
I have also reinstalled everything on another computer, but it didn't help me.

If anybody out there have a clue, please help me!!!!
We are going to demonstrate our application next wednesday, and then it have to work
properly!

---------------------------------------------------------------------
Ingebrigt Fuglem                                   fuglem@idt.unit.no
                
       
Division of Computer Systems and Telematics     
Norwegian Institute of Technology (NTH)         
---------------------------------------------------------------------
Newsgroups: comp.databases.ingres
From: zamper@slc9 (Andreas Zamperoni)
Subject: Problem with 'Radio Field' in Windows4GL
Organization: Department Of Mathematics and Computer Science
Date: Mon, 16 Nov 92 11:57:55 GMT


I have a problem generating a Radio Field with the Application 
Editor for Windows4GL. I want to make a Radio Field with (only)
two items, but by default I get a RF with three items and I can't
get rid of the third one (a '0' always remains in the Value entry).
In the 'sampledb' applications provided by INGRES there are Radio
Fields with two items (e.g. in the second frame of the 'Vendor Info'
application.

Can anybody help me to solve this problem (within the Application Editor) ?

o--------------------------------------------------------------------------o
|                           Andreas Zamperoni                              |
o-----------------------------------o--------------------------------------o
| Rijksuniversiteit te Leiden       |TNO Environmental and Energy Research |
| Department of Computer Science    lInstitute of Applied Geoscience       |
| Niels Bohrweg 1                   |Schoemakerstraat 97                   |
| P.O. Box 9512                     |P.O. Box 6012                         |
| 2300 RA Leiden                    |2600 JA Delft                         |
| The Netherlands                   |The Netherlands                       |
o-----------------------------------o--------------------------------------o
| email: zamper@rulwi.leidenuniv.nl | email: zamper@igg.tno.nl             |
| phone: *31 - (0)71 - 27 7103      | phone: *31 - (0)15 - 69 7720         |
| fax  : *31 - (0)71 - 27 6985      | fax  : *31 - (0)15 - 69 7193         |
o-----------------------------------o--------------------------------------o


Newsgroups: comp.databases.ingres
From: "james syniura" <james.syniura@canrem.com>
Subject: field templates
Reply-To: "james syniura" <james.syniura@canrem.com>
Organization: Canada Remote Systems
Distribution: comp
Date: 22 Nov 92 01:23:16 EST


RB>
RB>
RB>|Is there any way using the Ingres VIFRED program to make field templa
RB>|I am specifically looking for things like the following:
RB>|
RB>|   One numeric only field: X
RB>|   When displayed/modified field looks like: __-__-__
RB>|      where the "-" are actual characters that show up and the text
RB>|      moves around them.  I would like to keep it one numeric field f
RB>|      simplicity reasons, but would like to have the seperation as de
RB>
RB>A format like "nn\-nn\-nn" should do what you want.
RB>
RB>
RB>--
RB>Richard Begg (richard@asis.unimelb.edu.au)
RB>Admin Systems and Info Services - University of Melbourne.

Or....
        Purchase the knowledge management and define a new datatype.

--

=========================================================================
James Syniura  | UUCP    : canrem!james.syniura                 | 
System Support | Internet: james.syniura%canrem.uucp@lsuc.on.ca | 
Bell Canada    | Others  : james.syniura@canrem.uucp            |
========================================================================= 
                     Toronto, Ontario, Canada, Earth.
=========================================================================
     The opinions expressed are my own and not the company I work for.
=========================================================================

---
  WinQwk 2.0 a#575  LOTUS - Let Only The Users Suffer
--
Canada Remote Systems  - Toronto, Ontario
World's Largest PCBOARD System - 416-629-7000/629-7044
From: "Chapman, E-Lu*" <chapman#m#_e-lu*@msgate.corp.apple.com>
Subject: mailing list
Organization: National Radio Astronomy Observatory
Date: Fri, 20 Nov 1992 17:23:03 GMT

Please put my name on the mailing list.
My e-mail address is: 

elu@netcom.com

thanks,

elu
Newsgroups: comp.databases.ingres
From: CS_PAUL@GSBVAX.uchicago.edu (Paul Ford 312/702-0335)
Subject: re: Frequently Used Procedures
Organization: National Radio Astronomy Observatory
Date: Tue, 17 Nov 1992 22:53:51 GMT

Michael McGarrigle writes:

>Does anybody out there know of a way that commonly used routines can be stored
>in one place but accessed by several databases.

Several options occur to me:

  o Write the procedure in an embedded language (e.g., ESQLC/C) and define
    it as a LIBRARY procedure to ABF.  The procedure has to be compiled
    externally to ABF.   The disadvantage is that you must add a link
    options file to your application definition (for VMS, for Unix I'm not
    sure what the moral equivalent is) to tell ABF where to find the
    compiled object file (or object library file) when it links.

  o Under VMS: Leave the procedure in 4GL, but put it in a common
    directory.  Use a VMS path logical for your ABF source directory that
    includes the application specific directory and the common directory.
    Each ABF application that uses the procedure will recompile it, but
    there will be only one source.

    Example:

        Specific source directory for application MYAPP
                DEV1:[SOURCE.MYAPP]
        Common source directory
                DEV1:[SOURCE.COMMON]
        Path logical
                $ define MYAPP_PATH  DEV1:[SOURCE.MYAPP], DEV1:[SOURCE.COMMON]
        ABF directory specification for application MYAPP
                MYAPP_PATH


  o With UNIX I have no real experience, but I'd guess that you could do the
    same sort of common directory trick using soft links instead of VMS
    logical names.  Create a common directory to hold the shared procedure,
    and then in each application directory create a soft link pointing to the
    shared procedure source.  Maybe something like this:

        Specific source directory for application MYAPP
                /dev1/source/myapp
        Common source directory
                /dev1/source/common
        Soft link from application directory to common directory
                /dev1/source/myapp/sharedproc.osq ->
                    /dev1/source/common/sharedproc.osq

    Some real UNIX experts will have to provide the final word on this
    approach.

I'm a 3GL bigot, so the first option is my preference.   In fact it's these
kind of obstacles to code sharing in ABF that make me love it so much.

[I think I accidentally sent off an unedited copy of the original posting.
My apologies.]

Paul Ford
--------------------------------------------------------------------------
GSB Computing Services                  312.702.0335
University of Chicago                   cs_paul@gsbvax.uchicago.edu
1101 E. 58th Street
Chicago IL 60637
--------------------------------------------------------------------------

Newsgroups: comp.databases.ingres
From: reid@UPEI.CA (Mike Reid)
Subject: Auditdb on old journals?
Keywords: auditdb,journal
Organization: University of Prince Edward Island, CANADA
Date: Fri, 20 Nov 1992 15:09:08 GMT


Is there any way to get auditdb to write an audit trail for some previous
journal file?  The journal file is deleted after each checkpoint but I would
like to be able to look for particular changes in a journal file restored
from tape. We are running Ingres 6.4/02 under VMS 5.4. Any suggestions
would be appreciated.

Thanks

Mike Reid <REID@UPEI.CA>
Newsgroups: comp.databases.ingres
From: zhang@cs.rochester.edu (Zhang Ju)
Subject: University Ingres, Ingres, QUEL and SQL 
Organization: University of Rochester
Distribution: usa
Date: Thu, 19 Nov 1992 16:29:13 GMT



I have some very ignorant questions, please e-mail to me.

1. What is the relationship between University Ingres 8.9  and commercial 
Ingres?

2. I am trying to install a University Ingres on a Sun-IPC running SUNOS 4.1.1.
Does any Ingres book exist which can help me in this?

3. I have a POSTGRES running and love its features. Will commercial Ingres
pick it up?

Ju Zhang
Newsgroups: comp.databases.ingres
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Subject: re: Validating data imported from text files.
Organization: 
Date: Fri, 20 Nov 1992 20:40:10 GMT

In article <1992Nov19.134218.1@gsbacd.uchicago.edu>, 
cs_mj@gsbacd.uchicago.edu (Mark Jaeger) writes:
> In <18NOV199217192059@stars.gsfc.nasa.gov>, thompson@stars.gsfc.nasa.gov
> (William Thompson, code 682.1, x2040) writes:
> 
>> I was just told something startling.  In an E-mail message from Myron China
>> <mryo@ind_maroon.gwl.com>, I was told
>> 
>>    problem with flat file xfers is verifying successful completions of both
>>    the dump and the import.  oracle products, for instance, always signal 
>>    a 0 return code whether or not it had a problem.  so you end up spooling
>>    log files and checking them for errors yourself...
>> 
>> That's an astonishing statement to me!...
> ...
> If you want the full power of the database for enforcing rigid rules on
> the data, then you will have to write a program to load the data one row
> at a time, using the SQL "insert" statement instead.

Some nice person at Ingres sent me the following message:

    You also have the option of performing a copy into a temporary
    table,  and then using insert as select to insert into the real
    table, taking advantage of integrities, grants on a particular user
    to insert (rather than the 'all to public' requirement of copy), and
    so on.  It keeps everything in the database, and thus doesn't depend
    on an ESQL  application.

This is a good point and might just save some programmer a lot of work. 
However, it has the obvious disadvantage of having to paw over the data
not once, but twice.

On the subject of "grant all to public", the INGRES SQL "copy table"
statement no longer has that requirement (since 6.4, I think).  Now you
only need to grant "select to user/role/group" for copying out, and
"insert to user/role/group" for copying in.  See p. 7-27 of the SQL
Reference Manual (6.4, Dec. 1991)

I have also read the docs closer and learned that INGRES "copy
table...from" ignores table integrities and rules on the table.  The
suggested approach of using "insert...select" from a temporary table
would fix both of these problems.

--Mark Jaeger				internet: cs_mj@gsbvax.uchicago.edu
Graduate School of Business		yellnet:  (312) 702-0328
University of Chicago			faxnet:   (312) 702-0233
Disclaimer: My opinions are my own and not those of my employer.
Ich bin ein Virus.  Mach' mit und kopiere mich in Deine .signature.
From: mccrobie@saifr00.cfsat.honeywell.com (Dan McCrobie)
Newsgroups: comp.databases.ingres
Subject: Windows 4GL Dialog boxes
Summary: How do you disable the minimize feature??
Keywords: dialog boxes, iconification, minimize buttons
Date: 16 Nov 92 18:58:14 GMT
Article-I.D.: saifr00.1992Nov16.185814.4897
Followup-To: mccrobie@saifr00.cfsat.honeywell.com
Organization: Honeywell Air Transport Systems Division

In Windows 4GL, dialog boxes look exactly the same as windows.  This
creates problems for users since they can iconify dialog boxes (i.e, 
take the window and shrink it to an icon).  The problem develops when
the user wants to continue in the application with an iconfied dialog.
The system responds with a wait cursor (watch), leaving the user wondering
what happened.  On a system restart, all windows (including dialog boxes)
are closed so the user gets no feedback and is free to make the same error
again.

Besides the obvious fix to make the dialogs interactive, if we want to 
still use application modal dialogs (i.e. nothing else works in the
application until the dialog is answered), is there a way to avoid having
dialog boxes come up with iconify window buttons?  


 Dan McCrobie 
 mccrobie@saifr00.cfsat.honeywell.com
Newsgroups: comp.databases.ingres
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Subject: Re: Tab Char from ReportWriter
Organization: 
Date: Tue, 17 Nov 1992 19:27:02 GMT

In article <1992Nov17.010000.2403@sei.cmu.edu>, dz@sei.cmu.edu (David Zubrow) 
writes:
> How can I get ReportWriter to output a tab (\011) char?  

No can do.  This is a limitation of RW as of 6.4/02.  Workaround: output
some obscure character (like tilde) and then edit the output file to
globally search and replace it.

--Mark Jaeger				internet: cs_mj@gsbvax.uchicago.edu
Graduate School of Business		yellnet:  (312) 702-0328
University of Chicago			faxnet:   (312) 702-0233
Disclaimer: My opinions are my own and not those of my employer.
Ich bin ein Virus.  Mach' mit und kopiere mich in Deine .signature.

Newsgroups: comp.databases.ingres
From: eric@brolga.cc.uq.oz.au (Eric Halil)
Subject: Error count for server has been exceeded (But WHY?!)
Organization: Prentice Centre, University of Queensland
Date: Fri, 20 Nov 1992 03:12:50 GMT

We've been having regular problems with our server exiting with

E_SC0221_SERVER_ERROR_MAX      Error count for server has been exceeded.
E_GC2410_PERF_CONV       PL internal error. PERFORM_CONVERSION Failed. Please
see system admimistrator.  (there's a few of these errors)

then it dies.

There's never been anything in the errlog.log immediately before the
SERVER_ERROR_MAX error that would indicate any sort of serious error. And the
last time the server died the last message logged before the SERVER_ERROR_MAX
problem occurred 4 hrs previously!

Has anybody been having similar unexplained server exits?  Can anyone tell
me what sort and number of "invisible" errors might possibly be causing it 
to exceed it's magic quota of errors??

Thanks,
Eric.
--
Eric Halil                           |Internet/CSnet:         eric@cc.uq.oz.au
Prentice Centre                      |Bitnet:    eric%cc.uq.oz.au@uunet.uu.net
University of Queensland    4072     |UUCP:        uunet!munnari!cc.uq.oz!eric
AUSTRALIA --   Phone: +61 7 365 3610 |JANET:        eric%cc.uq.oz.au@uk.ac.ukc
Newsgroups: comp.databases.ingres
From: brunette@sju.edu (Glenn M. Brunette, Jr.)
Subject: Field Templates
Organization: St. Joseph's University
Date: Thu, 12 Nov 1992 18:22:17 GMT


Is there any way using the Ingres VIFRED program to make field templates?
I am specifically looking for things like the following:
 
   One numeric only field: X
   When displayed/modified field looks like: __-__-__
      where the "-" are actual characters that show up and the text
      moves around them.  I would like to keep it one numeric field for
      simplicity reasons, but would like to have the seperation as described.

Any help would be greatly appreciated!
Thanks,
Glenn

-- 
Glenn M. Brunette, Jr.                             Internet  : brunette@sju.edu
Assistant Network Manager                              UUCP  : sjuphil!brunette
Network Services & Academic Computing              Telephone : (215) 660-1524  
Saint Joseph's University                                Fax : (215) 660 1536
Newsgroups: comp.databases.ingres
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Subject: Re: Gnu C++ and INGRES
Followup-To: gcc.help
Organization: 
Date: Wed, 18 Nov 1992 20:26:28 GMT

In article <1992Nov17.133746.1439@dct.ac.uk>, mcsmijq@dct.ac.uk writes:

> Does anyone know how to link gnu C++ to INGRES on a VAX cluster. It,s easy
> enough using the link command with a vaxc obj file but what's the syntax using
> cxshare?

I don't quite know what cxshare is, but if it is a shareable runtime
library (similar to the file sys$share:vaxcrtl.exe that is supplied with
either VMS or VAX C), then you could link your program in either of two
ways:

		$ cc foo.c
		$ link foo.obj,sys$input: /opt
		gnu$lib:cxshare.exe /share
		^Z

or

		$ cc foo.c
		$ link foo.obj,foo.opt /opt

where foo.opt contains this line:

		gnu$lib:cxshare.exe /share

You'll have to adjust the name of "gnu$lib" for your site.

Shareable runtime libraries in VMS have the great advantages of (1)
making your images much, much smaller, thereby saving disk space and
reducing image activation time; and (2) reducing memory usage at runtime
since there need be only one copy of the shareable image in physical
memory for all users.

--Mark Jaeger				internet: cs_mj@gsbvax.uchicago.edu
Graduate School of Business		yellnet:  (312) 702-0328
University of Chicago			faxnet:   (312) 702-0233
Disclaimer: My opinions are my own and not those of my employer.
Ich bin ein Virus.  Mach' mit und kopiere mich in Deine .signature.

Newsgroups: comp.databases.ingres
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Subject: Re: Q: slooow access to FE catalogs (ABF,VIFRED)
Organization: 
Date: Mon, 23 Nov 1992 20:34:00 GMT

In article <00963E7D.8D984880.30414@hal.hahnemann.edu>, "Anthony J. Rzepela" 
<rzepela@hal.hahnemann.edu> writes:

> Our development database is fairly heavily populated with applications, 
> frames, forms, and the like. To battle the EXTREMELY sluggish ABF startup, 
> I have run SYSMOD with the INGRES flag (which supposedly optimizes the 
> base product's catalogs for VIFRED, ABF, etc.), but still, ABF starts 
> up like a tortoise...   Also, choosing 'RUN' from ABF took 
> so long just to compare the dates, I could not do it without going insane...

It's just possible that you could get _some_ benefit out of doing
"optimizedb" on the front end system catalogs.  I don't remember the
details, but you have to either specify the "-zc" switch, or name the
tables explicitly with the "-r" switch, or both.

You could also try running with the II_EMBED_SET environment variable
set to "printqry" in order to capture the queries to a file, and then
look at the performance statistics.  That might give a clue which ABF
queries are taking too long, and what could be done to speed them up.

--Mark Jaeger				internet: cs_mj@gsbvax.uchicago.edu
Graduate School of Business		yellnet:  (312) 702-0328
University of Chicago			faxnet:   (312) 702-0233
Disclaimer: My opinions are my own and not those of my employer.
Ich bin ein Virus.  Mach' mit und kopiere mich in Deine .signature.

Newsgroups: comp.databases.ingres
From: pneal@ingres.com (Calgary (Kal-gree), (403) 262-8119)
Subject: RE: Problem installing Ingres 6.4/02 under SunOS 4.1.3
Organization: National Radio Astronomy Observatory
Date: Mon, 16 Nov 1992 16:20:22 GMT

The problem has to do with re mapping memory locations  ...

Try the following ...

ingsetenv II_LG_MAP_ADDR 10000000


Ingres 6.4/02 was recently re-certified for use with SUN/OS 4.1.3, and this 
issue has been resolved.


>From:	PONY::"tjb@MATH.AMS.ORG" 14-NOV-1992 09:44:32.49
>To:	info-ingres@MATH.AMS.ORG
>CC:	
>Subj:	Problem installing Ingres 6.4/02 under SunOS 4.1.3
>
>I just installed Ingres 6.4/02 on a Sparcstation 10 running SunOS 4.1.3 but
>when it tries to start up it fails with the following error
>
>---------------------- RESOURCE CHECKING COMPLETE -----------------------
>
>
>Allocating 401408 bytes of shared memory...
>
>!shmat for id 201 at address F4000000 fails
>!errno = 22
>!Can't map locking segment into memory at address FFFFFFFF
>!Check or adjust the value of II_LG_MAP_ADDR
>Could not create the system segment, does your kernel have enough
>shared memory or has this program already been run?
>
>-----------------------------------------------------------------------------
>
>Has anyone seen this problem before?  I'm not entirely surprised since
>the release notes only guarantee that it works under 4.1.1 or 4.1.2.
>
>I have also put a call into Ingres but they haven't gotten back to me yet.
>-- 
>John Stewart -- Computing and Communications Services, Carleton University
>Internet: jstewart@ccs.carleton.ca or Mr.Canoehead@algonquin.carleton.ca  
>"The average middle income family with two parents and children pays $2,945
>more in Federal taxes than they would have under the tax policies in place
>before the Tories first came to power in 1984."
Newsgroups: comp.databases.ingres
From: chou@csd.hku.hk (Chou Sui Lin)
Subject: Printscreen
Organization: National Radio Astronomy Observatory
Date: Tue, 17 Nov 1992 05:50:03 GMT


Is there any way of specifying different printer queue from Ingres tools
such as abf for printing screen. The key word "printer" or the environment
variable ING_PRINT can only be used for a specific printer queue.

Thanks in advance

chou@csd.hku.hk