Before you create a catalog source, ensure that you have the information required to connect to the source system.
Perform the following tasks:
•Ensure that you have the required permissions to extract metadata.
•Install the Secure Agent on a Windows or Linux machine.
•Configure a connection to the IBM Db2 for z/OS source system in Administrator.
Verify permissions
To extract metadata and to configure other capabilities that a catalog source might include, you need account access and permissions on the source system. The permissions required might vary depending on the capability.
Permissions for metadata extraction
Ensure that you have the required permissions to enable metadata extraction.
Grant the following permissions:
•Read permission to access the IBM Db2 for z/OS source system.
• Grant permissions that allow you to perform the following operations:
- select on sysibm.SYSCOLUMNS
- select on sysibm.SYSFOREIGNKEYS
- select on sysibm.SYSKEYCOLUSE
- select on sysibm.SYSPARMS
- select on sysibm.SYSRELS
- select on sysibm.SYSROUTINES
- select on sysibm.SYSSEQUENCES
- select on sysibm.SYSSYNONYMS
- select on sysibm.SYSTABCONST
- select on sysibm.SYSTABLES
- select on sysibm.SYSVIEWS
Permissions to run data profiles
You can run profiles with the permissions required to perform metadata extraction.
Permissions to run data classification
You can perform data classification with the permissions required to perform metadata extraction.
Permissions to run glossary association
You can perform glossary association with the permissions required to perform metadata extraction.
Create a connection
Before you configure the IBM Db2 for z/OS catalog source, create a connection object in Administrator.
1In Administrator, select Connections.
2Click New Connection.
3Enter the following connection details:
Property
Description
Connection Name
A name for the connection. This name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -
Spaces at the beginning or end of the name are trimmed and are not saved as part of the name. Maximum length is 100 characters. Connection names are not case sensitive.
Description
An optional description for the connection. Maximum length is 255 characters.
Type
The type of connection. Ensure that the type is Db2 for zOS Database Ingestion.
4Enter properties specific to the IBM Db2 for z/OS connection:
Property
Description
Runtime Environment
The name of the runtime environment where you want to run database ingestion and replication tasks. You define runtime environments in Administrator.
User Name
The user name to use for connecting to the Db2 for z/OS instance.
Password
The password to use for connecting to the Db2 for z/OS instance.
Host
The name of the machine that hosts the database server.
Port
The network port number used to connect to the database server.
Location Name
The name of the Db2 for z/OS location that you want to access. For Db2 for z/OS, your system administrator can determine the name of your Db2 location using the command DISPLAY DDF.
5Click Test Connection to verify that the database details are valid.