Configure using PATROL Configuration Manager
PATROL for IBM DB2 supports creation and configuration of DB2 environment without the usage of PATROL Console or CMA. This can be performed using PCM. This section describes how to create and configure a Local, JDBC, Remote Windows, and Remote UNIX using PATROL Configuration Manager.
You can use BMC PATROL Configuration Manager to configure PATROL for IBM DB2 by using the following methods:
- PATROL Configuration Manager menu commands
- RuleSets through the CLI
The KM installation contains rule set files (.cfg) for PCM. The rule set files are located at $PATROL_HOME\..\rulesets\Shipped\pso. The rule set files contain configuration rules required to configure custom monitor and network devices.
Before you begin
Before using PATROL Configuration Manager to change the configuration of a Knowledge Module (KM), BMC recommends that you ensure that PATROL Configuration Manager is set up to save or backup the configuration.
To enable backups in PATROL Configuration Manager, perform the following steps:
- From the main menu, select File > Configure > Application.
- In the Configure: Application dialog box, select the Archives tab to open the Backup Settings.
- Ensure that the Save Backup Before Apply option is selected.
- Click OK to save the settings.
Configuring IBM DB2 environment using PCM
You can configure the IBM DB2 environment using the following template:
Click here to configure DB2 JDBC connection
The following is the template of pso_ruleSet_JDBC.cfg file, which contains configuration variables to monitor remote Windows:
PATROL_CONFIG
!------------------------------
! Global monitoring setting
!-----------------------------
"/PSO/DB2/JDBC/EnvList" = {
REPLACE = "<<Each DB2 environment name you add should be on this list using comma separator.The following characters are not valid in the environment name: $ |?\"[]+=&*();!^<>:/ >>"
},
"/PSO/DB2/JDBC/Logging" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then debug logging for all environments will be enabled. Log files will be created under the $PATROL_HOME/log directory.>>"
},
"/PSO/DB2/JDBC/ShutdownKMFilePath" = {
REPLACE = "<<optional - the km check every 30 seconds if the file registered in this pconfig variable is exists or not, if it exists then will shutdown and destroy all the environments under 'DB2' icon from console, if not exist then will discover the environments as well, the shutdown file should be located in the agent machine>>"
},
!----------------------------
! Environment Configurations
!----------------------------
"/PSO/DB2/JDBC/<<environment name>>/envName" = {
REPLACE = "<<This variable value is <<environment name>> which is a unique environment name for the IBM DB2 which describes the environment's usage>>"
},
"/PSO/DB2/JDBC/<<environment name>>/jdbcHost" = {
REPLACE = "<<JDBC host name or IP address. >>"
},
"/PSO/DB2/JDBC/<<environment name>>/jdbcPort" = {
REPLACE = "<<JDBC port number. Default 50000>>"
},
"/PSO/DB2/JDBC/<<environment name>>/jdbcDatabaseName" = {
REPLACE = "<<IBM DB2 database name. E.g.: SAMPLE >>"
},
"/PSO/DB2/JDBC/<<environment name>>/securityMechanism" = {
REPLACE = "<<optional - The securityMechanism used to connect to database, value 3 is the DEFAULT, value 13 is provided to support ENCRYPTED_USER_PASSWORD_AND_DATA_SECURITY, use this variable ONLY if you use IBM SDK 8 and above. The DEFAULT value is 3 >>"
},
"/PSO/DB2/JDBC/<<environment name>>/db2User" = {
REPLACE = "<<Connection user for IBM DB2 database>>"
},
"/SecureStore/PSO/DB2/JDBC/<<environment name>>/db2Password" = {
REPLACE = "DB2_MAIN;DB2_ENVIRONMENT;DB2_SETUPWIN;DB2_SETUPUNIX;DB2_SETUPLOCAL;DB2_SETUPJDBC/<<Connection password for IBM DB2 database>>"
},
!--------------------------
! Java collector settings
!--------------------------
"/PSO/DB2/JDBC/<<environment name>>/javaHome" = {
REPLACE = "<<The java home that will be used to run the java collector>>"
},
"/PSO/DB2/JDBC/<<environment name>>/jvmArgs" = {
REPLACE = "<<optinal- JVM args for the java collector>>"
},
"/PSO/DB2/JDBC/<<environment name>>/osJVMUser" = {
REPLACE = "<<The user that will run the java collector>>"
},
"/SecureStore/PSO/DB2/JDBC/<<environment name>>/osJVMPassword" = {
REPLACE = "DB2_MAIN;DB2_ENVIRONMENT;DB2_SETUPWIN;DB2_SETUPUNIX;DB2_SETUPLOCAL;DB2_SETUPJDBC/<<The local user's password that will be used to run the java collector>>"
},
!----------------------------
! Monitoring data details
!----------------------------
"/PSO/DB2/JDBC/<<environment name>>/healthMonitoring" = {
REPLACE = "<<Type of monitoring: availability only=1, DB2 system controlled=2, Customer collection data Selection=3>>"
},
"/PSO/DB2/JDBC/<<environment name>>/Applications" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 applications monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/JDBC/<<environment name>>/BufferPools" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 buffer pools monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/JDBC/<<environment name>>/Capacity" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 capacity monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/JDBC/<<environment name>>/HADR" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 high availability and disaster recovery monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/JDBC/<<environment name>>/InstanceParameters" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 instances monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/JDBC/<<environment name>>/InstancePartitionParameters" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 instance partitions monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/JDBC/<<environment name>>/Lock" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 locks monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/JDBC/<<environment name>>/Log" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 logs monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/JDBC/<<environment name>>/Performance" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 health monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/JDBC/<<environment name>>/Recovery" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 Recovery monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/JDBC/<<environment name>>/SQL" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 SQL monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/JDBC/<<environment name>>/TableSpaces" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 TableSpaces monitoring performance and availability will be enabled>>"
},
!----------------------------------------------
! Filters configuration by monitor types list
!----------------------------------------------
"/PSO/DB2/JDBC/<<environment name>>/filterConfigurationByAppClassesList/<<application monitor types>>/appClassId" = {
REPLACE = "<<This variable value is the selected filtering monitor type value. Application class corresponding ID list you find at file: Patrol3/pso/conf/app_classes_mapping.>>"
},
"/PSO/DB2/JDBC/<<environment name>>/filterConfigurationByAppClassesList/<<application monitor types>>/type" = {
REPLACE = "<<This variable value is the selected filtering option. Values can be : 0-None , 1-Include , 2-Exclude>>"
},
"/PSO/DB2/JDBC/<<environment name>>/filterConfigurationByAppClassesList/<<application monitor types>>/value" = {
REPLACE = "<<This variable value is the filtering instances from the selected monitor type>>"
},
!-------------------------------------------
! Custom SQL queries configuration list
!-------------------------------------------
"/PSO/DB2/JDBC/<<environment name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/EnableNumberOfRecordsAnnotation" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the query result as an annotation will be displayed>>"
},
"/PSO/DB2/JDBC/<<environment name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/SQLQuery" = {
REPLACE = "<<The custom SQL query you like to run>>"
},
"/PSO/DB2/JDBC/<<environment name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/SQLQueryCycle" = {
REPLACE = "<<Collection cycle time in minutes of the DB2 SQL query>>"
},
"/PSO/DB2/JDBC/<<environment name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/SQLQueryName" = {
REPLACE = "<<This variable displays the custom SQL query configuration list. The following characters are not allowed: $ |?\"[]+=&*();!^<>:/ >>"
},
!-----------------------------
! Administration
!-----------------------------
"/PSO/DB2/JDBC/<<environment name>>/logging" = {
REPLACE = "<<optional - setting the value of this pconfig variable to true or 1 will cause to enable debug logging for this environment. Log files will be created under the $PATROL_HOME/pso/logs and $PATROL_HOME/log directories>>"
},
"/PSO/DB2/JDBC/<<environment name>>/availabilityCollector" = {
REPLACE = "<<This variable value is the collection interval for availability attributes. Default 60 seconds>>"
},
"/PSO/DB2/JDBC/<<environment name>>/dataCollector" = {
REPLACE = "<<This variable value is the collection interval for data attributes. Default 600 seconds>>"
},
"/PSO/DB2/JDBC/<<environment name>>/LongRunningQueriesThreshold" = {
REPLACE = "<<This variable value is the threshold in seconds for the monitor data collection SQL queries that run longer than that. Default 60 seconds>>"
},
"/PSO/DB2/JDBC/<<environment name>>/BPPMI2D" = {
REPLACE = "<<optinal - if this variable is 'true' or '1' then it enables device mapping for all hosts in this environment. Monitors are created within a device according to the discovered host name of the monitored system. Disable device mapping means monitors are created within the device of the PATROL agent(s).>>"
},
!----------------------------------
! Disable monitoring configuration
!----------------------------------
"/PSO/DB2/JDBC/<<environment name>>/DisableEnvironment" = {
REPLACE = "<<optinal - if this variable is 'true' or '1' then it will disable the creation of the environment on the patrol tree view>>"
},
!---------------------------------------
! Environment edit state
!----------------------------------------
"/PSO/DB2/JDBC/<<environment name>>/isEnvEdited" = {
REPLACE = "<<If the current environment is edited from the pconfig the variable value should be changed to 1, that it applied to the changes>>"
},
!----------------------------------------------------------
! Configure i18n ,tableSpaces and ConnToDBOK configuration
! Using BMC_FORCE
!----------------------------------------------------------
"/PSO/DB2/JDBC/<<environment name>>/BMC_FORCE/i18n/lang" = {
REPLACE = "<<optional - The locale of DB2 environment it must be declared as <language>_<country> for example en_US, if user didn't insert this pconfig variable then will use the current locale of the java collector, if didn't succeed to retrieve current locale from java then will use the default locale en_US>>"
},
"/PSO/DB2/JDBC/<<environment name>>/BMC_FORCE/<<DB2 database name>>/tableSpaces/stateWarnList" = {
REPLACE = "<<optional - This is relevant to JDBC monitoring only, This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific database will be in warn state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateWarnList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/JDBC/<<environment name>>/BMC_FORCE/<<DB2 database name>>/tableSpaces/stateAlertList" = {
REPLACE = "<<optional - This is relevant to JDBC monitoring only, This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific database will be in alarm state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateAlertList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/JDBC/<<environment name>>/BMC_FORCE/<<DB2 database name>>/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - This pconfig define the SQL codes list (separated by comma) that generate warning state of parameter ConnToDBOK, Example: SQL1116N,SQL1035N,SQL1032N, so if failed to connect to database then km will check if error code is equal to any SQL code defined in this list, if yes then will set the value of the parameter to warn value.>>"
},
"/PSO/DB2/JDBC/<<environment name>>/BMC_FORCE/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/warnList but for environment level, this mean it will apply for all databases under all instances of this environment.>>"
},
"/PSO/DB2/JDBC/<<environment name>>/BMC_FORCE/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - This pconfig define the SQL codes list (separated by comma) that exclude alarm state of parameter ConnToDBOK, Example: SQL1116N,SQL1035N,SQL1032N, so if failed to connect to database then km will check if error code is equal to any SQL code defined in this list, if yes then will set the value of the parameter to value that will not generate alarm.>>"
},
"/PSO/DB2/JDBC/<<environment name>>/BMC_FORCE/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList but for environment level, this mean it will apply for all databases under all instances of this environment.>>"
},
"/PSO/DB2/JDBC/<<environment name>>/BMC_FORCE/ReconnectCycle" = {
REPLACE = "<<optional - The time in seconds need to wait before try to reconnect to the environment (in case the environment failed to connect to the main connection). The default is 300 seconds.>>"
}
!------------------------------
! Global monitoring setting
!-----------------------------
"/PSO/DB2/JDBC/EnvList" = {
REPLACE = "<<Each DB2 environment name you add should be on this list using comma separator.The following characters are not valid in the environment name: $ |?\"[]+=&*();!^<>:/ >>"
},
"/PSO/DB2/JDBC/Logging" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then debug logging for all environments will be enabled. Log files will be created under the $PATROL_HOME/log directory.>>"
},
"/PSO/DB2/JDBC/ShutdownKMFilePath" = {
REPLACE = "<<optional - the km check every 30 seconds if the file registered in this pconfig variable is exists or not, if it exists then will shutdown and destroy all the environments under 'DB2' icon from console, if not exist then will discover the environments as well, the shutdown file should be located in the agent machine>>"
},
!----------------------------
! Environment Configurations
!----------------------------
"/PSO/DB2/JDBC/<<environment name>>/envName" = {
REPLACE = "<<This variable value is <<environment name>> which is a unique environment name for the IBM DB2 which describes the environment's usage>>"
},
"/PSO/DB2/JDBC/<<environment name>>/jdbcHost" = {
REPLACE = "<<JDBC host name or IP address. >>"
},
"/PSO/DB2/JDBC/<<environment name>>/jdbcPort" = {
REPLACE = "<<JDBC port number. Default 50000>>"
},
"/PSO/DB2/JDBC/<<environment name>>/jdbcDatabaseName" = {
REPLACE = "<<IBM DB2 database name. E.g.: SAMPLE >>"
},
"/PSO/DB2/JDBC/<<environment name>>/securityMechanism" = {
REPLACE = "<<optional - The securityMechanism used to connect to database, value 3 is the DEFAULT, value 13 is provided to support ENCRYPTED_USER_PASSWORD_AND_DATA_SECURITY, use this variable ONLY if you use IBM SDK 8 and above. The DEFAULT value is 3 >>"
},
"/PSO/DB2/JDBC/<<environment name>>/db2User" = {
REPLACE = "<<Connection user for IBM DB2 database>>"
},
"/SecureStore/PSO/DB2/JDBC/<<environment name>>/db2Password" = {
REPLACE = "DB2_MAIN;DB2_ENVIRONMENT;DB2_SETUPWIN;DB2_SETUPUNIX;DB2_SETUPLOCAL;DB2_SETUPJDBC/<<Connection password for IBM DB2 database>>"
},
!--------------------------
! Java collector settings
!--------------------------
"/PSO/DB2/JDBC/<<environment name>>/javaHome" = {
REPLACE = "<<The java home that will be used to run the java collector>>"
},
"/PSO/DB2/JDBC/<<environment name>>/jvmArgs" = {
REPLACE = "<<optinal- JVM args for the java collector>>"
},
"/PSO/DB2/JDBC/<<environment name>>/osJVMUser" = {
REPLACE = "<<The user that will run the java collector>>"
},
"/SecureStore/PSO/DB2/JDBC/<<environment name>>/osJVMPassword" = {
REPLACE = "DB2_MAIN;DB2_ENVIRONMENT;DB2_SETUPWIN;DB2_SETUPUNIX;DB2_SETUPLOCAL;DB2_SETUPJDBC/<<The local user's password that will be used to run the java collector>>"
},
!----------------------------
! Monitoring data details
!----------------------------
"/PSO/DB2/JDBC/<<environment name>>/healthMonitoring" = {
REPLACE = "<<Type of monitoring: availability only=1, DB2 system controlled=2, Customer collection data Selection=3>>"
},
"/PSO/DB2/JDBC/<<environment name>>/Applications" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 applications monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/JDBC/<<environment name>>/BufferPools" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 buffer pools monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/JDBC/<<environment name>>/Capacity" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 capacity monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/JDBC/<<environment name>>/HADR" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 high availability and disaster recovery monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/JDBC/<<environment name>>/InstanceParameters" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 instances monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/JDBC/<<environment name>>/InstancePartitionParameters" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 instance partitions monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/JDBC/<<environment name>>/Lock" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 locks monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/JDBC/<<environment name>>/Log" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 logs monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/JDBC/<<environment name>>/Performance" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 health monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/JDBC/<<environment name>>/Recovery" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 Recovery monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/JDBC/<<environment name>>/SQL" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 SQL monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/JDBC/<<environment name>>/TableSpaces" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 TableSpaces monitoring performance and availability will be enabled>>"
},
!----------------------------------------------
! Filters configuration by monitor types list
!----------------------------------------------
"/PSO/DB2/JDBC/<<environment name>>/filterConfigurationByAppClassesList/<<application monitor types>>/appClassId" = {
REPLACE = "<<This variable value is the selected filtering monitor type value. Application class corresponding ID list you find at file: Patrol3/pso/conf/app_classes_mapping.>>"
},
"/PSO/DB2/JDBC/<<environment name>>/filterConfigurationByAppClassesList/<<application monitor types>>/type" = {
REPLACE = "<<This variable value is the selected filtering option. Values can be : 0-None , 1-Include , 2-Exclude>>"
},
"/PSO/DB2/JDBC/<<environment name>>/filterConfigurationByAppClassesList/<<application monitor types>>/value" = {
REPLACE = "<<This variable value is the filtering instances from the selected monitor type>>"
},
!-------------------------------------------
! Custom SQL queries configuration list
!-------------------------------------------
"/PSO/DB2/JDBC/<<environment name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/EnableNumberOfRecordsAnnotation" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the query result as an annotation will be displayed>>"
},
"/PSO/DB2/JDBC/<<environment name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/SQLQuery" = {
REPLACE = "<<The custom SQL query you like to run>>"
},
"/PSO/DB2/JDBC/<<environment name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/SQLQueryCycle" = {
REPLACE = "<<Collection cycle time in minutes of the DB2 SQL query>>"
},
"/PSO/DB2/JDBC/<<environment name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/SQLQueryName" = {
REPLACE = "<<This variable displays the custom SQL query configuration list. The following characters are not allowed: $ |?\"[]+=&*();!^<>:/ >>"
},
!-----------------------------
! Administration
!-----------------------------
"/PSO/DB2/JDBC/<<environment name>>/logging" = {
REPLACE = "<<optional - setting the value of this pconfig variable to true or 1 will cause to enable debug logging for this environment. Log files will be created under the $PATROL_HOME/pso/logs and $PATROL_HOME/log directories>>"
},
"/PSO/DB2/JDBC/<<environment name>>/availabilityCollector" = {
REPLACE = "<<This variable value is the collection interval for availability attributes. Default 60 seconds>>"
},
"/PSO/DB2/JDBC/<<environment name>>/dataCollector" = {
REPLACE = "<<This variable value is the collection interval for data attributes. Default 600 seconds>>"
},
"/PSO/DB2/JDBC/<<environment name>>/LongRunningQueriesThreshold" = {
REPLACE = "<<This variable value is the threshold in seconds for the monitor data collection SQL queries that run longer than that. Default 60 seconds>>"
},
"/PSO/DB2/JDBC/<<environment name>>/BPPMI2D" = {
REPLACE = "<<optinal - if this variable is 'true' or '1' then it enables device mapping for all hosts in this environment. Monitors are created within a device according to the discovered host name of the monitored system. Disable device mapping means monitors are created within the device of the PATROL agent(s).>>"
},
!----------------------------------
! Disable monitoring configuration
!----------------------------------
"/PSO/DB2/JDBC/<<environment name>>/DisableEnvironment" = {
REPLACE = "<<optinal - if this variable is 'true' or '1' then it will disable the creation of the environment on the patrol tree view>>"
},
!---------------------------------------
! Environment edit state
!----------------------------------------
"/PSO/DB2/JDBC/<<environment name>>/isEnvEdited" = {
REPLACE = "<<If the current environment is edited from the pconfig the variable value should be changed to 1, that it applied to the changes>>"
},
!----------------------------------------------------------
! Configure i18n ,tableSpaces and ConnToDBOK configuration
! Using BMC_FORCE
!----------------------------------------------------------
"/PSO/DB2/JDBC/<<environment name>>/BMC_FORCE/i18n/lang" = {
REPLACE = "<<optional - The locale of DB2 environment it must be declared as <language>_<country> for example en_US, if user didn't insert this pconfig variable then will use the current locale of the java collector, if didn't succeed to retrieve current locale from java then will use the default locale en_US>>"
},
"/PSO/DB2/JDBC/<<environment name>>/BMC_FORCE/<<DB2 database name>>/tableSpaces/stateWarnList" = {
REPLACE = "<<optional - This is relevant to JDBC monitoring only, This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific database will be in warn state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateWarnList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/JDBC/<<environment name>>/BMC_FORCE/<<DB2 database name>>/tableSpaces/stateAlertList" = {
REPLACE = "<<optional - This is relevant to JDBC monitoring only, This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific database will be in alarm state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateAlertList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/JDBC/<<environment name>>/BMC_FORCE/<<DB2 database name>>/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - This pconfig define the SQL codes list (separated by comma) that generate warning state of parameter ConnToDBOK, Example: SQL1116N,SQL1035N,SQL1032N, so if failed to connect to database then km will check if error code is equal to any SQL code defined in this list, if yes then will set the value of the parameter to warn value.>>"
},
"/PSO/DB2/JDBC/<<environment name>>/BMC_FORCE/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/warnList but for environment level, this mean it will apply for all databases under all instances of this environment.>>"
},
"/PSO/DB2/JDBC/<<environment name>>/BMC_FORCE/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - This pconfig define the SQL codes list (separated by comma) that exclude alarm state of parameter ConnToDBOK, Example: SQL1116N,SQL1035N,SQL1032N, so if failed to connect to database then km will check if error code is equal to any SQL code defined in this list, if yes then will set the value of the parameter to value that will not generate alarm.>>"
},
"/PSO/DB2/JDBC/<<environment name>>/BMC_FORCE/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList but for environment level, this mean it will apply for all databases under all instances of this environment.>>"
},
"/PSO/DB2/JDBC/<<environment name>>/BMC_FORCE/ReconnectCycle" = {
REPLACE = "<<optional - The time in seconds need to wait before try to reconnect to the environment (in case the environment failed to connect to the main connection). The default is 300 seconds.>>"
}
Click here to configure DB2 Local connection
The following is the template of pso_ruleSet_Local.cfg file, which contains configuration variables to monitor remote Windows:
PATROL_CONFIG
!------------------------------
! Global monitoring setting
!-----------------------------
"/PSO/DB2/Local/EnvList" = {
REPLACE = "<<Each DB2 environment name you add should be on this list using comma separator.The following characters are not valid in the environment name: $ |?\"[]+=&*();!^<>:/ >>"
},
"/PSO/DB2/Local/Logging" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then debug logging for all environments will be enabled. Log files will be created under the $PATROL_HOME/log directory.>>"
},
"/PSO/DB2/Local/ShutdownKMFilePath" = {
REPLACE = "<<optional - the km check every 30 seconds if the file registered in this pconfig variable is exists or not, if it exists then will shutdown and destroy all the environments under 'DB2' icon from console, if not exist then will discover the environments as well, the shutdown file should be located in the agent machine>>"
},
!----------------------------
! Environment Configurations
!----------------------------
"/PSO/DB2/Local/<<environment name>>/envName" = {
REPLACE = "<<This variable value is <<environment name>> which is a unique environment name for the IBM DB2 which describes the environment's usage>>"
},
!------------------------
! Local IBM DB2 Details
!------------------------
"/PSO/DB2/Local/<<environment name>>/db2InstallationHome" = {
REPLACE = "<<optional - The db2 installation home that need to monitor, you can provide full db2 path, DB2PATH environment variable, or leave empty, in case you provided DB2PATH and it not defined as env variable in your db2 system or left it empty, then the km will try to monitor a default db2 installation home if it exist in the xml file Patrol3/pso/conf/xml/defaultDB2InstallationHomeList.xml and in your db2 system. Environment variable name must start with DB2PATH. Example: DB2PATH, DB2PATH2 >>"
},
"/PSO/DB2/Local/<<environment name>>/db2InstancesMonitoringList" = {
REPLACE = "<<optional - The db2 instances list that need to monitor, the list should be separated by ',' separator and it's not support regex. when leave this field empty then the km will monitor all the db2 instances in the environment. >>"
},
"/PSO/DB2/Local/<<environment name>>/securityMechanism" = {
REPLACE = "<<optional - The securityMechanism used to connect to database, value 3 is the DEFAULT, value 13 is provided to support ENCRYPTED_USER_PASSWORD_AND_DATA_SECURITY, use this variable ONLY if you use IBM SDK 8 and above>>"
},
"/PSO/DB2/Local/<<environment name>>/db2User" = {
REPLACE = "<<The user that will be used to monitor the databases using the jdbc connection, it is the user that will run the DB2 CLP commands also.>>"
},
"/SecureStore/PSO/DB2/Local/<<environment name>>/db2Password" = {
REPLACE = "DB2_MAIN;DB2_ENVIRONMENT;DB2_SETUPWIN;DB2_SETUPUNIX;DB2_SETUPLOCAL;DB2_SETUPJDBC/<<The db2 user's password that will be used to monitor the db2 instances>>"
},
!--------------------------
! Java collector settings
!--------------------------
"/PSO/DB2/Local/<<environment name>>/javaHome" = {
REPLACE = "<<The java home that will be used to run the java collector>>"
},
"/PSO/DB2/Local/<<environment name>>/jvmArgs" = {
REPLACE = "<<optinal- JVM args for the java collector>>"
},
"/PSO/DB2/Local/<<environment name>>/osJVMUser" = {
REPLACE = "<<The user that will run the java collector.To start the KM backend Java collector by using the PATROL user, specify $PATROL_USER. >>"
},
"/SecureStore/PSO/DB2/Local/<<environment name>>/osJVMPassword" = {
REPLACE = "DB2_MAIN;DB2_ENVIRONMENT;DB2_SETUPWIN;DB2_SETUPUNIX;DB2_SETUPLOCAL;DB2_SETUPJDBC/<<The local user's password that will be used to run the java collector>>"
},
!----------------------------
! Monitoring data details
!----------------------------
"/PSO/DB2/Local/<<environment name>>/healthMonitoring" = {
REPLACE = "<<Type of monitoring: availability only=1, DB2 system controlled=2, Customer collection data Selection=3>>"
},
"/PSO/DB2/Local/<<environment name>>/Applications" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 applications monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/Local/<<environment name>>/BufferPools" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 buffer pools monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/Local/<<environment name>>/Capacity" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 capacity monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/Local/<<environment name>>/HADR" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 high availability and disaster recovery monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/Local/<<environment name>>/InstanceParameters" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 instances monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/Local/<<environment name>>/InstancePartitionParameters" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 instance partitions monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/Local/<<environment name>>/Lock" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 locks monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/Local/<<environment name>>/Log" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 logs monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/Local/<<environment name>>/Performance" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 health monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/Local/<<environment name>>/Recovery" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 Recovery monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/Local/<<environment name>>/SQL" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 SQL monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/Local/<<environment name>>/TableSpaces" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 TableSpaces monitoring performance and availability will be enabled>>"
},
!----------------------------------------------
! Filters configuration by monitor types list
!----------------------------------------------
"/PSO/DB2/Local/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/DB2DatabaseName" = {
REPLACE = "<<This variable value is the IBM DB2 database name to which the filtering will be applied>>"
},
"/PSO/DB2/Local/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/DB2InstanceName" = {
REPLACE = "<<This variable value is the IBM DB2 instance name to which the filtering will be applied>>"
},
"/PSO/DB2/Local/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/appClassesFilterList/<<application monitor types>>/appClassId" = {
REPLACE = "<<This variable value is the selected filtering monitor type value. Application class corresponding ID list you find at file: Patrol3/pso/conf/app_classes_mapping>>"
},
"/PSO/DB2/Local/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/appClassesFilterList/<<application monitor types>>/type" = {
REPLACE = "<<This variable value is the selected filtering option. Values can be : 0-None , 1-Include , 2-Exclude>>"
},
"/PSO/DB2/Local/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/appClassesFilterList/<<application monitor types>>/value" = {
REPLACE = "<<This variable value is the filtering instances from the selected monitor type>>"
},
!-------------------------------------------
! Custom SQL queries configuration list
!-------------------------------------------
"/PSO/DB2/Local/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustDB2DatabaseName" = {
REPLACE = "<<The database name of the DB2 server you would like to do custom SQL query>>"
},
"/PSO/DB2/Local/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustDB2InstanceName" = {
REPLACE = "<<The instance name of the DB2 server you would like to do custom SQL query>>"
},
"/PSO/DB2/Local/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/EnableNumberOfRecordsAnnotation" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the query result as an annotation will be displayed>>"
},
"/PSO/DB2/Local/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/SQLQuery" = {
REPLACE = "<<The custom SQL query you like to run>>"
},
"/PSO/DB2/Local/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/SQLQueryCycle" = {
REPLACE = "<<Collection cycle time in minutes of the DB2 SQL query>>"
},
"/PSO/DB2/Local/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/SQLQueryName" = {
REPLACE = "<<This variable displays the custom SQL query configuration list. The following characters are not allowed: $ |?\"[]+=&*();!^<>:/ >>"
},
!--------------------------------------------
! IBM db2diag log search configuration list
!--------------------------------------------
"/PSO/DB2/Local/<<environment name>>/DB2DiagLogSearchConfigList/<<iterator on specific DB2 instance>>/DB2DiagLogSearchList/<<iterator on db2diaglog search command>>/DiagLogSearchCommand" = {
REPLACE = "<<This variable value is the IBM db2diag tool search command>>"
},
"/PSO/DB2/Local/<<environment name>>/DB2DiagLogSearchConfigList/<<iterator on specific DB2 instance>>/DB2DiagLogSearchList/<<iterator on db2diaglog search command>>/DiagLogState" = {
REPLACE = "<<This variable value is the selected state which is set to the DiagLogOkAttribute. Values: 2-PRUNE, 3-INFORMATION, WARN-4, ALARM-5>>"
},
"/PSO/DB2/Local/<<environment name>>/DB2DiagLogSearchConfigList/<<iterator on specific DB2 instance>>/DiagLogDB2InstanceName" = {
REPLACE = "<<This variable value is the DB2 instance name to which the IBM db2diag log search configuration will be applied>>"
},
!-----------------------------
! Administration
!-----------------------------
"/PSO/DB2/Local/<<environment name>>/logging" = {
REPLACE = "<<optional - setting the value of this pconfig variable to true or 1 will cause to enable debug logging for this environment.Log files will be created under the $PATROL_HOME/pso/logs and $PATROL_HOME/log directories>>"
},
"/PSO/DB2/Local/<<environment name>>/availabilityCollector" = {
REPLACE = "<<This variable value is the collection interval for availability attributes. Default 60 seconds>>"
},
"/PSO/DB2/Local/<<environment name>>/dataCollector" = {
REPLACE = "<<This variable value is the collection interval for data attributes. Default 600 seconds>>"
},
"/PSO/DB2/Local/<<environment name>>/diagLogCollector" = {
REPLACE = "<<This variable value is the collection interval for IBM db2diag log attributes. Default 900 seconds>>"
},
"/PSO/DB2/Local/<<environment name>>/LongRunningQueriesThreshold" = {
REPLACE = "<<This variable value is the threshold in seconds for the monitor data collection SQL queries that run longer than that. Default 60 seconds>>"
},
"/PSO/DB2/Local/<<environment name>>/LongRunningCommandsThreshold" = {
REPLACE = "<<This variable value is the threshold in seconds for the monitor data collection CLP or OS commands that run longer than that. Default 60 seconds>>"
},
"/PSO/DB2/Local/<<environment name>>/BPPMI2D" = {
REPLACE = "<<optinal - if this variable is 'true' or '1' then it enables device mapping for all hosts in this environment. Monitors are created within a device according to the discovered host name of the monitored system. Disable device mapping means monitors are created within the device of the PATROL agent(s).>>"
},
"/PSO/DB2/Local/<<environment name>>/disableRemoteDBMonitoring" = {
REPLACE = "<<optional - setting the value of this pconfig variable to true or 1 will cause to NOT discover 'Remote' databases, deleting this pconfig variable or set its value to 0 or false will cause to discover the 'Remote' databases>>"
},
!----------------------------------
! Disable monitoring configuration
!----------------------------------
"/PSO/DB2/Local/<<environment name>>/DisableEnvironment" = {
REPLACE = "<<optinal - if this variable is 'true' or '1' then it will disable the creation of the environment on the patrol tree view>>"
},
"/PSO/DB2/Local/<<environment name>>/DB2InstanceConfigurationList/<<instance name>>/ShutdownDB2InstanceName" = {
REPLACE = "<<the specific DB2 instance name that you want to be destroyed if you provide a specific file path which should be located in the DB2 machine>>"
},
"/PSO/DB2/Local/<<environment name>>/DB2InstanceConfigurationList/<<instance name>>/ShutdownInstanceFilePath" = {
REPLACE = "<<optional - the km check every 1 min if the file registered in this pconfig variable for the specific instance is exists or not, if it exists then will destroy the db2 instance, if not exist then will discover the db2 instance as well, the shutdown file should be located in the DB2 machine>>"
},
!---------------------------------------
! Environment edit state
!----------------------------------------
"/PSO/DB2/Local/<<environment name>>/isEnvEdited" = {
REPLACE = "<<If the current environment is edited from the pconfig the variable value should be changed to 1, that it applied to the changes>>"
},
!-------------------------------------------------------------------------------
! Configure security mecahnism,i18n ,tableSpaces and ConnToDBOK configuration
! Using BMC_FORCE
!-------------------------------------------------------------------------------
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/securityMechanism" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/securityMechanism but for a specific instance.>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/i18n/lang" = {
REPLACE = "<<optional - The locale of DB2 environment it must be declared as <language>_<country> for example en_US, if user didn't insert this pconfig variable then will use the current locale of the java collector, if didn't succeed to retrieve current locale from java then will use the default locale en_US>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/tableSpaces/stateWarnList" = {
REPLACE = "<<optional - This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific instance will be in warn state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateWarnList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/tableSpaces/stateAlertList" = {
REPLACE = "<<optional - This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific instance will be in alarm state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateAlertList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/<<DB2 database name>>/tableSpaces/stateWarnList" = {
REPLACE = "<<optional - This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific instance and the specific database will be in warn state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateWarnList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/<<DB2 database name>>/tableSpaces/stateAlertList" = {
REPLACE = "<<optional - This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific instance and the specific database will be in alarm state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateAlertList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/<<DB2 database name>>/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - This pconfig define the SQL codes list (separated by comma) that generate warning state of parameter ConnToDBOK, Example: SQL1116N,SQL1035N,SQL1032N, so if failed to connect to database then km will check if error code is equal to any SQL code defined in this list, if yes then will set the value of the parameter to warn value.>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/<<DB2 database name>>/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/warnList but for a specific instance and database.>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/warnList but for a specific instance level, this mean it will apply for all databases under this instance.>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/warnList but for environment level, this mean it will apply for all databases under all instances of this environment.>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - This pconfig define the SQL codes list (separated by comma) that exclude alarm state of parameter ConnToDBOK, Example: SQL1116N,SQL1035N,SQL1032N, so if failed to connect to database then km will check if error code is equal to any SQL code defined in this list, if yes then will set the value of the parameter to value that will not generate alarm.>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList but for a specific instance and database.>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList but for a specific instance level, this mean it will apply for all databases under this instance.>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList but for environment level, this mean it will apply for all databases under all instances of this environment.>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/ReconnectCycle" = {
REPLACE = "<<optional - The time in seconds need to wait before try to reconnect to the environment (in case the environment failed to connect to the main connection). The default is 300 seconds.>>"
}
!------------------------------
! Global monitoring setting
!-----------------------------
"/PSO/DB2/Local/EnvList" = {
REPLACE = "<<Each DB2 environment name you add should be on this list using comma separator.The following characters are not valid in the environment name: $ |?\"[]+=&*();!^<>:/ >>"
},
"/PSO/DB2/Local/Logging" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then debug logging for all environments will be enabled. Log files will be created under the $PATROL_HOME/log directory.>>"
},
"/PSO/DB2/Local/ShutdownKMFilePath" = {
REPLACE = "<<optional - the km check every 30 seconds if the file registered in this pconfig variable is exists or not, if it exists then will shutdown and destroy all the environments under 'DB2' icon from console, if not exist then will discover the environments as well, the shutdown file should be located in the agent machine>>"
},
!----------------------------
! Environment Configurations
!----------------------------
"/PSO/DB2/Local/<<environment name>>/envName" = {
REPLACE = "<<This variable value is <<environment name>> which is a unique environment name for the IBM DB2 which describes the environment's usage>>"
},
!------------------------
! Local IBM DB2 Details
!------------------------
"/PSO/DB2/Local/<<environment name>>/db2InstallationHome" = {
REPLACE = "<<optional - The db2 installation home that need to monitor, you can provide full db2 path, DB2PATH environment variable, or leave empty, in case you provided DB2PATH and it not defined as env variable in your db2 system or left it empty, then the km will try to monitor a default db2 installation home if it exist in the xml file Patrol3/pso/conf/xml/defaultDB2InstallationHomeList.xml and in your db2 system. Environment variable name must start with DB2PATH. Example: DB2PATH, DB2PATH2 >>"
},
"/PSO/DB2/Local/<<environment name>>/db2InstancesMonitoringList" = {
REPLACE = "<<optional - The db2 instances list that need to monitor, the list should be separated by ',' separator and it's not support regex. when leave this field empty then the km will monitor all the db2 instances in the environment. >>"
},
"/PSO/DB2/Local/<<environment name>>/securityMechanism" = {
REPLACE = "<<optional - The securityMechanism used to connect to database, value 3 is the DEFAULT, value 13 is provided to support ENCRYPTED_USER_PASSWORD_AND_DATA_SECURITY, use this variable ONLY if you use IBM SDK 8 and above>>"
},
"/PSO/DB2/Local/<<environment name>>/db2User" = {
REPLACE = "<<The user that will be used to monitor the databases using the jdbc connection, it is the user that will run the DB2 CLP commands also.>>"
},
"/SecureStore/PSO/DB2/Local/<<environment name>>/db2Password" = {
REPLACE = "DB2_MAIN;DB2_ENVIRONMENT;DB2_SETUPWIN;DB2_SETUPUNIX;DB2_SETUPLOCAL;DB2_SETUPJDBC/<<The db2 user's password that will be used to monitor the db2 instances>>"
},
!--------------------------
! Java collector settings
!--------------------------
"/PSO/DB2/Local/<<environment name>>/javaHome" = {
REPLACE = "<<The java home that will be used to run the java collector>>"
},
"/PSO/DB2/Local/<<environment name>>/jvmArgs" = {
REPLACE = "<<optinal- JVM args for the java collector>>"
},
"/PSO/DB2/Local/<<environment name>>/osJVMUser" = {
REPLACE = "<<The user that will run the java collector.To start the KM backend Java collector by using the PATROL user, specify $PATROL_USER. >>"
},
"/SecureStore/PSO/DB2/Local/<<environment name>>/osJVMPassword" = {
REPLACE = "DB2_MAIN;DB2_ENVIRONMENT;DB2_SETUPWIN;DB2_SETUPUNIX;DB2_SETUPLOCAL;DB2_SETUPJDBC/<<The local user's password that will be used to run the java collector>>"
},
!----------------------------
! Monitoring data details
!----------------------------
"/PSO/DB2/Local/<<environment name>>/healthMonitoring" = {
REPLACE = "<<Type of monitoring: availability only=1, DB2 system controlled=2, Customer collection data Selection=3>>"
},
"/PSO/DB2/Local/<<environment name>>/Applications" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 applications monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/Local/<<environment name>>/BufferPools" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 buffer pools monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/Local/<<environment name>>/Capacity" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 capacity monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/Local/<<environment name>>/HADR" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 high availability and disaster recovery monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/Local/<<environment name>>/InstanceParameters" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 instances monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/Local/<<environment name>>/InstancePartitionParameters" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 instance partitions monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/Local/<<environment name>>/Lock" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 locks monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/Local/<<environment name>>/Log" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 logs monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/Local/<<environment name>>/Performance" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 health monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/Local/<<environment name>>/Recovery" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 Recovery monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/Local/<<environment name>>/SQL" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 SQL monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/Local/<<environment name>>/TableSpaces" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 TableSpaces monitoring performance and availability will be enabled>>"
},
!----------------------------------------------
! Filters configuration by monitor types list
!----------------------------------------------
"/PSO/DB2/Local/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/DB2DatabaseName" = {
REPLACE = "<<This variable value is the IBM DB2 database name to which the filtering will be applied>>"
},
"/PSO/DB2/Local/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/DB2InstanceName" = {
REPLACE = "<<This variable value is the IBM DB2 instance name to which the filtering will be applied>>"
},
"/PSO/DB2/Local/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/appClassesFilterList/<<application monitor types>>/appClassId" = {
REPLACE = "<<This variable value is the selected filtering monitor type value. Application class corresponding ID list you find at file: Patrol3/pso/conf/app_classes_mapping>>"
},
"/PSO/DB2/Local/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/appClassesFilterList/<<application monitor types>>/type" = {
REPLACE = "<<This variable value is the selected filtering option. Values can be : 0-None , 1-Include , 2-Exclude>>"
},
"/PSO/DB2/Local/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/appClassesFilterList/<<application monitor types>>/value" = {
REPLACE = "<<This variable value is the filtering instances from the selected monitor type>>"
},
!-------------------------------------------
! Custom SQL queries configuration list
!-------------------------------------------
"/PSO/DB2/Local/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustDB2DatabaseName" = {
REPLACE = "<<The database name of the DB2 server you would like to do custom SQL query>>"
},
"/PSO/DB2/Local/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustDB2InstanceName" = {
REPLACE = "<<The instance name of the DB2 server you would like to do custom SQL query>>"
},
"/PSO/DB2/Local/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/EnableNumberOfRecordsAnnotation" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the query result as an annotation will be displayed>>"
},
"/PSO/DB2/Local/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/SQLQuery" = {
REPLACE = "<<The custom SQL query you like to run>>"
},
"/PSO/DB2/Local/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/SQLQueryCycle" = {
REPLACE = "<<Collection cycle time in minutes of the DB2 SQL query>>"
},
"/PSO/DB2/Local/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/SQLQueryName" = {
REPLACE = "<<This variable displays the custom SQL query configuration list. The following characters are not allowed: $ |?\"[]+=&*();!^<>:/ >>"
},
!--------------------------------------------
! IBM db2diag log search configuration list
!--------------------------------------------
"/PSO/DB2/Local/<<environment name>>/DB2DiagLogSearchConfigList/<<iterator on specific DB2 instance>>/DB2DiagLogSearchList/<<iterator on db2diaglog search command>>/DiagLogSearchCommand" = {
REPLACE = "<<This variable value is the IBM db2diag tool search command>>"
},
"/PSO/DB2/Local/<<environment name>>/DB2DiagLogSearchConfigList/<<iterator on specific DB2 instance>>/DB2DiagLogSearchList/<<iterator on db2diaglog search command>>/DiagLogState" = {
REPLACE = "<<This variable value is the selected state which is set to the DiagLogOkAttribute. Values: 2-PRUNE, 3-INFORMATION, WARN-4, ALARM-5>>"
},
"/PSO/DB2/Local/<<environment name>>/DB2DiagLogSearchConfigList/<<iterator on specific DB2 instance>>/DiagLogDB2InstanceName" = {
REPLACE = "<<This variable value is the DB2 instance name to which the IBM db2diag log search configuration will be applied>>"
},
!-----------------------------
! Administration
!-----------------------------
"/PSO/DB2/Local/<<environment name>>/logging" = {
REPLACE = "<<optional - setting the value of this pconfig variable to true or 1 will cause to enable debug logging for this environment.Log files will be created under the $PATROL_HOME/pso/logs and $PATROL_HOME/log directories>>"
},
"/PSO/DB2/Local/<<environment name>>/availabilityCollector" = {
REPLACE = "<<This variable value is the collection interval for availability attributes. Default 60 seconds>>"
},
"/PSO/DB2/Local/<<environment name>>/dataCollector" = {
REPLACE = "<<This variable value is the collection interval for data attributes. Default 600 seconds>>"
},
"/PSO/DB2/Local/<<environment name>>/diagLogCollector" = {
REPLACE = "<<This variable value is the collection interval for IBM db2diag log attributes. Default 900 seconds>>"
},
"/PSO/DB2/Local/<<environment name>>/LongRunningQueriesThreshold" = {
REPLACE = "<<This variable value is the threshold in seconds for the monitor data collection SQL queries that run longer than that. Default 60 seconds>>"
},
"/PSO/DB2/Local/<<environment name>>/LongRunningCommandsThreshold" = {
REPLACE = "<<This variable value is the threshold in seconds for the monitor data collection CLP or OS commands that run longer than that. Default 60 seconds>>"
},
"/PSO/DB2/Local/<<environment name>>/BPPMI2D" = {
REPLACE = "<<optinal - if this variable is 'true' or '1' then it enables device mapping for all hosts in this environment. Monitors are created within a device according to the discovered host name of the monitored system. Disable device mapping means monitors are created within the device of the PATROL agent(s).>>"
},
"/PSO/DB2/Local/<<environment name>>/disableRemoteDBMonitoring" = {
REPLACE = "<<optional - setting the value of this pconfig variable to true or 1 will cause to NOT discover 'Remote' databases, deleting this pconfig variable or set its value to 0 or false will cause to discover the 'Remote' databases>>"
},
!----------------------------------
! Disable monitoring configuration
!----------------------------------
"/PSO/DB2/Local/<<environment name>>/DisableEnvironment" = {
REPLACE = "<<optinal - if this variable is 'true' or '1' then it will disable the creation of the environment on the patrol tree view>>"
},
"/PSO/DB2/Local/<<environment name>>/DB2InstanceConfigurationList/<<instance name>>/ShutdownDB2InstanceName" = {
REPLACE = "<<the specific DB2 instance name that you want to be destroyed if you provide a specific file path which should be located in the DB2 machine>>"
},
"/PSO/DB2/Local/<<environment name>>/DB2InstanceConfigurationList/<<instance name>>/ShutdownInstanceFilePath" = {
REPLACE = "<<optional - the km check every 1 min if the file registered in this pconfig variable for the specific instance is exists or not, if it exists then will destroy the db2 instance, if not exist then will discover the db2 instance as well, the shutdown file should be located in the DB2 machine>>"
},
!---------------------------------------
! Environment edit state
!----------------------------------------
"/PSO/DB2/Local/<<environment name>>/isEnvEdited" = {
REPLACE = "<<If the current environment is edited from the pconfig the variable value should be changed to 1, that it applied to the changes>>"
},
!-------------------------------------------------------------------------------
! Configure security mecahnism,i18n ,tableSpaces and ConnToDBOK configuration
! Using BMC_FORCE
!-------------------------------------------------------------------------------
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/securityMechanism" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/securityMechanism but for a specific instance.>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/i18n/lang" = {
REPLACE = "<<optional - The locale of DB2 environment it must be declared as <language>_<country> for example en_US, if user didn't insert this pconfig variable then will use the current locale of the java collector, if didn't succeed to retrieve current locale from java then will use the default locale en_US>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/tableSpaces/stateWarnList" = {
REPLACE = "<<optional - This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific instance will be in warn state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateWarnList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/tableSpaces/stateAlertList" = {
REPLACE = "<<optional - This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific instance will be in alarm state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateAlertList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/<<DB2 database name>>/tableSpaces/stateWarnList" = {
REPLACE = "<<optional - This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific instance and the specific database will be in warn state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateWarnList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/<<DB2 database name>>/tableSpaces/stateAlertList" = {
REPLACE = "<<optional - This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific instance and the specific database will be in alarm state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateAlertList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/<<DB2 database name>>/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - This pconfig define the SQL codes list (separated by comma) that generate warning state of parameter ConnToDBOK, Example: SQL1116N,SQL1035N,SQL1032N, so if failed to connect to database then km will check if error code is equal to any SQL code defined in this list, if yes then will set the value of the parameter to warn value.>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/<<DB2 database name>>/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/warnList but for a specific instance and database.>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/warnList but for a specific instance level, this mean it will apply for all databases under this instance.>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/warnList but for environment level, this mean it will apply for all databases under all instances of this environment.>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - This pconfig define the SQL codes list (separated by comma) that exclude alarm state of parameter ConnToDBOK, Example: SQL1116N,SQL1035N,SQL1032N, so if failed to connect to database then km will check if error code is equal to any SQL code defined in this list, if yes then will set the value of the parameter to value that will not generate alarm.>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList but for a specific instance and database.>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList but for a specific instance level, this mean it will apply for all databases under this instance.>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList but for environment level, this mean it will apply for all databases under all instances of this environment.>>"
},
"/PSO/DB2/Local/<<environment name>>/BMC_FORCE/ReconnectCycle" = {
REPLACE = "<<optional - The time in seconds need to wait before try to reconnect to the environment (in case the environment failed to connect to the main connection). The default is 300 seconds.>>"
}
Click here to configure DB2 Remote Windows connection
The following is the template of pso_ruleSet_RemoteWin.cfg file, which contains configuration variables to monitor remote Windows:
PATROL_CONFIG
!------------------------------
! Global monitoring setting
!-----------------------------
"/PSO/DB2/RemoteWin/EnvList" = {
REPLACE = "<<Each DB2 environment name you add should be on this list using comma separator.The following characters are not valid in the environment name: $ |?\"[]+=&*();!^<>:/ >>"
},
"/PSO/DB2/RemoteWin/Logging" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then debug logging for all environments will be enabled. Log files will be created under the $PATROL_HOME/log directory.>>"
},
"/PSO/DB2/RemoteWin/ShutdownKMFilePath" = {
REPLACE = "<<optional - the km check every 30 seconds if the file registered in this pconfig variable is exists or not, if it exists then will shutdown and destroy all the environments under 'DB2' icon from console, if not exist then will discover the environments as well, the shutdown file should be located in the agent machine>>"
},
!----------------------------
! Environment Configurations
!----------------------------
"/PSO/DB2/RemoteWin/<<environment name>>/envName" = {
REPLACE = "<<This variable value is <<environment name>> which is a unique environment name for the IBM DB2 which describes the environment's usage>>"
},
! Remote PowerShell details
"/PSO/DB2/RemoteWin/<<environment name>>/remoteHost" = {
REPLACE = "<<The remote host name where the monitored DB2 environment exist, this field should be used only in remote unix/window monitoring. >>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/remoteHostPort" = {
REPLACE = "<<The remote host port where the monitored DB2 environment exist, this field should be used only in remote unix/window monitoring, for example in windows env defaultF PowerShell port number 5985>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/remoteHostAuthentication" = {
REPLACE = "<<The remote host authentication for power shell windows connection, the value of this should be one of the values in the list: [Negotiate=1,Basic=2,Kerberos=3] >>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/remoteHostIsHttps" = {
REPLACE = "<<The remote host IsHttps for power shell windows connection, the value of this should be one of the values in the list: [FALSE=1, TRUE=2] >>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/remoteHostUser" = {
REPLACE = "<<The user that will be used to connect to the remote host>>"
},
"/SecureStore/PSO/DB2/RemoteWin/<<environment name>>/remoteHostPassword" = {
REPLACE = "DB2_MAIN;DB2_ENVIRONMENT;DB2_SETUPWIN;DB2_SETUPUNIX;DB2_SETUPLOCAL;DB2_SETUPJDBC/<<The remote host user's password that will be used to connect to remote host>>"
},
!------------------------
! Remote IBM DB2 Details
!------------------------
"/PSO/DB2/RemoteWin/<<environment name>>/db2InstallationHome" = {
REPLACE = "<<optional - The db2 installation home that need to monitor, you can provide full DB2 path, DB2PATH environment variable, or leave empty, in case you provided DB2PATH and it not defined as env variable in your DB2 system or left it empty, then the km will try to monitor a default DB2 installation home if it exist in the xml file Patrol3/pso/conf/xml/defaultDB2InstallationHomeList.xml and in your DB2 system. Environment variable name must start with DB2PATH. Example: DB2PATH, DB2PATH2 >>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/db2InstancesMonitoringList" = {
REPLACE = "<<optional - The db2 instances list that need to monitor, the list should be separated by ',' separator and it's not support regex. when leave this field empty then the km will monitor all the db2 instances in the environment. >>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/securityMechanism" = {
REPLACE = "<<optional - The securityMechanism used to connect to database, value 3 is the DEFAULT, value 13 is provided to support ENCRYPTED_USER_PASSWORD_AND_DATA_SECURITY, use this variable ONLY if you use IBM SDK 8 and above>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/db2User" = {
REPLACE = "<<optional - The user that will be used to monitor the databases using the jdbc connection, if you leave this variable empty in remote monitoring then the km will use the provided remoteHostUser>>"
},
"/SecureStore/PSO/DB2/RemoteWin/<<environment name>>/db2Password" = {
REPLACE = "DB2_MAIN;DB2_ENVIRONMENT;DB2_SETUPWIN;DB2_SETUPUNIX;DB2_SETUPLOCAL;DB2_SETUPJDBC/<<The db2 user's password that will be used to monitor the db2 instances>>"
},
!--------------------------
! Java collector settings
!--------------------------
"/PSO/DB2/RemoteWin/<<environment name>>/javaHome" = {
REPLACE = "<<The java home that will be used to run the java collector>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/jvmArgs" = {
REPLACE = "<<optinal- JVM args for the java collector>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/osJVMUser" = {
REPLACE = "<<The user that will run the java collector>>"
},
"/SecureStore/PSO/DB2/RemoteWin/<<environment name>>/osJVMPassword" = {
REPLACE = "DB2_MAIN;DB2_ENVIRONMENT;DB2_SETUPWIN;DB2_SETUPUNIX;DB2_SETUPLOCAL;DB2_SETUPJDBC/<<The local user's password that will be used to run the java collector>>"
},
!----------------------------
! Monitoring data details
!----------------------------
"/PSO/DB2/RemoteWin/<<environment name>>/healthMonitoring" = {
REPLACE = "<<Type of monitoring: availability only=1, DB2 system controlled=2, Customer collection data Selection=3>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/Applications" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 applications monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BufferPools" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 buffer pools monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/Capacity" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 capacity monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/HADR" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 high availability and disaster recovery monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/InstanceParameters" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 instances monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/InstancePartitionParameters" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 instance partitions monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/Lock" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 locks monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/Log" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 logs monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/Performance" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 health monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/Recovery" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 Recovery monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/SQL" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 SQL monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/TableSpaces" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 TableSpaces monitoring performance and availability will be enabled>>"
},
!----------------------------------------------
! Filters configuration by monitor types list
!----------------------------------------------
"/PSO/DB2/RemoteWin/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/DB2DatabaseName" = {
REPLACE = "<<This variable value is the IBM DB2 database name to which the filtering will be applied>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/DB2InstanceName" = {
REPLACE = "<<This variable value is the IBM DB2 instance name to which the filtering will be applied>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/appClassesFilterList/<<application monitor types>>/appClassId" = {
REPLACE = "<<This variable value is the selected filtering monitor type value. Application class corresponding ID list you find at file: Patrol3/pso/conf/app_classes_mapping.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/appClassesFilterList/<<application monitor types>>/type" = {
REPLACE = "<<This variable value is the selected filtering option. Values can be : 0-None , 1-Include , 2-Exclude >>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/appClassesFilterList/<<application monitor types>>/value" = {
REPLACE = "<<This variable value is the filtering instances from the selected monitor type>>"
},
!-------------------------------------------
! Custom SQL queries configuration list
!-------------------------------------------
"/PSO/DB2/RemoteWin/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustDB2DatabaseName" = {
REPLACE = "<<The database name of the DB2 server you would like to do custom SQL query>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustDB2InstanceName" = {
REPLACE = "<<The instance name of the DB2 server you would like to do custom SQL query>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/EnableNumberOfRecordsAnnotation" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the query result as an annotation will be displayed>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/SQLQuery" = {
REPLACE = "<<The custom SQL query you like to run>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/SQLQueryCycle" = {
REPLACE = "<<Collection cycle time in minutes of the DB2 SQL query>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/SQLQueryName" = {
REPLACE = "<<This variable displays the custom SQL query configuration list. The following characters are not allowed: $ |?\"[]+=&*();!^<>:/ >>"
},
!--------------------------------------------
! IBM db2diag log search configuration list
!--------------------------------------------
"/PSO/DB2/RemoteWin/<<environment name>>/DB2DiagLogSearchConfigList/<<iterator on specific DB2 instance>>/DB2DiagLogSearchList/<<iterator on db2diaglog search command>>/DiagLogSearchCommand" = {
REPLACE = "<<This variable value is the IBM db2diag tool search command>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/DB2DiagLogSearchConfigList/<<iterator on specific DB2 instance>>/DB2DiagLogSearchList/<<iterator on db2diaglog search command>>/DiagLogState" = {
REPLACE = "<<This variable value is the selected state which is set to the DiagLogOkAttribute. Values: 2-PRUNE, 3-INFORMATION, WARN-4, ALARM-5 >>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/DB2DiagLogSearchConfigList/<<iterator on specific DB2 instance>>/DiagLogDB2InstanceName" = {
REPLACE = "<<This variable value is the DB2 instance name to which the IBM db2diag log search configuration will be applied>>"
},
!-----------------------------
! Administration
!-----------------------------
"/PSO/DB2/RemoteWin/<<environment name>>/logging" = {
REPLACE = "<<optional - setting the value of this pconfig variable to true or 1 will cause to enable debug logging for this environment.Log files will be created under the $PATROL_HOME/pso/logs and $PATROL_HOME/log directories>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/availabilityCollector" = {
REPLACE = "<<This variable value is the collection interval for availability attributes. Default 60 seconds>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/dataCollector" = {
REPLACE = "<<This variable value is the collection interval for data attributes. Default 600 seconds>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/diagLogCollector" = {
REPLACE = "<<This variable value is the collection interval for IBM db2diag log attributes. Default 900 seconds>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/LongRunningQueriesThreshold" = {
REPLACE = "<<This variable value is the threshold in seconds for the monitor data collection SQL queries that run longer than that. Default 60 seconds>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/LongRunningCommandsThreshold" = {
REPLACE = "<<This variable value is the threshold in seconds for the monitor data collection CLP or OS commands that run longer than that. Default 60 seconds>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BPPMI2D" = {
REPLACE = "<<optinal - if this variable is 'true' or '1' then it enables device mapping for all hosts in this environment. Monitors are created within a device according to the discovered host name of the monitored system. Disable device mapping means monitors are created within the device of the PATROL agent(s).>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/disableRemoteDBMonitoring" = {
REPLACE = "<<optional - setting the value of this pconfig variable to true or 1 will cause to NOT discover 'Remote' databases, deleting this pconfig variable or set its value to 0 or false will cause to discover the 'Remote' databases>>"
},
!----------------------------------
! Disable monitoring configuration
!----------------------------------
"/PSO/DB2/RemoteWin/<<environment name>>/DisableEnvironment" = {
REPLACE = "<<optinal - if this variable is 'true' or '1' then it will disable the creation of the environment on the patrol tree view>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/DB2InstanceConfigurationList/<<instance name>>/ShutdownDB2InstanceName" = {
REPLACE = "<<the specific DB2 instance name that you want to be destroyed if you provide a specific file path which should be located in the DB2 machine>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/DB2InstanceConfigurationList/<<instance name>>/ShutdownInstanceFilePath" = {
REPLACE = "<<optional - the km check every 1 min if the file registered in this pconfig variable for the specific instance is exists or not, if it exists then will destroy the db2 instance, if not exist then will discover the db2 instance as well, the shutdown file should be located in the DB2 machine>>"
},
!---------------------------------------
! Environment edit state
!----------------------------------------
"/PSO/DB2/RemoteWin/<<environment name>>/isEnvEdited" = {
REPLACE = "<<If the current environment is edited from the pconfig the variable value should be changed to 1, that it applied to the changes>>"
},
!-------------------------------------------------------------------------------
! Configure security mecahnism,i18n ,tableSpaces and ConnToDBOK configuration
! Using BMC_FORCE
!-------------------------------------------------------------------------------
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/securityMechanism" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/securityMechanism but for a specific instance.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/i18n/lang" = {
REPLACE = "<<optional - The locale of DB2 environment it must be declared as <language>_<country> for example en_US, if user didn't insert this pconfig variable then will use the current locale of the java collector, if didn't succeed to retrieve current locale from java then will use the default locale en_US>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/tableSpaces/stateWarnList" = {
REPLACE = "<<optional - This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific instance will be in warn state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateWarnList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/tableSpaces/stateAlertList" = {
REPLACE = "<<optional - This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific instance will be in alarm state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateAlertList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/<<DB2 database name>>/tableSpaces/stateWarnList" = {
REPLACE = "<<optional - This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific instance and the specific database will be in warn state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateWarnList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/<<DB2 database name>>/tableSpaces/stateAlertList" = {
REPLACE = "<<optional - This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific instance and the specific database will be in alarm state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateAlertList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/<<DB2 database name>>/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - This pconfig define the SQL codes list (separated by comma) that generate warning state of parameter ConnToDBOK, Example: SQL1116N,SQL1035N,SQL1032N, so if failed to connect to database then km will check if error code is equal to any SQL code defined in this list, if yes then will set the value of the parameter to warn value.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/<<DB2 database name>>/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/warnList but for a specific instance and database.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/warnList but for a specific instance level, this mean it will apply for all databases under this instance.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/warnList but for environment level, this mean it will apply for all databases under all instances of this environment.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - This pconfig define the SQL codes list (separated by comma) that exclude alarm state of parameter ConnToDBOK, Example: SQL1116N,SQL1035N,SQL1032N, so if failed to connect to database then km will check if error code is equal to any SQL code defined in this list, if yes then will set the value of the parameter to value that will not generate alarm.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList but for a specific instance and database.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList but for a specific instance level, this mean it will apply for all databases under this instance.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList but for environment level, this mean it will apply for all databases under all instances of this environment.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/ReconnectCycle" = {
REPLACE = "<<optional - The time in seconds need to wait before try to reconnect to the environment (in case the environment failed to connect to the main connection). The default is 300 seconds.>>"
}
!------------------------------
! Global monitoring setting
!-----------------------------
"/PSO/DB2/RemoteWin/EnvList" = {
REPLACE = "<<Each DB2 environment name you add should be on this list using comma separator.The following characters are not valid in the environment name: $ |?\"[]+=&*();!^<>:/ >>"
},
"/PSO/DB2/RemoteWin/Logging" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then debug logging for all environments will be enabled. Log files will be created under the $PATROL_HOME/log directory.>>"
},
"/PSO/DB2/RemoteWin/ShutdownKMFilePath" = {
REPLACE = "<<optional - the km check every 30 seconds if the file registered in this pconfig variable is exists or not, if it exists then will shutdown and destroy all the environments under 'DB2' icon from console, if not exist then will discover the environments as well, the shutdown file should be located in the agent machine>>"
},
!----------------------------
! Environment Configurations
!----------------------------
"/PSO/DB2/RemoteWin/<<environment name>>/envName" = {
REPLACE = "<<This variable value is <<environment name>> which is a unique environment name for the IBM DB2 which describes the environment's usage>>"
},
! Remote PowerShell details
"/PSO/DB2/RemoteWin/<<environment name>>/remoteHost" = {
REPLACE = "<<The remote host name where the monitored DB2 environment exist, this field should be used only in remote unix/window monitoring. >>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/remoteHostPort" = {
REPLACE = "<<The remote host port where the monitored DB2 environment exist, this field should be used only in remote unix/window monitoring, for example in windows env defaultF PowerShell port number 5985>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/remoteHostAuthentication" = {
REPLACE = "<<The remote host authentication for power shell windows connection, the value of this should be one of the values in the list: [Negotiate=1,Basic=2,Kerberos=3] >>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/remoteHostIsHttps" = {
REPLACE = "<<The remote host IsHttps for power shell windows connection, the value of this should be one of the values in the list: [FALSE=1, TRUE=2] >>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/remoteHostUser" = {
REPLACE = "<<The user that will be used to connect to the remote host>>"
},
"/SecureStore/PSO/DB2/RemoteWin/<<environment name>>/remoteHostPassword" = {
REPLACE = "DB2_MAIN;DB2_ENVIRONMENT;DB2_SETUPWIN;DB2_SETUPUNIX;DB2_SETUPLOCAL;DB2_SETUPJDBC/<<The remote host user's password that will be used to connect to remote host>>"
},
!------------------------
! Remote IBM DB2 Details
!------------------------
"/PSO/DB2/RemoteWin/<<environment name>>/db2InstallationHome" = {
REPLACE = "<<optional - The db2 installation home that need to monitor, you can provide full DB2 path, DB2PATH environment variable, or leave empty, in case you provided DB2PATH and it not defined as env variable in your DB2 system or left it empty, then the km will try to monitor a default DB2 installation home if it exist in the xml file Patrol3/pso/conf/xml/defaultDB2InstallationHomeList.xml and in your DB2 system. Environment variable name must start with DB2PATH. Example: DB2PATH, DB2PATH2 >>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/db2InstancesMonitoringList" = {
REPLACE = "<<optional - The db2 instances list that need to monitor, the list should be separated by ',' separator and it's not support regex. when leave this field empty then the km will monitor all the db2 instances in the environment. >>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/securityMechanism" = {
REPLACE = "<<optional - The securityMechanism used to connect to database, value 3 is the DEFAULT, value 13 is provided to support ENCRYPTED_USER_PASSWORD_AND_DATA_SECURITY, use this variable ONLY if you use IBM SDK 8 and above>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/db2User" = {
REPLACE = "<<optional - The user that will be used to monitor the databases using the jdbc connection, if you leave this variable empty in remote monitoring then the km will use the provided remoteHostUser>>"
},
"/SecureStore/PSO/DB2/RemoteWin/<<environment name>>/db2Password" = {
REPLACE = "DB2_MAIN;DB2_ENVIRONMENT;DB2_SETUPWIN;DB2_SETUPUNIX;DB2_SETUPLOCAL;DB2_SETUPJDBC/<<The db2 user's password that will be used to monitor the db2 instances>>"
},
!--------------------------
! Java collector settings
!--------------------------
"/PSO/DB2/RemoteWin/<<environment name>>/javaHome" = {
REPLACE = "<<The java home that will be used to run the java collector>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/jvmArgs" = {
REPLACE = "<<optinal- JVM args for the java collector>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/osJVMUser" = {
REPLACE = "<<The user that will run the java collector>>"
},
"/SecureStore/PSO/DB2/RemoteWin/<<environment name>>/osJVMPassword" = {
REPLACE = "DB2_MAIN;DB2_ENVIRONMENT;DB2_SETUPWIN;DB2_SETUPUNIX;DB2_SETUPLOCAL;DB2_SETUPJDBC/<<The local user's password that will be used to run the java collector>>"
},
!----------------------------
! Monitoring data details
!----------------------------
"/PSO/DB2/RemoteWin/<<environment name>>/healthMonitoring" = {
REPLACE = "<<Type of monitoring: availability only=1, DB2 system controlled=2, Customer collection data Selection=3>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/Applications" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 applications monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BufferPools" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 buffer pools monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/Capacity" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 capacity monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/HADR" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 high availability and disaster recovery monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/InstanceParameters" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 instances monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/InstancePartitionParameters" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 instance partitions monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/Lock" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 locks monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/Log" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 logs monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/Performance" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 health monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/Recovery" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 Recovery monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/SQL" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 SQL monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/TableSpaces" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 TableSpaces monitoring performance and availability will be enabled>>"
},
!----------------------------------------------
! Filters configuration by monitor types list
!----------------------------------------------
"/PSO/DB2/RemoteWin/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/DB2DatabaseName" = {
REPLACE = "<<This variable value is the IBM DB2 database name to which the filtering will be applied>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/DB2InstanceName" = {
REPLACE = "<<This variable value is the IBM DB2 instance name to which the filtering will be applied>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/appClassesFilterList/<<application monitor types>>/appClassId" = {
REPLACE = "<<This variable value is the selected filtering monitor type value. Application class corresponding ID list you find at file: Patrol3/pso/conf/app_classes_mapping.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/appClassesFilterList/<<application monitor types>>/type" = {
REPLACE = "<<This variable value is the selected filtering option. Values can be : 0-None , 1-Include , 2-Exclude >>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/appClassesFilterList/<<application monitor types>>/value" = {
REPLACE = "<<This variable value is the filtering instances from the selected monitor type>>"
},
!-------------------------------------------
! Custom SQL queries configuration list
!-------------------------------------------
"/PSO/DB2/RemoteWin/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustDB2DatabaseName" = {
REPLACE = "<<The database name of the DB2 server you would like to do custom SQL query>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustDB2InstanceName" = {
REPLACE = "<<The instance name of the DB2 server you would like to do custom SQL query>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/EnableNumberOfRecordsAnnotation" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the query result as an annotation will be displayed>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/SQLQuery" = {
REPLACE = "<<The custom SQL query you like to run>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/SQLQueryCycle" = {
REPLACE = "<<Collection cycle time in minutes of the DB2 SQL query>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/SQLQueryName" = {
REPLACE = "<<This variable displays the custom SQL query configuration list. The following characters are not allowed: $ |?\"[]+=&*();!^<>:/ >>"
},
!--------------------------------------------
! IBM db2diag log search configuration list
!--------------------------------------------
"/PSO/DB2/RemoteWin/<<environment name>>/DB2DiagLogSearchConfigList/<<iterator on specific DB2 instance>>/DB2DiagLogSearchList/<<iterator on db2diaglog search command>>/DiagLogSearchCommand" = {
REPLACE = "<<This variable value is the IBM db2diag tool search command>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/DB2DiagLogSearchConfigList/<<iterator on specific DB2 instance>>/DB2DiagLogSearchList/<<iterator on db2diaglog search command>>/DiagLogState" = {
REPLACE = "<<This variable value is the selected state which is set to the DiagLogOkAttribute. Values: 2-PRUNE, 3-INFORMATION, WARN-4, ALARM-5 >>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/DB2DiagLogSearchConfigList/<<iterator on specific DB2 instance>>/DiagLogDB2InstanceName" = {
REPLACE = "<<This variable value is the DB2 instance name to which the IBM db2diag log search configuration will be applied>>"
},
!-----------------------------
! Administration
!-----------------------------
"/PSO/DB2/RemoteWin/<<environment name>>/logging" = {
REPLACE = "<<optional - setting the value of this pconfig variable to true or 1 will cause to enable debug logging for this environment.Log files will be created under the $PATROL_HOME/pso/logs and $PATROL_HOME/log directories>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/availabilityCollector" = {
REPLACE = "<<This variable value is the collection interval for availability attributes. Default 60 seconds>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/dataCollector" = {
REPLACE = "<<This variable value is the collection interval for data attributes. Default 600 seconds>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/diagLogCollector" = {
REPLACE = "<<This variable value is the collection interval for IBM db2diag log attributes. Default 900 seconds>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/LongRunningQueriesThreshold" = {
REPLACE = "<<This variable value is the threshold in seconds for the monitor data collection SQL queries that run longer than that. Default 60 seconds>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/LongRunningCommandsThreshold" = {
REPLACE = "<<This variable value is the threshold in seconds for the monitor data collection CLP or OS commands that run longer than that. Default 60 seconds>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BPPMI2D" = {
REPLACE = "<<optinal - if this variable is 'true' or '1' then it enables device mapping for all hosts in this environment. Monitors are created within a device according to the discovered host name of the monitored system. Disable device mapping means monitors are created within the device of the PATROL agent(s).>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/disableRemoteDBMonitoring" = {
REPLACE = "<<optional - setting the value of this pconfig variable to true or 1 will cause to NOT discover 'Remote' databases, deleting this pconfig variable or set its value to 0 or false will cause to discover the 'Remote' databases>>"
},
!----------------------------------
! Disable monitoring configuration
!----------------------------------
"/PSO/DB2/RemoteWin/<<environment name>>/DisableEnvironment" = {
REPLACE = "<<optinal - if this variable is 'true' or '1' then it will disable the creation of the environment on the patrol tree view>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/DB2InstanceConfigurationList/<<instance name>>/ShutdownDB2InstanceName" = {
REPLACE = "<<the specific DB2 instance name that you want to be destroyed if you provide a specific file path which should be located in the DB2 machine>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/DB2InstanceConfigurationList/<<instance name>>/ShutdownInstanceFilePath" = {
REPLACE = "<<optional - the km check every 1 min if the file registered in this pconfig variable for the specific instance is exists or not, if it exists then will destroy the db2 instance, if not exist then will discover the db2 instance as well, the shutdown file should be located in the DB2 machine>>"
},
!---------------------------------------
! Environment edit state
!----------------------------------------
"/PSO/DB2/RemoteWin/<<environment name>>/isEnvEdited" = {
REPLACE = "<<If the current environment is edited from the pconfig the variable value should be changed to 1, that it applied to the changes>>"
},
!-------------------------------------------------------------------------------
! Configure security mecahnism,i18n ,tableSpaces and ConnToDBOK configuration
! Using BMC_FORCE
!-------------------------------------------------------------------------------
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/securityMechanism" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/securityMechanism but for a specific instance.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/i18n/lang" = {
REPLACE = "<<optional - The locale of DB2 environment it must be declared as <language>_<country> for example en_US, if user didn't insert this pconfig variable then will use the current locale of the java collector, if didn't succeed to retrieve current locale from java then will use the default locale en_US>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/tableSpaces/stateWarnList" = {
REPLACE = "<<optional - This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific instance will be in warn state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateWarnList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/tableSpaces/stateAlertList" = {
REPLACE = "<<optional - This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific instance will be in alarm state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateAlertList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/<<DB2 database name>>/tableSpaces/stateWarnList" = {
REPLACE = "<<optional - This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific instance and the specific database will be in warn state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateWarnList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/<<DB2 database name>>/tableSpaces/stateAlertList" = {
REPLACE = "<<optional - This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific instance and the specific database will be in alarm state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateAlertList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/<<DB2 database name>>/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - This pconfig define the SQL codes list (separated by comma) that generate warning state of parameter ConnToDBOK, Example: SQL1116N,SQL1035N,SQL1032N, so if failed to connect to database then km will check if error code is equal to any SQL code defined in this list, if yes then will set the value of the parameter to warn value.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/<<DB2 database name>>/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/warnList but for a specific instance and database.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/warnList but for a specific instance level, this mean it will apply for all databases under this instance.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/warnList but for environment level, this mean it will apply for all databases under all instances of this environment.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - This pconfig define the SQL codes list (separated by comma) that exclude alarm state of parameter ConnToDBOK, Example: SQL1116N,SQL1035N,SQL1032N, so if failed to connect to database then km will check if error code is equal to any SQL code defined in this list, if yes then will set the value of the parameter to value that will not generate alarm.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList but for a specific instance and database.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList but for a specific instance level, this mean it will apply for all databases under this instance.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList but for environment level, this mean it will apply for all databases under all instances of this environment.>>"
},
"/PSO/DB2/RemoteWin/<<environment name>>/BMC_FORCE/ReconnectCycle" = {
REPLACE = "<<optional - The time in seconds need to wait before try to reconnect to the environment (in case the environment failed to connect to the main connection). The default is 300 seconds.>>"
}
Click here to configure DB2 Remote UNIX connection
The following is the template of pso_ruleSet_RemoteUnix.cfg file, which contains configuration variables to monitor remote Windows:
PATROL_CONFIG
!------------------------------
! Global monitoring setting
!-----------------------------
"/PSO/DB2/RemoteUnix/EnvList" = {
REPLACE = "<<Each DB2 environment name you add should be on this list using comma separator.The following characters are not valid in the environment name: $ |?\"[]+=&*();!^<>:/ >>"
},
"/PSO/DB2/RemoteUnix/Logging" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then debug logging for all environments will be enabled. Log files will be created under the $PATROL_HOME/log directory.>>"
},
"/PSO/DB2/RemoteUnix/ShutdownKMFilePath" = {
REPLACE = "<<optional - the km check every 30 seconds if the file registered in this pconfig variable is exists or not, if it exists then will shutdown and destroy all the environments under 'DB2' icon from console, if not exist then will discover the environments as well, the shutdown file should be located in the agent machine>>"
},
!----------------------------
! Environment Configurations
!----------------------------
"/PSO/DB2/RemoteUnix/<<environment name>>/envName" = {
REPLACE = "<<This variable value is <<environment name>> which is a unique environment name for the IBM DB2 which describes the environment's usage>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/remoteHost" = {
REPLACE = "<<The remote host name where the monitored DB2 environment exist, this field should be used only in remote unix/window monitoring. >>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/remoteHostPort" = {
REPLACE = "<<The remote host port where the monitored DB2 environment exist, this field should be used only in remote unix/window monitoring, for example in unix env and with ssh client this field can be the ssh port 22>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/remoteHostUser" = {
REPLACE = "<<The user that will be used to connect to the remote host>>"
},
"/SecureStore/PSO/DB2/RemoteUnix/<<environment name>>/remoteHostPassword" = {
REPLACE = "DB2_MAIN;DB2_ENVIRONMENT;DB2_SETUPWIN;DB2_SETUPUNIX;DB2_SETUPLOCAL;DB2_SETUPJDBC/<<The remote host user's password that will be used to connect to remote host>>"
},
!------------------------
! Remote IBM DB2 Details
!------------------------
"/PSO/DB2/RemoteUnix/<<environment name>>/db2InstallationHome" = {
REPLACE = "<<optional - The db2 installation home that need to monitor, you can provide full db2 path, DB2PATH environment variable, or leave empty, in case you provided DB2PATH and it not defined as env variable in your db2 system or left it empty, then the km will try to monitor a default db2 installation home if it exist in the xml file Patrol3/pso/conf/xml/defaultDB2InstallationHomeList.xml and in your db2 system. Environment variable name must start with DB2PATH. Example: DB2PATH, DB2PATH2 >>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/db2InstancesMonitoringList" = {
REPLACE = "<<optional - The db2 instances list that need to monitor, the list should be separated by ',' separator and it's not support regex. when leave this field empty then the km will monitor all the db2 instances in the environment. >>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/securityMechanism" = {
REPLACE = "<<optional - The securityMechanism used to connect to database, value 3 is the DEFAULT, value 13 is provided to support ENCRYPTED_USER_PASSWORD_AND_DATA_SECURITY, use this variable ONLY if you use IBM SDK 8 and above>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/db2User" = {
REPLACE = "<<optional - The user that will be used to monitor the databases using the jdbc connection, if you leave this variable empty in remote monitoring then the km will use the provided remoteHostUser>>"
},
"/SecureStore/PSO/DB2/RemoteUnix/<<environment name>>/db2Password" = {
REPLACE = "DB2_MAIN;DB2_ENVIRONMENT;DB2_SETUPWIN;DB2_SETUPUNIX;DB2_SETUPLOCAL;DB2_SETUPJDBC/<<The db2 user's password that will be used to monitor the db2 instances>>"
},
!--------------------------
! Java collector settings
!--------------------------
"/PSO/DB2/RemoteUnix/<<environment name>>/javaHome" = {
REPLACE = "<<The java home that will be used to run the java collector>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/jvmArgs" = {
REPLACE = "<<optinal- JVM args for the java collector>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/osJVMUser" = {
REPLACE = "<<The user that will run the java collector>>"
},
"/SecureStore/PSO/DB2/RemoteUnix/<<environment name>>/osJVMPassword" = {
REPLACE = "DB2_MAIN;DB2_ENVIRONMENT;DB2_SETUPWIN;DB2_SETUPUNIX;DB2_SETUPLOCAL;DB2_SETUPJDBC/<<The local user's password that will be used to run the java collector>>"
},
!----------------------------
! Monitoring data details
!----------------------------
"/PSO/DB2/RemoteUnix/<<environment name>>/healthMonitoring" = {
REPLACE = "<<Type of monitoring: availability only=1, DB2 system controlled=2, Customer collection data Selection=3>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/Applications" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 applications monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BufferPools" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 buffer pools monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/Capacity" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 capacity monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/HADR" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 high availability and disaster recovery monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/InstanceParameters" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 instances monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/InstancePartitionParameters" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 instance partitions monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/Lock" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 locks monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/Log" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 logs monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/Performance" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 health monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/Recovery" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 Recovery monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/SQL" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 SQL monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/TableSpaces" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 TableSpaces monitoring performance and availability will be enabled>>"
},
!----------------------------------------------
! Filters configuration by monitor types list
!----------------------------------------------
"/PSO/DB2/RemoteUnix/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/DB2DatabaseName" = {
REPLACE = "<<This variable value is the IBM DB2 database name to which the filtering will be applied>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/DB2InstanceName" = {
REPLACE = "<<This variable value is the IBM DB2 instance name to which the filtering will be applied>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/appClassesFilterList/<<application monitor types>>/appClassId" = {
REPLACE = "<<This variable value is the selected filtering monitor type value. Application class corresponding ID list you find at file: Patrol3/pso/conf/app_classes_mapping>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/appClassesFilterList/<<application monitor types>>/type" = {
REPLACE = "<<This variable value is the selected filtering option. Values can be : 0-None , 1-Include , 2-Exclude>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/appClassesFilterList/<<application monitor types>>/value" = {
REPLACE = "<<This variable value is the filtering instances from the selected monitor type>>"
},
!-------------------------------------------
! Custom SQL queries configuration list
!-------------------------------------------
"/PSO/DB2/RemoteUnix/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustDB2DatabaseName" = {
REPLACE = "<<The database name of the DB2 server you would like to do custom SQL query>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustDB2InstanceName" = {
REPLACE = "<<The instance name of the DB2 server you would like to do custom SQL query>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/EnableNumberOfRecordsAnnotation" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the query result as an annotation will be displayed>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/SQLQuery" = {
REPLACE = "<<The custom SQL query you like to run>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/SQLQueryCycle" = {
REPLACE = "<<Collection cycle time in minutes of the DB2 SQL query>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/SQLQueryName" = {
REPLACE = "<<This variable displays the custom SQL query configuration list. The following characters are not allowed: $ |?\"[]+=&*();!^<>:/ >>"
},
!--------------------------------------------
! IBM db2diag log search configuration list
!--------------------------------------------
"/PSO/DB2/RemoteUnix/<<environment name>>/DB2DiagLogSearchConfigList/<<iterator on specific DB2 instance>>/DB2DiagLogSearchList/<<iterator on db2diaglog search command>>/DiagLogSearchCommand" = {
REPLACE = "<<This variable value is the IBM db2diag tool search command>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/DB2DiagLogSearchConfigList/<<iterator on specific DB2 instance>>/DB2DiagLogSearchList/<<iterator on db2diaglog search command>>/DiagLogState" = {
REPLACE = "<<This variable value is the selected state which is set to the DiagLogOkAttribute. Values: 2-PRUNE, 3-INFORMATION, WARN-4, ALARM-5 >>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/DB2DiagLogSearchConfigList/<<iterator on specific DB2 instance>>/DiagLogDB2InstanceName" = {
REPLACE = "<<This variable value is the DB2 instance name to which the IBM db2diag log search configuration will be applied>>"
},
!-----------------------------
! Administration
!-----------------------------
"/PSO/DB2/RemoteUnix/<<environment name>>/logging" = {
REPLACE = "<<optional - setting the value of this pconfig variable to true or 1 will cause to enable debug logging for this environment.Log files will be created under the $PATROL_HOME/pso/logs and $PATROL_HOME/log directories>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/availabilityCollector" = {
REPLACE = "<<This variable value is the collection interval for availability attributes. Default 60 seconds>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/dataCollector" = {
REPLACE = "<<This variable value is the collection interval for data attributes. Default 600 seconds>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/diagLogCollector" = {
REPLACE = "<<This variable value is the collection interval for IBM db2diag log attributes. Default 900 seconds>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/LongRunningQueriesThreshold" = {
REPLACE = "<<This variable value is the threshold in seconds for the monitor data collection SQL queries that run longer than that. Default 60 seconds>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/LongRunningCommandsThreshold" = {
REPLACE = "<<This variable value is the threshold in seconds for the monitor data collection CLP or OS commands that run longer than that. Default 60 seconds>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BPPMI2D" = {
REPLACE = "<<optinal - if this variable is 'true' or '1' then it enables device mapping for all hosts in this environment. Monitors are created within a device according to the discovered host name of the monitored system. Disable device mapping means monitors are created within the device of the PATROL agent(s).>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/disableRemoteDBMonitoring" = {
REPLACE = "<<optional - setting the value of this pconfig variable to true or 1 will cause to NOT discover 'Remote' databases, deleting this pconfig variable or set its value to 0 or false will cause to discover the 'Remote' databases>>"
},
!----------------------------------
! Disable monitoring configuration
!----------------------------------
"/PSO/DB2/RemoteUnix/<<environment name>>/DisableEnvironment" = {
REPLACE = "<<optinal - if this variable is 'true' or '1' then it will disable the creation of the environment on the patrol tree view>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/DB2InstanceConfigurationList/<<instance name>>/ShutdownDB2InstanceName" = {
REPLACE = "<<the specific DB2 instance name that you want to be destroyed if you provide a specific file path which should be located in the DB2 machine>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/DB2InstanceConfigurationList/<<instance name>>/ShutdownInstanceFilePath" = {
REPLACE = "<<optional - the km check every 1 min if the file registered in this pconfig variable for the specific instance is exists or not, if it exists then will destroy the db2 instance, if not exist then will discover the db2 instance as well, the shutdown file should be located in the DB2 machine>>"
},
!---------------------------------------
! Environment edit state
!----------------------------------------
"/PSO/DB2/RemoteUnix/<<environment name>>/isEnvEdited" = {
REPLACE = "<<If the current environment is edited from the pconfig the variable value should be changed to 1, that it applied to the changes>>"
},
!-------------------------------------------------------------------------------
! Configure security mecahnism,i18n ,tableSpaces and ConnToDBOK configuration
! Using BMC_FORCE
!-------------------------------------------------------------------------------
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/securityMechanism" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/securityMechanism but for a specific instance.>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/i18n/lang" = {
REPLACE = "<<optional - The locale of DB2 environment it must be declared as <language>_<country> for example en_US, if user didn't insert this pconfig variable then will use the current locale of the java collector, if didn't succeed to retrieve current locale from java then will use the default locale en_US>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/tableSpaces/stateWarnList" = {
REPLACE = "<<optional - This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific instance will be in warn state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateWarnList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/tableSpaces/stateAlertList" = {
REPLACE = "<<optional - This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific instance will be in alarm state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateAlertList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/<<DB2 database name>>/tableSpaces/stateWarnList" = {
REPLACE = "<<optional - This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific instance and the specific database will be in warn state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateWarnList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/<<DB2 database name>>/tableSpaces/stateAlertList" = {
REPLACE = "<<optional - This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific instance and the specific database will be in alarm state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateAlertList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/<<DB2 database name>>/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - This pconfig define the SQL codes list (separated by comma) that generate warning state of parameter ConnToDBOK, Example: SQL1116N,SQL1035N,SQL1032N, so if failed to connect to database then km will check if error code is equal to any SQL code defined in this list, if yes then will set the value of the parameter to warn value.>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/<<DB2 database name>>/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/warnList but for a specific instance and database.>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/warnList but for a specific instance level, this mean it will apply for all databases under this instance.>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/warnList but for environment level, this mean it will apply for all databases under all instances of this environment.>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - This pconfig define the SQL codes list (separated by comma) that exclude alarm state of parameter ConnToDBOK, Example: SQL1116N,SQL1035N,SQL1032N, so if failed to connect to database then km will check if error code is equal to any SQL code defined in this list, if yes then will set the value of the parameter to value that will not generate alarm.>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList but for a specific instance and database.>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList but for a specific instance level, this mean it will apply for all databases under this instance.>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList but for environment level, this mean it will apply for all databases under all instances of this environment.>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/ReconnectCycle" = {
REPLACE = "<<optional - The time in seconds need to wait before try to reconnect to the environment (in case the environment failed to connect to the main connection). The default is 300 seconds.>>"
}
!------------------------------
! Global monitoring setting
!-----------------------------
"/PSO/DB2/RemoteUnix/EnvList" = {
REPLACE = "<<Each DB2 environment name you add should be on this list using comma separator.The following characters are not valid in the environment name: $ |?\"[]+=&*();!^<>:/ >>"
},
"/PSO/DB2/RemoteUnix/Logging" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then debug logging for all environments will be enabled. Log files will be created under the $PATROL_HOME/log directory.>>"
},
"/PSO/DB2/RemoteUnix/ShutdownKMFilePath" = {
REPLACE = "<<optional - the km check every 30 seconds if the file registered in this pconfig variable is exists or not, if it exists then will shutdown and destroy all the environments under 'DB2' icon from console, if not exist then will discover the environments as well, the shutdown file should be located in the agent machine>>"
},
!----------------------------
! Environment Configurations
!----------------------------
"/PSO/DB2/RemoteUnix/<<environment name>>/envName" = {
REPLACE = "<<This variable value is <<environment name>> which is a unique environment name for the IBM DB2 which describes the environment's usage>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/remoteHost" = {
REPLACE = "<<The remote host name where the monitored DB2 environment exist, this field should be used only in remote unix/window monitoring. >>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/remoteHostPort" = {
REPLACE = "<<The remote host port where the monitored DB2 environment exist, this field should be used only in remote unix/window monitoring, for example in unix env and with ssh client this field can be the ssh port 22>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/remoteHostUser" = {
REPLACE = "<<The user that will be used to connect to the remote host>>"
},
"/SecureStore/PSO/DB2/RemoteUnix/<<environment name>>/remoteHostPassword" = {
REPLACE = "DB2_MAIN;DB2_ENVIRONMENT;DB2_SETUPWIN;DB2_SETUPUNIX;DB2_SETUPLOCAL;DB2_SETUPJDBC/<<The remote host user's password that will be used to connect to remote host>>"
},
!------------------------
! Remote IBM DB2 Details
!------------------------
"/PSO/DB2/RemoteUnix/<<environment name>>/db2InstallationHome" = {
REPLACE = "<<optional - The db2 installation home that need to monitor, you can provide full db2 path, DB2PATH environment variable, or leave empty, in case you provided DB2PATH and it not defined as env variable in your db2 system or left it empty, then the km will try to monitor a default db2 installation home if it exist in the xml file Patrol3/pso/conf/xml/defaultDB2InstallationHomeList.xml and in your db2 system. Environment variable name must start with DB2PATH. Example: DB2PATH, DB2PATH2 >>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/db2InstancesMonitoringList" = {
REPLACE = "<<optional - The db2 instances list that need to monitor, the list should be separated by ',' separator and it's not support regex. when leave this field empty then the km will monitor all the db2 instances in the environment. >>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/securityMechanism" = {
REPLACE = "<<optional - The securityMechanism used to connect to database, value 3 is the DEFAULT, value 13 is provided to support ENCRYPTED_USER_PASSWORD_AND_DATA_SECURITY, use this variable ONLY if you use IBM SDK 8 and above>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/db2User" = {
REPLACE = "<<optional - The user that will be used to monitor the databases using the jdbc connection, if you leave this variable empty in remote monitoring then the km will use the provided remoteHostUser>>"
},
"/SecureStore/PSO/DB2/RemoteUnix/<<environment name>>/db2Password" = {
REPLACE = "DB2_MAIN;DB2_ENVIRONMENT;DB2_SETUPWIN;DB2_SETUPUNIX;DB2_SETUPLOCAL;DB2_SETUPJDBC/<<The db2 user's password that will be used to monitor the db2 instances>>"
},
!--------------------------
! Java collector settings
!--------------------------
"/PSO/DB2/RemoteUnix/<<environment name>>/javaHome" = {
REPLACE = "<<The java home that will be used to run the java collector>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/jvmArgs" = {
REPLACE = "<<optinal- JVM args for the java collector>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/osJVMUser" = {
REPLACE = "<<The user that will run the java collector>>"
},
"/SecureStore/PSO/DB2/RemoteUnix/<<environment name>>/osJVMPassword" = {
REPLACE = "DB2_MAIN;DB2_ENVIRONMENT;DB2_SETUPWIN;DB2_SETUPUNIX;DB2_SETUPLOCAL;DB2_SETUPJDBC/<<The local user's password that will be used to run the java collector>>"
},
!----------------------------
! Monitoring data details
!----------------------------
"/PSO/DB2/RemoteUnix/<<environment name>>/healthMonitoring" = {
REPLACE = "<<Type of monitoring: availability only=1, DB2 system controlled=2, Customer collection data Selection=3>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/Applications" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 applications monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BufferPools" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 buffer pools monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/Capacity" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 capacity monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/HADR" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 high availability and disaster recovery monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/InstanceParameters" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 instances monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/InstancePartitionParameters" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 instance partitions monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/Lock" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 locks monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/Log" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 logs monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/Performance" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 health monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/Recovery" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 Recovery monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/SQL" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 SQL monitoring performance and availability will be enabled>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/TableSpaces" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the IBM DB2 TableSpaces monitoring performance and availability will be enabled>>"
},
!----------------------------------------------
! Filters configuration by monitor types list
!----------------------------------------------
"/PSO/DB2/RemoteUnix/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/DB2DatabaseName" = {
REPLACE = "<<This variable value is the IBM DB2 database name to which the filtering will be applied>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/DB2InstanceName" = {
REPLACE = "<<This variable value is the IBM DB2 instance name to which the filtering will be applied>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/appClassesFilterList/<<application monitor types>>/appClassId" = {
REPLACE = "<<This variable value is the selected filtering monitor type value. Application class corresponding ID list you find at file: Patrol3/pso/conf/app_classes_mapping>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/appClassesFilterList/<<application monitor types>>/type" = {
REPLACE = "<<This variable value is the selected filtering option. Values can be : 0-None , 1-Include , 2-Exclude>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/filterConfigurationByAppClassesList/<<iterator on specific DB2 instance and database name>>/appClassesFilterList/<<application monitor types>>/value" = {
REPLACE = "<<This variable value is the filtering instances from the selected monitor type>>"
},
!-------------------------------------------
! Custom SQL queries configuration list
!-------------------------------------------
"/PSO/DB2/RemoteUnix/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustDB2DatabaseName" = {
REPLACE = "<<The database name of the DB2 server you would like to do custom SQL query>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustDB2InstanceName" = {
REPLACE = "<<The instance name of the DB2 server you would like to do custom SQL query>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/EnableNumberOfRecordsAnnotation" = {
REPLACE = "<<optional - if this variable is 'true' or '1' then the query result as an annotation will be displayed>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/SQLQuery" = {
REPLACE = "<<The custom SQL query you like to run>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/SQLQueryCycle" = {
REPLACE = "<<Collection cycle time in minutes of the DB2 SQL query>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/CustomSQLQueriesConfigurationList/<<iterator on specific DB2 instance and database name>>/CustomSQLQueryConfigurationList/<<SQL query name>>/SQLQueryName" = {
REPLACE = "<<This variable displays the custom SQL query configuration list. The following characters are not allowed: $ |?\"[]+=&*();!^<>:/ >>"
},
!--------------------------------------------
! IBM db2diag log search configuration list
!--------------------------------------------
"/PSO/DB2/RemoteUnix/<<environment name>>/DB2DiagLogSearchConfigList/<<iterator on specific DB2 instance>>/DB2DiagLogSearchList/<<iterator on db2diaglog search command>>/DiagLogSearchCommand" = {
REPLACE = "<<This variable value is the IBM db2diag tool search command>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/DB2DiagLogSearchConfigList/<<iterator on specific DB2 instance>>/DB2DiagLogSearchList/<<iterator on db2diaglog search command>>/DiagLogState" = {
REPLACE = "<<This variable value is the selected state which is set to the DiagLogOkAttribute. Values: 2-PRUNE, 3-INFORMATION, WARN-4, ALARM-5 >>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/DB2DiagLogSearchConfigList/<<iterator on specific DB2 instance>>/DiagLogDB2InstanceName" = {
REPLACE = "<<This variable value is the DB2 instance name to which the IBM db2diag log search configuration will be applied>>"
},
!-----------------------------
! Administration
!-----------------------------
"/PSO/DB2/RemoteUnix/<<environment name>>/logging" = {
REPLACE = "<<optional - setting the value of this pconfig variable to true or 1 will cause to enable debug logging for this environment.Log files will be created under the $PATROL_HOME/pso/logs and $PATROL_HOME/log directories>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/availabilityCollector" = {
REPLACE = "<<This variable value is the collection interval for availability attributes. Default 60 seconds>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/dataCollector" = {
REPLACE = "<<This variable value is the collection interval for data attributes. Default 600 seconds>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/diagLogCollector" = {
REPLACE = "<<This variable value is the collection interval for IBM db2diag log attributes. Default 900 seconds>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/LongRunningQueriesThreshold" = {
REPLACE = "<<This variable value is the threshold in seconds for the monitor data collection SQL queries that run longer than that. Default 60 seconds>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/LongRunningCommandsThreshold" = {
REPLACE = "<<This variable value is the threshold in seconds for the monitor data collection CLP or OS commands that run longer than that. Default 60 seconds>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BPPMI2D" = {
REPLACE = "<<optinal - if this variable is 'true' or '1' then it enables device mapping for all hosts in this environment. Monitors are created within a device according to the discovered host name of the monitored system. Disable device mapping means monitors are created within the device of the PATROL agent(s).>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/disableRemoteDBMonitoring" = {
REPLACE = "<<optional - setting the value of this pconfig variable to true or 1 will cause to NOT discover 'Remote' databases, deleting this pconfig variable or set its value to 0 or false will cause to discover the 'Remote' databases>>"
},
!----------------------------------
! Disable monitoring configuration
!----------------------------------
"/PSO/DB2/RemoteUnix/<<environment name>>/DisableEnvironment" = {
REPLACE = "<<optinal - if this variable is 'true' or '1' then it will disable the creation of the environment on the patrol tree view>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/DB2InstanceConfigurationList/<<instance name>>/ShutdownDB2InstanceName" = {
REPLACE = "<<the specific DB2 instance name that you want to be destroyed if you provide a specific file path which should be located in the DB2 machine>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/DB2InstanceConfigurationList/<<instance name>>/ShutdownInstanceFilePath" = {
REPLACE = "<<optional - the km check every 1 min if the file registered in this pconfig variable for the specific instance is exists or not, if it exists then will destroy the db2 instance, if not exist then will discover the db2 instance as well, the shutdown file should be located in the DB2 machine>>"
},
!---------------------------------------
! Environment edit state
!----------------------------------------
"/PSO/DB2/RemoteUnix/<<environment name>>/isEnvEdited" = {
REPLACE = "<<If the current environment is edited from the pconfig the variable value should be changed to 1, that it applied to the changes>>"
},
!-------------------------------------------------------------------------------
! Configure security mecahnism,i18n ,tableSpaces and ConnToDBOK configuration
! Using BMC_FORCE
!-------------------------------------------------------------------------------
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/securityMechanism" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/securityMechanism but for a specific instance.>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/i18n/lang" = {
REPLACE = "<<optional - The locale of DB2 environment it must be declared as <language>_<country> for example en_US, if user didn't insert this pconfig variable then will use the current locale of the java collector, if didn't succeed to retrieve current locale from java then will use the default locale en_US>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/tableSpaces/stateWarnList" = {
REPLACE = "<<optional - This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific instance will be in warn state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateWarnList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/tableSpaces/stateAlertList" = {
REPLACE = "<<optional - This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific instance will be in alarm state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateAlertList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/<<DB2 database name>>/tableSpaces/stateWarnList" = {
REPLACE = "<<optional - This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific instance and the specific database will be in warn state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateWarnList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/<<DB2 database name>>/tableSpaces/stateAlertList" = {
REPLACE = "<<optional - This variable will contain list of the tablespace states values in hex decimal separated by comma, so the TblspCustomHealth parameter of any tablespace that relate to the specific instance and the specific database will be in alarm state if its value exist in the list defined by customers for this pconfig variable, the hex values are integer values you can add the prefix '0x' for any value also, example for the stateAlertList is '2,0x8,0xc'.>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/<<DB2 database name>>/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - This pconfig define the SQL codes list (separated by comma) that generate warning state of parameter ConnToDBOK, Example: SQL1116N,SQL1035N,SQL1032N, so if failed to connect to database then km will check if error code is equal to any SQL code defined in this list, if yes then will set the value of the parameter to warn value.>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/<<DB2 database name>>/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/warnList but for a specific instance and database.>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/warnList but for a specific instance level, this mean it will apply for all databases under this instance.>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/parameters/ConnToDBOK/warnList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/warnList but for environment level, this mean it will apply for all databases under all instances of this environment.>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - This pconfig define the SQL codes list (separated by comma) that exclude alarm state of parameter ConnToDBOK, Example: SQL1116N,SQL1035N,SQL1032N, so if failed to connect to database then km will check if error code is equal to any SQL code defined in this list, if yes then will set the value of the parameter to value that will not generate alarm.>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList but for a specific instance and database.>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/<<DB2 instance name>>/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList but for a specific instance level, this mean it will apply for all databases under this instance.>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/parameters/ConnToDBOK/excludeAlarmList" = {
REPLACE = "<<optional - this is same as /PSO/DB2/<<environment name>>/<<DB2 database name>>/parameters/ConnToDBOK/excludeAlarmList but for environment level, this mean it will apply for all databases under all instances of this environment.>>"
},
"/PSO/DB2/RemoteUnix/<<environment name>>/BMC_FORCE/ReconnectCycle" = {
REPLACE = "<<optional - The time in seconds need to wait before try to reconnect to the environment (in case the environment failed to connect to the main connection). The default is 300 seconds.>>"
}