DB2 environment variables

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

Create DB2 Instance
Remove DB2 Instance
Create DB2 Database
Remove DB2 Database
Apply Patch to DB2 Instance
Rollback to the Patch on DB2 Instance

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 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
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 ¹ GA_DB2_INSTANCE_NAME ¹ GA_DB2_INSTANCE_USER ¹ 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

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

DB2 environment variables

Comments