About this task
A Data Definition Language (DDL) script can be used to create Annotations
database. The DB2Z_CreateAnnotationDB.sql DDL script is located in
the <IBM ADDI Installation Folder>\IBM Application Discovery Build
Client\Bin\Release\DBScripts folder.
Procedure
-
Go to <IBM ADDI Installation Folder>\IBM Application Discovery Build
Client\Bin\Release\DBScripts and open DB2Z_CreateAnnotationDB.sql by
using a text editor.
- Locate and set the following parameters in the entire script.
CREATE DATABASE <enter an appropriate name for the database>
SET CURRENT SCHEMA = 'enter an appropriate name for the schema'
SET CURRENT PATH = 'enter an appropriate name for the path'
SET CURRENT FUNCTION PATH = 'enter an appropriate name for the function
path'
Note: The default name of the database, schema, path, and function path is
EZANNOT
. The default name can be changed and can have a maximum length of
8 characters. Special characters cannot be used.
- Run the script.
- After you create the Annotations database, access
, and go to
. The Database
Names settings page is displayed.
- Enter the Annotations Database name and the schema name in Annotations
Database. The Annotations Database is used to store the comments that are related to
application’s lifecycle added by a user on a resource.
Results
The desired Annotations Database is
created.