Load port attributes and values

Function: The Load Port Attributes utility provides an efficient method of assigning attributes to a large number of ports. Please note Fabric Manager must be installed or the loading will fail.

To load port attributes and values:

Create a CSV file of Ports, Attributes and Values.
Execute the Load Port Attribute Utility.
Verify the Port Attributes Load.
Create a report template using the SQL Template Designer.

Once attribute values are assigned to application databases, a SQL Template Designer report can query the database to report on the application databases.

Create a CSV file of Ports, Attributes, and Values

The loadPortAttributeFile utility assigns attribute values to a list of switches. This utility takes as input a comma-separated values (CSV) file.

Note:

This CSV file becomes the master document of record for Port Attributes and therefore must be preserved in a working directory for future updates.

Create a spreadsheet table, in the format shown in the following example, and save it as a CSV file in a working directory. This file is specific to loading port attributes.

Columns:

The first column lists the Fabric Identifier.
The second column lists the Switch Identifier.
The third column lists the Port Element Name.
Each additional column lists attributes and values that will be applied to the port. Multiple attributes can be assigned to a single port object.

Rows:

First (Header) Row - Contains the fields that uniquely identify the Fabric Identifier Name, Switch Identifier, Port element name followed by Attribute names. The header row is information only and is not processed as a data row.
Subsequent rows list the Fabric Identifier, Switch Identifier, Port element name followed by the attribute values that you assign to each port.

Execute the Load Ports Attribute Utility

Before you begin, Bulk Load utility must be run in SQLPLUS as APTARE user.

The load_package utility is located in:

Linux: /opt/aptare/database/stored_procedures
Windows: \opt\oracle\database\stored_procedures

To assign attributes to application databases

Create a table in a spreadsheet.
Save the table as a comma-separated file (for example, PortAttributes.csv).
Log in to the portal server.
At the command line:
```
su -aptare
```

At the command line, launch sqlplus:

sqlplus <pwd>/<pwd>@//localhost:1521/scdb

Example:

sqlplus portal/portal@//localhost:1521/scdb

Execute the following at the SQL prompt:

SQL> Execute load_package.loadPortAttributeFile ('pathname_and_filename','domain_name',
Fabric_identifier_col_num, switch_identifier_col_num, port_ele_name_col_num,  'log_path_name', 'log_file_name','check_valid_value');

Example:

SQL> Execute load_package.loadPortAttributeFile('/tmp/portAttributes.csv', 'DomainEMEA', 1, 2,3,'/tmp/logs','portAttributes.log','Y');

Where:

pathname_and_filename	Full path + filename (enclosed in single straight quotes) of the CSV file. Windows example: '`c:\temp\PortAttributes.csv`' Linux example: '`/tmp/PortAttributes.csv`'
domain_name	Name (enclosed in single straight quotes) of the domain in which the ports reside. Example: 'DomainEMEA'
Fabric_identifier_col_num	Column number in the CSV file where the Fabric Identifier is listed; Example: 1
switch_identifier_col_num	Column number in the CSV file where the Switch Identifier is listed; Example: 2
port_ele_name_col_num	Column number in the CSV file where the Port Element Name is listed; Example: 3
log_path_name	Full path (enclosed in single straight quotes) where the log file will be created/updated; verify that you have write access to this directory. Optional: If a log path and filename are not specified, log records are written to scon.log and scon.err. To omit this parameter, enter: Example: 'c:\temp' or '/tmp'
log_file_name	Log file name enclosed in single straight quotes. Optional: If a log path and filename are not specified, entries are written to `scon.log` and `scon.err`. To omit this parameter, enter: '' Example: '`PortAttributes.log`'
check_valid_value	'Y' or 'N' - enclosed in single straight quotes. Y - Checks if the attribute value exists. If the utility determines that the attribute value is not valid, it skips this row and does not assign the attribute value to the switch object. N - Updates without checking that the attribute value exists. This option is seldom chosen, but it is available for certain customer environments where attributes may have been created without values (with scripts that bypass the user interface).

Check the log file for status and errors.
Restart the portal services so that the newly added attributes become available in the product.

Verify the Port Attributes Load

To verify that the attribute load was successful:

In the portal, go to Reports.
Select a blue user folder.
Select New SQL Template.
With the SQL Template Designer open, click the Query tab.
Enter the following query in the SQL Template Designer to verify Switch attributes:
```
select * from aps_v_swi_port_attribute
```

Load port attributes and values

Feedback

Feedback