Before we can take scripts, we need you to fill in a waiver so that the
NAIUA are free to publish without danger of being sued for infringement of
intellectual property. Here's what to do...
Report writer to create a rule,
procedure and sql script to create and maintain a history table for an existing
Ingres table. Created script may be edited to modify criteria for the rule
trigger. Rule fires on updates and deletes. Changed/deleted record is stored in
the history table along with the users logon id and date/time stamp of the
change. In the script is reference to entering records into a table
'db_rules'. This is a table we use to track rules placed into the database and
allows a comparison between the system catalogs and this table to determine
whether rules have been inadvertently lost or dropped from the system
Brad Cooper, owns a
software and services company
in Northern Virginia. He has put together a couple of simple IngresII
utilities that he would like to share with the Ingres community.
abf_size.ksh - submitted by Mark Ramsay
Gives the sizes of ABF code on
an installation by calculating the size of the underlying ABF files. Written
for 6.4/06 HP-UX 10.20 Korn Shell Script
add_user.ksh - submitted by Mark Ramsay
Adds an Ingres user to the
installation by interacting with accessdb. Lines 33, 34 & 35 may require
updating depending on the terminal set-up(relies on control characters). HP-UX
10.20 Korn Shell Script
Gives the sizes of all checkpoints on
an installation by calculating the size of the underlying checkpoint files.
Written for 6.4/06, but should work with IngresII and OpenIngres by revoking
line 77 and reinstating line 78. HP-UX 10.20 Korn Shell Script
db_size.ksh - submitted by Mark Ramsay
Gives the sizes of all databases on an
installation by calculating the size of the underlying database files. Written
for 6.4/06, but should work with IngresII and OpenIngres by revoking line 59
and reinstating line 60. HP-UX 10.20 Korn Shell Script
db_status.ksh - submitted by Mark Ramsay
Lists the status of all databases on a
given installation and checks the availability of the dbms servers. Written for
6.4/06. HP-UX 10.20 Korn Shell Script
dmf_trace.ksh - submitted by Mark Ramsay
Writes DMF420 trace point output to a
work directory. HP-UX 10.20 Korn Shell Script
A form base tool to list abf application and open them.
Reports on the users and the amount of time connected to a
APXE.xx files are online versions of Appendix E in the Version
6 ESQL companion guides. There is one APXE file for each ESQL language.
Views and include access and manipulate the bit field in the
Tool to measure the overflow of btree index.
Tool to measure the cache efficiencies.
Submitted by Steve Caswell of The Palmer Group, this tool
provides the queries, Windows4GL scripts, and ReportWriter code accompanying
the presentation, "Exploring The Windows4GL System Catalog Cave of Wonders"
presented at Ingres World '94.
Extension to the system catalog table to provide more
meaningfull info on table. Tools to generate ESQL code base on info in the
A tunable multi-threaded remodify and optimize system that
takes advantage of a multi-processor system and allows the DBA to
remodify/optimize only those tables which have been processed since the last
The Ferret is a tool which can find SQL statements in Report
Writer scripts, embedded SQL/C, database procedures, and ABF/4GL. It produces
six reports, plus an optional seventh. The reports generated are: Where Clause
Summary, Table/Column Cross Reference, Join Column Cross Reference, Optimizer
Input, Error Summary, Warning Summary, and an optional Syntax Error List.
Forcex a process on a VAX.
Tool to produce GBF device driver.
List of helpful hint.
Developed by Gordon Gallagher of King's College London, this
tool provides an Ingres backend procedure which, together with the GSQL system,
allows WWW browsers to interrogate Ingres databases. Useful for any
Ingres-based organizations that wants to permit simple Ingres access from the
Internet via WWW.
Developed by Johan Montald, this tool provides an Ingres
backend procedure which, together with ingperl, allows WWW browsers to
interrogate Ingres databases. Useful for any Ingres-based organizations that
wants to permit simple Ingres access from the Internet via WWW.
Ingperl is/was a extension to the perl language that permit
access to Ingres.
Ingperl has been superseded by DBD::Ingres a perl5 module that allows
access to Ingres databases through the DBI "DataBase Interface"
DBD::Ingres includes an Ingperl module, that enables old Ingperl programmes
to run (nearly) without change.
The DBI interface is described on the site: http://dbi.perl.org/
The documentation can be found at:
The Ingres driver can be found at:
Submitted by Mark Merrit of EDS, this tool displays the
current user sessions in Ingres. It's designed for use in a multi-server
environment, but will work with one server. INGWHO can also be used to remove
sessions from batch/shell procedures. Now works with perl 4 & 5 as well as
Ingres 6.4 and OpenIngres 1.1/04.
IQCL a VAX tool to preprocess, compile and link sources files.
km_express is an Ingres utility that will generate database
rules and procedures to maintain referential integrity for defined sets of
A series of short procedure to list useful info from the
A make like tools for the VAX.
A series of misc. tools for the VAX.
Installed July 11, 1999.
Generates symbolic constants
and structs to use with embedded SQL C programs.
Nuke all the Ingres front-end on a VAX.
Extension to the LSE editor for Ingres 4GL, OSL.
A debugger for ABF.
Some misc. procedures for the VAX.
Tool to measure overflow in a table.
Forms-based tool to manage permits (QUEL) on a database.
Some QUEL macros.
A series of tool that generate info from the system catalog.
This UNIX shell script finds the Ingres DBMS server socket
id's and the associated Process Id (PID). It also identifies the archiver and
This UNIX shell script finds the Ingres shared memory segments
and semaphones. It identifies which segments belong to which installation when
running more than one installation per machine. It is also useful to check that
all segments are cleaned up after a shutdown.
A tool to analyse the info from logstat.
This tool, submitted by Ken Frank, Control Software, Inc.,
provides the "alter table" capability missing in Ingres 6.4.
TBLMNT is a program to simplify making changes to the columns
in an Ingres database table. It supports commands to add new columns, delete
old columns, rename them, resize them, and change null/default attributes.
This tool, submitted by Phillip C. Brisco and NASA, is
primarily useful for adding and removing columns to existing production tables.
Includes a 3GL subroutine that saves data from a table to an SQL script file.
Includes source for VAX C and VAX FORTRAN.
A series of tools to improve user navigation in an ABF
A generic WWW to
SQL-database interface building tool