HDTenEightyP/NetNews huggingface dataset:
From: Tom Blythe <TJB@MATH.AMS.ORG>
Subject: copying a database
Organization: National Radio Astronomy Observatory
Date: Wed, 23 Dec 1992 04:00:55 GMT



I am attempting to copy a database, db1, to a database with another
name, db2, with both database located on the same machine. So I
performed the following steps:

1. rearranged each location for db1 so that no one location
   was using more than 44% of the disk.

2. created db2 with the same default location as db1 

3. extended db2 to all the same locations as db1

4. created and dropped a table repeatedly in db2 until the next table id
   (as seen in infodb) for db2 is larger than the next table id for db1.

5. shutdown ingres on the machine

6. copied all .t00 files from .../ingres/data/default/db1 directories to 
   .../ingres/data/default/db2 directories

7. restarted ingres

When I try to access db2, I get the following error:

   E_US0845 Table 'iidbcapabilities' does not exist or is not owned by you.
    (Tue Dec 22 22:48:49 1992)

If I look in db1 for the filename for iidbcapabilities, I can see that
file in the correct directory for db2 with the proper owner and
permissions.

All of this was done using Ingres v6.4/01  on a Solbourne
running 4.1A.2.

Does anyone have a suggestion for what I may have done wrong? I thought
that I had followed the basic recipe as described in this group
previously.

----------------------------------------------------------------------
Tom Blythe                               TJB@MATH.AMS.ORG
American Mathematical Society            (401) 455-4015
PO Box 6248, 201 Charles St.
Providence, RI 02940
----------------------------------------------------------------------
From: brent@spss.com (Brent Lambert)
Newsgroups: comp.databases.ingres
Subject: Ingres forms on IBM RS6000/AIX
Keywords: HELP
Date: 29 Dec 92 16:22:37 GMT
Organization: SPSS, Inc. - portable code group

NOTES:
I'm trying to use Ingres 6.4 on an IBM RS6000 w/ AIX 3.2, working from
an IBM X-Station 120.
Somehow, we don't seem to have any AIX-specific Ingres documentation.
We're not an Ingres-house, obviously, just a 3rd party s/w developer
trying to interface with a variety of DBMS's, including Ingres.

PROBLEM:
When I start a normal aixterm, my TERM environment variable is automagically
set to "aixterm-m".  Ingres forms don't recognize that.

If I then set  TERM_INGRES to "aixterm", I can actually start accessdb and use
the function keys, except that some of the things I want to do are mapped to
keys F13-F15, which don't exist on my keyboard.  Besides that, the graphics
characters show up as garbage characters instead of lines.  I can work around
the first problem easily enough by using the Menu key and the first letter of
the thing I want to do, but it's still a nuisance.  The second problem is a
nuisance, as well.

QUESTION:
Can anyone tell me what I need to do to use Ingres Forms from an IBM X-Station
in a way that Ingres Forms really likes?  Is there such a thing?


-- 
The above statements are not the opinions or policies of SPSS Inc.
The above statements may not be the opinions of Brent Lambert.
The first disclaimer is a policy of SPSS Inc.
Subsequent disclaimers are probably the opinion of Brent Lambert.
Newsgroups: comp.databases.ingres
From: "james syniura" <james.syniura@canrem.com>
Subject: db admin tools
Reply-To: "james syniura" <james.syniura@canrem.com>
Organization: Canada Remote Systems
Distribution: comp
Date: 23 Dec 92 11:24:16 EST

Rob Mcnicholas ....

