Ingres DB admin scripts
Daniel Brugger
Are you Ingres DB admin and looking for a more comfortable way to
backup/restore your databases? - Maybe the following could interest you...:
On my previous job I worked for a longer time as Ingres DB admin and there I
wrote several Unix shell scripts to automate DB administration tasks. This
script suite I'd like to make available to the community.
The main scripts are:
dbsave
------
- Full automated backup and maintenance of a whole CA/Ingres installation
with one command
- Relies on Ingres tools ckpdb, optimizedb, sysmod
- Automatic harddisk housekeeping (keeps the last #n checkpoints on your
hard disk but automatically removes older ones)
- Dynamic database list, new databases will be backuped without changing a
setup or anything else
- Monitores all activities into a logfile
- Comes with a well configured cktmpl.def file (uses cpio and file
compression which saves up to 80% space)
- Suited to run from cron
- Watchdog function (optional); alerts if the backup of a database takes
longer than a specified time
- Many commandline options
- Built-in help pages
- Runs in a productive HP-UX 9 environment since about six years
- Unix bourne shell script, 1400 lines
dbrestore
---------
- Interactive script to restore an Ingres DB from a checkpoint
- Maximum of comfort, full menu driven (text panels) with dynamic lists of
DBs, checkpoints and so on
- Relies on rollforwarddb (and in special cases on un-/reloaddb)
- All displays and activities are also logged to a logfile
- Allows (in a clean way) to restore each database from a given checkpoint
in every situation, also for iidbdb and also if the database has been
deleted previously (eg. using deletedb)
- Used in a productive HP UX environment and has been several times helpful
to restore crashed Ingres DBs, also 'iidbdb'
- Unix bourne shell script, 2600 lines, clean programmed, should be easy to
adapt changes
dbreorg
-------
- Interactive script to physically reorganize storage structures of database
tables (btree, hash, isam, heap)
- Menu driven, lets you chose to reorganize a specific table, a whole
database or the whole installation (it would be easy to change the script in
a way that you can run it non-interactively)
- Preserves all table attributes and indexes (keys, min-/max-page, ...)
- Relies mainly on the SQL-scripts generated by copydb, which uses the SQL
statement modifydb
- Unix bourne shell script, 2400 lines, clean programmed
- Tested for CA/OpenIngres 2.x and OpenIngres II on HP/UX
script library
--------------
- Additional base library including many tools and general useful script
functions, also outside from the 'db*'-scripts
- Unix bourne shell scripts, 400 lines
Interested? Reply with an e-mail to Brugge...@hotmail.com
Some points you should know:
- The scripts have been developed and tested on SunSolaris and HP UX with
Ingres 6.4 and 2.x and OpenIngres II
- All interactive panels, comments and messages are written in German
(...sorry, I'm a Swiss guy and originally I didn't intend to spread these
scripts)
- I'll provide them on a "as-they-are" base, no support can be given (if you
have some experience in shell scripting, then it will be easy to make
running them)
- The scripts are free, although if you find them useful, a donation of $20
would be warmly appreciated... :-)
- Commercial re-distribution is not allowed.
Yogesh Gawali
I am taking a shot 23 yrs later to see if you still have those scripts. If yes, can you please share it with me. Thank you.
Roy Hann
> Hi Daniel!!!
> I am taking a shot 23 yrs later to see if you still have those scripts. If yes, can you please share it with me. Thank you.
assistance with running an Ingres installation, my company is an Actian
Partner specializing in Ingres and the Ingres family of products.
roy.hann at rationalcommerce.com