ASE Replicator User’s Guide
ASE Replicator User’s GuideAdaptive Server Enterprise12.5
DOCUMENT ID: 35431-01-1250-02LAST REVISED: January 2003Copyright 1989-2003 by Sybase, Inc. All rights reserved.This publication pertains to Sybase software and to any subsequent release until otherwise indicated in new editions or technical notes.Information in this document is subject to change without notice. The software described herein is furnished under a license agreement,and it may be used or copied only in accordance with the terms of that agreement.To order additional documents, U.S. and Canadian customers should call Customer Fulfillment at (800) 685-8225, fax (617) 229-9845.Customers in other countries with a U.S. license agreement may contact Customer Fulfillment via the above fax number. All otherinternational customers should contact their Sybase subsidiary or local distributor. Upgrades are provided only at regularly scheduledsoftware release dates. No part of this publication may be reproduced, transmitted, or translated in any form or by any means, electronic,mechanical, manual, optical, or otherwise, without the prior written permission of Sybase, Inc.Sybase, the Sybase logo, AccelaTrade, ADA Workbench, Adaptable Windowing Environment, Adaptive Component Architecture,Adaptive Server, Adaptive Server Anywhere, Adaptive Server Enterprise, Adaptive Server Enterprise Monitor, Adaptive ServerEnterprise Replication, Adaptive Server Everywhere, Adaptive Server IQ, Adaptive Warehouse, Anywhere Studio, ApplicationManager, AppModeler, APT Workbench, APT-Build, APT-Edit, APT-Execute, APT-FORMS, APT-Translator, APT-Library, BackupServer, BizTracker, ClearConnect, Client-Library, Client Services, Convoy/DM, Copernicus, Data Pipeline, Data Workbench,DataArchitect, Database Analyzer, DataExpress, DataServer, DataWindow, DB-Library, dbQueue, Developers Workbench, DirectConnect Anywhere, DirectConnect, Distribution Director, e-ADK, E-Anywhere, e-Biz Integrator, E-Whatever, EC Gateway, ECMAP,ECRTP, eFulfillment Accelerator, Embedded SQL, EMS, Enterprise Application Studio, Enterprise Client/Server, Enterprise Connect,Enterprise Data Studio, Enterprise Manager, Enterprise SQL Server Manager, Enterprise Work Architecture, Enterprise Work Designer,Enterprise Work Modeler, eProcurement Accelerator, EWA, Financial Fusion, Financial Fusion Server, Gateway Manager, GlobalFIX,ImpactNow, Industry Warehouse Studio, InfoMaker, Information Anywhere, Information Everywhere, InformationConnect,InternetBuilder, iScript, Jaguar CTS, jConnect for JDBC, MainframeConnect, Maintenance Express, MDI Access Server, MDI DatabaseGateway, media.splash, MetaWorks, MySupport, Net-Gateway, Net-Library, New Era of Networks, ObjectConnect, ObjectCycle,OmniConnect, OmniSQL Access Module, OmniSQL Toolkit, Open Biz, Open Client, Open ClientConnect, Open Client/Server, OpenClient/Server Interfaces, Open Gateway, Open Server, Open ServerConnect, Open Solutions, Optima , PB-Gen, PC APT Execute, PCNet Library, Power , power.stop, PowerAMC, PowerBuilder, PowerBuilder Foundation Class Library, PowerDesigner,PowerDimensions, PowerDynamo, PowerJ, PowerScript, PowerSite, PowerSocket, Powersoft, PowerStage, PowerStudio, PowerTips,Powersoft Portfolio, Powersoft Professional, PowerWare Desktop, PowerWare Enterprise, ProcessAnalyst, Rapport, Report Workbench,Report-Execute, Replication Agent, Replication Driver, Replication Server, Replication Server Manager, Replication Toolkit, ResourceManager, RW-DisplayLib, S-Designor, SDF, Secure SQL Server, Secure SQL Toolset, Security Guardian, SKILS, smart.partners,smart.parts, smart.script, SQL Advantage, SQL Anywhere, SQL Anywhere Studio, SQL Code Checker, SQL Debug, SQL Edit, SQLEdit/TPU, SQL Everywhere, SQL Modeler, SQL Remote, SQL Server, SQL Server Manager, SQL SMART, SQL Toolset, SQL Server/CFT, SQL Server/DBM, SQL Server SNMP SubAgent, SQL Station, SQLJ, STEP, SupportNow, S.W.I.F.T. Message Format Libraries,Sybase Central, Sybase Client/Server Interfaces, Sybase Financial Server, Sybase Gateways, Sybase MPP, Sybase SQL Desktop, SybaseSQL Lifecycle, Sybase SQL Workgroup, Sybase User Workbench, SybaseWare, Syber Financial, SyberAssist, SyBooks, System 10,System 11, System XI (logo), SystemTools, Tabular Data Stream, TradeForce, Transact-SQL, Translation Toolkit, UltraLite.NET,UNIBOM, Unilib, Uninull, Unisep, Unistring, URK Runtime Kit for UniCode, Viewer, Visual Components, VisualSpeller, VisualWriter,VQL, WarehouseArchitect, Warehouse Control Center, Warehouse Studio, Warehouse WORKS, Watcom, Watcom SQL, Watcom SQLServer, Web Deployment Kit, Web.PB, Web.SQL, WebSights, WebViewer, WorkGroup SQL Server, XA-Library, XA-Server and XPServer are trademarks of Sybase, Inc. 11/02Unicode and the Unicode Logo are registered trademarks of Unicode, Inc.All other company and product names used herein may be trademarks or registered trademarks of their respective companies.Use, duplication, or disclosure by the government is subject to the restrictions set forth in subparagraph (c)(1)(ii) of DFARS 52.2277013 for the DOD and as set forth in FAR 52.227-19(a)-(d) for civilian agencies.Sybase, Inc., One Sybase Drive, Dublin, CA 94568.
ContentsAbout This Book . viiCHAPTER 1Introduction to ASE Replicator. 1Understanding replication . 1Table replication . 2Stored procedure replication . 2Transaction replication . 2Guaranteed delivery . 3Understanding ASE Replicator . 3ASE Replicator components . 4ASE Replicator processing. 7ASE Replicator objects. 8ASE Replicator limitations . 13CHAPTER 2Setting Up and Starting ASE Replicator .Setting up ASE Replicator.Configuring the primary Adaptive Server .Configuring the replicate servers and databases .Initializing the ASE Replicator process.Starting ASE Replicator .Using the aserep script.Using the RUN script .Setting up a replication system .1516222629303233Administering ASE Replicator .Administering the ASE Replicator process.Configuring ASE Replicator.Shutting down the ASE Replicator process.Suspending replication .Resuming replication .Monitoring ASE Replicator .Managing database connections .Creating a database connection.3637373838394040CHAPTER 3ASE Replicator User’s Guide1535iii
ContentsDeleting a database connection .Configuring a database connection.Suspending and resuming database connections.Getting information about database connections .Getting connection configuration information .Managing publications and subscriptions .Creating publications and subscriptions.Deleting publications and subscriptions .Suspending and resuming subscriptions.Getting information about publications and subscriptions .Managing primary and replicate articles .Creating primary articles .Creating replicate articles.Deleting primary articles.Deleting replicate articles .Materializing and validating replicate articles .Getting information about primary articles.Getting information about replicate articles .ASE Replicator configuration parameters .General configuration parameters.Connection configuration parameters .CHAPTER 4iv424243444647484849505152535556565762656674ASE Replicator Procedures . 79sp addprimaryart . 82sp addprimaryconn. 85sp addpub . 86sp addreplicateart. 87sp addreplicateconn . 91sp addsub. 92sp configprimaryconn . 93sp configrep. 95sp configreplicateconn . 97sp dropprimaryart . 98sp dropprimaryconn . 99sp droppub . 100sp dropreplicateart . 100sp dropreplicateconn . 101sp dropsub . 102sp helpconn. 103sp helplastcommit . 104sp helplocator. 105sp helpprimaryart . 106sp helpprimaryconn . 109sp helppub. 113Adaptive Server Enterprise
Contentssp helprep .sp helpreplicateart.sp helpreplicateconn .sp helpsub.sp materializesub .sp resumeprimaryconn.sp resumerep .sp resumereplicateconn .sp resumesub.sp shutdownrep.sp suspendprimaryconn .sp suspendrep.sp suspendreplicateconn .sp suspendsub .sp tracerep .sp validatesub HAPTER 5Troubleshooting ASE Replicator.Problems that prevent replication from starting.Primary server configuration problems.Remote server configuration problems .ASE Replicator configuration problems.User login or permission problems.Problems that cause ongoing replication to fail.Schema changes in primary or replicate tables .Datatypes, constraints, and column properties .143143143144145145146147148AP PE ND IX ADistribution Database Schema .Distribution Database base objects.Distribution Database datatypes .Base tables in the Distribution Database .Base procedures in the Distribution Database .Distribution Database shadow tables.Shadow tables for primary tables without large objects .Shadow tables for primary tables with large objects .Shadow tables for primary procedures.Distribution Database replicate objects.Distribution procedures .Replicate article proxy tables .153153153154164164165166167168168169Glossary . 171Index . 173ASE Replicator User’s Guidev
ContentsviAdaptive Server Enterprise
About This BookThe ASE Replicator User’s Guide describes how to use the ASEReplicator feature of Sybase Adaptive Server Enterprise to implementbasic replication from a primary Adaptive Server to one or more remoteAdaptive Servers.AudienceThis book is intended for System Administrators and DatabaseAdministrators who want to implement simple Adaptive Serverreplication with ASE Replicator.How to use this bookThis book contains the following chapters:Chapter 1, “Introduction to ASE Replicator,” provides an introduction toreplication system concepts and an overview of the ASE Replicator. Thischapter describes the major ASE Replicator components and explainshow they work.Chapter 2, “Setting Up and Starting ASE Replicator,” describes the initialsetup and configuration procedure for ASE Replicator. The setupprocedures in this chapter must be performed after installing the software,and before replication can begin.Chapter 3, “Administering ASE Replicator,” describes administrativeoperations, including managing and monitoring ASE Replicator and thereplication system.Chapter 4, “ASE Replicator Procedures,” describes the ASE Replicatorcommand procedures in detail, including syntax, options, usage, andexamples.Chapter 5, “Troubleshooting ASE Replicator,” describes basictroubleshooting and recovery procedures for ASE Replicator.Appendix A, “Distribution Database Schema,” describes the schema ofthe Distribution Database.Related documentsThe Adaptive Server Enterprise documentation set comprises thefollowing documents: ASE Replicator User’s GuideThe release bulletin for your platform – contains last-minuteinformation that was too late to be included in the books.vii
A more recent version of the release bulletin may be available on theWorld Wide Web. To check for critical product or document informationthat was added after the release of the product CD, use the SybaseTechnical Library.viii The Installation Guide for your platform – describes installation, upgrade,and configuration procedures for all Adaptive Server and related Sybaseproducts. Configuring Adaptive Server Enterprise for your platform – providesinstructions for performing specific configuration tasks for AdaptiveServer. What’s New in Adaptive Server Enterprise? – describes the new featuresin Adaptive Server version 12.5, the system changes added to supportthose features, and the changes that may affect your existing applications. Transact-SQL User’s Guide – documents Transact-SQL , Sybase’senhanced version of the relational database language. This manual servesas a textbook for beginning users of the database management system.This manual also contains descriptions of the pubs2 and pubs3 sampledatabases. System Administration Guide – provides in-depth information aboutadministering servers and databases. This manual includes instructionsand guidelines for managing physical resources, security, user and systemdatabases, and specifying character conversion, international language,and sort order settings. Reference Manual – contains detailed information about all Transact-SQLcommands, functions, procedures, and datatypes. This manual alsocontains a list of the Transact-SQL reserved words and definitions ofsystem tables. Performance and Tuning Guide – explains how to tune Adaptive Serverfor maximum performance. This manual includes information aboutdatabase design issues that affect performance, query optimization, how totune Adaptive Server for very large databases, disk and cache issues, andthe effects of locking and cursors on performance. The Utility Guide – documents the Adaptive Server utility programs, suchas isql and bcp, which are executed at the operating system level. The Quick Reference Guide – provides a comprehensive listing of thenames and syntax for commands, functions, system procedures, extendedsystem procedures, datatypes, and utilities in a pocket-sized book.Available only in print version.Adaptive Server Enterprise
The System Tables Diagram – illustrates system tables and their entityrelationships in a poster format. Available only in print version. Error Messages and Troubleshooting Guide – explains how to resolvefrequently occurring error messages and describes solutions to systemproblems frequently encountered by users. Component Integration Services User’s Guide – explains how to use theAdaptive Server Component Integration Services feature to connectremote Sybase and non-Sybase databases. Java in Adaptive Server Enterprise – describes how to install and use Javaclasses as datatypes, functions, and stored procedures in the AdaptiveServer database. Using Sybase Failover in a High Availability System – providesinstructions for using Sybase’s Failover to configure an Adaptive Serveras a companion server in a high availability system. Using Adaptive Server Distributed Transaction Management Features –explains how to configure, use, and troubleshoot Adaptive Server DTMfeatures in distributed tr
Audience This book is intended for System Administrators and Database Administrators who want to implement simple Adaptive Server replication with ASE Replicator. How to use this book This book contains the following chapters: Chapter 1, “Introduction to ASE
ASE STUDY GUIDE, Third Ed. Prepare tomorrow's automotive professionals for success on the National ASE Certification Tests with the ASE Test Preparation and Study Guide. This guide covers ASE areas A1-A8, and is designed to help service technicians and students of automotive technology prepare to take the National ASE Certification Tests.
The MakerBot Replicator Z18 is not user serviceable. Caution: Avoid leaving the MakerBot Replicator Z18 unattended during operation. If you must leave the MakerBot Replicator Z18 unattended during a print, exercise caution and follow these guidelines: Verify that the MakerBot Replicator Z18 has started the print and is operating normally.
The MakerBot Replicator Z18 will melt filament and squeeze it out onto the build plate in thin lines to build your object laye r by layer. With the huge build volume of the MakerBot Replicator Z18, this part of the process can take a long time. The method of 3D printing used by the MakerBot Replicator Z18 is called fused deposition model ing.
from the sides of the MakerBot Replicator 2X. 2 Removing the MakerBot Replicator 2X from the box 2a. Open the plastic covering and firmly grasp the frame of the MakerBot Replicator 2X. Be careful not to grip the rods or belts of the gantry system. Lift it out of the box and place it on a stable surface. 2b. Your MakerBot Replicator 2X is now fully
AVERTISSEMENT: La MakerBot Replicator 2 produit de très hautes températures et contient des pièces mobiles qui peuvent provoquer des blessures. Ne pénétrez jamais dans la MakerBot Replicator 2 lorsqu'elle est en train de fonctionner. Laissez toujours la MakerBot Replicator 2 refroidir avant de mettre les mains à l'intérieur.
Always allow the MakerBot Replicator Smart Extruder to cool to 50 C before removing it or reaching inside the MakerBot Replicator Mini. Warning: The MakerBot Replicator Mini includes moving parts that can cause injury. Never reach inside the MakerBot Replicator Mini while it is in operation. Warning: There is a risk of shock. This product is .
Apr 19, 2016 · TURN ABSTRACT MATHEMATICAL CONCEPTS INTO CONCRETE EXPERIENCES. 17 K-12 Fundraising. 18 K-12 PRODUCT DESIGN. 19 K-12 PRODUCT DESIGN. 20 Promoting Good. 21 . MakerBot Replicator Mini MakerBot Replicator MakerBot Replicator Z18 MakerBot Replicator 2X
Accounting Standard (IAS) terminology and requiring pre sentation in International Standard format. Approach – These qualifications were designed using Pearson’s Efficacy Framework. They were developed in line with World-Class Design principles giving students who successfully complete the qualifications the opportunity to acquire a good knowledge and understanding of the principles .
