Overview of the Copy function


You can use the Copy function online or offline to heal EPS pointers in a HALDB.

The Copy function reorganizes indexes without reorganizing the primary database. It is useful for removing CI/CA splits. It is similar to a REPRO but uses shadow databases while the database is online for updates. The Copy function takes advantage of the AOI and swapping automation that the Online Reorg function provides. You can also use the Copy function to produce copies of databases for use in other systems by specifying SWAP(N). A no-outage batch image copy is created when keyword ICP(Y) is included when creating copies of databases.

The following features are supported by the COPY command:

  • The HEAL keyword heals EPS pointers.

    Warning

    Note

    Running under the COPY command, this keyword replaces the HEALEPS function in earlier releases.

  • SHARE keyword support was added to support online or offline COPY.
  • With CHANGE RECORDING FACILITY, the COPY command uses the CHANGE RECORDING FACILITY log capture facility to allow copying of database data sets while they are online.
  • IDCAMS(MODEL) support was added.
  • ICP(Y) support was added.
  • You can perform the following operations with the COPY command:
    • Create a copy of a production database, both full function and HALDB (the whole database or one or more partitions including the ILDS)
    • Reorganize indexes and remove CI/CA splits
    • Move data sets to new volumes
    • Heal HALDB pointers in secondary indexes and logical relationships
    • Copy a subset of partitions of HALDB databases and indexes
    • Copy HALDB ILDS and/or primary index
    • Create a no-outage, batch image copy
Warning

Note

To use the COPY command, you must meet the following requirements:

  • You must have a license for either FAST REORG FACILITY/EP or CHANGE RECORDING FACILITY.
  • You must have the CRF product active in the IMS control region.
  • The COPY job must use the same RECONs as the IMS control region.
  • Multiple COPY commands require Cross-System Image Manager (XIM) because each COPY is run in a separate XIM discrete unit of work (UOW).

The following example shows sample JCL to execute the Copy function.

//***********************************************************
//* SAMPLE JCL
//***********************************************************
//CPYTSTA EXEC PGM=DLICPYON,REGION=4096K
//STEPLIB DD DISP=SHR,DSN=bmc.xxx.load
//DD DISP=SHR,DSN=IMSVS.Rxx.RESLIB
//DFSRESLB DD DISP=SHR,DSN=IMSVS.Rxx.RESLIB
//IMS DD DISP=SHR,DSN=IMSVS.Rxx.DBDLIB
//PLUSIN DD *
COPY DBD(dbdName) SWAP(N) -
DBRC(Y) IMSID(xxxx) DYNALLOC(Y,Y,Z)
//SYSPRINT DD SYSOUT=*
//BMCPRINT DD SYSOUT=*
//BMCMSG DD SYSOUT=*
//BMCTRACE DD SYSOUT=*

The following JCL statements apply to the Copy function.

Warning

Note

The CRFRDER/CRFRDER2 and IEFRDER/IEFRDER2 DD statements are not used for the Copy function.

EXEC

Required. Specifies PGM=DLICPYON.

STEPLIB DD

Required. Points to the BMC load library.

IMS DD

Required. Defines the IMSVS.DBDLIB data set that contains the DBD that will be used to sort the unsorted unload file into sequence.

DFSRESLB DD

Required. Defines the library that contains the IMS.RESLIB.

dbdddnam DD

Required unless DYNALLOC is used. Defines the new copy of the database after it is copied.

newddnam DD

Required unless DYNALLOC is used. Defines the data set that contains the original database that is being reorganized.

PLUSIN DD

Required. Defines the data set that contains the control statements for the Copy function.

The COPY command is required.

The following table describes the keywords that you use with PLUSIN DD.

Keyword

Required or optional

Accepted values

Description

AOIUSER

Optional

(progName)

Default: none

Specifies whether to invoke a user exit from within the AOI

DBD

Required

(dbdName)

Default: none

Specifies the DBD name

If you are reorganizing a single index, specify the name of the INDEX DBD. If you are making an offline copy of a database, specify the name of the database that is being copied. The name can be a secondary index, a primary index, or a primary DBD. If you specify a primary database name, you can build multiple indexes at once by specifying the SECINDEX keyword.

DBRC

Required

(Y)

(N)

Default: none

Specifies whether to invoke DBRC when there is no region controller

Specify N to invoke only by region controller.

DESCCODE

Optional

(nn,...)

Maximum ten entries

Default: (7)

Specifies descriptor codes used to route messages to the console

DYNALLOC

Optional

(YES)

(NO)

(YES,YES,x)

(YES,NO,x)

(NO,YES)

Default: (NO)

Dynamically allocate all database data sets using the data set names specified in the RECON data sets, and give output data sets unique names

GSGNAME

Optional

(gsgName)

Default: Use the GSG name used in system generation

Uses a global service group (GSG) name for remote site recovery (RSR)

HEAL

Optional

(Y)

(N)

Default: (N)

Heals or corrects Extended Pointer Set (EPS) pointers in HALDBs

ICP

Optional

(Y)

(N)

Default: (N)

Specify whether to take an image copy of the output data sets.

IDCAMS

Optional

(input)

(input,output)

(input,output,Y)

(input,output,N)

(model)

Default: none

Specifies SYSIN and SYSPRINT files for IDCAMS processing

DBRC(Y) required.

ILDS


(YES)

(NO)

(ONLY)

default: (NO)

Valid for PHDAM and PHIDAM

Specifies whether the ILDS of a HALDB should be copied

INDD

Optional

(DFSURWF1)

(DFSURIDX)

Default: none

Specifies the input data set if you are not scanning the primary database

OMAPI

Optional

(Y)

(N)

Default: (N)

Specifies whether to use IMS type-2 commands.

OUTDD

Optional

(ddname)

Default: none

Specifies the DD statement for the copied database

PART

Optional for a HALDB

(partName1,partName2...)

default: (ALL)

Valid for PHDAM, PHIDAM or PSINDEX

Specifies the names of partitions that are to be copied

PRIMIND

Optional for a HALDB

(YES)

(NO)

(ONLY)

default: (NO)

Valid for PHIDAM

Specifies whether the primary index of a HALDB should be copied

ROUTCODE

Optional

(nn,...)

max 10 entries

Default: (2,7)

Specifies routing codes to control the destination of messages that are sent to the console

SECINDEX

Optional

(YES)

(NO)

(ONLY)

Default: (NO)

  • YES-copy the DBD and all secondary indexes
  • NO-copy only the DBD
  • ONLY-copy only the secondary indexes of the DBD

SHARE

Optional

(YES,UPDATE)

Online

Specifies whether users will have update access to the database during reorganization

Optional

(YES)

(NO)

(YES,READ)

Specifies whether users will have read access to the database during reorganization

SWAP

Optional

(YES)

(NO)

(NO, DELETE)

(DELETE)

(YES,IC)

(SUSPEND,IC)

Default: (NO)

Specifies whether to swap the data set names after a successful reorganization

Warning

Note

If you have Cross-System Image Manager (XIM) installed, you can specify multiple COPY commands in the PLUSIN stream. If multiple COPY commands are found, XIM spawns an address space for each COPY command. If you do not use XIM, and you specify multiple COPY commands, the step fails.


Related topic




 

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

BMC AMI Online Reorg for IMS 5.1