CM batch parameter definitions

Values:

TABLESET
TABLE
ROW
PARTITIONS
NONE

Default:

TABLESET

For details on the possible values of lock mode, see the information about lock_mode in SYSPROC.ACCEL_LOAD_TABLES (IBM DB2 Analytics Accelerator for z/OS 7.5).

If the specified value is greater than the function level that is supported by Db2 Admin Tool, a warning message is issued.

If the specified value is less than the current function level value of the Db2 subsystem, an error message is issued and the CM batch job is terminated.

Values:

An integer value in the range 501 - 999.

Default:

blank

A blank value means that CM batch jobs are not allowed to run if the current function level of the Db2 subsystem is greater than the function level that is supported by Db2 Admin Tool.

Related information:

• Adopting new capabilities in Db2 13 continuous delivery (Db2 13 for z/OS)
• Support for Db2 continuous delivery

Values:

Y

Specifies that the change identified by the CHANGE_OWNER and CHANGE_NAME parameters is analyzed. If a change is also being imported, the change that is analyzed is the change identified by the NEW_CHANGE_OWNER and NEW_CHANGE_NAME parameters. A change that is already in ANALYZED state is reanalyzed.

N

Specifies that no change is analyzed.

C

Same as the Y parameter value except that the analyze is not done if the change is already in the ANALYZED state. For the C parameter, return codes of 0 and 1 are defined as follows:

• 0 indicates that analyze is not done because the change is already in the ANALYZED state.
• 1 indicates that analyze is done, and no warnings or errors are issued. The state is the same the state of ACTION_ANALYZE_CHANGE = 'Y' with RC=0.

There are no changes to the meanings of other RC values.

blank

Specifies that this parameter defaults to Y if a change is imported during this call to the Change Management batch interface.

Default:

blank

Values:

Y

Specifies that a run job is created for the change identified by the CHANGE_OWNER and CHANGE_NAME parameters. If a change is also being analyzed, a run job is created for the change after it is analyzed.

N

Specifies to not create a run job for the change.

blank

Specifies that this parameter should default to Y if a change is analyzed during this call to the Change Management (CM) batch interface.

Default:

blank

Values

U

Specifies an unconditional cancel change. The specified change is canceled even if other changes have the change as a prerequisite. If other changes have the change as a prerequisite, the changes that depend on the change that is being canceled are set to DEFINED status and must be analyzed before being run. A list of changes that have the change to be canceled as a prerequisite are listed.

C

Specifies a conditional cancel change. The specified change is canceled if no other changes have the change as a prerequisite change. If other changes have the change as a prerequisite change, an error message is issued. A list of changes that have the change to be canceled as a prerequisite are listed.

N

Specifies to not cancel the change.

Default

N

Values

Y

Specifies to run Db2 Object Comparison Tool to define a change that can be managed by Db2 Admin Tool Change Management. A compare report and a delta change file is generated that can be imported as a new change. The delta change file attributes are taken from the parameters for ADMIN_DATASET_TYPE = 'DELTA'.

By specifying ACTION_COMPARE = 'Y' and ACTION_IMPORT_CHANGE = 'N', you can run Db2 Object Comparison Tool to just generate a compare report and delta change file, without importing the result as a change. This setting enables you to view the differences between the compare source and target, and perhaps run the compare multiples times to fine-tune the differences between the source and target. When no more compares are needed and the change is ready to be deployed, the delta change file can be imported as a new change.

The files with DD names that start with IMCHG are not used.

N

Specifies to not run Db2 Object Comparison Tool to define the change.

Default

N

Values:

Y

Converts the readable work statement list (WSL) to an ISPF table. The readable WSL is specified by the PDS_FOR_WSL_CONV and WORKLIST_NAME_CONV parameters. The ISPF WSL is specified by the PDS_FOR_WSL and WORKLIST_NAME parameters.

N

Does not convert the WSL.

Default:

N

Values:

Y

The WSL will be converted to a readable data set that is specified by the parameters PDS_FOR_WSL_CONV and WORKLIST_NAME_CONV.

N

Does not convert the WSL.

Default:

blank

Values

C

Specifies a conditional delete change. The specified change is deleted if no other changes have the change as a prerequisite. If other changes have the change as a prerequisite, an error message is issued. A list of changes that have the change to be deleted as a prerequisite are listed.

N

Specifies to not delete the change.

U

Specifies an unconditional delete change. The specified change is deleted even if other changes have the change as a prerequisite. If other changes have the change as a prerequisite, the changes that depend on the change that is being deleted are set to DEFINED status and must be analyzed before being run. A list of changes that have the change to be deleted as a prerequisite are listed.

Default

N

Values

C

Delete the mask if it is not associated with a registered change that needs the mask for implementation. If the mask is needed by one or more changes for implementation, the names of changes are displayed and the mask is not deleted.

CONDITIONAL mode does not cover the scenario in which changes can have a mask associated with it but the mask is no longer needed to implement the change. For example, when a change is imported using masking, after the import completes the mask is no longer needed to implement that change.

N

The delete mask action is not enabled.

U

Delete the mask even if it is associated with a registered change that needs the mask for implementation. The names of changes that need the mask for implementation are displayed and the mask is deleted.

UNCONDITIONAL mode does not cover the scenario in which changes can have a mask associated with it but the mask is no longer needed to implement the change. For example, when a change is imported using masking, after the import completes the mask is no longer needed to implement that change. In this scenario, UNCONDITIONAL does not report the imported change.

Default

N

//PARMS DD *

ACTION_EXPORT_CHANGE = 'ASIS'

CHANGE_OWNER = 'A'

CHANGE_NAME = 'C1';

CHANGE_OWNER = 'A'

CHANGE_NAME = 'C2';

The delta change file is created according the template for ADMIN_DATASET_TYPE = 'DELTA'. For more information about these templates, see Db2 Admin Tool data set templates .

Values

ASIS

The specified changes are exported in the order that is specified by the CHANGE_OWNER and CHANGE_NAME parameters.

PREREQ

Db2 Admin Tool analyzes the specified changes for prerequisites and includes any prerequisite changes for the listed changes.

NO

The changes are not exported.

Default

NO

Values:

AUTO

A base version is generated and the content is automatically determined by the product for the specified change entry. The content of the base version is based on the registered change statements for the specified change entry.

USER

A base version is generated and the content is determined by a user-specified version scope.

NO

A base version is not generated. However, this setting has no control over whether a base version is automatically generated as determined by the GENERATE_BASE_VERSION_BEFORE_RUN and GENERATE_BASE_VERSION_AFTER_RUN parameters.

Default:

NO

Values:

BEFORE_RUN

DDL and Db2 Admin Tool statements are generated for the base version that was created before the specified change was implemented.

AFTER_RUN

DDL and Db2 Admin Tool statements are generated for the base version that was created after the specified the change was implemented.

SOURCE

DDL and Db2 Admin Tool statements are generated for the base version that is recorded as the source base version for the specified change.

TARGET

DDL and Db2 Admin Tool statements are generated for the base version that is recorded as the target base version for the specified change.

USER

DDL and Db2 Admin Tool statements are generated for the user-specified base version that is identified by the BASE_VERSION_OWNER and BASE_VERSION_NAME parameters.

NO

DDL and Db2 Admin Tool statements are not generated for any base version.

Default

NO

Values:

Y

Generate JCL for one of the following WSLs:

• An existing WSL. In this case, you must specify the PDS_FOR_WSL parameter and the following parameter values:

  ACTION_COMPARE = 'N'
  ACTION_GENERATE_WSL = 'N'

• A WSL that is being generated while running a comparison that does not use Change Management. This action is indicated by the following parameter values:

  ACTION_COMPARE = 'Y'
  ACTION_GENERATE_WSL = 'Y'

  In this case, the PDS_FOR_WSL parameter is optional.

If you specify Y, the WORKLIST_NAME parameter is required and is used for the JCL member name. Optionally, you can use the PDS_FOR_RUN_JCL parameter to specify the name of partitioned data set (PDS). You cannot specify any other ACTION_xxxx parameter.

N

Do not generate JCL.

Default:

N

Values:

Y

Yes. A work statement list is generated when ACTION_COMPARE= Y. Such a work statement list can be run directly by specifying ACTION_RUN_WSL=Y.

If you specify Y, you must specify ACTION_IMPORT_CHANGE=N.

N

No. A WSL is not generated.

Default:

N

Values:

Y

If ACTION_COMPARE = 'N', specifies that the content of files IMCHG001 up through IMCHG999 are imported into a new change. You do not need to define all of the IMCHG* files must be defined. For example, only 2 DDL files or delta change files is imported, you need to define only IMCHG001 and IMCHG002.

If ACTION_COMPARE = 'Y', specifies that the result of the compare is imported as a new change. The contents of the files with names IMCHG001 through IMCHG999 are not imported as a new change.

N

Specifies that no importing of a change is done.

blank

Specifies that this parameter defaults to Y if either of the following is true:

1. ACTION_COMPARE = 'N', and the IMCHG001 DD is defined and not empty.
2. ACTION_COMPARE = 'Y'.

Default:

blank

Values:

Y

Specifies that the content of the IMIGNORE DD statement is imported into a new ignore.

N

Specifies that no importing of an ignore is done.

blank

Specifies that this parameter defaults to Y if the IMIGNORE DD statement is defined and not empty.

Default:

blank

Optionally, use the NEW_MASK_OWNER and NEW_MASK_NAME parameters to specify the owner and the name of the imported mask.

Values:

Y

