Andersson HDB 1.0 Manuel d'utilisateur

PUBLICSAP Replication Server® Data Assurance Option 15.7.1 SP204Document Version: 1.0 ( 2014-12-18 )New Features Guide

1.3.1 Adding a DA Windows ServiceSet up an instance of an SAP Replication Server Data Assurance Option server or agent to run as a service in 64-bit

4. (Optional) Enter help to see a list of commands available in the service administration tool.Enter a Command::> helpSupported Commands Are:

2. Change directories:> cd $SAP\DA-15_5\winservice\bin3. Run ServiceAdmin.cmd to launch the DA Windows service administration tool.A new command pr

For example, to start a DA server called myserver, enter the command and the full path to the server instance:> StartService C:\SAP\DA-15_5\server\

If another SAP product updates the shared SAP JRE (during installation or upgrade, for example), the JVM DLL that a given DA Windows service relies on

C:\SAP\DA-15_5\agent\myagent\DA_Agent_myagent_Service.ini1.4 Test connection Displays JDBC Driver and Database VersionsThe test connection command ha

1.5.1 create compareset foreachCreates a compareset for each table after searching for all matching table names in the source and target databases.Sy

NoteThe source and target <connection_name> and <owner_name> pairings must be unique within each command.Table 4: create compareset Option

Parameter Valuekeep_computed_columns Whether to include computed columns in the compareset column mappings.Valid values: true or falseDefault: falseke

Example 4Creates a compareset for each table that exists in the source and both target databases using the default prefix, including tables only with

Content1 New Features in SAP Replication Server Data Assurance 15.7.1 SP204... 41.1 Comparison and Column Options in SAP DA...

2 New Features in SAP Replication Server Data Assurance 15.7.1 SP202SAP® Replication Server® Data Assurance Option 15.7.1 SP202 supports specifying t

When SAP DA selects rows from the “person” table for a comparison, this SQL query is generated:select first_name,last_name,dob from dbo.person order b

New Parameter:ignore_trailing_spaces – Determines whether to ignore trailing spaces when comparing character datatype values.Valid values are:● true –

See Security and Access Control in the SAP Replication Server Data Assurance Option Users Guide.2.4 Automatic Column Key Assignment for User Defined

TYPE CONNECTION OWNER TABLE MAPID COLUMN KEY---- ---------- ----- ------ ----- ---------- ----S conn1 dbo person 1 first_name 2T

3 New Features in SAP Replication Server Data Assurance 15.7.1 SP200SAP® Replication Server® Data Assurance Option 15.7.1 SP200 includes support for

● On Windows – keytool -certreq -alias jetty -keystore %SYBASE%\SCC-3_2\services\EmbeddedWebContainer\keystore -file scc_jetty.csr● On UNIX – keytool

4 New Features in Replication Server Data Assurance Option 15.7.1 SP110Replication Server® Data Assurance Option 15.7.1 SP110 includes support for IB

4.1.1 Configuring DA to Use the IBM DB2 UDB JDBC DriverTo use an IBM DB2 UDB database in a comparison, configure the DA server and the DA agent to us

Component Name Machine Name Port NumbersDA agent neptune ● 6500 – RMI● 6501 – TDS● 6502 – DTSAdaptive Server database mars 5000 – serverIBM DB2 Univer

5 New Features in Replication Server Data Assurance Option 15.7.1 SP100... 405.1 Support for Sybase IQ...

In this example, the pubs2 database is replicated on the IBM DB2 UDB. The DA server's local agent on mars points to the Adaptive Server database

11. View the compareset:show compareset authors_demo4go12. Create a job.This job creates a single comparison that uses the compareset defined in step

4.2.1 Configuring DA to Use the Microsoft SQL Server JDBC DriverTo use a Microsoft SQL Server database in a comparison, configure the DA server and t

Table 6: Deployment SummaryComponent Name Machine Name Port NumbersDA server mars ● 6500 – RMI● 6501 – TDS● 6503 – DASDDA agent pluto ● 6500 – RMI● 65

6. Test connection settings for the DA agent:test agent agent_plutogo7. Create database connections for the new DA agent.In this example, the pubs2 da

and s.address=t.address and s.city=t.city and s.state=t.state and s.country=t.country and s.postalcode=t.postalcodego11. View the comp

and set host=jupiter and set port=1521 and set database=XE and set user=harry and set password=openSesam3 with properties set sessionTime

ExampleExample 1 – waits indefinitely until the job is completed. You cannot regain the isql prompt control until DA server completes the job. The job

The returned result is:COMPARISON PART STATUS SUBMIT TIME END TIME RUN PROGRESS NEXT RETRY ERROR---------- ---- ------- ------------------- -

4.5 Changes to Sybase Control Center Data Assurance Plug-InSybase Control Center Data Assurance plug-in now supports Microsoft SQL Server and IBM DB2

1 New Features in SAP Replication Server Data Assurance 15.7.1 SP204In SAP® Replication Server® Data Assurance Option 15.7.1 SP204, you can use new o

5 New Features in Replication Server Data Assurance Option 15.7.1 SP100Replication Server® Data Assurance Option15.7.1 SP100 includes support for Syb

5.3 Support for HANA DBReplication Server Data Assurance Option 15.7.1 SP100 supports comparisons where the source or target database is HANA DB.Supp

5.5 Data PartitionsReplication Server Data Assurance Option 15.7.1 SP100 allows large tables to be split into logical partitions.For maximum performa

Important Disclaimers and Legal InformationCoding SamplesAny software coding and/or code lines / strings ("Code") included in this documenta

www.sap.com/contactsap© 2014 SAP SE or an SAP affiliate company. All rights reserved.No part of this publication may be reproduced or transmitted in a

Name DescriptionFORMAT_DATE Indicates how a character value should be converted into a date value (when it is compared with a date value).Character va

Name DescriptionSCALE Specifies the maximum number of scale digits (digits to the right of the decimal point) in a number that is compared. If a numb

Supported Datatype Conversion DescriptionDATE to VARCHAR SRS converts date values into date strings such as “Oct 20 1972”. This is not the DA default

Name DescriptionIGNORE_ZERO_PADDING Overrides the Comparison option with the same name. If not set, the Comparison option is used as required.Valid v

When the job is run and DA compares a DATE with a VARCHAR, DA uses the FORMAT to parse the VARCHAR value to a DATE prior to performing the comparison.