Creating Annotations Database on Db2 on z/OS Using DDL Script
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.
- 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.
Note: The default name of the database, schema, path, and function path is
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'
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.
The desired Annotations Database is created.