Specifies that the content of the IMMASK DD statement is imported into a new mask.

N

Specifies that no importing of a mask is done.

blank

Specifies that this parameter defaults to Y if the IMMASK DD statement is defined and not empty.

Default:

blank

Values:

Y

Specifies to recover the change.

N

Specifies to not recover the change.

Default:

N

Values:

Y

Runs the change.

N

Does not run the change.

Default:

N

Values:

Y

Runs the work statement list. The PDS_FOR_WSL parameter must be provided to indicate the PDS where the work statement list resides. The WORKLIST_NAME parameter must be provided to specify the PDS member.

N

Does not run the WSL.

Default:

N

Values:

YES

The automatic check process is performed.

NO

The automatic check process is not performed.

Default:

NO

Values:

YES

The product automatically attempts a REBUILD if the object is in the ARBDP state.

However, if the parameter RUN_REORG_REBUILD was specified as 'A - All relevant' to generate an explicit REBUILD during the change flow, then the value NO is passed to ADBTEP2. The NO value prevents an automatic REBUILD that duplicates the explicit REBUILD.

NO

The product does not automatically attempt a REBUILD if the object is in the ARBDP state.

Default:

NO

Values:

YES

The product automatically attempts a REORG if the object is in AREOR or AREO* state.

However, if the parameter RUN_REORG_REBUILD was specified as 'A - All relevant' to generate an explicit REORG during the change flow, then the value NO is passed to ADBTEP2. The NO value prevents an automatic REORG that duplicates the explicit REORG.

NO

The product does not automatically attempt a REORG if the object is in AREOR or AREO* state.

Default:

NO

Values:

YES or Y

An automatic rebind will be performed when packages are invalidated by processed statements.

NO or N

An automatic rebind will be not performed.

ALL or A

An automatic rebind will be performed when packages are invalidated by processed statements. Additionally, a REBIND command is generated when a new index is created on the table so that the access paths are refreshed for dependent packages. ALL requires the ADBTEP2_AUTOREBIND_APREUSE value to be NONE or blank.

Default:

NO

If ADBTEP2 is processing a REBIND statement that was generated by Object Compare, ADBTEP2 does not generate the same REBIND operation.

If you request that automatic rebinds be performed (ADBTEP2_AUTOREBIND = YES or ALL), you can set the following additional values to control the REBIND options:

• ADBTEP2_AUTOREBIND_APREUSE
• ADBTEP2_AUTOREBIND_EXPLAIN
• ADBTEP2_AUTOREBIND_OWNER
• ADBTEP2_AUTOREBIND_OWNERTYPE
• ADBTEP2_AUTOREBIND_ADDITIONAL_OPTS

Values:

NONE or N

APREUSE(NONE) is added to the REBIND statement.

WARN or W

APREUSE(WARN) is added to the REBIND statement.

ERROR or E

APREUSE(ERROR) is added to the REBIND statement.

blank

The APREUSE option is not added to the REBIND statement.

Default:

blank

Values:

YES or Y

EXPLAIN(YES) is added to the REBIND statement.

NO or N

EXPLAIN(NO) is added to the REBIND statement.

ONLY

EXPLAIN(ONLY) is added to the REBIND statement

blank

The EXPLAIN option is not added to the REBIND statement.

Default:

blank

Values:

A valid owner name. The maximum length is 128 characters.

Default:

blank

Values:

USER or U

OWNERTYPE (USER) is added to the REBIND statement.

ROLE or R

OWNERTYPE (ROLE) is added to the REBIND statement.

blank

The OWNERTYPE option is not added to the REBIND statement.

Default:

blank

Values:

A string up to 325 characters. The specified additional options are added to the REBIND statement as is; the syntax is not checked or formatted. The specified options apply only to rebinds of packages with TYPE=' ' (blank) and not to trigger, procedure, or function packages.

Default:

blank

Values:

YES

The product automatically attempts a REBUILD if the object is in one of these states: RBDP, RBDP*, or PSRBD state.

However, if the parameter RUN_REORG_REBUILD was specified as 'M - Mandatory' or 'A - All relevant' to generate an explicit REBUILD during the change flow, then the value NO is passed to ADBTEP2. The NO value prevents an automatic REBUILD that duplicates the explicit REBUILD.

NO

The product does not automatically attempt a REBUILD if the object is in one of these states: RBDP, RBDP*, or PSRBD state.

Default:

YES

Values:

YES

The product automatically attempts a REORG if the object is in the REORP state.

However, if the parameter RUN_REORG_REBUILD was specified as 'M - Mandatory' or 'A - All relevant' to generate an explicit REORG during the change flow, then the value NO is passed to ADBTEP2. The NO value prevents an automatic REORG that duplicates the explicit REORG.

NO

The product does not automatically attempt a REORG if the object is in the REORP state.

Default:

YES

Values:

MAXE

The failed command is written to the ADBHOLD table. The MAXERROR setting (as specified by the ADBTEP2_MAXE parameter) determines if the processing stops immediately, after nn errors, or if the bind error does not stop processing.

SAVE

The failed command is written to the ADBHOLD table. Processing continues.

IGNORE

The failed command is not written to the ADBHOLD table. Processing continues.

Default:

MAXE

Values:

-1

All errors are ignored. The batch job does not stop for any error.

0

No errors are allowed. The batch job stops on the first error.

1-99

The specified number of errors are ignored. The batch job stops on the next DSN command that fails. For example, if you specify 5, the batch job stops when the sixth DSN command fails.

For more information about MAXE, see Parameters passed to the ADBTEP2 program.

Default:

0

Values:

YES

The DROP is not performed if a Db2 pending change exists.

NO

The DROP is performed without checking for pending changes.

Default:

NO

Values:

Y

Yes. RESTART(YES) is used when ADBTEP2 is called.

N

No. RESTART(NO) is used when ADBTEP2 is called.

F

Force. RESTART(FORCE) is used when ADBTEP2 is called.

U

User. RESTART(USER_RESTART_NAME) is used when ADBTEP2 is called. If you specify U, you must specify a value for the ADBTEP2_USER_RESTART_NAME parameter.

Default:

Y

Values:

A valid restart location. 1 - 128 characters.

Default:

blank

Values:

CKPT

Uses the environment variables from the checkpoint record during the restart, if they are present.

INPUT

Runs set statements in the WSL before the restart point.

BOTH

Uses the environment variables from the checkpoint record during the restart, if they are present, and runs set statements in the WSL before the restart point.

Default:

The default value is blank.

Values:

Y

Yes

N

No

Default:

blank

Values:

A valid SQL ID. 1 - 8 characters.

Default:

blank

Values:

A valid schema name. 1 - 128 characters.

Default:

blank

Values:

A valid location name. 1 - 16 characters.

Default:

blank

Values:

A valid path name. 1 - 254 characters.

Default:

blank

Values:

A valid precision value. 1 - 5 characters.

Default:

blank

Values:

DB2

SQL statements are run based on Db2 rules.

STD

SQL statements are run based on standard SQL rules.

Default:

The default value is blank.

Values:

• ROUND_CEILING
• ROUND_DOWN
• ROUND_FLOOR
• ROUND_HALF_DOWN
• ROUND_HALF_EVEN

Default:

blank

Values:

Valid routine version names. 1 - 64 characters.

Default:

blank

Values:

Valid business time values. 1 - 10 characters.

Default:

blank

Values:

Valid system time values. 1 - 10 characters.

Default:

blank

Values:

Y

Yes. When a table-reference is an archive-enabled table, the table reference includes rows in the associated archive table.

N

No. When a table-reference is an archive-enabled table, the table reference does not include rows in the associated archive table.

Default:

N

Values:

Y

Yes. When a row in an archive-enabled table is deleted, a copy of the deleted row is stored in the associated archive table.

N

No. When a row in an archive-enabled table is deleted, a copy of the deleted row is not stored in the associated archive table.

Default:

N

Values:

E

ADBTEP2 ends with an error.

U

The table space is unloaded.

Default:

The default value is blank.

Values:

E

ADBTEP2 ends with an error.

U

The table space is unloaded.

Default:

The default value is blank.

This parameter applies only if you are running at Db2 12 function level 504 or higher.

Values:

Yes

Retry the statement.

When the current application compatibility level is Db2 12 function level 504 or higher, and an SQL statement returns SQLCODE -20008 (because it is trying to create a deprecated object), ABDTEP2 takes the following actions:

• Sets the APPLCOMPAT value to V12R1M503
• Retries the statement
• Changes APPLCOMPAT back to the previous value.

No

Do not retry the statement.

Default:

Yes

Values:

Yes

Adds a SPANNED keyword to the UNLOAD statement when the table that is being unloaded has an XML or LOB column.

No

Spanned keyword is not added to Unload statement.

Default:

No

Values:

YES

The product automatically attempts a REORG or REBUILD for the table space or index after SQL statement ALTER STOGROUP is executed. However, if the parameter RUN_REORG_REBUILD was specified as 'A - All relevant' to generate an explicit REORG or REBUILD during the change flow, then the value NO is passed to ADBTEP2. The NO value prevents an automatic REORG or REBUILD that duplicates the explicit REORG or REBUILD.

NO

The product does not automatically attempt a REORG or REBUILD for the table space or index after SQL statement ALTER STOGROUP is executed.

Default:

NO

• For a timeout condition with SQLCODE -913 and reason code x'00C9008E' or a resource unavailable condition (SQLCODE -904 and reason code x'00C200EA'), ADBTEP2 retries executing the statement.
• For a timeout condition with SQLCODE -911 and reason code x'00C9008E', ADBTEP2 tries restarting from the last checkpoint.

