|
utils2_ak |
Update
Updates to several utilities in the package:
Myschema:
Shifted the implicit/explicit keyword to upper case for consistency.
Fixed a bug that was ignoring casts from or to built-in(non-UDT) types.
Dostats:
Fixed a bug in SET ISOLATION when executing immediately.
Fixed a bug in --drop-distributions.
Added --clean-distributions for cleaning out old distributions when only specific tables are being processed. Can be used globally, but --drop-distributions will tend to be faster.
Restricted --drop-distributions from being used with -t, -x or -i since it would drop distributions from all tables and then only rebuild the distributions for the specified tables.
Thanks to Ashok Sharma for pointing out these bugs.
Submiited by: Art Kagel 2012-01-30 |
|
utils2_ak |
Update
Updates to several utilities in the package:
dbdelete: Added new option -R which begins all transactions with the WITHOUT REPLICATION clause which prevents the operation from being replicated via Enterprise Replication. Thanks to .yvind Gjerstad for the suggestion. Also increased the size of the maximum SQL DELETE command (for rowid deletes) from 32750 to 65500 to reflect the increase in the SQL buffer size starting with IDS v9.40.
dostats_ng.ec: Fixed to output SET ISOLATION commands to the command file or procedure if not executing directly. Fixed a problem with dostats not able to compile old systdist functions left over from an in-place upgrade. Some versions renamed the older function as systdistold, others as oldsystdist. One code path caught and ignored both versions of the renamed function, the other was still trying to compile systdistold. Removed extraneous COMMIT WORK statements for ANSI mode databases. Fixed a missing CLOSE when a loop made a shortcut exit. Fixes a bug in the manual row counting function that affects sites with tables having more than 2^31 rows in a table.
Myschema: Added support for External Spaces to --infrastructure. Handled SQL API version better than dbschema, shelling out to onspaces rather than just putting the suggestion in the output.
ul.ec & dbcopy.ec: Added new option -R which begins all transactions with the WITHOUT REPLICATION clause which prevents the operation from being replicated via Enterprise Replication. The option is ignored in unload mode (-u). Thanks to .yvind Gjerstad for the suggestion.
Submiited by: Art Kagel 2011-12-31 |
|
utils2_ak |
Update
dostats_ng.ec: Added new feature --proc_local. Creates the table of commands for the procedure to execute in each database rather than in sysadmin. This is to support earlier Informix versions that do not have a task manager (so no sysadmin) and to support non-logged databases. Fixed bug when running against an ANSI mode database. Fixed -i '!' processing to allow ORDER BY clauses in the query for version 11 and higher that support derived tables. Restricted -x"!SELECT..." since -i can be used be
negating the filters in the query.
dbschema.ec: Fixed a problem preventing use with non-logged databases. Fixed a problem compiling with ESQL/C versions earlier than 3.50. Made changes to print_infrastructure.ec to support versions of IDS earlier than 11.xx that do not have dbschema -c support. Added new feature --drop-proc to optionally insert a drop procedure statement before each create. Also added REVOKE EXECUTE FROM PUBLIC after the create. If public should have privileges a grant to that effect will also be output.
Submiited by: Art Kagel 2011-09-25 |
|
utils2_ak |
Update
Fixed a bug causing SEGV processing private synonyms
- New feature --infrastructure[=] to emulate doschema -c [-ns]. Fixes problems with the dbschema implementation:
- all chunks created in their original order (dbschema creates them in dbspace order)
- correct meta-data sizing for sbspaces (dbschema outputs size/4)
- correct tablespace tablespace sizing (dbschema outputs incorrect sizes for dbspaces with non-default pagesizes)
Submiited by: Art Kagel 2011-06-22 |
|
utils2_ak |
Update
dostats_ng.ec: Added new options --force-run and --auto-run to enforce FORCE mode or AUTO mode disregarding the AUTO_STAT_MODE setting in the ONCONFIG file and the environment.
myschema.ec: Address some platform and IDS version issues. Fixed bugs. New feature: --no-blade-funcs to eliminate stored routines associated with IBM datablades. New feature: --force-autostats force the output of STATLEVEL AUTO when appropriate. Added support for STATLEVEL and STATCHANGE.
ul.ec: New features: -f for reading/writing from/to stdin/stdout so ul.ec can be used as a filter. New -N option to output to native byte order rather than network byte order.
dbcopy.ec: Fixed a bug affecting DECIMAL/MONEY type column data.
dbstruct.ec: Added support for external tables and synonyms. New -G option to output 4GL RECORD structures.
sqlstruct.ec: New -G option to output 4GL RECORD structures.
Submiited by: Art Kagel 2011-05-28 |
|
ratios.shr_ak |
Update
Includes two additional experimental metrics and fixes a display bug affecting some platforms.
Submiited by: Art Kagel 2011-04-06 |
|
myexport |
Update
Added new option to myexport: -i controls the isolation level during external table based exports (-E or -e).
Submiited by: Art Kagel 2011-04-06 |
|
utils2_ak |
Update
Fixed a bug causing some columns to be dropped under specific conditions
Submiited by: Art Kagel 2011-04-06 |
|
utils2_ak |
Update
ncludes fixes to restore compatibility with Informix versions earlier than 11.50. Support added for a new myexport feature. Fixed DEFAULT clauses for BIGINT type columns.
Submiited by: Art Kagel 2011-04-05 |
|
sqlcmd-87.02 |
New release of sqlcmd
A new version of SQLCMD, version 87.02, has been uploaded to the IIUG
Software Repository. It contains a series of minor bug fixes compared
with 87.00, plus one minor feature.
The main bug fix is in the handling of a memory search function,
memmem(), which is available in the system with AIX 6.1 and some
versions of Linux The configuration only uses my implementation if there
isn't a system one, and I've changed the interface of my implementation
to match the interface provided by AIX and Linux.
The minor new feature is the ability to create a trusted connection, if
your system administrators give you permission to do so. The syntax has
the keyword TRUSTED appear at the end of the CONNECT statement (after
WITH CONCURRENT TRANSACTIONS or WCT if you use that).
Updated by: Jonathan Leffler 2011-04-04 |
|
partn |
Update
Version 1.3
Appends "database:owner.table[#index][%fragpart][,fragdbs]" to any onstat command which has a partnum/tblnum
eg: onstat -t | partn -xk5
Submiited by: Richard Harnden 2011-01-01 |
|
indexSizeEstimating |
New
EXCEL spreadsheet to estimate the size of a new index
Submiited by: Jose Luis Cabrera 2010-12-10 |
|
fgledit |
New
fgledit.pl is a simple perl script that "replicates" part of the behaviour
or r4gl and i4gl development cycle, i-e edit the source, compile it, get errors (sometimes :-),
edit the source with errors, positions the cursor on the first error occurrence,
cleans the errors text lines once the file is edited to have a brand new clean source file.
Submiited by: Eric Vercelletto 2010-12-10 |
|
ratios.shr_ak |
Update
Added new metrics.
Submiited by: Art Kagel 2010-12-10 |
|
myexport |
Update
This updated version of myexport uses EXTERNAL TABLES to unload and load data faster then ever! Options to load using DELUXE mode or EXPRESS mode external tables.
Submiited by: Art Kagel 2010-12-10 |
|
utils2_ak |
Update
New features again. Check it out!
This release also finally fixes the problems compiling the package on AIX. Also fixes two compile time warnings and a runtime bug in the previous (Nov. 17) release.
Submiited by: Art Kagel 2010-12-10 |
|
ar2 |
Update
Updated makefile to simplify build
Submiited by: Art Kagel 2010-12-10 |
|
partn |
Update
Appends database:owner.table[#index][%fragpart][,fragdbs] ..
eg: onstat -t | partn -xk5
Submiited by: Richard Harnden 2010-12-05 |
|
OnManager |
New
An administration utility to monitor server, user sessions, manage disk space, grant and limit access to databases
Submiited by: Tatiana Saltykova 2010-11-24 |
|
utils2_ak |
Update
dbdelete.ec: adds a new option, -o, that instructs dbdelete to not close and reopen the fetch cursor between rounds of fetching keys or rowids to delete. The purpose is to reduce (but not eliminate) the possibility of deleting rows that have been inserted to the table during the dbdelete run that match the selection criteria.
dostats_ng.ec: fixes an intermittent problem returning SQLCODE = -9971
myschema:
Added support for all 11.70 features. Note that some are not yet properly supported by dbschema in v11.70.xC1!
Submiited by: Art Kagel 2010-11-24 |
|
updstats_fn |
New
hese are my shell scripts to update statistics.
Not as complete as Art's utilities, but easier to use since they just require SHELL.
Submited by: Fernano Nunesn 2010-10-30 |
|
sqlcmd-87.00 |
New release of sqlcmd
Another update of SQLCMD, fixing some bugs and adding minor new functionality. See the README at the IIUG Software Repository, and the ChangeLog in the distributed source, for more information.
Updated by: Jonathan Leffler 2010-10-29 |
|
rdslib |
New release of rdslib ( version 2010.02 )
A new program, rdssplit, splits a p-code interpretable into its component p-code object files.
Updated by: Jonathan Leffler 2010-09-13 |
|
sqlcmd-86.09 |
New release of sqlcmd
Bug fix release. Primary bug fix renames the getline() function to avoid collisions with the POSIX function of the same name but different interface. The configuration recognizes CSDK versions up to 4.99, even though Panther uses 3.70 (at one time, it was going to use a 4.x version); call it 'future-proofing', but don't try it on a system running really old ESQL/C 4.xy. Other changes - see ChangeLog file.
Updated by: Jonathan Leffler 2010-09-13 |
|
beautify-unl |
update
Another update on this utility, mainly to correct some deficient (but working) Perl code in the UNLbeautifier class. The shar file also includes the original beautify-unl.sh and the text file that came with that.
Note that the class can also be used by any Perl script that is fetching data into an array. It need not operate on an unload-file. Run perldoc on UNLbeautifier to get information on the methods.
Updated by: Jacobn Salomon 2010-08-10 |
|
ixlocks |
update
This is the first public release of an Open Admin Tool (OAT) plugin to manage locks.
Updated by: Fernando Nunes 2010-07-31 |
|
beautify-unl |
update
Last week I released a first version of beautify-unl.pl, basically just a Perl version of my old utility beautify-unl.sh. The package was useful only to beautify-unl.pl. That has changed: The package can now accept rows of data, not just a delimited ASCII line. It can be used in any Perl script that fetches data from any database, not just Informix.
Updated by: Jacobn Salomon 2010-07-31 |
|
fragments.shar |
update
(Just reinstating what had been inadvertently deleted)
Updated by: Jacobn Salomon 2010-07-31 |
|
utils2_ak |
Update
This is a major release with lots of new features and fixes. Highlights:
Myschema - new options:
--no-extent-clause (like dbschema without -ss)
--set-owner - replace all owners with this one. Very useful for moving dev schema to production.
--sequence - print only sequence definitions
Support for default ROLES.
dbcopy - fixed support for LVARCHAR, DATETIME and INTERVALS
dostats_ng.ec - New options:
--drop-distributions to start the run by deleting all distributions
--isolation - set the runtime isolation. In some environments dostats may run faster with DIRTY_READ isolation set.
Submiited by: Art Kagel 2010-05-08 |
|
rdslib |
New release of rdslib ( version 2010.01 )
This is a maintenance release of the code, primarily (the previous
version was 2007.02).
There is a new script, p4gl, analogous to c4gl used by the c-code I4GL
compiler. Example use:
p4gl -o program.4gi source1.4gl source2.4go -L $HOME/lib/pcode \
-lxyz -lgen
This creates a program program.4gi by compiling source1.4gl and linking
it with source2.4go and two p-code libraries libxyz.4ga and libgen.4ga
that might be found in the current directory or in $HOME/lib/pcode.
The bug fixes mean it should work better on Linux (and MacOS X, in
theory). They also avoid a double-free error when the rdslib program is
run against an archive with no p-code files in it.
It supports p-code versions up to 7.32 (the current p-code version used
by I4GL-RDS 7.50.xC3).
Updated by: Jonathan Leffler 2010-03-01 |
|
partn |
New
Appends database:owner.table[#index][%fragpart][%fragdbs] to onstat commands
eg: onstat -t | partn -xk5
Submiited by: Richard Harnden 2010-02-09 |
|
recreate_er_define_stmts |
New
This is a bash shell script that interrogates the syscdr database and generates "pretty" cdr define commands (Based on 11.50.xC5 on Redhat 4) .
It doesn't take account of conflict resolution (I don't have any) and assumes all replicates are "Primary - Recipient", not update anywhere.
If anyone wanted to extend this to account for the above (easy to do, the syscdr database is a breeze to navigate):
Conflict resolution - look in the syscdr:repdef table (four rows starting with 'cr_')
Update anywhere replicates - Remove the "P" section in the query and review the MULTISET clause
Things I haven't done:
Found all the other flags from the repdef:flags column (Madison? can you help there?)
The bash scriptlet is to format the output 'nicely'.
Submiited by: Jarrod Teale 2010-01-16 |
|
ratios.shr_ak |
New
Ratios.shr_ak provides a stored procedure and shell script to report the basic server performance metrics for server versions 10.00 and later including reporting metrics for individual buffer caches for servers with multiple caches.
Submiited by: Art Kagel 2010-01-01 |
|
utils2_ak |
Update
New file: dostats_ng.ec: This is the first release of the next generation of
dostats! Features are currently the same as the regular dostats with one new
feature. However, the _ng release ONLY supports Informix Dynamic Server
versions 10.00 and later. Support for SE, Online 5.xx, DS 6.01, & IDS 7.xx and
9.xx have been removed in order to simplify the code path. This includes the
removal of the older algorithm needed to support pre-optimized server versions.
The only visible result of this code cleanup is that the table level trace
"Working on ..." is working correctly for the first time since the
optimized code path was added . The new feature is the --time-display
option which prints the start time of each step that is executed to make parsing
trace logs easier and to help determine if dostats runs are affecting other
tasks. All new features will be added to dostats_ng.ec from now on. The
original dostats.ec code base is frozen except for bug fixes. The makefile has
been modified to default to compiling dostats_ng.ec to create the dostats
executable.
myschema:
o Added a new option, -g, to place user privileges into a separate, specified,
file. This is useful for server audit and for larger installations. Thanks
to Bruce Simms for the idea. A future release may have a privileges only
option.
o Improved trigger parser. o Made index and constraint processing recognize
and display object state (enabled, disabled, filtering, etc.).
o Improved the --filtering option again. It now works correctly, leaving the
violated constraints disabled, but the offending records are recorded in the
violations table. The user will have to manually delete the keys noted in
the violations table(s) and then enable the violated constraints. Myimport
may be modified to automate this at some point.
o Fixed problem with VIEWS and SYNONYMS defined on tables that are later
ALTERED with a non-inplace ALTER printing before the table(s) that they
reference. Thanks to Joseph Jurcazak for pointing the problem out. There
still may be problems with VIEWS and SYNONYM ordering since SYNONYMS and
VIEWS can reference each other, but I can't figure out a good solution for
that one.
o Removed the warning issued when the CREATE statement is not found in the
first record of an SPL routine's text to only print when in verbose mode.
o Fixed problem with zero length defaults for character types. Was generating
a single space character as default, should be an empty string as these are
different for variable char type columns.
o Fixed type owner printout to use double quotes. Was single quoting type
owners for LIST, SET, & MULTISET types.
o Fixed some internal owner references to use double quotes. This was causing
trouble in ANSI databases and under DELIMIDENT.
o Fixed a #define causing compiler problems when using gcc v 3.xx
o Fixed handling of collection type columns.
o Added owner to table name in summary comment when not suppressed, ala
dbschema.
ul.ec:
o Fixed file size handling to allow files larger than 2GB.
o Fixed handling of BOOLEAN.
o Fixed a bug in DATETIME handling as string.
o Improved help.
o Fixed variable character default to handling as STRING to eliminate soft
trailing spaces.
dbcopy.ec:
o Fixed handling of BOOLEAN columns.
o Improved version detection for compile time handling of BIGINT, INT8,
BOOLEAN, etc.
Submiited by: Art Kagel 2009-10-27 |
|
img2mac |
New
Script to create a printer macro from an image file to print images from an Informix 4GL report (Logos, check signatures etc...)
Submiited by: Chad Lemmen 2009-08-26 |
|
undelete |
New
: Undelete utility restores erroneously deleted rows by decoding onlog listing
Submiited by: Denis Melnikov 2009-08-20 |
|
utils2_ak |
Update
Myschema: Improvements to handling keywords in comments in SPL and in quoted strings in trigger definitions. Fixed a problem with the auto extent calculation feature (-a) that was introduced in the last release.
Dostats: New features:
--procedure - creates a stored procedure to execute the UPDATE STATISTICS commands that dostats produces.
--schedule - Schedule the stored procedure to run periodically or once using the 11.xx+ task scheduler feature.
--aus-thresholds - Retrieve the Auto Update Statistics threshold settings to configure Aging, Browsing and PDQPRIORITY if enabled.
Fixed a problem linking dostats with -static on Solaris.
New makefile for systems that do not have GNU Make installed.
Improved Windows compiler compatibility.
ul.ec - replaced strcpy's with snprintf to improve security of commandline option processing.
listdb7.ec and sqlstruct.ec now unconditionally include my getopts.h everywhere.
dbstruct.ec fixed missing type in a static declaration that prevented compilation on some platforms.
Submiited by: Art Kagel 2009-08-01 |
|
ntutils |
Update
Upgrade to the NTUtils package. Improved readme and a fix to ipcs.exe
Submiited by: Guy Bowerman 2009-07-22 |
|
sqsl |
Update
New db2 data sources, Aubit 4gl port, Cygwin based Windows port (sadly no Aubit on Windows yet)
Submiited by: Marco Greco 2009-06-12 |
|
fglpp |
Update
now with IF[N]DEF/ELSE/ENDIF directives
Submiited by: Marco Greco 2009-06-12 |
|
rehex |
New
This copies stdin to stdout and reformats any hexadecimal numbers. Makes it easier to cross reference the output of various 'onstat' commands.
Submiited by: Richard Harnden 2009-05-28 |
|
InformixDynamicServerDialect |
New
The default Informix Dialect supplied with Hibernate has some bugs and missing functionality.
This dialect addresses these problems and improves the communication between Hibernate and IDS
Submiited by: Gary Ben-Israel 2009-05-28 |
|
utils2_ak |
Update
Fixes a bug in myschema affecting users with IDS versions earlier than 11.50.
Improved compile options to support CSDK versions earlier than 3.50 again.
Support for mixed case arguments to aid use in scripts that source tablenames
from mixed case repositories.
Submiited by: Art Kagel 2009-05-15 |
|
lwt_install |
Update
Lightweight installer utility to deploy pre-configured IDS instances on Windows
A new version 0.2.7 of the IDS Lightweight Installer is available. This version adds support for DRDA ports, a custom ROOTPATH, and uninstallation.
Submiited by: Guy Bowerman 2009-04-30 |
|
utils2_ak |
Update
New features in the April 7 release of utils2_ak:
New utilities (moved from another package and updated):
dbstruct.ec will produce C or ESQL/C structures to match a table
structure or that of an entire database.
sqlstruct.ec will produce C or ESQL/C structures to match the results
of an SQL statement. Statements that take replaceable parameters
will produce input structures as well as output structures if
appropriate.
dostats.ec:
* Fixed many ANSI mode problems again. Thanks to Kernoal Stephens
for his persistence in providing feedback.
* Fixed a problem with handling tables with very large numbers of
rows. However this makes dostats will no longer compile on
systems with SDK versions earlier than 3.50 as they do not
understand BIGINT.
* Fixed a problem accessing early versions of IDS that do not
support DBINFO( 'version', ... Thanks to Jacob Salomon for
finding this one.
myschema:
* Fixed the output location for SET INDEXES ... FILTERING to go to
the secondary schema file along with the CREATE INDEX statements.
* Fixes the extent calculations to take account of differing page
sizes, even between fragments of a table. Thanks to Hrvoje
Zokovic for pointing up the lack of support.
* Fixes the output of the --filtering option. This option is used
by myexport to ensure that the resulting myimport-ed database is
internally consistent without locking the database.
* Adds code to support the new SAMPLE SIZE option to medium
distributions when -u/-U option is presented.
* Fixes a bug causing core dumps if routines with defaulted
parameters exist. Thanks to Doug Lawry for pointing this one
out.
* Fixes a problem accessing early versions of IDS that do not
support DBINFO( 'version', ... Thanks to Jacob Salomon for
finding this one.
* Fixes problem compiling in older SDK/ESQL-C versions due to some
missing ifdef's protecting newer data types.
* Fixes a bug causing garbage to be displayed for LVARCHAR columns
on some 64bit systems.
ul.ec:
* Fixed problems compiling with older SDK and esql/C versions.
Submiited by: Art Kagel 2009-04-28 |
|
ntutils |
Update
A new version of NTutils - Windows utilities to simplify IDS administration tasks - is now available. This version has many bug fixes and has been tested on the latest Windows operating systems and IDS versions up to 11.50, and includes new utilities such as onpipe - which facilitates running IDS administration commands when the IDS service logs on as the SYSTEM user and no informix user account exists on the machine.
Submiited by: Guy Bowerman 2009-04-26 |
|
fragments.shar |
New
Quick review of partitions.sh uses:
- Note when a tablespace is getting fractured
- Locate all physical components of a table
- List all indexes and their page usage.
Added some features and came up with fragments.sh. Note, it calls fragment-list.sh to generate the basic data, then calls beautify-unl.sh to format the columns.
An update of partition-list.sh and partitions.sh:
fragments.sh, developed under Rel. 10.0, adds 2 main features over partitions.sh:
1. Displays basic fragment information (position, partition-name). Optionally, will display the fragmentation expression, if you use the -f option.
2. Since it was developed in an environment with mode-ANSI databases, it now displays the owner names of each tablespace.
May not work for releases below 10.0.
Submiited by: Jacob Salomon 2009-04-01 |
|
utils2_ak |
Update
Dostats: Fixed problems with databases that have C & Java
UDRs. Fixed missing semi-colons in COMMIT statements in mode ANSI
databases. Fixed problem with lagging owner names in mode ANSI
databases.
myschema: Fixes a bug in displaying DEFAULT clauses containing
INTERVAL type data. Also fixes a bad cast in print_indexes.ec that
passed older compiler tests but fails in gcc v4.xx
myschema:
Release 2.174 Fixed aggregate printout to exclude the
built-in genxml* aggregates included in every database since v11.10
Releases 2.176 & 2.175 Add support for VERCOLS which is
missing from dbschema as of 11.50xC3
ul: Made the code safe to compile and use in 64bit
environments. Fixed a bug in handling DECIMAL column data. New -F
option to process LVARCHAR columns as FIXCHAR the same as CHAR and
VARCHAR are already handled. Optional because it causes LVARCHARS to be
padded in the database to maximum length.
Added support for LVARCHAR, INT8, BIGINT, SERIAL8 and
BIGSERIAL. Also added a new option -F to optionally export LVARCHAR
columns as FIXCHAR to support binary data embedded in LVARCHAR.
dbcopy: Made the code safe to compile and use on 64bit
systems. New -B option to save error rows to a binary format that can
be reloaded using the ul.ec utility - needed if binary or non-printable
data is contained in CHAR/VARCHAR/LVACHAR cols. New -e option to
control binary/fixed format copying of CHAR, VARCHAR, and LVARCHAR
columns. Added support for INT8/SERIAL8 & BIGINT/BIGSERIAL column
types. Option -L is now deprecated in favor of '-e varchar'.
Submiited by: Art Kagel 2009-01-16 |
|
sqsl |
Update
The latest and greatest SQSL version is available for download!
Submiited by: Marco Greco 2008-10-23 |
|
lwt_install |
Update
Lightweight installer utility to deploy pre-configured IDS instances on Windows
A new version of the Informix Lightweight installer is available with 3 fixes:
1. A problem creating the informix user on domain machines
2. The -unzip command was not being executed
3. A problem running -verbose and -silent together if INFORMIXDIR or INFORMIXSERVER not set
Submiited by: Guy Bowerman 2008-10-20 |
|
lwt_install |
New Submission
Lightweight installer utility to deploy pre-configured IDS instances on Windows
Submiited by: Guy Bowerman 2008-09-27 |
|
linkpath |
Updated version
LINKPATH is a program that lets you check the security of the path leading to $INFORMIXDIR, or indeed for any file or directory.
his is an updated version of LINKPATH which accepts that user sys does not exist on Linux, and neither bin nor sys exists on MacOS, and so on and so forth. Thanks to Jim Tranny for pointing out the error.
Updated by: Jonathan Leffler 2008-08-12 |
|
informixtypes |
New contribution
Based on discussions in the ids@iiug.org mailing list in July 2008 under the subject 'Weird Request', here is a (pair of) stored procedure(s) to convert collength and coltype into a recognizable string.
Add BIGINT, BIGSERIAL support (per bug report from Art Kagel). Clean up some minor issues in the comments.
Updated by: Jonathan Leffler 2008-07-28 |
|
sqlcmd-86.00 |
New release of sqlcmd
SQLCMD version 86.00 will LOAD tables specified with database@server:owner.table and subsets of that, under delimited identifiers mode (DELIMIDENT set in the ESQL/C environment - so other client APIs may have more stringent requirements on the setting of DELIMIDENT). You can also create basic HTML tables by setting 'format HTML'.
Updated by: Jonathan Leffler 2008-07-15 |
|
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.
Fixed compile time bug in myschema: print_procedures.ec file.
- 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-07-106/TD>
|
|
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 |
|
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 |
