ALUIN keywords

ALLOWICP

STOPICP=N

DUAL=N

Specifies that index-controlled partitioned tables can be created

This keyword overrides the STOPICP=Y or DUAL=Y installation options and overrides the ZPARM PREVENT_NEW_IXCTRL_PART = YES.

This keyword also suppresses the generation of the -CENV worklist command.

This keyword must be manually added in the ALUIN input stream.

See also the STOPICP keyword in this table.

A

ALLOWREBUILD

(Db2 Version 11 and later)

None

A

ALLOWREORG

(Db2 Version 11 and later)

None

A

ALLSTATSUPD

UPDSTATS=A

Specifies that the tables DASD MANAGER PLUS and the Db2 catalog tables should be updated.

A

ALTERADDVOL

None

A

AMSDELETEI

None

Inserts a DELETE statement for the 'I' data set that stores reorganized data structures and data after an online reorg.

See also the NOAMSDELETEI keyword in this table.

A

APPLCOVR

APPLCOVR=Y

A

AUTHSW

AUTHSW=Y

Controls the method of authorization ID switching that Analysis uses.

The products generate -AUTH commands in the worklist.

See also the AUTHSWGLID, AUTHSWOFF, and NOAUTHSW keywords in this table.

Do not use the AUTHSW keyword if you are using a global authorization ID (GLID) or if AUTHSW=N in the installation options module.

A

AUTHSWGLID

AUTHSW=G

Disables authorization switching.

The products do not generate -AUTH and -SETS commands; they do, however, generate -GLID commands in the worklist.

See also the AUTHSW, AUTHSWOFF, and NOAUTHSW keywords in this table.

A

AUTHSWOFF

AUTHSW=X

Disables authorization switching.

Use this keyword only if you are not allowed to execute any -AUTH or -SETS commands in your environment, or if you previously edited your worklists and removed all of the -AUTH, -SETS, and -GLID commands.

See also the AUTHSW, AUTHSWGLID, and NOAUTHSW keywords in this table.

A

BASICUNLOAD

BMCUNLD=N

Generates commands for the UNLOAD PLUS utility.

A

BINDONIX

BINDONIX=Y

Automatically rebinds all packages dependent upon a table, after a new index has been added to a table or an existing index has been altered

A

BLNAME a.b

None

Passes a baseline name or template to the component if a template from the baseline profile is not being used.

A, B

BLPROFILE a.b

None

Passes a baseline profile name to the component.

A, B

BLRECOVER

None

Generates a worklist for restoring a full-recovery baseline.

This parameter generates LOAD statements from the baseline unload data sets and will not generate UNLOAD statements.

A

BLRECOVERPOINT

None

Generates a worklist for establishing a full-recovery baseline

In addition to including the -BASE command in the worklist, this option also generates -UNLD and -UNRC commands to unload and record the baseline unload data sets.

A, B

BLWORKID a. b

None

Passes the alter-type work ID that established the baseline to Analysis and Compare

Analysis and Compare use the work ID to look up the name of the baseline.

A, C

BMCCHECK

BMCCHECK=Y

Uses the CHECK PLUS utility for checking referential constraint violations

A

BMCCOPY

BMCCOPY=Y

A

BMCFASTLOAD

BMCFASTL=Y

A

BMCLOAD

BMCLOAD=Y

Uses the LOADPLUS utility to load data

A

BMCREBUILD

REBLD=B

A

REORG=B

A

BMCRSWITCH=Y

Specifies that when the BMC REORG PLUS utility cannot be used to reorganize table spaces, use the IBM REORG utility

See also the NOBMCRSWITCH keyword in this table.

A

BMCSTATSUPD

UPDSTATS=B

Specifies that only the DASD MANAGER PLUS tables are updated

A

BMCUNLOAD

BMCUNLD=Y

Uses the UNLOAD PLUS utility to unload data

A

BUILDTEMPCOPY

None

Builds a portable copy of the image copy data set

See also the NOBUILDTEMPCOPY keyword in this table.

A

CATALOG

AMS=C

Generates the following statements and commands in a worklist:

• AMS statements, including the CATALOG parameter in the IDCAMS DEFINE CLUSTER statement
• Commands for specifying IBM Storage Management Subsystem (SMS) parameters

A

CDLCHANGERULES a.b

None

C

CHANGERULESIN2 migrateProfile

None

Specifies the name of an outbound migrate profile containing change rules that Compare uses to resolve object names and creators.

Compare applies the change rules to CMPIN2 objects before the component performs a comparison. The outbound migrate profile must not contain locations.

This keyword replaces the CMPPROFILE keyword.

C

CISIZE4K

None

For VCAT-defined table spaces (partitioned, simple, segmented, and large object, or LOB), creates VSAM data sets with a control interval size (CISIZE) of 4 KB, regardless of the page size (buffer pool size) of the table space.

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 specify CISIZE4K for only certain partitions in a table space.

A

CKEXCEPTIONS nnnn

EXCEPT=0

Specifies the maximum number of rows that contain referential integrity or check constraint errors.

The default is 0.

You must manually add this keyword to the ALUIN input stream.

A

CLONEDATA

CLONDATA=Y

Includes worklist commands to unload, load, and copy data contained in clone tables.

See also the NOCLONEDATA keyword in this table.

A

CMPILOT

None

Specifies that the Analysis job contains CM/PILOT Data Manipulation Language (DML)

A, P

CMPIN1 a.b

None

Passes the name of the primary set of input (a baseline or a work ID) in a comparison to Compare.

C

CMPIN2 a.b

None

Passes the name of the secondary set of input (baseline) in a comparison to Compare.

C

None

C

CMPTYPE1 inputType

None

Passes the type of the primary set of input to Compare.

Valid types of input are BASELINE, BLWORKID, DDL, LOCAL (Db2 catalog), REMOTE (Db2 catalog), WORKID, and WORKLIST.

C

CMPTYPE2 inputType

None

Passes the type of the secondary set of input to Compare.

Valid types of input are BASELINE, BLWORKID, DDL, LOCAL (Db2 catalog), REMOTE (Db2 catalog), and WORKLIST.

C

COMMIT n

None

B

COPYDDN (parameters)

COPYDD01=C

COPYDD02=C

RECVDD01=C

RECVDD02=C

A

COPYEXPORT

None

A

None

Ignores Change Definition Language (CDL) statements that reference nonexistent table and view columns.

Any CDL statements that specify dropping or altering nonexistent table and view columns are discarded when the CDL is imported. If the CDL specifies adding a new column before or after one that does not exist, the new column is placed at the end of the column list.

I

DB2RULES

None

Sets the CURRENT RULES special register to Db2 so that certain statements are executed in accordance with Db2 rules

The default setting is Db2. For more information about the CURRENT RULES special register, see the IBM Db2 for z/OS documentation.

A

DB2STATSUPD

UPDSTATS=C

Specifies that only the Db2 catalog tables should be updated

A

DBRMLIB

DBRMLIB

A

DDLDROPS

None

C

DEBUG

None

A, P

DEBUG(INIT)

None

B, BR, C, I

DEFAULTOFF

None

C

DEFERCDC=Y

Depending on the value of the UTILS_BLOCK_FOR_CDC IBM Db2 subsystem parameter, Analysis performs different actions when the CREATE TABLE statement includes the DATA CAPTURE CHANGES clause. The following table lists the possible actions:

A

DEFERUNIQUEIX

DEFERUIX=Y

Analysis ignores the uniqueness of an index when it determines whether the index can be created with DEFER YES. For alter-type work IDs, all indexes are created with DEFER YES.

A

None

B

DELETEAGE n

None

Specifies deleting baselines that are older than the current date (minus n days) and created with the specified baseline profile.

See also the DELETEAGE keyword in the AJXIN input stream.

B

DISCARDS n

DISCARDS= nnnn

Specifies the number of discard records to allow.

The valid range for n is 0 through 9999.

DISCARDS 0 means that no maximum number of discards exists.

If you use DISCARDS 1, the product generates one discard DD, a //SYSDS001 for the entire run, and DISCARDS 1 as a LOAD parameter. JCL generated minimally sizes the data sets for SYSDS001 and SYSER001 DDs. This action causes the load utility to terminate with return code 8 if any records must be discarded. Typically, you use DISCARDS 1 when data is migrated, valid data remains unchanged, and the goal is to reduce the number of DDs and data sets needed.