Values:

An integer value from 0 to 99. A value of 0 means that ADBTEP2 is not to attempt any retries.

Default:

0

Values:

An integer value from 1 to 3600.

Default:

120

Values:

YES

The access state of the table space is preserved.

NO

The access state of the table space is not preserved.

Default:

NO

Values:

An integer value 1-255, blank

blank

The BUFNO attribute is not specified for the ALLOCATE statement.

Default:

blank

Values:

A valid data class name

Db2 Admin Tool does not validate this value. If an invalid value is specified, an error message is generated from TSO when the allocate of the data set is attempted. Db2 Admin Tool then sets the RECFM, LRECL, and BLKSIZE attributes by specifying these attributes on the ALLOCATE statement. By default, Db2 Admin Tool specifies the space attributes on the allocate statement but you can omit the space attributes from the ALLOCATE statement by specifying ADMIN_DATASET_SPACE_PRIQTY = '<NONE>' for the Db2 Admin Tool.

blank

The DATACLAS attribute is not specified for the ALLOCATE statement.

Default:

blank

Values:

A valid device unit, <NONE>

<NONE>

Specifies that the UNIT clause is omitted from the ALLOCATE statement.

Default:

SPACE_UNIT_NAME (See SPACE_UNIT_NAME.)

If the SPACE(priqty,secqty) clause is omitted, then no default value is specified.

Values:

An integer greater than zero, blank

blank

If the SPACE(priqty,secqty) clause is not to be omitted, specifies that the following default values are used for the Db2 Admin Tool data set type that is in effect:

• IFF: 60. A user specified value for directory blocks that you specify only if the Db2 Admin Tool default is insufficient for the change that is being analyzed.
• DELTA: 60
• DDL: 60
• SRCVF: 60
• TGTVF: 60
• MTC: 60

Default:

blank

Values:

A valid data set name.

The data set name can be 1 to 46 characters or blank.

blank

Specifies that the following default values are to be used for the indicated Db2 Admin Tool data set type that is in effect:

• CHG: &SSID..&CHGTAG..CHG
• DDL: &SSID..&CHGTAG..T&TIME..DDL
• DELTA: D&DATE..T&TIME..DELTA
• IFF: &SSID..&CHGTAG..IFF
• MTC: &SSID..D&DATE..T&TIME..MTC
• SRCVF: OC.D&DATE..T&TIME..SRCVF
• TGTVF: OC.D&DATE..T&TIME..TGTVF

Default:

blank

Values:

LIBRARY, PDS, blank

blank

For data set type IFF, the default is PDS. Otherwise the DSNTYPE attribute is not added to the ALLOCATE statement.

Default:

blank

Values:

A valid expiration date as defined for the EXPDT attribute for the TSO ALLOCATE statement, blank

blank

The EXPDT attribute is not specified for the ALLOCATE statement.

Default:

blank

Values:

A valid maxvol value as defined by the TSO ALLOCATE statement

Db2 Admin Tool does not validate this value. If an invalid value is specified, an error message is generated from TSO when the allocate of the data set is attempted.

blank

The MAXVOL attribute is not specified for the ALLOCATE statement.

Default:

blank

Values:

A valid management class name

Db2 Admin Tool does not validate this value. If an invalid value is specified, an error message is generated from TSO when the allocate of the data set is attempted.

blank

The MGMTCLAS attribute is not specified for the ALLOCATE statement.

Default:

blank

Values:

An integer value representing the number of days, blank

blank

The RETPD attribute is not specified for the ALLOCATE statement.

Default:

blank

Values:

A valid PRIQTY value, <NONE>, blank

<NONE>

Specifies that the SPACE(priqty,secqty), unit of space clauses, and space directory attributes be omitted from the ALLOCATE statement.

blank

Specifies that the following default values are to be used for the indicated Db2 Admin Tool data set type that is in effect:

• CHG: 10
• DDL: 10
• DELTA: 10
• IFF: 2
• MTC: 10
• SRCVF: 10
• TGTVF: 10

Default:

blank

If the SPACE(priqty,secqty) clause is omitted, then no default value is specified.

Values:

A valid SECQTY value, blank

blank

If the SPACE(priqty,secqty) clause is not to be omitted, the following default values are used for the Db2 Admin Tool data set type that is in effect:

• CHG: 10
• DDL: 10
• DELTA: 10
• IFF: 2
• MTC: 10
• SRCVF: 10
• TGTVF: 10

Default:

blank

If the SPACE(priqty,secqty) clause is omitted, no default value is specified.

Values:

CYL

Specifies that the space unit type is cylinders.

TRK

Specifies that the space unit type is tracks.

blank

Specifies that the following default values are used for the Db2 Admin Tool data set type that is in effect:

• CHG: CYL
• DDL: CYL
• DELTA: CYL
• IFF: CYL
• MTC: CYL
• SRCVF: CYL
• TGTVF: CYL

Default:

blank

Values:

A valid storage class name

Db2 Admin Tool does not validate this value. If an invalid value is specified, an error message is generated from TSO when the allocate of the data set is attempted.

blank

The STORCLAS attribute is not specified for the ALLOCATE statement.

Default:

blank

You can specify multiple data set types. Separate each type with a semicolon. All data set template parameters that are specified before the next semicolon in the parameter list apply to the type of data set specified. For more information about the syntax of specifying the data set type parameters, see Db2 Admin Tool data set templates.

Values:

CHG

The CHG data set.

Recommendation: When generating a recover change, use CHG_RO or CHG_RE. Specifying CHG when generating a recover change affects the CHG data set for only the change itself; it does not affect the CHG data set for the recover change. If CHG_RO or CHG_RE is not specified, the default recover change CHG data set is created.

CHG_RO

The CHG data set for a recover to original data change. A recover to original data change is specified by the following two options:

• GENERATE_RECOVER_CHANGE = ‘Y’
• DATA_TO_RECOVER = ‘O’ or DATA_TO_RECOVER = ‘B’

CHG_RE

The CHG data set for a recover to existing data change. A recover to existing data change is specified by the following two options:

• GENERATE_RECOVER_CHANGE = ‘Y’
• DATA_TO_RECOVER = ‘E’ or DATA_TO_RECOVER = ‘B’

DDL

The DDL Admin data set. This data set is the output data set when generating DDL from a base version.

DELTA

The compare delta change file.

IFF

The IFF PDS Db2 Admin Tool data set.

Recommendation: When generating a recover change, use IFF_RO or IFF_RE. Specifying IFF when generating a recover change affects the IFF data set for only the change itself; it does not affect the IFF data set for the recover change. If IFF_RO or IFF_RE is not specified, the default recover change IFF data set is created.

IFF_RO

The IFF PDS Db2 Admin Tool data set for a recover to original data change. A recover to original data change is specified by the following two options:

• GENERATE_RECOVER_CHANGE = ‘Y’
• DATA_TO_RECOVER = ‘O’ or DATA_TO_RECOVER = ‘B’

IFF_RE

The IFF PDS Db2 Admin Tool data set for a recover to existing data change. A recover to existing data change is specified by the following two options:

• GENERATE_RECOVER_CHANGE = ‘Y’
• DATA_TO_RECOVER = ‘E’ or DATA_TO_RECOVER = ‘B’

MTC

The multi-target change file.

SRCVF

A compare source version work file.

TGTVF

A compare target version work file.

blank

The Db2 Admin Tool data set template parameters are ignored until a supported value for ADMIN_DATASET_TYPE is specified.

Default:

blank

Values:

One or more serial numbers separated by a comma, blank

blank

The VOLUME attribute is not specified for the ALLOCATE statement.

Default:

blank

Values:

YES

Excluded objects can be dropped implicitly.

NO

Excluded objects cannot be dropped implicitly.

Default:

NO

Values:

Y

Revert PBR2 table space objects back to PBR.

N

Do not revert PBR2 table space objects back to PBR.

Default:

N

Values:

Y

Generate the rotate partition statement. Data from the rotating partitions is unloaded before the rotate takes place. You can either reload the data or discard it.

N

Generate the alter partition statement. Data from the rotating partitions is reloaded into the table. Logical and physical partitions are preserved.

Default:

Y

Values:

An SQLID with SECADM authority

Specify a SECADM authority to manage all security-related tasks.

Default:

blank

Values:

An SQLID

The ID to connect as when auth-switching.

<NONE>

Avoids producing auth-switch work-statement lists (WSL).

<SQLID>

Enables the SQLID authorization switching feature.

blank

Produces auth-switch WSL, with the ID portion of the WSL as comments.

Default:

<NONE>

Values:

Y

Auth-switching is used if an auth-switch ID is specified.

N

Auth-switching is used.

Default:

N

Values:

YES or Y

An ALTER VIEW REGNERATE statement is generated for each view that references the affected columns. If no such views exist, no statements are generated.

NO or N

No ALTER VIEW REGNERATE statements are generated.

Default:

NO

Values:

1 to 128 characters

Default:

blank

Values:

Valid change name; 1 to 128 characters. If CHGTAG_TYPE ='NAME', the change name must be 1 to 8 characters due to data set naming restrictions.

Default:

AUTO:&CURTS.

Values:

Valid change owner; 1 to 128 characters

Default:

&CURSQLID.

Values:

ID

The &CHGTAG. symbol variable value is based on the Db2 Admin Tool generated change ID.

NAME

The &CHGTAG. symbol variable value is based on the user specified change name.

OWNER