RM>  Newsgroup: comp.databases.ingres
RM> Message-ID: <ROBM.92Dec22120335@ishtar.Berkeley.EDU>
RM>    Subject: DB admin tools
RM>
RM>Hi all,
RM>
RM>I'm working on a database which is in a constant state of flux.
RM>Necessity dictated that we put it into production before we had really
RM>worked out all the problems, so I often find myself dropping and
RM>recreating tables to add a new field, or change a field's size or
RM>type, etc.  After doing this once or twice, I quickly learned that
RM>there are many side effects of these kinds of changes.  For example,
RM>dropping a table causes any views, forms, or permits which referred to
RM>that table to be destroyed also, so the DBA needs to create scripts to
RM>recreate all the different pieces, and remember to update these
RM>scripts whenever a change is made anywhere.  Unfortunately, Ingres
RM>doesn't seem to provide any tools to help make this kind of change
RM>easier.  I've been using unloaddb and then editing the scripts to
RM>recreate just the parts i need, but this is tedious, and it doesn't
RM>handle forms or views very well.
RM>
RM>I've been thinking about writing my own tools that would access the
RM>system catalogs and help find all references to a particular table or
RM>field, so that these changes would be easier to manage.  But before I
RM>do it myself, I ask:
RM>
RM>Does anyone have any suggestions for any Public Domain or commercial
RM>products which would provide this kind of functionality?
RM>
RM>Thanks in advance,
RM>
RM>-Rob

If you are on a VAX system, you should have a third party product called
schemadef in the schemadef sub-directory. This is not written by ASK, but 
will perform the DBA tasks you require.


James Syniura

--

=========================================================================
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.0b#575  Excuse me, I have to recharge my flamethrower.
--
Canada Remote Systems  - Toronto, Ontario
World's Largest PCBOARD System - 416-629-7000/629-7044
Newsgroups: comp.databases.ingres
From: sethg@dcatlas.dot.gov (Seth Grimes)
Subject: Managing array/matrix data?
Organization: U.S Dept. of Transportation
Distribution: comp
Date: Tue, 22 Dec 1992 10:27:03 GMT

I'd like to hear from anyone who has used Ingres to manage array or
matrix data using Ingres (which presumably would be done with the 
Object Management extension).  I researching DBs that could manage
an extensive collection of time-series data, which can be thought of
as one-dimensional arrays, and some multi-dimensional matrices.

Thanks,

		Seth Grimes, grimes@oecd.fr
From: franks@ntrc26.ntrc.ntu.ac.sg (Frank Siebenlist)
Newsgroups: comp.databases.ingres
Subject: Xdefaults entries for windows4gl?
Date: 22 Dec 92 04:11:23 GMT
Distribution: comp.databases.ingres
Organization: /home/franks/.organization


We are unable to find any references to the Xdefaults entries which
we can use to change the font in the system editor.
(The default DEC-font refuses to show underscores...)
Anyone out there who knows more about this?

Regards, Frank and Chock Lee.
--
---------------------------------------------------
Frank Siebenlist             <franks@ntu.ac.sg>
Senior Research Fellow
GINTIC Institute of Manufacturing Technology (GIMT)
Nanyang Technological University (NTU)
Nanyang Avenue
Singapore 2263
Tel: (65) 799-1356               Fax: (65) 791-2927
---------------------------------------------------
Newsgroups: comp.databases.ingres
From: macdonal@westford.ccur.com (Steve MacDonald)
Subject: Popup menus
Organization: Concurrent Computer Corp.  Westford, MA
Distribution: usa
Date: Wed, 23 Dec 1992 20:02:33 GMT


I'm interested in creating a popup menu for my database application, similar 
to the one in the abf demo which, when called, prompts the user to enter a 
character from a to d, thus permitting the user to examine various tables in the
database. I'm curious as to how this is accomplished. I have looked through 
several of the manuals and I have yet to come up with something that appears to
apply. Could someone please point me in the right direction? I did see the 
section on the abf demo database which lists the code for the database.osq
function, but I couldn't figure out where the little box windows are created or,
for that matter, how they are created.




					Thanks,
					Steve
From: sm_rosen@ceres.rm.fccc.edu (Steve Rosen)
Newsgroups: comp.databases.ingres
Subject: Using UNIFACE with Ingres
Date: 30 Dec 92 17:29:45 GMT
Reply-To: sm_rosen@ceres.fccc.edu
Organization: Fox Chase Cancer Center - Phila, PA
Originator: sm_rosen@ceres.rm.fccc.edu


