IBM Tivoli Monitoring for Virtual Environments, Version 7.2 Fix Pack 3

CSV format for data import and export

Data to be imported and exported must be kept in CSV format.

Table 1. CFG_PHYSICAL_SERVER for PowerVM®
COLUMN NAME DATA TYPE COLUMN LENGTH DETAILS
PHYSICAL_ SERVER_PK BIGINT   Primary key
SERVER_POOL _NAME VARCHAR 256 Currently not used
DATA_ CENTER_ NAME VARCHAR 256 Data center to which physical server belongs, default value "Default"
FQDN VARCHAR 256 Currently not used
HOST_NAME VARCHAR 256 Host name of Managed System
IP_ADDRESS VARCHAR 256 IP address of Managed System
MODEL VARCHAR 256 Model name, for example, POWER® 570, Power® 750
MODEL NAME VARCHAR 256 Human_Desired_Model for example 750-8233-E8B
MANUFACTURER VARCHAR 256 Name of manufacturing company, for example, IBM®
ARCHITECTURE VARCHAR 256 Currently not used
OPERATING_ SYSTEM_NAME VARCHAR 64 Operating system name, for example, Power Linux or AIX®
OPERATING_ SYSTEM_ VERSION VARCHAR 32 Operating system version, for example, 6.1 or 7.1
CPU_SPEED BIGINT   Processor speed in MHZ
CPU_CORES_INSTALLED BIGINT   Total CPU Installed
NUM_CPUS INTEGER   Number of cores Enabled
MEMORY_LIMIT BIGINT   Physical memory capacity in MB
MEMORY_ INSTALLED BIGINT   Currently not used
STATUS VARCHAR 256 Do not edit this column
HYPERVISOR_ VERSION VARCHAR 32 Hypervisor version, Currently not used
HYPERVISOR_ TYPE VARCHAR 64 Hypervisor Name, for example, Power
SERIAL_NUMBER VARCHAR 128 Serial number of Managed System
DATA_SOURCE VARCHAR 64 Do not edit this column
HMC_HOST_NAME VARCHAR 256 HOST NAME OF THE HMC SERVER
TAG TYPES
TAG TYPE DATA TYPE STRING LENGTH DETAILS
CUST_PRIMARY_ BU VARCHAR 50 Business unit with most significant dependency on this server
CUST_PRIMARY_ BUSINESS_APP VARCHAR 50 Business application with most significant dependency on this server
SERVER_ FUNCTION VARCHAR 50 Application, database, print server, or web server
ENVIRONMENT VARCHAR 50 Production, development, test, data management zone, or eminent security zone
CRITICALITY_ SLA VARCHAR 50 Business criticality or service level agreement info
CITY_CENTER VARCHAR 50 If multiple locations, city or data center name location of server or host
WORKINGSET VARCHAR 50 Flag indicating physical server is part of working set
Instructions:
  • Do not add any value to the MODEL_NAME column when you import the CSV for any new managed system.
  • Do not alter the content of the first column of the csv file, namely PHYSICAL_SERVER_PK.
  • Update the values in the rest of the columns only if the existing values are null or empty.
  • To add new servers, keep the values in the PHYSICAL_SERVER_PK column blank and add values in the rest of the columns.
  • The length of the input strings must not exceed the string length as shown.
  • You can add tags as new columns in the table.
  • You can add multiple tags of the same tag type with a ; separator. For example, you can add two tag names, PostPaid and PrePaid, of the same tag type, CUST_PRIMARY_BU, to a server by combining the tag names as PostPaid;PrePaid.
