SAP DB:ODBC Guide de dépannage

Quick Start Guide for SAP® HANADatabaseReplication Server® 15.7.1SP100Linux, UNIX, and Microsoft Windows

Syntax conventionsKey Definition{ } Curly braces indicate that you must choose at least one of the enclosed options. Donot type the braces when you en

If you have not set up the sample Replication Server instance, enter your ReplicationServer instance name in place of SAMPLE_RS.2.Enter:grant create o

Setting the DB2 UDB Connectivity Autocommit ParameterReplication Agent requires that the DB2 UDB connectivity autocommit parameter be turnedon (autoco

Adding a Temporary Tablespace to the Primary DatabaseAdd a temporary tablespace to the primary database.1.Start the DB2 UDB command-line processor (CL

1.Locate the resource file template.The majority of configuration values required to create and initialize a Replication Agentcan be recorded and stor

Parameter Description Example valuesltm_admin_pw Password for the user administering the Rep-lication Agent instance.The default password policy istha

Parameter Description Example valuesrs_charset Character set that Replication Server is us-ing.Note: The value defined for the rs_charsetconfiguration

%SYBASE%\RAX-15_5\bin\ra_admin.bat -vr myra.rs• On UNIX or Linux:$SYBASE/RAX-15_5/bin/ra_admin.sh -vr myra.rs where myra.rs is the path and name of th

Verifying the Replication Agent Instance InstallationVerify that the Replication Agent instance has been successfully installed.1.Use dsedit to update

You see:Type Connection---- ----------PDS succeeded(1 row affected)b) If the result indicates a failure:• The server is not responding, or• One of th

1.Initialize the Replication Agent instance:ra_admin initgoYou see a message indicating that the procedure was successful.2.Enter:resumegoIf the Repli

• Replication Agent for Microsoft SQL Server• Replication Agent for IBM DB2 UDBCHAPTER 1: ConventionsQuick Start Guide for SAP HANA Database 3

DSI Suspended 103 pds.pdb24 DIST Awaiting Wakeup 103 pds.pdb25 SQT Awaiting Wakeup 103:1 DIST pds.pdb23 SQM

Note: SAP HANA database is not case-sensitive and uses uppercase characters iflowercase characters are provided.If an owner is not specified with the

2.Reset the locator stored in the Replication Agent:ra_locator zerogo3.Reset the locator stored in Replication Server:isql -Usa -Psa_pass -SSAMPLE_RSc

CHAPTER 7GlossaryThis glossary describes Replication Server Options terms.•Adaptive Server® – the brand name for Sybase relational database management

can have only one database connection in Replication Server. See also Replication Serverand route.•data client – a client application that provides ac

•gateway – connectivity software that allows two or more computer systems with differentnetwork architectures to communicate.•inbound queue – a stable

•Log Transfer Interface – an internal component of Replication Agent that interacts withReplication Server to forward transactions for distribution to

•primary database – the database that contains the data to be replicated to anotherdatabase (the replicate database) through a replication system. The

•replicated transaction – a primary transaction that is replicated from a primary databaseto a replicate database by a transaction replication system.

•table – in a relational DBMS, a two-dimensional array of data or a named data object thatcontains a specific number of unordered rows composed of a g

CHAPTER 1: Conventions4 Replication Server

CHAPTER 7: Glossary112 Replication Server

IndexAaccessing and downloading from SPDC 8, 25, 53,81ASEconfiguring Replication Server for replicationfrom the primary database 16installing replicat

testing replication 102verifying the Replication Agent instance 99default directory 11, 27, 83directoriesdefault 11, 27, 83Eerrorswhile starting insta

replication componentsconfiguration 59, 87Replication Server, addingprimary database 16resetting primary ASE database for replication 20resetting prim

Index116 Replication Server

CHAPTER 2How to Use This DocumentUse this document to set up and begin using a basic replication system with SAP® HANAdatabase as the replicate.This d

CHAPTER 2: How to Use This Document6 Replication Server

CHAPTER 3ASE-to-SAP HANA DatabaseReplication SetupImplement a sample replication system for replication from Adaptive Server Enterprise(ASE) to SAP HA

• You have a valid license for Replication Server with ExpressConnect for HANA DB.• Adaptive Server is installed and configured to serve as the source

TaskNote: If you are installing Replication Server Options (RSO), this task requires you to performseveral steps twice because you are downloading Rep

Installing Replication ServerInstall Replication Server using the setup program.Prerequisites• Allocate a disk partition of at least 20MB for each Rep

4. In the Introduction window, click Next.5.Indicate where to install Replication Server:•To select an installation directory, click Choose, and brows

DOCUMENT ID: DC01974-01-1571100-02LAST REVISED: July 2013Copyright © 2013 by Sybase, Inc. All rights reserved.This publication pertains to Sybase soft

•Use Previously Deployed License Server – for an existing license server, enter thehost name of the machine where the license server is running, and t

12.When the final window appears, indicating a successful installation, click Done to exit theinstaller.Editing the Interfaces FileEdit your Replicati

Configuring Replication ServerReview the procedures for configuring Replication Server for ASE-to-SAP HANA databasereplication.Obtaining the SAP HANA

where myschema is your SAP HANA database schema, and muser is the maintenance useryou just created.5.Log in to Replication Server:isql –Usa –Psa_pass

Configuring Replication Server for Replication from the Primary DatabaseConfigure Replication Server for replication from the primary database.Adding

Parameter Description Valuers.rs_db_maint_user User ID whose work is not re-plicated when logged on theprimary database. The user iscalled maintenance

The output from the command looks similar to:Spid Name State Info---- ----- ------ --------32 DSI EXEC Awaiting Command 101(1) SAMPLE_RS

Note: By default, this DDL creates a table with the owner dbo.3.Grant permissions to any new or existing object to be replicated in the primary databa

For information on using the create subscription command in direct load materialization,see Replication Server Reference Manual.10.On the Adaptive Ser

exitgoIf you have not set up the sample Replication Server instance, enter your ReplicationServer instance name in place of SAMPLE_RS.8.Disconnect fro

ContentsCHAPTER 1: Conventions...1CHAPTER 2: How to Use This Document...5CHAPTER 3: ASE-t

CHAPTER 3: ASE-to-SAP HANA Database Replication Setup22 Replication Server

CHAPTER 4Oracle-to-SAP HANA DatabaseReplication SetupImplement a sample replication system for replication from Oracle to SAP HANA database.Use the ta

PrerequisitesReview the prerequisites before you begin setting up Oracle-to-SAP HANA databasereplication.Make sure:• You are familiar with Oracle and

Identify the Sybase Installation DirectoryDetermine the directory in which to install the replication components.Replication Agent, Replication Server

Note: To generate a license, you must provide some information, such as the host name,MAC address, and number of CPUs.5.Download your product licenses

If there is not enough disk space in the temporary disk space directory, set theenvironment variable TMP to directory_name before running it again, wh

•Specify License Keys – click Browse to select the license file. To select multiplelicense files, use Shift+Click or Ctrl+Click. The license pane disp

•Yes – to create a sample Replication Server directory without starting the sampleReplication Server, or,•No – to continue with the installation.See t

The directory does not exist.Do you want to create it?If the directory you specified exists, you see:Warning: You have chosen to install into an exist

• Informational• Warning• ErrorIf you choose not to have e-mail alerts or severity messages logged, select No.Click Next.11.Review the product feature

CHAPTER 4: Oracle-to-SAP HANA DatabaseReplication Setup...23System Architecture...

Configuring Replication ComponentsReview the procedures for configuring each of the replication components in the replicationsystem.Configuring Replic

hdbuserstore set rds myhost:xxxxx my_securestore_user my_securestore_pwdwhere•rds is the key for the secure store entry•myhost:xxxxx is the connection

where:•rds is the replicate SAP HANA database. For a standard connection, this must matchthe data server name in the interfaces file entry. See the Ad

Configuring Replication AgentReview the procedures for configuring Replication Agent for Oracle.Primary Oracle Database Configuration for ReplicationC

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARYKEY, UNIQUE INDEX) COLUMNS;ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;Configuring Oracle LogMinerConfig

