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.

Procedure

  1. Go to <IBM ADDI Installation Folder>\IBM Application Discovery Build Client\Bin\Release\DBScripts and open DB2Z_CreateAnnotationDB.sql by using a text editor.
  2. 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.
  3. Run the script.
  4. After you create the Annotations database, access Start Menu > IBM Application Discovery and Delivery Intelligence > Launch IBM Application Discovery Configuration Service Admin, and go to Configure > Environments > "Your environment" > Servers and security > Database names. The Database Names settings page is displayed.
  5. 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.