Provisioning a Db2 Warehouse on Cloud instance

Db2 Warehouse on Cloud is a cloud database that serves as the target for your Data Gate on Cloud data. The supported version of Db2 Warehouse on Cloud runs on AWS as a service, but is provisioned through your IBM Cloud® account. It runs on AWS in the IBM® virtual private cloud (VPC).

1. Open a web browser and go to https://cloud.ibm.com.
2. Log in with your IBM id.
3. Click Create Resource on the upper right of the window.
4. Under Catalog, search for Db2 Warehouse.
5. In the Db2 Warehouse window, under Platform, select Amazon Web Services.
6. From the Location drop-down list, select one of the following locations:
   • Nothern Virginia (us-east-1)
   • Frankfurt (eu-central-1)
   Only these two locations are supported for use with Data Gate on Cloud.
7. Select an Availability Zone or leave the default setting, which is Automatic.
8. Under License, select Bring your own license.
9. Confirm that you possess the required number of license VPUs.
   Draft comment: kuester@de.ibm.com
   Check VPU.
10. Under Resource Allocation, select a Compute size of 32cpu.
11. Skip the S3 options selection.
12. Select between 5 and 6 TB of Block Storage.
13. Optionally, you can use the calculator to estimate your backup costs. Daily backups are taken as part of the service, and by default each backup is retained for seven days.
    Tip: From the Db2 Warehouse on Cloud console, you can reduce the default retention period to one day to reduce your backup costs.
14. Under Add-Ons, select:
    • Create AWS private link

      This is a very important step that you must not forget. The AWS private link connects your Data Gate on Cloud VPC with your Db2 Warehouse on Cloud instance.

    • IBM Data Gate on Cloud compatibility
    Important:

    Ensure that you do not select Oracle compatibility.

15. Draft comment: kuester@de.ibm.com
    Check if a resource group must be created. Comment from Joyce:

    At this point, it's possible that the customer will have to create a resource group if they don't have one yet. I'm not sure of the details. I’m hoping my team will provide some review comments here. Or maybe you want them to pick the same resource group that contains their Data Gate instance?

    Then they should review their selections and click Create to initiate the deployment. They’ll see a message when the deployment is complete.

16. Review your selections and click Create to initiate the deployment. Wait until the process has finished.
    You see a summary of the Db2 Warehouse on Cloud instance that has been created for you on AWS. Make a note of the instance's CRN. You need it in one of the steps that follow.

Completing the following steps, you instruct IBM support to enable your Db2 Warehouse on Cloud instance for Data Gate on Cloud.

17. Open a web browser and go to https://cloud.ibm.com/unifiedsupport/supportcenter.
18. Log in with your IBM ID.
    You see the following page:

    

19. Scroll down to the Contact Support section and click Create a Case.
    Draft comment: kuester@de.ibm.com
    Joyce:

    The steps say to choose category = Account, but I don't think this is correct. When I tried it, I didn't have the option of choosing Topic = Db2 Warehouse. Maybe this is because I haven't deployed Db2WonC under my account. Again, a place where I think our ops team will have some useful input. Check this.

    You see the page in the following figure:

    

20. From the Topic drop-down list, select Db2 Warehouse.
21. From the Subtopic drop-down list, select Configuration change request.
22. On the following page, you see the Subject field. Type Enable the instance for DataGate support in this field, and add the following information to the Description:

    Please enable the following DB2 Warehouse cloud instance for DataGate support:
    CRN: <crnOfDb2WarehouseToEnableForDataGate> 
    Including: 
    (1) Setup db2 config configuration parameter DATAGATE_ENABLED=YES
    (2) install memory tables via CALL SYSINSTALLOBJECTS('ANNACC','C','','')

    When the support team set the parameter that is shown under (1), Db2 system variables are set as follows:

    DB2_EXTENDED_OPTIMIZATION=COL_RTABLE_UD_THR 0,XGBPART ON FULL NONHDIR,ENABLE_OLAP2AGG ON,NI2NE_WITH_NULLS OUTER
    DB2COMPOPT=CDE_NEQN_ENABLE
    DB2_ATM_CMD_LINE_ARGS=-include-manual-tables -low-priority-update-systables
    DB2_SELECTIVITY=ALL,AJSEL
    DB2LOCK_TO_RB=STATEMENT
     
    DB2_ENABLE_MULTIPLE_CCSIDS_FOR_LOB_COLUMNS=YES 
    DB2_ENABLE_CCSID_SEMANTICS=YES 
    DB2_ENABLE_MULTIPLE_CCSIDS=YES

    Your support case should look similar to this:

    

23. Click Submit case.
24. Wait for a reply from IBM support that confirms the completion of your support case.