Creating Annotations Database on Db2 for LUW Using DDL Script

Edit online

About this task

A Data Definition Language (DDL) script can be used to create Annotations database. The DB2LUW_CreateAnnotationDB.sql DDL script is located on the machine where IBM® AD Build Client is installed, in the <IBM ADDI Installation Folder>\IBM Application Discovery Build Client\Bin\Release\DBScripts folder.

Procedure

  1. By default, when running the DB2LUW_CreateAnnotationDB.sql DDL script an annotations database with the default EZANNOT name is created.
    Note:
    • In case that you want to change the default EZANNOT name of the annotations database, go to <IBM ADDI Installation Folder>\IBM Application Discovery Build Client\Bin\Release\DBScripts, open DB2LUW_CreateAnnotationDB.sql by using a text editor, and replace in the entire file the default EZANNOT name with the one that you desire.
    • The database name must follow the general Db2 object naming rules.
  2. Run the DB2LUW_CreateAnnotationDB.sql script by using Db2 Command Line Processor (CLP).
  3. After you create the Annotations database, go to the machine where IBM AD Servers and Services are installed, 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.
  4. Enter the Annotations Database name in Annotations Database > Name. 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 and configured.