Creating a database on an instance of Db2

This topic describes how to create a Db2 database on a target Db2 instance using BMC Database Automation (BDA).

Before you begin

A Db2 instance must be available for provisioning and must meet all of the Db2 database prerequisites. See Creating-an-instance-of-Db2-on-Linux-and-Unix.

To create a Db2 database

1. From the Management Console, select the node in the Grid that hosts the Db2 instance you want to create a Db2 database on and select that Db2 instance. 
2. In the Db2 Instance Information section, select Provision > Create Db2 Database.

3. In the Naming page, populate the following fields, and click Next.

4. In the Database Information page, populate the following fields, and click Next.

5. In the Database Storage page, populate the following fields, and click Next.

6. In the Database Parameters page, populate the following fields, and click Next. 

7. In the Database Encryption page, populate the following fields, and click Next. 

   Note

   The Database Encryption page appears only when creating databases on Db2 instances version 10.5 fixpack 5 or later. 

   
   

8. In the Catalog Tablespace page, populate the following fields, and click Next. 
   

9. In the User Tablespace page, populate the following fields, and click Next. 

10. In the Temporary Tablespace page, populate the following fields, and click Next. 

11. In the Custom Scripts Configuration page, select any pre-provisioning or post-provisioning scripts that you want to run as follows, and click Next.

12. In the Job Options page, specify any of the following Job options, and click Next. 

13. If the Change Control page displays, populate the following fields, and click Next. 

    Note

    The Change Control page appears only when change control is configured for your environment. See Configuring-change-control.

14. In the Summary page, review the provisioning information.
    To make changes, do the following:
    1. Click Go to to return to the provisioning step that you want to edit.
    2. Make your changes.
    3. Click Save and Review to return to the Summary page.
15. Specify your verification preferences.
    For additional information, see Understanding-pre-verification-tests.
    • To continue with database creation after the pre-verification tests have been successfully run without manual intervention, select Automatically Continue If All Tests Succeed.

    • To create the database without having first run the pre-verification steps, select Skip Pre-Verification Tests.

      Note

      The Skip Pre-Verification Tests option should only be used when you are certain all tests can succeed. The option skips verification and advances directly to the actual provisioning activity.

16. Click Create Db2 Database.
    If you disabled the Automatically Continue If All Tests Succeed and Skip Pre-Verification Tests options, you are prompted to click Continue after the pre-verification steps are done.
    The database creation process begins and a progress page appears.

    Note

    If you close your browser, the operation continues. You can return to this page by using the Jobs page.

17. (Optional) Click View Log to view log file details or Download Log Package to download full log details.
18. Check the Results section for the Success message.

19. Click Done and return to the Contents view of this domain. 

    Note

    Detailed current and historical information about this action can be viewed in the Jobs section of the Management Console. See Monitoring-jobs-and-viewing-job-history.