ALTERNATE COPY POOL field (ALTERNATE_CP subsystem parameter)
The ALTERNATE_CP subsystem parameter specifies the name of an alternate SMS copy pool for the BACKUP SYSTEM utility. If a copy pool is specified, BACKUP SYSTEM alternates between using that copy pool and the standard copy pool when the utility creates system-level backups.
| Acceptable values: | blank or 1–14 alphanumeric characters, including @, #, and $. The first character must be non-numeric.Db2 uses this value to build the name according to the Db2 naming convention for copy pools. |
|---|---|
| Default: | blank |
| Update: | option 36 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM ALTERNATE_CP |
| Data sharing scope: | Same setting recommended on all members |
The value of the ALTERNATE_CP subsystem parameter applies only if the ALTERNATE_CP option is not specified in the BACKUP SYSTEM utility control statement. If the ALTERNATE_CP option is specified in the BACKUP SYSTEM statement, that value overrides the subsystem parameter value. In that case, the copy pool that is specified in the BACKUP SYSTEM statement is used as the alternate copy pool for that utility invocation only.
The value of the ALTERNATE_CP subsystem parameter has the following meanings:
- blank
- BACKUP SYSTEM uses the standard copy pool only.
- Not blank
- BACKUP SYSTEM uses the specified copy pool as the alternate copy pool for system-level backups. BACKUP SYSTEM alternates between using the standard copy pool and the alternate copy pool for system-level backups. BACKUP SYSTEM checks the BSDS to determine whether the standard copy pool or alternate copy pool was used for the most recent system-level backup. If no system-level backups are recorded in the BSDS, BACKUP SYSTEM uses the standard copy pool. If system-level backups are recorded in the BSDS, BACKUP SYSTEM uses the copy pool that was not used for the most recent system-level backup. .
BACKUP SYSTEM, RESTORE SYSTEM, and RECOVER can create and use system-level backups for the standard copy pool and more than one alternate copy pool. However,only the standard copy pool and the alternate copy pool that is specified in the ALTERNATE_CP subsystem parameter are used for automatically alternating the copy pool for system-level backups. Other copy pool names are ignored.
The ALTERNATE_CP value applies to both the database copy pool and the log copy pool, if one is specified.
