ALTER and Change Manager installation options

The installation process creates the installation options module for the ALTER and BMC AMI Change Manager for Db2 products. This module resides in $$xnnDOPT and also in the HLQ.UBMCCNTL member (where HLQ is the high-level qualifier) that has the same name as the installation options module. The module's default name is ACMDOPD1.

Related topic

Command-and-syntax-reference


Important

The installation options are also called default options, or DOPTs.

Example of installation options module

The ALTER and Change Manager installation options are also known as default options, or DOPTs.

Click here to view an example of the installation options module for Change Manager...
   File  Edit  Edit_Settings  Menu  Utilities  Compilers  Test  Help            
 -------------------------------------------------------------------------------
 EDIT       SYS22081.T050647.RA000.MVSSXS1.DOPED.H02        Columns 00001 00072
 Command ===>                                                  Scroll ===> PAGE
 ****** ***************************** Top of Data ******************************
 ==MSG> -Warning- The UNDO command is not available until you change            
 ==MSG>           your edit profile using the command RECOVERY ON.              
 000001 *DOPTS NAME          : DMD1QEND                                         
 000002 *DATE DOPTS ASSEMBLED: 20220301                                         
 000003 ACMDOPTS CSECT ,                                                        
 000004 ACMDOPTS RMODE 24                                                       
 000005 ACMDOPTS AMODE 24                                                       
 000006 ACMDOPTS $ALUDOPT PRODUCT='CHANGE MANAGER',                            X
 000007                DATE=&SYSDATC,                                          X
 000008                PC=ACM,                                                 X
 000009                EURO=(N,R),                                             X
 000010                SYSTYPE=S,                                              X
 000011                LOG=N,                                                  X
 000012                DBRMLIB=N,                                              X
 000013                WDSN=,                                                  X
 000014                CATAUDIT=(N,R),                                         X
 000015                CATRECOV=(N,R),                                         X
 000016                SEQI=050,                                               X
 000017                SYNCPNT=10,                                             X
 000018                ALLOC=N,                                                X
 000019                STORCLAS=N,                                             X
 000020                DATACLAS=N,                                             X
 000021                MGMTCLAS=N,                                             X
 000022                AUTHSW=(N,R),                                           X
 000023                DASDMAN=(Y,R),                                          X
 000024                CCSID=(E,R),                                            X
 000025                VVALPROP=(N,R),                                         X
 000026                BPOOLTS=BP0,                                            X
 000027                BPOOLIX=BP0,                                            X
 000028                DISCARDS=(0001,R),                                      X
 000029                BMCCOPY=(N,R),                                          X
 000030                BMCCHECK=(N,R),                                         X
 000031                BMCLOAD=(N,R),                                          X
 000032                UTILCOPY=(N,R),                                         X
 000033                BMCUNLD=(I,R),                                          X
 000034                REORG=(I,R),                                            X
 000035                REBLD=(I,R),                                            X
 000036                UNLDCOLL=N,                                             X
 000037                PARTCPY=N,                                              X
 000038                PARALLEL=N,                                             X
 000039                ZPARM=DSNZPARM,                                         X
 000040                MAXSYSUT=20,                                            X
 000041                BMCFASTL=Y,                                             X
 000042                DYNCOPY=Y,                                              X
 000043                DYNUNLD=Y,                                              X
 000044                STATS=(S,R),                                            X
 000045                UPDSTATS=(C,R),                                         X
 000046                TABLEALL=(Y,R),                                         X
 000047                UNLDEMPT=(Y,R),                                         X
 000048                STOPCOMM=(N,R),                                         X
 000049                TABLEACC=(Y,R),                                         X
 000050                KEYCARD=N,                                              X
 000051                GENOBID=N,                                              X
 000052                COPYDD01=R,                                             X
 000053                COPYDD02=N,                                             X
 000054                HSMVOL=,                                                X
 000055                ENVP=ACMD1QDE,                                          X
 000056                FEP=ACMD1QDF,                                           X
 000057                SPP=ACMD1QDS,                                           X
 000058                ANP=ACMD1QDA,                                           X
 000059                IMP=ACMD1QDI,                                           X
 000060                CMP=ACMD1QDC,                                           X
 000061                BASE=ACMD1QDB,                                          X
 000062                RPTPL=ACMD1QDR,                                         X
 000063                EPP=ACMD1QXM,                                           X
 000064                EAP=ACMD1QXA,                                           X
 000065                EIP=TISINSTL,                                           X
 000066                DEFERUIX='N',                                           X
 000067                REORGALT=(N,R),                                         X
 000068                POFDS=('AUS.DOPSEC.CNTL(JXD1QEND)',R),                  X
 000069                STATHIST=N,                                             X
 000070                TBLANKS=2,                                              X
 000071                REORGALL=(Y,R),                                         X
 000072                REORGREF=(Y,R),                                         X
 000073                REGENNSP=N,                                             X
 000074                DYNREORG=Y,                                             X
 000075                CLONDATA=Y,                                             X
 000076                BLRTERMC='#',                                           X
 000077                UCPKPALL=N,                                             X
 000078                CMPSPTXT=Y,                                             X
 000079                STOPLIST=,                                              X
 000080                RPLUSYNC=R,                                             X
 000081                LKVALID=Y,                                              X
 000082                STOPICP=N,                                              X
 000083                BINDONIX=N,                                             X
 000084                ROLEOWN=(N,R),                                          X
 000085                VRM=,                                                   X
 000086                REORGONL=(Y,R),                                         X
 000087                PLANMGMT=N,                                             X
 000088                SPANNED=(Y,R),                                          X
 000089                USENGTR=(N,R),                                          X
 000090                USENGTUL=(N,R),                                         X
 000091                REGENATR=(Y,R),                                         X
 000092                BMCRSWITCH=N,                                           X
 000093                REORGPDD=N,                                             X
 000094                APPLCOVR=N,                                             X
 000095                IDAAIGNR=N,                                             X
 000096                MOVETB=N,                                               X
 000097                UNQUALIFY=N,                                            X
 000098                CMPLIMT1=0000,                                          X
 000099                CMPLIMT2=0000,                                          X
 000100                CMPSCWBF=FFFFFFFF,                                      X
 000101                CMPSCWBS=FFFFFFFF,                                      X
 000102                RACROUTE=Y,                                             X
 000103                LATESTPKG=N,                                            x
 000104                DEFERCDC=N,      x
 000105                LOSTERROR=N,                                            x                           
 000106                RENAMECOL=N
 000107                END                                                      
 ****** **************************** Bottom of Data ****************************

