Sample batch configuration files
This section provides sample batch files for the DB2 UDB EE and DB2 UDB EEE environments.
DB2 EE sample batch configuration file
The following example illustrates a batch configuration file for the inst1 and inst2 instances in the DB2 UDB EE environment. bradk003 represents the host and DB2 represents the DB2 UDB EE environment.
Sample batch configuration file for the DB2 UDB EE environment
bradk003:DB2:inst1::defaultAccount:patrol/patrol
bradk003:DB2:inst1::MenuCmds.defaultAccount:patrol/patrol
bradk003:DB2:inst2::defaultAccount:patrol/patrol
bradk003:DB2:::AutoAckDiagLogOK:1
bradk003:DB2:::AutoAckProblemDB2Agents:1
bradk003:DB2:::ConfVarVer:6.7.10
bradk003:DB2:::DB_CONN_TIMEOUT:189
bradk003:DB2:::DB_filterList:inst1-SAMPLE1
bradk003:DB2:::KMSTATUS:UP
bradk003:DB2:::LOCK_TIMEOUT:188
bradk003:DB2:::filterList:inst2
bradk003:DB2:::remoteList:inst1
bradk003:DB2:::syscAlarmList:inst2
bradk003:DB2:::syscRecovList:inst1
bradk003:DB2:inst1::db2server_ok_filename:/data3/db2/databases/test.txt
bradk003:DB2:::tblspList:inst1-SAMPLE1,inst2-SAMPLE2
bradk003:DB2:inst1:SAMPLE1:TSPCHOICE:2
bradk003:DB2:inst1::DMSONLY:
bradk003:DB2:inst2:SAMPLE2:tblsp_to_discover:
bradk003:DB2:inst1::SPARE_CHANNEL:0
bradk003:DB2:inst1::TablespaceStateAlertList:200,800
bradk003:DB2:inst2::TablespaceStateWarnList:100,400
bradk003:DB2:inst1::araAction:57
bradk003:DB2:i nst1::conntodb_warn:SQL1116N,SQL1035N,SQL1032N
bradk003:DB2:inst1::current_agent_filename:/data2/db2/databases/inst1/db2kmapp.cur
bradk003:DB2:inst1::history_agent_filename:/data2/db2/databases/inst1/db2kmapp.hst
bradk003:DB2:inst1::db2version:9.7
bradk003:DB2:inst1::error_list:ALARM Database is damaged
bradk003:DB2:inst1::monitor_switches:16 b 1 l 1 so 1 st 1 t 1 u 1
bradk003::::DB2UDB_VER9_INSTALL_PATH:/opt/IBM/db2/V9.1/;/opt/IBM/db2/V9.7/
bradk003:DB2:inst1::discApplNames:
bradk003::::AgentAppEnableList:inst2,inst1
bradk003::::ForceAppHoldingLock:inst2,inst1
bradk003::::discAllAppls:inst1
bradk003::::discNoAppls:
bradk003::::discSelAppls:
bradk003::::discTopAppls:inst2
bradk003:DB2:inst1::discFilterParms:
bradk003:DB2:inst1::discNumAppls:
bradk003:DB2:inst1::MenuCmds.defaultAccount:patrol/patrol
bradk003:DB2:inst2::defaultAccount:patrol/patrol
bradk003:DB2:::AutoAckDiagLogOK:1
bradk003:DB2:::AutoAckProblemDB2Agents:1
bradk003:DB2:::ConfVarVer:6.7.10
bradk003:DB2:::DB_CONN_TIMEOUT:189
bradk003:DB2:::DB_filterList:inst1-SAMPLE1
bradk003:DB2:::KMSTATUS:UP
bradk003:DB2:::LOCK_TIMEOUT:188
bradk003:DB2:::filterList:inst2
bradk003:DB2:::remoteList:inst1
bradk003:DB2:::syscAlarmList:inst2
bradk003:DB2:::syscRecovList:inst1
bradk003:DB2:inst1::db2server_ok_filename:/data3/db2/databases/test.txt
bradk003:DB2:::tblspList:inst1-SAMPLE1,inst2-SAMPLE2
bradk003:DB2:inst1:SAMPLE1:TSPCHOICE:2
bradk003:DB2:inst1::DMSONLY:
bradk003:DB2:inst2:SAMPLE2:tblsp_to_discover:
bradk003:DB2:inst1::SPARE_CHANNEL:0
bradk003:DB2:inst1::TablespaceStateAlertList:200,800
bradk003:DB2:inst2::TablespaceStateWarnList:100,400
bradk003:DB2:inst1::araAction:57
bradk003:DB2:i nst1::conntodb_warn:SQL1116N,SQL1035N,SQL1032N
bradk003:DB2:inst1::current_agent_filename:/data2/db2/databases/inst1/db2kmapp.cur
bradk003:DB2:inst1::history_agent_filename:/data2/db2/databases/inst1/db2kmapp.hst
bradk003:DB2:inst1::db2version:9.7
bradk003:DB2:inst1::error_list:ALARM Database is damaged
bradk003:DB2:inst1::monitor_switches:16 b 1 l 1 so 1 st 1 t 1 u 1
bradk003::::DB2UDB_VER9_INSTALL_PATH:/opt/IBM/db2/V9.1/;/opt/IBM/db2/V9.7/
bradk003:DB2:inst1::discApplNames:
bradk003::::AgentAppEnableList:inst2,inst1
bradk003::::ForceAppHoldingLock:inst2,inst1
bradk003::::discAllAppls:inst1
bradk003::::discNoAppls:
bradk003::::discSelAppls:
bradk003::::discTopAppls:inst2
bradk003:DB2:inst1::discFilterParms:
bradk003:DB2:inst1::discNumAppls:
DB2 EEE sample batch configuration file
The following example illustrates a batch configuration file for the inst1 and inst2 instances in the DB2 UDB EEE environment. bradk003 represents the host and DB2EEE represents the DB2 UDB EEE environment.
Sample batch configuration file for the DB2 UDB EEE environment
bradk003:DB2EEE:inst2::defaultAccount:patrol/PATROL
bradk003:DB2EEE:inst2::MenuCmds.defaultAccount:patrol/PATROL
bradk003:DB2EEE:::AutoAckDiagLogOK:1
bradk003:DB2EEE:::AutoAckProblemDB2Agents:1
bradk003:DB2EEE:::DB_CONN_TIMEOUT:185
bradk003:DB2EEE:::DB_filterList:inst2-SAMPLE2
bradk003:DB2EEE:::KMSTATUS:UP
bradk003:DB2EEE:::LOCK_TIMEOUT:183
bradk003:DB2EEE:inst2:SAMPLE2:TSPCHOICE:1
bradk003:DB2EEE:inst2::DMSONLY:inst2-SAMPLE2
bradk003:DB2EEE:inst2::PortName:Pals
bradk003:DB2EEE:inst2::StartPortNum:77441
bradk003:DB2EEE:inst2::EndPortNum:77444
bradk003:DB2EEE:inst2::TablespaceStateAlertList:20,400
bradk003:DB2EEE:inst2::TablespaceStateWarnList:10,800
bradk003:DB2EEE:inst2::araAction:57
bradk003:DB2EEE:inst2::conntodb_warn:SQL1116N,SQL1035N,SQL1032N
bradk003:DB2EEE:inst2::current_agent_filename:/data1/db2/databases/inst2/db2kmapp.cur
bradk003:DB2EEE:inst2::db2server_ok_filename:db2/databases/test.txt
bradk003:DB2EEE:inst2::db2version:9.1
bradk003:DB2EEE:inst2::discNumAppls:2
bradk003:DB2EEE:inst2::error_list:ALARM Severe
bradk003:DB2EEE:inst2::history_agent_filename:/data1/db2/databases/inst2/db2kmapp.hst
bradk003:DB2EEE:inst2::monitor_switches:16 b 1 l 1 so 1 st 0 t 0 u 0
bradk003:DB2EEE:::filterList:inst2
bradk003:DB2EEE:::syscAlarmList:inst2
bradk003:DB2EEE:::syscRecovList:
bradk003:DB2EEE:::tblspList:inst2-SAMPLE2
bradk003:DB2EEE: inst2:SAMPLE1:tblsp_nodes_discover:
bradk003:DB2EEE:inst2:SAMPLE1:tblsp_to_discover:
bradk003:DB2EEE:inst2::suspend_disc_file:/data3/db2/databases/rons/test.txt
bradk003::::DB2UDB_VER9_INSTALL_PATH:/opt/IBM/db2/V9.1/;/opt/IBM/db2/V9.7/
bradk003:DB2EEE:inst2::discFilterParms:1
bradk003:DB2EEE:inst2::discApplNames:
bradk003::::AgentAppEnableList:inst2
bradk003::::ForceAppHoldingLock:inst2
bradk003::::discAllAppls:
bradk003::::discNoAppls:
bradk003::::discSelAppls:
bradk003::::discTopAppls:inst2
bradk003::::subagentList:inst2
bradk003:DB2EEE:inst2::MenuCmds.defaultAccount:patrol/PATROL
bradk003:DB2EEE:::AutoAckDiagLogOK:1
bradk003:DB2EEE:::AutoAckProblemDB2Agents:1
bradk003:DB2EEE:::DB_CONN_TIMEOUT:185
bradk003:DB2EEE:::DB_filterList:inst2-SAMPLE2
bradk003:DB2EEE:::KMSTATUS:UP
bradk003:DB2EEE:::LOCK_TIMEOUT:183
bradk003:DB2EEE:inst2:SAMPLE2:TSPCHOICE:1
bradk003:DB2EEE:inst2::DMSONLY:inst2-SAMPLE2
bradk003:DB2EEE:inst2::PortName:Pals
bradk003:DB2EEE:inst2::StartPortNum:77441
bradk003:DB2EEE:inst2::EndPortNum:77444
bradk003:DB2EEE:inst2::TablespaceStateAlertList:20,400
bradk003:DB2EEE:inst2::TablespaceStateWarnList:10,800
bradk003:DB2EEE:inst2::araAction:57
bradk003:DB2EEE:inst2::conntodb_warn:SQL1116N,SQL1035N,SQL1032N
bradk003:DB2EEE:inst2::current_agent_filename:/data1/db2/databases/inst2/db2kmapp.cur
bradk003:DB2EEE:inst2::db2server_ok_filename:db2/databases/test.txt
bradk003:DB2EEE:inst2::db2version:9.1
bradk003:DB2EEE:inst2::discNumAppls:2
bradk003:DB2EEE:inst2::error_list:ALARM Severe
bradk003:DB2EEE:inst2::history_agent_filename:/data1/db2/databases/inst2/db2kmapp.hst
bradk003:DB2EEE:inst2::monitor_switches:16 b 1 l 1 so 1 st 0 t 0 u 0
bradk003:DB2EEE:::filterList:inst2
bradk003:DB2EEE:::syscAlarmList:inst2
bradk003:DB2EEE:::syscRecovList:
bradk003:DB2EEE:::tblspList:inst2-SAMPLE2
bradk003:DB2EEE: inst2:SAMPLE1:tblsp_nodes_discover:
bradk003:DB2EEE:inst2:SAMPLE1:tblsp_to_discover:
bradk003:DB2EEE:inst2::suspend_disc_file:/data3/db2/databases/rons/test.txt
bradk003::::DB2UDB_VER9_INSTALL_PATH:/opt/IBM/db2/V9.1/;/opt/IBM/db2/V9.7/
bradk003:DB2EEE:inst2::discFilterParms:1
bradk003:DB2EEE:inst2::discApplNames:
bradk003::::AgentAppEnableList:inst2
bradk003::::ForceAppHoldingLock:inst2
bradk003::::discAllAppls:
bradk003::::discNoAppls:
bradk003::::discSelAppls:
bradk003::::discTopAppls:inst2
bradk003::::subagentList:inst2
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*