The &CHGTAG. symbol variable value is based on the user specified change owner.

Default:

ID

Values:

A valid ignore changes name, blank

A valid ignore changes name; 1 to 128 characters

Specify a 1- to 128-character Ignore Changes Specification is used during the compare process.

blank

Ignore changes is not used during the compare process.

Default:

blank

Values:

Specify a valid 1- to 128-character ignore changes owner.

Default:

&CURSQLID.

Values:

A valid data set name

The data set must contain ignore fields and be a fixed block sequential data set or a member of a partitioned data set with a record length of 80 (RECFM=Fx, LRECL=80). The input must be in columns 1-72 of the data set.

Syntax:

objecttype: field1,field2, .... ,fieldn

where objecttype is the Db2 catalog table name and fieldn : is the Db2 catalog column to be ignored

Examples:

SYSDATABASE: BPOOL
SYSDATABASE: INDEXBP,STGROUP
SYSTABLESPACE: BPOOL
SYSTABLEPART: PQTY,SQTY,STORNAME,VCATNAME
SYSINDEXES: INDEXSPACE
SYSINDEXPART: PQTY,SQTY,STORNAME,VCATNAME

Ignore fields are applied to both the target and the source objects before the definitions are compared.

Related information:

• Translation masks and ignore fields (IBM Db2 Object Comparison Tool for z/OS 13.1.0)

Default:

blank

Values:

A valid ignore fields name, blank

A valid ignore fields name

Specify a 1- to 128-character Ignore Fields name. The specified Ignore Fields Specification is used during the compare process.

Default:

blank

Values:

Specify a 1- to 128-character Ignore Fields owner.

Default:

&CURSQLID.

Values:

A valid data set name

The data set must contain masks and must be a fixed block sequential data set or a member of a partitioned data set with a record length of 80 (RECFM=Fx, LRECL=80). The input must be in columns 1-72 of the data set.

Here are some mask definition examples:

NAME: ABC*, DEF*
NAME: HLQ*D*, NEW**
OWNER: SYSIBM,MYCAT

Masks are applied to the source objects before they are compared with the target. You can define as many masks as you want; however, defining many masks will degrade the performance of compare. The first left hand mask that matches are used and the name is translated to the right hand value. If no match is found it is not translated, but still participate in the compare. Using the above masks a source database with the name 'HLQ47D9' is translated to 'NEW479' before it is compared with the target databases.

Related information:

• Translation masks and ignore fields (IBM Db2 Object Comparison Tool for z/OS 13.1.0)

Default:

blank

Values:

Specify a valid 1- to 128-character mask name.

Default:

blank

Values:

Specify a valid 1- to 128-character mask owner.

Default:

&CURSQLID.

Values:

Specify a 1- to 128-character comment or leave this parameter blank.

Default:

blank

Values:

Number of days until eligible for auto-delete

Specify a number in the range 1-9999.

blank

No auto-deletion will take place.

Default:

blank

Values:

Name for the compare results.

Specify a valid 1- to 128-character compare results name.

Default:

AUTO:&CURTS.

Values:

Owner of the compare result

A valid 1- to 128 character name of the compare results owner.

Default:

&CURSQLID.

Values:

A

Generate all jobs and processes to reload data.

D

Generate only SQL.

Restriction: You must set the CONTENT_OF_APPLY_JOBS parameter to A if the GENERATE_RECOVER_CHANGE parameter is set to Yes.

Default:

A

Values:

O

Recover using the original data. The original data is the data that is unloaded when the original change is run. If you use the original data during a recovery operation, consider whether related tables that were not affected by the recover must also be restored to the same point to avoid inconsistencies. This option applies only to tables that were unloaded in the original change.

E

Recover using the existing data. The existing data is the data that exists in the table just before the original change is recovered. If a table is dropped without being re-created in the original change, no data is loaded after the table is created in the recover change.

B

Set up recover with both the existing data and the original data, so that you will have the choice to recover with either type of data. (At the time of recovery, you can specify RECOVER_OPTION=’O’ or RECOVER_OPTION=’E’).

N

Do not use any data to do recover. This option allows for a recovery with DDL only.

Default:

E

Values:

Valid library names. 1 - 44 characters.

Default:

blank

Values:

Valid library names. 1 - 44 characters.

Default:

blank

Values:

Specify a valid PRIQTY value.

Default:

30

Values:

Specify a valid SECQTY value.

Default:

30

This parameter is useful when multiple REORG operations are performed on the same table space because of a change.

Values:

Y

Disables the optimization of REORG statements.

N

REORG statements are optimized. The minimum number of REORG operations are used to try to avoid multiple REORG operations on the same table space.

Default:

N

Values:

Y

Display the multi-target change statements

N

Do not display the multi-target change statements.

Default:

N

Values:

YES

Do not force this option.

NO

Force this option.

Default:

N

Values:

Y

Perform a run-time analyze. If the product detects that the latest Db2 catalog information is not used but is needed, the run process will fail with an error. The change will need to be analyzed again before it can be run.

N

A runtime analyze is not done before a change is run.

Default:

Y

Values:

YES or Y

If a table on the target has foreign keys and the table also exists on the source, all foreign keys that are not also on the source will be dropped from the target.

NO or N

The drop behavior is determined by the SUPPRESS_DROP_OF_OBJECTS parameter.

Default:

NO

Values:

Y

Enables accelerated tables.

N

Does not enable accelerated tables.

Default:

Y

If ENABLE_ACCELERATED_TABLES is set to YES, RELOAD_ACCELERATED_TABLES must also be set to YES.

Values:

REPLACE

The existing base version is replaced with the new base version.

AUTO

The specified base version name is not used. Instead, Db2 Admin Tool uses the product default value for a base version name, such as AUTO:&CURTS.. A warning message is issued to notify you of this event.

Default:

AUTO

Values:

REPLACE CONDITIONAL

Replace the change if it is not a prerequisite for other changes. If the change is a prerequisite for other changes, an error message is issued. The names of changes that are dependent on the change are displayed and the replace change request is not processed.

REPLACE UNCONDITIONAL

Replace the change even if it is a prerequisite for other changes. The names of changes that are dependent on the change are displayed.

The change status of changes that are dependent on the change is changed to DEFINED, and the changes must be analyzed before being run.

STOP

Do not replace the change.

Default:

STOP

• CHG sequential file
• IFF PDS
• WSL PDS member
• JCL PDS member
• run job input PDS

Values:

CONDITIONAL

If the data set or PDS member already exists, and the data set or PDS member is already associated with the change from a previous CM action, replace the data set or PDS member. If the data set or PDS member already exists, and the data set or PDS member is not already associated with the change, stop processing.

REPLACE

If the data set or PDS member already exists, replace it.

STOP

If the data set or PDS member already exists, stop processing.

Default:

CONDITIONAL

Values:

REPLACE CONDITIONAL

Replace the mask if it is not associated with a registered change that needs the mask for implementation. If the mask is needed by one or more changes for implementation, the names of changes are displayed and the mask is not replaced.

REPLACE CONDITIONAL mode does not cover the scenario in which changes can be associated with a mask but the mask is no longer needed to implement the change. For example, when a change is imported using masking, after the import completes the mask is no longer needed to implement that change. The mask, however, is still associated with the change.

REPLACE UNCONDITIONAL

Replace the mask even if it is associated with a registered change that needs the mask for implementation. The names of changes that need the mask for implementation are displayed and the mask is replaced. Only the changes that need the mask for implementation are reported.

REPLACE UNCONDITIONAL mode does not cover the scenario in which changes can be associated with a mask but the mask is no longer needed to implement the change. For example, when a change is imported using masking, after the import completes the mask is no longer needed to implement that change. In this scenario, REPLACE UNCONDITIONAL does not report the imported change. The mask, however, is still associated with the change.

STOP

Do not replace the mask.

Default:

STOP

Values:

A valid 1- to 128-character exclude specification name, blank

Default:

blank

Values:

A valid 1- to 128-character exclude specification owner.

Default:

&CURSQLID

Values:

AUTO

Db2 Admin Tool automatically determines the objects that are in the base version based on the objects that are being changed.

USER

The objects that are in the base version are defined by a version scope that is specified by the user.

NO

A new base version is not generated after the change is implemented.

Default:

NO

Values:

AUTO

Db2 Admin Tool automatically determines the objects that are in the base version based on the objects that are being changed.

USER

The objects that are in the base version are defined by a version scope that is specified by the user.

NO

A new base version is not generated after the change is implemented.

Default:

NO

Values:

Y

Generate a job class parameter with the value of the JOB_CLASS parameter.

N

Do not generate a job class parameter.

Default:

Y

Values:

Y

A recover change is generated during analyze.

N

If the change does not have a recover change, a recover change is not generated. Otherwise, this parameter is forced to be set to Y and the recover change is regenerated.

Default:

N

Values:

Y

Use the user-defined templates in the ADBTEMPL DD data definition. Refer to Symbol variables in the ADBTEMPL file: Db2 TEMPLATE support for information about using symbol variables to specify Db2 TEMPLATE statements.

N

Use the Db2 Admin Tool default template statements.

Default:

N

Values:

C

Generates the GRANT statement with the CREATE prefix.

P

Generates the GRANT statement with the POSTUTIL prefix.

Default:

C

Values:

O

The START value from the Db2 catalog is used.

C

The START value is computed based on the identity attributes of the column.

Default:

O

Values:

YES

The column order is ignored. When possible, column changes are done by using ALTER statements.

NO

