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 ALTER and BMC AMI Change Manager for Db2 13.1.

Overrides of the Analysis parameters

The Analysis Input Stream Parameters panel provides a way for you to select optional parameters to be included in the ALUIN input stream for the Analysis component.

The following figures show the Analysis Input Stream Parameters panel for a migrate-type work ID.

ALUFOAN39 ---------------- Analysis Input Stream Parameters --------------------
Command ===>

Type information. Then press Enter to continue or PF12 for previous panel.

Select any of the following analysis parameters.
_ ENV             Display installation environment
_ PKEYPROP        Propagate parent key changes to foreign keys
_ VALWARN         Display errors as warnings for conditions in text
_ VVALPROP        Propagate table column changes to base views
_ NOORDERBY       Omit the ORDER BY clause for unloads in the worklist
_ NOUNLOADEMPTY   Do not unload tables that IBM RUNSTATS indicates are empty
_ STOPCOMMIT      Generate an AT(COMMIT) statement for every STOP command
_ DEFERUNIQUEIX   Create unique indexes with DEFER YES
_ CISIZE4K        Create all VSAM data sets with a CISIZE of 4 KB
_ PARALLEL        Enable worklist parallelism
_ SINGLEPHASE     Omit the -STOP command between phases of a migrate worklist
_ APPLCOVR        Include APPLCOMPAT overrides in worklist
_ LOSTERROR       Escalate lost objects messages from warnings to errors

Commands:  HELP END PREVIOUS

 The options are defined as follows:

Option

Description

Display installation environment

Inserts the ENV keyword into the ALUIN input stream. This option provides additional diagnostics about the processing for Analysis and lists the keywords and the values in the installation options module. This option is also used to provide information to BMC Support.

Propagate parent key changes to foreign keys

Inserts the PKEYPROP keyword into the ALUIN input stream

Analysis provides a feature called parent key propagation. If you specify changes to the following elements of a column in a parent key and parent key propagation is enabled, Analysis propagates those changes throughout the Db2 system to any foreign key columns that reference the original parent key:

  • Data type
  • Length
  • Scale
  • Field procedure
  • Field procedure parameters

Note

If any of the foreign key columns are also used in the parent key of the table, changes are recursively propagated.

Display errors as warnings for conditions in text

Inserts the VALWARN keyword into the ALUIN input stream. Analysis flags errors in the trigger, view, materialized query table (MQT), or index text, but still creates a worklist. The errors are treated as warnings.

Note

You must correct the errors, verify the text and qualifiers in the worklist, or set the owner to the correct value before you execute the worklist. Otherwise, Execution fails.

Propagate table column changes to base views

Inserts the VVALPROP keyword into the ALUIN input stream. Select this option to propagate table column changes to base views. A base view is a view that contains all of the columns of one table in the same order and with the same names. A base view does not contain a WHERE clause.

For base views only, you can propagate the following table column changes when you select this option:

  • Column order
  • Addition of columns
  • Deletion of columns

A base view must meet the following criteria for Analysis to propagate the changes:

  • If an explicit view column list or an explicit SELECT column list is specified for the view, the column lists must exactly match the column names from the table in the SELECT clause. The following figure shows an example.

Explicit view column list

CREATE TABLE.A
       (COL1 INTEGER,
        COL2 SMALLINT,
        COL3 CHAR(15))
    IN DB1.TS1;
CREATE VIEW VIEW.A (COL1, COL2, COL3)
    AS SELECT COL1, COL2, COL3
    FROM TABLE.A;

The name of each column in the view column list must be unique and unqualified.

  • If an implicit view column list or an implicit SELECT column list is specified for the view, the columns of the view inherit the names of the columns in the table in the SELECT clause. The following figure shows an example.

Implicit view column list

CREATE TABLE.A
       (COL1 INTEGER,
        COL2 SMALLINT,
        COL3 CHAR(15))
    IN DB1.TS1;
CREATE VIEW VIEW.B
    AS SELECT *
    FROM TABLE.A;

If you do not select the option to propagate table column changes to base views, the NOVVALPROP keyword is inserted into the ALUIN input stream. This keyword specifies not to propagate extended view text.

Omit the ORDER BY clause for unloads in the worklist

Inserts the NOORDERBY keyword into the ALUIN input stream. When the work ID is analyzed, Analysis omits the ORDER BY clause from the unloads in the worklist. If this option is not selected, the product includes an ORDER BY clause when a clustering index is present on the table that is being unloaded.

Note

When the NOORDERBY keyword is analyzed, the subsequent load is performed from an unsorted file. The keyword improves the performance of unloads. However, a reorganization and a rebuild might be necessary to improve the performance of the application.

Do not unload tables that IBM RUNSTATS indicates are empty

Inserts the NOUNLOADEMPTY keyword into the ALUIN input stream. When you select this option, the product does not build SYSR nnnn data sets in the JCL for empty tables. A table is empty when Db2 catalog statistics show that the cardinality of the table is 0 (zero).