Anybody using UNIFACE (4GL) with Ingres?  I am curious
about opinions, etc.  Please send e-mail.


-- 
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
             Steve Rosen / Fox Chase Cancer Center / Phila, PA
         {Voice}: (215) 728-3665, E-Mail: sm_rosen@ceres.fccc.edu

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Newsgroups: comp.databases.ingres
From: domke@wudos5.wustl.edu (Fred M. Domke)
Subject: RE: DB admin tools
Organization: National Radio Astronomy Observatory
Date: Thu, 24 Dec 1992 16:15:17 GMT

If you are using SchemaDef II, you may wish to modify the OSQ for the Save_Info 
frame.  The code to extract view definitions does a 'squeeze', 'trim' and 
concatenates a blank between multiple rows of view definition text.  Since the 
text may not split at word boundaries, this may fail.  Specifically, modify line 
85 of Sav_Info.OSQ from 
    "SELECT IItext = squeeze(v.text_segment),"... 
to 
    "SELECT IItext = v.text_segment,"... 
and modify line 107 from
    "IIdesc = IIdesc + trim(IItext)+' ';" 
to 
    "IIdesc = IIdesc + IItext;".

Other than that, it seems to work fine.
From: judy_k@cho006.cho.ge.com
Newsgroups: comp.databases.ingres
Subject: Code management - how much is enough?
Date: 22 Dec 92 10:21:09 EDT
Organization: GE Fanuc Automation, North America

A debate on database development and code management methodology has occurred
in the midst of a database project here and I am looking for information or
experiences along these lines. 

Our application is targeted for a unix workstation with 4gl user interfaces.
We have had four developers working on this for the last few months. It happens
that we have varied backgrounds, 2 working on 4gl, 1 on 3gl (interfacing to
other systems with esqlc and cron) and the other working closely with the 
end-users on the design and implementation details. The end-users are internal 
here in our company.

The debate is on how much code management we should do and to what extreme it
should be done. The one side insists we break every element out into scripts 
to be managed with rcs (or even use a networked vax and cms) in an elaborate 
system of alpha, beta and large directory structures for each-- essentially, 
an exploded copy of everything for every release. The other side while not 
opposed to the release structures is not in favor of the explosion-- rather, 
wants only to unloaddb and exportapp as rollback points and views the 
explosion as an unnecessary burden.
---
  Ken Judy  ><>
  GE Fanuc  Charlottesville, VA
  judy_k@cho006.cho.GE.COM     
Newsgroups: comp.databases.ingres
From: dstan@PROBLEM_WITH_INEWS_GATEWAY_FILE (David W. Stan)
Subject: DB admin tools
Date: Wed, 23 Dec 1992 00:47:18 GMT
Organization: HP Sonoma County (SRSD/MWTD/MID)
X-Newsreader: TIN [version 1.1.9 PL6]

I received a mailer from "AEGIS". The ad indicates their software
does everything you asked and maybe a little more.

I have not used it or talked to anyone who has so I can't make
a recommendation.

The telephone number is 1-510-814-7050.

Address: 

Aegis Products, Incorporated
1070 Marina Village Parkway, Suite 101
Alameda, CA 94501
Fax (510) 814-9383

--
David W. Stan 
Newsgroups: comp.databases.ingres
From: "Sande Nissen (CompuCtr, SoftServ)" <SNISSEN@carleton.edu>
Subject: UNSUBSCRIBE
Organization: National Radio Astronomy Observatory
Date: Thu, 31 Dec 1992 21:36:12 GMT

UNSUBSCRIBE

				Sande Nissen
				Computer Center, Carleton College
				Internet: snissen@carleton.edu
				CompuServe: [74716,3673]
