Art's Utilities Download Page
Latest Gamma Level Releases
Utils2_ak is my primary package of utilities. This is the November 7, 2018 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:
November 7, 2018
New option --rename-auto-index=<table matches> generates RENAME INDEX statements for
auto-named (constraint) indexes. Works with -K to generate short or longer names.
July 16, 2018
myschema
Updated option:
Enhanced the --passwd option. If password passed to this option (or using the PASSWD
environment variable) begins with the at sign (@) character the rest of the string is treated
as a file path containing the password on the first line. The file must be owned by the actual
user executing myschema and have 0600 privilege or myschema will reject the file with a
simple error message. This allows for a more secure way to use username authentication in
a non-trusted environment. Thanks to David Link for suggesting this feature change.
June 22, 2018
myschema
New options: -
--use-database-owner - Generate all objects owned by the current owner of the database.
--use-table-owner - Generate table-dependent objects owned by the owner of the table.
These first two options go along with --set-owner=owner, and -O (strip all owner names)
--constraint-file=file - Place constraints in the named file. This one is used with --primary,
--secondary, --index-file, --grant-file, --view-file, --trigger-file, --procedure-file, and
--distributions-file. Fixed some problems with the partial schema file output. Expanded
"owner"s to all objects.
April 18, 2018
dostats_ng.ec:
Fixed handling of stored procedures with UDT parameters (ex: timeseries).
April 8, 2018
myschema
Fixed RANGE/INTERVAL output to suppress automatic partitions (not needed). Removed extent and lock mode clauses from virtual table definitions. Changed to generate INSTEAD of triggers before GRANT statements for VIEWs to eliminate errors at create time from grants to multi-table
views.
dbsavail.ec
New options: -H specify server to connect to, -R reverse sort order, -F explicit option for default sort order (by free space), hidden option, -E, to SET EXPLAIN for debugging. Also new options: -K, -M, -G to display total, used, & free space in KB, MB, or GB respectively.
January 9, 2018:
Myschema
Fixed PLOG dbspace output in --infrastructure runs.
ul.ec
Housekeeping.
dbsavail.ec
Made the dbspace name column dynamically sized based on the longest dbspace name.
October 24, 2017:
Myschema
Fixed BIGSERIAL and SERIAL8 current value output on 32bit compilers.
August 2017:
Myschema
Fixed a bug affecting --noags_procs and worked around a change in the way the latest GNU C compilers treat inline functions that might prevent linking.
July 11, 2017:
Myschema:
Fixed a bug that causes myschema to hang on exit on some AIX versions when it exits while not connected to the database (usually when printing usage or version info).
July 9, 2017
Mydbdiff :
Fixed a typo that prevented execution.
Myschema:
Fixed a nasty bug that only affects users with Informix v11.xx running myschema with the --myexport-express or --myexport-schema options (usually when using myexport). The bug causes fragmentation expressions in the CREATE TABLE statements to be generated without named partitions where such are named in the source database.
Dostats_ng.ec:
The May 24th, 2017 release fixes a problem affecting non-logged databases. Dostats was trying to set an isolation level which is not valid in a non-logged database.
The April 20th, 2017 release adds the capability to use a list file created in Windows with embedded carriage returns as the file argument to -i and -e.
The February 26th 2017 release includes an update to the -Z option to be able to specify SAMPLING SIZE for MEDIUM mode distributions as a percentage of rows in the table. Values <= 1.0 are treated as a percentage of rows to be sampled. Values over 1.0 are treated as a minimum row count to sample.
December 14, 2016 Dostats adds --include-owner to get around problems compiling stored procedures named after key words (ex: null(), hour(), etc.).
Myexport:
The December 14th release includes a new option: -n enables the myschema --no-check and --no-validate options (requires myschema source revision 2.349 or later). This sets foreign key and check constraints to NOVALIDATE and enables creating indexes and constraints after the data is loaded (-m).
Myschema:
The May 24th, 2017 release adds new file handling options permitting the user to break up the types of DDL into separate files. Files can now be specified independently for indexes, procedures and functions, triggers, views and synonyms, grant and revoke statements, and for update statistics commands. They are, respectively: --index-file, --procedure-file, --trigger-file, --view-file, --grant-file, --distributions-file. Also the --primary and --secondary options have been enhanced to work more smoothly together and with the new options.
The May 3, 2017 release fixes handling of temp smart blobspaces in both modes of the --infrastructure output.
The April 5th, 2017 release fixed a bug affecting timeseries type columns.
The December 14th release includes two new myschema features --no-check to generate CHECK constraints with the new NOVALIDATE option which is useful when migrating data that is pre-validated. Added support to --infrastructure for unencrypted storage spaces when encrypted storage is enabled (v12.10.xC8 and later). Extended --keep-generated-names support to check constraints.
The November 27th release includes a new myschema feature. --keep-generated-names names constraints with auto-generated names using the generated names (though the engine will downshift them). The default behavior is to not name auto-named constraints so that a new name is generated at create time. Also fixed a bug affecting certain UNIQUE constraints.
The July 28, 2016 release fixes a bug in the new --myexport-escape option.
Other utils2_ak utility news:
The November 16, 2016 release updates the Usage for dbsavail to display the -d option. The -d option causes dbsavail to display details of the chunks making up each dbspace. Also improved the sort order display strings in the report output.
The October 14, 2016 release adds new options to dbsavail.ec. The new -N, -S, & -P options allow the user to specify that the report be sorted in dbspace name, size (in KB), or percent free rather than the default ordering by free KB.
The September 15, 2016 release adds two options to dbstruct.ec. Also extended support for extended types as best I can to all output formats. The new -D output format generates SQL DDL for the requested table(s). If you just need the CREATE statement for your tables and nothing else, this tends to be faster than debschema/myschema. The new -M option outputs the structure for each table to its own file named <database>.<table>.<extension> where extension defaults to .c, .ec, .ftn, .4gl, or .sql as appropriate to the output format. If you specify the extra argument at the end of the command line this overrides the default file extension.