Loading data from IBM Cloud Object Storage

This section explains how to load data from IBM Cloud Object Storage in Db2 SaaS in the new Genius Hub–enabled console. Follow these instructions if you see the updated UI. If you are still using the legacy console, refer to the Loading data section for the correct steps.

Using Console

You can load data from IBM Cloud Object Storage (COS) into IBM® Db2® as a Service by using the Console.

BLUUSERS cannot load data from the console.

Create the necessary credentials on the COS bucket to allow Console to access the data

  1. Access the COS Bucket on the IBMCloud Dashboard by clicking on the name

Resource List
Resource List

Create Credentials on the COS bucket so Db2 Console can access the data.

  1. Select Service Credentials
  2. Click on New Credentials
  3. Enter Name for the Service Credential
  4. Select the appropriate Role
  5. Ensure Include HMAC Credential is enabled

Create Service Credentials
Create Service Credentials

Get the Access key and Secret access key from the Credentials

  1. Expand the Credential
  2. Note down the access_key_id and secret_access_key

Get Keys
Get Access Keys

The steps for opening the db2 console to the load data page in the UI differ depending on whether you are using the legacy console or the new Genius Hub–enabled console.

If you are still using the legacy console, refer to the Loading data section for the correct steps.

Open the Db2 Console to the load data page

  1. Click on Administration > Databases > select your database > click on Data operations in the left menu
  2. Click on Load Data in the main content
  3. Click on Cloud Object Storage
  4. Pick the COS Authentication Endpoint that matches your bucket
  5. Enter the Access key ID from above for Access key
  6. Enter the Secret access key from above for Secret access key
  7. Click on Browse Files to select the file you want to load from

Create Service Credentials
Create Service Credentials

Create Service Credentials
Create Service Credentials

External Tables

You can load data from IBM Cloud Object Storage (COS) into IBM® Db2® as a Service by using the built-in External Tables functionality.

Here's an example SQL statement that inserts COS data into a IBM Db2 Warehouse SaaS table by using External Tables:

INSERT INTO <table-name> SELECT * FROM EXTERNAL '<mys3file.txt>' USING
  (CCSID 1208 s3('s3-api.us-geo.objectstorage.softlayer.net',
  '<S3-access-key-ID>',
  '<S3-secret-access-key>',
  '<my_bucket>'
     )
  )