From: pavlov@niktow.canisius.edu (Greg Pavlov)
Newsgroups: comp.databases.ingres
Subject: Re: Ingres Design Limits
Date: 29 Dec 92 16:08:56 GMT
Organization: Canisius College, Buffalo NY. 14208

In article <2967@perl-sun.dwrsun4.UUCP>, perl@dwrsun4.UUCP (Robert Perlberg) writes:
> 
> > -	256 column limit per table
> 
> Probably true.  I've run into the 2000 byte limit myself (although if I
> had my way I would have designed the database differently), but I'd
> like to know what type of application would need more than 256
> columns.
> 
  Three "rules":

   1. the universe of applications is greater than any single individual's
      ability to conceive of them;

   2. any limit will be insufficient for some application;

   3. limits apply to joins as well.


   greg pavlov
   pavlov@fstrf.org
From: robm@ishtar.Berkeley.EDU (Rob McNicholas)
Newsgroups: comp.databases.ingres
Subject: DB admin tools
Date: 22 Dec 92 12:03:35
Organization: Technical and Computing Services, U.C. Berkeley, Berkeley, CA
Distribution: world
NNTP-Posting-Host: ishtar.berkeley.edu

Hi all,

I'm working on a database which is in a constant state of flux.
Necessity dictated that we put it into production before we had really
worked out all the problems, so I often find myself dropping and
recreating tables to add a new field, or change a field's size or
type, etc.  After doing this once or twice, I quickly learned that
there are many side effects of these kinds of changes.  For example,
dropping a table causes any views, forms, or permits which referred to
that table to be destroyed also, so the DBA needs to create scripts to
recreate all the different pieces, and remember to update these
scripts whenever a change is made anywhere.  Unfortunately, Ingres
doesn't seem to provide any tools to help make this kind of change
easier.  I've been using unloaddb and then editing the scripts to
recreate just the parts i need, but this is tedious, and it doesn't
handle forms or views very well.

I've been thinking about writing my own tools that would access the
system catalogs and help find all references to a particular table or
field, so that these changes would be easier to manage.  But before I
do it myself, I ask:

Does anyone have any suggestions for any Public Domain or commercial
products which would provide this kind of functionality?

Thanks in advance,

-Rob

--
Rob McNicholas		    Technical & Computing Services, EECS, U.C. Berkeley
robm@eecs.berkeley.edu	    Voice: 510/642-8633  FAX: 510/643-7846
Newsgroups: comp.databases.ingres
From: sfc@tpghq.com (Steve Caswell)
Subject: Re: Optimizer question
Organization: Palmer & Associates, Inc., Norcross, GA
Date: Tue, 29 Dec 1992 14:38:57 GMT

In article <Dec28.232159.59717@yuma.ACNS.ColoState.EDU> daveb@NREL.ColoState.EDU (Dave Bigelow 491-5574) writes:
>Using INGRES SunOS Version 6.4/02 (su4.u42/00) on a 670MP I get
>the following message when I try to do a count by on a data field
>(field_name). This also happens in Report_Writer when a conditional
>on the field is specified.
>
>   'the histogram for [field_name] is not monotonically increasing.'
>
>In poking around I discovered that the table was re-optimized but
>the second time without the inclusion of the offending field.  My
>question is does the optimizer clear stale statistics each time it
>is invoked or do I have to do another modify to clear the
>statistics? Is this the likely cause of the problem?
>
>Thanks for your reply.
>
>-- 
>Dave Bigelow                        
>Natural Resource Ecology Laboratory  internet:  daveb@panicum.nrel.colostate.edu
>Colorado State University            telephone: 303-491-5574      
>Fort Collins, CO 80523               FAX:       303-491-1965

There is a bug in 6.4/02 that causes the symptom you mentioned.  The problem
is most likely to occur when a date column that is used in a comparison contains
some enpty strings rather than non-empty actual dates.  The problem stems from
a bug in the optimizedb utility which produces overlapping histograms if this
data condition exists.

