Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Command Center for Db2 13.2

Setting Schema Management options

You can use the Options button configuration-24.png (in the New console, click NW_gear.png) to set optional behavior for the Schema Management feature. These settings also serve as the default option settings for all new Schema Compare views.

Note

You can override the options settings for a specific Schema Compare View in the Define a Comparison wizard. For more information, see Comparing-two-schemas.

You can specify the following options:

 

Option

Description

Default value

Use European format for decimal numbers (EURO)

Select whether to use the European decimal format (1.234.567,89).

This value corresponds to the Change Manager EURO installation option.

No

Use padded values for columns of type VARCHAR (PADDED)

Select whether to pad VARCHAR values.

This option corresponds to the Change Manager OVERRIDE( IXPADDEDY ) and OVERRIDE( IXPADDEDN ) ALUIN keywords, and to the PADIX DSNZPARM.

No

Include the primary key constraint in the scope

Select whether to include the primary key constraint in the scope.

This option corresponds to the Change Manager OVERRIDE( KEEP-ALL-PRIMARY ) ALUIN keyword.

No

Include white spaces in native SQL stored procedure comparisons

Select whether to include white spaces in native SQL stored procedures.

This option corresponds to the Change Manager CMPSPTXT installation option, and the SPTEXT( EXACT ) or SPTEXT( NOEXACT ) ALUIN keyword.

Yes

CCSID

Select the default encoding scheme for databases that are created.

This option corresponds to the Change Manager CCSID installation option.

EBCDIC

CISIZE

Select N to create VSAM data sets with a control interval size (CISIZE) of 4 KB, regardless of the page size (buffer pool size) of the table space. Select Y to support larger CISIZE values.

This option corresponds to the DSVCI DSNZPARM.

Blank

Length of inline LOB columns

Enter a value for the inline LOB column.

This option corresponds to the LOB_INLINE_LENGTH DSNZPARM.

0

OVERRIDE

Enter one or more space-separated Change Manager OVERRIDE keywords (maximum of 57 characters).

Note

Do not enclose the OVERRIDE keywords between parentheses.

For more information, see OVERRIDE-keywords.

NA

Enable Trace

(Available in the Classic console only)

Select whether to include informational messages. Consult with BMC Customer Support before using this option.

No

Related topics

Comparing-Db2-schemas

OVERRIDE-keywords



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*