IBM Cloud Docs
Databases

Databases

You can access database information by using the web console.

Information about databases

The table lists database-related values and their definitions.
Value Description
Name Specifies the name of the database.
Default schema Specifies the deafult schema.
Owner Specifies the owner of the database.
User tables Specifies the number of tables that are created in the database.
Character set Specifies the character set for the database.
Created on Specifies when the database was created.

Creating databases

  1. Go to Databases.

  2. Click Create database after selecting following options:

    • Netezza
    • Lakehouse

  3. Add all inputs based on the option selected. Type a name for the database. If the name contains special characters, enclose it in double quotation marks. The dot character (".") is not supported.

  4. If the database type is Netezza, select a storage type from the drop-down: Block, Default, or Object.

    Specify the default storagetype to be used for objects created within the database. For more information on storagetypes, see Default storage type.

  5. Optional: Specify the retention time interval (in days) for the database. You can select between 1 day and up to 99 days. For more information on retention time interval and time travel, see NPSaaS time travel.

  6. Click Create.

Assigning owners to databases

  1. Go to Databases.
  2. Select the database for which you want to assing an owner.
  3. From the overflow menu, click Assign owner.
  4. Select an owner for the database.
  5. Click Assign.

Renaming databases

  1. Go to Databases.
  2. Select the database that you want to rename.
  3. From the overflow menu, click Rename.
  4. Type a new name for the database. If the name contains special characters, enclose it in double quotation marks. The dot character (".") is not supported.
  5. Click Rename.

Updating retention time interval (time travel) for databases

  1. Go to Databases.
  2. Select the database for which you want to update the retention time interval.
  3. From the overflow menu, click Update interval.
  4. Type a retention time interval. You can select between 1 day and up to 99 days, or zero to alter a temporal database to nontemporal. For more information on retention time interval and time travel, see NPSaaS time travel.
  5. Click Save.

Viewing privileges for databases

  1. Go to Databases.
  2. Select the database which privileges you want to view.
  3. From the overflow menu, click Show privileges. A list of privileges is now displayed.

Dropping databases

  1. Go to Databases.
  2. Select the database that you want to drop.
  3. From the overflow menu, click Drop.
  4. Confirm your choice by clicking Drop.