To avoid the problem, remove the optimizer staistics from certain date columns
that are involved in queries that file with the "not monotonically increasing"
error.  The involved date columns probably appear in comparison (i.e., the
where clause) in the queries that fail.

Statistics can be removed from offending columsn selectively.  For example,
to remove statistics from the 'columnname' column in the table 'tablename',
in the database 'dbname', do the following:

   statdump -zdl dbname -rtablename -acolumnname

To answer your original questions, INGRES only clears stale statistics when
you specify a particular column.  In other words, when optimizedb was run the
second time, with the offending column ommitted, optimizedb only performed
optimization on columns you specified.  It left stats on the other columns
alone (I'm assuming you ran optimizedb with some kind of flag telling it which
columns to optimize).

-- 

Steve Caswell           |   (404) 448-7727    |  "The opinions expressed are my
Principal Consultant    |   sfc@tpghq.com     |   own.  They may not be perfect,
The Palmer Group        |   uunet!tpghq!sfc   |   but they're all I've got."
From: pk110377@wvnvms.wvnet.edu
Newsgroups: comp.databases
Subject: DBASE III/IV MDX,NDX, DBT File Formats
Date: 24 Dec 92 05:35:19 GMT
Organization: West Virginia Network for Educational Telecomputing

I am working on a C++ class to handle DBASE III/IV files.  I can't find much
documentation on the MDX, NDX or DBT files.  If someone would E-mail them to me
it would save me a ***lot*** of time.   Thanks,  Alan Dennis.

Internet: PK110377@wvnvaxa.wvnet.edu
Newsgroups: comp.databases
From: landers@comm.mgmt.purdue.edu (Chris Landers)
Subject: Anyone have the FoxTalk Articles Index file?
Date: Tue, 29 Dec 1992 22:13:33 GMT
Organization: Krannert Graduate School of Management, Purdue University


Could you mail it to me? 
Thanks.

    <================================><=================================>
    ||  Christopher Landers          ||  Purdue University - KRAN 708  ||
    ||  Krannert Computing Center    ||  West Lafayette, IN  47907     ||
    <=================== landers@comm.mgmt.purdue.edu ==================>
From: shah@tay1.dec.com (Amitabh Shah)
Newsgroups: comp.databases
Subject: Re: 500'000 records - who does best?
Date: 1 Jan 93 20:45:58
Organization: Digital Equipment Corporation, TAY1, Littleton MA
	<1993Jan1.182624.2993@uunet!tellab5!odgate>
NNTP-Posting-Host: santur.tay1.dec.com
In-reply-to: mike@uunet!tellab5!odgate's message of 1 Jan 93 18:26:24 GMT


On 1 Jan 93 18:26:24 GMT, mike@uunet!tellab5!odgate (Mike J. Kelly) said:
>> lamaster@pioneer.arc.nasa.gov (Hugh LaMaster) writes:
>In article <18774@mindlink.bc.ca>, Mischa_Sandberg@mindlink.bc.ca (Mischa Sandberg) writes:
>|> We run Sybase on Suns and RS6000's. We chose Sybase because, within our
>|> domain, they beat Oracle down quite handily (they also didn't try to
>|> fudge the benchmark). 

>>Would anyone care to comment on the ad campaign that Oracle is 
>>running right now, showing Oracle 7 to be 3-4X faster than Sybase on
>>TPC-A?  Unfortunately, in their long list of systems compared, there
>>is very little overlap in the system configurations run between the
>>different vendors. The same ad has appeared in a number of trade rags.
>>The "headline" is: Sybase Best: 183 TPS   Oracle 7 Best: 645 TPS.

> I would be very skeptical of any Oracle benchmark claims because Oracle's
> license prevents the publication of any benchmark results without Oracle's
> permission.  Therefore, the only Oracle benchmark results you will see are
> the "good" ones.

While I can not comment on Oracle's policy of benchmarking in general, I can
say something about the TPC-A benchmark results. All TPC results have to be
accompanied by a Full Disclosure Report that gives a substantial amount of
information about how the benchmark was run. If a vendor tries to cheat in
their tests, chances are good that this will be caught, since their
competitors would be closely scrutinizing the reports. 

