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. | |
| -homeDir | N/A | MAD_HOMEDIR; location of the operational server instance. 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 |