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