pds_connection_type

The type of connectivity driver used on the primary database connection.

Default

One of the following values is set automatically when the Replication Agent instance is created.

Values

MSSQLJDBC – Replication Agent uses the Microsoft SQL Server JDBC™ driver to connect to the primary Microsoft SQL Server database.

ORAJDBC – Replication Agent uses the Oracle JDBC™ driver to connect to the primary Oracle database.

UDBJDBC – Replication Agent uses the DB2 Universal Database JDBC driver to connect to the primary database in DB2 Universal Database.

Comments

  • The value of the pds_connection_type parameter is set automatically at the time a Replication Agent instance is created. The specific value depends on the type of Replication Agent instance created.

    Note: Do not change the default value of the pds_connection_type parameter.
  • The value of the pds_connection_type parameter determines which of several other Replication Agent configuration parameters related to the primary database connection must also have values specified.
    • MSSQLDBC requires corresponding values for the following parameters:

      • pds_server_name

      • pds_port_number

      • pds_database_name

    • UDBJDBC requires corresponding values for the following parameters:

      • pds_host_name

      • pds_port_number

      • pds_database_name

      • pds_datasource_name

    • ORAJDBC requires corresponding values for the following parameters:

      • pds_host_name

      • pds_port_number

      • pds_database_name

    • For the tnsnames.ora file, the following parameters are required:

      • pds_tns_filename

      • pds_tns_connection

    • The value of the pds_connection_type parameter is automatically set when a Replication Agent instance is created.