Enterprise Data Catalog Scanner Configuration Guide > Configuring Database Management Resources > IBM DB2 for z/OS
  

IBM DB2 for z/OS

Configure an IBM DB2 for z/OS resource type to extract metadata from IBM DB2 for z/OS databases.

Objects Extracted

Enterprise Data Catalog extracts metadata of the following schema objects from an IBM DB2 for z/OS resource:

Permissions to Configure the Resource

When you load an IBM DB2 for z/OS resource, Enterprise Data Catalog extracts metadata from the IBM DB2 for z/OS subsystem. Enterprise Data Catalog selects the metadata from the DB2 catalog tables.
Configure SELECT privileges on the following system tables in the IBM DB2 for z/OS user account that you use to connect to the IBM DB2 for z/OS data source:
System Tables
Metadata Extracted
  • - SYSIBM.SYSSYNONYMS
  • - SYSIBM.SYSTABLES
  • - SYSIBM.SYSROUTINES
  • - SYSIBM.SYSSEQUENCES
  • - SYSIBM.SYSDATATYPES
Schemas
  • - SYSIBM.SYSTABLES
  • - SYSIBM.SYSTABLESPACE
  • - Tables
  • - Views
  • - SYSIBM.SYSVIEWS
  • - Alias
  • - SYSIBM.SYSTABLES
  • - SYSIBM.SYSCOLUMNS
  • - SYSIBM.SYSTABLESPACE
Columns
  • - SYSIBM.SYSKEYS
  • - SYSIBM.SYSINDEXES
Primary keys
  • - SYSIBM.SYSRELS
  • - SYSIBM.SYSFOREIGNKEYS
  • - SYSIBM.SYSINDEXES
Foreign keys
  • - SYSIBM.SYSCHECKS
  • - SYSIBM.SYSCHECKDEP
Check constraints
  • - SYSIBM.SYSINDEXES
  • - SYSIBM.SYSKEYS
Indexes
  • - SYSIBM.SYSSYNONYMS
  • - SYSIBM.SYSTABLES
Synonyms
SYSIBM.SYSTRIGGERS
Triggers
SYSIBM.SYSTRIGGERS
Stored procedures
SYSIBM.SYSROUTINES
Functions
SYSIBM.SYSSEQUENCES
Sequences
  • - SYSIBM.SYSSEQUENCESDEP
  • - SYSIBM.SYSSEQUENCES
Identity
SYSIBM.SYSDATATYPES
User-defined types

Prerequisites

To access metadata from z/OS subsystems using PowerExchange, perform the following steps:
For more information about installing and configuring PowerExchange, see the PowerExchange Installation and Upgrade guide.

Resource Connection Properties

The following table describes the properties for the IBM DB2 for z/OS resource:
Property
Description
Location
Node name in the dbmover.cfg file on the machine where the Catalog Service runs that points to the PowerExchange Listener on the z/OS system.
Note: Enterprise Data Catalog uses PowerExchange for DB2 for z/OS to access metadata from z/OS subsystems.
User
Name of the user account that connects to IBM DB2 for z/OS database.
Password
Password for the user account that connects to IBM DB2 for z/OS database.
Encoding
Code page for the IBM DB2 for z/OS subsystem.
Sub System ID
Name of the DB2 subsystem.
The following table describes the Additional property for source metadata settings on the Metadata Load Settings tab:
Property
Description
Enable Source Metadata
Enables metadata extraction
Database
Click Select to specify a list of databases that you want to import. You can use one of the following options from the Select Database dialog box to import the databases:
  • - Select from List. Select the required database from a list of available databases.
  • - Select using regex. Provide SQL regular expressions such as * or ? to include databases that match the expression.
Schema
Click Select to specify the schemas that you want to import. You can use one of the following options from the Select Schema dialog box to import the schemas:
  • - Select from List. Select the required schemas from a list of available schemas.
  • - Select using regex. Provide SQL regular expressions such as * or ? to include schemas that match the expression.
    • Note: If you use regular expression to select the databases that you want to import, you must not use regular expression to select the schemas.
Source Metadata Filter
You can include tables and views from the resource run. Use semicolon (;) to separate the table names and view names. When the list is empty, the resource run includes all the available tables and views. You can use regular expressions such as * and ? to specify the list of tables and views.
For more information about the filter field, see Source Metadata and Data Profile Filter.
Case Sensitive
Specifies that the resource is configured for case sensitivity.
  • - Select the check box to specify that the resource is configured as case sensitive.
  • - Clear the check box to specify that the resource is configured as case insensitive.
By default, the resource is configured as case sensitive.
To view the log information of the IBM DB2 for z/OS resource, see the LDM.log file.
You can enable data discovery for an IBM DB2 for z/OS resource. For more information about enabling data discovery, see the Enable Data Discovery topic.
You can enable composite data domain discovery for an IBM DB2 for z/OS resource. For more information about enabling composite data domain discovery, see the Composite Data Domain Discovery topic.
Note: You cannot run profiling using an IBM DB2 for z/OS resource that contains multiple databases with the same schema name. Make sure the schema names of the databases that you select need to be unique.