| alarm |
Monitors warnings, errors, and online status of databases [DBA, PERL] |
Download |
View |
| alarm_space |
Specialized versions of the Informix alarm and evidence shell scripts, plus a script that warns if dbspace is running low, plus 4 other admin scripts [DBA, KSH] |
Download |
Info |
| analyse_idx |
Interactive program that gives information on indexes [DBA, I4GL] |
Download |
View |
| arch2disk |
Archives an OnLine database to disk [DBA, SH] |
Download |
View |
| arch_hp_tape |
Archives an OnLine database to an HP shuttle tape drive [DBA, SH] |
Download |
View |
| auto_ontape |
Runs ontape unattended for multi-tape backup [DBA, SH] |
Download |
View |
| bloqueos |
script for view and kill users using a table [AWK, DBA, SQL] |
Download |
Info |
| chkinstall |
Checks for and optionally fixes Informix installation errors [AWK, DBA, SH] |
Download |
View |
| chklock-1.2 |
Reports locks on an SE database [C, DBA] |
Download |
Info |
| ckfls |
Reports files in $INFORMIXDIR with incorrect permissions [DBA, SH] |
Download |
View |
| cmp_row |
Checks the consistency of rows in an Informix Enterprise Replication configuration [DBA, ESQLC] |
Download |
Info |
| copy_spaces |
Converts onstat -d commands into onspaces commands [DBA, SH] |
Download |
View |
| db_ontape |
Runs ontape [DBA, PERL, SH] |
Download |
View |
| dbalter |
Alters one database to be like another [DBA, ISQLPERL] |
Download |
View |
| dbamenu |
Menu-driven DBA utility script [AWK, DBA, KSH] |
Download |
View |
| dbamon |
Monitors OnLine engine performance [DBA, SH] |
Download |
View |
| dbdiff2 |
Generates SQL that alters one database to be like another. UPDATED! Contains a new version created by David Williams. [DBA, I4GL] |
Download |
View |
| dbinfo_lk |
Displays INFO statement output [AWK, DBA, SQL] |
Download |
View |
| dbldfmt |
Converts a fixed-field-length file to LOAD format [C, DBA, MISC] |
Download |
View |
| dbmon_pm |
Database monitoring utility scripts [AWK, DBA, SH] |
Download |
View |
| dbping |
Simple timing to see if your database connection is up [AWK, DBA, MISC, SH] |
Download |
View |
| dbps |
merges the output of onstat -g ses with ps -f (ie not Berkeley) [DBA, PERL] |
Download |
Info |
| dbref |
Analyzes referential integrity & builds (un)load scripts [DBA, I4GL] |
Download |
View |
| dbsh |
Splits dbschema output into a set of files [AWK, DBA, SH] |
Download |
View |
| dbspace_pages |
Reports unused space in all dbspaces [DBA, SH, SQL] |
Download |
View |
| dbspace_space |
Reports unused space in all dbspaces [DBA, SH, SQL] |
Download |
View |
| dbtop |
Quick real-time resource monitor for Informix database servers, similar to the Unix 'top' command. [DBA, PERL] |
Download |
Info |
| dbweb-1.0.3 |
Web based database interrogator and remote monitor [C, DBA, ESQLC, MISC] |
Download |
Info |
| ddhash_stats |
Calculate DD_HASHSIZE and DD_HASHMAX [C, DBA] |
Download |
Info |
| defrag_table |
Defragments tables [DBA, PERL, SQL] |
Download |
View |
| deinstall |
Uninstalls and removes Informix software products [AWK, DBA, SH] |
Download |
View |
| disk_struct |
Displays the disk structure for the current instance [DBA, I4GL, SH] |
Download |
View |
| dm |
Shows summary of output from various onstat commands [DBA, ESQLC] |
Download |
View |
| dup-auth |
Generates SQL to grant or revoke existing table and column privileges [DBA, KSH, SQL] |
Download |
View |
| dup_spaces |
Produces onspaces commands to replicate dbspaces, chunks, temp spaces and blob spaces [AWK, DBA, KSH] |
Download |
View |
| entropymap |
Dirty bit of 4GL to display extent entropy in a dbspace as html [DBA, I4GL, MISC] |
Download |
Info |
| errmsgtbl |
Creates a database table of Informix error messages [AWK, DBA, MISC, SH] |
Download |
View |
| extent_report |
Reports extent size and usage info [DBA, PERL] |
Download |
View |
| extentsize |
Calculates extent sizing for a table [DBA, SH] |
Download |
View |
| find_tmp_tbls |
Lists temp tables per session in an instance using onstat [AWK, DBA, KSH, MISC] |
Download |
Info |
| format_ps |
Formats the output of ps -el, shows in a tree-like format who started what - oninit processes are shown as owning shm segments (IDS not XPS) [C, DBA, MISC] |
Download |
View |
| fragments.shar |
Details on every tablespace (including fragments ) on a server [AWK, DBA, KSH, MISC] |
Download |
Info |
| idbb |
Automatic Informix database back-up utility [DBA, SH] |
Download |
View |
| idstools |
A collection of numerous tools for I4GL and ESQL/C development, and database administration of IDS [AWK, C, DBA, ESQLC, I4GL, MISC, SH] |
Download |
Info |
| ifmx_user |
Counts the number of concurrent Informix users (sessions) [DBA, ESQLC, MISC] |
Download |
Info |
| infmx2html |
Creates Web pages describing one or more databases [DBA, I4GL] |
Download |
View |
| infotable |
Gives comprehensive information about a table similar to Oracle's "describe" command [DBA, ESQLC, MISC] |
Download |
Info |
| isextract |
Unloads data from C-ISAM files [C, DBA, ESQLC, MISC] |
Download |
Info |
| JLoader |
load / unload via jdbc, BLOB handling incomplete [DBA, JAVA] |
Download |
Info |
| killidle |
Monitors and kills idle processes [AWK, DBA, MISC] |
Download |
View |
| linkpath |
LINKPATH is a program that lets you check the security of the path leading to $INFORMIXDIR, or indeed for any file or directory. [C, DBA] |
Download |
Info |
| listtabchunk |
a tool which will print all tables/indexes residing in a chunk [DBA, ESQLC] |
Download |
Info |
| lockrep |
Reports tables locked by users [AWK, DBA, MISC, SH] |
Download |
View |
| lockwt |
Reports user sessions holding locks and any sessions waiting for those locks to be released [DBA, ESQLC] |
Download |
Info |
| logcheck |
Reads log numbers from logical log tapes [AWK, DBA, SH] |
Download |
View |
| logs |
Real-time HDR replication monitor for Informix database servers. [DBA, PERL] |
Download |
Info |
| long2time |
Converts an ER timestamp into display format [C, DBA, MISC] |
Download |
View |
| lwt_install |
Windows embedability tool to deploy pre-configured IDS instances [C, DBA, MISC] |
Download |
Info |
| master_event.plx |
This program will monitor all event's reported by the Informix Engine. [DBA, PERL] |
Download |
View |
| maxextents |
Determines total number of extents for a table [C, DBA, JAVA] |
Download |
View |
| mbp_ontape |
Utilities for unattended backup of database and logs to disk [DBA, KSH, SH] |
Download |
View |
| misql |
Alternative to isql/dbaccess, including simple forms [DBA, I4GL, ISQL, MISC] |
Download |
View |
| mkupdstats |
SQL script that generates recommended UPDATE STATISTICS commands [DBA, SQL] |
Download |
View |
| mon_buffer |
Reports buffer utilization [AWK, DBA, KSH] |
Download |
View |
| monitor |
Database that holds historical and performance data on all tables [DBA, KSH, SQL] |
Download |
Info |
| monitor_space |
Monitors dbspaces for level of fullness [AWK, DBA, SH] |
Download |
View |
| movetab |
Allows moving tables between Informix instances without having to turn off logging [DBA, ESQLC, MISC] |
Download |
Info |
| myexport |
Replacements for dbexport and dbimport [AWK, DBA, KSH, MISC] |
Download |
Info |
| myonpload |
Command line interface to onpload like sqlunload and sqlreload [DBA, ESQLC, MISC, SQL] |
Download |
Info |
| on_to_unload |
Reads arcunload or single-table onunload output [AWK, C, DBA] |
Download |
View |
| ondd.ksh |
This script provides serial or parallel data streams in conjunction with the HPL to move data between versions 7, 8, and 9 instances. [DBA, KSH, LSDW] |
Download |
Info |
| onlsize |
Reports sizes of OnLine databases [DBA, PERL] |
Download |
View |
| onprocs |
Shows which stored procedures are being executed [AWK, DBA, MISC, SH] |
Download |
View |
| onstat_rau_ur |
Computes read ahead utilization and bufwait ratios from onstat -p [AWK, DBA] |
Download |
View |
| onsts |
Display sql for active sessions [DBA, PERL] |
Download |
Info |
| onweb_10uc1_aix |
The 1.0 UC1 release of OnWeb in compressed TAR format for AIX [DBA, PERL, SQL] |
Download |
Info |
| onweb_10uc1_dec |
The 1.0 UC1 release of OnWeb in compressed TAR format for DIGITAL UNIX [DBA, PERL, SQL] |
Download |
Info |
| onweb_10uc1_hp |
The 1.0 UC1 release of OnWeb in compressed TAR format for HP-UX [DBA, PERL, SQL] |
Download |
Info |
| onweb_10uc1_lin |
The 1.0 UC1 release of OnWeb in compressed TAR format for LINUX [DBA, PERL, SQL] |
Download |
Info |
| onweb_10uc1_sol |
The 1.0 UC1 release of OnWeb in compressed TAR format for SOLARIS [DBA, PERL, SQL] |
Download |
Info |
| orclproc |
Oracle function equivalents as stored procedures [DBA, ISQL, SPL] |
Download |
View |
| partitions |
Lists table info like extents and pages in partitions [AWK, DBA, KSH, SQL] |
Download |
View |
| pgdump |
Displays pages of an OnLine database [C, DBA, MISC] |
Download |
View |
| pres_ext |
Creates SQL script to preserve OnLine extents [DBA, SH] |
Download |
View |
| privproc |
Reports privileges for Stored Procedures [ACE, DBA, ISQL] |
Download |
View |
| ratios |
Calculates Read-ahead utilization, Bufwaits and Buffer Turnover ratios [DBA, PERL] |
Download |
View |
| rehex |
Reformats hexadecimal numbers from onstat commands. [C, DBA] |
Download |
Info |
| reorg_pl |
Reorganizes an entire database or single table [DBA, PERL] |
Download |
View |
| rix-0.4 |
This is a program that allows you to run the onstats against remote hosts, or, if you run multiple instances on one machine, then is sorts your environment. [C, DBA] |
Download |
Info |
| save_idx |
Saves and recreate indexes [AWK, DBA, SH] |
Download |
View |
| schemadiff |
Compares 2 schemas, described in _Tech_Notes_ v5,i3 [C, DBA] |
Download |
View |
| seqscan |
Monitors sequential scans using "onstat -g ppf" [AWK, DBA, SH, SQL] |
Download |
View |
| set_index |
This script sets the object mode of contraints and indexes on a table(s) either ENABLED or DISABLED. [DBA, KSH] |
Download |
Info |
| setixd |
Tools for Working with Multiple INFORMIXDIRs [C, DBA, SH, SQL] |
Download |
Info |
| size9 |
Script to size databases, esp v9 [DBA, SPL, SQL] |
Download |
Info |
| space_usage |
Reports table space usage in an OnLine database [C, DBA, I4GL] |
Download |
View |
| spsl |
Stored procedure that shows who owns locks on a table [DBA, SPL] |
Download |
View |
| sqlrun32 |
Win32 executable to process SQL on a remote Informix server [DBA, ISQL] |
Download |
Info |
| sqsl |
Structured Query Scripting Languge Tool [BISON, DBA, ESQLC, MISC, SQL, YACC] |
Download |
Info |
| su_ontape |
Does an su to user "informix", then runs ontape [C, DBA] |
Download |
View |
| sysmast_sql |
SQL scripts to be used with the sysmaster database [DBA, ISQL, SQL] |
Download |
View |
| tab_col_frm |
Table/column information screen file [DBA, SPERFORM] |
Download |
View |
| table-iostats |
Displays I/O counts for each tblspace [AWK, DBA, SH, SQL] |
Download |
View |
| tbheader |
Prints header information from an Informix back-up tape [C, DBA] |
Download |
View |
| tbrpt |
Combines several tbstat options into one report [AWK, DBA, SH, SQL] |
Download |
View |
| temptab |
Generates information about temporary tables [DBA, I4GL] |
Download |
View |
| temptab.pl |
A perl version of temptab [DBA, PERL] |
Download |
Info |
| topdb |
Monitors database activity using onstat similar to Unix top command [AWK, DBA, SH, SQL] |
Download |
View |
| trigger |
Attaches to the end of a file and spawns processes whenever a key string is added [C, DBA, MISC] |
Download |
View |
| trigger_test |
Tests triggers and stored procedures from I4GL [DBA, I4GL, MISC, SQL] |
Download |
View |
| tx_split |
Splits SQL update/delete statements into smaller transaction groups to avoid lock table overflows and long transaction problems [DBA, ESQLC, MISC, SQL] |
Download |
Info |
| unused_space |
Reports remaining space in currently used volumes [AWK, DBA, SH] |
Download |
View |
| upd_stats |
Collection of utilities that generate optimal update statistics statements and perform other Informix and Unix functions [DBA, PERL] |
Download |
Info |
| upd_stats_rt |
Generate and perform UPDATE STATISTICS on Informix tables [DBA, PERL] |
Download |
Info |
| uque |
Identifies who's locked on what and what it is that is locked [DBA, ESQLC, MISC] |
Download |
View |
| utils_ak |
Database administration scripts and programs [AWK, DBA, ESQLC, SH] |
Download |
View |
| utils2_ak |
Database administration programs and utilities [DBA, ESQLC] |
Download |
Info |
| utils3_ak |
Event alarm handler program and script [C, DBA, KSH] |
Download |
View |
| utils4_ak |
Scripts to process dbschema or myschema (utils2_ak) output [AWK, DBA] |
Download |
View |
| utils_jl |
Database administration utility package [C, DBA, SH] |
Download |
View |
| utils_sp |
Database administration scripts and programs [C, DBA, I4GL, PERL] |
Download |
View |
| who_access |
Determines who is accessing or locking a table [AWK, DBA, KSH, SQL] |
Download |
View |
| xtbload |
X application that displays OnLine status similar to xload [C, DBA] |
Download |
View |
This section contains links to other sources for software. To
be listed in this section, software must be of broad applicability
in an Informix enviroment, such as database development and
management utilities or general purpose end-user tools. It must
also be open source or freeware, or must have a free demo or
evaluation version available.
