Book description
Sybase 15 Replication Server Administration addresses the needs of a wide range of database professionals, explaining to both beginners and experts how to administer Sybase’s newest Replication Server release. This book examines all the knowledge, background information, and conceptual frameworks needed in order to get started on installing and administering Sybase Replication Server, and explores the world of contemporary cross-platform compatible Sybase Replication Server administration.
Learn how to replicate business-critical data; configure database connections and routes; manage replicated tables, stored procedures, and subscriptions; set up a warm standby system; monitor replication performance and tune the database system; provide up-to-the-minute high availability of data; recover from failures and prevent data loss; troubleshoot the replication system.
Table of contents
- Contents
- Acknowledgments
- Introduction
- Chapter 1 Data Replication
- Chapter 2 The Replication Server Architecture
- Chapter 3 Replication Design and Implementation Strategies
- Chapter 4 Replication Server Installation and Upgrade
-
Chapter 5 Configuration Parameters
-
Configuring Replication Server
- batch
- batch_begin
- byte_order
- cm_fadeout_time
- cm_max_connections
- ha_failover
- memory_limit
- num_concurrent_subs
- num_msgqueues
- num_msgs
- num_mutexes
- num_stable_queues
- num_threads
- oserver
- password_encryption
- rec_daemon_sleep_time
- rssd_error_class
- smp_enable
- sqm_recover_segs
- sqm_warning_thr1
- sqm_warning_thr2
- sqm_warning_thr_ind
- sqm_write_flush
- sqt_init_read_delay
- sqt_max_cache_size
- sqt_max_prs_size
- sqt_max_read_delay
- sre_reserve
- sub_daemon_sleep_time
- sts_cachesize
- sts_full_cache_rssd_system_table
- stats_sampling
- stats_show_zero_counters
- use_security_services
- use_ssl
- varchar_truncation
- Configuration Parameters for Both Database Connection and Route
-
Configuration Parameters Unique to Database Connection (DSI)
- command retry
- db_packet_size
- dist_sqt_max_cache_size
- dsi_charset_convert
- dsi_cmd_batch_size
- dsi_cmd_separator
- dsi_commit_check_locks_intrvl
- dsi_commit_check_locks_log
- dsi_commit_check_locks_max
- dsi_commit_control
- dsi_exec_request_sproc
- dsi_fadeout_time
- dsi_ignore_underscore_name
- dsi_isolation_level
- dsi_keep_triggers
- dsi_large_xact_size
- dsi_max_cmds_to_log
- dsi_max_text_to_log
- dsi_max_xacts_in_group
- dsi_num_large_xact_threads
- dsi_num_threads
- dsi_partitioning_rule
- dsi_replication
- dsi_replication_ddl
- dsi_rs_ticket_report
- dsi_serialization_method
- dsi_sql_data_style
- dsi_sqt_max_cache_size
- dsi_text_convert_multiplier
- dsi_xact_group_size
- dump_load
- dynamic_sql
- dynamic_sql_cache_management
- dynamic_sql_cache_size
- exec_cmds_per_timeslice
- exec_sqm_write_request_limit
- md_sqm_write_request_limit
- parallel_dsi
- rep_as_standby
- sub_sqm_write_request_limit
- Configuration Parameters Unique to Replication Server Route
- Security Configuration Parameters for Connecting to the ID Server
- Other Valid Replication Server Configuration Parameters
- Embedded RSSD Configuration Parameters
-
Configuring Replication Server
- Chapter 6 Replication Agent
- Chapter 7 Connections
- Chapter 8 Routes
-
Chapter 9 Managing Replicated Tables and Stored Procedures
-
Replication Definitions and Subscription Definitions
- Create a Replication Definition
- Altering a Replication Definition
- Marking Tables for Replication
- Replicating Tables with text, unitext, image, and rawobject Datatypes
- Replicating Tables with Computed Columns
- Replicating Tables with Encrypted Columns
- Replicating Tables with Different Ownership
- Creating Replication Definition for Java Columns
- Managing Replicated Stored Procedures
- Creating Publications
- Dropping Replication Definitions
-
Replication Definitions and Subscription Definitions
- Chapter 10 Subscriptions
- Chapter 11 Functions and Function Strings
-
Chapter 12 Warm Standby
- Warm Standby vs. Hot Standby System
- Warm Standby Components
- Regular Replication vs. Warm Standby
- Enabling Replication to Standby Database
- Setting Up Warm Standby
- Warm Standby as Primary
- Warm Standby as Replicate Database
- System Tables and System Stored Procedures for Warm Standby Setup
- Using Replication Definitions and Subscriptions
- Switchover
- Chapter 13 Multi-Site Availability
-
Chapter 14 Performance Monitoring and Tuning
- Common Mistakes
- Performance Monitoring Tools
-
Analyzing Performance Metrics
- Metrics to Focus On
- Replication Agent User (EXEC)
- Stable Queue Manager (SQM)
- Stable Queue Transaction (SQT)
- Distributor (DIST)
- Data Server Interface (DSI)
-
DSI Executor (DSI EXEC)
- Common Problems
- Metrics to Focus On
-
Tuning for Performance
- Replication Definitions and Unique Indexing
- Disabling or Optimizing Triggers
- Replication Definitions and Minimal Column Replication
- Increase ULC and Enable Delayed Commit
- Use Dynamic SQL/Prepared Statements
- Enable Statement Cache with Literal Parameterization
- Parallel DSI Contention and Group Sizing/Partitioning
- Parallel DSIs and “Collapsing Updates”
- Replication Server Interface (RSI) and RSI User
- Monitoring Performance
-
Chapter 15 Disaster and Recovery
- Types of Failures
- Disaster Recovery Fundamentals
- Recovering the Primary Database
- Recovering the RSSD Database
- Removing Replication Server from the Replication System
- Recovering from a Damaged Partition
- Summary Plan for Recovery
-
Chapter 16 Replicating Oracle Data
- Sybase Replication System for Non-Sybase Data Servers
- Replication Agent Installation
- Configuring DirectConnect for Oracle
-
Configuring Replication Server
- Configuring a Replication Agent Instance
- Creating a Replication Agent Instance
- Starting a Replication Agent Instance
- Stopping a Replication Agent Instance
- Quiescing a Replication Agent Instance
- Initializing a Replication Agent Instance
- Suspending a Replication Agent Instance
- Creating Administrator User Login
-
Configuring Replication Agent Connection Configuration Parameters
- Configuring Connection Parameters for Oracle SID (Primary Data Server)
- New Replication Agent Configuration Parameters for Oracle RAC in Replication Agent 15.1
- Configuring Connection Parameters for the Replication Server
- Configuring Replication Agent Instance Connection Parameters for the RSSD (or ERSSD)
- Replication Agent Transaction Log Management
- Marking Objects for Replication in the Primary Database
- Oracle Database Specific Issues
- Configuring and Tuning Replication Agent for Oracle
- Troubleshooting Replication Agent
- Troubleshooting Replication Agent System Database (RASD)
- Typical Topology of Heterogeneous Replication
- Chapter 17 Security
- Chapter 18 Internationalization
- Chapter 19 ERSSD
-
Chapter 20 Troubleshooting
-
Replication Agent
- Invalid Login
- Missing Replication Server Name in Interfaces
- Permission Issue
- Misconfigured Replication Agent
- Invalid Truncation Page
- Syslogs Corruption
- Primary Database Transaction Log Full
- Standby Database Transaction Log Full
- Error 9209
- Replication Status Inconsistency of text, unitext, or image Columns
- Error 2033
- Error 9202
- Errors 9204 and 9254
- Error 9205
- Error 9240
- Error 9255
- Error 9261
- Errors 9278 and 9279
- Error 9286
-
DSI Issues
- States of DSI Scheduler Thread
- States of DSI Executor Thread
- Creating an Error Class for Duplicate Key
- Turning On DSI Trace Flags
- Turning Off DSI Trace Flags
- Connectivity Issues
- Incorrect Login/Password
- Permission Issues
- SUID Mismatch
- Connection Failures with Asynchronous Transaction and DDL Replication
- Data Server Errors
- Replication Server Errors
- Stable Queues
- Open Transaction in the Inbound Queue
- Data Not Being Replicated
- Data Latency
-
Replication Agent
- Appendix A Origin Queue ID
- Appendix B Removing the Active Replication Server from the Replication System
- Appendix C Useful Queries
- Index
Product information
- Title: Sybase 15.0 Replication Server Administration
- Author(s):
- Release date: December 2008
- Publisher(s): Jones & Bartlett Learning
- ISBN: 9781449613174
You might also like
book
Configuring and Tuning Databases on the Solaris™ Platform
Turbocharge your Oracle, DB2, Sybase, or Informix database environment! Covers every aspect of database and Solaris …
book
Sybase to DB2 Conversion Guide
IBM® DB2® for Linux®, UNIX®, and Windows® has long been known for its technology leadership. The …
book
SQL Server DMVs in Action
SQL Server DMVs in Action is a practical guide that shows you how to obtain, interpret, …
book
Microsoft® SQL Server 2012 Unleashed
Buy the print version of¿ and get the eBook version for free! eBook version includes chapters …