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 README.1st - Reports what features and fixes are included in each utility.īUILDING - Describes how to build utils2_ak on each platform and compiler environment. File 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). Sqlstruct.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 Janurelease.ĭ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 IBM Data & AI Roadmaps ( ) - Use this site to view roadmaps for Data & AI products.Utils2_ak is my primary package of utilities. I BM Unified Ideas Portal ( ) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas. Welcome to the IBM Ideas Portal ( ) - Use this site to find out additional information and details about the IBM Ideas process and statuses. Specific links you will want to bookmark for future use Get feedback from the IBM team to refine your idea Take a look at ideas others have posted and upvote them if they matter to you, Post ideas and requests to enhance a product or service. If you can't find what you are looking for, Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. Start by searching and reviewing ideas and requests to enhance a product or service. We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all ( public) or visible only to you and IBM ( private), use the I BM Unified Ideas Portal ( ). This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |