The maddbx utility allows for database operations to retrieve information about a database, create or delete tables and indexes, along with several other database-related operations.
Option | Type | Description | Default |
---|---|---|---|
-numTabs | Number of tables | NONE | |
-tabList | Table name (or names) for operation. Use ALL for all tables, or specify individual tables by name (for example, mpi_memstat). | NONE | |
-colList | tabName | Columns for table ‘tabName' | NONE |
-idxList | tabName | Indexes for table ‘tabName' | NONE |
-numcols | tabName | Number of columns for table ‘tabName' | NONE |
-numidxs | tabName | Number of indexes for table ‘tabName' | NONE |
-numrows | tabName | Number of rows of specified tables | NONE |
-crTable | tabName | Creates table ‘tabName' | NONE |
-drTable | tabName | Deletes table ‘tabName' | NONE |
-crIndex | idxName | Creates index ‘idxName' | NONE |
-drIndex | idxName | Deletes index ‘idxName' | NONE |
-crTabIdx | tabName | Creates all indexes for table ‘tabName' | NONE |
-drTabIdx | tabName | Deletes all indexes for table ‘tabName' | NONE |
-optimize | tabName | Optimize specified tables or ALL tables. This command is used as a starting point for table optimization. It is a generic command based on default optimizer settings. The effectiveness of the command could vary depending on the optimizer settings in place for that implementation. If table optimization is not achieved by running this command, contact the responsible database administrator to update statistics in a manner tailored to the optimizer settings in place for that implementation. |
NONE |
-loadunl | tabName | Loads table ‘tabName' from .unl file* | NONE |
-unload | tabName | Unloads table ‘tabName to a .unl file | NONE |
-rebuild | tabName | Rebuilds (creates the table and indexes) for table ‘tabName | NONE |
-truncate | tabName | Truncates (deletes all data) from table ‘tabName' | NONE |
-sqlexec | sqlFile | Runs commands from an SQL file. | NONE |
These next arguments are additional arguments for –loadunl: | |||
-onepass | Implies –truncate, -loaddata, -index | ||
-truncate | Truncate tables only | ||
-loaddata | Load data information table (or tables) only | ||
-index | Index table (or tables) only | ||
-useint | Use internal loader instead of the database utility. For improved performance, use the internal loader. | ||
-remote | Database is remote | ||
-maxErrs | Maximum number of “per-table” errors allowed before ending | ||
-commitSize | Number of records processed between commits | ||
-otherArgs | Additional arguments to database utility | ||
-rootDir | MAD_ROOTDIR; location of IBM® Initiate® Master Data Service software. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | ||
-homeDir | MAD_HOMEDIR; location of a Master Data Engine instance. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | ||
-connStr | MAD_CONNSTR; ODBC connection string | ||
-objCode | MAD_OBJCODE; restrict command to table or index that belongs to this object. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | ||
-dbtype | MAD_DBTYPE; native database name. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | ||
-dbServer | MAD_DBSERVER; native database server. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | Optional if not using native | |
-dbname | MAD_DBNAME; native database name. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | Optional if not using native | |
-dbuser | MAD_DBUSER; native database user ID. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | Optional if not using native | |
-dbpass | MAD_DBPASS; native database password. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | Optional if not using native | |
-ddlfile | MAD_DDLFILE; data definition file. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | Optional based on command | |
-stofile | MAD_STOFILE; storage definition file. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | Optional | |
-unldir | MAD_UNLDIR; load or unload .unl directory. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | Optional based on command | |
-tabPfx | MAD_TABPFX; table and index name prefix. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | Optional | |
-tabSfx | MAD_TABSFX; table and index name suffix. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | Optional | |
-encoding | MAD_ENCODING; encoding of .unl files; options are: UTF8, UTF16, or LATIN1. The environment variable setting for this option (shown in uppercase) can be used in place of the command-line options. | LATIN1 | |
-noexec | Show SQL statements only; no execution is processed | NONE | |
-help | List help information | NONE | |
-version | List version number | NONE |
Related concept