International Informix Users Group

	Informix News

29 April 08 - IntelligentEnterprise.com - IBM Informix Upgrade Enhances Clustering, Database Management... Read 29 April 08 - itweek.com - IBM 'Cheetah 2' mauls data costs... Read 28 April 08 - eWeek.com - IBM Uncages Cheetah 2 Data Server... Read 28 April 08 - CNNMoney.com - IBM Helps Clients Reduce Data Management Costs With New Informix Dynamic Server... Read 09 April 08 - CNNMoney.com - MediaSpan Embeds IBM Informix Dynamic Server Software for Delivering News to Print, Web and Wireless Devices... Read 08 April 08 - IT-Director.com - Informix seeks developers... Read 18 February 08 - marketwire.com - Icarus Studios Partners With IBM to Upgrade Performance, Availability for Its Online Games... Read 17 January 08 - eWeek.com - IBM Adds Mac Support to IDS for Higher Education... Read 17 January 08 - informationweek.com - Lotus Notes For iPhone Signals Closer Ties Between IBM, Apple... Read 16 January 08 - marketwire.com - IBM Informix Dynamic Server to Deliver Support for Mac OS X... Read 16 January 08 - internetnews.com - IBM's IDS to Support Mac Platform... Read 28 June 07 - REG Developer - IBM and Informix tie down Cheetah... Read 27 June 07 - CBRonline.com - IBM corrects its own Informix customer figures... Read 14 June 07 - vnunet.com - IBM changes spots with Informix 'Cheetah' database... Read 14 June 07 - eChannelLine - IBM expands scope for IDS... Read 14 June 07 - Resellernews - IBM: Informix database alive and kicking... Read 13 June 07 - DB2 Magazine - Cheetah is now out of the gate... Read 12 June 07 - IBM - IDS 11 release announcement (pdf)... Read 12 June 07 - ChannelWeb Network - IBM Uncages IDS 11, Aka Cheetah, Database... Read 12 June 07 - eWeek.com - IBM's 'Cheetah' Ready to Pounce... Read 12 June 07 - InformationWeek - IBM Unleashes 'Cheetah' Database... Read 12 June 07 - WebWire - IBM Strengthens Database Portfolio With New Informix Dynamic Server... Read 12 June 07 - Intelligent Enterprise - IBM Unveils Informix Upgrade... Read 12 June 07 - ComputerWeekly.com - IBM's Cheetah IDS makes leap to better data centre clustering... Read 12 June 07 - ebiz - IBM Unveils Next Generation Informix Dynamic Server... Read 12 June 07 - computerworld.com - Will 'Cheetah' help IBM's Informix chase down market share?... Read 12 June 07 - Internetnews.com - No Data Can Outrun This 'Cheetah'... Read 12 June 07 - de.internet.com - IBM neuer Datenbank-Server mit Codenamen Cheetah ist fertig... Read 12 June 07 - verifox.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read 12 June 07 - golem.de - Informix 11 vorgestellt... Read 12 June 07 - Computerwoche.de - IBM stellt neue Informix-Version vor... Read 12 June 07 - IBM.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read 12 June 07 - Heise - IBM gibt Informix 11 frei... Read 25 May 07 - Taiwan.CNET.com - Local Taiwan Informix user group established... (Chinese language) ... Read 18 May 07 - ChannelWeb Network - IBM Musters Partners For Cheetah Release... Read 18 May 07 - eWeek.com - IBM Looks to 'Cheetah' to Speed Up Blade Servers... Read 7 May 07 - DB2 Magazine - SQL Shortcuts - Use these tricks to generate IDS SQL scripts... Read Previous news items

Home Member Area About IIUG



	About the Software Repository



	Repository Index



	Repository Search



	Repository Upload

Software Repository News

Recent New Submissions and Updates

utils2_ak	New release of utils2_ak News Announcement: This update to utils2_ak: - Fixes a bug in the last release of dostats affecting SET LOCK MODE and the new -w option. - New dostats option, -n errlimit, to ignore the first errlimit errors. Thanks to Colin.Dawson for the suggestion. - myschema now prints out ALTER ROUTINE statements altering routine modifier attributes Updated by: Art Kagel 2008-06-13
sqlcmd-85.00	New release of sqlcmd An update to SQLCMD with support for CSDK 3.00.xC3 and with a new feature, the ability to simulate dbaccess or isql in scripts. Updated by: Jonathan Leffler 2008-05-11
entropymap	New release of entropymap Further to a post I made on cdi, I was playing with 4GL to produce an "entropy map" showing how extents are distributed in a dbspace, similar to the Windows "defrag" status screen. Have a play! Updated by: Malcolm Perrior 2008-03-11
sqlcmd-84.00	New release of sqlcmd News Announcement: SQLCMD version 84.00 is a feature release, with support for the new BIGINT and BIGSERIAL types that are available with CSDK 3.50 and IDS 11.50. The code has also been cleaned up so it once more compiles with ESQL/C 5.20. Additional changes include reporting inserted serial number values after an insert operation in verbose mode, and right-justifying INT8 (and BIGINT) values when formatted in one of the fixed format modes. Updated by: Jonathan Leffler 2008-03-09
ddhash_stats	New contribution! Prints out statistics to help calculate 'good' values for DD_HASHSIZE and DD_HASHMAX. Submited by: Richard Harnden 2007-12-10
load2	New release of load2 Support for 64-bit systems. Smart blob handling. Precompiled binaries for some systems. In September my company have migrated from 7.31 on SCO to 10.0 on AIX. Therefore I've made changes necessary to compile it on a new platform. In particular changes for 64-bit platform were introduced. I've added also smart blobs support as we intend to use it in near future. SCO platform soon will not be available for me so I've tested on SCO for the last time. Other changes: unloadx can produce XMLSchema (MS dialect) and xsl for transforming xml file back into unload format. Precompiled binaries for Linux, Windows, AIX & SCO are available at http://robsosno.googlepages.com/downloads Updated by: Robert Sosnowski 2007-12-04
utils2_ak	New release of utils2_ak Contains the following changes: drive_dostats: Improved portability dostats.ec: Improved support for IDS 11.10 Cheetah New option -w to permit controlling WAIT MODE dbcopy.ec: Supports wider tables. Fixed compiling with ESQL/C versions earlier than 3.00. Updated by: Art Kagel 2007-10-26
bloqueos	New Submission! script for view and kill users using a table Updated by: Leon Lejtman 2007-06-25
meta_qa	New Submission! A generic untility for detecting differences between a data source and data in an informix database Updated by: Mark Bessans 2007-06-01
utils2_ak	New release of utils2_ak Features in utils2_ak June 1, 2007 release: Dostats: Fixed a cosmetic typo which may cause confusion. Dbcopy: Expanded -p option increases users control over PDQPRIORITY. Wait mode (-w) support fixed to NOT WAIT when -w0 is passed. New option -I adds support for IDS 11.10 COMMITTED READ LAST COMMITTED isolation level. Myschema: Added support for IDS 10.00+ fragmentation using named partitions which allows more than one fragment of a single object to reside in a single dbspace. Added new option --simple-fragments which mimics dbschema in not naming partitions which have been given implicit names. Updated by: Art Kagel 2007-06-01
logs	New Submission! Real-time HDR replication monitor for Informix database servers. Works by executing the onstat -g dri command to determine the primary and secondary server names, then using onstat -l to check for the current logical log number and position on each (using rsh to run that command on whichever is the remote server). Continually displays the log numbers and positions, moving down a line each time the "number of logs behind" changes. Here is an example of the output: logs: primary=finp1n, secondary=fins1n logs: behind 0 log(s) at Sun May 20 09:47:12 EDT 2007: primary=530657, secondary=530657 logs: primary=530657 (39.72%), secondary=530657 (39.64%) Updated by: Chris Kelch 2007-05-20
dbtop	New Submission! Answer the question, "Who's hogging my database CPU?" Quick real-time resource monitor for Informix database servers, similar in presentation and operation to the Unix 'top' command. Tested with IDS 10.00.FC6 and perl v5.8.2 on AIX 5.3. This is the little utility I discussed with some of you at the IIUG conference in San Jose. It monitors CPU usage of all active sessions in real time by repeatedly issuing onstat -g act in a tight loop. It looks nicest if you have the perl (CPAN) Curses module installed, but works fine without it. Please email me if you run into problems or want anything added. I hope this helps you out! It has helped us here quite often. Updated by: Chris Kelch 2007-05-18
sqlcmd-81.03	New release of sqlcmd This is a bug fix release compared with v81.01 with nothing in the way of new features in SQLCMD itself. The changes are in the build and packaging process. Review SQLCMD-81.03.README file for more details Jonathan Leffler Updated by: Jonathan Leffler 2007-05-14
utils2_ak	New release of utils2_ak Dbdelete.ec - New -q option permits one to specify a full SELECT statement to return ROWIDs selected for deletion. This adds enough flexibility to eliminate the need for many custom delete utilities. Myschema - Fixed two bugs affecting DBA procedures and breaking quoted strings across lines in triggers. dostats.ec - Fixed some portability issues, support added for v11 SAMPLING SIZE option. Fixed a bug detecting optimized versions with 2 digit patch levels. Requirement to specify -t with -i removed. Some code cleanup and replaced the getopt.[hc] version supplied with the same (later) used one in myschema. Updated by: Art Kagel 2007-05-01
sqlcmd-81.01	New release of sqlcmd This is primarily a bug fix release with not much in the way of major new features. Since version 80.00 was released in November 2005, the most significant change is that the configuration system tries to deduce compiler flags from the esql script so that 64-bit flags are picked up automatically. Another possibly significant change is the new program, SQLREAD. This is a read-only variant of SQLCMD. You can only use it to select data, possibly INTO TEMP tables (but you cannot create temp tables with explicit CREATE TEMP TABLE statements). You can adjust session characteristics like isolation level, but you can't do insert, delete or update operations, nor execute procedures, etc. If you compile with -DSQLREAD_NOSHELLESCAPE, then the user cannot invoke an editor on their SQL, or do other shell escape operations. The easiest way to do that is: make UFLAGS=-DSQLREAD_NOSHELLESCAPE This will not affect SQLCMD; the conditional tests are base on SQLREAD and SQLREAD_NOSHELLESCAPE. Treat SQLREAD with caution - it is new code and there might still be a backdoor way of modifying the database (please let me know if so). But it is a huge step in the right direction if that's what you need. The -G option (used for XML) is officially obsolete, replaced by -X instead. Note that 'sqlcmd -h' gives extended help. Still not proven to build on current versions of Windows with current versions of ClientSDK. If someone wants to do it, I'll assist, but it is not near the top of my personal priority list. It isn't my itch; I don't have any plans to scratch it. For other changes, see the ChangeLog file. Jonathan Leffler Updated by: Jonathan Leffler 2007-04-15
InformixDB	Update - Version 2.4! Implement 'named' parameter style to optionally bind query parameters by name Implement option to retrieve opaque types in their binary representation Submitted by: Carsten Haese 2006-12-01
utils2_ak	New release of utils2_ak This release of utils2_ak contains the following updates: Myschema: Revision 2.166 fixes a bug in SPL UDR output for IDS 9.xx+. Dostats: Release 1.126 - 1.127 Expand the verbose (-v) option to provide additional modes of verbosity including suppression of all progress output. Also added an error message if -S is not specified and the argument to -d does not resolve to a list of one or more databases (with -S a -329 error was already being produced if the named database did not exist). Thanks to Ravi Krishna for the suggestion. Release 1.128 fixes a bug detecting the server version if -S was specified. This could cause dostats to fail to correctly support IDS 9 & 10 server features. Also added verbose level -v2 which prints the server version strings. Thanks to Doug Conrey for pointing out the problem and performing the initial investigation. ul.ec: Release 1.38 fixed detection of HP systems at compilation time. Updated by: Art Kagel 2006-11-10
InformixDB	Update - Version 2.3! : InformixDB is a Python extension module that allows you to develop Python scripts/applications that connect to an IBM Informix database engine. Submitted by: Carsten Haese 2006-10-01
dbspace_pages	New release of dbspace-pages A very recently posted release of dbspace-pages.sh has a nasty little bug that breaks the script in release 9.4 of Informix. It ecounters a new "Note:" that appears in between the dbspaces and chunks sections of onstat -d. This upload has corrected the bug - an oversight in a pattern that matches hex numbers. Note: dbspace-pages.sh has no parameters. You just run it in an IDS environment where you would have run onstat -d. Updated by: Jake Salomon 2006-09-28
beautify-unl	New release of beautify-unl some awks have a problem with large floating point numbers and worked around this Updated by: Jake Salomon 2006-09-28
dup_spaces	New release of dup_spaces added code to handle release 10's new column in the dbspace section - the page size of the dbspace. Updated by: Jake Salomon 2006-09-28
myexport	New release of myexport_shr NEW! Support for myimport using HPLoader for data loading. Support for constraint filtering during loading. Support for loading/unloading servers requiring login and password for authentication using sqlcmd. Added option to myimport to load without logging. Updated by: Art Kagel 2006-07-12
utils2_ak	New release of utils2_ak Myschema: Added secure connection support. Fixed missing object (getopts.o) in makefiles. Fixed problem losing the name of the last check constraint for a table. Added new option --filtering to generate start violations and set constraints, indexes to filtering for use with myimport. Fixed compilation problems affecting getopt.c and getopt.h on HPUX and eliminated compiler warnings. Dostats: Fixed SEG Faults resulting from handling large numbers of stored procedures and UDRs that take no arguments. Updated by: Art Kagel 2006-07-12
escape	New utility The ESCAPE program is designed to make it possible to preserve spaces in arguments to shell script commands even when the arguments must then be passed onto another program (with the spaces intact). Updated by: Jonathan Leffler 2006-07-10
utils2_ak	New release of utils2_ak Here at long last is an update to utils2_ak with lots of new and improved stuff. Please see the README.1st for attributions of ideas and fixes and for further details: drive_dostats: - Fixed problems handling HUGE exclude files. dostats: - Fixed problems using -a with -S. - Support for optimized server versions. Output modified for newer server releases (7.31xD2+ & 9.20xC3+). - Automatically detects server optimization level. - New option -N to invert server optimization detection results. - New option -G to use actual row count of the table for -b mode. Needed for installations with thousands of tables as querying sysmaster takes too long on such systems. - Fixed problem with processing keys multiple times if only the sort direction of the index differs. - Expanded -i & -x to allow a WHERE clause (introduced with -i! or -x!) to be applied to systables or an entire sub-query to be included in table selection. Allows complete flexibility to configure what tables dostats processes. - Improved -e & -E output. Sub-totals now add up. - Fixed problems with tables that have a very large number of columns. - Fixed problems handling stored routines correctly in 9.xx+. Specific names are now used correctly when available, otherwise argument type lists are output for every overloaded function if that is available. If neither is available then overloaded routines are compiled in a batch using the older syntax. - Added a consistent string 'FAILED' to every error message to simplify scripting. myschema: - Two new options -I to toggle off printing of serial type initial values and -i to print a specific initial value. - Usage improved to clear up the interactions between -c and -a, and -i and -I. - Smart blob column support completed. - Added PROCEDURE keyword and argument lists to GRANT statements for 9.xx+ servers. - Fixed problem using with 9.2x-9.3x and LVARCHAR columns. - New -D option to only print UDTs. - New -Nnotypes option to supress UDTs from full schema, table, and routine reports. - New multi-function -N and long option names implemented as the options list becomes too long for mnemonics to be practical. - Filter out cdr_ tables. - Owners stripped from SPL now. dbcopy: - Support for usernames and passwords on the commandline and environment variables to ease scripting. - Cleaned up usage. Art S. Kagel Updated by: Art Kagel 2006-03-27
InformixDB	Update - Version 2.2! : InformixDB is a Python extension module that allows you to develop Python scripts/applications that connect to an IBM Informix database engine. Submitted by: Carsten Haese 2006-03-26
php_pdo_informix	New submission! This archive contains the PDO (PHP Data Object) driver in order to connect from PHP to Informix IDS. The binaries are not (yet) available on the PHP.net web site. Submitted by: Jean Georges Perrin 2006-02-22
setixd	New submission! The SETIXD script and its related programs are made available to the IIUG following a discusion in the comp.databases.informix news group in February 2005, under the subject 'Recommended Install Order'. Jonathan Leffler wrote: Have you considered using two separate INFORMIXDIRs - one for the server, and a separate one for the tools? David Grove asked: Then what about the INFORMIXDIR environment var? One would then have to set it every time, depending on what one purposed to do during a specific user session, right? Jonathan Leffler responded: Yes. The ordinary users would set INFORMIXDIR to the tools directory and never need the administration tools. [...see the README file for more information...] (Yes; it was on the one-year anniversary of a draft being started that this got posted. Happy Valentine's Day!) Submitted by: Jonathan Leffler 2006-02-14
aqb_free	New submission! Powerful visual query building component with full support of Informix SQL dialect. Submitted by: Sergey Smagin 2005-12-29
InformixDB	New submission! InformixDB is a Python extension module that allows you to develop Python scripts/applications that connect to an IBM Informix database engine. Submitted by: Carsten Haese 2005-12-10
JLoader	New submission! Little extensible program / library to simulate Informix (UN-)LOAD commands via jdbc. Handy if you do not have access to the target machine where you could use those statements. BLOB support is limited, only had a few jpegs in normal tablespace for testing. Capable of batch processing. (understatement: batch file REQUIRED) Use it if you like, have fun... Submitted by: Till Wilde von Wildemann 2005-12-07
size9	New submission! script to size database for V9.x written up Superboer, uploaded by Obnoxio The Clown Submitted by: Obnoxio The Clown 2005-12-06
sqlcmd-80.00	New release of sqlcmd This is primarily a bug-fix version of SQLCMD. It has new features too - like the ability to skip an initial number of records on LOAD and the new FIXSEP and FIXDEL formats. (Don't code those formats into your scripts; the notation will change in the next release - see the TODO file.) There's still an outstanding bug in SQLUPLOAD related to nulls in the input data. Updated by: Jonathan Leffler 2005-12-04
load2	New release of load2! Version 1.65 Maintenance release. Most important is CSDK 2.90 compatibility. Also option to not replicate changes loaded with loadinc. Submited by: Robert Sosnowski 2005-10-22
sqsl	New Submission! Structured Query Scripting Language in a standalone tool. Submited by: Marco Greco 2005-05-07
sqlcmd-77.08	New release of sqlcmd : Minor bug fix in XML output generation, thanks to Roy Mercer. Anybody using XML format output with 'headings on' or -H option, please note that heading tags are now all lower case (e.g. type_name instead of TYPE_NAME). Updated by: Jonathan Leffler 2005-04-22
ascii	New Submission! Here is an SQL package that provides two functions - ASCII('a') which returns the number corresponding to the first letter of the supplied string, and CHR(97) which returns the character responding to the supplied number (in the range 0..255, but be wary of 0). The gzipped tar file is tiny - 1918 bytes compressed. If you have SQLCMD, then you can run "sqlcmd -d dbase -f mkascii.sql" to create everything -- if you get fancy, you can make mkascii.sql executable and edit the pathname to sqlcmd into it, and then run the following command to create the information in a database called mode_ansi. It will work for logged, unlogged and mode ANSI databases. mkascii.sql mode_ansi If you don't have SQLCMD, you can use DB-Access to create the ASCII table (asciitbl.sql), and the procedures (ascii.sql, chr.sql) and then load the ASCII table from ascii.unl. There are 255 lines of data in ascii.unl - the missing value is ASCII NUL. Jonathan Leffler Submited by: Jonathan Leffler 2005-04-20
unl_utils	New Submission! Utilities for converting csv-files to Informix unl-files and vice-versa. csv2unl - Converts a csv-file to an unl-file. unl2csv - Converts an unl-file to a csv-file. unl2err - Splits an unl-file into good/bad parts. csv_fix - 'Fixes' a malformed csv-file. Requires a C compiler. Submitted by: Richard Harnden 2005-04-14
sqlcmd-77.07	New release of sqlcmd This is another minor upgrade to SQLCMD (compared with 77.03 or 77.05) with somewhat better handling of CSV data. If you are not stressing CSV format, it is not critical to upgrade to this version. Updated by: Jonathan Leffler 2005-04-02
upd_stats	New release of upd_stats Fixes to xupdstats script Updated by: Doug Wilson 2003-03-31
sqlcmd-77.05	New release of sqlcmd This maintenance release of SQLCMD includes all the features documented for v77.03, but adds fixes for handling CSV data with commas in the data fields during loading (and, coincidentally, fixes an oversight in the RELOAD command such that it did not accept FORMAT 'csv'). It also contains fixes for handling backslashes in both SQL statements and in load data files. (There is one area where CSV does not work the same as MS Excel - namely if the data for a field contains newlines. It appears that MS Excel is happy to accept the newlines without any escaping, and searches for the double quote that marks the end of the field. SQLCMD expects backslash-newline to mark the end of continued data fields; the backslash is omitted when the string is scanned by the CSV code. Thus, MS Excel would accept: abc,"def ghi" This defines two fields. SQLCMD requires: abc,"def\ ghi" Fixing that is non-trivial - it is not clear that it is worthwhile, either. Feedback on this decision is welcomed.) New Features Improved support for passwords, avoiding listing them both on the command line and in scripts. Following the lead of Ravikrishna's INFOTPASS environment variable in his INFOTABLES command, SQLCMD now looks for the file identified by the environment variable SQLCMDPASSWORDS. If the environment variable is not set, nothing happens. If it is set and you don't provide the password, SQLCMD will read the file looking for an entry which defines the database and username that are specified, and uses the password from the third field. If you do not provide a user name, the first entry matching the database is used. $INFORMIXSERVER is ignored; it is the database name specified in the connect request that counts. You can now effectively list just the user name and not the password in the CONNECT statement, but the user name will be ignored if SQLCMDPASSWORDS is not set. The *BLOB utilities also support this mechanism. Fields are case-sensitive and separated by pipe symbols, and blank lines and lines starting with a '#' are ignored. Other changes are more nearly cosmetic; the most significant is that you can now specify QUOTE '"' ESCAPE '@' FORMAT 'SELECT' in the middle of a LOAD or UNLOAD statement (where you could previously only specify DELIMITER). For UNLOAD (only) the formats include XML and you can also specify RECORDTAG 'tablename'. The characters or strings must be enclosed in quotes (single or double does not matter). New options include '-O col1,col2,col3' to specify the ordering of unloaded data with SQLUNLOAD and '-Y' to suppress the use of the history file in interactive mode. Note that the command number stays at 0 if you use this option. We can discuss whether that's a bug or a feature later. In theory, the 64-bit support should be better, and it compiles, links and runs using a C++ compiler instead of a C compiler. This version is aware of CSDK 2.90, which contains ESQL/C 2.90 (whereas CSDK 2.81 contained ESQL/C 9.53). Older versions of SQLCMD will not compile properly (if at all) under CSDK 2.90. Updated by: Jonathan Leffler 2005-03-31
update_statistics	New Submission! An update statistics controller program Submitted by: Greg Sinclair 2005-02-27
dbarchive.vbs	New Submission! dbarchive.vbs.zip contains two versions of a VBScript program for automating an achive of an Informix database server running on Windows NT/2000. They are released under terms of the GNU General Public License. Submitted by: Charles Rutledge 2005-01-28
ifx5utils	New Submission! Usefull routines in "C" for my older and not-soported informix online 5.x test installation runing over SCO Unix. The two most important are the called "page6.c" and "rchunk.c" The first touch de chunk flag for UP or DOWN allowing after a IO failure with make one chunk down, put them UP without AS from Miami. The second utility, allows the rename of the chunks in the reserverd pages. example: Y name the chunks on diferents machines/instances like "rifxMMMMa", "rifxMMMMb",.... where MMMM is a unique number. If I need to have in the same machine two instances of the same data, I make one archive, change the name of the chunks (by expample, original RIFX0000a, after rename "RIFX0001a"), then restore the archive.. Submitted by: Gustavo Tobares 2005-01-26
eSQLEditor	New Submission! eSQLEditor shows list of tables or procedures by pattern of name, columns, indexes, etc; paste name of table or other database object to sql text by double click; execute sql scripts with timing and logging and show error place. Submitted by: Denis Zhuravlev 2005-01-21
ntutils	New Submission! A set of Windows utilities to assist with INFORMIX administrative tasks on Windows Brief description addrights - Adds the user rights required by the informix user to logon as a Service and start IDS , or for a user to run ixsu.exe. anyserv - Allows any non-interactive program to be started as a service.. buildreg - Re-creates the windows Registry keys necessary to start IDS. cfgpatch - Changes onconfig.std values in the IDS Windows media. copydefault - Copies .default setnet settings to informix user settings d2u - Strips the CR from CRLF sequences from a file. delusr - Deletes specified user from all groups on machine. dllbase - Changes the Base Address of a DLL file. getdc - Requests information about machines on the domain from the first Domain Controller to respond. ixpasswd - Changes the logon password for all services which logon as user informix. ixset - Sets Informix environment variables in the Registry for the specified InformixServer. ixsu - Launches a command line window running as the specified user. logoff - Command line utility to logoff user, shutdown, reboot, or power-off machine. ntchname - Changes machine name dependancies for an IDS instance, changes IDS instance name. nterror - Converts an NT Operating System error number into an error message. ntmail - Command line utility to send emails. ntservice - GUI program to update and remove Windows Services. onregcheck - Checks and prints the Informix Dynamic Server Registry settings. proctoken - GUI program to view the user rights of running processes. runproc - Runs a program using the userid of the specified user. setsysenv - Sets system or user environment variables. tapeinfo - Queries a tape device for configuration information. uninst - Removes unwanted entries in the Control Panel->Add/Remove Programs dialog box. Submitted by: Guy Bowerman 2004-12-17
ipa.info.pl	New Perl Script! A pure Perl script that analyzes the text output from 'oncheck -pT' looking for outstanding in-place alters. Submitted by: Jonathan Leffler 2004-11-11
load2	New release of load2 , Version 1.6 upgrade for load2 procedures and related utilities. Added utility for comparing data between two tables - dbdiff. The main purpose is to ease synchronizing ER replication (detailed description in dbdiff.txt file). I've made also some bug fixes. Updated by: Robert Sosnowski 2004-10-17
utils2_ak	New release of utils2_ak Update release contains: Dostats: Improved support for mode ANSI databases. Myschema: New feature: -k now toggles whether named indexes should replace hidden constraint indexes. Updated feature: -F now also prints VIEWS which refer to the named table(s) and view(s) specified with -t. Myschema can now create a safety schema to be used when dropping or manually reorging a table. Fixed a compile-time problem affecting older ESQL/C versions. Improved support for mode ANSI databases. Support for UDR language privileging. Autodetects IDS engine versions that do not support IDS7.3/9.[234] features and uses alternative syntax where more efficient syntax that is not supported is used by default. adds minor revision protection to the generation of CREATE SEQUENCE statements which are first supported in IDS 9.40. Updated by: Art Kagel 2004-10-12
myexport	New release of myexport.shr Fixes to myexport & myimport to avoid problems with pedantic versions of nawk. Replaced dbaccess in myimport with sqlcmd to create database and tables so myimport can be run on a pure client. Updated by: Art Kagel 2004-08-26
utils2_ak	New release of utils2_ak Update release contains: Fixed the new shell archive so it supports the user's preferred pager to display the BUILDING and README files using the PAGER environment variable (default: more). Added support for UDR language privileging. Fixed some compiler complaints from pedantic compilers. Fixed an array overrun. Detects IDS version at runtime to avoid syntax recognized only be later releases. Alternative syntax that may be less efficient is substituted on those releases. A new file, BUILDING, which explains in detail issues related to building the package. The shell archive has been modified to automatically display this file when extracting the package and to offer to display myschema.README as well. Hopefully this will relieve some of the confusion some users have building the package. Myschema: Fixed a problem with LVARCHAR in IDS 9.2x and earlier servers. Fixed a bug causing myschema to abort when it encounters a sequence record in systables. Added full support for sequences. Changed handling of PRIVATE synonyms to always output the original owner clause. Implemented two efficiency improvements. Makefile improvements for IBM AIX users. Update to dbdelete.ec to permit compilation with the 64bit releases of the SDK. Update to myschema which fixes a problem handling LVARCHAR columns in IDS 9 releases earlier than 9.21. LVARCHAR was fixed lenght in those releases and adding support for 9.3x configurable length LVARCHAR columns broke support for 9.[12]x. This is now fixed. Dostats: NEW FEATURE: Support for environment variables INFORMIXUSER & INFORMIXPASS to allow dostats to be run against a remote server that is not a trusted host. Myschema: BUG FIX: Corrects a bug related to detached constraint indexes. Myschema was incorrectly declaring these without an IN dbspace clause which would cause a syntax error for PRIMARY KEY and UNIQUE constraint indexes of tables FRAGMENTED ROUND ROBIN. ENHANCEMENT: Extended the SET EXPLAIN feature (-E) to sysmaster table queries. Updated by: Art Kagel 2004-08-16
datelib_ak	New release of datelib_ak Updates include: Vastly improved string to date/time conversion function which can handle any future or current date and history begining with January 1, 1800. Handles every reasonable date/time format I could think to support plus english strings and fuzzy dates like "last tuesday" and "ten years ago wednesday" Also greatly expanded set of conversion functions to convert between the four date/time types provided with the library and Informix date, datetime, and interval types and several UNIX date/time formats. Updated by: Art Kagel 2004-01-15
sqlcmd-72.06	New release of sqlcmd SQLCMD version 72.06 released on 2003-12-05. This is the latest version of SQLCMD - as of today! it has a version of 'XML metadata' in it, triggered by -F xml and either -H or -T (you get the same with either or both). (Beware: the details of the XML behaviour are likely to change in future releases. Complete backwards compatibility is not guaranteed by default - but you should be able to configure the current behaviour if you need it.). It has various small bug fixes in it, including enhancements to CSV handling - for details, see the ChangeLog. The history mechanism has been revised to handle locking so that several processes can use the same history file and the resulting SQL is cleanly interleaved. Previously, you could get weird results and corruption. I've also updated the 'config.guess' and 'config.sub' scripts to the versions that are distributed with autoconf 2.57 - which is the most current version. The 64-bit support is still not as thoroughly tested as I'd like. And the support for IUS extended types is better than it was, but still far from stellar. For more details about the changes, look at the ChangeLog file. Updated by: Jonathan Leffler 2003-12-05
load2	New release of load2 , Version 1.50 Now linked with zlib library so gzipped files are immediately accessible. Unload now uses fetch array which increases performance a bit. Also few bug fixes. Updated by: Robert Sosnowski 2003-12-05
listtabchunk	listtabchunk version 2.1 In this version option -d can be specified to list all all tables/indices residing in all chunks of a dbspace. Updated by: Ravi Krishna 2003-10-12
master_event.plx	*New Submission!* This program will monitor all event's reported by the Informix Engine and log and will automatically back up logical logs as they fill. This program will also look at the free redo logs and send an email alert (either email or pager number) if the number of free logs =< total logs. Submitted by: Albert Smith 2003-059-25
dup_spaces	Made a small change in the awk one-liner to determine page size from the last line of onstat -b. This is to accomodate a small difference in onstat -b output introduced in IDS 9.x. attention. Updated by: Jacob Salomon 2003-09-25
infotable	infotable version 4.0 Support for function indexes Support for user defined type fields Support for ANSI databases PLUS bug fixes for reporting order, critical when comparing two databases for schema differences. Updated by: Ravi Krishna 2003-09-10
blob_to_char dblist_c dbbeauty dbdatabases dbinfo dblist dbloader dbreorg dbrepair dbreserved dbrowlock dbsyntax dbupdates db4glgen dbform dbinfo vie	New release of DBToolKit The programs of DBToolkit are listed to the left. New blob_to_char.txt file. The dblist rename to dblist_c in the C-ISAM version is to eliminate any conflicts with the ESQL/C version of dblist. The man pages for dbrepair and dbrowlock were updated. db4glgen: Fixed bug in how SERIAL fields are detected dbform: Cosmetic changes... data displayed in BOLD so it stands out, SERIAL fields displayed in REVERSE dbinfo_sh: Shell script version of the ESQL/C program that's been around for years. Updated by: Dave Snyder 2003-07-27
db4glgen	New release of db4glgen db4glgen ver 4.03 Changed "isql" to "dbaccess"... dbaccess comes with the engine, isql is extra. Checking for SERIAL now works with ALL versions of dbaccess. Updated by: Dave Snyder 2003-06-14
4gltools_ak	*New Submission!* 4GL functions to ease application building including warning and message box management functions, fprintf and other stdio functions, an updated printscreen function, transaction control functions that are database logging mode independent. Submitted by: Art Kagel 2003-05-30
load2	New release of load2 load2 ver 1.4 New improvements! Now handles blobs , both TEXT and BYTE datatypes. Can use with cygwin on Windows NT. Updated by: Robert Sosnowski 2003-04-13
sqlcmd-72.00	New release of sqlcmd SQLCMD version 72.00 was released on 2003-04-02. Compared with the prior generally available version, 71.02, there are two main changes, one functional, one legal. The functional change is that the format of the history file is now platform neutral, both between big-endian and little-endian machines and between 32-bit and 64-bit machines. The consequence of this is that the magic number for the history file has changed, so the new version of SQLCMD will decline to use the old format history file. Recommendation: if you want to retain your previous SQL history, use the old version of histdump to dump your history files to text, and review the contents. Then remove the old history files. SQLCMD will restart the history files with the new format. Alternatively, set the SQLCMDLOG environment variable to a new value (eg $HOME/.sqlcmdlog-72.00). The legal change is that the code is now explicitly released under the GNU General Public Licence version 2. The practical implications of this are supposed to be minimal, and if someone finds the GPL too onerous, they can contact me and discuss alternative licences after they've justified their problem. The other changes are basically minor. There was a discussion in comp.databases.informix with the subject 'Batch updates in ESQL' started by Roger Aunebakk on 2003-03-26, which lead to bug B162088 being entered in PTS. At the moment, the code for MKPROC ignores SQLNOTFOUND (because it should not be an error condition), but this can lead to faulty behaviour because of B162088. Be wary of using MKPROC until you've decided which behaviour you think is correct. For more details about the changes, look at the ChangeLog file. Updated by: Jonathan Leffler 2003-04-03
myonpload	New release of myonpload myonpload ver 2.1 Support for PIPES for external tools like gzip for compression. Updated by: Ravi Krishna 2003-03-16
blob_char	New release of blob_char Updated by: Dave Snyder 2003-03-16
rdslib	New release of rdslib Here's a new version of the RDSLIB code, the p-code librarian and linker for I4GL-RDS. It is compatible with I4GL-RDS 7.32.UC1, which has a new p-code version (732). That means that older versions of RDSLIB would not work with the new version of I4GL-RDS. The rdsscan program has a new option, -a, which might be of interest to people. Updated by: Jonathan Leffler 2003-02-19
upd_stats	New release of upd_stats "I fixed a problem with the wholock utility (I hadn't noticed it until now because it only happened when the table number was big enough), and I added a new utility for people still using Fourgen(Endura/Hk/Whatever) CASE tools (which correctly sets the DBSRC path before starting the 4gl debugger). " -- Doug Wilson Updated by: Doug Wilson 2003-02-18
alarm_space	New release of 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 Updated by: Thomas Horner 2003-02-06
dbps	*New Submission!* merges the output of onstat -g ses with ps -f (ie not Berkeley) Submitted by: Richard Thomas 2003-02-01
listtabchunk	*New Submission!* A tool which will print all tables/indexes residing in a chunk Submitted by: Ravi Krishna 2003-02-01
onsts	*New Submission!* Display sql for active sessions Submitted by: Richard Thomas 2003-02-01
set_index	*New Submission!* This script sets the object mode of contraints and indexes on a table(s) either ENABLED or DISABLED. Submitted by: Richard Thomas 2003-02-01
temptab.pl	*New Submission!* A PERL version of temptab Submitted by: Richard Thomas 2003-02-01
upd_stats_rt	*New Submission!* Generate and perform UPDATE STATISTICS on Informix tables Submitted by: Richard Thomas 2003-02-01
IfxSQL	New home for IfxSQL A database access tool for Windows that can make queries, execute scripts, export data, design reports, etc. The site's primary language is Spanish, but the tool's interface is straightforward. http:/www.terra.es.personal5.jcramos66 Updated by: Juan Carlos Ramos 2003-01-20
on_to_unload	New release of on_to_unload The latest release of on_to_unload adds more datatype support. Updated by: Art Kagel 2003-01-07
vertmenu_tk	*New Submission!* Tony Kaser has made some changes to vertmenu that fit his needs. He has included a file called CHANGES that hightlights his modifications. This is not to be considered as a drop in replacement of Marco Greco's vertmenu. Submitted by: Tony Kaser 2003-01-04
rix-0.4	*New Submission!* Remote Informix Monitoring 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. Submitted by: Richard Harnden 2003-01-01
sqlstruct	Release 1.4 of sqlstruct adds support for all built-in basic data types and fixes a bug affecting longer SQL statements. Updated by: Art Kagel 2002-12-26
infotable	Gives comprehensive information about a table similar to Oracle's describe command Updated by: Ravi Krishna 2002-12-04
mbp_ontape	Utilities for unattended backup of database and logs to disk Submitted by: Pavel Bohacik 2002-11-06

Recently Added Links to Other Sites

DBStudio	A free tool for fast SPL and query development
4glWorks	An application framework for Informix-4GL.
Aubit4GL	The Aubit Open Source Informix-4GL compatible complier and other 4GL development tools.
Server Studio	Server Studio JE with Sentinel - A comprehensive suite of tools to support IBM Informix databases from initial design, development and testing, through to production deployment and operational service [DBA, SPL, SQL]
IFxSQL	A database access tool for Windows that can make queries, execute scripts, export data, design reports, etc. The site's primary language is Spanish, but the tool's interface is straightforward.

Software Repository News

Recent New Submissions and Updates

Recently Added Links to Other Sites

Other Links