No description, website, or topics provided.
Shell PHP Awk Assembly
Fetching latest commit…
Cannot retrieve the latest commit at this time.

README.md

InformixScripts

A repository of Informix utility scripts by Fernando Nunes (domusonline@gmail.com) If you're interested in Informix the author would also recommend his blog at:

http://informix-technology.blogspot.com

Introdution

The documentation is the weakest part of this repository. For now I'mjust including a very brief description of the structure and contents of the repository.

Distribution and license

These repository uses GPL V2 (unless stated in a specific script or folder). In short terms it means you can use the contents freely. If you change them and distribute the results, you must also make the "code" available (with the current contents this is redundant as the script is the code)- The full license text can be read here:

http://www.gnu.org/licenses/old-licenses/gpl-2.0.html

Disclaimer

These scripts are provided AS IS. No guaranties of any sort are provided. Use at your own risk
None of the scripts should do any harm to your instances or your data. The worst they could do is to provide some misleading information. However, bad configuration or any unkown bug for example in the environment configuration script (setinfx) could cause some confusion and put you in a situation where you could be adminisering the wrong instance. Please test the scripts in non critical environments before you put them into production

Support

As stated in the disclaimer section above, the scripts are provided AS IS. The author will not guarantee any sort of support.

Nevertheless the author is insterested in improving these scripts. if you find a bug or have some special need please contact the author and provide information that can help him fix the bug ordecide if the feature is relevant and can be added in a future version

Structure

OAT_plugins

Plugins for the Open Admin Tool. Currently the only plugin present is ixlocks, a plugin that will show your instance locks with a few options (by table, session etc.)

queries

This contains handy queries. Currently only one is present but more will be added in the future

scripts

This is currently the main part of the repository. Most scripts provide a -h option that will show the script usage and syntax. It contains four folders:

  • alarmprogram
    A replacement script for the standard alarmprogram.sh that is shipped with the engine

  • setinfx
    A script to position environment variables for different instances and present a selection menu based on a config file

  • ix

    • ixcaches
      This will generate oversized parameters for PC_, DD_ and DS_ parameters

    • ixlocks
      Show current locks

    • ixproclog
      Monitors your online.log and reacts to different entries. Must be used with a few associated files

    • ixprofiling
      Shows detailed statistcs for the execution of one or more queries. The comparison and the results should provide good guidance aboutthe best query plan

    • ixrunalldbs
      Runs a script in all the instance's non-system databases

    • ixseqscans
      Shows tables with sequential scans

    • ixses
      onstat -g ses replacement with much more information in a single output (merges information form several onstat commands and some system views

    • ixtableuse
      shows who's locking a table or preventing an ALTER TABLE

    • ixtop
      Shows the top sessions or table/partitions based on some specified criteria. By default shows top CPU consumption threads, but much more options are available

    • ixvirtdir
      Creates a new "INFORMIXDIR" based on an existing product installation. Some sub-directories are duplicated (like etc/, dbssodir/, aaodir/) to allow better granularity for role-separation and different configurations (although currently most of the files are instance indepedent when an INFORMIXDIR is shared across instances)

    There are a few other but they'r not as stable/tested/useful as the above ones

  • updstats
    Scripts to run statistics on a table or database level with several options.