Follow the steps to manually upgrade the version 11.0 MDM
database on Oracle to the version 11.3 MDM database. For information
about upgrading the database for previous releases, see the links
at the end of this topic.
Before you begin
Read the content of the link at the end of this topic about
manual installation of the database.
For Oracle, the use of
table spaces for data, indexes and LOBs, such as CLOBs or XML, to
improve database performance is supported. Look for the following
placeholders in the scripts: <TABLE_SPACE>, <INDEX_SPACE>,
and <LONG_SPACE>.
Procedure
- Replace the placeholder <SCHEMA> in
the scripts in the following folders with a schema name or owner.
Ensure that the name or owner is in uppercase. CODE_LANG in
the folder name is the language that is currently installed.
Note: If
any of the directories are empty, no data was generated and you do
not need to run the scripts.
- MDM_INSTALL_HOME/database/Upgrade/11.3.0/Level-I/Oracle/Standard/ddl/data_req_CODE_LANG/data
- MDM_INSTALL_HOME/database/Upgrade/11.3.0/Level-I/Oracle/Standard/ddl/data_CODE_LANG/data-industry
- MDM_INSTALL_HOME/database/Upgrade/11.3.0/Level-I/Oracle/Standard/ddl/data_opt_CODE_LANG/data
- To load the common data, to load the English code table
data, and to configure the table in the language that you selected,
run the following script in the MDM_INSTALL_HOME/database/Upgrade/11.3.0/Level-I/Oracle/Standard/ddl/data_req_CODE_LANG/data directory
from the command line. Use the command: sqlplus <SCHEMA>/<SCHEMAPASSWORD>@<DBNAME>
@<script_name> >> <log_file_name>
- The insert.sql script inserts new
data.
- The update.sql script updates existing
table data.
- The delete.sql script deletes obsolete
table data.
If you are loading English data only, set CODE_LANG to en.
Otherwise, set CODE_LANG to the
language code of the language you are loading.
- To load the English industry data, run the scripts in the MDM_INSTALL_HOME/database/Upgrade/11.3.0/Level-I/Oracle/Standard/ddl/data_en/data-industry directory
from the command line. Use the command: sqlplus <SCHEMA>/<SCHEMAPASSWORD>@<DBNAME>
@<scriptname> >> <log_file_name>
- The insert.sql script inserts new
data.
- The update.sql script updates existing
table data.
- The delete.sql script deletes obsolete
table data.
- If you are loading data for a language other than English,
run the scripts in the MDM_INSTALL_HOME/database/Upgrade/11.3.0/Level-I/Oracle/Standard/ddl/data_<CODE_LANG>/data-industry directory
from the command line: sqlplus <SCHEMA>/<SCHEMAPASSWORD>@<DBNAME>
@<scriptname> >> <log_file_name>
- The insert.sql script inserts new
data.
- The update.sql script updates existing
table data.
- The delete.sql script deletes obsolete
table data.
- If you are loading code table data for a language other
than English, run the scripts in the MDM_INSTALL_HOME/database/Upgrade/11.3.0/Level-I/Oracle/Standard/ddl/data_opt_CODE_LANG/data directory
from the command line: sqlplus <SCHEMA>/<SCHEMAPASSWORD>@<DBNAME>
@<scriptname> >> <log_file_name>
- The insert.sql script inserts new data.
- The update.sql script updates existing table
data.
- The delete.sql script deletes obsolete table
data.
- Repeat the previous two steps for each non-English language
that is installed.
- Navigate to the MDM_INSTALL_HOME/database/Upgrade/11.3.0/Level-I/Oracle/Standard/ddl/ directory.
- Edit the script ImpReqDataCfgMgr_ora.script and
replace all placeholder values with the actual values for your environment.
- Run the script ImpReqDataCfgMgr_ora.script.
- Run the following command: sqlplus <SCHEMA>/<SCHEMAPASSWORD>@<DBNAME>
@QryUpdCfgMgrData_ora.sql >> <log_file_name> The QryUpdCfgMgrData_ora.sql script
populates the Configuration Manager values based on previous InfoSphere® MDM version
11.3 deployment values.
What to do next
Complete the manual database upgrade to
InfoSphere MDM 11.4 by
upgrading from version
11.3 to
11.4.