madhubdrop utility
The madhubdrop utility drops the database tables and indexes of an MDM installation.
Before you run a utility, make sure that you have set the necessary operational server environment variables. For information about the variables, see the operational server environment variables topic.
| Option | Type | Description | Default |
|---|---|---|---|
-database |
N/A | Create a database for IBM® DB2® for z/OS®. If you are using DB2 for z/OS, you must use this option to create the database. | NONE |
-tablespace |
N/A | Create table space settings. If you are using DB2 fpr z/OS, you must use this option to specify table space settings. | NONE |
-confirm |
N/A | Required to confirm execution of drop command | NONE |
-noExec |
N/A | Show SQL statements only; no execution is processed | NONE |
-verbose |
N/A | Show progress information | NONE |
-help |
N/A | List help information | NONE |
-version |
N/A | List version number | NONE |
-rootDir |
N/A | MAD_ROOTDIR; location of the MDM software.
The environment variable setting for this option (shown in uppercase)
can be used in place of the command-line options. |
|
-connStr |
N/A | MAD_CONNSTR; ODBC connection string. The environment
variable setting for this option (shown in uppercase) can be used
in place of the command-line options. |
|
-dbType |
N/A | 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 |
N/A | 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 |
N/A | 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 |
N/A | 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 |
N/A | 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 |
-encoding |
N/A | 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 |