GRANT SELECT ON SYS.ATTRIBUTE$ TO RA_USER;GRANT SELECT ON SYS.CCOL$ TO RA_USER;GRANT SELECT ON SYS.CDEF$ TO RA_USER;GRANT SELECT ON SYS.COL$ TO RA_USE

RESOURCESELECT_CATALOG_ROLEThe user who starts the Replication Agent instance must also have read access to the Oracleredo log files and the Oracle ar

Record the ORACLE_SID value for the instance you want to connect to.4.(Optional) If your operating system has a Java 6.0.x-compatible JRE or JDK insta

password information listed in the tnsname.ora file for the Oracle, Replication Server,and RSSD connections.• Set the value of rs_source_ds to the val

Parameter Description Example Valuesrs_host_name Machine where Replication Server is instal-led.jdoe_host1rs_port_number Port number where Replication

CHAPTER 5: Microsoft SQL Server-to-SAP HANADatabase Replication Setup...51System Architecture...

Parameter Description Example Valuesinitialize_instance Initialize the Replication Agent instance. yespdb_include_archives Enables or disables the use

Note: If, in your response file, you set start_instance to yes, your instance is alsorunning. If you set initialize_instance to yes, your instance is

Note: These verification steps are optional because they were performed when youverified the resource file.3.Verify the Replication Agent connection t