Table 2. CFG_PHYSICAL_SERVER for VMware
COLUMN NAME DATA TYPE COLUMN LENGTH DETAILS
PHYSICAL_ SERVER_PK BIGINT   Primary key
SERVER_POOL _NAME VARCHAR 256 Name of server pool if a hierarchy exists
DATA_ CENTER_ NAME VARCHAR 256 Data center to which physical server belongs
FQDN VARCHAR 256 Fully qualified host name
HOST_NAME VARCHAR 256 Host name of physical server
IP_ADDRESS VARCHAR 256 IP address of physical server
MODEL VARCHAR 256 Model name, for example, SUN-FIRE-V240 or POWER 570
MANUFACTURER VARCHAR 256 Name of manufacturing company, for example, IBM, HP, or DELL
ARCHITECTURE VARCHAR 256 System Architecture, for example, SUN4 or POWER
OPERATING_ SYSTEM_NAME VARCHAR 64 Operating system name, for example, Linux or Windows
OPERATING_ SYSTEM_ VERSION VARCHAR 32 Operating system version
CPU_SPEED BIGINT   Processor speed in MHZ
NUM_CPUS INTEGER   Number of cores
MEMORY_LIMIT BIGINT   Physical memory capacity in MB
MEMORY_ INSTALLED BIGINT   Currently not used
STATUS VARCHAR 256 Do not edit this column
HYPERVISOR_ VERSION VARCHAR 32 Hypervisor version, for example, 3.5 U3 for VMware
HYPERVISOR_ TYPE VARCHAR 64 Hypervisor Name, for example, pHyp or VMware ESX
BIOS_DATE DATE   BIOS date of server
DATA_SOURCE VARCHAR 64 Do not edit this column
TAG TYPES
TAG TYPE DATA TYPE STRING LENGTH DETAILS
CUST_PRIMARY_ BU VARCHAR 50 Business unit with most significant dependency on this server
CUST_PRIMARY_ BUSINESS_APP VARCHAR 50 Business application with most significant dependency on this server
SERVER_ FUNCTION VARCHAR 50 Application, database, print server, or web server
ENVIRONMENT VARCHAR 50 Production, development, test, data management zone, or eminent security zone
CRITICALITY_ SLA VARCHAR 50 Business criticality or service level agreement info
CITY_CENTER VARCHAR 50 If multiple locations, city or data center name location of server or host
WORKINGSET VARCHAR 50 Flag indicating physical server is part of working set
TYPE VARCHAR 50 Candidate type indicating whether a physical server is Source or Target
Instructions:
  • Do not alter the content of the first column of the csv file, namely PHYSICAL_SERVER_PK.
  • Update the values in the rest of the columns only if the existing values are null or empty.
  • To add new servers, keep the values in the PHYSICAL_SERVER_PK column blank and add values in the rest of the columns.
  • The length of the input strings must not exceed the string length as shown.
  • You can add tags as new columns in the table.
  • You can add multiple tags of the same tag type with a ; separator. For example, you can add two tag names, PostPaid and PrePaid, of the same tag type, CUST_PRIMARY_BU, to a server by combining the tag names as PostPaid;PrePaid.