If the DISCARDS keyword is set to anything other than 1, the product generates a different discard DD (//SYSDnnnn) for each LOAD, and generates DISCARDS n as a LOAD parameter for each LOAD command (where n is the maximum number of discards). This action causes the load to terminate if the discard maximum is reached. If fewer records are discarded, the discard file contains the records and execution proceeds to the next step in the worklist.

You must manually add this keyword to the ALUIN input stream to change the number of discard records set in the DISCARDS installation option.

A

DYNCOPY

DYNCOPY=Y

A, F

DYNREORG

DYNREORG=Y

A, F

DYNUNLD

DYNUNLD=Y

Dynamically allocates the unload (SYSREC) and discard (SYSDISC) data sets that the UNLOAD PLUS, LOADPLUS, IBM UNLOAD, and IBM LOAD utilities use.

DYNULD=Y is required when you generate a worklist with spanned record column support.

See also the NODYNUNLD keyword in this table.

A, F

EMPTYCARD n

None

Regards tables with a specific cardinality to be considered empty.

The valid range for n is 0 through 2,147,483,647.

In certain applications, particularly ERP applications, manually updating statistics to get a nonzero cardinality for tables that might be empty can improve performance. When optimizing ERP applications, NOUNLOADEMPTY views all tables with a cardinality of zero and the cardinality specified by EMPTYCARD as empty.

EMPTYCARD n must be manually added into the ALUIN input stream, and the NOUNLOADEMPTY parameter must also be included in the input stream.

A

ENV

None

A, B, BR, C, E, F, I, J

EURO

EURO

A, B, BR, C, I, J, S

EXPMAXTS nnnn

None

A

FORCECHECK

None

Uses the ENFORCE NO option when LOADPLUS loads data and uses the IBM CHECK DATA utility to enforce referential integrity and check constraints.

A

None

Causes Compare to generate DROP statements from a DDL file for objects in the Db2 catalog when the following conditions exist:

• You are comparing a Db2 catalog to a DDL file.
• The DDL file is the source of scope rules.

If you use one of the OVERRIDE(CHILDALL) keywords with the FORCEDDLDROPS keyword, the following DROP statements are included in the CDL:

• Explicit DROPS mentioned in the DDL file
• DROPS generated for missing dependent objects

C

FORCELOADREPLACE

None

Instructs Analysis to generate one of the following forms of the LOAD DATA syntax:

• LOAD DATA RESUME YES INTO TABLE

  Analysis uses this syntax in the BMC LOADPLUS utility when you are migrating only data from a single table at the table level of a segmented table space.

  Analysis uses this syntax in the IBM LOAD utility when you are migrating only data from:

  • A single table at the table level of a segmented table space.
  • The second and succeeding tables of multiple tables at the table space level of a segmented table space.

  Analysis does not assume that the structures on the sending and receiving subsystems are identical. The load utility deletes the existing data in the table before loading.

A

FORCELOADREPLACE (continued)

None

• LOAD DATA RESUME YES INTO TABLE REPLACE

  Analysis uses this syntax in the LOADPLUS utility when you are migrating only data from one or more tables at the table space level of a segmented table space. Analysis assumes that the structures on the sending and receiving subsystems are identical, and generates the LOAD statements based on the structure of the sending subsystem. The load utility replaces the data in the table.

  Analysis does not use this syntax in the IBM LOAD utility.

FORCELOADREPLACE (continued)

None

A

FORCERESMAX

None

A

FORCETRWLMENV

None

C

FULLDEBUG

None

A

GENOBID

GENOBID=Y

Generates the OBID parameter in a CREATE TABLE statement

See also the NOGENOBID keyword in this table.

A

GLAUTHID globalAuthorizationID

GLID

Defines a global authorization ID (GLID).

The components use this authorization ID instead of the authorization ID of the person who submits the job. The worklist begins with a -GLID command that switches authorization to the GLID.

After all Analysis-generated -AUTH and -SETS commands, the product resets the current authorization ID to the GLID.

See also the GLID keyword in the AJXIN input stream.

A, B

HISTORYALL

STATHIST=Y

Uses the IBM RUNSTATS utility to update the Db2 catalog history tables with the current statistics that are being collected.

See also the NOHISTORY keyword in this table.

A

HSMVOL volumeID

HSMVOL= volumeID

A

IBMCHECK

BMCCHECK=N

Uses the IBM CHECK DATA utility for checking referential constraint violations.

A

IBMCOPY

BMCCOPY=N

Uses the IBM COPY utility for creating image copies.

A

IBMLOAD

BMCLOAD=N

Uses the IBM LOAD utility to load data.

A

IBMREBUILD

REBLD=I

Uses the IBM REBUILD utility to run against an index if the index is created with DEFER YES.

A

IBMREORG

REORG=I

A

IBMUNLOAD

BMCUNLD=I

Uses the IBM UNLOAD utility to unload data.

A

IDAAIGNORE

IDAAIGNR=Y

A

IGNOREDUPLICATES

None

Compare ignores duplicate views and issues a warning message instead of a fatal error. Compare discards all duplicate views and continues comparing the DDL.

C

IGNOREIMPLDEPS

None

When you make changes that cause the following objects to be dropped and created, or migrated, ignores the changes to those objects:

• Table spaces (whether the changes were made in the current work ID or in a previous work ID)
• Auxiliary objects
• Enforcing indexes defined as ROWID GENERATED BY DEFAULT

These objects are dependents of implicitly created table spaces.

See also the NOIGNOREIMPLDEPS keyword in this table.

A

IGNORELKERROR

LKVALID=I

Ignores any errors that the product generates while assigning a new sequence for the ALTER TABLE ALTER PARTITION statements to alter limit keys.

You must manually insert this keyword in the ALUIN input stream.

Analysis generates the statements in the original order and issues a warning message.

A

IMPORT

None

Imports CM/PILOT Data Manipulation Language (DML) statements into a work ID.

A, P

INCLUDE (parameter [parameter,...])

None

Specifies either the types of commands to include in a worklist or the information to include in a Change Definition Language (CDL) file.

The following parameters are valid for Analysis:

• AMS
• BIND
• BINDAUTH
• DATA
• SQL
• REBIND

The following parameters are valid for Compare:

• CDLDEP
• ALTER
• CREATE
• DROP

A, BR, C

KEYCARD

KEYCARD=Y

Takes cardinality statistics for the key columns of an index when the IBM RUNSTATS utility takes index statistics.

See also the NOKEYCARD keyword in this table.

A

LATESTPKG=Y

A

LOBGT32M

None

A

LOCATION1

None

Specifies the location of a Db2 catalog for the primary set of input in a comparison.

C

LOCATION2

None

Specifies the location of a Db2 catalog for the secondary set of input in a comparison.

C

LOG

LOG=Y

Logs the records that the IBM LOAD utility loads.

A

LOSTERROR=Y

Analysis escalates the message and return code severity generated for an implicitly dropped foreign key from a warning (RC4) to an error (RC8)

A

MAPPINGDATABASE dataBase

None

A

MAXSYSREC nnnn

None

Specifies the maximum number of dynamically allocated unload (SYSREC) data sets to use for each unload (-BMCD) and load (-BMCL) worklist command when multitasking the unloading and loading of data for partitioned table spaces.

If the number of partitions in the table space exceeds the value of MAXSYSREC, Analysis divides the partitions to be unloaded among several unload and load worklist commands. For example, if the value of MAXSYSREC is 256 and the number of partitions in the table space is 540, Analysis generates three unload and load commands:

• The first command unloads or loads the first 256 partitions.
• The second command unloads or loads the next 256 partitions.
• The third command unloads or loads the last 28 partitions.

The default value is 256. If you want to specify a value other than 256, you must manually change the value for the keyword in the ALUIN input stream.

A

MAXSYSUT nnnn

MAXSYSUT

Specifies the maximum number of SYSUT temporary work data sets that the LOADPLUS and REORG PLUS utilities use to build nonclustering indexes.

Valid values are 1 through 9999.

A

MAXVER

None

Performs an action if an online schema change cannot be made to an object because the maximum number of active versions exists for the object.

Analysis will perform one of the following actions:

• Include statements in the worklist to drop and create an object.
• For indexes that are defined as COPY NO, generate a -RBLD statement in the worklist to rebuild the index.

If the MAXVER keyword is not included in the ALUIN input stream and Analysis encounters an object that has reached the maximum number of active versions, Analysis terminates with an error.

You must manually add this keyword to the ALUIN input stream.

A

MIGLOCATIONS

(location ddname [,...])

None

Specifies which locations (location) to use in an outbound migrate profile and the associated DDName for the output worklist or Change Definition Language (CDL) file for each location.

The location and DDName must be separated by a space, and the location and DDName pairs must be separated by commas.

If MIGLOCATIONS is not specified, all locations in the outbound migrate profile are used in Analysis or the comparison.

A, C

MIGPROFILE a.b

None

A, I

MIGSCOPE

None

Migrates from a profile scope rather than from the work ID’s CD entries.

A

MOVETB=Y

If possible, Analysis uses the ALTER TABLESPACE MOVE TABLE statement to move tables.

A

MULTITBDS

None

Generates a single -BMCD worklist command for a table space that contains multiple tables when you use the UNLOAD PLUS utility to unload data.

Analysis unloads each table in the table space into in a separate unload (SYSREC) data set.

You must manually add this keyword to the ALUIN input stream. In addition, you must select the Use Dynamic SYSRE datasets option on the Analysis Utility Dataset Options panel.

A

NEWWORKID a.b

None

Creates a new work ID.

To use this keyword, Analysis also requires the MIGPROFILE a.b and MIGSCOPE keywords.

The AEXIN input stream also uses this keyword.

A, I, P

NOALIAS

None

Sets the object change flag for a comparison to N (no) for the alias object.

C

NOAMSDELETEI

None

Does not delete an 'I' data set that contains data structures and data that have been reorganized in an online reorg.

See also the AMSDELETEI keyword in this table.

A

NOAPPLCOVR

APPLCOVR=N

Analysis issues an error then stops the process when it detects a create command (CREATE or DROP/CREATE) for a :

• Synonym
• Table space that is not a universal table space (non-UTS)

See also the APPLCOVR keyword in this table.

A

NOAUTHSW

AUTHSW=N

Uses only the SET CURRENT SQLID statement for authorizations.

The products generate -SETS commands in the worklist.

See also the AUTHSW and AUTHSWOFF keywords in this table.

Do not use the NOAUTHSW keyword if you are using a global authorization ID (GLID).

A

NOAUXILIARY

None

Sets the object change flag for a comparison to N (no) for the auxiliary object.

C

NOBASELINE

None

Does not create a baseline when using the specified baseline profile.

B

NOBINDONIX

BINDONIX=N

Does not rebind packages that are dependent upon a table after an index has been added to the table or an existing index has been altered

A

BMCFASTL=N

Does not use the FORMAT BMCLOAD option in the UNLOAD PLUS utility and the FORMAT BMCUNLOAD option in the BMC LOADPLUS utility to unload data from one table and load it into another table that has a similar structure

To override this keyword, you must manually change the keyword to BMCFASTLOAD in the ALUIN input stream.

See also the BMCFASTLOAD keyword in this table.

A

BMCRSWITCH=N

Specifies not to use the IBM REORG utility automatically, even if the BMC REORG PLUS utility cannot be used to reorganize the table spaces

See also the BMCRSWITCH keyword in this table.

A

NOBUFFERPOOL

None

Ignores the BUFFERPOOL attribute for databases, table spaces, and indexes

C

NOBUILDTEMPCOPY

None

Does not build a portable copy of the image copy data set.

See also the BUILDTEMPCOPY keyword in this table.

A

NOCHECKCNST

None

Sets the object change flag for a comparison to N (no) for the check constraint object.

C

NOCLONEDATA

CLONDATA=N

Omits worklist commands to unload, load, and copy data contained in clone tables.

See also the CLONEDATA keyword in this table.

A

NOCOMPRESS

None

Ignores the table space COMPRESS attribute from a comparison when you include partition attributes in a comparison.

C

NOCOPY

BMCCOPY=X

Does not create image copies.

A

NOCOPYFORCE

BMCCOPY=F

Does not create image copies.

This parameter causes the product to issue a START DATABASE ACCESS (FORCE) statement to reset the copy pending.

A

NODATABASE

None

Sets the object change flag for a comparison to N (no) for the database object or partition attribute.

This keyword suppresses comparing object types and object attributes.

C

NODBRMLIB

None

Omits the LIBRARY parameter on the BIND statement for plans and packages.

A

NODEFINE

None

Ignores the DDL DEFINE parameter for table spaces and indexes.

C

DEFERCDC=N

Depending on the value of the UTILS_BLOCK_FOR_CDC IBM Db2 subsystem parameter, Analysis performs different actions when the CREATE TABLE statement includes the DATA CAPTURE CHANGES clause. The following table lists the possible actions:

A

NODROPORPHANEDTS

None

Does not drop any auxiliary table space that does not contain an auxiliary table.

You must manually insert this keyword in the ALUIN input stream.

A

NODROPRESTRICT

None

Ignores the DROPRESTRICT attribute for tables

C

None

Ignores the DSSIZE attribute of a table space or an index in a comparison

C

NODYNCOPY

DYNCOPY=N

A, F

NODYNREORG

DYNREORG=N

A, F

NODYNUNLD

DYNUNLD=N

Does not dynamically allocate the unload (SYSREC) and discard (SYSDISC) data sets that the UNLOAD PLUS, LOADPLUS , IBM UNLOAD, and IBM LOAD utilities use.

A, F

NOECHO

None

Does not include keywords in the ALUIN input stream as comments in a worklist.

You must manually insert this keyword in the ALUIN input stream.

A

NOFOREIGNKEY

None

Sets the object change flag for a comparison to N (no) for the foreign key object.

C

NOFREEPAGE

None

Ignores the table space and index FREEPAGE attribute from a comparison when you include partition attributes in a comparison.

C

NOGENOBID

GENOBID=N

Does not generate the OBID parameter in a CREATE TABLE statement.

See also the GENOBID keyword in this table.

A

NOHISTORY

STATHIST=N

Does not update the Db2 catalog history tables with the current statistics that are being collected.

See also the HISTORYALL keyword in this table.

A

NOHSMVOL

HSMVOL=N

Uses a blank value for the HSM volume ID.

See also the HSMVOL keyword in this table.

A

NOIDAAIGNORE

IDAAIGNR=N

A

NOIDENTITY

None

Ignores the IDENTITY attribute for tables.

C

NOIGNOREIMPLDEPS

None

Issues an error when you make changes that cause the following objects to be dropped and created, or migrated:

• Table spaces (whether the changes were made in the current work ID or in a previous work ID).
• Auxiliary objects
• Enforcing indexes defined as ROWID GENERATED BY DEFAULT.

These objects are dependents of implicitly created table spaces.

You must manually add this keyword to the ALUIN input stream.

See also the IGNOREIMPLDEPS keyword in this table.

A

NOINDEX

None

Sets the object change flag for a comparison to N (no) for the index object.

C

NOORDERLK

LKVALID=N

Does not analyze or reorder the sequence of ALTER TABLE ALTER PARTITION statements that modify limit keys.

You must manually add this keyword to the ALUIN input stream.

A

NOKEYCARD

KEYCARD=N

Does not take cardinality statistics for the key columns of an index when the IBM RUNSTATS utility takes index statistics.

See also the KEYCARD keyword in this table.

A

LATESTPKG=N

Analysis generates rebinds for all versions of every affected package

A

NOLOBDATA

None

Does not unload and load data contained in large object (LOB) columns.

This keyword is not valid when you are creating a full-recovery baseline.

You must manually insert this keyword in the ALUIN input stream.

A

NOLOCKSIZE

None

Ignores the LOCKSIZE and LOCKMAX attributes for table spaces.

C

LOSTERROR=N

Analysis generates a warning for implicitly dropped foreign key objects

A

NOMASK

None

Sets the object change flag for a comparison to N (no) for the column mask object.

This keyword suppresses comparing object types and object attributes.

C

MOVETB=N

Analysis unloads, drops, rebuilds, and loads tables to move tables.

A

NOMTASK

None

Disables multitasking when data is unloaded to permit tape stacking for Execution.

You must manually insert this keyword in the ALUIN input stream.

A

NOORDERBY

None

Bypasses the ORDER BY clause on all unloads

As a result, the Analysis performs the subsequent load from an unsorted file.

See also the ORDERBY keyword in this table.

A

None

Ignores the PAGENUM attribute for table spaces.

C

NOPARALLEL

PARALLEL=N

A

NOPARTCOPY

PARTCPY=N

Does not create a partition-level image copy of a partitioned table space or index.

See also the PARTCOPY keyword in this table.

A

None

Ignores the DSSIZE attribute for table spaces and index partitions in a comparison.

C

NOPARTITION

None

Sets the object change flag for a comparison to N (no) for the partition attribute.

C

NOPATH

None

Ignores the PATH attribute for the following objects:

• check constraints
• views
• triggers
• stored procedures
• column masks
• row permissions

C

NOPCTFREE

None

Ignores the table space and index PCTFREE attribute from a comparison when you include partition attributes in a comparison.

C

NOPCTFREE_UPD

None

Ignores the table space FOR UPDATE clause of the PCTFREE attribute from a comparison when you include partition attributes in a comparison.

C

NOPERMISSION

None

Sets the object change flag for a comparison to N (no) for the row permission object.

This keyword suppresses comparing object types and object attributes.

C

NOPLANMGMT

PLANMGMT=N

If the PLANMGMT column in the SYSIBM.SYSPACKAGE table for a package is blank, Analysis generates a PLANMGMT(OFF) option for the package REBIND statement. Otherwise, Analysis uses the SYSIBM.SYSPACKAGE PLANMGMT column to generate the PLANMGMT option for the package REBIND statement.

You must manually insert this keyword in the ALUIN input stream to override the installation option.

A

NOPRIQTY

None

Ignores the table space and index PRIQTY attribute from a comparison when you include partition attributes in a comparison.

C

NOREBUILD

REBLD=N

A

NOREFRESH

REFRESH=N

Does not use the REFRESH TABLE statement to refresh the data in a materialized query table (MQT).

You can manually add this keyword to the ALUIN input stream.

See also the REFRESH keyword in this table.

A

NOREGENIDENTITY

None

Does not allow a column that is defined with GENERATED ALWAYS AS IDENTITY to be rebuilt by Analysis if the table is dropped and created.

To enable Db2 to generate a new unique value for the identity column that is defined as GENERATED ALWAYS, manually change the NOREGENIDENTITY keyword to REGENIDENTITY.

See also the REGENIDENTITY keyword in this table.

A

NOREMARKS

None

Ignores the following objects that have changes only to comments and labels:

• sequences
• tables
• indexes
• views
• aliases
• stored procedures
• column masks
• row permissions

C

RENAMECOL=N

C

NOREORGCDC

(BMC.DB2.SPE2507)

REORGCDC=N

Analysis does not force the reorganization of a table space when the following conditions are true: 

• The table space contains a table that has the DATA CAPTURE attribute set to CHANGE.
• You are altering or rebuilding either the table space or the table it contains.

Analysis reorganizes the table space if it is required.

See also the REORGCDC keyword in this table.

A

NOREORGPDD

REORGPDD=N

Specifies that no reorganizations be included in the worklist for objects with pending DDL that resulted from an alter in the worklist.

See also the REORGPDD keyword in this table.

A

NOREORGONLINE

REORGONL=N

A

NOREPLACE

None

Specifies that existing work IDs will not be replaced with the REPLICATE WORKID statement.

See also the REPLACE keyword in this table.

P

NOROLEOWN

ROLEOWN=N

Specifies that a ROLE is not defined as the owner, creator, or grantor of an object.

See also the ROLEOWN keyword in this table.

A

NOSECQTY

None

Ignores the table space and index SECQTY attribute from a comparison when you include partition attributes in a comparison.

C

NOSEGSIZE

None

Ignores the SEGSIZE attribute for segmented table spaces.

C

NOSPANNEDRECS

SPANNED=N

Uses file reference data sets instead of spanned records to unload and load XML and LOB data

A

NOSTARTVALUE

None

Ignores the START attribute for an identity column in a table.

C

NOSTOGROUP

None

Sets the object change flag for a comparison to N (no) for the storage group object or attribute.

This keyword suppresses comparing object types and object attributes.

C

NOSTOPCOMMIT

STOPCOMM=N

Prevents an AT(COMMIT) statement from being generated for every STOP command in the worklist.

See also the STOPCOMMIT keyword in this table.

A

NOSTOPLIST

STOPLIST= creatorName

Analyzes all of the tables in a migrate-type work ID, including those in a list that are identified by a creator name for the work ID as tables that should not be analyzed.

See also the STOPLIST keyword in this table.

A

NOSYNONYM

None

Sets the object change flag for a comparison to N (no) for the synonym object.

C

NOTABLE

None

Sets the object change flag for a comparison to N (no) for the table object.

Use this keyword to set the flags for global temporary tables.

C

NOTABLEACCESS

TABLEACC=N

Includes START DATABASE commands in an alter-type worklist, preventing outside access to tables during worklist execution.

Whether or not NOTABLEACCESS is specified, the SHRLEVEL NONE option is used as the default in a REORG TABLESPACE statement in a -BMCR or -REOR worklist command.

A

NOTABLEALL

TABLEALL=N

Does not include the TABLE(ALL) parameter on stand-alone statistics jobs.

A

NOTABLESPACE

None

Sets the object change flag for a comparison to N (no) for the table space object or partition attribute.

This keyword suppresses comparing object types and object attributes.

C

NOTCPROTATE

None

Does not create an ALTER TABLE ROTATE PARTITION statement in a worklist, even if you specified a value for the Rotate Parts field on the Tablespace Parts List panel for the work ID.

You must manually add this keyword to the ALUIN input stream.

See also the TCPROTATE keyword in this table.

A

NOTRACKMOD

None

Ignores the table space TRACKMOD attribute from a comparison when you include partition attributes in a comparison.

C

NOTRIGGER

None

Sets the object change flag for a comparison to N (no) for the trigger object.

C

NOUNIQUECNST

None

Shows a primary key as part of the table definition in the generated Change Definition Language (CDL).

If you omit the keyword, Compare shows a primary key as a primary unique constraint.

C

NOUNLDCOLL

UNLDCOLL=N

Provides explicit column lists on all of the UNLOAD PLUS utility unloads only when needed.

To provide explicit column lists on the IBM UNLOAD utility unloads, you must manually insert the keyword in the ALUIN input stream.

A, J

NOUNLOADEMPTY

UNLDEMPT=N

Does not unload tables that the IBM RUNSTATS utility indicates are empty.

See also the UNLOADEMPTY keyword in this table.

A

NOUSENGTR

USENGTR=N

Uses the REORG PLUS utility to perform data reorganization

See also the USENGTR keyword in this table.

A

NOUSENGTUL

USENGTUL=N

Uses either the BMC or IBM utilities, depending on which of the following pairs of keywords you include in the ALUIN input stream.

• BMCUNLOAD/BMCLOAD for the BMC utilities
• IBMUNLOAD/IBMLOAD for the IBM utilities

See also the USENGTUL keyword in this table.

A

NOUTILCOPY

UTILCOPY=N

A

NOVALIDATE

None

Does not check for changes in objects since specification was performed.

A

NOVIEW

None

Sets the object change flag for a comparison to N (no) for the view object

C

NOVIEWCHECK

None

Ignores the CHECK attribute for views.

C

NOVVALPROP

VVALPROP=N

A

NOWLORDER

None

Generates the objects in a worklist in an unsorted, random order.

See also the WLORDER NONE keyword in this table.

You can use this keyword to override the ACM_WLORDER POF keyword.

A

NOXMLDATA

None

Does not unload and load data contained in XML columns.

You must manually insert this keyword in the ALUIN input stream.

This keyword is not valid when you are creating a full-recovery baseline.

A

OBJECTS (baseline)

None

Specifies the name of a baseline for a baseline report.

BR

OBJINFO

None

A

ORDERBY

None

Builds the ORDER BY clause when a clustering index is present on the table that is being unloaded.

The use of this keyword can result in significant overhead.

See also the NOORDERBY keyword in this table.

A

OVERRIDE( ALTERWL )

None

Allows an alter‐type worklist to be used in a comparison

Without this keyword, if you attempt to use an alter‐type worklist in a comparison, Compare issues an error.

C

OVERRIDE( BASELINE-DELETE )

None

For a batch run type, deletes the baseline specified for a baseline profile.

To delete the baseline, you must include the following keywords in the ALUIN DD in the batch JCL:

• BLNAME a.b
• BLPROFILE a.b
• OVERRIDE( BASELINE-DELETE )
• NOBASELINE

The name of the baseline must be fully qualified. The BLNAME and the BLPROFILE ALUIN keywords cannot contain a template.

B

None

Includes all dependent objects for each table from the catalog referenced in the DDL in the comparison.

This option is available only when the scope of the comparison is a DDL file or migrate worklist, and you are comparing a catalog and a DDL file or worklist.

C

OVERRIDE( CHILDALL-TS )

None

Includes all dependent objects for each table space or table from the catalog referenced in the DDL in the comparison.

This option is available only when the scope of the comparison is a DDL file or migrate worklist, and you are comparing a catalog and a DDL file or worklist.

C

OVERRIDE(CHILDALL-DB)

None

Includes all dependent objects for each database, table space, or table from the catalog referenced in the DDL in the comparison.

This option is available only when the scope of the comparison is a DDL file or migrate worklist, and you are comparing a catalog and a DDL file or worklist.

C

OVERRIDE( CKSEGSIZE )

None

Shows the differences between a simple table space and a segmented table space defined with a SEGSIZE of 4.

C

OVERRIDE( CK-SG-DEFLT )

None

Shows the differences between the names of storage groups for table spaces when one storage group has the default name

C

OVERRIDE( CMPLKSZ )

None

Shows the differences between the values of the LOCKSIZE attribute for table spaces when one attribute has a value of TABLE and the other has a value of TABLESPACE

C

OVERRIDE(CTSA-ASCII)

None

Compare uses an ASCII encoding scheme (CCSID) for creating table spaces, regardless of the CCSID specified.

C

OVERRIDE(CTSA-EBCDIC)

None

Compare uses an EBCDIC encoding scheme (CCSID) for creating table spaces, regardless of the CCSID specified.

C

OVERRIDE(CTSA-UNICODE)

None

Compare uses a UNICODE encoding scheme (CCSID) for creating table spaces, regardless of the CCSID specified.

C

OVERRIDE(CTSD-ASCII)

None

Compare uses an ASCII encoding scheme (CCSID) for creating table spaces whenever a CCSID is not specified.

C

OVERRIDE(CTSD-EBCDIC)

None

Compare uses an EBCDIC encoding scheme (CCSID) for creating table spaces whenever a CCSID is not specified.

C

OVERRIDE(CTSD-UNICODE)

None

Compare uses a UNICODE encoding scheme (CCSID) for creating table spaces whenever a CCSID is not specified.

C

OVERRIDE( DB-OWNER )

None

Shows the differences between owner attribute values for databases

C

OVERRIDE( DEFAULTPIECESIZE )

None

If the PIECESIZE for an auxiliary index is 0, Compare uses the DSSIZE value of the table space for the PIECESIZE for the auxiliary index

C

OVERRIDE( ENQFAILRC4 )

None

Produces a return code of 4 when the deletion of a baseline fails because the baseline is in use.

This keyword overrides the default return code of 0.

You must manually insert this keyword in the ALUIN input stream.

B

OVERRIDE( FKNN )

None

Shows the differences between two foreign keys when one foreign key has a three-part explicit name and the other foreign key has no name (part three is not specified).

C

OVERRIDE( FORCECMPSPCONCENTRATE )

(BMC.DB2.SPE2510)

OVERRIDE( FORCECMPSPDEBUG )

None

Shows the differences between the values for the debug mode attribute of stored procedures when a value is blank

C

OVERRIDE( FORCE-CMP-SPPARMVCHAR )

None

Shows the differences between the VARCHAR parameters of stored procedures

C

OVERRIDE( FORCECMPSPPROGRAMTYPE )

None

Shows the differences between the values of the program type option for external stored procedures when the value of one of the program types is blank

C

OVERRIDE( FORCECMPSPWLMNEST )

None

Shows the differences between the values of the WLM FOR NESTED attribute for stored procedures when the value for one of the attributes is blank

C

OVERRIDE( FORCECMPTRDEBUG )

None

Shows the differences between the values for the debug mode attribute of advanced triggers when a value is blank

C

OVERRIDE( FORCEINLLOB )

None

Compare uses the Db2 DSNZPARM LOB_INLINE_LENGTH value for the INLINE LENGTH, when it is not included in the DDL definition of a LOB column.

C

OVERRIDE( FORCE-SPCCSID )

None

Shows the differences between the values of the parameter CCSID for stored procedures

C

OVERRIDE( FORCE-SPEXTERNALNM )

None

Shows the differences between the values of the external name for stored procedures when one of the names is blank

C

OVERRIDE( FORCESP-ROUNDING )

None

Shows the differences between the values of the ROUNDING option for stored procedures when one of the options is blank

C

OVERRIDE( FORCESP-TFORMAT )

None

Shows the differences between the values of the TIME FORMAT option for stored procedures when one of the options is blank

C

OVERRIDE( FORCE-TRCCSID )

None

Shows the differences between the values of the parameter CCSID for advanced triggers

C

OVERRIDE( FORCETR-ROUNDING )

None

Shows the differences between the values of the ROUNDING option for advanced triggers when one of the options is blank

C

OVERRIDE( FORCETR-TFORMAT )

None

Shows the differences between the values of the TIME FORMAT option for advanced triggers when one of the options is blank

C

OVERRIDE( GENOBID )

None

B, BR, C

OVERRIDE( INCLUDEPARENTS )

None

Includes the parent objects of tables or table spaces in the scope of a catalog-to-catalog comparison when you are specifying the object types and object names for Compare1 and Compare2 to explicitly define the scope of the comparison.

C

OVERRIDE( IXPADDEDN )

None

Uses the default of PADDED NO for an index, regardless of the value in the Db2 subsystem parameter DSNZPARM.

C

OVERRIDE( IXPADDEDY )

None

Uses the default of PADDED YES for an index, regardless of the value in the Db2 subsystem parameter DSNZPARM.

C

OVERRIDE( KEEP-ALL-PRIMARY)

UCPKPALL=Y

Includes the primary key constraint in a baseline or comparison when you exclude unique constraints.

B, C

OVERRIDE( LONGVARCOLS )

None

Shows the differences between two columns when one column has a LONG VARCHAR data type and the other column has a VARCHAR data type.

C

OVERRIDE( MAXVALUE )

None

Shows the differences between the values of the MAXVALUE attribute of materialized query tables when one of the attributes is blank

C

OVERRIDE( NOALIASLOC )

None

Ignores the location attribute for aliases in a comparison

C

OVERRIDE( NOAPPEND )

None

Ignores the APPEND attribute of a table in a comparison.

C

OVERRIDE( NOAPPLCOMPAT )

None

Ignores the APPLCOMPAT option for stored procedures and advanced triggers in a comparison

C

OVERRIDE( NOARCHIVE )

None

Ignores the ARCHIVING_TABLE attribute for tables in a comparison

C

OVERRIDE( NOARCHSENS )

None

Ignores the archive sensitive option for stored procedures and advanced triggers in a comparison

C

OVERRIDE( NO-ARCH-TB )

None

Ignores archive tables in a comparison

C

OVERRIDE( NOBIZTIME )

None

Ignores the PERIOD BUSINESS_TIME attribute for indexes or tables in a comparison

C

OVERRIDE( NOBUSTIMES )

None

Ignores the business time sensitive option in stored procedures and advanced triggers in a comparison

C

OVERRIDE( NOCLONES )

None

Ignores clone tables in a comparison.

C

OVERRIDE( NOCOLUMNS )

None

Ignores columns in a table in a comparison

C

OVERRIDE( NODATACAPTURE )

None

Ignores the data capture attribute of a table in a comparison.

C

OVERRIDE( NODBOWN-CRE )

None

Ignores the owner attribute when creating databases in a comparison

C

OVERRIDE( NODSSIZE )

None

Ignores the DSSIZE attribute of a table space in a comparison.

C

OVERRIDE( NOENFORCED )

None

Ignores the ENFORCED attribute of a foreign key in a table in a comparison.

C

OVERRIDE( NO-FIELDPROC )

None

Ignores the FIELDPROC attribute for tables in a comparison

C

OVERRIDE( NOGBPCACHE )

None

Ignores the GBPCACHE attribute for table spaces in a comparison.

C

OVERRIDE( NO-GEN-ALLSPATTRS )

None

Ignores all stored procedure attributes in a comparison

C

OVERRIDE( NOGENAS )

None

Ignores the as-generated-expression-clause for columns in a table in a comparison

C

OVERRIDE( NO-GEN-SPDETERMINISTIC )

None

Ignores the deterministic attribute for stored procedures in a comparison

C

OVERRIDE( NOGEN-SPPARMS )

None

Ignores parameters for stored procedures in a comparison

C

OVERRIDE( NO-GEN-UC )

None

Ignores unique constraints in a comparison

C

OVERRIDE( NO-GLOBAL-CDL )

None

Ignores global temporary tables in a comparison

C

OVERRIDE( NO-HIDDEN )

None

Ignores the HIDDEN attribute for table columns in a comparison

C

OVERRIDE( NOINLINELOB )

None

Ignores the INLINE attribute for table spaces in a comparison.

C

OVERRIDE( NOINSERTA )

None

Ignores the INSERT ALGORITHM attribute for table spaces in a comparison

C

OVERRIDE( NOIXCLOSE )

None

Ignores the CLOSE attribute of an index in comparison

C

OVERRIDE( NOIXCLUSTER )

None

Ignores the CLUSTER attribute for indexes in a comparison

C

OVERRIDE( NOIXCOMPRESS )

None

Ignores the COMPRESS attribute of an index in a comparison.

C

OVERRIDE( NOIXCOPY )

None

Ignores the COPY attribute of an index in a comparison

C

OVERRIDE( NO-IX-DATATYPE ) 

None

Ignores the XML index data type in a comparison

C

OVERRIDE( NO-IX-EXPRESSIONS )

None

Ignores the text of the index on expression for indexes in a comparison

C

OVERRIDE( NO-IX-FORCE-XML )

None

Compare does not drop and rebuild an index when one of the indexes is an XML index

C

OVERRIDE( NO-IX-KEY-COLS )

None

Ignores key columns for indexes in a comparison

C

OVERRIDE( NO-IX-KYTEXT-XML )

None

Ignores the text for XML indexes in a comparison

C

OVERRIDE( NOIXNULLX )

None

Ignores the NULL attribute for indexes in a comparison

C

OVERRIDE( NOIXPADDED )

None

Ignores the PADDED attribute of an index in a comparison

C

OVERRIDE( NOKEYLABEL )

None

Ignores the KEYLABEL attribute for tables in a comparison

C

OVERRIDE( NOLENGTHCOL )

None

Ignores the length or scale attributes of table columns in a comparison

C

OVERRIDE( NOLIMITKEYS )

None

Ignores LIMITKEY attribute of a partitioned table space in a comparison when you include partition attributes in a comparison.

C

OVERRIDE( NOLOGTS )

None

Ignores the LOG attribute of a table space in a comparison.

C

OVERRIDE( NOMAINTBY )

None

Ignores the MAINTED BY attribute for materialized query tables in a comparison

C

OVERRIDE( NOMASKTEXT )

None

Ignores the text for column masks in a comparison

C

OVERRIDE( NOMAXPRTS )

None

Ignores the the MAXPARTITIONS attribute of a table space in a comparison.

C

OVERRIDE( NOMQTTEXT )

None

Ignores the text for materialized query tables in a comparison

C

OVERRIDE( NONULLRULE )

None

Ignores the NULL attribute of table columns in a comparison

C

OVERRIDE( NOPACKPATH )

None

Ignores the PACKAGE PATH attributes for stored procedures in a comparison

C

OVERRIDE( NOPERMTEXT )

None

Ignores the text for row permissions in a comparison

C

OVERRIDE( NOPIECESIZE )

None

Ignores the PIECESIZE attribute of an index in a comparison.

C

OVERRIDE( NO-PRIMARY-CONSTRAINTS )

UCPKPALL=N

Ignores the primary key constraint in a baseline or comparison when you exclude unique constraints

B, C

OVERRIDE( NOQUERYOPT )

None

Ignores the query optimization attribute of materialized query tables in a comparison

C

OVERRIDE( NOSEQ-OBJ-ATTRS )

None

Ignores attributes for sequences in a comparison

C

OVERRIDE( NOSEQUENCES )

None

Ignores sequences in a comparison

C

OVERRIDE( NOSPACTIVE )

None

Ignores the active version attribute for stored procedures in a comparison

C

OVERRIDE( NOSPASUTIME )

None

Ignores the ASUTIME option for stored procedures in a comparison

C

OVERRIDE( NOSPCCSID )

None

Ignores the CCSID option for stored procedures in a comparison

C

OVERRIDE( NOSPCOLLID )

None

Ignores the package collection ID option for stored procedures in a comparison

C

OVERRIDE( NOSPCOMMITRETURN )

None

Ignores the commit on return option for stored procedures in a comparison

C

OVERRIDE( NOSPCONACCRESO )

None

Ignores the concurrent access resolution option for stored procedures in a comparison

C

OVERRIDE( NOSPCONCENTRATE )

(BMC.DB2.SPE2510)

OVERRIDE( NOSPCURRENTDATA )

None

Ignores the CURRENTDATA option for stored procedures in a comparison

C

OVERRIDE( NOSPDATAACC )

None

Ignores the SQL DATA ACCESS option for stored procedures in a comparison

C

OVERRIDE( NOSPDATEFORMAT )

None

Ignores the date format option for stored procedures in a comparison

C

OVERRIDE( NOSPDBINFO )

None

Ignores the DBINFO option for stored procedures in a comparison

C

OVERRIDE( NOSPDEBUGMODE )

None

Ignores the DEBUG MODE option for stored procedures in a comparison

C

OVERRIDE( NOSPDECIMAL )

None

Ignores the DECIMAL option for stored procedures in a comparison

C

OVERRIDE( NOSPDEFERPREPARE )

None

Ignores the DEFER PREPARE option for stored procedures in a comparison

C

OVERRIDE( NOSPDEGREE )

None

Ignores the degree option for stored procedures in a comparison

C

OVERRIDE( NOSPDETERMINISTIC )

None

Ignores the deterministic option for stored procedures in a comparison

C

OVERRIDE( NOSPDYNRULES )

None

Ignores the dynamic rules option for stored procedures in a comparison

C

OVERRIDE( NOSPEXPLAIN )

None

Ignores the EXPLAIN option for stored procedures in a comparison

C

OVERRIDE( NOSPEXTNAME )

None

Ignores the external name option for stored procedures in a comparison

C

OVERRIDE( NOSPFORUPD )

None

Ignores the FOR UPDATE clause option for stored procedures in a comparison

C

OVERRIDE( NOSPIMMEDWRITE )

None

Ignores the IMMEDIATE WRITE option for stored procedures in a comparison

C

OVERRIDE( NOSPISOLEVEL )

None

Ignores the isolation level option for stored procedures in a comparison

C

OVERRIDE( NOSPJAVA )

None

Ignores the JAR SCHEMA, JAR ID, and JAVA SIGNATURE options for stored procedures in a comparison

C

OVERRIDE( NOSPKEEPDYN )

None

Ignores the KEEP DYNAMIC option for stored procedures in a comparison

C

OVERRIDE( NOSPLANGUAGE )

None

Ignores the implementation language option for stored procedures in a comparison

C

OVERRIDE( NOSPMAXFAIL )

None

Ignores the maximum number of failures option for stored procedures in a comparison

C

OVERRIDE( NOSPOPTHINT )

None

Ignores the OPTHINT option for stored procedures in a comparison

C

OVERRIDE( NOSPPACKOWNER )

None

Ignores the package owner option for stored procedures in a comparison

C

OVERRIDE( NOSPPARAMETERS )

None

Ignores the parameter attributes for stored procedures in a comparison

C

OVERRIDE( NOSPPARMCCSID )

None

Ignores the PARAMETER CCSID option for stored procedures in a comparison

C

OVERRIDE( NO-SPPARMCDL )

None

Ignores the parameters for stored procedures in a comparison, but displays a message that differences exist in the parameters

C

OVERRIDE( NOSPPARMDATATYPE )

None

Ignores the data type of the parameter for stored procedures in a comparison

C

OVERRIDE( NOSPPARMFORBIT )

None

Ignores the subtype of the parameter for stored procedures in a comparison

C

OVERRIDE( NOSPPARMINOUT )

None

Ignores the row type of the parameter for stored procedures in a comparison

C

OVERRIDE( NOSPPARMLOC )

None

Ignores the location of the parameter for stored procedures in a comparison

C

OVERRIDE( NOSPPARMNAME )

None

Ignores the name of the parameter for stored procedures in a comparison

C

OVERRIDE( NOSPPARMORDER )

None

Ignores the ordinal number of the parameter for stored procedures in a comparison

C

OVERRIDE( NOSPPARMSTYLE )

None

Ignores the PARAMETER STYLE option for stored procedures in a comparison

C

OVERRIDE( NOSPPARMVCHAR )

None

Ignores the varying length string parameter for stored procedures in a comparison

C

OVERRIDE( NOSPPROGRAMTYPE )

None

Ignores the PROGRAM TYPE option for stored procedures in a comparison

C

OVERRIDE( NOSPQUALIFIER )

None

Ignores the qualifier option for stored procedures in a comparison

C

OVERRIDE( NOSPREGISTERS )

None

Ignores the SPECIAL REGISTER option for stored procedures in a comparison

C

OVERRIDE( NOSPRELEASEAT )

None

Ignores the release option for stored procedures in a comparison

C

OVERRIDE( NOSPREOPT )

None

Ignores the REOPT option for stored procedures in a comparison

C

OVERRIDE( NOSPRESULTSET )

None

Ignores the result sets option for stored procedures in a comparison

C

OVERRIDE( NOSPROUNDING )

None

Ignores the ROUNDING option for stored procedures in a comparison

C

OVERRIDE( NOSPRUNOPTS )

None

Ignores the RUNOPTS option for stored procedures in a comparison

C

OVERRIDE( NOSPSECURITY )

None

Ignores the EXTERNAL SECURITY option for stored procedures in a comparison

C

OVERRIDE( NOSPSQLPATH )

None

Ignores the SQL path (PATHSCHEMAS) option for stored procedures in a comparison

C

OVERRIDE(NOSPSTAYRESIDENT)

None

Ignores the STAY RESIDENT option for stored procedures in a comparison

C

OVERRIDE( NOSPTEXT )

None

Ignores the text option for stored procedures in a comparison

C

OVERRIDE( NOSPTFORMAT )

None

Ignores the time format option for stored procedures in a comparison

C

OVERRIDE( NOSPVALIDATE )

None

Ignores the VALIDATE option for stored procedures in a comparison

C

OVERRIDE( NOSPWLMENV )

None

Ignores the WLM environment option for stored procedures in a comparison

C

OVERRIDE( NOSPWLMNEST )

None

Ignores the WLM environment for nested calls option for stored procedures in a comparison

C

OVERRIDE( NOSQLID )

None

Ignores the SQLID attribute for aliases, indexes, tables, or views in a comparison

C

OVERRIDE( NOSTOREDPROCS )

None

Ignores stored procedures in the scope of a comparison

C

OVERRIDE( NOSUBTYPE )

None

Ignores the subtype of a column of a table in a comparison

C

OVERRIDE( NOSYSTIME )

None

Ignores the PERIOD SYSTEM_TIME  and VERSIONING_TABLE attributes for tables in a comparison

As a result, the following syntax is not included in the CDL: ALTER PERIOD, ADD PERIOD, PERIOD, and DROP PERIOD SYSTEM_TIME, as well as VERSIONING_TABLE <NONE>, HISTORY, and EXTRA_ROW.

C

OVERRIDE( NOSYSTIMES )

None

Ignores the system-time sensitive option for stored procedures and advanced triggers in a comparison

C

OVERRIDE( NOSYS-VTB )

None

Ignores the VERSIONING_TABLE attribute for tables in a comparison

C

OVERRIDE( NOTBAUDIT )

None

Ignores the AUDIT attribute of a table in a comparison

C

OVERRIDE( NOTBCCSID )

None

Ignores the CCSID attribute for tables in a comparison

C

OVERRIDE( NOTBCONTROL )

None

Ignores the CONTROL attribute for tables in a comparison

C

OVERRIDE( NOTBDEFVALUE )

None

Ignores the default value of a column in a table in a comparison

C

OVERRIDE( NOTBEDITPROC )

None

Ignores the EDITPROC attribute for tables in a comparison

C

OVERRIDE( NO-TB-MAINTBY )

None

Ignores the MAINTAINEDBY attribute for tables in a comparison

C

OVERRIDE( NO-TB-QOPT )

None

Ignores the QUERYOPT attribute for tables in a comparison

C

OVERRIDE( NOTBTSAUTO )

None

Does not apply automatic change rules to match up all of the table's table space names when comparing at the table level

C

OVERRIDE( NOTBVALIDPROC )

None

Ignores the VALIDPROC attribute for tables in a comparison

C

OVERRIDE( NO-TCP-KEYS )

None

Ignores the partitioning key columns for table-controlled partitioning table spaces in a comparison

C

OVERRIDE( NO-TCP-PARTS )

None

Ignores the partitions for table-controlled partitioning table spaces in a comparison

C

OVERRIDE( NOTRACTIVE )

None

Ignores the active version attribute for advanced triggers in a comparison

C

OVERRIDE( NOTRASUTIME )

None

Ignores the ASUTIME option for advanced triggers in a comparison

C

OVERRIDE( NOTRCCSID )

None

Ignores the CCSID option for advanced triggers in a comparison

C

OVERRIDE( NOTRCONACCRESO )

None

Ignores the concurrent access resolution option for advanced triggers in a comparison

C

OVERRIDE( NOTRCONCENTRATE )

OVERRIDE( NOTRCURRENTDATA )

None

Ignores the CURRENTDATA option for advanced triggers in a comparison

C

OVERRIDE( NOTRDEBUGMODE )

None

Ignores the DEBUG MODE option for advanced triggers in a comparison

C

OVERRIDE( NOTRDECIMAL )

None

Ignores the DECIMAL option for advanced triggers in a comparison

C

OVERRIDE( NOTRDYNRULES )

None

Ignores the dynamic rules option for advanced triggers in a comparison

C

OVERRIDE( NOTREXPLAIN )

None

Ignores the EXPLAIN option for advanced triggers in a comparison

C

OVERRIDE( NOTRIGTEXT )

None

Ignores the text for triggers in a comparison

C

OVERRIDE( NOTRIMMEDWRITE )

None

Ignores the IMMEDIATE WRITE option for advanced triggers in a comparison

C

OVERRIDE( NOTRISOLEVEL )

None

Ignores the isolation level option for advanced triggers in a comparison

C

OVERRIDE( NOTROPTHINT )

None

Ignores the OPTHINT option for advanced triggers in a comparison

C

OVERRIDE( NOTRQUALIFIER )

None

Ignores the qualifier option for advanced triggers in a comparison

C

OVERRIDE( NOTRRELEASEAT )

None

Ignores the release option for advanced triggers in a comparison

C

OVERRIDE( NOTRROUNDING )

None

Ignores the ROUNDING option for advanced triggers in a comparison

C

OVERRIDE( NOTRSECURE )

None

Ignores the secure attribute for triggers in a comparison

C

OVERRIDE( NOTRSQLPATH )

None

Ignores the SQL path (PATHSCHEMAS) option for advanced triggers in a comparison

C

OVERRIDE( NOTRWLMENV )

None

Ignores the WLM environment option for advanced triggers in a comparison

C

OVERRIDE( NOTSCCSID )

None

Shows the differences between the values of the CCSID attribute for table spaces when the value of one of the attributes is the default

C

OVERRIDE( NOTSCLOSE )

None

Ignores the CLOSE attribute of a table space in a comparison

C

OVERRIDE( NOTSNULLRULE )

None

Ignores the NULL attribute of the TIMESTAMP column data type for tables in a comparison

C

OVERRIDE( NOUDTCOLS )

None

Ignores schema differences for table columns in a comparison

C

OVERRIDE( NOVIEWTEXT )

None

Ignores the text for views in a comparison

C

OVERRIDE( NOVWQUAL )

None

Ignores the QUALIFIED attribute (explicit qualifier) of a view in a comparison.

C

OVERRIDE( PRESERVEPAD )

None

If the value of the PADDED attribute for an index is not specified, Compare uses the value of Y instead of using the value from the DSNZPARM

C

OVERRIDE( PSIZE-FORCE )

None

Shows the differences between the values of the PIECESIZE attribute of indexes when one of the attributes has a default value

C

OVERRIDE( SG-CLASSES )

None

Ignores the STORCLASS, MGMTCLASS, and DATACLASS attributes for storage groups in a comparison

C

OVERRIDE( SG-KEYLABEL )

None

Ignores the KEYLABEL attribute for storage groups in a comparison

C

OVERRIDE( SHOWZPIECESIZE )

None

Shows the differences between the values of the PIECESIZE attribute of indexes when one of the attributes does not have a value, and the parent table space is not included in the scope of the comparison

Compare shows a value of 0 for the attribute that does not have a value.

C

OVERRIDE( SKIPAUXLD )

None

Ignores the auxiliary indexes in a comparison

C

OVERRIDE( SPNOTEXT )

None

Ignores the text for stored procedures in a comparison

C

OVERRIDE( SPOWNER )

None

Shows the differences between the owners of stored procedures

By default, the product does not compare the owners.

B, BR, C

OVERRIDE( SPTEXT-TRACE )

None

Provides a hex dump of the text for a stored procedure when all of the following conditions are met:

• The product retrieves the information from the SYSIBM catalog.
• Compare detects a difference between the text for Compare1 and Compare2.

B, BR, C

OVERRIDE( SQ-MAX-VALUE )

None

Ignores the MAXVALUE attributes for sequences in a comparison

C

OVERRIDE( SQ-MIN-VALUE )

None

Ignores the MINVALUE attributes for sequences in a comparison

C

OVERRIDE( SQOWNER )

None

Ignores the owner for sequences in a comparison

C

OVERRIDE( SQ-START-VALUE )

None

Ignores the START WITH attribute for sequences in a comparison

C

OVERRIDE( STARTVALUE )

None

Shows the differences between the values for the START WITH attribute for identity columns in tables, unless the NOSTARTVALUE keyword is specified

C

OVERRIDE( TBDB-IGNORE )

None

Ignores the database name for tables in a comparison

C

OVERRIDE( TBTS-IGNORE )

None

Ignores the table space name for tables in a comparison

C

OVERRIDE( TS-OWNER )

None

Shows the differences between the values for the owner attribute for table spaces 

C

OVERRIDE( UCNN )

None

Shows the differences between two unique constraints when one unique constraint has a three-part explicit name and the other unique constraint has no name (part three is not specified).

C

PARALLEL

PARALLEL=Y

A

PARTCOPY

PARTCPY=Y

A

PIC

PIC=[Y,N]

Takes an image copy of each table space before it drops a database or table, or before it drops and reorganizes a table space.

A

PKEYPROP

None

Propagates column attribute changes on a primary key to the tables of the foreign keys that are connected to that primary key.

This propagation applies only to changes in the DATATYPE, LENGTH, DECIMAL, FIELDPROC, and FIELDPROCPARM attributes.

A

PLANMGMTBASIC

PLANMGMT=B

If the PLANMGMT column in the SYSIBM.SYSPACKAGE table for a package is blank, the Analysis generates a PLANMGMT(BASIC) option for the package REBIND statement. Otherwise, Analysis uses the SYSIBM.SYSPACKAGE PLANMGMT column to generate the PLANMGMT option for the package REBIND statement.

You must manually insert this keyword into the ALUIN input stream to override the installation option.

A

PLANMGMTEXTENDED

PLANMGMT=E

If the PLANMGMT column in the SYSIBM.SYSPACKAGE table for a package is blank, the Analysis generates a PLANMGMT(EXTENDED) option for the package REBIND statement. Otherwise, Analysis uses the SYSIBM.SYSPACKAGE PLANMGMT value to generate the PLANMGMT option for the package REBIND statement.

You must manually insert this keyword into the ALUIN input stream to override the installation option.

A

PROTECT

None

Protects the baseline that you are creating from being deleted.

A, B

UNQUALIFY=N

Creates the tables, indexes, or views in the worklist with a qualified name

When you set this keyword in the ALUIN input stream, Analysis follows the Db2 default behavior where both the CREATOR and OWNER of the object are the part1 (the qualifier of the object).

You must manually add this keyword to the ALUIN input stream.

A

REBINDADVANCED

REGENATR=N

A

REBINDNATIVE

REGENNSP=N

Rebinds a package that is associated with a native SQL stored procedure by generating the REBIND PACKAGE command in a worklist.

You must manually insert this keyword into the ALUIN input stream.

See also the REGENNATIVE keyword in this table.

A

REBUILD

None

Creates a new worklist if a previous worklist was created for the same work ID.

This keyword is required if the status of the work ID is analyzed.

A

REFRESH

REFRESH=Y

Uses the REFRESH TABLE statement to refresh the data in a materialized query table (MQT).

You can manually add this keyword to the ALUIN input stream.

See also the NOREFRESH keyword in this table.

A

REGENADVANCED

REGENATR=Y

Rebinds an advanced trigger by generating the ALTER TRIGGER with a REGENERATE VERSION clause in a worklist.

You must manually insert this keyword into the ALUIN input stream.

See also the REBINDADVANCED keyword in this table.

A

REGENIDENTITY

None

Enables Db2 to assign a unique value to a column that is defined with GENERATED ALWAYS AS IDENTITY.

You must manually add this keyword to the ALUIN input stream.

See also the NOREGENIDENTITY keyword in this table.

A

REGENNATIVE

REGENNSP=Y

Rebinds a package that is associated with a native SQL stored procedure by generating the ALTER PROCEDURE statement with the REGENERATE clause in a worklist.

You must manually insert this keyword into the ALUIN input stream.

See also the REBINDNATIVE keyword in this table.

A

REGISTER (parameters)

COPYDD01=R

COPYDD02=R

RECVDD01=R

RECVDD02=R

A

REM ('comment')

None

Allows a baseline comment (with a length of 62 characters) to be entered.

B

REMARKS  (comment)

None

Allows a comment (with a length of 254 characters) to be entered for an alter-type work ID used with import or a comparison

C,I

RENAMECOL=Y

C

REORGALL

REORGALL=Y

Reorganizes a table space when a reorganization would be applicable.

See also the REORGPENDONLY keyword in this table.

A

REORGCDC
(BMC.DB2.SPE2507)

REORGCDC=Y

Analysis always reorganizes a table space when the following conditions are true:

• The table space contains a table that has the DATA CAPTURE attribute set to CHANGE.
• You are altering or rebuilding either the table space or the table it contains.

For example, we would reorganize the table space when altering the table, even though it is an immediate alter and does not require a reorganization.

See also the NOREORGCDC keyword in this table.

A

REORGREF

REORGREF=Y

A

REORGONLINE

REORGONL=Y

A

REORGNONE

REORGREF=N

Reorganizes a table space by using the SHRLEVEL NONE option when an online reorg (SHRLEVEL CHANGE) is not applicable or is not requested.

See also the REORGREF keyword in this table.

A

REORGPDD

REORGPDD=Y

Specifies that reorganizations be included in the worklist for objects with pending DDL that resulted from an alter in the worklist.

You must also specify the REORGPENDONLY keyword with the REORGPDD keyword. See the REORGPENDONLY keyword in this table.

See also the NOREORGPDD keyword in this table.

A

REORGPENDONLY

REORGALL=N

Reorganizes a table space when the table space requires a reorganization (for example, the table space is in REORG-pending status).

If you specify the REORGPDD keyword, you must also specify the REORGPENDONLY keyword. See the REORGPDD keyword in this table.

See also the REORGALL keyword in this table.

A

REPLACE

None

Specifies that existing work IDs are replaced with the REPLICATE WORKID statement.

See also the NOREPLACE keyword in this table.

P

REPLACEWORKID a.b

None

Replaces an existing work ID.

The AEXIN input stream also uses this keyword.

E, F, I, P

REPORT (DETAIL)

None

Creates comparison report information as comments in the CDL file.

The comments include all of the CREATE, ALTER, and DROP statements for a comparison.

C

REPORTTYPE BASELINE

None

Specifies the baseline report.

BR

RESMAXIC nnnnn

None

A

RETAINMAX n

None

Retains n number of complete baselines and delete all others that were created with the specified baseline profile.

See also the RETAINMAX nnnn keyword in the AJXIN input stream.

B

REUSEWORKID

None

Replaces the work ID in the ALUIN input stream with the work ID listed in the previous -WKID worklist command.

P

ROLEOWN

ROLEOWN=Y

Allows objects to be created where the owner, creator, or grantor is a ROLE.

A

RPLUSYNCAUTO

RPLUSYNC=A

A

RPLUSYNCREPLACE

RPLUSYNC=R

A

SCOPE1 objectOwner. objectName

None

Names a baseline profile or an outbound migrate profile that contains scope rules.

You would use SCOPE1 SSID.objectOwner.objectName if you wanted to name a baseline profile on a remote subsystem. To specify a three-part name, you would have to edit the keyword manually.

SCOPE1 corresponds to the primary set of input in a comparison.

This keyword replaces the SCOPEPROFILE keyword.

C

SCOPE2 objectOwner.objectName

None

Names a baseline profile or an outbound migrate profile that contains scope rules.

SCOPE2 SSID.objectOwner.objectName names a baseline profile on a remote subsystem. To specify a three-part name, you must manually edit the keyword in the ALUIN input stream.

SCOPE2 corresponds to the secondary set of input in a comparison.

This keyword replaces the SCOPEPROFILE keyword.

C

SCOPERULE1 (objectOwner object name_part1. name_part2)

None

C

SCOPERULE2 (objectOwner object [name_part1. name_part2])

None

Specifies the owner and the name of an object that limits the scope of database and table space comparisons when comparing two Db2 catalogs.

Compare uses SCOPERULE2 when you specify one catalog object and its dependents as the scope of the comparison. SCOPERULE2 corresponds to the secondary set of input in the comparison. A space must separate each parameter.

C

SCOPETYPE type:type,type

None

Specifies the type of scope for a comparison.

The following values are valid for type:

• BASELINE is valid when specified in a profile.
• DDL is valid when specified for objects that are contained in a data definition language (DDL) file for the scope.
• MIGRATE is valid when specified in a profile.
• PROFILES is valid when you use a catalog baseline profile or an outbound migrate profile as the source of the scope rules in a comparison of one Db2 catalog to another Db2 catalog.
• RULE is valid for comparing one Db2 catalog to another Db2 catalog when you specify a catalog object and its dependents as the scope of the comparison.
• WORKLIST is valid when specified for a comparison that uses the objects that are contained in a worklist for the scope.

C

SHOWRULES

None

Displays the automatic change rules that are created when either of the following conditions exist:

• An outbound migrate profile (indicated by the CHANGERULESIN2 keyword) is not specified for a comparison of one Db2 catalog to another Db2 catalog.
• An outbound migrate profile is specified for any comparison (including a comparison of one Db2 catalog to another Db2 catalog).

C

SHRLEVELCHG

None

Uses image copies that are marked as either SHRLEVEL REFERENCE or SHRLEVEL CHANGE.

A

SHRLEVELREF

None

Uses image copies that are marked as SHRLEVEL REFERENCE.

A

SINGLEPHASE

None

Creates a single-phase worklist for migrating data structures within the same Db2 subsystem.

A

SMSINCLUDE [parameter]

None

Identifies the IBM Storage Management Subsystem (SMS) parameters that are included on the -AMS command in the worklist.

The following values are valid for parameter:

• STORCLAS
• MGMTCLAS
• DATACLAS

A

SORTDEVT

None

Specifies the device type to use for dynamically allocated SORTWORK data sets.

A

SOURCETYPE

None

B, I

SPANNEDRECS

SPANNED = Y

A

SPTEXT( EXACT )

CMPSPTXT=Y

Compares each character in the text for native SQL stored procedures verbatim.

Compare ignores the X'0D' carriage return.

C

SPTEXT( NOEXACT )

CMPSPTXT=N

Ignores extra blanks, blank lines, and character case (uppercase and lowercase) when comparing the text for native SQL stored procedures.

C

SSID ssid

None

Identifies the Db2 subsystem ID or the Db2 data sharing group attachment name.

The SSID keyword must match the -SSID command in the worklist. This parameter is required.

If the SSID is specified in the JCL in an EXEC statement in a cataloged procedure (which begins with a PROC statement), its value overrides the value of the SSID keyword.

The AEXIN and AJXIN input streams also use this keyword.

A, B, BR, E, F, I, J, P, S

STDRULES

None

Sets the CURRENT RULES special register to STD so that certain statements are executed in accordance with standard SQL rules. The default setting is Db2. For more information about the CURRENT RULES special register, see the IBM Db2 for z/OS documentation.

A

STOPCOMMIT

STOPCOMM=Y

Generates an AT(COMMIT) statement for every STOP command in the worklist.

This keyword can be manually added in the ALUIN input stream.

See also the NOSTOPCOMMIT keyword in this table.

A

STOPICP

STOPICP=Y

DUAL=Y

Specifies that all new partitioned objects must use table-controlled partitioning.

This keyword overrides the STOPICP=N or DUAL=N installation options.

This keyword must be manually added in the ALUIN input stream.

See also the ALLOWICP keyword in this table.

A

STOPLIST creatorName

STOPLIST= creatorName

Specifies the eight-character creator name for a migrate-type work ID that identifies a list of tables that should not be analyzed (stop list).

An example of a table that should not be analyzed might be those that are defined with the DATA CAPTURE CHANGES attribute. If a table is referenced in a work ID that is included in the stop list, Analysis issues an error message. The default value is blank.

See also the NOSTOPLIST keyword in this table.

A

SYNCPOINT parameter

SYNCPNT parameter

Creates additional -SYNC commands in a worklist, based on the number of -SQL commands since the last -SYNC command.

The variable parameter specifies the maximum number of -SQL commands that can be in the worklist before a -SYNC command is created. Valid values for parameter are from 0 through 99. The default is 10.

If this value is reached, Analysis places an additional -SYNC command before the next -SQL command. Any -SYNC command in the worklist resets the count of -SQL commands to zero.

The -SYNC commands that this keyword generates are in addition to the -SYNC commands that Analysis automatically generates.

A

TABLEACCESS

TABLEACC=Y

Allows outside access to tables during worklist execution.

You must manually add this keyword to the ALUIN input stream.

A

TABLEALL

TABLEALL=Y

Enables the BMCSTATS or IBM RUNSTATS utility to gather column statistics on all of the columns in all of the tables in a table space by including the TABLE ALL parameter in the -BMCS or -RNST worklist command.

A

TCPROTATE

None

A

TERMINATOR character

BLRTERMC=#

Specifies the character that the baseline report uses to separate SQL statements.

The default value is a pound sign (#). The value of character can be any character except a blank, comma (,), double quotation mark ('), single quotation mark ('), left parenthesis [(], right parenthesis [)], or underscore (_).

You must manually add this keyword to the ALUIN input stream.

BR

THRESHOLD n

None

Specifies the integer that limits the number of objects that the components pull from the Db2 catalog by using the nonunique catalog indexes.

The default limit is 100,069 objects. The valid range of values is 1 through 2,147,483,646 (or 2**31-2).

If the number of objects that are requested exceeds the limit, the nonunique catalog indexes are ignored. The relevant table space in the catalog is then scanned for the requested objects. For example, if the THRESHOLD is set to 100,069, and you request 100,100 objects, the product fully scans the table space instead of opening 100,100 Db2 cursors.

B, C

TRANSFORM

None

Checks the text for a view, trigger, check constraint, or materialized query table (MQT).

Analysis then extracts the required information that is needed to set the authorizations correctly.

You must manually add the keyword to the ALUIN input stream.

A

TRIAL

None

Specifies that the ALUIN input stream contains CM/PILOT Data Manipulation Language (DML), but that Analysis does not generate a worklist.

This keyword can also specify that Analysis generates only a report when the DELETE WORKID, DELETE SYNCTABLE, or REPLICATE WORKID statement is used.

A, P

TVALOFF

None

Does not use text validation for triggers.

The VALOFF ALUIN keyword replaces this keyword.

A, C, I

TVALWARN

None

Treats error conditions in trigger text as warnings.

If the component finds an error, it processes the trigger without propagation. Execution fails if the errors in a worklist have not been corrected.

For Compare and Import, you must manually add the keyword to the ALUIN input stream.

The VALWARN ALUIN keyword replaces this keyword.

A, C, I

UNLDCOLL

UNLDCOLL=Y

Requires explicit column lists on all of the UNLOAD PLUS utility unloads.

To provide explicit column lists on the IBM UNLOAD utility unloads, you must manually insert the keyword in the ALUIN input stream.

A, J

UNLOADCOPY-xx

None

A

UNLOADCOPYDS-xx

None

A

UNLOADEMPTY

UNLDEMPT=Y

Unloads tables that the IBM RUNSTATS utility indicates are empty.

See also the NOUNLOADEMPTY keyword in this table.

A

UNLOADTABLE

None

Specifies that an unload occurs from the Db2 table data set instead of from an image copy.

A

UNQUALIFY=Y

Analysis creates the tables, indexes, or views in the worklist with the following details:

• Object with an unqualified name
• CURRENT SQLID as the owner
• CURRENT SCHEMA as the creator

You must manually add this keyword to the ALUIN input stream.

When this keyword is specified, you must have the AUTHSW installation option set to N.

A

USENGTR

USENGTR=Y

A

USENGTUL

USENGTUL=Y

A

UTILCOPY

UTILCOPY=Y

A

UTILSTATS

STATS=U

A, F

VALOFF

None

Does not use text validation for triggers, views, or materialized query tables (MQTs).

This keyword replaces the TVALOFF and VVALOFF ALUIN keywords.

A, C, I

VALWARN

None

Treats error conditions in trigger, view, materialized query table (MQT), or index text as warnings.

If the component finds an error, the component processes the text without propagation. Execution fails if the errors in a worklist have not been corrected.

For Compare and Import, you must manually add the keyword to the ALUIN input stream.

This keyword replaces the TVALWARN and VVALWARN ALUIN keywords.

A, C, I

VVALOFF

None

Does not use text validation for views.

You must verify authorizations for any unqualified dependent objects.

The VALOFF ALUIN keyword replaces this keyword.

A, C, I

VVALPROP

VVALPROP=Y

A

VVALWARN

None

Downgrades conditions that are not found and certain syntax errors to warnings.

If an error is found, the diagnostic log records the specific error messages and the component does not propagate changes to the view text. Execution fails if the errors in a worklist have not been corrected.

For Compare and Import, you must manually add the keyword to the ALUIN input stream.

The VALWARN ALUIN keyword replaces this keyword.

A, C, I

WLORDER order

None

A

WLORDERMSG

None

Records in the SYSPRINT data set and in the worklist the amount of time to sort a worklist.

A

WORKID a.b

None

Specifies the work ID to use.

Execution fails if this work ID does not match the work ID that the -WKID command in the worklist specifies. The AEXIN and AJXIN input streams also use this keyword.

A, B, E, I

WORKIDMERGE

None

Merges imported DDL, CDL, or worklists with an existing work ID.

I