CLONING

Edit online

The CLONING section of the IBM® Storage Protect Snapshot profile contains parameters that are used for cloning operations. The parameters are independent of the storage device or application.

The following lists provide the parameters, a description of each parameter, and default values for the CLONING section.

The following parameters apply to DB2® databases:
DEVICE_CLASS
This required parameter identifies the device class to use when you are cloning a database. The following code sample provides an example of how to specify options for this parameter: 
DEVICE_CLASS <device class> 
USE_FOR_CLONING <list of clone database names> [conditions]
There is an optional conditions statement that can be used. The following code sample includes an example of how to use the conditions statement.

The condition statement is optional. When you use the condition statement, use the following syntax:


[USE_AT <days of week>] [FROM <time> TO <time>] 
[ON_DBPARTITIONNUMS <list of partitions>]
The time period that is specified cannot span midnight for a device class. If a device class time period is required to span midnight, you must specify two time periods for the device class. The first time period must end with a value 1 minute before midnight and the second time period must start at midnight. The following example shows how to specify a time period that spans midnight for a device class:
DEVICE_CLASS <myClass1> USE_FOR_CLONING CL1 FROM 20:00 TO 23:59 
DEVICE_CLASS <myClass2> USE_FOR_CLONING CL2 FROM 00:00 TO 06:00

If multiple DEVICE_CLASS statements are used, ensure that a unique 1-to-1 relation between the clone database name and the device class exists.

Default
Not applicable.
Advanced mode only
No.
CLONE_DATABASE_MEMORY
Use this parameter to change the amount of initial shared memory that is allocated by the database on the clone server. The value that is specified is used to modify the DB2 database shared memory size configuration parameter (DATABASE_MEMORY) on the clone server. The value must be a number, and documented limits for the database configuration parameter DATABASE_MEMORY apply. If the CLONE_DATABASE_MEMORY parameter is set to 0, the DATABASE_MEMORY value set for the productive database is used for the clone database.
Default
The same amount of initial shared memory that is allocated by DB2 on the production server.
Advanced mode only
Yes
ENHANCED_PARTITIONING
The ENHANCED_PARTITIONING parameter is used to control processing when extra file systems that are not database files are specified by the FLASH_DIR_LIST parameter in a cloning operation. IBM Storage Protect Snapshot fails, when a file system that is specified by the FLASH_DIR_LIST parameter contains symbolic links that point to a file system on a different volume group that is not part of the snapshot operation. Set the ENHANCED_PARTITIONING parameter to NO to ensure that symbolic links if present are not processed. You must manually add this parameter to the IBM Storage Protect Snapshot profile file. The following list identifies the possible options:
YES
Use this option to ensure that IBM Storage Protect Snapshot processes all symbolic links of files or directories that are specified in the FLASH_DIR_LIST profile parameter.
NO
Use this option to ensure that IBM Storage Protect Snapshot does not process symbolic links of files or directories that are specified in the FLASH_DIR_LIST profile parameter.
Default
YES
Advanced mode only
Yes.
FLASH_DIR_LIST
This parameter is used to include files systems that are not part of the database files in the snapshot operation.
Specify a fully qualified directory name and file name. For example: 
[ON DBPARTITIONNUM list of partitions] fully qualified file name

Inside the file, specify one fully qualified file or directory on each line. IBM Storage Protect Snapshot includes the complete volume groups where the specified files or directories are located in the snapshot.

In DB2 Data Partitioning Feature environments that contain multiple partitions, a different file name for each partition can be specified. In this scenario, because different file names are specified for different partitions, specify the ON DBPARTITIONNUM parameter. Each partition number is separated by a space.

The default value is an empty list. This value prevents extra volumes from participating in the snapshot operation.

Default
By default, no file name is specified.
Advanced mode only
Yes.
DATABASE_SCHEMA
When a clone database is created from the production database, the database schema does not change. The clone database uses the database schema that is used by the production database. The DATABASE_SCHEMA parameter is used to specify the database schema. For DB2, the DATABASE_SCHEMA parameter is required. The default database schema is determined by the dbs_db6_schema environment variable. These environment variables are set on the production database instance owner environment.
If the environment variable is not set, the default database schema value is SAPR3. The DATABASE_SCHEMA parameter is evaluated when the following conditions exist:
  • A processing script is used with the preproc_clone or postproc_clone command.
  • The refresh_clone command is entered with the -X or -Y cloning parameter.
  • The create_clone command is entered with the -Y cloning parameter.
Default
The default value is determined by environment variables.
Advanced mode only
Yes.
NEGATIVE_LIST
The NEGATIVE_LIST parameter is used to control processing when files that are not associated with the database are stored within the same file system that is used for the backup and restore operations. This parameter is required. The following list identifies the options:
NO_CHECK
Use this option to not check for extra files. The operation ignores any additional files that are identified. When you use this option and data is restored, all files that are on the file system or volume group are overwritten.
WARN
Use this option to receive a warning message for each file that is identified on the volume, but not part of the snapshot operation. The processing continues. When you use this option and data is restored, all files that are on the file system or volume group are overwritten.
ERROR
Use this option to receive an error message for each file that is discovered on the volume, but not part of the snapshot operation. The processing ends.
filename
Use this option to back up and restore files that are not part of the database tablespace files. Using this option includes files in the snapshot operations. When you use this option, specify the fully qualified names of the files and directories. Use one line for each entry. When these files are identified, processing continues. When other files are identified, but not part of the database tablespace files or identified in the NEGATIVE_LIST file, processing ends. Any directory that is listed in the NEGATIVE_LIST file is processed recursively. For example, all files within the directory, including subdirectories, are processed during a backup or restore request.
Default
There is no default for this required parameter.
Advanced mode only
Yes.
TIMEOUT_FLASH
This parameter specifies the maximum time, in seconds, that the database agent waits for a response to the management agent call during the flash phase. If the database agent does not receive a response within the specified time, an error message is displayed. This parameter allows the maximum time to be specified for a database to be suspended. This parameter also implies the maximum time when JFS2 file systems can be frozen. When the timeout is reached, the file systems thaw, the database is resumed, and the backup operation ends with an error. The minimum value for TIMEOUT_FLASH is 5 seconds.
Default
The default value is 120 seconds.
Advanced mode only
Yes
TIMEOUT_<PHASE>
Specify the maximum time (in seconds) that the database agent waits for a response to the management agent call during the <phase> phase. If the database agent does not receive a response within the specified time, the cloning operation ends and an error message is displayed. The default value is 3600 seconds.
You can specify one of these phase values for a snapshot backup. For example: TIMEOUT_PREPARE
  • PARTITION
  • PREPARE
  • VERIFY
  • CLOSE
Advanced mode only
Yes.