DB2 profile example

Edit online

The profile file provides parameters that customize how IBM® Storage Protect Snapshot works within a particular environment. Use this example to verify that the configuration of the profile is correct for your DB2® data partitioning environment.

The following sample profile is used for a DB2 DPF environment. The profile specifies that snapshots are completed from 06am to 8pm and snapshots with offloaded backups for the remaining time. These offloaded backups use two different SAN Volume Controller clusters, one from 00am to 6am and the other cluster from 8pm to 12pm. Each cluster is backed up by a separate backup system, even though that fact is not obvious in the example.

>>> GLOBAL
ACS_DIR /db2/D01/acs
ACSD acsprod5 57328
TRACE NO
<<< 
>>> ACSD
ACS_REPOSITORY /db2/D01/acs/acsrepository
# ADMIN_ASSISTANT NO
# REPOSITORY_LABEL TSM
<<< 
>>> OFFLOAD
BACKUP_METHOD DB2
OPTIONS @/db2/D01/tdp_r3/vendor.env
# PARALLELISM AUTO
# NUM_SESSIONS 1
# NUM_BUFFERS AUTO
# BUFFER_SIZE AUTO
<<< 
>>> CLIENT
# BACKUPIDPREFIX DB2___
APPLICATION_TYPE DB2
TSM_BACKUP YES
TSM_BACKUP NO USE_FOR SVC_NO_TSM
MAX_VERSIONS ADAPTIVE
# LVM_FREEZE_THAW AUTO
# NEGATIVE_LIST NO_CHECK
# TIMEOUT_FLASH 120
# GLOBAL_SYSTEM_IDENTIFIER
DEVICE_CLASS SVC2 FROM 00:00 TO 05:59
DEVICE_CLASS SVC_NO_TSM FROM 06:00 TO 20:00
DEVICE_CLASS SVC1 FROM 20:01
<<<

>>> DEVICE_CLASS SVC_NO_TSM
COPYSERVICES_HARDWARE_TYPE SVC
COPYSERVICES_PRIMARY_SERVERNAME 192.168.1.104
# COPYSERVICES_USERNAME superuser
# SVC_COPY_RATE 80
# SVC_CLEAN_RATE 50
# COPYSERVICES_COMMPROTOCOL HTTPS
# COPYSERVICES_CERTIFICATEFILE NO_CERTIFICATE
COPYSERVICES_SERVERPORT 5989
FLASHCOPY_TYPE COPY
# COPYSERVICES_TIMEOUT 6
# RESTORE_FORCE NO
LVM_MIRRORING YES
TARGET_SETS VOLUMES_FILE
VOLUMES_FILE /db2/D01/acs/acsvolumes/fct.file
BACKUP_HOST_NAME PREASSIGNED_VOLUMES
<<< 
>>> DEVICE_CLASS SVC1
COPYSERVICES_HARDWARE_TYPE SVC
COPYSERVICES_PRIMARY_SERVERNAME 192.168.1.101
# COPYSERVICES_USERNAME superuser
# SVC_COPY_RATE 80
# SVC_CLEAN_RATE 50
# COPYSERVICES_COMMPROTOCOL HTTPS
# COPYSERVICES_CERTIFICATEFILE NO_CERTIFICATE
# COPYSERVICES_SERVERPORT 5989
FLASHCOPY_TYPE INCR
# COPYSERVICES_TIMEOUT 6
# RESTORE_FORCE NO
LVM_MIRRORING YES
TARGET_SETS VOLUMES_FILE
VOLUMES_FILE /db2/D01/acs/acsvolumes/fct.file
BACKUP_HOST_NAME PREASSIGNED_VOLUMES
<<< 
>>> DEVICE_CLASS SVC2
COPYSERVICES_HARDWARE_TYPE SVC
COPYSERVICES_PRIMARY_SERVERNAME 192.168.1.104
# COPYSERVICES_USERNAME superuser
# SVC_COPY_RATE 80
# SVC_CLEAN_RATE 50
# COPYSERVICES_COMMPROTOCOL HTTPS
# COPYSERVICES_CERTIFICATEFILE NO_CERTIFICATE
COPYSERVICES_SERVERPORT 5989
FLASHCOPY_TYPE INCR
# COPYSERVICES_TIMEOUT 6
# RESTORE_FORCE NO
LVM_MIRRORING YES
TARGET_SETS VOLUMES_file
VOLUMES_FILE /db2/D01/acs/acsvolumes/fct.file
BACKUP_HOST_NAME PREASSIGNED_VOLUMES
<<<