That said, however, Oracle's recent TPC-A and TPC-B tests - those run with
Oracle7 - are commonly known to use a TPC benchmark special that they
implemented in Oracle7, viz., "discrete transactions". The latter are so
restricted in their functionality, and in their possible interaction with
the normal transactions, that they are utterly useless in any reallife
application. Their sole purpose seems to be to enhance TPC-A and -B results.
Thus, any of Oracle's claims for TPC-A or -B with Oracle7 should be taken with
a large grain of salt. 

-amitabh.
--
______________________________________________________________________________
Amitabh Shah                                   shah@tay1.dec.com----(INTERNET)
Digital Equipment Corporation                  santur::shah----------(EASYNET)
Software Performance Group                     +1 508 952 4430---------(PHONE)
151 Taylor St. Littleton MA 01460              +1 508 952 4197-----------(FAX)
From: hagadorn@amsaa-cleo.brl.mil (Thomas Hagadorn)
Newsgroups: comp.databases
Subject: Re: Zip code data base wanted
Date: 30 Dec 92 14:23:07 GMT
Organization: Army Materiel Systems Analysis Activity

In a previous article, john@timer1.UUCP (john) says:
>
>Our company is looking for a postal zip code database. We are willing
>to pay for a resonable price for it. It will be better if we can
>get updated if any change is made.
>
>Any pointer will be appreciated.
>
>John Chan

  From the regular "SPECIAL INTERNET CONNECTIONS" posting in comp.misc,
I find:

 -Geographic Server     telnet martini.eecs.umich.edu 3000 or 141.212.99.9 3000
   offers: Info by city or area code (Population, Lat./Long., Elevation, etc).

Part of the intro file is reproduced below. 

|NOTE: This server is intended for use with clients which interpret
|the raw protocol.  However, you may also use the server directly
|if you don't have the clients.  There are currently four clients:
|1) A user agent which pretty-prints the raw protocol and optionally
|   computes distance and azimuth between any two cities,
|2) A filter for producing input files for Brian Reid's netmap program,
|3) A US map browser which uses the X Window System,
|3) A prototype X-based network browsing tool.
|
|Data came primarily from the US Geological Survey and the US Postal Service.
|Coverage includes all US cities, counties, and states,
|as well as some US mountains, rivers, lakes, national parks, etc.
|A few international cities have also been included.
|Unfortunately, some minor inaccuracies remain.  Send mail to
|info@comsol.com for information regarding the data.
|
|Interpret server replies as follows:
|
|0 <city name>
|1 <county FIPS code> <county name>
|2 <state/province abbreviation> <state/province name>
|3 <nation abbreviation> <nation name>
|A <telephone area code>
|E <elevation in feet above mean sea level>
|F <feature code> <feature name>
|L <latitude DD MM SS X> <longitude DDD MM SS X>
|P <1980 census population>
|R <remark>
|T <time zone>
|Z <postal ("ZIP") code>
|
|
|Direct questions or comments to Tom Libert, libert@citi.umich.edu,
|or phone (313) 936-0827.  Please let me know if you write new clients.
Newsgroups: comp.databases
Subject: Re: RDBMSes for text management??
From: D.M.Todd@massey.ac.nz (D.M. Todd)
Date: Wed, 30 Dec 92 21:11:06 GMT
Organization: Massey University, Palmerston North, New Zealand
Summary: text management and Advanced Revelation
X-Reader: NETNEWS/PC Version 2c

I'm using Advanced Revelation for an application that has extensive
text.  In fact I chose ARev partly because it would handle text and
most of the other products couldn't.  It doesn't have much built in,
but some utilities are available and the programming language has
good string handling.  I've include routines to do keyword-in-context
listings and searches based on "dictionaries" (lists of words that
refer to a particular concept).
Newsgroups: comp.databases