Managing Host Data Collection > Loading Host and WWN Relationships
Version 9.1
Loading Host and WWN Relationships
In environments with firewall restrictions, Capacity Manager Host Resources data cannot be collected. APTARE provides a utility for manually loading host and Worldwide Name relationships (a unique identifier used in storage technologies) into the Portal database so that this limited information can be included in the standard Capacity Manager reports.
This utility takes a comma-separated values (CSV) file as input and populates database tables so that the Host Bus Adapter (HBA) data is available in reports.
Loading the Host HBA Port Data
This utility provides an bulk-load method for populating the database with host data.
Create a CSV File
In preparation for loading host data, enter the information into a spreadsheet from which you will create a comma-separated file.
The table in the spreadsheet should be in the following format:
first column - host name
second column - node WWN
third column - port WWN
Table 3: Example of Host WWN CSV File
test_host, 50:06:0E:80:05:63:B7:20, 50:06:0E:80:05:63:B7:21
Execute the Script
To load host HBA port data
1. Create a table in a spreadsheet, as shown in the above example. Save the table as a comma-separated file (for example, hostWWN.csv).
2. Log on to the Portal Server as user aptare.
3. At the command prompt, type: sqlplus <pwd>/<pwd>
4. Execute the following at the SQL prompt:
SQL> Execute srm_load_pkg.loadHBAPortFile(‘<domainName>, ‘<isIncremental>’, ‘<CSVfile>’, ‘<logPathname>’, ‘<logFilename>’, [, ‘<source_name>’]);
StorageConsole domain name (enclosed in single straight quotes)
‘Y’ or ‘N’ (enclosed in single straight quotes) to indicate if it is an incremental load.
If ‘Y’, an HBA port record will be created if none exists.
If ‘N’, the old HBA port record will be deleted first and then a new one created.
CSV file path and name (enclosed in single straight quotes)
Log path name (enclosed in single straight quotes)
Log file name (enclosed in single straight quotes)
source_name is an optional, case-insensitive string, up to 100 characters, representing the source of the host details; for example, CMDB might be relevant for a change management database. This source information is retained for historical purposes, to track how the host was added to the database. If nothing or NULL is provided for this parameter, HBA CSV Load will be inserted as the source into the reporting database.
Execute srm_load_pkg.loadHBAPortFile(‘corpHost1’, Y, /tmp/hba_port_data.txt’,
/tmp’, ‘hba_port_data.log’, ‘CMDB’);
5. IMPORTANT: If you created a new source_name, you need to insert it into the custom host source ranking table using the instructions provided in Setting a Host’s Priority.