The following table lists the supported environment variables for BMC Database Automation (BDA) Actions.
In BDA 8.8, the following new scope have been added:
- DB2 Database. Actions created with a DB2 Database scope can be set as script and SQL Actions and can be executed against the targeted DB2 database.
Scope | Environment Variables |
---|
Application Scope | GAC_{CUSTOM_FIELD} GAD_{APPLICATION_PROPERTY} GA_CLARITY_USER GA_CLARITY_USERIP 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_XML |
Application Instance Scope | GAC_{CUSTOM_FIELD} GAD_{APPLICATION_PROPERTY} GA_CLARITY_USER GA_CLARITY_USERIP 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_XML |
DB2 Instance Scope | GAC_{CUSTOM_FIELD} GA_DAGENT_VERSION GA_DB2_COPY GA_DB2_DAS_HOME GA_DB2_DAS_USER GA_DB2_FIXPACK GA_DB2_INSTANCE_HOME GA_DB2_INSTANCE_NAME GA_DB2_INSTANCE_USER GA_DB2_PATCH_FIXPACK GA_DB2_VERSION GA_OPERATION GA_OPERATION_DESCRIPTION GA_PATCH_LOCATION GA_PATCH_PACKAGE GA_RUN_STATE |
DB2 Member Instance Scope | GAC_{CUSTOM_FIELD} GA_DAGENT_VERSION GA_DB2_COPY GA_DB2_DAS_HOME GA_DB2_DAS_USER GA_DB2_FIXPACK GA_DB2_INSTANCE_HOME GA_DB2_INSTANCE_NAME GA_DB2_INSTANCE_USER GA_DB2_PATCH_FIXPACK GA_DB2_VERSION GA_OPERATION GA_OPERATION_DESCRIPTION GA_PATCH_LOCATION GA_PATCH_PACKAGE GA_RUN_STATE |
DB2 Database Scope | GAC_{CUSTOM_FIELD} GA_APP_IDENTIFIER GA_CLARITY_USER GA_CLARITY_USERIP GA_COMPATIBLE_APPLICATION GA_DAGENT_VERSION GA_DB2_COPY GA_DB2_DATABASE_NAME GA_DB2_DB_ALIAS GA_DB2_DB_ALTERNATE_SERVER_HOSTNAME GA_DB2_DB_ALTERNATE_SERVER_PORT_NUMBER GA_DB2_DB_COMMENT GA_DB2_DB_PARTITION GA_DB2_DB_RELEASE_LEVEL GA_DB2_DB_TYPE GA_DB2_INSTANCE_HOME GA_DB2_INSTANCE_NAME GA_DB2_INSTANCE_USER GA_DB2_LOCAL_DB_DIR GA_DOMAIN GA_JOB_ID GA_LOG_DIR GA_MANAGER_ADDRESS GA_OPERATION GA_OPERATION_DESCRIPTION GA_OPERATION_PRODUCT GA_PERL GA_RUN_STATE GA_SCRIPT_DIR GA_SUBJOB_ID GA_VAR_DIR GA_VERIFY_MODE GA_XML |
Oracle Home Scope | GAC_{CUSTOM_FIELD} GA_CLARITY_USER GA_CLARITY_USERIP GA_DAGENT_VERSION GA_DB_SID_LIST 1 GA_DOMAIN GA_HOME_TYPE GA_INSTALL_USER GA_JOB_ID GA_LOG_DIR GA_MANAGER_ADDRESS GA_OPERATION GA_OPERATION_DESCRIPTION GA_ORACLE_HOME GA_PERL GA_RUN_STATE GA_SCRIPT_DIR GA_SUBJOB_ID GA_XML |
Node Scope | GAC_{CUSTOM_FIELD} GA_CLARITY_USER GA_CLARITY_USERIP 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_XML |
Oracle Database Instance Scope | GAC_{CUSTOM_FIELD} GA_CLARITY_USER GA_CLARITY_USERIP GA_DAGENT_VERSION GA_DB_NAME GA_DB_ORACLE_HOME GA_DB_SID GA_DOMAIN GA_INSTALL_USER 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_XML |
Oracle Database Scope | GAC_{CUSTOM_FIELD} GA_CLARITY_USER GA_CLARITY_USERIP GA_DAGENT_VERSION GA_DB_NAME GA_DB_ORACLE_HOME GA_DB_SID GA_DOMAIN GA_INSTALL_USER 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_XML |
Oracle Pluggable Database Scope | GAC_{CUSTOM_FIELD} GA_CLARITY_USER GA_CLARITY_USERIP GA_DAGENT_VERSION GA_DB_NAME GA_DB_ORACLE_HOME GA_DB_SID GA_DOMAIN GA_INSTALL_USER GA_JOB_ID GA_LOG_DIR GA_MANAGER_ADDRESS GA_OPERATION=CustomAction::Application::OraclePluggableDatabase GA_OPERATION_DESCRIPTION GA_ORACLE_BASE GA_PDB_NAME GA_PERL GA_RUN_STATE GA_SCRIPT_DIR GA_SUBJOB_ID GA_XML |
SQL Server Database Scope | GAC_{CUSTOM_FIELD} GA_CLARITY_USER GA_CLARITY_USERIP GA_DAGENT_VERSION GA_DATABASE_NAME GA_DBEDITION GA_DBMAJORVERSION GA_DBNUMERICVERSION GA_DOMAIN GA_INSTANCE_NAME 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_XML |
SQL Server Instance Scope | GAC_{CUSTOM_FIELD} GA_CLARITY_USER GA_CLARITY_USERIP GA_DAGENT_VERSION GA_DBEDITION GA_DBMAJORVERSION GA_DBNUMERICVERSION GA_DOMAIN GA_INSTANCE_CLUSTERED GA_INSTANCE_NAME 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_XML |
SQL Server Availability Group Scope | GAC_{CUSTOM_FIELD} GA_CLARITY_USER GA_CLARITY_USERIP GA_DAGENT_VERSION GA_DBEDITION GA_DBMAJORVERSION GA_DBNUMERICVERSION GA_DOMAIN GA_HADR_DATABASE_LIST GA_HADR_GROUP_NAME GA_HADR_REPLICA_CONNECT_NAME GA_HADR_REPLICA_NAME GA_HADR_REPLICA_ROLE - PRIMARY vs. SECONDARY
GA_HADR_LISTENER_DEFINED - 1 vs. 0
GA_HADR_LISTENER_NAME - only defined if group has a listener GA_HADR_LISTENER_PORT - only defined if group has a listener GA_INSTANCE_NAME - defined for compatibility with instance-scoped scripts GA_INSTANCE_CONNECT_NAME - defined for compatibility with instance-scoped scripts GA_JOB_ID GA_LOG_DIR GA_MANAGER_ADDRESS GA_NODE_STATE GA_OPERATION GA_OPERATION_DESCRIPTION GA_OPERATION_PRODUCT GA_PERL GA_RUN_STATE GA_SCRIPT_DIR GA_SUBJOB_ID GA_XML |
Sybase Dataserver Instance Scope | GAC_{CUSTOM_FIELD} GA_CLARITY_USER GA_CLARITY_USERIP GA_DAGENT_VERSION GA_DATASERVER_NAME GA_DOMAIN GA_JOB_ID GA_LOG_DIR GA_MANAGER_ADDRESS GA_MASTER_DEVICE GA_OPERATION GA_OPERATION_DESCRIPTION GA_PERL GA_RUN_STATE GA_SCRIPT_DIR GA_SUBJOB_ID GA_SYBASE_EBF GA_SYBASE_ROOT GA_SYBASE_VERSION GA_XML |
Sybase Dataserver Scope | GAC_{CUSTOM_FIELD} GA_CLARITY_USER GA_CLARITY_USERIP GA_DAGENT_VERSION GA_DATASERVER_NAME GA_DOMAIN GA_JOB_ID GA_LOG_DIR GA_MANAGER_ADDRESS GA_MASTER_DEVICE GA_OPERATION GA_OPERATION_DESCRIPTION GA_PERL GA_RUN_STATE GA_SCRIPT_DIR GA_SUBJOB_ID GA_SYBASE_EBF GA_SYBASE_ROOT GA_SYBASE_VERSION GA_XML |
Sybase Replication Server Instance Scope | GAC_{CUSTOM_FIELD} GA_CLARITY_USER GA_CLARITY_USERIP GA_DAGENT_VERSION GA_DOMAIN GA_ID_SERVER GA_IS_ID_SERVER GA_JOB_ID GA_LOG_DIR GA_MANAGER_ADDRESS GA_OPERATION GA_OPERATION_DESCRIPTION GA_PERL GA_REPSERVER_NAME GA_RUN_STATE GA_SCRIPT_DIR GA_SUBJOB_ID GA_SYBASE_EBF GA_SYBASE_ROOT GA_SYBASE_VERSION GA_XML |
Sybase Replication Server Scope | GAC_{CUSTOM_FIELD} GA_CLARITY_USER GA_CLARITY_USERIP GA_DAGENT_VERSION GA_DOMAIN GA_ID_SERVER GA_IS_ID_SERVER GA_JOB_ID GA_LOG_DIR GA_MANAGER_ADDRESS GA_OPERATION GA_OPERATION_DESCRIPTION GA_PERL GA_REPSERVER_NAME GA_RUN_STATE GA_SCRIPT_DIR GA_SUBJOB_ID GA_SYBASE_EBF GA_SYBASE_ROOT GA_SYBASE_VERSION GA_XML |
1 The GA_DB_SID_LIST variable is only set for Oracle Home Actions when the target is a Database Management System home, not a cluster or Automatic Storage Management (ASM) home.