DB2 environment variables

The following table lists the supported environment variables for DB2, for each BMC Database Automation activity:   

Activity

Environment Variables

Create DB2 Instance

GA_ARCHITECTURE
GA_BITS
GA_DAS_COPY
GA_DB2_COPY
GA_DB2_FIXPACK
GA_DB2_VERSION
GA_DB2_DAS_HOME
GA_DB2_DAS_USER
GA_DB2_INSTALL_TYPE
GA_DB2_INSTANCE_FENCED_USER
GA_DB2_INSTANCE_HOME
GA_DB2_INSTANCE_NAME
GA_DB2_INSTANCE_USER
GAC_{CUSTOM_FIELD}
GA_DAGENT_VERSION
GA_DOMAIN
GA_JOB_ID
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_PERL
GA_RUN_STATE
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_VAR_DIR
GA_VERIFY_MODE
GA_XML

Remove DB2 InstanceGA_ARCHITECTURE
GA_BITS
GA_DAS_COPY
GA_DB2_COPY
GA_DB2_FIXPACK
GA_DB2_VERSION
GA_DB2_DAS_HOME
GA_DB2_DAS_USER
GA_DB2_INSTALL_TYPE
GA_DB2_INSTANCE_FENCED_USER
GA_DB2_INSTANCE_HOME
GA_DB2_INSTANCE_NAME
GA_DB2_INSTANCE_USER
GAC_{CUSTOM_FIELD}
GA_DAGENT_VERSION
GA_DOMAIN
GA_JOB_ID
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_PERL
GA_RUN_STATE
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_VAR_DIR
GA_VERIFY_MODE
GA_XML
Create DB2 Database

GA_DB2_DB_ALIAS_COUNT
GA_DB2_DB_ALIAS_n_ALT_HOSTNAME
GA_DB2_DB_ALIAS_n_ALT_PORT
GA_DB2_DB_ALIAS_n_COMMENT
GA_DB2_DB_ALIAS_n_NAME  
GA_DB2_DB_ALT_HOSTNAME
GA_DB2_DB_ALT_PORT
GA_DB2_DB_AUTOCONFIGURE_APPLY
GA_DB2_DB_AUTOCONFIGURE_KEYWORD_COUNT
GA_DB2_DB_AUTOCONFIGURE_KEYWORD_n
GA_DB2_DB_AUTOCONFIGURE_VALUE_n
GA_DB2_DB_AUTOMATIC_STORAGE
GA_DB2_DB_CATALOG_TABLESPACE_AUTORESIZE
GA_DB2_DB_CATALOG_TABLESPACE_CONTAINER_COUNT
GA_DB2_DB_CATALOG_TABLESPACE_CONTAINER_n
GA_DB2_DB_CATALOG_TABLESPACE_CREATED
GA_DB2_DB_CATALOG_TABLESPACE_EXTENT_SIZE
GA_DB2_DB_CATALOG_TABLESPACE_FILE_SYSTEM_CACHING
GA_DB2_DB_CATALOG_TABLESPACE_INCREASE_SIZE
GA_DB2_DB_CATALOG_TABLESPACE_INITIAL_SIZE
GA_DB2_DB_CATALOG_TABLESPACE_MANAGED_BY
GA_DB2_DB_CATALOG_TABLESPACE_MAX_SIZE
GA_DB2_DB_CATALOG_TABLESPACE_OVERHEAD
GA_DB2_DB_CATALOG_TABLESPACE_PREFETCH_SIZE
GA_DB2_DB_CATALOG_TABLESPACE_TRANSFER_RATE
GA_DB2_DB_CODESET
GA_DB2_DB_COLLATION
GA_DB2_DB_COMMENT
GA_DB2_DB_DFT_EXTENT_SZ
GA_DB2_DB_ENCRYPTION_CIPHER
GA_DB2_DB_ENCRYPTION_ENABLED
GA_DB2_DB_ENCRYPTION_KEY_LENGTH
GA_DB2_DB_ENCRYPTION_MASTER_KEY_LABEL
GA_DB2_DB_ENCRYPTION_MASTER_KEY_OPTIONS_SPECIFIED
GA_DB2_DB_ENCRYPTION_MODE
GA_DB2_DB_ENCRYPTION_OPTIONS_SPECIFIED
GA_DB2_DB_ENCRYPTION_SUPPORTED
GA_DB2_DB_NUMSEGS
GA_DB2_DB_PAGESIZE
GA_DB2_DB_RESTRICTIVE
GA_DB2_DB_STORAGE_DBPATH
GA_DB2_DB_STORAGE_PATHS_COUNT
GA_DB2_DB_STORAGE_PATH_n
GA_DB2_DB_TEMPORARY_TABLESPACE_AUTORESIZE
GA_DB2_DB_TEMPORARY_TABLESPACE_CONTAINER_COUNT
GA_DB2_DB_TEMPORARY_TABLESPACE_CONTAINER_n
GA_DB2_DB_TEMPORARY_TABLESPACE_CREATED
GA_DB2_DB_TEMPORARY_TABLESPACE_EXTENT_SIZE
GA_DB2_DB_TEMPORARY_TABLESPACE_FILE_SYSTEM_CACHING
GA_DB2_DB_TEMPORARY_TABLESPACE_INCREASE_SIZE
GA_DB2_DB_TEMPORARY_TABLESPACE_MANAGED_BY
GA_DB2_DB_TEMPORARY_TABLESPACE_MAX_SIZE
GA_DB2_DB_TEMPORARY_TABLESPACE_OVERHEAD
GA_DB2_DB_TEMPORARY_TABLESPACE_PREFETCH_SIZE
GA_DB2_DB_TEMPORARY_TABLESPACE_TRANSFER_RATE
GA_DB2_DB_TERRITORY
GA_DB2_DB_USER_TABLESPACE_AUTORESIZE
GA_DB2_DB_USER_TABLESPACE_CONTAINER_COUNT
GA_DB2_DB_USER_TABLESPACE_CONTAINER_n
GA_DB2_DB_USER_TABLESPACE_CREATED
GA_DB2_DB_USER_TABLESPACE_EXTENT_SIZE
GA_DB2_DB_USER_TABLESPACE_FILE_SYSTEM_CACHING
GA_DB2_DB_USER_TABLESPACE_INCREASE_SIZE
GA_DB2_DB_USER_TABLESPACE_INITIAL_SIZE
GA_DB2_DB_USER_TABLESPACE_MANAGED_BY
GA_DB2_DB_USER_TABLESPACE_MAX_SIZE
GA_DB2_DB_USER_TABLESPACE_OVERHEAD
GA_DB2_DB_USER_TABLESPACE_PREFETCH_SIZE
GA_DB2_DB_USER_TABLESPACE_TRANSFER_RATE
GAC_{CUSTOM_FIELD} 
GA_DAGENT_VERSION 
GA_DOMAIN 
GA_JOB_ID 
GA_LOG_DIR 
GA_MANAGER_ADDRESS 
GA_OPERATION 
GA_OPERATION_DESCRIPTION 
GA_PERL 
GA_RUN_STATE 
GA_SCRIPT_DIR 
GA_SUBJOB_ID 
GA_VAR_DIR
GA_VERIFY_MODE 
GA_XML

