Show TOC

Changes to alter connectionLocate this document in the navigation structure

The alter connection syntax has been modified and several new parameters added.

alter connection to <data_server>.<database> {
     [for replicate table named [<table_owner>.]<table_name> 
     [set <table_param> [to] ‘<value>’]] |
     set function string class [to] <function_class> |
     set error class [to] <error_class> |
     set replication server error class [to] <rs_error_class> |
     set password [to] <passwd> |
     set dsi_connector_sec_mech [to] <hdbuserstore> |
     set log transfer [to] {on | off} |
     set <database_param> [to] '<value>' |
     set <security_param> [to] '<value>' |
     set security_services [to] 'default']
     set dataserver and database name [to] <new_ds>.<new_db> |
     set trace [to] '<value>' | 
          set schemamap [with | without decluster] from <data_server>.<db>.{<from_schema> | NULL} to {<to_schema> | NULL} |
     set sap_trim_len to {'on' | 'off'} |
     set sapsystemname to '<sid_adm_value>' |
     set reblock_ddntf to {'on' | 'off'}}
Replication Server 15.7.1 SP200 adds these parameters:
  • schemamap – Maps primary schema or owner (<from_schema>) to replicate schema or owner (<to_schema>).

    During DML or heterogeneous DDL replication, if a replicate database is subscribing to a table replication definition that includes the table owner, the replicate owner of the table replication definition takes effect. A schemamap can take effect only if there is no table subscription for the table or if the table replication definition does include the replicate table owner.

  • data_server.db – Specifies the data server and database containing the primary data.
  • <from_schema> – Specifies the schema of the primary database.
  • <to_schema> – Specifies the schema of the replicate database.
  • with decluster – Enables declustering of cluster tables for a schema.
  • without decluster – Disables declustering of cluster tables for a schema.
  • NULL – Specifies all users. Mapping relations for <data_server>.<db> are dropped if you specify NULL for both <from_schema> and <to_schema>.
  • sapsystemname – (only for replication from SAP Business Suite applications) Specifies the environment variable for the SAP system name, that is <sid>.
  • sap_trim_len – (only for replication from SAP Business Suite on Oracle database to any supported database) Specifies whether Replication Server should truncate the first two bytes during replication if:
    • The application datatype (DDIC type) of the column is RAW or LRAW, and
    • The DDIC type length is greater than 255 bytes.

    The valid values are 'on' and 'off' (default).

  • reblock_ddntf – (only for replication from SAP Business Suite on DB2 UDB database to any supported database) Specifies whether Replication Server should adjust each FIELDS column length in the replicate database to 32768 characters except the last row. The valid values are 'on' (default) and 'off'.

See alter connection in the Reference Manual.