set username muserset password mpwdwith log transfer on, dsi_suspendedgowhere:•pds is the value of the rs_source_ds parameter specified in Replication

Command <resume> failed - Desired state <REPLICATE>could not be achieved. Current state: <REPLICATION DOWN>3.The ra_status command r

22 SQM Awaiting Message 103:0 pds.pdb62 REP AGENT Awaiting Command pds.pdbTesting ReplicationWhen you finish setting up the replication syst

If you have not set up the sample Replication Server instance, enter your ReplicationServer instance name in place of SAMPLE_RS.9.Alter the replicatio

gors_zeroltm pds, pdbgoexitgoYou see:Locator has been reset to zero.(return status = 0)5.Resume replication with the Replication Agent resume command:

CHAPTER 4: Oracle-to-SAP HANA Database Replication Setup50 Replication Server

CHAPTER 5Microsoft SQL Server-to-SAPHANA Database ReplicationSetupImplement a sample replication system for replication from Microsoft SQL Server to S

Resetting the Primary Microsoft SQL ServerDatabase for Replication...76CHAPTER 6: DB2 UDB-to-SAP HANA DatabaseR

PrerequisitesReview the prerequisites before you begin setting up Microsoft SQL Server-to-SAP HANAdatabase replication.Make sure:• You are familiar wi

Identify the Sybase Installation DirectoryDetermine the directory in which to install the replication components.Replication Agent, Replication Server

Note: To generate a license, you must provide some information, such as the host name,MAC address, and number of CPUs.5.Download your product licenses

If there is not enough disk space in the temporary disk space directory, set theenvironment variable TMP to directory_name before running the installe

Alternatively, copy and paste the license information directly in the license pane. ClickNext.If you specify a served license key, the installer promp

•No – to continue with the installation.See the Replication Server Configuration Guide for Windows or UNIX.Note: For a sample Replication Server insta

after the end of the grace period, obtain a valid license from the Sybase ProductDownload Center at http://www.sybase.com/detail?id=1025266, and insta

Configuring Replication ComponentsReview the procedures for configuring each of the replication components in the replicationsystem.Configuring Replic

hdbuserstore set rds myhost:xxxxx my_securestore_user my_securestore_pwdwhere•rds is the key for the secure store entry•myhost:xxxxx is the connection

where:•rds is the replicate SAP HANA database. For a standard connection, this must matchthe data server name in the interfaces file entry. See the Ad

Creating a Replication Server Connection to thePrimary Database...100Initializing the Replication Agent Instance

Configuring Replication AgentReview the procedures for configuring Replication Server for Microsoft SQL Server.Primary Microsoft SQL Server Configurat

Enabling Remote DACEnable remote DAC.PrerequisitesTask1.Log in to the server:"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\SQLCMD.EXE"