The column order is not ignored. If necessary to preserve the column order, column changes are made by dropping and recreating the table.

Default:

NO

Values:

Specify a 1- 128-character comment or leave this parameter blank.

Default:

blank

Values:

Specify a valid 1- 128-character ignore name.

Default:

AUTO:&CURTS.

Values:

Specify a valid 1- 128-character ignore owner.

Default:

&CURSQLID.

Values:

P

Make the pending changes a prerequisite for the imported change.

S

Supersede the pending changes and continue importing the change. The pending changes are placed in DEFINED status and will have the superseded change as a prerequisite.

I

Ignore the pending changes and continue importing the change. Analyzed pending changes are left in ANALYZED status and prerequisites are not established.

C

Cancel the import change process.

Default:

P

Values:

Specify a 1- to 72-character statement.

Default:

//&USERID.D JOB (&SYSUID),'CM BATCH',

Values:

Specify a 1- to 72-character statement.

Default:

// REGION=0K,NOTIFY=&SYSUID,MSGCLASS=H,MSGLEVEL=(1,1),

Values:

Specify a 1- to 72-character statement.

Default:

blank

Values:

Specify a 1- to 72-character statement.

Default:

blank

Values:

Specify a 1- to 72-character statement.

Default:

blank

Values:

Specify a valid job class.

Default:

A

Values:

Specify a 1- to 72-character statement.

Default:

blank

The following example shows how to set this parameter:

JOB_JCLLIB_LINE_1 = '//GOCCM JCLLIB ORDER=ADB.DEVCUST.JCLLIB’

//GOCCM JCLLIB ORDER=ADB.DEVCUST.JCLLIB

Values:

Specify a 1- to 72-character statement.

Default:

blank

Values:

Specify a 1- to 72-character statement.

Default:

blank

Values:

Specify a 1- to 72-character statement.

Default:

blank

Values:

Specify a 1- to 72-character statement.

Default:

blank

The following example shows how to set this parameter:

JOB_PARM_LINE_1='S=SYS4A'

