![]()
The package includes a file, scripts_doc.txt, describing each script.Īdded new options export-binary and import-binary to generate only Scripts_ak: This package contains 17 scripts that I have found to be particularly useful. It includes a stored procedure, ratios(), that is installed in sysmaster and a script, newratios.ksh, that retrieves the data calculated by the ratios proc and formats a report. Ratios.shr_ak is a package of metric calculations that I use to quickly evaluate the health of a running Informix system. Myimport - Drop in replacement for dbimportįrom_external.awk - Used by myimport to pre-process a dbexport data set for loading via external tables. Myexport - Drop in replacement for dbexport 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 binary export and import (not compatible with 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. Myexport is my replacement for dbexport and dbimport. Tells what changes need to be made to the makefiles for #Import from dbschema file informix how toREADME.1st - Reports what features and fixes are included in each utility.īUILDING - Describes how to build utils2_ak on each platform and compiler environment. #Import from dbschema file informix portableFile format is compatible with external table "INFORMIX" format and portable between processor Ul.ec - A binary file unload/load utility. Options to generate C, C++, ESQL/C, 4GL, or SQL DDL (for SELECT). #Import from dbschema file informix updateSqlstruct.ec - Generate data structures from SQL statements including input and output structures for SELECT, INSERT, DELETE, and UPDATE statements. PrintfreeB.ec - Print out a table detail report similar to oncheck -pT Does everything that dbschema does except display data distributions (dbschema -hd) and much more. ![]() Myschema - My dbschema replacement utility. Mydbdiff - Script to compare two schema files or a schema file to a live schema. ![]() Listdb7.ec - Displays details about your databases and tables and indexes. If you have the cores to spare, get the job done Runs multiple copies of dostats updating a subset list of your tables. The original dostats.ec source is included for servers older thanĭrive_dostats - Divide and conquer. ![]() Optional chunk detail.ĭbscript.ec - Generate SQL, scripts, or OS commands to run against all or some of the tables in your database.ĭbstruct.ec - Generate data structures from your database for C, C++, ESQL/C, Structured FORTRAN, or x4GL.ĭostats_ng.ec - The original and still the best way to automate your update statistics runs. Reports used and free space in pages, KB, and percent. Can copy some data that dbcopy cannot.ĭbsavail.ec - Summary dbspace report. Without worrying about long transaction rollbacks.ĭbdelete.ec - Delete large amounts of data from a table FAST without risking long transaction rollbacks.ĭbmove.ec - Another data copy utility using the methods the dbdelete uses. These reports are important for testing DBPATH, connection groups, and Connection Manager behavior as well as verifyingĭbcopy.ec - Copy data from table to table directly across databases, servers, instances, versions, even between databases at different logging levels This is the Septemrelease.ĭbping.ec - Tests connections and reports connection time as well as the actual host and servername connected as well as which alias was used for Utils2_ak is my primary package of utilities. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |