MTK Parameter

Parameter

excludeSysTable

Type: []string

Desc: Exclude system object definitions. If not configured, use the default value

Example:

DB2 Exclude System Table example

{
  "excludeSysTable": [
    "EXPLAIN_ACTUALS",
    "ADVISE_TABLE",
    "ADVISE_PARTITION",
    "ADVISE_MQT",
    "ADVISE_WORKLOAD",
    "ADVISE_INDEX",
    "ADVISE_INSTANCE",
    "OBJECT_METRICS",
    "EXPLAIN_DIAGNOSTIC_DATA",
    "EXPLAIN_DIAGNOSTIC",
    "EXPLAIN_STREAM",
    "EXPLAIN_PREDICATE",
    "EXPLAIN_OPERATOR",
    "EXPLAIN_OBJECT",
    "EXPLAIN_ARGUMENT",
    "EXPLAIN_STATEMENT",
    "EXPLAIN_INSTANCE"
  ]
}

enableSyncCompTabPro

Type: bool

Desc: Indicates whether to generate a DDL with the table compression.

Default: false

tableOptions

Type: map[string]string

Desc: Configure the Add table attributes when creating a table option. For the time being, only openGauss/MogDB is supported.

• openGauss/MogDB create table xxx() with (xx);

Parameters are not case-sensitive. When using regular expressions, you need to pay attention to the order. As long as the first one is satisfied, the match will not continue

• "*" // Migrate all tables in the object
• "Schema1.*" // Migrate all tables under Schema1 in the object
• "Schema1.TABLE_1" // only Schema1.TABLE_1 table add option

special option value remove

compression=remove The compression attribute is removed

Default: null

Example:

Table Options Example

{
  "tableOptions": {
    "*": "orientation=row, compression=no",
    "schema1.*": "orientation=row, compression=no",
    "schema1.table_1": "orientation=row, compression=no"
  }
}

Table Options Regexp Example

{
  "tableOptions": {
    "schema1.table_1": "orientation=row, compression=no",
    "schema1.table_duty_log*": "orientation=row, compression=no",
    "schema1.^table_duty_log*": "orientation=row, compression=no",
    "schema1.*": "orientation=row, compression=no",
    "*": "orientation=row, compression=no"
  }
}

Add: v2.3.2

indexOptions

Type: map[string]string

Desc: As with the tableOptions option configuration, it only takes effect for indexes.

Default: null

Add: v2.3.2