Important

,R in the variable syntax indicates that the value specified will refresh the existing value of the variable in the user’s ISPF profile data set, if the time stamp of the installation options module is later than the time stamp in the user’s ISPF profile member.


Description of installation options

This section describes each option in the installation options module. In some cases, the default value for the option is listed with the option name.

  

ALLOC=N

This option indicates the allocation units to use for data sets that are managed by the IBM Storage Management Subsystem (SMS). If the AMS is set to Y, this option determines how the product allocates space for VCAT-defined Db2 objects that SMS manages.

The parameters are defined as follows:

Parameter

Description

C

Cylinders

K

Kilobytes

M

Megabytes

N

SMS not in use (default)

T

Tracks

ANP=ACMvryA

This option defines the Analysis plan name.

APPLCOVR=N

This option controls whether the Analysis includes commands in a worklist to override the application compatibility level (APPCOMPAT).

This option is applicable in IBM Db2 V12 FL503 and later.

The parameters are defined as follows:

Parameter

Description

N

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

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

N is the default value.

Y

Inserts the appropriate SET CURRENT APPLICATION COMPATIBILITY commands in the worklist upon detecting the following commands:

  • CREATE SYNONYM command
  • CREATE command related to a table space that is not a universal table space (UTS)
Example

-SETC 005850 SET CURRENT APPLICATION COMPATIBILITY = 'V12R1M503'
-SQL 000000 CREATE TABLESPACE TLOTCP78 IN R1NGTULX
...
-SETC 000000 SET CURRENT APPLICATION COMPATIBILITY = 'V12R1M504'

AUTHSW=N

