IIUG Utils2_ak

My most useful and most frequently downloaded utilities package. It contains those DBA utilities for users of Informix Dynamic Server database engines that I use all of the time.

Features

myschema - My replacement for Informix dbschema with many additional features
dostats - My utility to manage server data distributions and statistics. The gold standard for this purpose.
dbcopy - Copy data from table to table quickly between databases and even between server instances. It can even copy data between tables in databases with different logging levels.
dbdelete - Delete massive numbers of rows from a table quickly with filter control and without risking long transactions.
dbmove - Similar to dbcopy, but can copy some data types that dbcopy cannot cope with.
dbstruct - Create data structure definitions based on the tables in a database for C, C++, FORTRAN 90, 4GL, etc.
sqlstruct - Create data structures to support one or more SQL SELECT, INSERT, UPDATE, or DELETE statements.
drive_dostats - Script to divide the tables in a database to process multiple tables in parallel using multiple copies of dostats.
listdb7 - List the databases managed by a server instance with optional details including: logging level, tables, indexes, etc.
dbsavail - Report on dbspaces size, used and free space in pages, KB, or percentages with various sort options.
dbping - Quick check for connectivity to a server with round-trip connect timing.
ul - Binary data load/unload utility. Can unload the contents of a table to a file in a compact and portable binary format. Optional format is compatible with INFORMIX mode external table files.
printfreeB - Produces a report similar to an oncheck -pT report.