Create a CSV File of Application Database Objects and Attributes
The LoadDBAttribute utility assigns application attribute values to a host’s database application. This utility takes as input a comma-separated values (CSV) file.
NOTE: This CSV file becomes the master document of record for Application Database Attributes and therefore should be preserved in a working directory for future updates.
1. 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 application databases.
In the above example:
• The first 3 columns comprise the unique identifier for an Application Database—in this example, CorpServer1, FinanceDB, and FinanceDBInstance.
• Subsequent columns list the attributes and values.
Columns
• Columns list the objects that uniquely identify an application. For an Application Database, the required columns are: Host Name, DB Name, DB Instance.
• Each additional column lists attributes and values.
Rows
• First (Header) Row - Contains the fields that uniquely identify an application, followed by the attribute names. The header row is information only and is not processed as a data row.
• Subsequent rows list the objects that uniquely identify an application database, followed by the attribute values that you are assigning to each application database.