This option controls the method of authorization-ID switching that Analysis uses:

  • If AUTHSW=N, the product generates the -SETS command in the worklist to change the authorization IDs with SET CURRENT SQLID statements. For additional security, you cannot edit -AUTH commands into the worklist. This option uses Db2 secondary authorization IDs.

    Important

    We recommend that you specify AUTHSW=N.

  • If AUTHSW=Y, the product generates the -AUTH command in the worklist to change the authorization IDs for subsequent SQL statements and reBIND commands. You can also manually add -SETS commands to the worklist for setting the authorization IDs.

    The -AUTH command that is generated in the worklist cannot switch to 8-byte authorization IDs. Because the -AUTH command simulates the user ID environment inherent to MVS, and MVS itself is limited to seven characters for user IDs, the authorization ID must be seven characters or less.

    If your Db2 environment has committed to the use of SET CURRENT SQLID, the best way to ensure that 8-byte IDs are correctly used is to set the installation option for AUTHSW to N. When AUTHSW=N, the product generates -SETS commands in the worklist instead of -AUTH commands. Using -SETS commands exploits the built-in Db2 switching mechanism and the commands are not limited to 7-byte IDs.

    If using -SETS commands is not suitable for your environment, you can switch -AUTH commands to 8-byte IDs through the Execution security exit. This exit has many possible uses, including the ability to examine and optionally change the authorization ID that the -AUTH command uses. Through this exit you can cause an 8-byte ID to switch to a corresponding 7-byte (or shorter) ID, which causes a switch in the Db2 DSN3@TH exit that is already installed. In the HLQ.DBSAMP data set, member ALUEUSX1 provides an example of the Execution security exit.

    For more information about the Execution security exit, see Using.

    Important

    Use AUTHSW=Y only if your site does not use Db2 secondary authorization IDs.

  • If AUTHSW=B, the product generates both -AUTH and -SETS commands in the worklist to change the authorization IDs. The product generates -AUTH commands to set the original CREATEDBY values and to DROP objects. The CREATEDBY field in the Db2 catalog remains unchanged after updates. The product generates -SETS commands to set new OWNER values for all objects. In addition, when AUTHSW=B, the product changes the authorization IDs before CREATE TABLE and CREATE INDEX statements.

    Warning

    Setting AUTHSW=B is not recommended because of potential security exposure and the additional complexity if you try to restart the worklist. The security exposure exists because the Db2 catalog does not accurately reflect the primary authorization ID of the creator of the objects. If you must set AUTHSW=B, use the sample security exit (ALUEUSX1 in the HLQ.DBSAMP data set) to avoid security exposure.

  • If AUTHSW=X, the product disables authorization switching for a worklist. The product does not generate -AUTH, -SETS, and -GLID commands in the worklist.

    Information

    Use AUTHSW=X only under the following conditions:

    • You are not allowed to execute any -AUTH or -SETS commands in your environment
    • You previously edited your worklists and removed all of the -AUTH, -SETS, and -GLID commands
  • If AUTHSW=G, the products disable authorization switching for a worklist. The products do not generate -AUTH and -SETS commands; they do, however, generate -GLID commands in the worklist.
  • If AUTHSW=Z, the product generates the -SETS command in the worklist to change the authorization IDs with SET CURRENT SQLID statements. For additional security, you cannot edit -AUTH commands into the worklist. This option uses Db2 secondary authorization IDs except when a table has an XML column or LOB column and STDRULES. If the table conditions are met, the base table space owner is used for the authorization ID prior to the creation of the table.

For a list of the authorizations that are used for authorization switching, as well as information about -AUTH and -SETS commands, see Command-and-syntax-reference.

BASE=ACMvryB

(Change Manager only) This option defines the name of the Baseline plan.

BINDONIX=N

After you add a new or alter an index, this option indicates whether to automatically rebind all packages that are dependent on the table containing the index.

BLRTERMC=#

