| DBA Script
| Description
|
| Utility to check status of Ingres Servers on Windows
| ingstatus is a utility found on the Linux and UNIX platforms that gives an indication of the servers that are running in the instance.
|
| Dynamic Playback
| Ingres Load testing tool which uses the output from SC930 trace to feed back into an Ingres database reproducing almost equivalent load.
|
| Changing table structures
| A python script to generate an terminal monitor script to drop primary key constraints and create them as btree with base table structure.
|
| Collecting Ingres QEP and LockTrace Information Using JDBC
| Illustrates how to get Ingres Query execution plan, lock_trace etc using Ingres SET statements from a Java application
|
| Summarise output of auditdb - Unix shell script
| This script strips out extra verbosity from the auditdb output
|
| Removing Ingres Sessions Using IMA
| Below is an IMA script which removes all sessions connected to an Ingres installation. This is useful to run before shutting down Ingres for example. It uses the procedure ima_remove_session which should already be defined in imadb. In order to run it successfully it should be run by a user with Security Administrator privilege. It creates a temporary file so you should also run it from a directory where you can create files.
|
| Full SQL Query Tool
| This example is a complete application for executing arbitary SQL statements. It demonstrates dynamic cursors, query analysis, error handling, and dynamic data type handling.
|
| SQL Lock Monitor Tool
| This example is a complete application for monitoring locks. It demonstrates the use of embedded SQL to query the imadb and continuously display results.
|
| IngresErrlogAnalysis
| This script will give you date, dow, timeofday and month analysis of every message type and a few specialized analyses (eg tables, page, session, etc analysis for deadlocks and similar messages). Best to copy the errlog and run the script on a non-Production machine.
|
| SQLScriptsforUnix
| This document describes basic techniques for executing SQL from Unix/Linux shell scripts using the Ingres line-mode terminal monitor.
|
| CatchBigFiles
| This script will detect big files in the Ingres work directory and for each detection will record information.
|
| Show sessions
| Unix and DOS scripts to provide a quick formatted summary of output from iimonitor
|
| Find Foreign Keys
| ESQLC program to help uncover possible foreign keys in large schemas.
|
| Another Terminal Monitor
| Different implementation for the Ingres Terminal Monitor.
|
| Create quick temp table in Ingres
| Script to create quick temp table in Ingres and load it with N rows for some generic testing/development.
|
| Create variable temp table in Ingres
| Script to create temp table in Ingres with N+1 varchar(8) columns and load it with N rows for some generic testing/development.
|
Login
Register
Actian.com
