Technical Blog Post
Abstract
MDM Post Install Configuration Targets - recreate_database
Body
Target recreate_database
Helps you obtain a vanilla instance of the MDM database with the gold data.
When to use:
- In test instances, where test data has to be removed and the instance can be re-used.
- In cases where database load failed during MDM configuration, due to issues like missing tablespace(s)
Please Note:
All tables in the schema in which MDM is configured will be dropped. A vanilla instance of the MDM database will be created containing database objects and gold data that come with the MDM installer. Customizations and rows inserted on a functional MDM instance will be lost. Hence, It is adviced to use this target in Development and Test instances only.
Invocation:
When the operating system is Windows:
- Go to <MDM_INSTALL_DIR>/mds/scripts
- Invoke madconfig recreate_database
In other operating systems
- Go to <MDM_INSTALL_DIR>/mds/scripts
- Invoke ./madconfig.sh recreate_database
Inputs obtained:
- The database password
- The WebSphere Application Server administrator user password
Other details on database configuration are obtained from mdm_install.properties found in <MDM_INSTALL_DIR>/properties folder. (In MDM v11.4 FP3 and MDM v11.5, other details are obtained from <MDM_INSTALL_DIR>/properties/db.properties)
Tasks performed:
- Obtains user consent to proceed with database recreation
- Stops the server
- Drop all the triggers, foreign keys, indexes, sequences and tables in the given database schema.
- Removes and creates the ODBC Data Source
- Creates Virtual MDM database objects and populates Virtual MDM data
- Create Physical MDM database objects and populates gold data
- Updates the Configuration tables with the instance details
- Starts the server
Please Note: This target does not drop or create tablespaces
Logs:
Logs can be found at
- <MDM_INSTALL_DIR>/logs/madconfig
- <MDM_INSTALL_DIR>/logs/madconfig/java
- <MDM_INSTALL_DIR>/logs/database
- <MDM_INSTALL_DIR>/mds/log
Available in:
- MDM v11.4 FP3
- MDM v11.5
- MDM v11.6
UID
ibm11142104