IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Agent Installation Guides > Warehouse Summarization and Pruning 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 (DBTYPE)
- 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 (KSY_WAREHOUSE_TYPE)
- Database Type
The valid values include "DB2", "ORACLE", "MSSQL" when using addSystem and configureSystem CLIs.
This value is required.
Default value: DB2
- Sources (SOURCES)
- Sources 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.
- JDBC JARs List (KSY_WAREHOUSE_JARS)
- Fully qualified paths to JDBC JAR files (comma separated)
The type is string.
This value is required.
Default value: None
- JDBC URL (KSY_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 Summarization and Pruning agents that are installed on operating systems other than Windows.
Default value: jdbc:db2://localhost:50000/WAREHOUS.
- JDBC Driver (KSY_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 Summarization and Pruning agents that are installed on operating systems other than Windows.
Default value: com.ibm.db2.jcc.DB2Driver.
- JDBC URL (KSY_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 Summarization and Pruning agents that are installed on operating systems other than Windows.
Default value: jdbc:oracle:thin:@server:port:database.
- JDBC Driver (KSY_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 Summarization and Pruning agents that are installed on operating systems other than Windows.
Default value: oracle.jdbc.driver.OracleDriver.
- JDBC Driver (KSY_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 Summarization and Pruning agents that are installed on operating systems other than Windows.
Default value: com.microsoft.sqlserver.jdbc.SQLServerDriver.
- JDBC URL (KSY_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 Summarization and Pruning agents that are installed on operating systems other than Windows.
Default value: jdbc:sqlserver://server:port;databasename=database;SelectMethod=cursor.
- Warehouse user (KSY_WAREHOUSE_USER)
- The Warehouse user
The type is string.
This value is required.
Default value: None
- Warehouse Password (KSY_WAREHOUSE_PASSWORD)
- The Warehouse password
The type is password.
This value is required.
Default value: None
- TEPS Server Host (KSY_CNP_SERVER_HOST)
- The TEPS hostname
The type is string.
This value is required.
Default value: localhost
- TEPS Server Port (KSY_CNP_SERVER_PORT)
- The TEPS port (default 1920)
The type is numeric.
This value is required.
Default value: 1920
- Reporting (TRAM)
- Reporting Integration
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.
- Enable Reporting Integration (KSY_TRAM_ENABLE)
- Flag that indicates whether reporting integration is enabled or not. If enabled the Time Dimension tables are created with the schema IBM_TRAM. Allowed values are Y for yes, N for no.
The type is restricted.
The value is required.
Default value: N
- Reporting User (KSY_DB2_TRAM_USER)
- Reporting user that will create the time dimension tables.
The type is string.
The value is not required.
- Reporting User (KSY_ORACLE_TRAM_USER)
- Reporting user that will create the time dimension tables.
The type is string.
The value is not required.
Default value: IBM_TRAM
- Reporting User (KSY_MSSQL_TRAM_USER)
- Reporting user that will create the time dimension tables.
The type is string.
The value is not required.
Default value: IBM_TRAM
- Reporting Password (KSY_TRAM_PASSWORD)
- The reporting password.
The type is password.
The value is not required.
- Time Dimension Granularity (Minutes) (KSY_TRAM_TD_GRANULARITY)
- Controls the granularity of TIME_DIMENSION data load in minutes.
The type is numeric.
The value is required.
Default value: 5
Minimum value: 1
- Time Dimension Initial Amount (Months) (KSY_TRAM_TD_INITIAL_LOAD)
- Amount of data to be initially loaded in the TIME_DIMENSION table, in months.
The type is numeric.
The value is required.
Default value: 24
Minimum value: 1
- Scheduling (SCHEDULING)
- Scheduling 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.
- Fixed Schedule (KSY_FIXED_SCHEDULE)
- If fixed scheduling is in use. Allowed values are Y for yes, N for no.
The type is restricted.
The value is required.
Default value: Y
- Every N days (KSY_EVERY_N_DAYS)
- The number of days between runs (default is 1)
The type is numeric.
This value is required.
Default value: 1
- Hour to run (KSY_HOUR_TO_RUN)
- The fixed hour to run (valid values are 0-12, default is 2)
The type is numeric.
This value is required.
Default value: 2
- Minute to run (KSY_MINUTE_TO_RUN)
- The fixed minute to run (default is 0)
The type is numeric.
This value is required.
Default value: 0
- AM/PM (KSY_HOUR_AM_PM)
- AM or PM
The type is restricted.
This value is required.
Default value: AM
- Every N minutes (KSY_EVERY_N_MINS)
- Minutes between flexible runs
The type is numeric.
This value is required.
Default value: 60
- Blackout (KSY_BLACKOUT)
- Exception times in HH:MM-HH:MM format (24 hour clock), comma separated when flexible scheduling shouldn't run
The type is string.
This value is optional.
- Work Days (WORK)
- Work Days 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.
- Week starts on (KSY_START_OF_WEEK_DAY)
- The day the week starts (default is Sunday). Valid values are 0 and 1. 0 = Sunday, 1 = Monday.
The type is restricted.
This value is required.
Default value: 0
- Off Peak Shift Hours (KSY_SHIFT1_HOURS)
- Off peak shift hours, comma separated
The type is string.
This value is required.
Default value: 0,1,2,3,4,5,6,7,8,18,19,20,21,22,23
- Peak Shift Hours (KSY_SHIFT2_HOURS)
- Peak shift hours, comma separated
The type is string.
This value is required.
Default value: 9,10,11,12,13,14,15,16,17
- Count weekends as vacation (KSY_WEEKENDS_AS_VACATIONS)
- Whether to consider weekends as vacation days (default is Yes). Allowed values are Y for yes and N for no.
The type is restricted.
This value is required.
Default value: Y
- Vacation days (KSY_VACATION_DAYS)
- Vacation days (YYYYMMDD format), comma separated
The type is string.
This value is optional.
- Log Settings (LOG)
- Log Settings 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.
- Prune WAREHOUSELOG (KSY_WAREHOUSELOG_PRUNE)
- Specify whether the WAREHOUSELOG table will be pruned. Format is nnn.unit where nnn is the number of units and unit is day, month or year. Specify blank to not prune the table.
The type is string.
This value is optional.
- Prune WAREHOUSEAGGREGLOG (KSY_WAREHOUSEAGGREGLOG_PRUNE)
- Specify whether the WAREHOUSEAGGREGLOG table will be pruned. Format is nnn.unit where nnn is the number of units and unit is day, month or year. Specify blank to not prune the table.
The type is string.
This value is optional.
- Additional Settings (ADDITIONAL)
- Additional Settings 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.
- Number of worker threads (KSY_MAX_WORKER_THREADS)
- The number of worker threads to be used
The type is numeric.
This value is required.
Default value: 2
- Maximum rows per database transaction (KSY_MAX_ROWS_PER_TRANSACTION)
- The maximum number of rows per transaction (effective size is this value divided by number of worker threads)
The type is numeric.
This value is required.
Default value: 1000
- Use timezone offset from (KSY_TIMEZONE_IND)
- Which timezone to use when aggregating the data: agent or warehouse (default is agent)
The type is restricted.
This value is required.
Default value: agent
- Aggregate hourly data older than (KSY_HOUR_AGE_UNITS)
- The minimum age for hourly data to be aggregated (default is 1)
The type is numeric.
This value is required.
Default value: 1
- Aggregate daily data older than (KSY_DAY_AGE_UNITS)
- The minimum age for daily data to be aggregated (default is 0)
The type is numeric.
This value is required.
Default value: 0
- Maximum number of node errors to display (KSY_NODE_ERROR_UNITS)
- The number of errors to keep in memory (default is 10)
The type is numeric.
This value is required.
Default value: 10
- Maximum number of Summarization and Pruning runs to display (KSY_SUMMARIZATION_UNITS)
- The number of summarization runs to keep in memory (default is 10)
The type is numeric.
This value is required.
Default value: 10
- Database Connectivity Cache Time (minutes) (KSY_CACHE_MINS)
- The number of minutes to cache the database status (default is 10)
The type is numeric.
This value is required.
Default value: 10
- Batch mode (KSY_BATCH_MODE)
- The type of batching to be used (default is single system). Allowed values are 0 for single system, 1 for multiple system.
The type is restricted.
This value is optional.
Default value: 0
- Database Compression (KSY_DB_COMPRESSION)
- Enable database compression, if supported (default is no)
The type is restricted.
This value is required.
Default value: N
- Database Table Partitioning (KSY_PARTITION)
- Enable the usage of table partitioning, if supported. Allowed values are Y for yes, N for no.
The type is restricted.
This value is required.
Default value: N
- Number of future partitions to maintain (KSY_PARTITIONS_UPWARD)
- Define the number of partitions in the future that should be created. For detailed, hourly and daily, the value is in days. For other aggregations, it is the number of units in that aggregation granularity. Valid values are between 1 and 10.
The type is numeric.
This value is required.
Default value: 10
- Group by threshold (days) (KSY_GROUP_BY_THRESHOLD)
- Define the number of days that should be used when discovering agents on a given table. Valid values are between 0 and 30 days. Weekly and above aggregated tables will always use 2 if the value defined is not 0. A value of 0 means to scan the entire table.
The type is numeric.
This value is required.
Default value: 0
- Default table container (KSY_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. Only supported for DB2 Linux/UNIX/Windows,and Oracle.
The type is string.
This value is optional.
Default value: None
- Default index container (KSY_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. Only supported for DB2 Linux/UNIX/Windows,and Oracle.
The type is string.
This value is optional.
Default value: None
Parent topic:
Agent installation and configuration