Login
Register
Actian.comNavigation
Learn About
Developing With
Ingres Talk
Information
Toolbox
Views
Ingres DBA Examples
From Ingres Community Wiki
Jump to: navigation, search
[edit]
Useful DBA Scripts and Standalone Utilities
| 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. |
Retrieved from "http://community.actian.com/wiki/Ingres_DBA_Examples"
