Creating a Db2 for z/OS database

You can create a new database in Db2® for z/OS® to work with your data in IBM® Cloud Pak for Data.

Before you begin

Service This service is not available by default. An administrator must install this service on the IBM Cloud Pak for Data platform. To determine whether the service is installed, open the Services catalog and check whether the service is enabled.

The system administrator must also configure the Db2 for z/OS environment, as described in Configuring a Db2 for z/OS environment for creating databases from Cloud Pak for Data.

About this task

By creating your own database in Db2 for z/OS from Cloud Pak for Data, you can work with your data in a sandbox environment where you own and can change to the database objects, without changing the master data. You can bring the data into projects for use in analytics. Because the new database is created in Db2 for z/OS, the data remains protected by the governance polices of that platform.

Procedure

  1. Go to Collect > My data.
  2. Click Databases > Create a database.
  3. For the database type, select IBM Db2 for z/OS Connector for IBM Cloud Pak for Data, and click Next.
  4. Enter the host name and port for the z/OS system where IBM Db2 DevOps Experience for z/OS or the z/OSMF templates are installed.
  5. Enter the credentials for access to the z/OS system.
  6. Click Test.
    You receive a confirmation message if your connection is successful.
  7. Click Next and select the schema for your Db2 for z/OS database.
    You can expand each schema template to see the list of included tables in the template.
  8. Click Next and provide a Display name.
    The display name is just for tracking in Cloud Pak for Data. The actual database created in Db2 for z/OS uses automatically generated names. You can see the name after the database is created.
  9. Click CREATE.
    The My data page opens and the database that you created is shown in a new tile.
  10. Optional: You can click Details to see the name and other information about the created database.

What to do next

In the actions menu for the new database, you can use the following actions to work with the Db2 for z/OS database that you created:

  • Click Details to see the database name, and other information about the database.
  • Click Open to begin exploring the data from the Explorer or the Run SQL editor.
  • Click Access management to grant other users access to the database.
  • Click Delete to delete the database.

For more information, see Working with Db2 for z/OS databases (Db2 for z/OS Connector).