Hi there
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.
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.
Yogesh Gawali wrote:
Hi Daniel!!!If it turns out you get no response to this query, and if you need any assistance with running an Ingres installation, my company is an Actian Partner specializing in Ingres and the Ingres family of products.
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 at rationalcommerce.com
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 418 |
Nodes: | 16 (2 / 14) |
Uptime: | 22:25:55 |
Calls: | 8,766 |
Calls today: | 9 |
Files: | 13,287 |
D/L today: |
3 files (1,633K bytes) |
Messages: | 5,964,750 |