Table 3. CFG_VIRTUAL_MACHINE for PowerVM
COLUMN NAME DATA TYPE COLUMN LENGTH DETAILS
VIRTUAL_ MACHINE_PK BIGINT   Primary key
SHARED_MODE VARCHAR 32 Logical Partition CPU sharing Mode
CAPPED_MODE VARCHAR 32 Logical Partition CPU Capping Mode
PS_HOST_ NAME VARCHAR 256 Host name of Managed System
VMID VARCHAR 256 Currently Not Used
HOST_NAME VARCHAR 256 Host name of Logical Partition
IP_ADDRESS VARCHAR 256 IP address of Logical Partition
FQDN VARCHAR 256 Currently Not Used
MEMORY_ SIZE BIGINT   Memory currently allcoated to LPAR
OPERATING_ SYSTEM_NAME VARCHAR 256 Name of operating system
OPERATING_ SYSTEM_ VERSION VARCHAR 256 Operating system version
MIDDLEWARE _NAME VARCHAR 256 Middleware name
MIDDLEWARE _VERSION VARCHAR 256 Middleware version
DATA_SOURCE VARCHAR 64 Source of configuration data of virtual machine. Do not edit this information.
PHYSICAL_ SERVER_PK BIGINT   Physical server primary key
VM_NAME VARCHAR 256 Display name of Logical Partition
WORKINGSET VARCHAR 50 Flag indicating that virtual machine is part of working set
VIOS_STORAGE_NAME y STORAGE_PROTECTION VARCHAR 128 VARCHAR 256 VIO Partition name providing storage to the LPAR
VIOS_NETWORK_NAME VARCHAR 256 VIO Partition name providing network to the LPAR
VIOS_STORAGE_VIRT_MC_PK BIGINT   VIO Partition for Storage primary key
VIOS_NETWORK_VIRT_MC_PK BIGINT   VIO Partition for Network primary key
STORAGE_ASSIGNED DOUBLE     Storage space assigned in MB to LPAR
STORAGE_CONSUMED DOUBLE     Storage space consumed in MB to LPAR
STORAGE_PROTECTION VARCHAR 128 Currenly Not used
CITY_CENTER VARCHAR 50 If multiple locations, city or data center name location of server or host
CRITICALITY_SLA VARCHAR 50 Business criticality or service level agreement info
CUST_PRIMARY_BU VARCHAR 50 Business unit with most significant dependency on this server
CUST_PRIMARY_BUSINESS_APP VARCHAR 50 Business application with most significant dependency on this server
ENVIRONMENT VARCHAR 50 Production, development, test, data management zone, or eminent security zone
SERVER_FUNCTION VARCHAR 50 Application, database, print server, or web server
Instructions:
  • Do not alter the content of the first column of the csv file, namely VIRTUAL_MACHINE_PK.
  • Update the values in the rest of the columns only if the existing values are null or empty.
  • To add new servers, keep the values in the VIRTUAL_MACHINE_PK column blank and add values in the rest of the columns.
  • The length of the input strings must not exceed the string length as shown.
  1. When you import any LPAR, if VIO is not added on the Managed System in the database, you must not use any VIO name or VIOS_STORAGE_VIRT_MC_PK / VIOS_NETWORK_VIRT_MC_PK
  2. You can import VIO with the Logical Partition import or export.
  3. To import VIO, set the OS Type to VIOS.
  4. Before you complete the association of the VIO and the LPAR, ensure that the VIO Partition details imported successfully.
Table 4. CFG_VIRTUAL_MACHINE for VMware
COLUMN NAME DATA TYPE COLUMN LENGTH DETAILS
VIRTUAL_ MACHINE_PK BIGINT   Primary key
PS_HOST_ NAME VARCHAR 256 Host name of physical server
VMID VARCHAR 256 ID of the virtual machines
HOST_NAME VARCHAR 256 Host name of virtual machine
IP_ADDRESS VARCHAR 256 IP address of virtual machine
FQDN VARCHAR 256 Fully qualified domain name
CPU_MIN BIGINT   CPU reservation
CPU_MAX BIGINT   CPU limit
CPU_DESIRED BIGINT   Currently not used
MEMORY_MIN BIGINT   Memory reservation
MEMORY_MAX BIGINT   Currently not used
MEMORY_ DESIRED BIGINT   Currently not used
OPERATING_ SYSTEM_NAME VARCHAR 256 Name of operating system
OPERATING_ SYSTEM_ VERSION VARCHAR 256 Operating system version
MIDDLEWARE _NAME VARCHAR 256 Middleware name
MIDDLEWARE _VERSION VARCHAR 256 Middleware version
DATA_SOURCE VARCHAR 64 Source of configuration data of virtual machine. Do not edit this information.
PHYSICAL_ SERVER_PK BIGINT   Physical server primary key
VM_NAME VARCHAR 256 Display name of virtual machine
WORKINGSET VARCHAR 50 Flag indicating that virtual machine is part of working set
CITY_CENTER VARCHAR 50 If multiple locations, city or data center name location of server or host
CRITICALITY_SLA VARCHAR 50 Business criticality or service level agreement info
CUST_PRIMARY_BU VARCHAR 50 Business unit with most significant dependency on this server
CUST_PRIMARY_BUSINESS_APP VARCHAR 50 Business application with most significant dependency on this server
ENVIRONMENT VARCHAR 50 Production, development, test, data management zone, or eminent security zone
SERVER_FUNCTION VARCHAR 50 Application, database, print server, or web server
Instructions:
  • Do not alter the content of the first column of the csv file, namely VIRTUAL_MACHINE_PK.
  • Update the values in the rest of the columns only if the existing values are null or empty.
  • To add new servers, keep the values in the VIRTUAL_MACHINE_PK column blank and add values in the rest of the columns.
  • The length of the input strings must not exceed the string length as shown.

Feedback