IIUG Utils2_ak

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.

Follow IIUG Utils2_ak

IIUG Utils2_ak Web Site