Assess a DB2 LUW database

In the assessment of a DB2 LUW database, objects and SQL statements of the database are assessed. To assess the objects of a DB2 LUW database, you must copy the objects and convert them into files.

Prerequisites

OceanBase Migration Assessment (OMA) is installed. For more information, see Install OMA.

Run the assessment command

Go to the installation directory of OMA and run start.sh with reference to the following sample statement. For more information about the parameters in the statement, see Product form. In Microsoft Windows, replace sh bin/start.sh with start.bat.

• Object assessment

  sh bin/start.sh \
  # The task name, which can be set to any value.
  --name textTest \
  # The assessment mode. ANALYZE_TOTAL indicates a database assessment.
  --mode ANALYZE_TOTAL \
  # The assessment type. Valid values: OBJECT and SQL. OBJECT indicates the assessment of objects. SQL indicates the assessment of SQL statements.
  --analyze-types OBJECT \
  # The data source. TEXT indicates a text file.
  --from-type TEXT \     
  # The delimiter that separates statements in the file.
  --sql-delimiter ; \    
  # The assessment mode.
  --evaluate-mode SOURCE_TARGET \
  # The path of the source file.
  --source-file db2look.sql \  
  # The type of the source database.
  --source-db-type DB2LUW  \        
  # The version of the source database.
  --source-db-version 11.1  \        
  # The schema to be assessed.
  --schemas TEST \
  # The type of the destination database.
  --target-db-type OBORACLE \    
  # The version of the destination database.
  --target-db-version 3.1.20
  

• SQL statement assessment

  sh bin/start.sh \
  # The task name, which can be set to any value.
  --name testDB2 \
  # The assessment mode. ANALYZE_TOTAL indicates a database assessment.
  --mode ANALYZE_TOTAL \
  # The assessment type.
  --analyze-types SQL \
  # The data source. DB indicates a database.
  --from-type COLLECT \     
  # The assessment mode.
  --evaluate-mode SOURCE_TARGET \
  # The type of the source database.
  --source-db-type DB2LUW \        
  # The version of the source database.
  --source-db-version 11.5.0 \        
  # The IP address of the source database.
  --source-db-host 10.10.10.1 \        
  # The port number of the source database.
  --source-db-port port \        
  # The username of the source database.
  --source-db-user username \        
  # The password of the source database.
  --source-db-password password \        
  # The name of the source database.
  --source-db-name dbname \   
  # The type of the destination database.      
  --target-db-type OBORACLE \    
  # The version of the destination database.
  --target-db-version 3.1.20 \    
  # The time when the data collection starts.
  --collect-start-time 2021-11-19 00:00:00 \    
  # The time when the data collection ends.
  --collect-end-time 2021-12-20 00:00:00
  

After you run the preceding commands, you can view the progress in real time.

View assessment reports

After the assessment is completed, OMA generates an assessment report in the .pdf format in the report directory and an assessment report in the HTML format in the reportTool directory.

• To view the assessment report in the .pdf format, go to the report directory and open the PDF file of the name in the path displayed in the CLI.

• To view the assessment report in the HTML format, perform the following operations:

  1. Go to the reportTool directory, double-click the index.html file.

  2. On the page that appears, click Authorize and View Report.

  3. Select and open the oma.sqlite file.

     Generally, the oma.sqlite file is stored in the db folder under the root directory of OMA.

  4. On the page that appears after you open the oma.sqlite file, click Select Report in the upper-right corner and select the migration assessment report that you want to view from the drop-down list.