Help Center> Database and Application Migration UGO> User Guide> Object Migration> Editing Conversion Configurations> Editing the Configurations During Migration from DB2 to GaussDB
Updated on 2022-11-15 GMT+08:00

Editing the Configurations During Migration from DB2 to GaussDB

Symptom

Feature Name

Recommended Setting

In DB2, the BLOB data type can store a maximum of 2 GB data. In GaussDB V5R2, the BLOB data type can store a maximum of 1 GB data.

BLOB show error

No error information is displayed.

In DB2, the CLOB data type can store a maximum of 2 GB data. In GaussDB V5R2, the CLOB data type can store a maximum of 1 GB data.

CLOB show error

No error information is displayed.

GaussDB V5R2 does not support GRAPHIC. You can convert GRAPHIC to the character string type.

GRAPHIC

Do the migration and convert the data type to NVARCHAR2.

GaussDB V5R2 does not support DBCLOB. You can convert DBCLOB to CLOB.

DBCLOB

Do the migration and convert the data type to CLOB.

GaussDB V5R2 does not support DECFLOAT. You can convert DECFLOAT to DOUBLE PRECISION.

DECFLOAT

Do the migration and convert the data type to DOUBLE PRECISION.

GaussDB V5R2 does not support XML. You can convert XML to a data type compatible with GaussDB V5R2.

XML

Do the migration and convert the data type to TEXT.

The TABLESPACE syntax of GaussDB V5R2 is different from that of DB2. You can comment the TABLESPACE syntax of DB2 or use the corresponding syntax instead.

TABLESPACE

Replace TABLESPACE.

If the user does not exist, GaussDB V5R2 does not support AUTHORIZATION during schema creation.

AUTHORIZATION in Create Schema statements

Comment AUTHORIZATION

GaussDB V5R2 supports partial CACHE in sequences.

CACHE in sequences

Comment CACHE in sequences.

GaussDB V5R2 does not support ORDER in sequences.

ORDER in sequences

Comment ORDER in sequences.

GaussDB V5R2 does not support RANDOM in indexes.

RANDOM in indexes

Comment RANDOM in indexes.

GaussDB V5R2 does not support CLUSTER in indexes.

CLUSTER in indexes

Comment CLUSTER in indexes.

GaussDB V5R2 does not support LONG TABLESPACE in tables.

LONG TABLESPACE in tables

Comment LONG TABLESPACE in tables.

GaussDB V5R2 does not support ORGANIZE BY in tables.

ORGANIZE BY in tables

Convert ORGANIZE BY to ORIENTATION.

GaussDB V5R2 does not support WITH CHECK OPTION in CREATE VIEW statements.

WITH CHECK OPTION in views

Comment WITH CHECK OPTION.

GaussDB V5R2 does not support ROW MOVEMENT in CREATE VIEW statements.

ROW MOVEMENT in views

Comment ROW MOVEMENT

GaussDB V5R2 does not support DATA CAPTURE in CREATE SCHEMA statements.

ATA CAPTURE in CREATE SCHEMA statements

Comment DATA CAPTURE

GaussDB V5R2 does not support SELECT in INSERT statements.

SELECT in INSERT statements

Migrate SELECT statements

GaussDB V5R2 does not support ORDER BY in UPDATE statements.

ORDER BY in UPDATE statements

Comment ORDER BY in UPDATE statements.

GaussDB V5R2 does not support OFFSET in UPDATE statements.

OFFSET in UPDATE statements

Comment OFFSET in UPDATE statements.

GaussDB V5R2 does not support FETCH in UPDATE statements.

FETCH in UPDATE statements

Comment FETCH in UPDATE statements.

GaussDB V5R2 does not support ORDER BY in DELETE statements.

ORDER BY in DELETE statements

Comment ORDER BY in DELETE statements.

GaussDB V5R2 does not support OFFSET in DELETE statements.

OFFSET in DELETE statements

Comment OFFSET in DELETE statements.

GaussDB V5R2 does not support FETCH in DELETE statements.

FETCH in DELETE statements

Comment FETCH in DELETE statements.

GaussDB V5R2 does not support INCLUDE in INSERT statements.

INCLUDE in INSERT statements

Comment INCLUDE in INSERT statements.

GaussDB V5R2 does not support INCLUDE in DELETE statements.

INCLUDE in DELETE statements

Comment INCLUDE in DELETE statements.

GaussDB V5R2 does not support INCLUDE in UPDATE statements.

INCLUDE in UPDATE statements

Comment INCLUDE in UPDATE statements.

GaussDB V5R2 does not support QUERY OPTIMIZATION in CREATE VIEW statements.

QUERY OPTIMIZATION in CREATE VIEW statements

Comment ENABLE QUERY OPTIMIZATION

GaussDB V5R2 does not support COMMENT for synonyms.

COMMENT

Comment entire statements.

The converted objects are parsed based on the syntax of GaussDB V5R2. Check whether the conversion is correct.

Parse Converted SQL.

Ignore parsing.