Use the instance.cfg configuration file to set the DA agent system properties.
The instance.cfg file for DA agent is found in the $SYBASE/DA-15_5/agent/instance directory.
where instance is the name of your DA agent.
| Property Name | Description and Value |
|---|---|
| da.agent.colHashPrefix |
Specifies the prefix for each column_hash
column alias in the SQL select
statements. The prefix is followed by the name of the
column. For
example:
select … hashbytes(‘md5’, mycol, using
msb) as sy_col_hash_mycol
The prefix must be 1 – 100 characters in length and contain only letters, digits, and underscores. Default: sy_col_hash_ This property applies to the DA server's local agent and remote DA agents. |
| da.agent.maxDbHashArgs |
Specifies the maximum number of arguments DA supplies to the database hash function (SAP Adaptive Server hashbytes). If the number of comparison columns with the row_hash option exceeds this number, the comparison columns are divided into groups, and multiple row hashes are generated and compared. Valid values are:
Default: 100 This property applies to the DA server's local agent and remote DA agents. |
| da.agent.rowHashPrefix |
Specifies the prefix DA uses for each
row_hash column alias in SQL
select statements. The prefix is
followed by the row_hash number, starting
with 1. For
example:
select … hashbytes(…)as sy_row_hash_1 The prefix must be 1 – 100 characters in length and contain only letters, digits, and underscores. Default: sy_row_hash_ This property applies to the DA server's local agent and remote DA agents. |
| da.dts.port |
Specifies the port number for the remote DA agents to accept data transfer stream (DTS) connections from DA server instances. Valid values are:
Default: none (value required) |
| da.jdbc.asa |
Specifies the JDBC driver class name for SAP Adaptive Server Anywhere (ASA). Default: com.sybase.jdbc4.jdbc.SybDriver This property applies to the DA server's local agent and remote DA agents. |
| da.jdbc.ase |
Specifies the JDBC driver class name for an SAP Adaptive Server database. Default: com.sybase.jdbc4.jdbc.SybDriver This property applies to the DA server's local agent and remote DA agents. |
| da.jdbc.hanadb |
Specifies the JDBC driver class name for the SAP HANA database. Default: com.sap.db.jdbc.Driver This property applies to the DA server's local agent and remote DA agents. |
| da.jdbc.iq |
Specifies the JDBC driver class name for an SAP IQ database. Configure this to ianywhere.ml.jdbcodbc.jdbc3.IDriver to use the native SQL Anywhere® ODBC driver. Default: com.sybase.jdbc4.jdbc.SybDriver This property applies to the DA server's local agent and remote DA agents. |
| da.jdbc.oracle |
Specifies the JDBC driver class name for an Oracle database. Default: oracle.jdbc.driver.OracleDriver This property applies to the DA server's local agent and remote DA agents. |
| da.sec.dts.enableRemoteAccess |
Determine whether the data transfer stream (DTS) listener can accept connections from remote clients. Valid values are true or false. Default: false |