Show TOC

Changes to alter connectionLocate this document in the navigation structure

Several new parameters are added to the alter connection command.

Syntax
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'}}
Parameters

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.