Art's Utilities Download Page
Latest Gamma Level Releases
Utils2_ak is my primary package of utilities. This is the May 15, 2020 release.
Included:
dbping.ec - Tests connections and reports connection time as well as the actual host and servername connected as well as which alias was used for
the connection. These reports are important for testing DBPATH, connection groups, and Connection Manager behavior as well as verifying
server failover.
dbcopy.ec - Copy data from table to table directly across databases, servers, instances, versions, even between databases at different logging levels
without worrying about long transaction rollbacks.
dbdelete.ec - Delete large amounts of data from a table FAST without risking long transaction rollbacks.
dbmove.ec - Another data copy utility using the methods the dbdelete uses. Can copy some data that dbcopy cannot.
dbsavail.ec - Summary dbspace report. Reports used and free space in pages, KB, and percent. Optional chunk detail.
dbscript.ec - Generate SQL, scripts, or OS commands to run against all or some of the tables in your database.
dbstruct.ec - Generate data structures from your database for C, C++, ESQL/C, Structured FORTRAN, or x4GL.
dostats_ng.ec - The original and still the best way to automate your update statistics runs. The original dostats.ec source is included for servers older than
10.00.
drive_dostats - Divide and conquer. Runs multiple copies of dostats updating a subset list of your tables. If you have the cores to spare, get the job done
faster.
listdb7.ec - Displays details about your databases and tables and indexes.
mydbdiff - Script to compare two schema files or a schema file to a live schema.
myschema - My dbschema replacement utility. Does everything that dbschema does except display data distributions (dbschema -hd) and much more.
Many many options to tune its behavior
printfreeB.ec - Print out a table detail report similar to oncheck -pT
sqlstruct.ec - Generate data structures from SQL statements including input and output structures for SELECT, INSERT, DELETE, and UPDATE statements.
Options to generate C, C++, ESQL/C, 4GL, or SQL DDL (for SELECT).
ul.ec - A binary file unload/load utility. File format is compatible with external table "INFORMIX" format and portable between processor
architectures.
README.1st - Reports what features and fixes are included in each utility.
BUILDING - Describes how to build utils2_ak on each platform and compiler environment. Tells what changes need to be made to the makefiles for
each.
Myexport is my replacement for dbexport and dbimport. These scripts optionally use external tables or the Informix High Performance Loader to unload and load data much faster than dbexport/dbimport without locking the database. Options include parallel export and import, NOVALIDATE data loading, constraint filtering, user selected isolation level, running dostats after the load, compressed unload files, dbexport & dbimport compatibility, dbspace mapping.
The package includes:
myexport - Drop in replacement for dbexport
myimport - Drop in replacement for dbimport
ak_launcher.c - Used by myimport
from_external.awk - Used by myimport to pre-process a dbexport data set for loading via external tables.
Sample dbspace mapping files.
Included:
dbping.ec - Tests connections and reports connection time as well as the actual host and servername connected as well as which alias was used for
the connection. These reports are important for testing DBPATH, connection groups, and Connection Manager behavior as well as verifying
server failover.
dbcopy.ec - Copy data from table to table directly across databases, servers, instances, versions, even between databases at different logging levels
without worrying about long transaction rollbacks.
dbdelete.ec - Delete large amounts of data from a table FAST without risking long transaction rollbacks.
dbmove.ec - Another data copy utility using the methods the dbdelete uses. Can copy some data that dbcopy cannot.
dbsavail.ec - Summary dbspace report. Reports used and free space in pages, KB, and percent. Optional chunk detail.
dbscript.ec - Generate SQL, scripts, or OS commands to run against all or some of the tables in your database.
dbstruct.ec - Generate data structures from your database for C, C++, ESQL/C, Structured FORTRAN, or x4GL.
dostats_ng.ec - The original and still the best way to automate your update statistics runs. The original dostats.ec source is included for servers older than
10.00.
drive_dostats - Divide and conquer. Runs multiple copies of dostats updating a subset list of your tables. If you have the cores to spare, get the job done
faster.
listdb7.ec - Displays details about your databases and tables and indexes.
mydbdiff - Script to compare two schema files or a schema file to a live schema.
myschema - My dbschema replacement utility. Does everything that dbschema does except display data distributions (dbschema -hd) and much more.
Many many options to tune its behavior
printfreeB.ec - Print out a table detail report similar to oncheck -pT
sqlstruct.ec - Generate data structures from SQL statements including input and output structures for SELECT, INSERT, DELETE, and UPDATE statements.
Options to generate C, C++, ESQL/C, 4GL, or SQL DDL (for SELECT).
ul.ec - A binary file unload/load utility. File format is compatible with external table "INFORMIX" format and portable between processor
architectures.
README.1st - Reports what features and fixes are included in each utility.
BUILDING - Describes how to build utils2_ak on each platform and compiler environment. Tells what changes need to be made to the makefiles for
each.
Myexport is my replacement for dbexport and dbimport. These scripts optionally use external tables or the Informix High Performance Loader to unload and load data much faster than dbexport/dbimport without locking the database. Options include parallel export and import, NOVALIDATE data loading, constraint filtering, user selected isolation level, running dostats after the load, compressed unload files, dbexport & dbimport compatibility, dbspace mapping.
The package includes:
myexport - Drop in replacement for dbexport
myimport - Drop in replacement for dbimport
ak_launcher.c - Used by myimport
from_external.awk - Used by myimport to pre-process a dbexport data set for loading via external tables.
Sample dbspace mapping files.
News:
May 15, 2020
dbping.ec:
Added new options: -u user, -p password, -t timeout, -h for usage, and -V for version printout
May 10, 2020
myschema.ec:
Fixed a problem where Access Method support functions were being written to the procedures file which will cause the main
file to fail to execute on the target database because those function definitions are needed to define the Access Method. Thanks
to Kenneth Penza for bringing this to my attention. Support functions are now written to the main file except when only printing
stored procedures.
May 7, 2020
myschema.ec:
Added new option --no-private-synonyms to exclude private synonyms from the output. Thanks to Ognjen Orel for the suggestion.
April 27, 2020
myschema.ec:
Added --help option to report usage with a success return code. Removed stropts.h and the unimplemented system call isastream().
dbscript.ec:
Added options to control what objects are processes:
-e - Include EXTERNAL TABLES in the 'table' names processed.
-v - Include VIEWS in the 'table' names processed.
-s - Include SYNONYMS in the 'table' names processed.
-S - Include SEQUENCES in the 'table' names processed.
-n - Exclude 'normal' tables from processing. Useful only when one or more of -s, -e, -v, or -S are included.
April 12, 2020
dbscript.ec:
myschema.ec:
For both of these utilities - Changed a query to be dynamic because some early CSDK 3.50 releases did not recognize the ORDER SIBLINGS BY
construct and rejected the code even though the corresponding engine releases supported it. The new code will be passed to the engine so
as long as the engine supports the feature it will be OK. This affects the dbscript -D option and the myschema --dependency-order option. The
behavior is unchanged, this change just expands support to some older compilers. Thanks to Mark Collins for identifying the issue.
February 12, 2020
dbdelete:
Fixed a bug when -I was passed. Added new -v (verbose) flag to increase runtime trace.
Added new -P option to specify a pause between delete runs. May improve performance on some servers or reduce impact on other processes.
Fixed a problem with -p which was not obeying "-p 0".
Thanks to David Williams for the ideas for -P & -v and for identifying the -p 0 issue. David also provided the code to implement -P.
dostats_ng.ec:
Fixed a problem acquiring row counts for virtual tables. VTI tables are no longer processed.
January 15, 2020
dbcopy.ec:
Added support for ifx_row_id the undocumented ROWID analogue that works for all tables whether partitioned or not!
myschema:
Fixed extensible chunk output for --infrastructure. Fixed an error message and a usage error.
Novenber 18, 2019
myschema:
Fixed a bug displaying DATETIME types in some conditions in CREATE TABLE that was introduced in the September 17 release.
Improved handling for DISTINCT types of all base types.
Fixed REVOKE ... AS <owner> to conform to -O -A & --set-owner. Added AS <owner> to REVOKEs for sequences.
dbdelete:
Added support for using ifx_row_id for processing partitioned tables that do not have WITH ROWID included (-I). Works for all
tables and may be faster than the default for partitioned tables WITH ROWID.
September 17, 2019
myschema:
Added support for the new TSTAMP distinct type.
September 13, 2019
myschema:
Added support for the new Partial Index feature in v14.10.FC2!
September 10, 2019
myschema:
Added support for storagepool commands to the --infrastructure output.
Moved UDT definitions to the primary file (needed for myexport).
Fixed security policy display.
Dostats_ng.ec:
Fixed the display of the time processing each object ends.
June 28, 2019
Makefiles: Fixed a problem. Also improved "make install" to recognize the INSTALLDIR environment variable to override the default location.
BUILDING: Updated this instruction file to document the INSTALLDIR environment variable and expand the description of -static issues when using recent versions of GCC to compile.
June 18, 2019
listdb7.ec:
Added the locale of each database to the detail (-D) display.
April 30, 2019
Myschema:
Added --views-file to name a file to hold views and related triggers.
Added --views-only option to restrict output to only views and related triggers.
Added --synonym-file to name a file to hold synonym definitions.
Added --no-proc-cleaning to disable the scrubbing of stored procedure definitions.
Improved stored procedure scrubbing procedures. Stripping out "IF NOT EXISTS" from the CREATE command (the engine apparently saves this text if used).
April 8, 2019
Myschema:
Added owner names to the referenced table in foreign keys.
Added AS "owner" to the REVOKE ALL FROM public statements generated for every table.
Fixed an issue with referencing constraint output produced with -F.
March 16, 2019
Fixed some compile time warnings from the newest GCC compiler versions in several utilities.
dostats_ng.ec
Improved some error handling.
Myschema:
Added support for new v14.10 features. New options --replace-procs, --replace-views, and --replace-triggers to generate create statements for these types of objects using the new CREATE OR REPLACE syntax.
February 6, 2019
dostats_ng.ec:
Fixed issues with routines that have OUT and/or INOUT parameters and improved some error handling.
Thanks to Rick Fahey helping track this down.
myschema:
Fixed problem with RENAME INDEX statements that include the owner.