[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ulysse::rdb_vms_competition

Title:DEC Rdb against the World
Moderator:HERON::GODFRIND
Created:Fri Jun 12 1987
Last Modified:Thu Feb 23 1995
Last Successful Update:Fri Jun 06 1997
Number of topics:1348
Total number of notes:5438

7.0. "Some INGRES technical notes" by MINDER::PICKERING () Fri Jun 12 1987 19:19

    I have some INGRES technical notes available. I will make them
    available to anyone who mails me. The notes are listed below:

    			  INGRES Technical Notes		     
			  ======================


#  Status  	      Name					File	
-------------------------------------------------------------------------

1   N	VMS System Parameters and Page Level Locking		note001.vms
2   N	Running INGRES on VMS 4.0				note002.vms
3   C	"Repeated" EQUEL Queries 				note003.all
4   C	User-Specified Query Processing Plans			note004.all
5   C	How to Add a New Device and Move Existing DB's to it	note005.vms
6   C	How to Cluster Your INGRES Databases			note006.vms
7   C	How INGRES Uses the "Users" File and Table		note007.vms
7   C	How INGRES Uses the "Users" File and Table		note007.unx
8   C   A Debugging Trace Flag for EQUEL Programs		note008.vms
8   C   A Debugging Trace Flag for EQUEL Programs		note008.unx
9   C	A Way to Specify Temporary Sort File Locations		note009.vms
9   C	A Way to Specify Temporary Sort File Locations		note009.unx
10  C	How to Add or Rename a Column in an Existing Table	note010.all
11  N	Temporary Files Used by Ingres				note011.vms
11  N	Temporary Files Used by Ingres				note011.unx
12  C	Btree versus Isam as storage structures			note012.all
13  C	The Use and Misuse of Compression 			note013.all
14  C	Complex 'OR'ed queries in INGRES			note014.all
15  C	Measuring the Overflow in Tables			note015.all
16  C	The Use of "set lockmode readlock=nolock"		note016.all
17  C	TIDS: what they are and when to use them		note017.all
18  C	Changing Ownership of Forms	 			note018.vms
18  C	Changing Ownership of Forms	 			note018.unx
19  C	How to add or change your C compiler for ABF/OSL	note019.vms
20  C   How to Change Ownership of a Database			note020.vms
20  C   How to Change Ownership of a Database			note020.unx
21  C   INGRES Process Names				        note21.vms
22  C   A Command Procedure to List Backends and Their Owners   note22.vms
23  C   INGRES Detached Processes and VMS Quotas		note023.vms
24  C   Changing Ownership of a Table				note024.vms
24  C   Changing Ownership of a Table				note024.unx
25  C   Changing Ownership of a Report				note025.all
26  C   The Ingres Permit Command				note026.all
27  C   How to Replace A Single Table from Backup		note027.vms
27  C   How to Replace A Single Table from Backup		note027.unx
28  C   How to Read QEP's					note028.all
29  C   Aggregates - Part 1					note029.all
30  C   Aggregates - Part 2					note030.all
                                                                          
    31  C   The INGRES Locking System				note031.vms
    31  C   The INGRES Locking System				note031.unx
32  C   Overflow Distribution					note032.all
33  C   Heaps and Secondary Indexes				note033.all
34  C   EQUEL Tablefield Row States				note034.all
35  C   Assigning Unique Numbers				note035.all
36  C   Collision Detection on Updates to a Single Record	note036.all
37  C   Views: Precautions and Update Rules			note037.all
38  C   Improving Concurrent User Performance, Part 1		note038.all
39  C   INGRES Rowcounts				  	note039.all
40  C	Aggregates - Part 3: Performance			note040.all
41  C	References on Database Design			        note41.all
42  C	VMS Process Scheduler States				note042.vms
43  C	How to Rename a Database			 	note043.vms
43  C	How to Rename a Database				note043.unx
44  C	The Correct Use of the COPYAPP Utility			note044.vms
45  C	Checkpointing a Database from a Command Procedure	note045.vms
46  C   Inconsistent Databases: Causes and Cures		note046.vms
47  C   Measuring Query Performance				note047.all
48  C   Virtual Memory Usage in INGRES/CMS			note048.cms
49  C   Improving Concurrent User Performance: Part 2		note049.all
50  C   Key Duplicity						note050.all
51  C	Returning To The Top Frame Of An ABF Application	note051.all
52  C   OSL and Base Registers in CMS 3.0 and Above		note052.cms
53  C	Locking and INGRES Installation Configurations 		note053.vms
	on VAXclusters
54  C   Floating Point Numbers					note054.all
55  C   Measuring and Controlling File Fragmentation		note055.vms
56  C   Using Optimizedb 					note056.all
57  C   Suggestions for configuring a trouble free INGRES 	note057.vms
	Installation
58  C   Running Reports from OSL				note058.vms
58  C	Running Reports from OSL				note058.unx
59  C   BTREE Implementation in INGRES				note059.all
60  C   VMS Performance Checklist  				note060.vms
60  C   Unix Performance Checklist				note060.unx
61  C   Annotated VMS Sysgen Parameters  			note061.vms
62  C   Changing the Display Mode of a Form in an ABF frame	note062.all
63  C   Runtime Error Processing in ABF Applications		note063.all
64  C   Porting INGRES Applications from VMS to CMS		note064.cms
65  C	Checkpointing Databases in UNIX Installations		note065.unx
66  C	Copying a Database from one INGRES Installation
				to another			note066.unx
67  C	Switching Forms On and Off in UNIX Installations	note067.unx
68  C	INGRES Startup Errors					note068.vms
69  C	INGRES Validation Checks				note069.all
70  C	Report Writer Techniques				note070.all
71  C	The Concept of Data Clustering				note071.all
72  C	Diagnosing Database I/O (DI) Errors			note072.vms
73  C	ABF Forms: Scoping Rules and Storage Classes		note073.all
74  C	How to Change Ownership of an INGRES Installation	note074.all
    75  C   Using UNIX signals with INGRES				note075.unx
STATUS CODES:	

C	-  CURRENT - this note is valid for current INGRES release.
N	-  NOT CURRENT - this note should be deleted, it is no longer valid.

FILE EXTENSIONS:

.all	-  Available in all environments
.vms	-  Available only for VMS environments
.unx	-  Available only for UNIX environments
.cms	-  Available only for CMS environments
    
T.RTitleUserPersonal
Name
DateLines
7.1We have the technology....NACOFF::PICKERINGMon Sep 21 1987 15:3714
    I will probably regret saying this..!
    
    I have Ingres V5.0/03 (vax.vms/06) loaded on a machine here. I also
    have a set of the documentation (except for pre-compilers other
    than C).
    
    I am prepared to (try to) answer questions for you provided that
    	 - questions not too involved
         - I have time!
         - you don't blame me if I get it wrong!
    	 - you accept my Ingres knowledge is very,very limited 
         
    I will add info to this base note on items I think may be of general
    interest anyway.