/*JOBPARM S=SYS4A

Values:

Specify a 1- to 72-character statement.

Default:

blank

Values:

Specify a 1- to 72-character statement.

Default:

blank

Values:

Specify a 1- to 72-character statement.

Default:

blank

• A list of the parameter values that were provided in an invocation override (by using the PARMS DD statement)
• A list of the final parameter values that were used

Values:

Y

These two lists are included. Each list is identified in ADBMSGS by message ADB7957I.

N

These lists are not included.

Default:

N

Values:

DATA

For information about DATA, see the description of detectChanges in SYSPROC.ACCEL_LOAD_TABLES (IBM DB2 Analytics Accelerator for z/OS 7.5).

PARTITIONS

For information about PARTITIONS, see the description of detectChanges in SYSPROC.ACCEL_LOAD_TABLES (IBM DB2 Analytics Accelerator for z/OS 7.5).

NONE

DetectChanges is not used when calling SYSPROC.ACCEL_LOAD_TABLES.

Default:

DATA

Values:

Specify a 1- 128-character comment or leave this parameter blank.

Default:

blank

Values:

YES

Masks are applied to ignored fields.

NO

Ignored fields retain their original values.

Default:

NO

Values:

Specify a 1- 128-character mask name or leave this parameter blank.

Default:

AUTO:&CURTS.

Values:

Specify a 1- 128-character mask owner or leave this parameter blank.

Default:

&CURSQLID.

Values:

Specify an integer value.

Default:

3145680

Values:

Specify a valid PRIQTY value. You can specify the following values:

• A number that indicates the number of space units specified.
• Blank, which causes the kilobyte value shown to be converted to a value that is measured in terms of the space specified.
• 99999999, which indicates the maximum space allowed by MVS™ for the space unit that is specified.

Default:

3145680

To use MTC_CENTRAL_LOCATION, a DRDA connection is required between the central and remote subsystems.

Values:

Specify a valid Db2 location name.

Default:

blank

Values:

Specify a 1- to 128-character change name or leave this parameter blank.

Default:

blank, which results in the value of the CHANGE_NAME parameter being used as the name for the new change.

Values:

Specify a 1- to 128-character change owner or leave this parameter blank.

Default:

blank, which results in the value of the CHANGE_OWNER parameter being used as the name for the new change owner.

Values:

Specify a 1- to 128-character ignore name or leave this parameter blank.

Default:

blank, which results in the value of the IGNORE_NAME parameter being used as the name for the new ignore.

Values:

Specify a 1- to 128-character ignore owner or leave this parameter blank.

Default:

blank, which results in the value of the IGNORE_OWNER parameter being used as the name for the new ignore owner.

Values:

Specify a 1- to 128-character mask name or leave this parameter blank.

Default:

blank, which results in the value of the MASK_NAME parameter being used as the name for the new mask name.

Values:

Specify a 1- to 128-character mask owner or leave this parameter blank.

Default:

blank, which results in the value of the MASK_OWNER parameter being used as the name for the new mask owner.

Values:

YES

If integration with InfoSphere Optim Configuration Manager (OCM) is enabled and the action on error setting is set to allow the override parameter, Db2 Admin Tool continues processing the change even if the OCM repository database and the backup tables on the local system are not available.

NO

If integration with InfoSphere Optim Configuration Manager (OCM) is enabled, Db2 Admin Tool stops processing the change if the OCM repository database and the backup tables on the local system are not available.

Default:

NO

Values:

A valid PDS data set name

Specify a 1- to 46-character data set name. If this name is not enclosed in single quotation marks, the fully qualified data set name is PREFIX_FOR_DATA_SETS.PDS_FOR_RECOVER_JCL.

Default:

&SSID..RECOVER.JCL

Values:

A valid PDS data set name

Specify a 1- to 46-character data set name. If this name is not enclosed in single quotation marks, the fully qualified data set name is PREFIX_FOR_DATA_SETS.PDS_FOR_RECOVER_WSL.

Default:

&SSID..RECOVER.WSL

Values:

A valid PDS data set name

Specify a 1- to 46-character data set name. If this name is not enclosed in single quotation marks, the fully qualified data set name is PREFIX_FOR_DATA_SETS.PDS_FOR_RUN_JCL.

Default:

&SSID..RUN.JCL

Values:

A valid PDS data set name

Specify a 1- to 46-character data set name. If this name is not enclosed in single quotation marks, the fully qualified data set name is PREFIX_FOR_DATA_SETS.PDS_FOR_RUN_JOB_INPUT.

Default:

&SSID..&CHGTAG..IN

Values:

A valid PDS data set name

Specify a 1- to 46-character data set name. If this name is not enclosed in single quotation marks,, the fully qualified data set name is PREFIX_FOR_DATA_SETS.PDS_FOR_WSL.

Default:

&SSID..RUN.WSL

Values:

Valid PDS data set names. 1 - 46 characters. If the name is not enclosed in single quotation marks, the fully qualified data set name is PREFIX_FOR_DATA_SETS.PDS_FOR_WSL_CONV.

Default:

blank

Values:

A number in the range 0-100.

Default:

0

Values:

Specify a 1- to 8-character Db2 plan name.

Default:

ADB

Values:

Specify a 1- to 17-character data set prefix.

Default:

&USERID.

Values:

YES

The table is dropped and recreated (by using UNLOAD, DROP, CREATE, and LOAD operations) so that the column data is preserved.

NO

The column is altered by using ALTER TABLE statements, which results in data loss for the affected columns. If you want to save a copy of the data, specify UNLOAD_ALTERED_TABLES = YES.

Default:

YES

Values:

T

Object type processing will be performed. This process compares one object type at a time.

H

Database hierarchy processing will be performed. This process compares all object types within a database hierarchy at the same time. This is the default value.

Note: If you choose not to disable REORG optimization, the compare process will set your PROCESSING_ORDER value to H and continue processing using REORG optimization.

Default:

H

Options must be in the format option_name(option_value). For example:

REBIND_ADDITIONAL_OPTS = 'FLAG(I) IMMEDWRITE(NO)'

The specified additional options are added to the REBIND statement as is; the syntax is not checked or formatted.

Values:

One or more valid REBIND options. The maximum total length of this value is 325 characters.

Default:

blank

Values:

NONE or N

APREUSE(NONE) is added to the REBIND statement.

WARN or W

APREUSE(WARN) is added to the REBIND statement.

ERROR or E

APREUSE(ERROR) is added to the REBIND statement.

blank

The APREUSE option is not added to the REBIND statement.

Default:

blank

Values:

YES or Y

EXPLAIN(YES) is added to the REBIND statement.

NO or N

EXPLAIN(NO) is added to the REBIND statement.

ONLY or O

EXPLAIN(ONLY) is added to the REBIND statement

blank

The EXPLAIN option is not added to the REBIND statement.

Default:

blank

This option is not generated for REBIND TRIGGER PACKAGE statements.

Values:

A valid owner name. The maximum length is 128 characters.

Default:

blank

REBIND_OWNERTYPE is used only if REBIND_OWNER is also specified. REBIND_OWNERTYPE is ignored if the Db2 subsystem version is earlier than Db2 13.

Values:

USER or U

OWNERTYPE (USER) is added to the REBIND statement.

ROLE or R

OWNERTYPE (ROLE) is added to the REBIND statement.

blank

The OWNERTYPE option is not added to the REBIND statement.

Default:

blank

Values:

Specify a 1- to 128-character comment or leave this field blank.

Default:

blank

Values:

Specify a 1- to 128-character change name.

Default:

The name of original change with _RCVR appended

Values:

Specify a 1- to 128-character change owner.

Default:

The owner of original change

Values:

O

Recover using the original data. The original data is the data that is unloaded when the original change is run. If you use the original data during a recovery operation, consider whether related tables that were not affected by the recover must also be restored to the same point to avoid inconsistencies. This option applies only to tables that were unloaded in the original change.

E

Recover using the existing data. The existing data is the data that exists in the table just before the original change is recovered. If a table is dropped without being re-created in the original change, no data is loaded after the table is created in the recover change.

D

Recover with DDL only and ignore data.

Default:

blank

Recover using the option that was specified when the recover change was set up. If DATA_TO_RECOVER= 'B' or RECOVER_WITHDDL = ‘Y’, blank is not valid; you must specify a value for RECOVER_OPTION.

Values:

S

This option recovers the specified change and set to DEFINED status for any pending change that modifies the same or related objects. The recover change supersedes any pending changes that modify the same or related objects.

C

This option prevents the change from being recovered when pending changes will modify the same or related objects. If there are pending changes, the changes are not recovered. To recover this change and to set the status of any pending changes to DEFINED, set the value of this parameter to S (supersede).

Default:

C

Values:

Y

Recover change can recover using DDL only and ignore data.

N

Recover change can not recover using DDL only.

Default:

N

Values:

YES

Recreate accelerated tables.

NO

Do not recreate accelerated tables.

Default:

YES

Y

Reload accelerated tables.

N

Do not reload accelerated tables.

Default:

Y

If RELOAD_ACCELERATED_TABLES is set to YES, RECREATE_ACCELERATED_TABLES must also be set to YES.

Values:

YES

Remove accelerated tables.

NO

Do not remove accelerated tables.

Default:

YES

Values:

Y

Replicates accelerated tables.

N

Does not replicate accelerated tables.

Default:

Y

If REPLICATE_ACCELERATED_TABLES is set to YES, RELOAD_ACCELERATED_TABLES must also be set to YES.

Values:

Y

The report includes the expected conversion problems for tables when the change is run.

N

The report does not include a list of expected conversion problems.

Default:

N

Values:

Y

The report includes statistics of compared and changed objects for each object type.

N

The report does not include the object count statistics.

Default:

N

The Totals Report contains the overall totals of objects affected and includes values from the Analyze step from each of the target systems.

Values:

Y

The report includes the object totals report.

N

The report does not include the object totals report.

Default:

N

Values:

Y

The report does not include objects that are identical in the source and target.

N

The report includes objects that are identical in the source and the target.

Default:

N

Values:

Y or YES

The summary report is to include the original names. In the report, the original name is listed under Source Object, and the new name is listed under Target Object.

N or NO

The summary report is not to include the original names.

Default:

N

Values:

Y

The report includes the statement totals report.

N

The report does not include the statement totals report.

Default:

N

Values:

Y

The report includes a brief summary of changes for each object.

N

The report does not include a brief summary.

Default:

N

Values:

Y

The report includes system generated names of the fields that are ignored by the compare or analyze process.

N

The report does not include system generated names of the fields that are ignored.

Default:

N

Values:

Y, N

Y

The report includes the masks used by the compare or analyze process.

N

The report does not include the masks that are used.

Default:

N

Values:

Y

The report includes user-defined names of the fields that are ignored by the compare or analyze process.

N

The report does not include user-defined names of the fields that are ignored.

Default:

N

Values:

Y

Retain the GENERATED ALWAYS attribute for row change time stamp columns.

N

Do not retain the GENERATED ALWAYS attribute for row change time stamp columns.

Default:

N

Values:

Y

Retain the GENERATED ALWAYS attribute for rowid columns.

N

Do not retain the GENERATED ALWAYS attribute for rowid columns.

Default:

N

Values:

Y

Generate a CHECK DATA utility job for each table space that is affected by a LOAD utility.

N

Do not generate a CHECK DATA utility job.

Default:

N

Values:

M

Generate REBIND statements for packages only if packages are invalidated by the changes.

A or Y

Generate REBIND statements for packages and plans that are affected by the change.

N

Do not generate REBIND statements.

Default:

N

Values:

M

Mandatory. Generate REORG utility statements to remove REORG-pending conditions.

A

All relevant. Generate all needed REORG utility statements to fully implement the effects of the changes, for example, space parameter changes.

N

None. No REORG utility statements are generated. This option is invalid if you specified NO for ALLOW_ROTATE_PARTS.

Default:

N

Values:

R

Generate RUNSTATS utility statements for all tables that are affected by the (RE)LOAD utility.

A

Generate RUNSTATS utility statements for all altered table space, table, and index objects.

B

Generate RUNSTATS utility statements for objects that are affected by the RE(LOAD) utility and SQL ALTER statements.

M

Generate RUNSTATS utility statements for the following conditions:

• If a table space is dropped and recreated, the tables and indexes are included in RUNSTATS.
• If a table is dropped and recreated, only the indexes, and not the table, are included in RUNSTATS.
• If an index is created, recreated, or has columns added, the index is included in RUNSTATS.
• If the index is created with DEFER YES and REBUILD is generated, RUNSTATS is performed after the REBUILD.

N

No RUNSTATS utility statements are generated.

Default:

N

Values:

An SQLID

The specified Run SQLID is the owner of databases and table spaces. If the specified Run SQLID is different from the current owner, the databases, table spaces, and all dependent objects are dropped and re-created to accomplish the change of owner.

<NONE>

No SET CURRENT SQLID statements are generated.

blank

SET CURRENT SQLID statements are generated when necessary.

Default:

blank

Values:

YES, NO

Default:

NO

Values:

Y

The source base version generated during analyze is saved as a new base version.

N

The source base version generated during analyze is not saved.

Default:

N

Values:

Y

The target base version that was generated during analyze is saved as a new base version.

N

The source base version during analyze is not saved.

Default:

N

Values:

Y

Message ADB7353W is issued for this situation. This message is issued regardless of the value of the value of the Suppress DROP of objects field on the Generate Compare Jobs (GOC5) panel.

N

No message is issued.

Default:

N

Values:

ORIGINAL, COMPUTED

Default:

ORIGINAL

Values:

A data set name

Specify a 1- to 46-character data set name. If SOURCE_TYPE = 'DDL', specify the name of the data set that contains the DDL for the compare source.

If SOURCE_TYPE = 'USER', specify the name of the data set that contains the list of Db2 Admin Tool quick scopes for the compare source.

blank

If SOURCE_TYPE = 'DDL', the SRCIN file must contain the DDL for the compare source.

If SOURCE_TYPE = 'USER', either the SOURCE_VERSION_SCOPE_OWNER and SOURCE_VERSION_SCOPE_NAME parameters must be specified, or the SRCIN file must contain the list of Db2 Admin Tool quick scopes for the compare source.

Default:

blank

Values:

A valid exclude specification name, blank

A valid exclude specification name.

Specify a 1- to 128-character exclude specification name. The specified Exclude Specification is used for the source during the compare process.

blank

Exclude objects are not used for the compare source.

Default:

blank

Values:

Specify a valid 1- to 128-character exclude specification owner.

Default:

&CURSQLID.

Values:

Y

Generate the DDL.

D

Generate the DDL and extract foreign keys for tables that are dependent on the tables being extracted.

N

Do not generate DDL.

Default:

blank

Values:

Specify a valid 1- to 128-character location name that is defined in SYSIBM.LOCATIONS or leave this parameter blank to specify the local Db2 subsystem.

blank

The local Db2 subsystem.

Default:

blank

Values:

DDL

The source is DDL. To specify the data set that contains the DDL, use the compare source input file (SRCIN DD) or the SOURCE_DSN parameter. If the SOURCE_DSN parameter is not specified, the compare source input file (SRCIN DD) must be pre-allocated.

USER

The source is a Db2 subsystem, and the list of object names is provided by the user. To specify the list of Db2 objects, use a Db2 Admin Tool version scope, a list of Db2 Admin Tool quick scopes, or both. A quick scope can include an SQL SELECT statement to identify the objects.

To specify an existing scope, use the SOURCE_VERSION_SCOPE_OWNER and SOURCE_VERSION_SCOPE_NAME parameters. To specify a data set that contains a list of Db2 Admin Tool quick scopes, use the compare source input file (SRCIN DD) or the SOURCE_DSN parameter.

Default:

DDL

Values:

Specify a 1- to 128-character comment, or leave this field blank.

Default:

blank

Values:

Specify a valid 1- to 128-character version name.

Default:

AUTO:OC.&CURTS..SRCVF

Values:

Specify a valid 1- to 128-character version owner.

Default:

&CURSQLID.

Values:

A valid version scope name; 1 to 128 characters, blank

A valid version scope name.

Specify a valid 1- to 128-character version scope name. If SOURCE_TYPE = 'USER', the version scope that is specified by SOURCE_VERSION_SCOPE_OWNER and SOURCE_VERSION_SCOPE_NAME is used for the Db2 object list for the compare source.

blank

If SOURCE_TYPE = 'USER', a list of Db2 Admin Tool quick scopes must be specified in a pre-allocated SRCIN DD file or in the data set that is specified by the SOURCE_DSN parameter.

Default:

blank

Values:

Specify a valid 1- to 128-character version scope owner.

Default:

&CURSQLID.

Values:

FILE

If the SRCVF file is not pre-allocated, it is allocated by using the attributes from ADMIN_DATASET_TYPE = 'SRCVF'.

DB2

If the SRCVF file is not pre-allocated, it is allocated by using the attributes from ADMIN_DATASET_TYPE = 'SRCVF' but as a temporary file. The file contents are stored in the Db2 Admin Tool change management repository using the owner and name values from the SOURCE_VERSION_OWNER and SOURCE_VERSION_NAME parameters.

TEMP

If the SRCVF file is not pre-allocated, it is allocated by using the attributes from ADMIN_DATASET_TYPE = 'SRCVF' but as a temporary file.

Default:

FILE

Values:

Specify a valid space unit for tape.

Default:

TAPE

Values:

Specify a valid space unit.

Default:

TRK

Values:

Specify a valid space unit name.

Default:

SYSALLDA

Values:

Specify a valid 1- to 4-character Db2 subsystem ID.

Default:

This parameter does not have a default value.

Values:

Y

Stop WSL processing with RC=28 when conversion errors occur.

N

Do not stop WSL processing when conversion errors occur.

Default:

N

Values:

YES, NO

Default:

NO

Values:

YES, NO

Default:

NO

Values:

YES, NO

Default:

NO

Regardless of the value that you set for this option, IBM Db2 Object Comparison Tool for z/OS replaces all relationships between a parent and a child if a foreign key is specified in the source. To delete a foreign key, both the parent and the child must be present in the source (without a foreign key). If DROP statements are part of the source DDL, objects are dropped regardless of the value that is specified for this parameter.

Regardless of the value that you set for this option, IBM Db2 Object Comparison Tool for z/OS drops all explicit LOB objects from the target if they are not specified on the source. However, if the base table that is associated with the LOB objects is kept because 'Suppress DROP of objects' is set to 'YES', then all of the LOB objects are kept.

Values:

a valid symbol variable name

Specify a valid symbol variable name or leave this parameter blank. A valid symbol variable name begins with the ampersand (&) character and ends with the . character. The name can be 3-128 characters, the total of which includes the & and . characters. The name is converted to upper case.

Default:

blank

Values:

Specify a 1- to 128-character value or leave this field blank.

Default:

blank

Values:

R

Generate COPY utility statements for all tables that are affected by the (RE)LOAD utility.

A

Generate COPY utility statements for all altered table space, table, and index objects.

B

Generate COPY utility statements for objects that are affected by the RE(LOAD) utility and SQL ALTER statements.

N

No COPY utility statements are generated.

Default:

N

Values

The value originates from the multi-target change file, which cannot be modified by the user.

Default:

blank

Values:

1 to 128 characters

Default:

blank

Values:

A data set name.

Specify a 1- to 46-character data set name. If TARGET_TYPE = 'USER', specify the name of the data set that contains the list of Db2 Admin Tool quick scopes for the compare target; One to 46 characters

blank

If TARGET_TYPE = 'USER', either the TARGET_VERSION_SCOPE_OWNER and TARGET_VERSION_SCOPE_NAME parameters must be specified, or the TGTIN file must contain the list of Db2 Admin Tool quick scopes for the compare target.

Default:

blank

Values:

A valid exclude specification name

Specify a valid 1- to 128-character exclude specification name. The specified Exclude Specification is used for the target during the compare process. One to 128 characters

blank

Exclude objects is not used for the compare target.

Values:

Specify a valid 1- to 128-character exclude specification owner.

Default:

&CURSQLID.

Values:

Y

Generate the DDL.

D

Generate the DDL and extract foreign keys for tables that are dependent on the tables being extracted.

N

Do not generate DDL.

Default:

blank

Values:

A valid Ignore Fields name

Specify a valid 1- to 128-character ignore fields name.

blank

Ignore Fields name is not included in the statement.

Default:

blank

Values:

A valid Ignore Fields owner

Specify a valid 1- to 128-character target ignore owner.

blank

Ignore Fields owner is not included in the statement.

Default:

blank

Values:

Specify a location that is defined in SYSIBM.LOCATIONS or leave this field blank to specify the local Db2 subsystem.

Default:

blank

Values:

A valid mask name

Specify a valid 1- to 128-character target mask name.

blank

The mask name is not included in the statement.

Default:

blank

Values:

A valid mask owner

Specify a valid 1- to 128-character target mask owner.

blank

The mask owner is not included in the statement.

Default:

blank

Values:

AUTO

The target is a Db2 subsystem. The Db2 objects for the compare target are automatically selected by Db2 Admin Tool based on the content of the compare source.

If TARGET_TYPE=AUTO, you cannot specify TARGET_DSN, TARGET_VERSION_SCOPE_NAME, or a compare target input file (TGTIN DD).

USER

The target is a Db2 subsystem, and the list of object names is provided by the user. To specify the list of Db2 objects, use a Db2 Admin Tool version scope, a list of Db2 Admin Tool quick scopes, or both. A quick scope can include an SQL SELECT statement to identify the objects.

To specify an existing scope, use the TARGET_VERSION_SCOPE_OWNER and TARGET_VERSION_SCOPE_NAME parameters. To specify a data set that contains a list of Db2 Admin Tool quick scopes, use the compare target input file (TGTIN DD) or the TARGET_DSN parameter.

DDL

The target is DDL. To specify the data set that contains the DDL, use the compare target input file (TGTIN DD) or the TARGET_DSN parameter. If the TARGET_DSN parameter is not specified, the compare target input file (TGTIN DD) must be pre-allocated.

Attention: If the target DDL that is specified does not match the DDL in the Db2 database, problems might occur when running the resultant change. Therefore, consider using this option only when comparing DDL to DDL (TARGET_TYPE='DDL' and SOURCE_TYPE=’DDL’).

Default:

AUTO

Values:

Specify a 1- to 128-character comment or leave this field blank.

Default:

blank

Values:

Specify a valid 1- to 128-character version name.

Default:

AUTO:OC.&CURTS..TGTVF

Values:

Specify a valid 1- to 128-character version owner.

Default:

&CURSQLID.

Values:

A valid version scope name.

Specify a valid 1- to 128-character version scope name. If TARGET_TYPE = 'USER', the version scope that is specified by TARGET_VERSION_SCOPE_OWNER and TARGET_VERSION_SCOPE_NAME is used for the Db2 object list for the compare target.

blank

If TARGET_TYPE = 'USER', a list of Db2 Admin Tool quick scopes must be specified in a pre-allocated TGTIN DD file or in the data set specified by the TARGET_DSN parameter.

Default:

blank

Values:

Specify a valid 1- to 128-character version scope owner.

Default:

&CURSQLID.

Values:

FILE

If the TGTVF file is not pre-allocated, it is allocated by using the attributes from ADMIN_DATASET_TYPE = 'TGTVF'.

DB2

If the TGTVF file is not pre-allocated, it is allocated by using the attributes from ADMIN_DATASET_TYPE = 'TGTVF' but as a temporary file. The file contents are stored in the Db2 Admin Tool change management repository. The owner and name values are obtained from the TARGET_VERSION_OWNER and TARGET_VERSION_NAME parameters.

TEMP

If the TGTVF file is not pre-allocated, it is allocated by using the attributes from ADMIN_DATASET_TYPE = 'TGTVF', but as a temporary file.

Default:

FILE

Values:

One of the following valid formats to identify a Db2 function level:

• V13R1Mmmm
• V12R1Mmmm
• mmm

For more information about function level identifiers, see Function levels and related levels in Db2 13 (Db2 13 for z/OS).

You can specify any function level equal to or less than the current Db2 function level.

Default:

The current Db2 function level

Related information:

• Adopting new capabilities in Db2 13 continuous delivery (Db2 13 for z/OS)
• Support for Db2 continuous delivery

Values:

YES or Y

Unload all altered tables.

DES or D

Unload only those altered tables where the alters are destructive. Destructive alters are changes that might result in the loss of data, such as ALTER TABLE DROP COLUMN.

NO or N

Do not unload any altered tables.

Default:

YES

Values:

U

Use the UNLOAD utility.

P

Use the Db2 Parallel UNLOAD utility.

H

Use Db2 High Performance Unload when available. The HPU option is supported only if an HPU load library is specified.

Default:

U

Values:

Y

Specify DEFER YES on eligible indexes.

N

Do not specify DEFER YES.

Default:

Values:

YES or Y

Utilities are run by calling DSNUTILV.

NO or N

Utilities are invoked in the CM batch job.

Default:

YES

Values:

Y

If an ignore is also being imported, the ignore that is used for import change is the newly created ignore. Otherwise, the ignore that is used is identified by the IGNORE_OWNER and IGNORE_NAME parameters.

blank

Specifies that this parameter defaults to Y if an ignore and a change are imported.

Default:

blank

Values:

Y

If a mask is also being exported, the mask that is used for export change is the newly created mask. Otherwise, the mask that is used is identified by the COMPARE_MASK_OWNER and MASK_NAME parameters.

blank

Specifies that this parameter defaults to Y if a mask and a change are imported.

Default:

blank

Values:

Y

If a mask is also being imported, the mask that is used for import change is the newly created mask. (This newly created mask is identified by the NEW_MASK_OWNER and NEW_MASK_NAME parameters.) Otherwise, the mask that is used is identified by the MASK_OWNER and MASK_NAME parameters.

blank

Specifies that this parameter defaults to Y if a mask and a change are imported.

Default:

blank

Values:

Y

Store the run job input data in a permanent data set that is referenced in the run job.

N

Store the run job input data in an in-stream data set in the run job.

Default:

N

Values:

Y

The user-customized utility options are used.

N

The Db2 Admin Tool and Db2 default utility options are used.

Default:

N

Values:

Specify a 1- to 8-character Db2 template name.

Default:

CLNCOPY1

Values:

a non-blank value

a non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES is set to Y, and the template exists in the ADBTEMPL file.

Default:

S

Values:

A Db2 template name; 1 to 8 characters

Default:

CLNCOPY2

Values:

a non-blank value

a non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y and the template exists in the ADBTEMPL file.

Default:

S

Values:

A Db2 template name; 1 to 8 characters

Default:

CLNDISC

Values:

a non-blank value

a non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y and the template exists in the ADBTEMPL file.

Default:

S

Values:

A Db2 template name; 1 to 8 characters

Default:

CLNERR

Values:

a non-blank value

a non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y and the template exists in the ADBTEMPL file.

Default:

S

Values:

A Db2 template name; 1 to 8 characters

Default:

CLNFCOPY

Values:

a non-blank value

Default:

S

Values:

A Db2 template name; 1 to 8 characters

Default:

CLNLOBC

The data set name cannot exceed 35 bytes and must be in PDS format. Do not specify a member name

Values:

a non-blank value

Default:

S

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES is set to Y, and the template exists in the ADBTEMPL file.

Values:

A Db2 template name.

Specify a 1- to 8-character Db2 template name.

Default:

CLNMAP

Values:

A non-blank value.

Specify a non-blank value.

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES is set to Y, and the template exists in the ADBTEMPL file.

Default:

S

Values:

A Db2 template name; 1 to 8 characters

Default:

CPUNCH

Values:

a non-blank value

a non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y and the template exists in the ADBTEMPL file.

Default:

S

Values:

A Db2 template name; 1 to 8 characters

Default:

CLNRCVR1

Values:

a non-blank value

a non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set toY and the template exists in the ADBTEMPL file.

Default:

S

Values:

A Db2 template name; 1 to 8 characters

Default:

CLNRCVR2

Values:

a non-blank value

a non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y and the template exists in the ADBTEMPL file.

Default:

S

Values:

A Db2 template name; 1 to 8 characters

Default:

CUNL

Values:

a non-blank value

a non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y and the template exists in the ADBTEMPL file.

Default:

S

Values:

A Db2 template name; 1 to 8 characters

Default:

CUPUNCH

Values:

a non-blank value

a non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y and the template exists in the ADBTEMPL file.

Default:

S

Values:

A Db2 template name; 1 to 8 characters

Default:

CUPUNCHC

Values:

a non-blank value

a non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y and the template exists in the ADBTEMPL file.

Default:

S

Values:

A Db2 template name; 1 to 8 characters

Default:

CUUNL

Values:

a non-blank value

a non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y and the template exists in the ADBTEMPL file.

Default:

S

Values:

A Db2 template name; 1 to 8 characters

Default:

CUUNLC

Values:

a non-blank value

a non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y and the template exists in the ADBTEMPL file.

Default:

S

Values:

A Db2 template name; 1 to 8 characters

Default:

CLNWORK1

Values:

a non-blank value

a non-blank value

A non-blank value indicates that the template name is used if theGENERATE_TEMPLATES parameter is set to Y and the template exists in the ADBTEMPL file.

Default:

S

Values:

A Db2 template name; 1 to 8 characters

Default:

CLNWORK2

Values:

a non-blank value

a non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y and the template exists in the ADBTEMPL file.

Default:

S

Values

A Db2 template name; 1 to 8 characters

Default:

CLNXMLC

The data set name cannot exceed 35 bytes and must be in PDS format. Do not specify a member name.

Values:

a non-blank value

Default:

S

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES is set to Y, and the template exists in the ADBTEMPL file.

Values:

A Db2 template name

The Db2 template name can be 1 to 8 character in length.

Default:

COPY1

Values:

A non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y and the template exists in the ADBTEMPL file.

Default:

S

Values:

A Db2 template name

The Db2 template name can be 1 to 8 character in length.

Default:

COPY2

Values:

A non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y and the template exists in the ADBTEMPL file.

Default:

S

Values:

A Db2 template name

The Db2 template name can be 1 to 8 character in length.

Default:

DISC

Values:

A non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y, and the template exists in the ADBTEMPL file.

Default:

S

Values:

TAPE

A removal media device, such as 3490 tape, or a 3490E tape drive.

DASD

A magnetic disk storage device, such as a direct access storage device (DASD).

Default:

DASD

Values:

A Db2 template name

The Db2 template name can be 1 to 8 character in length.

Default:

ERR

Values:

A non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y and the template exists in the ADBTEMPL file.

Default:

S

Values:

A Db2 template name

The Db2 template name can be 1 to 8 character in length.

Default:

FCOPY

Values:

A non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y and the template exists in the ADBTEMPL file.

Default:

S

Values:

A Db2 template name

The Db2 template name can be 1 to 8 character in length.

Default:

LOBC

Values:

A non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y and the template exists in the ADBTEMPL file.

Default:

S

Values:

TAPE

A removal media device, such as 3490 tape, or a 3490E tape drive.

DASD

A magnetic disk storage device, such as a direct access storage device (DASD).

Default:

DASD

Values:

A Db2 template name

The Db2 template name can be 1 to 8 character in length.

Default:

MAP

Values:

A non-blank value.

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y, and the template exists in the ADBTEMPL file.

Default:

S

Values:

A Db2 template name

The Db2 template name can be 1 to 8 character in length.

Default:

PUNCH

Values:

A non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y and the template exists in the ADBTEMPL file.

Default:

S

Values:

A Db2 template name

The Db2 template name can be 1 to 8 character in length.

Default:

RCVR1

Values:

A non-blank value.

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y, and the template exists in the ADBTEMPL file.

Default:

S

Values:

A Db2 template name

The Db2 template name can be 1 to 8 character in length.

Default:

RCVR2

Values:

A non-blank value.

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y, and the template exists in the ADBTEMPL file.

Default:

S

Values:

A Db2 template name

The Db2 template name can be 1 to 8 character in length.

Default:

UNL

Values:

A non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y and the template exists in the ADBTEMPL file.

Default:

S

Values:

A Db2 template name

The Db2 template name can be 1 to 8 character in length.

Default:

UPUNCH

Values:

A non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y and the template exists in the ADBTEMPL file.

Default:

S

Values:

A Db2 template name

The Db2 template name can be 1 to 8 character in length.

Default:

UPUNCHC

Values:

A non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y and the template exists in the ADBTEMPL file.

Default:

S

Values:

TAPE

A removal media device, such as 3490 tape, or a 3490E tape drive.

DASD

A magnetic disk storage device, such as a direct access storage device (DASD).

blank

The DEVTYPE option is not added. The Db2 default for this utility option is used.

Default:

DASD

Values:

A Db2 template name

The Db2 template name can be 1 to 8 character in length.

Default:

UUNL

Values:

A non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y and the template exists in the ADBTEMPL file.

Default:

S

Values:

A Db2 template name

The Db2 template name can be 1 to 8 character in length.

Default:

UUNLC

Values:

A non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y and the template exists in the ADBTEMPL file.

Default:

S

Values:

TAPE

A removal media device, such as 3490 tape, or a 3490E tape drive.

DASD

A magnetic disk storage device, such as a direct access storage device (DASD).

Default:

DASD

Values:

A Db2 template name

The Db2 template name can be 1 to 8 character in length.

Default:

WORK1

Values:

A non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y and the template exists in the ADBTEMPL file.

Default:

S

Values:

TAPE

A removal media device, such as 3490 tape, or a 3490E tape drive.

DASD

A magnetic disk storage device, such as a direct access storage device (DASD).

Default:

DASD

Values:

A Db2 template name

The Db2 template name can be 1 to 8 character in length.

Default:

WORK2

Values:

A non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y and the template exists in the ADBTEMPL file.

Default:

S

Values:

A Db2 template name

The Db2 template name can be 1 to 8 character in length.

Default:

XMLC

Values:

A non-blank value

A non-blank value indicates that the template name is used if the GENERATE_TEMPLATES parameter is set to Y and the template exists in the ADBTEMPL file.

Default:

S

This parameter validates the input DDL directly against the catalog for issuing the Db2 PREPARE statement, checking whether objects exist, and so on. Prerequisite changes are not considered, so an informational message is issued when Y is specified. For example, if the table that is in the DDL does not exist in the catalog, the validation process ends with an error. If a prerequisite change is in the process of creating the table, it is not considered.

The VALIDATE_DDL parameter is an import optional parameter that is limited to validating the DDL. It is not applicable to validating the changes file. For example, if you run a compare and import the changes file, the VALIDATE_DDL parameter is not used, and a warning message that the value of the parameter is forced to N is issued.

Values:

Y

Validates the DDL and displays the report in the job output.

N

The DDL is not validated.

Default:

N

Values:

Valid data set names. 1- 8 characters.

Default:

blank

Values:

Y

Validate the WSL and display the report in the job output.

N

Do not validate the WSL.

Default:

N

Values:

A valid data set member name

The data set member name can be 1 to 8 characters or blank.

blank

No validation will be done.

Default:

No default value.

Values:

A valid PDS member name. 1 - 8 characters.

Default:

blank

Values:

Valid PDS member names. 1 - 8 characters.

Default:

If a work statement list (WSL) is being generated (ACTION_GENERATE_WSL = 'Y'), the default is the change tag value that is used by this WSL, as specified in WORKLIST_NAME.

If a change is being analyzed or run, the default is the change tag value that is used by the change. This value depends on the value of CHGTAG_TYPE

Otherwise, the default is blank.