-BMCC (BMC AMI Copy utility)

The -BMCC command invokes the

BMC AMI Copy

utility.

The -BMCC command can be processed in parallel. For more information about the worklist parallelism feature of the BMC Database Administration for DB2 and BMC AMI Database Administration for Db2 solutions, see Using-worklist-parallelism.

You can run the BMC AMI Copy utility to perform the following functions

Dynamically allocate copy data sets
Create partition-level image copies
Create a sequential migration file

Use of -BMCC to dynamically allocate copy data sets

The BMC AMI Copy utility can dynamically allocate the data sets that are used to create valid image copies.

JCL Generation uses the symbolic variable that is specified in the JCL Generation Data Set Options for Copies panels to create an OUTPUT descriptor for Analysis. When generating the -BMCC command, Analysis specifies the OUTPUT descriptor for local and recovery primary and backup copies. The DSNAME parameter in the descriptor specifies the data set name for the object that is copied.

Example of -BMCC command—dynamic allocation of data sets

-BMCC 004800
    OUTPUT DCPYLOCP
      UNIT SYSDA
    DSNAME RDAMCG.&UTIL.A.&DB.&TS.P&PART
               COPY TABLESPACE ACMX06A.X61NS
                    COPYDDN (DCPYLOCP)

The P&PART symbolic variable is used in the DSNAME parameter to ensure that the data set name for each object is unique for partition-level image copies.

If you want to stack the data sets on a tape with data sets of the same type, the product groups the OUTPUT descriptors and COPY statements in one -BMCC command, as shown below.

Important

The data sets for table spaces that are implicitly created cannot be stacked on tape.

Example of -BMCC command—dynamic allocation with tape stacking

-BMCC 002500
    OUTPUT DCPYLOCP
      UNIT CART
    DSNAME ACM.&UTIL.A.&DB.&TS
    VOLCNT 99
    EXPDT 2002/200
    STACK YES
    OUTPUT DCPYREMP
      UNIT CART
    DSNAME ACM.&UTIL.C.&DB.&TS
    VOLCNT 99
    EXPDT 2002/200
    STACK YES
               COPY TABLESPACE ACMX01L.X05SS
                    COPYDDN (DCPYLOCP)
                    RECOVERYDDN (DCPYREMP)
                 TABLESPACE ACMX01L.X04NS
                    COPYDDN (DCPYLOCP)
                    RECOVERYDDN (DCPYREMP)

Use of -BMCC to create partition-level image copies

Analysis can generate a partition-level image copy of a partitioned table space or index in a database when you select to use BMC AMI Copy as the copy utility.

Example of -BMCC command—partition-level image copies shows an example of the -BMCC command that is used when partition-level image copies are requested for a partitioned index. The ALL option in the OPTIONS parameter indicates that the entire partitioned index is copied.

-SPAC 001100 DDNAME C002 BMCC IX C7PCB1C.IX37A1
-BMCC 001150
    OPTIONS IXDSNUM ALL
               COPY INDEX      C7PCB1C.IX37A1
                    COPYDDN (C0020001)
                    DSNUM      1
                  INDEX      C7PCB1C.IX37A1
                    COPYDDN (C0020002)
                    DSNUM      2
                  INDEX      C7PCB1C.IX37A1
                    COPYDDN (C0020003)
                    DSNUM      3

Use of -BMCC to create sequential migration files

The BMC AMI Copy EXPORT command and BMC AMI Recover IMPORT command enable you to migrate an image copy or set of image copies within a Db2 subsystem or to another Db2 subsystem.

The EXPORT and IMPORT commands comprise the Copy Migration feature of the Recovery Management for Db2, BMC AMI Recovery for Db2, BMC AMI Database Administration, Next Generation Technology Database Administration for DB2, and Database Administration solutions.

BMC AMI Copy invokes the BMC AMI Copy EXPORT command on the sending subsystem during phase 1 of the migration to collect information on one or more table spaces. This information includes object identifiers, the names of image copies, and other information relating to the sending table spaces. The EXPORT command includes this information in a sequential migration file.

Example of -BMCC command—EXPORT command

-BMCC 000700
           OPTIONS MAXTASKS (1,1)
    OUTPUT EXPFILE
      UNIT SYSALLDA
      EXPOUT YES
    DSNAME RDADQL.DEGA.WORKIDXX.EX000001
            EXPORT TABLESPACE DQC07090.TS07090A
                            , DQ2CLG2.T03PBGY
            AUX ALL
            ATLOGPOINT LASTFULLCOPY
            EXPORTDDN(EXPFILE)
            REUSE YES

-BMCC 000750
           OPTIONS MAXTASKS (1,1)
    OUTPUT EXPFILE
      UNIT SYSALLDA
      EXPOUT YES
    DSNAME RDADQL.DEGA.WORKIDXX.EX000002
            EXPORT TABLESPACE DQC07090.TS07090A
                            , DQ2CLG2.T03PBGY
            CLONE
            AUX ALL
            ATLOGPOINT LASTFULLCOPY
            EXPORTDDN(EXPFILE)
            REUSE YES

The EXPORT command uses the following options.

EXPORT command options

Option	Notes
OPTIONS MAXTASKS	Instructs BMC AMI Copy to use only one task, so that BMC AMI Copy creates only one EXPORT file and includes all of the table spaces in the file
EXPORT TABLESPACE	Provides an explicit list of table spaces to include in the scope of the migration To include history tables in the EXPORT file, you must include the parent table space in the BMC AMI Copy scope of the migration.
ATLOGPOINT LASTFULLCOPY	Instructs BMC AMI Copy to use the last full image copy
AUX ALL	Instructs BMC AMI Copy to include auxiliary objects in the image copy You do not have to explicitly specify the auxiliary objects.
INDEXES YES	Instructs BMC AMI Copy to include indexes in the image copy
REUSE YES	Allocates the EXPORT file (if the file does not already exist), replaces the contents of the EXPORT file (if the file does exist), and reprocesses all table spaces when restarting or starting over a worklist You must use REUSE YES if you are restarting a worklist.

Notes for -BMCC

For some objects, Analysis generates the -BMCC command differently.

Note the following items when the -BMCC command is used in a worklist:

The utility command starts on the second line of the statement. The first line is reserved for parameters that are passed to the utility.
If a table space is created explicitly, Analysis generates the command as shown in the example below.
Example of -BMCC command
-BMCC 001700
COPY TABLESPACE BRDB101.N1
DEVT SYSDA COPYDDN (SYCL0001,SYCR0002)
If the table space is created implicitly, the character T precedes the command text. The execution looks up the table space name during processing and substitutes it for the table name before invoking the utility.
If Db2 created XML or LOB objects implicitly, the -BMCC command includes the following parameters:
- XMLTBO or LOBTBO, which identifies the owner of the table
- XMLTBN or LOBTBN, which identifies the name of the table
- XMLCOL or LOBCOL, which identifies the name of the XML or LOB column
The COPY command syntax also includes the name of the XML or LOB table space that supports the XML or LOB column in the base table.

For more information, see BMC AMI Copy for Db2 documentation.