Catalog Source Configuration > IBM Db2 for LUW Script > Before you begin
  

Before you begin

Before you can extract catalog source metadata, get information from the IBM Db2 for LUW administrator.
Ensure that the following prerequisites are met:

Verify permissions

Verify that the administrator has the following permissions:

Create a connection

Before you configure the IBM Db2 for LUW Script catalog source, create a connection object in Administrator.
    1In Administrator, select Connections.
    2Click New Connection.
    3Enter the following connection details:
    Property
    Description
    Connection Name
    Name of the IBM Db2 for LUW Script connection. Must be unique within the organization.
    Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -
    Maximum length is 100 characters.
    Connection names are not case sensitive.
    Description
    Optional description of the connection.
    Maximum length is 255 characters.
    Type
    Type of connection. Ensure that the type is Db2 for LUW Database Ingestion.
    4Enter properties specific to the Db2 for LUW Database Ingestion connection:
    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 LUW Database Ingestion.
    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 LUW instance.
    Password
    The password to use for connecting to the Db2 for LUW instance.
    Host
    The name of the machine that hosts the database server.
    Port
    The network port number used to connect to the database server.
    Database Name
    The name of the Db2 for LUW database that you want to access.
    Advanced Connection Properties
    Advanced properties for the Progress DataDirect JDBC DB2 driver, which is used to connect to the Db2 for LUW source. If you specify more than one property=value entry, separate them with a semicolon (;).
    The driver properties that you can enter in this field are described in the Progress DataDirect for JDBC connection properties. For example, you can set the EncryptionMethod property to control whether data is encrypted and decrypted when transmitted over the network between the driver and database server.
    5Click Test Connection.
    The results of the test are displayed on the page.
    6Click Save.