Ingres Tools Archive

Please send all comments and suggestions to:

• If you have MS Word, go to the following link:
  http://www.naiua.org/toolz/toolform.doc
  Complete the Word document and e-mail that and your script(s) back to webmaster@www.naiua.org (the "Authorized Signature" can be ignored in the case of e-mailed documents)
• If you DON'T have MS Word, go to the following link:
  http://www.naiua.org/toolz/toolform.html
  Print off this document and fax or mail as per instructions on printout.

bhs_and_table.rw submitted by Allan Reid

http://www.cooperlogic.com/ingres/IngresUtility.htm

ABSTRACT
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.

abflist

A form base tool to list abf application and open them.

account

Reports on the users and the amount of time connected to a server.

apxe

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.

bit_field

Views and include access and manipulate the bit field in the catalog.

btreeof

Tool to measure the overflow of btree index.

cache

Tool to measure the cache efficiencies.

cave

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.

db_dict

Extension to the system catalog table to provide more meaningfull info on table. Tools to generate ESQL code base on info in the system catalog.

DBHygiene

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 checkpoint.

ferret

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

Forcex a process on a VAX.

gbf_device

Tool to produce GBF device driver.

helpfull_hint

List of helpful hint.

ing-www-gsql

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.

ing-www-perl

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 superseeded by DBD::Ingres a perl5 module that allows
access to Ingres databases through the DBI "DataBase Interface" layer.
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: http://search.cpan.org/search?dist=DBI
The Ingres driver can be found at:
http://search.cpan.org/search?dist=DBD-Ingres

ingwho

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

IQCL a VAX tool to preprocess, compile and link sources files.

km_express

km_express is an Ingres utility that will generate database rules and procedures to maintain referential integrity for defined sets of Tables.

list_tool

A series of short procedure to list useful info from the system catalog.

make

A make like tools for the VAX.

misc

A series of misc. tools for the VAX.

mydclgen

Installed July 11, 1999. Generates symbolic constants and structs to use with embedded SQL C programs.

nuke

Nuke all the Ingres front-end on a VAX.

osl-lse

Extension to the LSE editor for Ingres 4GL, OSL.

osq-debug

A debugger for ABF.

other

Some misc. procedures for the VAX.

overflow

Tool to measure overflow in a table.

permit

Forms-based tool to manage permits (QUEL) on a database.

quel_macro

Some QUEL macros.

relstat

A series of tool that generate info from the system catalog.

servers

This UNIX shell script finds the Ingres DBMS server socket id's and the associated Process Id (PID). It also identifies the archiver and recovery processes.

showmem

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.

stats

A tool to analyse the info from logstat.

tblmnt

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.

tblscrpt

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.

vfs

A series of tools to improve user navigation in an ABF application.

http://www.ri.bbsrc.ac.uk/webintool.html