Remove DB2 Database

GA_DB2_DB_ALIAS
GA_DB2_DB_COMMENT 
GA_DB2_DB_PARTITION 
GA_DB2_DB_RELEASE_LEVEL 
GA_DB2_DB_REMOVE_DEACTIVATE 
GA_DB2_DB_REMOVE_DISALLOW_TCPIP_CONNECTIONS
GA_DB2_DB_REMOVE_FORCE_APPLICATION_ALL  
GA_DB2_DB_REMOVE_QUIECE
GA_DB2_DB_REMOVE_RESET_CONNECTION 
GA_DB2_DB_REMOVE_STOP_START  
GA_DB2_DB_REMOVE_TERMINATE 
GA_DB2_DB_TYPE
GA_DB2_LOCAL_DB_DIR
GAC_{CUSTOM_FIELD} 
GA_DAGENT_VERSION 
GA_DOMAIN 
GA_JOB_ID 
GA_LOG_DIR 
GA_MANAGER_ADDRESS 
GA_OPERATION 
GA_OPERATION_DESCRIPTION 
GA_PERL 
GA_RUN_STATE 
GA_SCRIPT_DIR 
GA_SUBJOB_ID 
GA_VAR_DIR
GA_VERIFY_MODE 
GA_XML

Apply Patch to DB2 Instance

GAC_{CUSTOM_FIELD}
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_DAGENT_VERSION
GA_DB2_COPY
GA_DB2_DAS_HOME
GA_DB2_DAS_USER
GA_DB2_DATABASE_NAME
GA_DB2_FIXPACK
GA_DB2_INSTANCE_HOME 1
GA_DB2_INSTANCE_NAME 1
GA_DB2_INSTANCE_USER 1
GA_DB2_PATCH_FIXPACK
GA_DB2_VERSION
GA_DOMAIN 
GA_JOB_ID
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_OPERATION_PRODUCT 
GA_PACKAGE_DIR
GA_PATCH_DIR
GA_PATCH_PACKAGE
GA_PERL
GA_RUN_STATE
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_VAR_DIR
GA_VERIFY_MODE 
GA_XML

Rollback to the Patch on DB2 Instance

GAC_{CUSTOM_FIELD}
GA_DAGENT_VERSION
GA_DB2_COPY
GA_DB2_DAS_HOME
GA_DB2_DAS_USER
GA_DB2_DATABASE_NAME
GA_DB2_FIXPACK
GA_DB2_INSTANCE_HOME 1
GA_DB2_INSTANCE_NAME 1
GA_DB2_INSTANCE_USER 1
GA_DB2_PATCH_FIXPACK
GA_DB2_VERSION
GA_DOMAIN
GA_JOB_ID
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_PACKAGE_DIR
GA_PATCH_DIR
GA_PATCH_PACKAGE
GA_PERL
GA_RUN_STATE
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_VAR_DIR
GA_VERIFY_MODE
GA_XML

1 Applies only to Pre and Post Install Start and Stop scripts.

Was this page helpful? Yes No Submitting... Thank you

Comments