Editing knowledge base
Knowledge base data consists of rules, the server model catalog, user-defined benchmark values, and virtualization overhead values. This data that is loaded into the Capacity Planner can be adjusted as the environment requires.
The sample files that are loaded by default during installation
are available in CSV format in the following
directories:
- For Tivoli® Integrated Portal V2.1: TIP_HOME/ITMFVSDash/dbinstaller/samples/
- For Dashboard Application Services Hub:
- Windows systems: C:\Program Files\IBM\JazzSM\installedDashboards\com.ibm.tivoli.cpdash\AnalyticsDatabaseInstaller\samples
- Operating systems other than Windows: /opt/IBM/JazzSM/installedDashboards/com.ibm.tivoli.cpdash/AnalyticsDatabaseInstaller/samples
- Rules
- See Importing rules in Capacity Planner.
- Server Model Catalog
- This file contains the server models that are listed in the Add
Physical Server window. If you must make changes to the
models available for adding new servers, this file can be modified.
Use the file format in Table 1.The following entry is a sample:
Table 1. Server Model Catalog Column name Maximum column length Details SERVER_MODEL_CATALOG_PK 19 This column must be blank. MODEL_DESCRIPTION 50 Description of the model. This column can be blank. VENDOR 20 Model vendor. This column can be blank. MODEL 50 Model name, for example, System X3550. PROCESSOR 50 Processor Family, for example, Intel Xeon E5335. PROCESSOR_SPEED_MHZ 10 Processor speed in MHz. PROCESSOR_CHIPS 10 Number of processor chips. This column can be blank. PROCESSOR_CORES 10 Number of processor cores. ,,IBM,System X3200,Intel Xeon X3210,,,4 - USER_DEFINED_BENCHMARK.csv
- This file contains the benchmark values for the server models.
These values are used to match comparative benchmarks for the server
models and the result of the matching is displayed in the Status column
in the Physical Server Inventory view. Use the
file format in Table 2.The following entry is a sample:
Table 2. User-defined benchmark Column name Maximum column length Details USER_DEFINED_BENCHMARK_PK 19 This column must be blank. VENDOR 20 Server vendor. This column can be blank. SERVER_DESCRIPTION 50 Server description. This column can be blank. FAMILY 20 Server family. This column can be blank. PROCESSOR 128 System name with Processor architecture, for example, IBM® System x3550 M3 (Intel Xeon X5650). PROCESSOR_SPEED_MHZ 10 (Integer) Processor speed. This column can be blank. PROCESSOR_CHIPS 10 (Integer) Number of processor chips. PROCESSOR_CORES 10 (Integer) Number of processor cores CPU_BENCHMARK_CAPACITY 19 (Integer) Benchmark value. The value can be 0 - 100000. CPU_OLTP_BENCHMARK_CAPACITY 19 Currently not used. OS 50 Operating system. This column can be blank. DATE 10 Currently not used. This column must be blank. UVALUES 10 (Integer) Currently not used. This column must be blank. HEIGHT_MM 10 Currently not used. This column must be blank. WIDTH_MM 10 Currently not used. This column must be blank. DEPTH_MM 10 Currently not used. This column must be blank. MAX_HEAT_BTU 19 Currently not used. This column must be blank. MAX_POWER_WATTS 19 Currently not used. This column must be blank. NOTES 50 Currently not used. This column must be blank. MODEL 50 Currently not used. This column must be blank. ,,,,IBM Corporation IBM BladeCenter HS21 XM (Intel Xeon E5430),,1,8,21200 ,,,,,,,,,,, - CUSTOM_USER_DEFINED_BENCHMARK.csv
- You can use the CUSTOM_USER_DEFINED_BENCHMARK.csv file to supplement the benchmark data of the Capacity Planner with your environment specific physical server models and the benchmark data. The data loaded using the CUSTOM_USER_DEFINED_BENCHMARK.csv file is searched on precedence to the built-in benchmark data. The search result is displayed in the Status column in the Physical Server Inventory view.
- The built-in benchmark database of Capacity Planner contains some benchmark values for some types of physical servers. While loading knowledge base data for benchmark if you choose Benchmark to upload the knowledge base, the built-in benchmark database is overwritten by the values that are uploaded. If this is not wanted, upload the created benchmark csv file using Custom Benchmark. The benchmarks uploaded through Custom Benchmark are giving preference over the built-in benchmark database entries while finding a matching performance benchmark for the physical server.
- For more information about uploading a custom benchmark file,
see Uploading custom benchmark file in Capacity Planner.Note: The CUSTOM_USER_DEFINED_BENCHMARK.csv file and the USER_DEFINED_BENCHMARK.csv file have similar file format.
- VIRTUALIZATION_OVERHEAD.csv
- This file contains the virtualization overhead values that are
used in optimization generation. These values are by default set to
10% of CPU, memory, network bandwidth, and storage I/O resources.
These values can be modified and loaded to the Capacity Planner as
needed by the environment. Use the file format inTable 3.
Table 3. Virtualization overhead Column name Maximum column length Details VIRTUALIZATION_OVERHEAD_PK 8 This column must be blank. HYPERVISOR_TYPE 64 Hypervisor type, for example, VMware ESX. HYPERVISOR_VERSION 64 Hypervisor version. CPU_CORES_RANGE_LOWER 4 (Integer) Lower limit for CPU cores range for which the overhead applies. CPU_CORES_RANGE_UPPER 4 (Integer) Upper limit for CPU cores range for which the overhead applies. PERCENTAGE_CPU_OVERHEAD 4 (Integer) CPU overhead value (percentage). PERCENTAGE_MEMORY_OVERHEAD 4 (Integer) Memory overhead value (percentage). PERCENTAGE_NETWORK_OVERHEAD 4 (Integer) Currently not used. PERCENTAGE_INTERNAL_DISK_OVERHEAD 4 (Integer) Currently not used. PERCENTAGE_DISK_IO_OVERHEAD 4 (Integer) Currently not used. APPLICATION_TYPE 30 Currently not used.