IMAGECOPY statement
The IMAGECOPY statement specifies an exact location for input image copies.
Normally, Log Master uses the Db2 catalog to locate input image copies, and then uses the image copies to perform row completion or to obtain compression dictionaries. Use this statement when the record of an image copy has been deleted from the SYSIBM.SYSCOPY table of the Db2 catalog, but the image copy data sets themselves are still available. If you specify the image copy location, Log Master can use the image copies directly. You can specify multiple input image copies with one IMAGECOPY statement.
The following figure shows the IMAGECOPY statement syntax:
Option | Description | ||||||
|---|---|---|---|---|---|---|---|
TABLESPACE NAME | Indicates that Log Master uses input from an image copy that contains the table space represented by tableSpaceName. | ||||||
DSNDB04 | databaseName | Specifies the database associated with an input image copy.
| ||||||
tableSpaceName | Specifies the table space that is contained in an input image copy. | ||||||
Image copy parameters | Specifies the location and other attributes of an input image copy. See Image copy parameters. |
Image copy parameters
The Image copy parameters specify the location and other attributes of an input image copy. The information from these parameters enables
Log Master
to use the image copy to perform row completion or to obtain a compression dictionary.
Log Master can obtain dictionaries from the following sources, listed in order of preference:
- Current table space
- Db2 log
- Old Objects Table of the Repository
- Image copies of the table space
The following figure shows the Image copy parameters syntax of the IMAGECOPY statement.
Option | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
DATASET dataSetName | Specifies the name of a data set that contains the input image copy. | ||||||||
IMRBA x 'imrba' | Specifies the RBA/LRSN of the log point when the input image copy was created. | ||||||||
ENCRYPTED | FLASHCOPY | SNAPSHOT | Specifies the type of the input image copy. The default is a SYSCOPY copy. | ||||||||
DATE (date) TIME (time) | Specifies the date and time when the input image copy was registered in BMXCOPY or SYSCOPY. These values are required for an ENCRYPTED copy. | ||||||||
DSNUM 0 | DSNUM n | Specifies a partition of a partitioned table space that is contained in the image copy.
| ||||||||
ICTYPE | Specifies the type of the input image copy.
| ||||||||
DEVT deviceType | Specifies the type of the device that contains the input image copy. Enter a site-specific name for a type of storage device (for example, 3390 for a DASD device, or TAPE for a magnetic tape device). Use this keyword only if the image copy data set is uncataloged. | ||||||||
VOLSER (volser) | Specifies the VOLSER of the device that contains the input image copy. To enter multiple VOLSERs, separate each with a comma. Use this keyword only if the data set containing the input image copy is uncataloged. | ||||||||
SEQNO n | Specifies the sequence number if the input image copy is located on a tape volume. Use this keyword only if the data set containing the input image copy is uncataloged. | ||||||||
REMAP | Indicates that the input image copy occurred immediately after an event that remapped (modified) the record IDs (RIDs) in the table space. Typically, Db2 remaps RIDs when you run a Db2 Load or Reorg utility program. |