If Analysis determines that the table is empty, it generates the -ISMT command in the worklist. The command is used to ensure that the table is still empty at Execution. Analysis also generates the -ISMT command in the worklist if the DEFINE parameter is set to NO for an index or a table space. UNLOAD and LOAD statements will not be generated for the table.

Analysis does not generate the -ISMT command if one of the following conditions exists:

  • A base table is incomplete

    A base table can be incomplete under the following conditions:

    • If the unique index for a ROWID column is missing
    • If the auxiliary table space, table, or index is missing
  • The Db2 catalog statistics show that the cardinality of the table is -1, which indicates that statistics do not exist

Generate an AT (COMMIT) statement for every STOP command

Inserts the STOPCOMMIT keyword into the ALUIN input stream.

Create unique indexes with DEFER YES

Ignores the uniqueness of an index when it determines whether the index can be created with DEFER YES. The product inserts the DEFERUNIQUEIX keyword into the ALUIN input stream for use in alter-type work IDs only. For alter-type work IDs, all indexes are created with DEFER YES.

Note

To create an index with the DEFER YES parameter, you must also select the BMC AMI Recover utility or the IBM REBUILD INDEX utility from the Analysis Utility Options panel. For information about using the Recover and Rebuild Utilities, see Using-utilities-with-ALTER-and-Change-Manager.

Create all VSAM data sets with a CISIZE of 4 KB

For VCAT-defined table spaces (partitioned, simple, segmented, and large object [LOB]), instructs Analysis 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. When you select this option, the product inserts the CISIZE4K keyword into the ALUIN input stream.

Note

The CISIZE4K keyword overrides the value that you specify for the Variable CISIZE field on the Tablespace Parts List panel or the Auxiliary Tablespace Attributes List panel.

For partitioned table spaces, the product uses a 4 KB CISIZE for each partition of the table space. You cannot select the Create all VSAM data sets with a CISIZE of 4 KB option for only certain partitions in a table space.

Enable worklist parallelism (Database Administration solution only)

For the Database Administration solution, instructs Analysis to include commands to run a worklist in parallel. When you select this option, the product inserts the PARALLEL keyword into the ALUIN input stream.

Note

The presence of the parallelism commands in the worklist does not signify that the worklist will be executed in parallel. To run the worklist in parallel, you must set the ACM_PARALLEL_WORKLST keyword to Y in the AJXPOFIN input stream or specify the Run Worklist in Parallel mode Execution override option. For information, see Overrides-of-default-processing-options.

When you select to enable worklist parallelism, Change Manager automatically selects the following additional Analysis options:

  • On the Analysis Utility Options panel, BMC UNLOAD PLUS is selected for Unload and BMC LOADPLUS is selected for Load.
  • On the Analysis Image Copy Options panel, BMC AMI Copy is selected for Copy.
  • On the Analysis Utility Dataset Options panel, the Use Dynamic SYSRE datasets and Use Dynamic COPY datasets options are selected.

These options are required to enable Worklist parallelism. In addition, you must ensure that on the Analysis Worklist Command Options panel, the Data option is selected.

Omit the -STOP command between phases of a migrate worklist (migrate-type work ID only)

When analyzing a migrate-type work ID, inserts the SINGLEPHASE keyword into the ALUIN input stream. If you want to migrate your data structures, data, or both within the same subsystem, select this option to create a worklist that unloads data, creates structures, and loads data all in one step.

When you migrate your data structures, data, or both to a different subsystem, deselect this option to generate the -STOP command between the first and second phases of the migration.

Make tables inaccessible during execution (alter-type work ID only)

When analyzing an alter-type work ID, inserts the NOTABLEACCESS keyword into the ALUIN input stream. Analysis inserts START DATABASE commands into the worklist to reduce access to the tables in the worklist during execution by putting objects into read-only status.

Note

Whether or not the Make tables inaccessible during execution option is selected, the SHRLEVEL NONE option is used as the default in a REORG TABLESPACE statement in a -BMCR or -REOR worklist command.

Include APPLCOMPAT overrides in worklist

On an IBM Db2 12 subsystem, inserts the APPLCOVR keyword in the ALUIN input stream. Analysis inserts the appropriate SET CURRENT APPLICATION COMPATIBILITY commands in the worklist upon detecting the following commands:

  • CREATE SYNONYM
  • CREATE command related to a table space that is not a universal table space

If you do not select this option, Analysis inserts the NOAPPLCOVR keyword in the ALUIN input stream. Analysis issues an error then stops the process when it detects the commands listed above.

This option is not displayed when the program runs on Db2 subsystems earlier than V12.

Escalate lost objects messages from warnings to errors

(BMC.DB2.SPE2310)

Inserts the LOSTERROR keyword into the ALUIN input stream. Analysis escalates lost object messages from warnings to errors.

Related topic

Overrides-of-default-processing-options

ALUIN-keywords



 

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