[Info-ingres] Ingres DB admin scripts

[Yogesh Gawali]

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.

On Friday, 27 October 2000 at 20:43:40 UTC+11, Daniel Brugger wrote:
> 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... at 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.