(Change Manager only) This option specifies the character that the baseline report uses to separate SQL statements. The default value is a pound sign (#). The value can be any character except a blank, comma (,), double quotation mark ('), single quotation mark ('), left parenthesis [(], right parenthesis [)], or underscore (_).

BMCCHECK=N

This option indicates whether to use the CHECK PLUS utility in place of the IBM CHECK DATA utility for checking referential constraint violations in Db2 table spaces (Y or N).

BMCCOPY=N

This option indicates whether to use the BMC AMI Copy utility in place of the IBM COPY utility. The parameters are defined as follows:


Parameter

Description

N

Uses the IBM COPY utility to copy objects.

When BMCCOPY=N, the COPYDD01, COPYDD02, RECVDD01, and RECVDD02 installation options must equal R.

Y

Uses the BMC AMI Copy utility.

The BMC AMI Copy utility must be installed. When Change Manager is used as a component of the BMC Database Administration for DB2, Next Generation Technology Database Administration for DB2, or BMC AMI Database Administration for Db2 solution, the default is Y.

X

Does not include a copy utility command in a worklist.

F

Does not include a copy utility command in a worklist and start objects in copy pending status with ACCESS (FORCE).

BMCFASTL=N

This option indicates whether to use the FORMAT BMCLOAD option (UNLOAD PLUS utility) and FORMAT BMCUNLOAD (LOADPLUS utility) to unload data from one table and load it into another table that has a similar structure (Y or N). If you use Change Manager as a component of the Database Administration or BMC AMI Database Administration solution, the default is Y.

BMCLOAD=N

This option indicates whether to use the LOADPLUS utility for loads instead of the IBM LOAD utility (Y or N). If you use Change Manager as a component of the Database Administration or BMC AMI Database Administration solution, the default is Y.

BMCRSWITCH=N

This option indicates whether to automatically use the IBM REORG utility instead of the BMC REORG PLUS utility for reorganizing table spaces when the Analysis component determines that REORG PLUS cannot be used (Y or N).

BMCUNLD=N

This option indicates whether to use the UNLOAD PLUS utility to unload data. The parameters are defined as follows:


Parameter

Description

N

Uses the BASIC UNLOAD utility to unload data

Y

Uses the UNLOAD PLUS utility to unload data.

When Change Manager is used as a component of the Database Administration or BMC AMI Database Administration solution, the default is Y.

I

Uses the IBM UNLOAD utility to unload data.

BPOOLIX=BP0

This option indicates the buffer pool for user indexes. Valid values include:

  • BP0 through BP49
  • BP8K0 through BP8K9
  • BP16K0 through BP16K9
  • BP32K, BP32K1 through BP32K9

Important

In Change Manager, the Compare component uses the value of BPOOLIX on the local Db2 subsystem when a remote Db2 catalog or a baseline is used in a comparison.

BPOOLTS=BP0

This option indicates the buffer pool for user data. Valid values include:

  • BP0 through BP49
  • BP8K0 through BP8K9
  • BP16K0 through BP16K9
  • BP32K, BP32K1 through BP32K9

The value should match the value specified for the Db2 initialization parameter module, DSNZPARM, on the Db2 subsystem on which the option is used.

Important

In Change Manager, the Compare component uses the value of BPOOLTS on the local Db2 subsystem when a remote Db2 catalog or a baseline is used in a comparison.

CATAUDIT=N

This option specifies the data definition language (DDL) audit logging indicator. If you have BMC AMI Catalog Manager for Db2 installed, an entry of Y causes Execution to log executed DDL statements in the Catalog Manager DDL Audit Log (Y or N). For information about the auditing log, see Using.

CATRECOV=N

This option specifies the Drop Recovery indicator. This option is useful only if you have Catalog Manager installed. Type Y if you want the Execution component to invoke Catalog Manager to log recovery information in the Catalog Manager drop-recovery tables for the objects that are dropped when the work ID is executed. For information about drop recovery, see Using.

CCSID=E

This option provides the default encoding scheme for databases that are created using the product.


Parameter

Description

A

ASCII

E

EBCDIC

U

Unicode

CLONDATA=Y

This option indicates whether to include worklist commands to unload, load, and copy data contained in clone tables (Y or N).

CMP=ACMvryC

(Change Manager only) This option defines the Compare plan name.

CMPLIMIT1

Reserved for future use.

CMPLIMIT2

Reserved for future use.

CMPSCWBF

Reserved for future use.

CMPSCWBS

Reserved for future use.

CMPSPTXT=N

This option indicates how the Compare component should compare the text of a native SQL stored procedure.


Parameter

Description

N

Ignores extra blanks, blank lines, and character case (uppercase and lowercase) when comparing the text.

Y

Compares each character in the text verbatim.

COPYDD01=R

See COPYDD02

COPYDD02=N

These options define image copies for the BMC and IBM copy utilities. The parameters are defined as follows:


Parameter

Description

N

Does not create an image copy.

C

Creates an image copy of the primary data set at the local site, but does not register the image copy.

The BMC AMI Copy, REORG PLUS, or LOADPLUS utility is used to create the copy.

R

Creates an image copy of the primary data set at the local site using one of the following utilities:

  • BMC AMI Copy
  • REORG PLUS
  • LOADPLUS
  • IBM COPY

The utility will register the copy.

If the IBM COPY utility is used, COPYDD01 and COPYDD02 must equal R.

DASDMAN=Y

This option indicates whether DASD MANAGER PLUS is installed (Y or N). The product selects Db2 catalog statistics for space estimation. When DASDMAN=Y, any statistics from the BMCSTATS tables are merged.

DATACLAS=N

This option indicates whether support for the DATACLAS parameter is required for VCAT-defined Db2 objects (Y or N).

DATE=&SYSDATC

This option indicates a parameter that is used only if you have ASMA90 as your assembler.

DBRMLIB=N

This option includes the LIBRARY parameter on the BIND statement for plans and packages (Y or N).

Important

A disadvantage to adding the LIBRARY parameter to the BIND PLAN command is that the order of the libraries on the BIND could be incorrect. If some DBRMs are present in multiple libraries, the product cannot guarantee that the concatenation will result in every DBRM coming from the correct library.

This option determines how Analysis handles the DATA CAPTURE CHANGES option when creating tables. 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.

Value

Description

N

The following table lists the possible actions:

UTILS_BLOCK_FOR_CDC

Action

N

The analysis includes the DATA CAPTURE CHANGES clause in the CREATE TABLE statement

Y

Analysis issues an error and does not generate a worklist

Y

The following table lists the possible actions:

UTILS_BLOCK_FOR_CDC

Action

N

Analysis includes the DATA CAPTURE CHANGES clause in the CREATE TABLE statement

Y

  • Omits the DATA CAPTURE CHANGES clause in the CREATE TABLE statement if specified
  • Includes an ALTER TABLE statement with the DATA CAPTURE CHANGES clause after a utility loads or recovers the data into the table

DEFERUIX=N

This option enables the product to create unique indexes with the DEFER YES parameter (Y or N).

DISCARDS=nnnn

This option is used by the product to specify the number of discard records to allow. The parameter nnnn specifies the number of discards in a range from 0 to 9999. DISCARDS=0 means that no maximum number of discards exists.

With DISCARDS=1, the product generates one discard DD, //SYSDS001, for the entire run, and DISCARDS 1 is generated as a LOAD parameter. JCL that is generated minimally sizes data sets for SYSDS001 and SYSER001 DDs. If any records must be discarded, this action causes the load utility to terminate with a return code of 8.

If the DISCARDS option is set to any value other than 1, a different discard DD (//SYSDnnnn) is generated for each load, and DISCARDS n is generated as a LOAD parameter for each LOAD command (where n is the maximum number of discard records). 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.

DYNCOPY=N

This option indicates whether the BMC AMI Copy, BMC AMI Recover, and IBM COPY utilities dynamically allocate copy (SYSCOPY) data sets (Y or N). If you use Change Manager as a component of the Database Administration, NGT Database Administration, or BMC AMI Database Administration solution, the default is Y.

DYNREORG=Y

This option indicates whether the REORG PLUS and IBM REORG utilities dynamically allocate archive (ARCHDDN), copy (COPYDDN, RECOVERYDDN), discard (DISCARDDN), punch (PUNCHDDN), sysrec (UNLDDN), and sortout or sysut (WORKDDN) data sets (Y or N).

DYNUNLD=N

This option indicates whether the UNLOAD PLUS and LOADPLUS utilities dynamically allocate unload (SYSREC) and discard (SYSDISC) data sets (Y or N). If you use the Change Manager as a component of the Database Administration or the BMC BMC AMI Database Administration solution, the default is Y.

EAP=AEXvrHA

This option defines the Execution Authorization plan name, which determines if a user is authorized to run Execution.

EIP=BMIINSTL

This option defines the Installation plan name.

ENVP=ACMvryE

This option defines the Environment plan name, which is used to display the product environment information.

EPP=AEXvrHM

This option defines the Execution primary plan name.

EURO=N

This option instructs the product to expect numbers in the European format (comma used for the decimal point) and to create output in European decimal format (Y or N).

This option is particularly important when the product parses index LIMITKEY values that are separated by commas. If the EURO keyword is present, the product requires delimiting commas to be followed by blanks.

Important

The Import, Specification, Baseline (Change Manager), and Compare (Change Manager) components use the value for EURO from the installation options module, but do not support the use of the EURO keyword in the ALUIN input data stream.

EXCEPT=nnnn

This option is used by the product to specify the maximum number of rows that contain referential integrity or check constraint errors (exceptions). The parameter nnnn specifies the number of exceptions in a range from 0 to 9999. EXCEPT=0 means that no maximum exceptions exist.

Important

This option is not generated in the installation options module. To change the default value of the option, you must manually add the option and value to the module.

FEP=ACMvryF

This option defines the Front End plan name.

GENOBID=N

This option specifies whether to generate the OBID parameter in a CREATE TABLE statement (Y or N).

HSMVOL=vol

This option specifies the volume ID that indicates an archived data set if you are using a storage management system, such as the IBM Hierarchical Storage Manager (DFSMShsm). If this volume ID is encountered, the product uses a template of default values for data set allocation.

IMP=ACMvryI

This option defines the Import plan name.

KEYCARD=N

This option indicates whether to take cardinality statistics for the key columns of an index when the IBM RUNSTATS utility is used to take index statistics (Y or N).

This option specifies for which package versions the Analysis component generates rebinds. The parameters are defined as follows:

Parameter

Description

N

Analysis generates rebinds for all versions of every affected package

Y

Limits the rebinds generated by Analysis to the latest version of a package

LKVALID=Y

When you alter the limit key values for an index- or table-controlled partitioned object, the products must alter each partition in a specific sequence. Each altered limit key cannot exceed the value of the existing limit key of the next partition. The products sort the limit key values so that ALTER TABLE ALTER PARTITION statements can be executed in the correct sequence. The products also validate the limit key values to ensure that partition ranges do not overlap and that the values are correct for the data types and lengths of the partitioning columns. This option indicates whether to sort and validate the limit key values.

The parameters are defined as follows:


Parameter

Description

Y

Sorts and validates the limit key values

N

Does not sort and validate the limit key values

I

Ignores any errors that the products generate when they sort and validate the limit key values

LOG=N

This option specifies that records be logged during loads that use the IBM LOAD utility (Y or N).

This option specifies whether to escalate implicitly dropped foreign key object messages from warnings to errors.

The parameters are defined as follows:

Parameter

Description

N

(Default) Implicitly dropped foreign key object messages are processed as warnings

Y

Implicitly dropped foreign key object messages are processed as errors

No worklist is generated.

MAXSYSUT=20

This option specifies the maximum number of SYSUT temporary work data sets that the LOADPLUS or REORG PLUS utilities can use to build nonclustering indexes for a table. The range of valid values is 1 to 9999.

MGMTCLAS=N

This option indicates whether support for the MGMTCLAS parameter is required for VCAT-defined Db2 objects (Y or N).

MOVETB=N


This option specifies whether Analysis uses the ALTER TABLESPACE MOVE TABLE statement or the unload, drop, rebuild, and load process. The parameters are defined as follows:

Parameter

Description

N

Unloads, drops, rebuilds, and loads tables

Y

Uses the ALTER TABLESPACE MOVE TABLE statement, if possible

PARALLEL=Y

When Change Manager is used as a component of the Database Administration or BMC AMI Database Administration solution, this option instructs Analysis to create commands that Execution can use to execute a worklist in parallel.

PARTCPY=N

This option indicates whether to use the LOADPLUS , BMC AMI Copy, BMC AMI Recover, or REORG PLUS utility to create a partition-level image copy of a partitioned table space or index (Y or N).

PC=ACM

This option defines the product code to the product components.

PLANMGMT=N

If the PLANMGMT column in the SYSIBM.SYSPACKAGES table for a package is blank, the product uses this installation option to generate the PLANMGMT option in the REBIND statement for the package. Otherwise, the SYSIBM.SYSPACKAGES PLANMGMT column is used to generate the PLANMGMT option in the REBIND statement for the package. The products do not use the DSNZPARM PLANMGMT subsystem parameter. The default value is N.

The parameters are defined as follows:


Parameter

Description

REBIND statement option

N

No default

PLANMGMT(OFF)

B

Basic

PLANMGMT(BASIC)

E

Extended

PLANMGMT(EXTENDED)

POFDS=('&&HLQ..CNTL(&POFNAME)'

This option specifies the name of the initial JCL Generation Product Options File (POF).

PRODUCT='PRODUCT NAME'

This option defines the product name. (for example, PRODUCT='Change Manager'.

REBLD=I

This option indicates whether to use the rebuild utility from IBM or BMC or no rebuild utility. If REBLD=N, eligible indexes are not created with DEFER YES. If a nonunique index is dropped or created in a worklist, and its parent table is not dropped or created in the worklist, the index is created with DEFER YES if REBLD=I or REBLD=B.

The parameters are defined as follows:


Parameter

Description

I

Uses the IBM REBUILD INDEX utility to rebuild indexes.

B

Uses the BMC AMI Recover utility. The BMC AMI Recover utility must be installed.

N

Does not generate a rebuild utility command in the worklist.

RECVDD01=N

See RECVDD02

RECVDD02=N

These options define image copies for the BMC and IBM copy utilities. The parameters are defined as follows:


Parameter

Description

N

Does not create an image copy.

C

Creates an image copy of the backup data set at the remote site, but does not register the image copy.

The BMC AMI Copy, REORG PLUS, or LOADPLUS utility is used to create the copy.

R

Creates an image copy of the backup data set at the remote site using one of the following utilities:

  • BMC AMI Copy
  • REORG PLUS
  • LOADPLUS
  • IBM COPY

The utility will register the copy.

If the IBM COPY utility is used, RECVDD01 and RECVDD02 must equal R.

REFRESH=Y

This option indicates whether to refresh the data in a materialized query table (MQT) by using the REFRESH TABLE statement (Y or N).

REGENATR=Y

When you rebind advanced triggers with long names or delimited names, you might encounter problems. This can be resolved by regenerating the trigger. This option specifies whether to rebind the trigger by using the REBIND PACKAGE (N) or using the ALTER TRIGGER name REGENERATE VERSION version (Y) statement.

Important

For advanced triggers, you must specify REBIND PACKAGE, not REBIND TRIGGER PACKAGE.

REGENNSP=N

When you change a Db2 object to which a native SQL stored procedure references, the package that is associated with the stored procedure might need to be rebound. This option specifies whether to rebind the package by using the REBIND PACKAGE command or the ALTER PROCEDURE statement with the REGENERATE clause (Y or N ).


Parameter

Description

N

Generates the REBIND PACKAGE command.

Y

Generates the ALTER PROCEDURE statement with the REGENERATE clause.

This option determines what statements Compare generates when the only differences between two table definitions is a column rename.


Parameter

Description

N

Generates drop-and-add statements

Example of generated drop-and-add statements

 -CDL  000550 ALTER TABLE EF23158C.TRIG_SCHED                                   
          DROP COLUMN TSCHEMA                                           
          ADD COLUMN TSCHEMA_NEW BEFORE TRIG                            
                  (CHAR(10)    FOR SBCS DATA          
          NOT NULL WITH DEFAULT)   

Compare also generates warning message BMC56790W. 

Y

Generates a column rename statement

Example of generated column rename statement

-CDL  000550 ALTER TABLE EF23158C.TRIG_SCHED                                   
          ALTER COLUMN TSCHEMA (                                        
                NAME    TSCHEMA_NEW                             
                )     

Compare also generates message BMC56791I.

REORG=I

This option indicates whether to use the REORG PLUS product, BMC AMI Reorg product, or the IBM REORG utility to generate reorganization commands in worklists for changes that require reorganizing table spaces and indexes. Changes made to attributes such as PRIQTY, SECQTY, PCTFREE, FREEPAGE, and VOLUME (for VCAT-defined partitions) can cause placement of reorganization commands in the worklist.


Parameter

Description

I

If Db2 places the object in a REORG-pending advisory (AREO*) status or in a REORG-pending restrictive (REORP) status, generates reorganization commands for the IBM REORG utility.

B

If Db2 places the object in an AREO* status or in a REORP status, generates reorganization commands for the BMC utility that you specify:

  • REORG PLUS

    By default, the product uses REORG PLUS for reorganization.

  • BMC AMI Reorg(only ALTER and Change Manager version 12.1 and later)

    To select BMC AMI Reorg, you must use the USENGTR keyword in the ALUIN input stream or specify the USENGTR= Y installation option.

The utilities must be installed.

REORGALL=Y

This option indicates whether to reorganize a table space when a reorganization would be applicable (Y) or when the table space requires a reorganization (for example, the table space is in REORG-pending status) (N).

REORGREF=Y

This option indicates whether a table space should be reorganized by using the SHRLEVEL REFERENCE (Y) or SHRLEVEL NONE (N) option. This option is used when an online reorg (SHRLEVEL CHANGE) is either not applicable or not requested.

Important

BMC AMI Reorg always performs an online reorganization (SHRLEVEL CHANGE) and disregards this option.

REORGONL=N

This option indicates whether a table space should be reorganized by using an online reorg (SHRLEVEL CHANGE) (Y or N).

Important

BMC AMI Reorg always performs an online reorganization (SHRLEVEL CHANGE) and disregards this option.

ROLEOWN=N

This option indicates whether the object is to be created using a trusted context with ROLE as the object owner (ROLEOWN=Y) or using the user with the associated user privileges as the owner (ROLEOWN=N).

If you have set (ROLEOWN=Y), worklists are processed using the AUTHSWOFF option.

RPLUSYNC=R

This option indicates whether the migration file should include all table spaces in the BMC AMI Recover IMPORT command or only table spaces that have changed since the preceding migration. This option applies to the Copy Migration feature of the following solutions:

  • BMC AMI Recovery for Db2
  • BMC AMI Database Administration
  • NGT Database Administration
  • Database Administration


Parameter

Description

R

Replaces all table spaces regardless of whether they have changed or not.

Consider this option when migrating to a subsystem in which the data is manipulated in test environment.

A

Replaces only table spaces that have changed since the last time those spaces were imported.

Consider this option when migrating to a query-based environment when the table spaces are read only.

RPTPL=ACMvryR

(Change Manager only) This option specifies the name of the product plan that is used to generate reports.

SEQI=050

This option defines the sequence-number increment for worklists and CDL files.

SPANNED=Y

This option defines whether spanned records are used to unload and load XML or LOB columns.

SPP=ACMvryS

This option defines the Specification plan name.

STATHIST=Y

This option specifies that the BMC BMCSTATS utility or the IBM RUNSTATS utility will update the Db2 catalog history tables with the current statistics that are being collected (Y or N).

STATS=S

This option indicates the type of statistics that are generated. The parameters are defined as follows:


Parameter

Description

S

Stand-alone—Generates either a -BMCS (BMC BMCSTATS) or an -RNST (IBM RUNSTATS) command in a worklist for the generation of statistics.

U

Utility—Uses a copy, load, or reorg utility to generate statistics whenever possible.

X

Does not generate statistics.

STOPCOMM=N

This option indicates whether an AT (COMMIT) command is generated in a worklist when a STOP command is created.

STOPICP=N

This option indicates whether index-controlled partitioned objects can be created. STOPICP must be set to match the setting of DSNZPARM PREVENT_NEW_IXCTRL_PART. Set STOPICP=Y if you have set DSNZPARM PREVENT_NEW_IXCTRL_PART to Y.

If STOPICP=N, you can create index-controlled partitioned objects.

If STOPICP=Y, you are not allowed to create index-controlled partitioned objects.

STOPLIST=creatorName

This option specifies the eight-character creator name for a migrate-type work ID that identifies a list of tables that should not be modified or analyzed. The default value is blank.

STORCLAS=N

This option indicates whether support for the STORCLAS parameter is required for VCAT-defined Db2 objects (Y or N).

SYNCPNT=parm

This option creates additional -SYNC commands in a worklist, based on the number of -SQL commands since the last -SYNC command. The variable parm specifies the maximum number of -SQL commands that can be in the worklist before a -SYNC command is created. Valid values for parm are from 0 to 99. The default value is 10.

When the value is reached, the Analysis component places an additional -SYNC command before the next -SQL command. Any -SYNC command in the worklist resets the count of -SQL commands to zero. -SYNC commands that this keyword generates are in addition to the -SYNC commands that Analysis automatically generates.

SYSTYPE=S

This option defines the installation’s character set.


Parameter

Description

M

Mixed

S

Single-byte only

TABLEACC=Y

This option indicates whether all tables remain accessible during execution.


Parameter

Description

Y

Ensures that tables remain accessible during the execution of an alter-type worklist.

N

Prevents access to the tables in a worklist by putting objects into read-only status with START DATABASE commands in an alter-type worklist.

Whether TABLEACC=Y or TABLEACC=N, the SHRLEVEL NONE option is used as the default in a REORG TABLESPACE statement in a -BMCR or -REOR worklist command.

TABLEALL=N

This option specifies the STATS utility to gather information for all columns of tables.


Parameter

Description

N

Does not include the TABLE(ALL) parameter.

Y

Includes the TABLE(ALL) parameter in the -BMCS (BMC BMCSTATS) or the -RNST (IBM RUNSTATS) worklist command to gather statistics for all columns of all tables in a table space.

UCPKPALL=N

This option indicates whether the primary key constraint is included in a baseline or comparison.


Parameter

Description

N

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

Y

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

UNLDCOLL=N

This option indicates the explicit column list that is required on all UNLOAD PLUS unloads (Y or N).

UNLDEMPT=Y

This option indicates whether the tables that RUNSTATS indicates as empty are unloaded (Y or N).

UNQUALIFY=N


This option specifies whether to create tables, indexes, or views in a worklist with the CURRENT SQLID as the owner, the CURRENT SCHEMA as the creator, and the object with an unqualified name. The parameters are defined as follows:

Parameter

Description

N

Creates tables, indexes, or views with a qualified name.

To override this option and create objects with an unqualified name, use the UNQUALIFY ALUIN keyword.

Y

Creates tables, indexes, or views with the following details:

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

When this parameter is specified, the value of the AUTHSW installation option also must be set to N.

To override this option and create objects with a qualified name, use the QUALIFY ALUIN keyword.

UPDSTATS=C

This option specifies which statistics are updated. The parameters are defined as follows:


Parameter

Description

A

All—Updates the DASD tables and the Db2 catalog tables.

BMCSTATS is selected.

B

BMC DASD tables—Updates only the DASD tables.

BMCSTATS is selected.

C

Db2 Catalog–Updates only the Db2 catalog tables.

IBM RUNSTATS is selected.

USENGTR=N

(version 12.1 or later) If you have specified the installation option REORG=B, this option determines which BMC reorganizational utility (BMC AMI Reorg or REORG PLUS) is used to generate reorganization commands in worklists.


Parameter

Description

Y

Uses BMC AMI Reorg.

N

Uses REORG PLUS.

USENGTUL=N

(version 12.1 or later) This option specifies whether to use the BMC classic utilities or the BMC AMI Utilities utilities.

Parameter

Description

N

Uses either the BMC classic or IBM utilities, depending on the value you set in the BMCUNLD and BMCLOAD keywords.

Y

Uses BMC AMI Unload and BMC AMI Load to unload and load data. To use the BMC AMI Utilities, you must also include the BMCUNLD and BMCLOAD keywords in the installation options.

USUB=

This option specifies to use the IBM REORG utility instead of the BMC REORG PLUS utility to perform a reorganization. If USUB is S, the product uses the IBM REORG utility. Valid values are S or blank (default).


Parameter

Description

S

Uses IBM REORG.

 blank

Uses REORG PLUS.

UTILCOPY=N

This option determines whether other utilities or a copy utility creates an image copy during loads.


Parameter

Description

Y

Creates image copies by utilities other than the copy utilities, whenever possible.

If the utilities cannot create a copy, a separate copy step is generated.

N

Generates all copies that the specific copy utility takes (either the IBM COPY utility or the BMC AMI Copy utility) in a separate copy step

VRM=vrmm

This option indicates the version, release level, and maintenance level.

VVALPROP=N

This option indicates whether the product supports extended view text propagation (Y or N).

ZPARM=DSNZPARM

This option specifies a name for the Db2 DSNZPARM initialization parameter module.

If you use a DSNZPARM with a different name, update the ZPARM value and reassemble the DOPTS using the stand alone member in the hlq.UBMCCNTL data set.

The DSNZPARM module must be available in the Db2 DSNEXIT library specified for online or batch processes.

This ZPARM installation option and value is used only if the IBM SYSPROC.ADMIN_INFO_SYSPARM stored procedure is not available. To obtain the DSNZPARM values, grant MONITOR1 authority to each user because DASD MANAGER PLUS  calls the SYSPROC.ADMIN_INFO_SYSPARM stored procedure. IBM requires MONITOR1 authority to access the stored procedure.

 

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