IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Agent Installation Guides > Warehouse Proxy Agent Installation Guide > Agent installation and configuration
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
Configuration values
For both local and remote configuration, you provide the configuration values for the agent to operate.
When you are configuring an agent, a panel is displayed so you can enter each value. When a default value exists, this value is pre-entered into the field. If a field represents a password, two entry fields are displayed. You must enter the same value in each field. The values you type are not displayed to help maintain the security of these values.
The configuration for this agent is organized into the following groups:
- Database Type (KHD_DB_TYPE)
- Choose the database type
The configuration elements defined in this group are always present in the agent's configuration.
This group defines information that applies to the entire agent.
- Database (KHD_DBMS)
- Database Type
The valid values include "DB2", "ORACLE", "MSSQL" when using addSystem and configureSystem CLIs.
This value is required.
Default value: DB2
- Agent Parameters (KHD_PARMS)
- Agent Parameters Details
The configuration elements defined in this group are always present in the agent's configuration.
This group defines information that applies to the entire agent.
- Use Batch (KHD_BATCH_USE)
- Batch Database Operations
The type is checkbox.
This value is optional.
Default value: true
- JDBC Driver (KHD_DB2_JDBCDRIVER)
- The Warehouse JDBC Driver when connecting to a DB2 Linux/UNIX/Windows, or DB2 z/OS database
The type is string.
This value is required. This setting is only valid for Warehouse Proxy agents that are installed on operating systems other than Windows
Default value: For All UNIX and Linux Operating Systems: com.ibm.db2.jcc.DB2Driver.
- JDBC URL (KHD_DB2_JDBCURL)
- The Warehouse JDBC URL when connecting to a DB2 Linux/UNIX/Windows, or DB2 z/OS database
The type is string.
This value is required. This setting is only valid for Warehouse Proxy agents that are installed on operating systems other than Windows
Default value: For All UNIX and Linux Operating Systems: jdbc:db2://localhost:50000/WAREHOUS.
- Database Compression (KHD_DB_COMPRESSION)
- Database Compression option
The type is checkbox.
This value is optional.
Default value: false
- JDBC Driver (KHD_MSSQL_JDBCDRIVER)
- The Warehouse JDBC Driver when connecting to a Microsoft SQL Server database
The type is string.
This value is required. This setting is only valid for Warehouse Proxy agents that are installed on operating systems other than Windows
Default value: For All UNIX and Linux Operating Systems: com.microsoft.sqlserver.jdbc.SQLServerDriver.
- JDBC URL (KHD_MSSQL_JDBCURL)
- The Warehouse JDBC URL when connecting to a Microsoft SQL Server database
The type is string.
This value is required. This setting is only valid for Warehouse Proxy agents that are installed on operating systems other than Windows
Default value: For All UNIX and Linux Operating Systems: jdbc:sqlserver://server:port;databasename=database;SelectMethod=cursor.
- ODBC DSN (KHD_ODBC_DSN)
- The data source name used by the Warehouse Proxy agent
The type is string.
This value is required. This setting is only valid for Warehouse Proxy agents that are installed on Windows operating systems.
Default value: For All Windows Operating Systems: ITM Warehouse.
- JDBC Driver (KHD_ORACLE_JDBCDRIVER)
- The Warehouse JDBC Driver when connecting to an Oracle database
The type is string.
This value is required. This setting is only valid for Warehouse Proxy agents that are installed on operating systems other than Windows.
Default value: For All UNIX and Linux Operating Systems: oracle.jdbc.driver.OracleDriver.
- JDBC URL (KHD_ORACLE_JDBCURL)
- The Warehouse JDBC URL when connecting to an Oracle database
The type is string.
This value is required. This setting is only valid for Warehouse Proxy agents that are installed on operating systems other than Windows.
Default value: For All UNIX and Linux Operating Systems: jdbc:oracle:thin:@server:port:database.
- Warehouse Compression for Distributed Sources (KHD_SERVER_DIST_COMPRESSION_ENABLE)
- Enable the compression of historical data from distributed sources before upload to the Warehouse Proxy Server
The type is checkbox.
This value is optional.
Default value: true
- Warehouse Compression for Z/OS Sources (KHD_SERVER_Z_COMPRESSION_ENABLE)
- Enable the compression of historical data from Z/OS sources before upload to the Warehouse Proxy Server
The type is checkbox.
This value is optional.
Default value: false
- JDBC JARs List (KHD_WAREHOUSE_JARS)
- Fully qualified paths to JDBC JAR files (comma separated)
The type is string.
This value is required.
Default value: None
- Password (KHD_WAREHOUSE_PASSWORD)
- The Warehouse database user password
The type is password.
This value is required.
Default value: None
- Warehouse TEMS List (KHD_WAREHOUSE_TEMS_LIST)
- Space or comma separated list of Tivoli Enterprise Monitoring Server instances served by this Warehouse Proxy agent. *ANY can be specified if this Warehouse Proxy agent will export data of any agents connected to any TEMS. If the list is left blank, this Warehouse Proxy agent will be the default Warehouse proxy agent.
The type is string.
This value is optional.
Default value: None
- Username (KHD_WAREHOUSE_USER)
- The Warehouse database username
The type is string.
This value is required.
Default value: ITMUSER
- Database Table Partitioning (KHD_PARTITION)
- Enable the usage of table partitioning, if supported.
The type is checkbox.
This value is required.
Default value: false
- Number of future partitions to maintain (KHD_PARTITIONS_UPWARD)
- Define the number of partitions in the future that should be created. Valid values are between 1 and 10.
The type is numeric.
This value is required.
Default value: 10
- Default table container (KHD_DEFAULT_TABLE_CONTAINER)
- Define the default table container which should be used when creating new tables. The value must follow the naming rules of the database system being used. A blank value causes the database to select the container in which the table will be created.
The type is string.
This value is optional.
Default value: None
- Default index container (KHD_DEFAULT_INDEX_CONTAINER)
- Define the default index container which should be used when creating new tables. Use this to place indices in a separate container from tables. The value must follow the naming rules of the database system being used. For DB2, if indices are stored in a separate tablespace from the table data, both the table and index containers must be Database Managed Tablespaces.
The type is string.
This value is optional.
Default value: None
Parent topic:
Agent installation and configuration