Verifying the Version of the Microsoft Filter Manager LibraryConfirm that the Microsoft Filter Manager Library version is 5.1.2600.2978 or later, to m

5.In Windows Explorer, navigate to %SYBASE%\RAX-15_5\bin, and double-click thesybfiltermgr.exe file to start the sybfilter driver management console.6

Task1.From the Windows Control Panel, select:Administrative Tools > Services2.In the listed services, find the service named Microsoft SQL Server A

The majority of configuration values required to create and initialize a Replication Agentcan be recorded and stored in a resource file. Using a resou

Parameter Description Example valuesltm_admin_pw Password for the user administering the Rep-lication Agent instance.The default password policy istha

Parameter Description Example valuesrssd_username Valid user for RSSD. SAMPLE_RS_RSSD_maintrssd_password Password for rssd_username. SAM-PLE_RS_RSSD_m

Microsoft SQL Server(TEAMSTER)b) Stop the service.2.Restart Microsoft SQL Server in single-user mode:a)Click Start > Control Panel > Administrat

isql –Usa –Psa_pass –Smyra7.If your resource file has initialize_instance set to no, initialize the primary data server andthe Replication Agent insta

Contentsviii Replication Server

Subsequent initializationCreate another Replication Agent instance, after you have already initialized the primary dataserver.See also• Verifying the

ra_admin initYour Replication Agent instance is now running and has been initialized.Creating a Replication Server Connection to the Primary DatabaseC

To detect an error that occurred after replication start-up, execute:ra_statusgoIf the Replication Agent is in replicating state, ra_status returns:St

EXEC Suspended 103(1) pds.pdb DSI Suspended 103 pds.pdb24 DIST Awaiting Wakeup 103 pds.pdb25 SQT Awa

grant all privileges on <tableowner>.PTAB1 to public8.Log in to Replication Server:isql –Usa –Psa_pass –SSAMPLE_RSIf you have not set up the sam

ra_admin refreshNote: If you prefer to delete and replace all the information in the Replication Agentrepository, issue the ra_admin deinit, force com

CHAPTER 5: Microsoft SQL Server-to-SAP HANA Database Replication Setup78 Replication Server

CHAPTER 6DB2 UDB-to-SAP HANADatabase Replication SetupImplement a sample replication system from DB2 UDB to SAP HANA database.Use the tasks in this do

• You are familiar with DB2 UDB and SAP HANA database.• You have valid licenses for Replication Server with ExpressConnect for HANA DB andReplication

Replication Agent Installation DirectoryReplication Agent versions 15.5 and later use the RAX-15_5 directory name. If you have anexisting Replication

CHAPTER 1ConventionsThese style and syntax conventions are used in Sybase® documentation.Style conventionsKey Definitionmonospaced (fixed-width)• SQL

6.Download your installation files, and uncompress and extract all the installation images toyour local drive.Installing Replication ComponentsReview

where setup.bin is the executable file name for installing Replication Server.If there is not enough disk space in the temporary disk space directory,

•Next to install the new SySAM license server and follow the installation prompts.•Previous and select Use previously deployed license server if you h

Note: For a sample Replication Server instance, the rs_charset parameter must be setto utf8.Click Next.12.When the final window appears, indicating a

any older versions of the products you choose toinstall that are detected in this directory will bereplaced.If you continue and the older products wer

Click Next.11.Review the product features or components listed on the Preinstallation Summarywindow. Click Install.The installation program installs t

Setting DB2 UDB Environment VariablesFor UNIX and Linux, the DB2 UDB installation provides two scripts for setting up the DB2UDB environment variables

# force 32-bit librariesLD_LIBRARY_PATH=$HOME/sqllib/lib32:$LD_LIBRARY_PATHexport LD_LIBRARY_PATH4.Before starting Replication Agent, always source yo

Note: Each SAP HANA database installs with a unique instance number, and the portnumber is the instance number prefixed with 3 and suffixed with 15:3i

set password mpwdgoFor SAP Secure User Store:create connection to rds.rdbusing profile rs_udb_to_hanadb;echset username auserset password apwdset dsi_