Home

SYBASE Replication Server 12.6 design Service Manual

Contents

1. 4 381H 26 2H 45 GIRS KRM Replication Server Replication Server Replication Server Replication Server Eb A ZH Replication Server RSSD
2. 131 Ripe IE i SB BR K T1 T2 DB1 F T3 DB2 SI S2 S3 HRA 3 A 1 KER TR PAM DB1 T1 10 5 20 200 100 3 DB1 T2 10 5 10 400 200 2 DB2 T3 120 100 2 1500 1000 2 3 A 2 FA
3. TUB AW Replication Agent sp_setreptable Replication Server 3 5
4. C FES NAE AI ATS IS EB OETA o red yellow blue Ad RD cash check credit xiii RCL XIV anchovies Ti di S A Re beans rice sweet potatoes
5. upd_publishers_pubs2_req upd_publishers_pubs2 CARED upd publishers pubs2 req sp_setrepproc
6. i Ripe IE BSBK RSSD rs_fillcaptable rs capacity Replication Server A 1 El A 1 TH DIE EE EE JH AE Legend Information you provide Calculation results Constants ee Message Overhead EI Message Ses Primary Key Widih Table Replication Row Widh Changed Seleciiviby hbound Change Rate E Failure Duration Volume Inbound Transaction hbound Database Volume Typical Transaction Inbound Queue Duration Size Total Queue Disk Usage Outh Queue ound Size Save Interval 122 Replication Server HRA REMH Replication Server ASCII
7. 9 RYE HEL PRG ee a VEE Ja ays eh BSP SECUS fd sp_setrepproc EKAR AA GRE upd_publishers_pubs2_req publishers pend upd publishers pubs2 CRER
8. MEH Replication Server 2 create publication 3 create article 4 validate publication 1 fH create subscription 58 Replication Server 3 11 pubs rep pubs2_pub A 3 11 KH publishers Primary
9. Replication Server Replication Server 14 98 Replication Server rs default function class rs db2 function class create function string class rs default class rs db2 function class rs db2 function class text BY image DB2
10. state state CA Replication Server Replication Server TEH GJ R publishers titles BRI publishers titles Gl Wr publishers KF titles sp setrepproc
11. 35 63 EIE ZH T Adaptive Server OR ES ZR Bl XL Replication Server Replication Server PAH K E ARKA
12. HESS tll BU e 81 PR tea He TRE Ter Wit FR Ife fa Ter Wt AFR rs_subcmp Ta feb Aas VI fEF X Adaptive Server SQL Server MEJA 737 Ie FF AS 225i YF SEG T 97 US PE s Replication Server
13. ITH o 33 3 10 F E CEKER publishers WAE publishers K N pubs copy pub id pub name E pubs_copy pub id pub name pub id 1000 55 RAYE HEL PRG A 3 10 FER Ese x publishers Primary Data Client application oe ea EE pou Replication M defimitioms here CN Tokyo Meteor LTA Subscription here seattle pubs cony EE perp 2 LL e a a BER Replication Server
14. Replication Server Replication Server Adaptive Server timestamp double precision nchar nvarchar timestamp varbinary 8 Replication Server FIER Replication Server Adaptive Server Replication Agent xvi Sybase Replication Server LAN WAN Replication Server Sybase Adaptive Server Repl
15. DD 21 28 ID distribute Replication Server RepAgent distribute fit distribute distribute command_tags subcommand values command_tags Replication Server WRK FRR AY SEX HS BE Hos subcommand values commit transaction rollback transaction Replication Server origin time origin qid tran id MRB HafeXXGXRE Replication Server EH fit tx iil E A AA H BJ
16. binary nocase Replication Server ATA 1 30 1 30 Replication Server PAB AP SEN GE AIA 30 2 Replication Server
17. WAN WAN LAN FW EAI AL
18. 31 ZEB E E HRE VPK PR BL ITER 55 OLTP OLTP 32
19. Replication Server WEB Replication Agent Replication Server conu LLL 143 connect source 144 get maintenance user 146 get truncation 147 distribute 148 RepAgent 160 K B 1 RepAgent Adaptive Server Replication Agent LTL x B 1 BHAftERE ARS BS A connect source Replication Server get maintenance user get truncation Replication Server distribute Replication Server 148 distribute KB 1 Replication Server Replication Agent distribute Replication Server LTL 143 connect source connect source Replication Server RepAgent
20. IMB 2MB WAN 137 A MAKE tid RS JB BER Replication Server Replication Agent LTM RSSD RSSD 10MB 10MB 12MB RSSD RSSD
21. Replication Server Replication Server 3 8 NY DS pubs2 BOSTON DS TOKYO DS A 3 8 HEHEH Standby E OSI Inbound Queue BOSTON DS Data Server C Peps Database pubs Database To Tokyo Site NY DS Data Server Client Applications pubs2 Behe R AR ABE PN EB PE GUEE a H pubs2 EZE EIN 7 A F
22. Replication Server Replication Server Execute this script at Sydney replication server Creates subscription using no materialization for upd publishers pubs2 create subscription upd publishers pubs2 sub for upd publishers pubs2 with replicate at SYDNEY DS pubs2 without materialization go end of script LI wl Replication Server Replication Server Execute this script at Sydney replication server Creates subscription using bulk materialization for upd publishers pubs2 define subscription upd publishers pubs2 sub for upd publishers pubs2 with replicate at SYDNEY DS pubs2 go 38 Replication Server activate subscription upd publishers pubs2 sub for upd publishers pubs2 with replicate at SYDNEY DS pubs2 go Load data If updates are in progress use activate subscription with the with suspension clause and re sume connection after the load validate subscription upd publishers pubs2 sub for upd publishers pubs2 with replicate at SYDNEY DS pubs2 go end of script
23. 1000 500 Sybase Central Replication Server 25 ER EXTR HU ZA Replication Server
24. Replication Server 15 Replication Server Replication Server 12 0 Adaptive Server Enterprise 12 0 Sybase Replication Server Replication Server Replication Server 19 Sybase D Sun Cluster 2 2 VO
25. Adaptive Server SQL Server Replication Server Replication Server Replication Server 23 TA BE BEBE XT Ir A FEIF KI I 2 4 g 2 4 PERIOD Active standby Data Server Data Server Active ecce id Standby Database Database To other Replication Servers or destination databases PA gir IAH FET PH P3 AP 33098 EE CRNA E Tl R 290 PEK EP EDS JE ARDEA REPPIN AN TA Ce ae esi Fe A EAN G2 hl tL AY HE Replication Server RepAgent
26. InboundTableVolume InboundTableVolume InboundMsgSizeupdate ChangeRateupdate InboundMsgSizeinsert ChangeRateinsert InboundMsgSizedelete ChangeRatedelete InboundMsgSizefunctionl ChangeRatefunctionl InboundMsgSizefunction2 ChangeRatefunction2 Replication Server HRA REMH wl OutboundTableVolume OutboundTableVolume OutboundMsgSizeupdate ChangeRateupdate OutboundMsgSizeinsert ChangeRateinsert OutboundMsgSizedelete ChangeRatedelete OutboundMsgSizefunctionl ChangeRatefunctionl OutboundMsgSizefunction2 ChangeRatefunction2 H ChangeRate ChangeRate date CpangeRateiiser InboundMsgSize OutboundMsgSize 123 TransactionVolume InboundTransactionVolume InboundTransactionVolume MsgSizecommit MsgSizebegin InboundTransactionRate MsgSizepegin MsgSizecommit 450
27. command_tags origin_time datetime_value origin_qid binary_value tran_id binary_value mode 0x08 standby_only 1 0 origin time datetime origin time begin transaction commit transaction rollback transaction origin qid 32 Replication Server RepA gent 148 B 3 tran id 120 ID ID ID RepAgent FZL PRR SUM tran id tran_id data_server database tran_id RepAgent
28. 112 Replication Server Unicode ATX BIEILEBIIESI 7 4 7 4 Ri HCHSCHI Sort Order ROS Replication Server Replication Server Replication Server Unicode Replication Server 4i WB Unicode Replication Server RS unicode sort order unicode sort order unicode sort order 7 1 Sybase Unicode binary Unicode Replication Server 115
29. extra cheese avocados sour cream alter replication definition add add searchable columns alter replication definition replication_definition add column datatype column datatype add searchable columns column column replicate minimal all columns RCL Transact SQL Ai AN SURHEL 9 RCL Replication Server RCL
30. ADIER EITE OR AAO Replication Server sp_setreptable n 1 2 f bx EE RE 3 3 213 3 fM ERE E 2e E Si P Priman data fie ne Repleate datafics o P Primary and r
31. Sybase Central rs init Replication Server Replication Server AS A ACS Ta BS o Replication Server admin logical status rs init dump load fe d bcp Replication Server a Replication Server rs_init dump load b Adaptive Server c d Adaptive Server Replication Server 9 Replication Server resume connection admin logical status
32. WAN Tis AK PR BL 55 Replication Server 1 gal 55 58
33. RSSD Hehe SS sou Be Eo AR AR EAN KA A WD Replication Server 19 RSSD RSSD RCL RSSD Replication Server Replication Server Replication Server Replication Server Ay RAK E BRA IR B o Wa te BU SAR SCM AE de A hes UR H A Ft Ee FU Replication Server HJ TH Rs AKAMA wield Replication Server Replication Server 458 MOROKE
34. 1 1 Replication Server WAN 1 1 EA ui H Replication Server Replication Agent Dii Data Server plication Replication Server 1e EN Replication Server Replication Server E HAIE AH Replication Server Replication Server Replication Agent Replication Server Replication Server Replication Server HH e EI E Uo Replication Server Replication Server RSSD Adaptive Server Enterprise ERSSD Ci Ast RSSD Adaptive Server Anywhere Repli
35. Replication Server Replication Server Replication Server Replication Server WREN Replication Server Replication Server 1032 fjr TA Replication Server 2 3 4 Replication Agent Sybase Replication Agent Sybase Adaptive Server Sybase SQL Server 6
36. DV AEH TA IA PNW POR AC RSM Server WWI fi Replication Server A F Replication Server Replication Server BUF FES RDA BL WUT AA 109 FEF MAF 110 7 1 El 7 1 iE Sort Order ROS PDS Characbr Set 9 Conversion PRS RRS Replication Server select Replication Server Replication Server at LATA SAFER Replication Server
37. Replication Server sp_setreptable Replication Server Replication Server Replication Server JH PA o TER 3 1 CRER Wu EB AP mM Be Re et 3 8 EP a publishers GRE TAE publishers Ze fili publishers pub id 1000 33 ZEB E E it RE A 3 1 ARREN EK EZ HRE Primary 2 Client application Data i changes primary data Primary aite Communications Network l Peplicate e e publishers Execute this script at Tokyo data server Marks publishers for replication sp setreptable publishers true go end of script
38. Replication Server Adaptive Server RSSD LTM AA SUE I Adaptive Server Replication Server where lastname MacGregor dict binary MacGregor Sybase rs_subcmp
39. Replication Server 24 FAK E Aa RI Henn 1 23 2448 AS Lb 55 3 200 x Replication Server
40. in AF TE GE FOP MF Adaptive Server 1 RASE Adaptive Server Replication Server Adaptive Server LIM Replication Server RSSD WRECKS RK AF Replication Server Adaptive Server Sybase AUR EE AP POTE MUP Sybase Replication Server 2 Replication Server Adaptive Server
41. Replication Server SSL SSL SSL SSL ARKH ARZE OUI WA 17 18 Replication Server Replication Server Sybase 2 m Replication Server Replication Agent Replication Server Sybase Replication Server Replication Server
42. Open Server Replication Server 54 Replication Server ITER KME
43. data server database RepAgent 149 distribute mode standby only begin transaction 150 Replication Server A 7k HEN 22 H PUE AAE WUC mode ZZ WSZ PIMA Mar TU xe FE WRA AM mode LTL 200 Replication Server 11 5 standby only standby only 1 WRH standby_only 0 standby only LTL 200 Replication Server 11 5 begin transaction commit transaction rollback transaction begin transaction distribute command_tags begin system transaction tran_name for user password no password AK command_tags j 149 6 system Replication Server
44. rs_subcmp rs_subcmp Replication Server 85 Wk e fa Wl Replication Server Replication Agent Replication Server Replication Server 19 Fe 86 Replication Server Replication Agent
45. stop_replication Replication Server create error class assign action Replication Server rs lastcommit 100 rs lastcommit Replication Server rs lastcommit rs commit Replication Server Replication Server rs_lastcommit Replication Server 6 FF E BIA TASSE S K 6 2 Jt f rs lastcommit 3 6 2 rs lastcommit 477 origin int H1 Replication Server origin qid binary 36 ID secondary_qid binary 36
46. 2 2 2 2 f LAN HABZHREH Primary aite Read Write Client S Applications 9 Me Read Ornly Client Applications 26 e i IEE FAL OLTP 22 2 3 salesdetail A 2 3 RE T ERI chicago Mew ork san Francisco salesgia i sates salesobiai Hi REARS por por Primary Fragments
47. OAT DMA ee ie PEE ERASE HE HL VATH VES Be HG LIE ODER FET AR TE i EAS TA Jf TERI ST SE a KE SS tho SURYA eee PIB AA UES 29 ER EXTR HU ZA 30 Replication Server Replication Server 31 32 39 44 48 50 55
48. El 1 2 IETERU H Fie plica don geryg 3 Re plica Ed Replication Server 18 EN Replication Server Replication Server EARS ai Vit 19 ed ARS A o Replication Server Replication Server Replication Server Replication Server Replication Server Replication Server Replication Server WAN Replication Server Replication Server Replication Server Replication Server Replication Server
49. Replication Server rs init Replication Server Replication Server RCL Replication Server Replication Server EZ 5 Replication Server Sybase Adaptive Server Replication Server Replication Server Replication Server Sybase Central Replication Server X Replication Server Web Sybase
50. WAN LAN WAN OLTP Replication Server WAN WAN WAN Replication Servers
51. Replication Server Replication Server Replication Server Replication Server Replication Agent Replication Server Replication Server LAN WAN Replication Server Replication Server IZH Replication Server AR AHF Replicat
52. RPC Open Server Adaptive Server Replication Server 1e EN TE A PR UY PR Be TT PRS i PE n o PE 2 BU IR ato Replication Server A ZHAWURE VATI P RAB ths BERRA SE EP IS IT IY SQL SQL RPC Replication Server Replication Server Replication Server grant revoke Replication Server 12 0 Replication Server 12 5 SSL Replication Server 25 Fig AN fg 22 Replication Server
53. RSSD 7 Replication Server Replication Agent Replication Server
54. Replication Server Rep Server RSM Server RSM Client RSM Server RSM Server Replication Server Replication Server RSM Server rsmgen UNIX RSMSetup Windows NT rsmgen RSMSetup Replication Server Sybase Central Sybase Replication Server RSM Client SYBASE RSM Server Sybase Central RSM Client SSYBASE Open Client Server RSM Client RSM Server au RSM Server UR PAF ERAGE BERA
55. Replication Server Adaptive Server SQL Server a E AEF 52 sp_reptostandby sp reptostandby DML DDL Replication Server 15 send warm standby xacts sp_config_rep_agent RepAgent a RepAgent replication_role replication_role E PIR 8 ID ee Replication Server create logical connection UR A BIBRA FIER ZS Ay PPS IE WE
56. Replication Server 7 AUR EWRIPLRER 7 2 7 2 RIT Characbr Set PDs PRS Sort Order Conversion RRS BP e Adaptive Server RepAgent e Replication Server Replication Server Replication Server RSI Replication Server x FEF MAF 7 3 rs subemp 7 3 iTV Sort Order Sort Crd RDS Character Set PDS Conversion PRS RRS rs_subcmp NDE IRA Ae o EB ARA si PUE FIT BUD Pe RA et TS BH ARS i TR rs subemp rs_subcmp select
57. A 3 5 RE ZA EB SES ARE Primary Fragrnerit Mew S ark Headquarters Primary Fragment san Francisco 45 E SE 3 6 salesdetail A 3 6 RASRERMNR hicago Sor UTE ny sales sub sf sales sub Mew ork Sor Francisco saeco ta salesdetail Execute this script at Chicago RSCHI Creates replication definition chi sales create replication definition chi sales rep with primary at DSCHI DBCHI with all tables named salesdetail stor id char 4 ord num varchar 20 title id varchare qty smallint discount float primary key stor id ord num searchable columns stor id ord num title id go end of script 46 Replication Server Execute this script at New York RSNY Creates replication definition ny sales Greate replication definition ny sales rep with primary at DSNY DBNY with all tables named salesdetail stor id charta ord num varchar 20 title id varchar6 qty smallint discount float primary key stor id ord num searchable columns stor id ord num title id go end of script Execute this script at San Francisco R
58. OLTP LAN E Replication Server 2 1 El 2 1 FLAN HABZHREH OLTP Applications Decision Support Applications ASH EVERE BCR ERI AY A EAER E o MTT AY eA Replication Server 28 BRAM TE FARAY publishers publishers2 55 Adaptive Server Replication Server KAIT E WAN
59. Replication Server Replication Server Replication Server 19 24 26 Replication Server 3 Replication Server TRE SLAF OLTP OLTP Bh tt RISC RE SEP si
60. Replication Server 1 3 11 ETRE WW RAAF A 1 3 PME PHA Hong Kong HPA AIRD T ETARE BERK T EERS usu ls 2 Xt 4T SUBE E TRIS GITARE Bs HPE es 2h H A BY WRAAE PTE BR ERS DA A FE E 1 4 El 1 4 ERS PHBA Replication Server WAN 1 4 12 Replication Server 18 EN Replication Server Replication Server
61. 16 2 NFE WME UTF 8 BMP 4E Replication Server Adaptive Server UTF 16 unichar univarchar Z BH Unicode UTF 8 unichar univarchar Replication Server 12 5 2 5 Replication Server RSM Server BTE ALE WRIPLRAR RSM Server Replication Server ETE RSM Server RSM Server Replication Server Adaptive Server SQL Server RSM Server 4 E M T S ELE RSM Server SJIS RSM Server WANEH EUCJIS RSM Server RSM Server RSM Server W RSM Server
62. deliver as upd_publisher_pubs2 Execute this script at Tokyo replication server Creates replication definition create function replication definition upd publishers pubs2 req with primary at TOKYO DS pubs2 deliver as upd publisher pubs2 pub id char 4 pub name varchar 40 city varchar 20 state char 2 go L end of script
63. Sybase Replication Agent Sybase Replication Agent DB2 Universal Database UNIX Windows FR E Informix Microsoft SQL Server Oracle Replication Server DB2 Universal Database Sybase Replication Agent DB2 Informix Microsoft SQL Server Oracle Sybase Replication Agent EJER A ONS A Ri IISA Replication Agent Replication Agent LTD LTL Replication Server 91 Replication Agent A 5 3 Sybase Replication Agent RBA Log Transfer Manager Log Log Transfer Interface K Reader UK i Replication Agent Replication Agent Transaction Log LTL out to Replication Server Transactions Read from Log Primary Database Sybase Replication Agent Replication Server Rep
64. upd_publishers_pubs2 35 ZEB E E it RY sp_setrepproc Replication Server Replication Server A 3 2 fH ITUR AHORA E E Pe Primary site sored m that changes 2 primary data here EER Se Network 2 res Replicate ne Corresponding stored qos He es procedure executes to F p Replica E change replicate data Da EET EE E CET EE EET EE EE EE EET EET IS CELL ECCE 36 Replicatio
65. HS Replication Server LTM Xf Ek ER VA A AER acl EA ES NER H oes OC 1MB 2MB Sybase RepAgent Adaptive Server 138 Replication Server HRA BuU Replication Server LTM RepAgent Adaptive Server Replication Server Sun SPARCstation Replication Server 7MB DSI 500K MD md source memory pool TEX RepAgent BK LTM 500K A SQT AF sqt_max_cache_ size
66. RowWidth MEH T A HRABE InboundMsgSizebegin OutboundMsgSizebegin 250 InboundMsgSizecommit OutboundMsgSizecommit 200 450 So WRAY SE SEAT Y EKE InboundMsgOverhead 380 ID OutboundMsgOverhead 200 ID ColOverhead 30 E b ARAN NumColumns NumColumnsChanged 30 NumColumnsChanged 2 NumPrimaryKeyColumns 30 Replication Server
67. T1 T2 T3 OutboundQueueVolume Hi T EET OutboundQueueVolume OutboundQueueVolume sum OutboundTableVolume ReplicationSelectivity OutboundTransactionVolume OutboundTableVolume WEK A EF 126 ReplicationSelectivity WME X H 4 A 2 HHAH AU TET TransactionVolume Messagepegin Message commit 250 FFE 200 FFE RA TransactionRate 1 OutboundQueueVolume OutboundQueueVolumeS1 OutboundTransactionVolume TableVolumeTi ReplicationSelectivityT1 S1 TableVolumeT2 ReplicationSelectivityT2 S1 TableVolumeT3 ReplicationSelectivityT3 S1 OutboundQueue Volumes Sitel 450 5 10K sec 0 1 8K sec 0 4 5K sec 0 2 7K sec Site2 450 10 10K sec 0 4 8K sec 0 8 5K sec 0 15K sec Site3 450 8 10K sec 0 4 8K sec 0 5K sec 0 2 9K sec OutboundQueueSize OutboundQueueVolume FailureDuration SaveInterval HF OutboundQueueVolume FAN WY R BEN BDU H Failur
68. 125 Agi BRAZZER D Hala RA RAS AKAMA 126 InboundTableVolumeupper Max InboundMsgSize ChangeRate OutboundTableVolumeupper Max OutboundMsgSize ChangeRate Max InboundMsgSize Max OutboundMsgSize GEA A AB ANTE IS X ChangeRate
69. 83 PR tea He 84 OLTP Replication Server Replication Server add partition Replication Server MIRARI XP Ad Replication Server Replication Server RSSD
70. 113 FEF MAF 114 He 7 1 SFY Unicode FE FMi F defaultml UTF 16 ML altnoacc CP850 it altdict cp850 altnocsp CP850 scandict CP850 scannocp CP850 binary UTF 16 dict Latin 1 nocase Latin l iB WAKDS nocasep Latin 1 XE RAK DSA noaccent Latin 1 KE RASS espdict Latin 1 espnocs Latin 1 espnoac Latin l rusnocs 8859 5 cyrnocs 8859 5 elldict 8859 7 hundict 8859 2 hunnoac 8859 2 hunnocs 8859 2 turknoac 8859 9 turknocs 8859 9 thaidict CP874 utf8bin UTF 8 UTF 16 rs_subcmp Unicode Replication Server rs_subcmp Replication Server BTE ALE WRIPLRAR Adaptive Server
71. insert title ID publisher publisher title ins_publishers ins titles ins pub title Execute this script at NY and SF data servers Creates stored procedure create procedure ins publishers pub id char 4 pub name varchar 40 null city varchar 20 null state char 2 2null as insert publishers values pub_ id pub name city state end of script Execute this script at NY and SF data servers Creates stored procedure create procedure ins titles title id tid title varchar 80 type char 12 pub id char 4 null price money null advance money null total sales int null notes varchar 200 null pubdate datetime contract bit as n RAYE HEL PRG if not exists select pub id from publishers where pub id Gpub id raiserror 20001 FATAL ERROR Invalid publishers id else insert titles values title id title type pub id price advance Gtotal sales notes pubdate contract end of script Execute this script at NY and SF data servers
72. 80 200K fstr_ cachesize 250 RepAgent AFEK RepAgent Adaptive Server AF text image TERTIT Sybase Adaptive Server te AEA IER text image 140 RepAgent k LTM Adaptive Server 5612 FIH Tki H a RepAgent Ja Adaptive Server RepAgent 2332 128 DPT
73. Replication Server Replication Server Replication Server Replication Server Replication Server
74. A KA Re AP Replication Server insert delete begin transaction Replication Server BoA REE Ua m WAT P FE Replication Server Adaptive Server DB2 2 Replication Server RPC SQL RPC Replication Server RPC pki Al 4F
75. WAN amp ill SUE B3 DL Ea Replication Server Replication Server FFA Replication Server Replication Server
76. RSM RSM Client Sybase Central Replication Server Open Client RSM Client Sybase Central GUI RSM Server Open Server RSM Client RSM Server Sybase Sybase Sybase Sybase xvii FIER xviii Replication Server KEHA Replication Server l 2 3 6 9 13 Replication Server FER BG IRA da SCF Replication Server 15 18
77. Replication Server publishers Execute this script at Tokyo replication server Creates replication definition pubs rep create replication definition pubs rep with primary at TOKYO DS pubs2 with all tables named publishers 34 Replication Server pub id char 4 pub name varchar 40 city varchar 20 state varchar 2 primary key pub id go end of script Replication Server Execute this script at Sydney replication server Creates subscription pubs sub Create subscription pubs sub for pubs rep with replicate at SYDNEY DS pubs2 where pub id gt 1000 go end of script WAN CREO FE upd publishers pubs2 publishers upd_publishers_pubs2
78. InboundTransactionRate OutboundTransactionVolume OutboundTransactionVolume MsgSizecommit MsgSizebegin OutboundTransactionRate Hu MsgSizegegin MsgSizecommit 450 NF OutboundTransactionRate 127 Nie WW a 2 2 OutboundTransactionRate mboundTransactionRate 50 20 1 1 OutboundTransactionRate 5 50 0 5 0 2 3r Mit OutboundTransactionRate InboundTransactionRate OutboundTr
79. TE FETA Bi fk 82 Replication Server 458 JU ER TEE Replication Server FEIT UL Fe GEER a iy Rea AUS NT IER Be BE 2J SR v DRE Replication Server
80. 159 RepAgent Zr A RepAgent RepAgent Replication Server Replication Server T1 T2 T1 begin transaction T2 begin transaction Tl insert into authors karsen 510 534 9219 T2 update authors set phone 510 986 7020 where name green and phone 415 986 7020 T2 commit transaction T1 commit transaction LTL RepAgent Open Client Client Library Replication Server isql LIL distribute Orlgin tame Dec 10 1992 8 149 12 750AM origin qid 0x00000000000000000000000000000001 tran_id 0x000000111111 begin transaction T1 for user password distribute Gorigin time Dec 10 1992 8 48 12 750AM origin qid 0x00000000000000000000000000000002 Gtran id 20x000000222222 begin transaction T2 for user password distribute origin times Dec 10 1992 8 48 13 750AM Gorigin qid 0x00000000000000000000000000000003 tran_id 0x0000001111 applied authors rs insert yielding after name karsen phone 510 534 9219 distribute origin time Dee X0 1992 8 48 1934750AM origin qid 0x00000000000000000000000000000004 Gtran id 20x000000222222 applied a
81. 11 27 warmstdb 145 FAT AMBRE 97 142 119 146 get maintenance user LTL PEFR EIB ARS AS PIE 97 16 7 84 140 EE 167 Al X x 58 WA 13 125 133 103 124 124 Ae B 104 86 25 12 Y yielding 153 24 25 25 23 29 FER HERA at 95 D NNER 39 32 43 50 47 48 35 158 109 113 ER 39 109 113 70 tite xiii GE 104 14 168 ID 88 ID 147 147 xi iW x Z zerolen text status 155 47 48 49 49 11 69 CE 22
82. ii Adaptive Server RepAgent RepAgent send_maint_xacts_to_replicate RepAgent send_maint_xacts_to_replicate true RepAgent Replication Server ay 3x LIM A Replication Server 3 7 413 7 RAPAE HA ERP Primary Fragment Headquarters Fc Corporate Rollup RepAgants senc_maint_xacts_to_replicate os Set fe Trug or LT started with Agption Chicago ee Primary Fragment Mew York T Consolidated data i i replicated to other sites San Francisc
83. salesdetail stor id stor id 7067 stor id 5023 stor_id 8042 a 3 E SEHUEND Replication Server 28 BRAM TE FARAY OLTP
84. Replication Server Replication Agent 3 E grant revoke Replication Server K 1 1 Replication Server 1e EN zx 1 1 Replication Server IR Sa sa Fm n EAT T TET Replication Server create object Replication Server primary subscribe create object create object primary subscribe
85. Replication Server ID ID Replication Server ID ID 147 distribute distribute 148 K B 3 Adaptive Server RepAgent ID Replication Agent J ID FFA ID 4 B 3 Adaptive Server RepAgent HAZI ID B97 zt Th AR 1 2 3 8 THUR H as W HF TH ER o 9 14 ID ID 4 2 Pie 15 20 ID 21 28 29 30 RepAgent 31 32 21 28 8 ZT datetime Replication Server
86. Replication Server RepAgent RepAgent Replication Server Replication Server 11 0 ME RHAH connect source Replication Server ID ID 147 ID Replication Agent Replication Server 11 0 11 0 145 get maintenance user connect source FE connect source NY DS BEARS 28 F Stocks db 2 RepAgent RepAgent Replication Server Replication Server 11 5 LTL 200 connect source lti NY DS Stocks db 200 VERSION 200 Sysversion UpgradeLocater 1150 0x000000000 get maintenance user R
87. configure connection FXR Replication Server 109 105 Unicode UTF 8 UTF 16 UTF 8 UTF 16 106 Replication Server Unicode UTF 8 Unicode unichar univarchar UTF 16 Unicode Unicode Adaptive Server UTF 8 UCS 8 650 UTF 8 8 Unicode UTF 8 ASCH 0 127 1 2 3 Basic Multilingual Plane BMP pd Te s Adaptive Server Oracle IBM UDB Microsoft SQL Server Informix UTF 8 UTF 16 UCS 16 Unicode
88. Open Server Replication Server Replication Server Interfaces Open Server JX create connection Replication Server Replication Server create connection 97 Replication Server Replication Server Adaptive Server HDS Replication Server 12 7j DB2 Informix Microsoft SQL Server Oracle HDS Sybase Replication Server
89. Replication Server Replication Server rs_init Replication Server Replication Agent Replication Server Replication Server Replication Server Replication Server Replication Server ZEE AORE E E 0 e ES ET Be Pg OT ES BLA o Sybase RAMA HE Wat MFE iw Be As BARERA W Ai EME MS HA AP im AE ME BH TE Replication Server EAT FY E ADEE i ST EE RJ m P ULE 16 Replication Server 8
90. 2 6 Al 2 6 iI TEAR AREK EHHE Replication Sever Prima odistibutes pimay Site Y Po npdates made by focal Po chentsand by request juMehonsinitiated at remote sites _ i Ed uM D E Cienatrihe monary TT site can update primary e PER data directly EE ee aad vies ee Replicate site i use request functions to t j update primary data chrorousiy mice memes Replication Server Replication Server Replication Server Replication Server Replication Server 28 EAM IEEE RIT WREST EDR Wythe BENS ETGEN fi BEND SHE TE PETS RAIN ACES TEE ARS NA PEN URETRA SE BOVE DSL
91. KFKF Sybase Getting Started CD Sybase Technical Library CD Technical Library Product Manuals Web Getting Started CD PDF Technical T CD Getting Started CD Getting Started CD Adobe Acrobat Reader Adobe Web CD Technical Library CD DynaText Technical CD Technical Library Technical Library Z2848 FA Technical Library Product Manuals Web Technical Library CD HTML Web BRT mF EBF Update Technical Document Case Management Solved Case Sybase D veloper Network Technical Library Product Manuals Web http www sybase com support manuals Product Manuals CP
92. 10 isal JE FT ET o 54 Adaptive Server switch active 51 3 8 1 ft Replication Server switch active HE JE o 2
93. LTM LTM LTM language 3 z Replication Server LIM Replication Server nh tt att 7 BIEILEBR II ESI Replication Server RSM Server Sybase SEE AAS ril TS AZT AY BOI AT bas RIT IAT REIR T ER e FAT ERD MAE Open Client Client Library Sybase 7 ASCII 7 ASCI a EE TIE AN ETE
94. DDL sqlddl append sqlddl append first last ddl string first DDL last DDL ddl string DDL dump RepAgent Replication Server dump FMS MEK rs dumptran rs dumpdb distribute command_tags dump database transaction database_name dump_label id database_name dump label varchar 30 RepAgent varbinary 36 HY fal zx dump purge Replication Server begin ID ogid ID distribute command_tags purge open xact to oqid ogid YD ID purge LTL 102
95. Replication Server ne BY AE LK o OLTP A OLTP 19 26 Replication Server E2xXx BAIKARA Replication Server 2 5 A 2 5 UT MBLP ERE React rite Client Application
96. Replication Server rs commit rs dumpdb rs dumptran rs get lastcommit Replication Server rs get lastcommit 6 2 rs get lastcommit select select origin origin gid secondary qid from rs lastcommit Sybase Central Sybase Central RSM Sybase Sybase Open Server 95 Replication Server Sybase Central Replication Server Sybase Central Sybase Central RCL isql
97. Replication Server RIX commit transaction rollback transaction rollback commit transaction rollback transaction rollback distribute command_tags commit transaction rollback transaction rollback from oqid to oqid commit transaction rollback transaction transaction rollback ID oqid e rollback ogid ID xd DB2 rollback to ogid ID e rollback from ogid1 to ogid2 ID Replication Server RepAgent ASA applied F M applied EDT execute text image i distribute applied distribute command tags applied owner owner_name Ctable rs update yielding before pa
98. a 1t Replication Server admin logical status b Replication Server H o 3 RepAgent 53 E AEF 4 Replication Server VHI FEZ drop connection MS Wr F AGE EXE TE Wa FY DA ORE ES 5 EH isa A 3 9 WALENABORA NY Des ns pai agy a Active Database TON DNE A T Datahase a mm L LLL BOSTOM Ds Data Server Client Applications Replication Server i ob os AF o amp EL US IR AS d ARROL HRH Ett DY
99. 91 8 92 Sybase 87 13 Replication Server 23 Replication Server Manager 166 Replication Server RSSD replication role 52 rollback transaction distribute 151 rs datarow for writetext 154 rs db2 function string class 98 rs default function string class FRA BA 98 rs delete 153 rs get lastcommit 102 rs insert 153 rs lastcommit 100 rs marker RepAgent 158 rs subemp 111 111 rs update 153 rs writetext 155 RSM 25 RSM Client xvii 107 RSM Server xvii 105 RSM Replication Server Manager RSSD 92 What EK 120 82 50 54 23 51 91 87 91 Hite eS 87 LTL 143 128 135 129 135 124 Replication Server S send maint xacts to replicate RepAgent 4
100. ID origin_time datetime dest_commit_time datetime origin time dest commit time origin rs_lastcommit rs dumpdb rs dumptran Adaptive Server SQL Server rs_commit rs_dumpdb rs dumptran rs update lastcommit rs lastcommit Create a procedure to update the rs lastcommit table create procedure rs update lastcommit origin is origin qid binary 36 secondary qid binary 36 origin time datetime as update rs lastcommit set origin qid origin qid secondary gid Gsecondary qid origin time origin time commit time getdate where origin origin if rowcount 0 begin insert rs lastcommit origin origin qid secondary did Origin time commit Ime padli pad2 pad3 pad4 pad5 pad6 pad7 pad8 101 rs get lastcommit HH values Gorigin origin qid Gsecondary qid Gorigin time getdate 0x00 0x00 0x00 0x00 0x00 0x00 0x00 0x00 end go
101. Replication Server Replication Server sit V HTREHETESEUBEREXESR AERA TRYIN TR SE A ACS KB AR EHTS 65
102. 131 TE 132 PERT ww 133 133 a E i EEE TE EEA TE ETE 134 PR S FNERIT EE NN 135 135 EC Na EE poi een in renti cn FERE 138 138 Re 138 138 139 Replication Server A FEX sse 139 RepAgent 139 Eu Bt e RUNE 141 0 Jg ESEE E E EE E A 142 142 B SES QNT 143 i 143 DCOHTIDETL eo nd nas 144 c4 l M M 145 EEE E E AE A E E N 145 connect source 146 get maintenance USer pp 146 get Wun 0 147 ID Lesen 147 148 149 0 150 applied ww 151 vi Replication Server execute es 157 sqlddl append Ne 159 dtt EN REM a ERR Ke REN E EHR REN AURA ERR N E 159 purge EG RI EI IET ETT 159 RepAgent 160 ETE N E E ENE NEOR ENEE eh NM ee Eh et ET EE AE UD pe 163 vii HK viii Replication Server Replication Server Replication Server
103. 26 RPI 26 PF vin ET 9 16 RepAgent 13 28 26 84 Unicode 106 115 RSM Server xd5 s 117 105 108 105 105 137 123 Replication Server
104. 3 base 64 Y base 64 d3 d2 dl 3 d3 len 64 64 len len d3 64 64 d2 len 64 dl len 64 text 126 d3 0 d2 1 d1 62 33 WERN M 0 33 1433 62 33 I LIL LTL blurb text writetext distribute Gorigin qid 0x00010000010000 Gtran id 20x00018238 applied texttest rs datarow for writetext yielding datarow Gtitle id BU1032 Gprice 90 00 blurb hastext always rep Gpicture hastext always rep distribute Gorigin qid 0x00010000010001 Gtran id 20x00018238 applied texttest rs writetext append first last changed with log textlen 126 blurb Straight Talk About Computers is an annotated analysis of what computers can do for you a no hype guide for the critical user distribute Gorigin qid 0x00010000010002 Gtran id 20x00018238 applied texttest rs writetext append first with log textlen picture amp 0X010
105. 52 PNA text image EZT A 2K text image text image text image Replication Server LIM LTM HRA BuU RepAgent Adaptive Server RepAgent RepAgent ct lib Replication Server ct lib f SAF LIM LTM 4MB LTM 1 MB LTM SMB LIM LTM TransactionRate DurationOfLongestTransaction LTMTransactionOverhead TransactionRate DurationOfLongestTransaction
106. E Replication Server AD N SR PR EIT 63 RAYE HEL PRG El 3 12 RA Primary aite procedure executes to i change primary data Function replication definition here Communications Meteark poc j procedure does not change data but its upd_publisher_pubs2 upd publishers pubs2 req Execute this script at Sydney replication server Creates stored procedure upd publishers pubs2 req create procedure upd publishers pubs2 req pub id char 4 pub name varchar 40 city varchar 20 state char 2 as begin if select 1 gt 1 print Submitting request end go end of script 64 Replication Server Replication Server
107. Replication Server 28 EAM EE RIT TA e Se ER 55 B XL HE 100 HE 1000
108. Replication Server 12 0 Replication Server Adaptive Server ETRE WW RAAF 10 Replication Server Man JAA te Replication Server Replication Server TAK AY ER IRI B Y E XA Replication Server Replication Server 4 H AER FEIN TAS A H1 S Replication Server Sybase Central EV rs init Adaptive Server SQL Server Replication Server Replication Server 1 2 KR T Replication Server
109. Adaptive Server Adaptive Server Replication Server Replication Server 1 CRY 100 OutboundQueueVolume OutboundQueueVolume Wize XJ I OutboundTableVolumes OutboundQueueVolumeupper sum OutboundTableVolumes OutboundTransactionVolume 129 Nips WW ma 2 2 OutboundTable Volumes 20K 10K OutboundTransactionVolume 1K 5 WI OutboundQueueVolume 20K Sec 10K Sec 1K Sec 31K Sec ReplicationSelectivity OutboundQueueVolume OutboundQueueVolume sum OutboundTable
110. LTL MS Replication Agent FH Replication Agent RepAgent Adaptive Server LTM Sybase SQL Server Replication Agent for DB2 Sybase Replication Agent UNIX Windows DB2 Universal Database Sybase Replication Agent Informix Microsoft SQL Server Oracle Sybase Replication Agent WE Replication Server 5 Replication Agent Replication Agent Replication Agent 5 1 Replication Agent Replication Server FI 5 1 HEER AG Replication Replication Server Agent Data Server
111. Replication Server 12 6 ID DC31036 01 1260 01 2003 10 H 1989 2004 Sybase Inc Sybase 800 68 822 617 229 9845 Sybase Sybase Inc Sybase Sybase AccelaTrade ADA Workbench Adaptable Windowing Environment Adaptive Component Architecture Adaptive Server Adaptive Server Anywhere Adaptive Server Enterprise Adaptive Server Enterprise Monitor Adaptive Server Enterpris
112. Adaptive Server SQL Server Replication Server Open Server Replication Server Replication Server Replication Server Replication Server 95 Sybase ER EE IW Aaa rs lasteommit X Replication Server rs get lastcommit Sybase Open Server Sybase Replication Server ADS 4 45 DB2 Informix Microsoft SQL Server Oracle H
113. Sybase Replication Agent Adaptive Server RepAgent Replication Agent F Replication Agent 87 88 Replication Agent 90 Replication Agent Replication Agent Replication Server P im M EZE EW Replication Server RepAgent Replication Server 11 5 Replication Agent Log Transfer Manager LTMO Sybase SQL Server 11 0 x Replication Agent Replication Agent Replication Control Language RCL Log Transfer Language LTL Replication Agent Replication Server k Replication Server Sybase Sybase Sybase Adaptive Server Anywhere DB2 Universal Database Informix Microsoft SQL Server Oracle Replication Agent Replication Agent for DB2
114. Replication Server Bas XJ Adaptive Server Replication Server Replication Server Replication Server 6 2s Om Replication Agent PRIA PRAISE AF AA AU ER IC S HR 2S e Pm C S1 Sybase C SD Replication Server C SI C SI Sybase DirectConnect Replication Server C SI C SI Replication A
115. Adaptive Server Sybase SQL Server 7 A Replication Server Fit x A eo B Replication Agent Replication Server LTL Sybase Replication Server JE E n BE AIT AE BOTA AAA EP ih CD Sybase Technical Library Replication Server Replication Server Replication Server 12 6
116. 2MB Replication Server HRA REMH InboundTableVolumes MJ UME HA FI shh InboundDatabaseVolume InboundDataBaseVolume sum InboundTableVolume InboundTransactionVolume HF InboundTable Volumes e TransactionVolume Messagepegin Messagecommit 250 FI 200 NEI RA TransactionRate 132 A 3 InboundDatabaseVolumes InboundDatabaseVolumeDB1 23K 14K 450 bytes tran 20 tran sec 46K sec InboundDatabaseVolumeDB2 19K 450 bytes tran 20 tran sec 28K sec InboundDatabaseVolumes DB1 DB2 InboundQueueSize InboundDatabaseVolume TransactionDuration Inbound DatabaseVolume TransactionDuration DB1 DB2 TransactionDuration 10 5 InboundQueue InboundQueueDB1 46K sec 600sec 28MB InboundQueueDB2 28K sec 300sec 8MB 135 Nips WW ma 2 2
117. Ifo EBF Update RCL alter user user set password new_passwd verify password old passwd xiii Replication Server alter user louise set password somNIfic verify password Ennul alter user Replication Server ATA Bron set password new passwd TH ON TAS Items base price money CORR ETERS ARR Bh ATT X 1 JUI UE
118. text X image RPC X rs_writetext PA AK rs_writetext 99 ABE BT PRI AP RF RR e ALR RACE FS EB RE TEN DAA EU Replication Server Pa WE 14 Replication Server 6 FN E EVA TAREA S create function string class FUE RAS PBB TT BBR TIE HEUS RRE E RBI Ae FB o rs insert rs update rs delete text BK image text image rs_datarow_for_writetext rs get textptr rs textptr init rs_writetext text X image rs_select rs select with lock PAZ E T RR Replication Server create error cl
119. 133 Nise KW a 2 2 T1 T2 T3 SQL update InboundTableVolume InboundTableVolume Max InboundMsgSize ChangeRate T1 T2 Ta3 TInboundTableVolumeT1 1130 20 23K sec InboundTableVolumeT2 1430 10 14K sec InboundTableVolumeT3 9480 2 19K sec OutboundTableVolume OutboundTableVolume Max OutboundMsgSize ChangeRate T1 T2 Ta3 OutboundTableVolumeTi1 524 20 10K sec OutboundTableVolumeT2 816 10 8K sec OutboundTableVolumeT3 2716 2 5K sec InboundMsgSize OutboundMsgSize WAX H F 133 ChangeRate WHER AR 132 A 1 RSSD 134 Replication Server RSSD RSSD RSSD RSSD
120. Adaptive Server 444 H is 9 3 Replication Server 4 Replication Server RepAgent LTM 5 Replication Server LIM 6 J Adaptive Server Adaptive Server Adaptive Server 7 RATA KERN Adaptive Server 8 Adaptive Server 9 Adaptive Server Adaptive Server RepAgent LIM Replication Server Adaptive Server dbcc settrunc ltm ignore 116 Replication Server 10 BTE ALE WRIPLRAR Adaptive Server dump transaction db name with truncate only 11 Adaptive Server dbcc settru
121. LTMTransactionOverhead KAA 250 MFT TransactionRate 10 SBS FFA DurationOfLongestTransaction 5 LTM 10 tran sec 300 seconds 250 bytes tran 750K 141 CPU f CPU 142 Replication Server SMP CPU Replication Server Replication Agent Replication Server Replication Server CPU Replication Server Replication Server Replication Server
122. pubs2 get maintenance user for NY DS pubs2 db Maintenance user pubs2 db maint get truncation ID 36 ID RepAgent ID Replication Server RepAgent ID Replication Server get truncation get truncation data_server database data server database Replication Agent Replication Server 36 ID ID 32 Replication Agent 4 Replication Server Replication Agent ID 32
123. HRA REMH E InboundDatabaseVolume 128 OutboundDatabaseVolume InboundQueueSize LransactionDurationy ical TransactionDurationlongest 135 Replication Server Replication Server 16K RAC ERIS AG mu BAe init sqm write delay 1
124. connect source Replication Agent Replication Agent RCL Replication Server Replication Server Replication Server 12 0
125. Adaptive Server 28 H ois 4 Bk rf A AEG AS FAY PUR Ae ITE Adaptive Server 2KB Adaptive Server 119 EK BIL Replication Server Replication Server Replication Server Replication Server RSSD Replication Agent 20MB RSSD Adaptive Server 10MB RSSD 10MB SRSSD Adaptive Server 20 RSSD Replication Server RSSD 20 RSM RSSD RSM 8MB RAM Replicat
126. Replication Server Replication Agent Replication Server Replication Server rs subcmp rs_subcmp
127. ndm rJ Transaction Log Replication Agent Replication Agent Sybase Replication Agent CH F Informix Microsoft SQL Server Oracle Sybase Replication Agent Replication Agent 3 SQL Replication Agent Sybase Replication Agent is Replication Agent A Replication Agent Replication Agent Sybase Sybase Replication Server Sybase Sybase Replication Agent e Replication Agent for DB2 Sybase Replication Agent Replication Agent Replication Agent for DB2 Replication Agent for DB2 OS 390 DB2 Replication Server K 5 2 Replication Agent for DB2 Replication Server 5 2 DB
128. 102 Replication Server 7x 103 104 105 109 115 i5 118 Replication Server Replication Server Manager RSM Sybase Central Sybase Replication Server Replication Server RSM Server me 104 Replication Server RSM Server WEEN EA PEE SRA E d sts Ve His mee Ung o priis IE 13 XE AT RAE o A sig HRH Sybase FIRRA ARASH
129. param list H XX create function replication definition create function Replication Server Replication Server rs marker RepAgent Replication Server rs marker rs_api varchar 255 RepAgent distribute Replication Server distribute command_tags param_string rs marker rs marker Grs api 0x1234567 Adaptive Server RepAgent Replication Server distribute command tags 0x1234567 rs api Replication Server MRB sqiddl append purge f gt gt 4 sglddl append LTL 200 DDL create table HJ DDL sqlddl append
130. 115 Replication Server RS_charset Replication Server Replication Server Interface RSI Replication Server BK H R Replication Server CIF REB e Replication Server KIZA S foeda UN FEES TRAE KEAN SAT FR ERR EFT SRS EGE f 4 2k BARRIE Replication Server Replication Server Z EZH dsi_charset_convert Replication Server ze fi AIA Replication Server
131. uuu 29 3 0 31 usse 31 ERE RR 32 Bai Ea e E 33 45 FA I FH BA EE A ET 35 39 RR 41 E ENEN AEE E EE E 43 0 44 46 EO 47 48 50 RR 51 E EEA ES E E 53 iuuenem 55 NORTE 55 58 ooo cece ccc ccccccccccccccccccccccccccececcececececcececeeececececececeeeeeceeeenens 63 caie E ET 69 4 NETS 81 almat E i 81 2 PO EIEE ALEE AEAEE ON EEEE EE 82 82 ETIANI E AET REOR TERR 84 SUUS LLL cepto eda imminuta cecum M vM ore EE ins 85 IV Replication Server 85 i EEE E E A EET T 85 rs_subcmp eene 85 D 02 MEME EEE 86 86 5 Replication Agent 87 Replication Agent 5 87 CO 88 ye 3 RO 89 Replication Agent eeceeeererirrirerierirrrrerrrrrrerre 89 Replication Agent 4 90 Replication Agent for P T 90 Sybase Replication Agent pp 91 6 ee 95 Liuius 95 Sybase 96 Open Server i 97 a a a OTEA A A ERNE AE EA ES AT 97 LE 2g s EE A EA A AA E
132. begin transaction commit transaction Adaptive Server LTL 200 system Replication Server 11 5 tran name varchar 30 Replication Server e user password varchar 30 user password XF LTL 101 RERE password user E XF LTL 100 wser password Replication Server MRB no_password RepAgent LTL 200 no password Replication Server 11 5 commit transaction rollback transaction rollback RepAgent
133. connect source RepAgent LTL connect source connect source Iti data_server database version no sendallxacts warmstdb in recovery data server database RepAgent version no connect source LTL RepAgent LTIM Replication Server LIL Replication Server Replication Server Replication Agente X B 2 Replication Server LIL X B 2 Replication Server 5 LTL H TE Replication Server LTL 12 5 400 12 1 300 12 0 300 11 5 200 11 0 103 10 1 1 102 10 1 101 10 0 100 Replication Agent Replication Server 12 5 LTL 400 Replication Server 12 5 WR Replication Agent Replication Server 12 x LTL 300 Replication Server 12 x Replication Agent Replication Server 11 5 LT
134. Creates stored procedure create procedure ins pub title pub_ id char 4 pub name varchar 40 null city varchar 20 null state char 2 title id tid null title varchar 80 null type char 12 null price money null advance money null total sales int null notes varchar 200 null pubdate datetime null contract bit as begin if pub_ name null exec ins publishers pub id pub name city state if title id null exec ins titles title id title type Gpub id price advance Gtotal sales notes pubdate contract end end of script amp amp delete title publisher del publishers del titles del pub title Execute this script at NY and SF data servers Creates stored procedure create procedure del publishers Gpub id char 4 as begin if exists select from titles where pub id Gpub id raiserror 20005 FATAL ERROR Existing titles else 72 Replication Server delete from publishers where pub id epub id end end of script Execute this script
135. create logical connection 52 create publication fp 58 create subscription 38 58 125 153 153 123 29 29 85 Wit 130 136 129 130 136 127 124 WALID IX 7 Wit 7 a BK 121 138 119 13 14 99 D AA define subscription fip 38 distribute LTL 143 148 drop connection 54 dump distribute 159 RCL xiv FFER THA WTKR AL 65 23 15 16 163 Al G 145 T icis get maintenance user aded 143 146 eue ed IL get truncation LTL 143 147 55 57 rer id 28 a 29 ee 2 an 29 EME UE 126 125 E 123 130 83 WAN execute distribute 157 ERSSD HON X Replication Server 7 Replication Server 103 RSM Client 107 F RSM Server 107 for recovery
136. notes pubdate contract end else if rep state old state begin exec del titles title id pub_id exec del publishers pub id end else if rep state null begin exec ins publishers pub id pub name city state if title id null exec ins titles title id title type Gpub id Gprice advance total sales notes pubdate contract end end end of script Replication Server ins pub title del pub title upd pub title state old state Execute this script at NY data servers Creates replication definition del pub title create function replication definition del pub title with primary at MIAMI DS pubs2 pub id char 4 u RAYE HEL PRG state char 2 title id varchar 6 searchable parameters state go end of script Execute this script at NY data servers ee Creates replication definition ains pub title create function replication definition 10s pub title with primary at MIAMI DS pubs2 pub id char 4 pub name varchar 40 city varchar 20 estate char 2 title id varchar 6 title varchar 80 type char 12 price money advance money total sales int notes varchar 200 pubdate datetime contract bit searchable
137. publishers Execute this script at Tokyo replication server Creates replication definitions pubs rep and pubs copy rep create replication definition pubs rep with primary at TOKYO DS pubs2 with all tables named publishers pub id char 4 pub name varchar 40 city varchar 20 state varchar 2 primary key pub id go create replication definition pubs copy rep with primary at TOKYO DS pubs2 56 Replication Server with primary table named publishers with replicate table named pubs copy pub id char 4 pub name varchar 40 primary key pub id go end of script Replication Server Execute this script at Sydney replication server Creates subscription pubs sub and pubs copy rep Create subscription pubs sub for pubs rep with replicate at SYDNEY DS pubs2 go create subscription pubs copy sub tor pubs copy rep with replicate at SYDNEY DS pubs2 go end of script Execute this script at Seattle replication server Creates subscription pubs copy sub create subscription pubs copy sub for publ copy rep with replicate at SEATTLE DS pubs2 where pub id 1000 go end of script 57 RAYE HEL PRG
138. upd_publishers_pubs2 upd_publishers_pubs2 publishers publishers pend 3 13 66 Replication Server El 3 13 ARAMA ER Primary aite Function replication deftnitiors for request and applied functions here site 2 m function here Chen application car Y access pending table to s s MN i gee in progress gub shers pend i transactions iesu ij ata Execute this script at Sydney data server Creates local pending table create table publishers pend pub id char 4 not null pub name varchar 40 null city varchar 20 null Statechar 2 null go end of script Bf R E ETE FUR upd_publisher_pubs2 upd publishers pub2 req insert into Replication Server publishers pend Execute this script at Sydney data server
139. BEE DAE ELS TBI HSE o BiB EAE AST A EAT ER BE BR rb 2 ASHES Be EH HAET A I 0 JURE A T ALAR ER
140. Bee TBS LADY F Replication Server Adaptive A E u RSM Server FI LTM HAS JA pie ele ages xx f LAE Pg BUT RAS ds e Adaptive Server Replication Server RepAgent Adaptive Server Fm uH Replication Server RSM Server LTM r1 TU VA Iss inp H Hf Se zz SABA T 2 J obras I PE ARS a8 AAS m CEE ATR JR ei ACHES Replication Server Replication Server RepAgent 2 4 AZ Replication Server Tu AJ RepAgent 1 Replication Server Replication Server LTM EX Replication Agent LTM 2 Replication Server RS language
141. FIRA HAYS A 124 InboundMsgSizeupdate InboundMsgOverhead ColOverhead RowWidth 2 OutboundMsgSizeupdate OutboundMsgOverhead RowWidth 2 NumSites 8 RowWidthChanged InboundMsgSizeupdate InboundMsgOverhead ColOverhead RowWidth RowWidthChanged OutboundMsgSizeupdate OutboundMsgOverhead RowWidth RowWidthChanged NumSites 8 AULA EHI eb BABE we A PAARA AC InboundMsgSizeupdate InboundMsgOverhead ColOverhead RowWidthChanged 2 PrimaryKeyWidth OutboundMsgSizeupda
142. OS 390 DB2 Universal Database Replication Agent Sybase Replication Agent T DB2 Universal Database UNIX Windows amp E Informix Microsoft SQL Server Oracle Replication Agent ZH fT 87 BF AK 88 RepAgent Adaptive Server LIM Sybase SQL Server Replication Agent for DB2 OS 390 Sybase Replication Agent LAN Replication Agent 1 Replication Server 2 Ai connect source 3 Replication Server RepAgent send maint xacts to replicate send_warm_standby_xacts true 4 Replication Server ID RepAgent Replication Server 5
143. RKTT RAE TE 107 FFE Replication Server Replication Server 7 ASCII 7 ASCU Replication Server 7 ASCIT AFF LATE SG dX FTI Replication Server 7 ASCII Adaptive Server Connectivity Libraries ISO_1 CP850 8 RSM Server RS
144. Server Library C H Replication Server Replication Server Server Library Replication Server Open Server Open Server Open Server Open Server Server Library C RPC Open Server APD Replication Server API
145. at NY and SF data servers Creates stored procedure create procedure del titles title id tid pub id char 4 null as if pub_id null delete from titles where title id title id else delete from titles where pub id epub id end end of script Execute this script at NY and SF data servers Creates stored procedure create procedure del pub title Gpub id char 4 state char 2 title id tid null as begin TE otrttle id le null begin exec del titles title ad return end if pub id null end begin exec del titles title id pub_id exec del publishers pub id end end of script update pub_id tile upd publishers upd titles upd publishers upd titles upd pub title 73 RAYE HEL PRG 74 upd_pub title old_state Execute this script at NY data servers Creates stored procedure create procedure upd publishers pub id char 4 pub name varch
146. b c ob yielding yielding before a 5 b 10 c 15 after b 12 LTL 101 RepAgent Replication Server create replication definition text image applied rs_datarow for writetext rs writetext text image Replication Server 10 1 text image Replication Server rs datarow for writetext Transact SQL writetext Client Library ct send data dbwritetext dbmoretext DB Library text image FIREX Replication Server rs_datarow for writetext distribute command_tags appl
147. m FD Sybase Web 1 D Web http www sybase com support techdocs Technical Documents Products Go Certification Report Xy zS JRT yG E Aa i Go Certification Report Sybase Web MySybase MySybase Sybase Web 1 2 Web http www sybase com support techdocs Technical Documents MySybase MySybase xi LYE Sybase EBF xii EBF Web http Awww sybase com support Sybase 2 EBFsUpdates Web 3 4 Go 5
148. parameters state go end of script Execute this script at NY data servers Creates replication definition upd pub title create function replication definition upd pub title with primary at MIAMI DS pubs2 pub id char 4 pub name varchar 40 city varchar 20 state char 2 title id varchar 6 title varchar 80 type char 12 price money advance money total sales int notes varchar 200 pubdate datetime contract bit Gold state char 2 searchable parameters state old state go end of script 78 Replication Server Replication Server upd_pub title Execute this script at SF data servers Creates subscription for del pub title ins pub title and upd pub title create subscription del pub title sub for del pub title with replicate at SF DS pubs2 where state CA without materialization Go create subscription ins pub title sub for ins pub tiele with replicate at SF DS pubs2 where state CA without materialization go create subscription upd pub title subl for upd pub title with replicate at SF DS pubs2 where state CA without materialization go create subscription upd pub titl
149. pub id end end of script Execute this script at SF data servers Creates stored procedure create procedure upd titles title id tid title varchar 80 type char 12 pub id char 4 null price money null advance money null total sales int null notes varchar 200 null pubdate datetime contract bit as if not exists select from titles where title id title id exec ins titles title id title type pub id price advance total sales notes pubdate contract else update titles set ELEILE SO tiele type etype pub id Gepub id price Gprice advance advance total sales total sales notes notes pubdate pubdate contract contract where title id title id end end of script Execute this script at SF data servers Creates stored procedure create procedure upd pub title pub_ id char 4 pub name varchar 40 null city varchar 20 null estate char 2 76 Replication Server title id tid null title varchar 80 null type char 12 null price money null advance money null total sales int null notes varchar 200 null pubdate datetime null contract bit Gold state char 2 as declare rep state char 2 begin select rep state state from publishers where pub id pub id if Gold state state begin exec upd publishers pub id pub name city state if etitle id e null exec upd titles title id etitle etype pub id price advance total sales
150. 2 Replication Agent H 7 Replication System Fri mary Side DB Logs DBZ Replication Agenttor DBZ UDB up Replication LTM for Replication Extract us Semer 90 Replication Server DB2 5 Replication Agent Replication Agent for DB2 Replication Agent for DB2 OS 390 DB2 DB2 His Replication Agent for DB2 Replication Extract DB2 DB2 LTM for MVS Replication Extract TCP IP Replication Server Replication Server a DB2 DB2 DB2 K AAA DBR AI AES EM iot BREIL SEBO iB DB2 DB2 DB2
151. 203 Replication Server execute FAF MRB distribute origin qid 0x00010000010003 tran id 0x00018238 applied texttest rs writetext append last picture 0x4990 execute Replication Server m execute distribute command_tags execute repfunc function replication_definition function sys sp stored procedure param list repfunc KF LTL 103 function PAZ ix PM execute Replication Server execute repfunc Replication Server Replication Server oF ik ef 22 Replication Server execute repfunc Replication Server Replication Server WRAK repfunc
152. 52 Replication Server yielding 4 MRB rs update rs insert rs delete yielding B 4 BUE KB 4 applied fi SHielE BIB E PIIRTEET He RE rs update rs_insert gus rs delete table function name applied Replication Server A Replication Server 10 execute RepAgent rs insert rs delete LTL RepAgent function name Replicatio
153. 8 88 145 send warm standby xacts RepAgent 52 88 145 146 sendallxacts 145 sp reptostandby 52 sp setrepproc 36 71 sp setreptable 33 39 44 sqlddl append distribute 159 standby only 150 subcmp 85 switch active 53 Sybase Central xvii 25 Sybase 102 123 19 145 129 6 5 127 5 25 150 87 88 84 Replication Agent 91 14 8 13 3 85 Ha 85 3 128 85 24 T table function name 153 text image 154 156 tpinit text status 155 tpnull text status 155 tran id 149 29 JDBC 92 Replication Agent 92 U Unicode 113 Unicode 7742 106 UTF 16 FFR 106 UTF 8 742 106 V validate publication 58 W WAN 1
154. 98 Lesser 98 RR 99 99 rs lasicommil Be 1 uo ee ckx ern ERE Ren Rene En Ro xe Eus du Reub Run Re Ra RR 100 rs get lastcommit ccccccceeesssssceceeeeeeeeeeeeeeeeeeeeeersntaees 102 Sybase Central 102 7 ne 103 A E E A EEA 103 E E a 104 et 105 OO OO 105 Unicode UTF 8 UTF 16 ee 106 RSM Server 107 RSM Client oa 107 m 108 12 M 109 1 109 Unicode 113 115 ee 117 De AE RO EAS EEE CRORE SAO ENE E SE TO TOE 118 HK A eT AA A AAEE E E NAT A EA EE E 119 E a T s AENA AE POREN IENA NA NIE DM 119 Replication Server 120 Replication Server 4 120 Replication Server 7 121 Replication Server eee 121 ENE op MC ceo oe 121 iuuenes 122 Dy MePPPPIT OE 123 ROT 125 LNG ov TNR NR 126 0r toc m G eed 126 i 131
155. BER REEE S1 S2 S3 d T1 10 40 40 T2 40 80 0 T3 20 0 20 KA 3 SERES DB1 DB2 S1 S2 S3 Al 20 2 20 5 Jh 10 8 fh 132 Replication Server HRA REMH RowWidthChanged 123 a Ta FALE As InboundMsgSizeupdate InboundMsgOverhead ColOverhead RowWidth RowWidthChanged OutboundMsgSizeupdate OutboundMsgOverhead RowWidth RowWidthChanged NumSites 8 InboundMsgSizeT1 380 450 200 100 1130 bytes InboundMsgSizeT2 380 450 400 200 1430 bytes InboundMsgSizeT3 380 6600 1500 1000 9480 bytes OutboundMsgSizeT1 200 200 100 24 500 bytes OutboundMsgSizeT2 200 400 200 16 800 bytes OutboundMsgSizeT3 200 1500 1000 16 2700 bytes MsgSizebegin 250 MsgSizecommit 200 132 A 1
156. Be op Wo AE FY TH ERE UE E BBC AR AE TER XE AIP o Eb A ZH Replication Server FETAH Replication Server Replication Server Replication Server A Replication Server Replication Server Replication Server 13 IN RMI BEARS ah Xd Replication Agent Replication A
157. Creates stored procedure create procedure upd publishers pubs2 req pub id char 4 pub name varchar 40 city varchar 20 state cha 2 as insert into publishers pend values pub id pub name city state go end of script upd publishers pubs2 publishers publishers pend Execute this script at Sydney data server Creates stored procedure upd publishers pubs2 create procedure upd publishers pubs2 pub id char 4 pub name varchar 40 city varchar 20 state char 2 as update publishers set pub name pub name City Cil ty state state where pub id pub id delete from publishers pend where pub id Gpub id go end of script 68 Replication Server 65 upd publishers pubs2 req 37 upd_ publishers pubs2 38 upd publisher pubs2 upd publishers pubs2 sub n Lit H PV FE e 26 A T E d T SURE ka WAT X
158. DS Dyaebett T PALER ERAMATE HDS Replication Server Replication Server Sybase 96 Sybase DirectConnect Sybase LAN DirectConnect Bae u VA taj CAE Sybase Sybase DirectConnect Replication Server Open Client Server Sybase DirectConnect Open Server Sybase DirectConnect AS 400 Informix Microsoft SQL Server OS 390 DB2 Oracle ODBC AX DirectConnect EH DirectConnect DirectConnect Server FA o Replication Server OIX FREE EVF HIRIA R S Open Server px Zh Ate E tPA PR Open Server
159. E HI YA PR ZA n UBI PA ZR 38d fei E o fe PBI publishers titles pubs2 NY DS SF DS 69 RAYE HE PR 70 3 14 publishers ER titles A 3 14 HAKR PEAT nubs database publishers OS Binner Washington DC 1389 po gp Only rows related to CA are replicated Replicate Site 52 database publishers CA state publishers titles publishers state titles ISDH state itn GRE publisher state NY CA publisher
160. HRA BuU NumColumns 30 For a delete operation without minimal columns NumColumns 30 NumPrimaryKeyColumns 30 RowWidth ASCI char 10 10 binary 10 22 RowWidth 2 RowWidthChanged 10 RowWidth 200 FFT TPF E W RowWidthChanged 100 FF NumSites ParameterWidth ASCH Begin Commit Pair 450 MFT AARE CBE E 5
161. Ih Adaptive Server 8K 64 2K Adaptive Server 2048 SF BH FB o LRU RepAgent RepAgent RepAgent 256 2K RepAgent RepAgent RAKHI AZII Adaptive Server 2048 text image text image text image text image text image 170
162. L 200 Replication Server 11 5 WR Replication Agent Replication Server 11 0 LTL 103 Replication Server 11 0 144 Replication Server MRB Replication Agent Replication Server 11 0 Replication Server 10 1 LTL 101 102 Replication Server 10 1 till Replication Agent Replication Server 10 0 JRE M E LTL 100 Replication Server RepAgent connect source sendallxacts send maint xacts to replicate RepAgent Replication Server warmstdb send warm standby xacts RepAgent Replication Server in recovery for recovery RepAgent
163. M Server RSM Server RSM Server RSM Server JSO_ 1 SJIS SJIS RSM Server ISO_1 108 Replication Server FATT 7 BIEILEBR II ESI Replication Server RSM Server Replication Server RSM Server Sybase Unicode 115 Replication Server RS_sortorder
164. RepAgent Jil 145 103 118 KAI 58 62 i 58 58 H 4E E 58 hastext 109 oo 155 38 aT 39 40 43 gr 14 ABRE n care AN 14 xi HARRE 14 99 90 Mek Og 16 14 157 DB2 98 RCL 7 97 rs oo ET 85 18 86 86 23 164 Replication Server in recovery 145 isql 7 J Java Runtime Environment JRE 93 Java 93 JDBC 92 32 33 35 34 17 1 11 Wee 51 Wa 125 9 54 1 26 32 K 124 9 13 18 9 63 L LTI LIL connect source MA 143 144 distribute 143 148 get maintenanc
165. SSF gt Creates replication definition st sales create replication definition sf sales rep with primary at DSSF DBSF with all tables named salesdetail stor id char 4 ord num varchar 20 title 3d varchare qty smallint discount float primary key stor id ord num searchable columns stor id ord num title xd go end of script FATT RSHQ Replication Server Execute this script at Headquarters RSHQ Creates subscriptions to chi sales ny sales cc and sf sales create subscription chi sales sub for chi sales rep with replicate at DSHQ DBHQ where stor id 7067 go create subscription ny sales sub 47 BARE RRP for ny sales rep with replicate at DSHQ DBHQ where stor 1d 5022 go create subscription sf sales sub for sf sales rep with replicate at DSHQ DBHQ where stor id 8042 go end of script MIRER WAE RepAgent
166. Volume ReplicationSelectivity OutboundTransactionVolume 50 80 OutboundQueueVolume 20K Sec 0 5 10K Sec 0 8 1K Sec 19K Sec 136 configure connection configure route Replication Server Replication Server OutboundQueueSize OutboundQueueVolume FailureDuration SaveInterval EE OutboundQueueVolume CHI ACTS s FailureDuration 7 KH 8 A YW A YS BY H T a Be p CS AY e TR E
167. Y TAY Savelnterval 130 Replication Server HRA REMH OutboundQueueVolume 18K Savemnterval 1 1 OutboundQueueSize 18K sec 60min 60min 0 018MB sec 120min 60sec min 130MB 136 16K JA Em emu K 9 Replication Server 50 9596 Sum InboundQueueSize Sum OutboundQueueSize Sum InboundQueueSize Sum OutboundQueueSize
168. ansactionRate OutboundTransactionRate OutboundTransactionRate InboundTransactionRate InboundDatabaseVolumeupper sum InboundTableVolumeupper InboundTransVolume 135 InboundDatabaseVolume 126 InboundDatabaseVolume sum InboundTableVolume InboundTransactionVolume InboundQueueSizetypical InboundDatabaseVolume TransactionDurationtypical InboundQueueSizelongest InboundDatabaseVolume TransactionDurationlongest 128 Replication Server
169. ar 40 city varchar 20 state char 2 as if not exists select from publishers where pub id pub_ id raiserror 20005 FATAL ERROR Unknown publishers id else update publishers set pub name pub name GLlty city state state where pub id pub id end end of script Execute this script at NY data servers Creates stored procedure create procedure upd titles title id tid title varchar 80 type char 12 pub id char 4 null price money null advance money null total sales int null notes varchar 200 null pubdate datetime contract bit as if not exists select from titles where title id title id raiserror 20005 FATAL ERROR Unknown title id else update titles set title title type type pub id pub_ id price price advance advance total sales total sales notes notes pubdate pubdate contract contract where title id title id end end of script Execute this script at NY data server Creates stored procedure Replication Server create procedure upd pub title pub id char 4 pub name varchar 40 null city varchar 20 null state char 2 null title id tid null title varchar 80 null type char 12 null price money null advance money null total sales int null notes varchar 200 null pubdate datetime null contract bit Gold state char 2 as begin if not exists select from publishers where pub id pub_ i
170. ase Replication Agent JDBC Replication Agent Replication Server Replication Agent Replication Server RSSD Replication Server 5 Replication Agent Java Sybase Replication Agent Java Sybase Replication Agent Replication Agent Java Runtime Environment JRE Replication Agent 94 Replication Server Adaptive Server Sybase SQL Server E AS os ds BS Be 95 Sybase 96 Open Server 97 97 PUTAT BAS 98 99 rs lastcommit 100 rs get lastcommit 102 Sybase Central 102 Replication Server Replication Server Adaptive Server Enterprise Sybase SQL Server
171. ass assign action Replication Server 6 1 99 rs lastcommit 6 1 KHOE E BEEN Replication Server F ignore warn wok ABATE EAR BEI arp Sr retry_log configure connection log retry_stop configure connection stop_replication suspend connection
172. base Replication Server RSM Server Sybase Unicode UTF 8 FIR Replication Server Replication Server Replication Server Sybase Replication Server RSM Server Replication Server A CPU AR fete AI E 119 121 138 139 CPU 142 142 Replication Server Replication Agent RepAgent LTM Replication Agent DS Adaptive Server Replication Server
173. bs2 pub with primary at TOKYO DS pubs2 with replication definition pubs rep go RAYE HEL PRG create article pubs copy art for pubs2 pub with primary at TOKYO DS pubs2 with replication definition pubs rep where pub id 1000 go end of script A zc pubs2_pub Execute this script at Tokyo replication server Validates the publication pubs2 pub validate publication pubs2 pub with primary at TOKYO DS pubs2 go end of script pubs2_pub pubs2_pub_sub Ih Replication Server upd_authors_art pubs_art pubs copy art Execute this script at Sydney replication server Creates publication subscription pubs2 pub sub create subscription pubs2 pub sub for publication pubs2 pub with primary at TOKYO DS pubs2 with replicate at SF pubs2 without materialization go end of script 62 Replication Server IB 2k EBL Replication Server
174. cation Server RSSD ERSSD RSSD Adaptive Server Enterprise FXR ERSSD MEMES WAIL Replication Server RCL Sybase Central Replication Server Manager Replication Server RCL SQL fit isql Sybase SQL Replication Server Replication Server RCL Replication Server Manager Replication Server t HLA Replication Server Replication Server IE ZR Replication Server Replication Server Replication Server E 222 ia AY DAYS AEA X o 4j bx AY EA Xe e a OE T V BBE TE RCC EE Dg UNIX UO DTX HS WA KN HEA Replication Server Replication Server MA f X rp 2g LARA Hr etr ERE
175. d raiserror 20005 FATAL ERROR Unknown publishers id else exec upd publishers pub id pub name city state IL ticle id l mull begin lf not exists select from titles where title i1id etitle id exec ins titles title id title type Gpub id price Gadvance total sales notes pubdate contract else exec upd titles title id title type pub id price advance total sales notes pubdate contract end end end of script XERE pub id tite F R 3 1 He 3 1 Bill Fr CA AEB RG MME NS CA NY publisher publisher D PME EMEN Alius oic END rS upd publishers upd titles upd_publishers upd_titles upd_pub title Execute this script at SF data servers Creates stored procedure create procedure upd publishers d RAYE HEL PRG pub id char 4 pub name varchar 40 city varchar 20 state char 2 as if not exists select from publishers where pub id pub_ id raiserror 20005 FATAL ERROR Unknown publishers id else update publishers set pub name pub name CLiy ciey state state where pub id
176. e Replication Adaptive Server Everywhere Adaptive Server IQ Adaptive Warehouse Anywhere Studio Application Manager AppModeler APT Workbench APT Build APT Edit APT Execute APT FORMS APT Translator APT Library AvantGo AvantGo Application Alerts AvantGo Mobile Delivery AvantGo Mobile Document Viewer AvantGo Mobile Inspection AvantGo Mobile Marketing Channel AvantGo Mobile Pharma AvantGo Mobile Sales AvantGo Pylon AvantGo Pylon Application Server AvantGo Pylon Conduit AvantGo Pylon PIM Server AvantGo Pylon Pro Backup Server BizTracker ClearConnect Client Library Client Services Convoy DM Copernicus Data Pipeline Data Workbench DataArchitect Database Analyzer DataExpress DataServer DataWindow DB Library dbQueue Developers Workbench Direct Connect 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 Mail Anyw
177. e sub2 for upd pub title with replicate at SF DS pubs2 where old state CA without materialization go end of script i RAYE HEL RG 80 Replication Server 81 82 VRS te Hite 85 Replication Server Adaptive Server Replication Agent LAN WAN Replication Server Replication Server Replication Server Replication Agent
178. e user 143 get truncation 143 147 143 144 LIL EE LTM 8 LTM 124 11 12 M mode 149 mode 150 origin qid 149 origin time 149 standby only 150 tran id 149 distribute 149 N notrep text status 155 138 141 RepAgent 139 Replication Server 139 119 O OLTP 19 26 32 84 23 Ma 21 22 Open Server Server Library C 97 origin qid 149 origin time 149 165 Al P purge distribute 159 Unicode 113 114 115 109 110 38 110 Q fix A ZK Replication Server ERSSD 53 28 63 69 63 65 28 44 47 R RCL xiv REP SSL 17 RepAgent AP 160 88 Wi Replication Agent 87 8 13 repfunc 157 Replication Agent 87 88 91
179. eDuration 4 14 400 5 136 Replication Server HRA REMH Savelnterval 2 7200 FailureDuration Savelnterval 21 600 OutboundQueueSizes Sitel 7K sec 21 600sec 151MB Site2 15K sec 21 600sec 324MB Site3 9K sec 21 600sec 194MB CA Sum InboundQueueSizes Sum OutboundQueueSizes InboundQueueSizes 135 OutboundQueueSizes 2MB RSSD TEAM P 2MB 28MB 8MB 151MB 324MB 194MB 707MB Sybase
180. eplicate a e data flow San Francisco 40 Replication Server 3 4 salesdetail A 3 4 WELL T ET AEREME sate sade By sae ie ok ny sales sub sf sales sub chi sales sub sf sales sub san Francisca chi sales sub ny sales sub salesdetail Execute this script at Chicago RSCHI Creates replication definition chi sales create replication definition chi sales rep with primary at DSCHI DBCHI with all tables named salesdetail stor xd char 4 ord num varchar 20 title id varchar6 qty smallint discount float 41 f bx E EIU primary key stor id ord num searchable columns stor rid ord num title rd go end of script Execute this script at New York RSNY Creates replication definition ny sales create replication definition ny sales rep with primary at DSNY DBNY with all tables named salesdetail stor id char 4 ord num varchar 20 title aid varchare qty smallint discount float primary key stor id ord num searchable columns stor id ord num title xd go end of script Execute this script at San Francisco RSSF Creates replication definition sf sales create replication definition sf sales rep with pr
181. eplication Server Ja RepAgent get maintenance user DARA FEA OW ae Replication Server RepAgent Replication Server RepAgent send_warm_standby_xacts Replication Server RepAgent Adaptive Server RepAgent SQL Server LTM get maintenance user get maintenance user for data_server database Replication Server char 30 146 Replication Server get truncation ID MRB FP BAEK NY_DS
182. er ree 1 pp 1 Ne 2 Ue Fee doa zb SPIRI atta am atest eae eine 2 3 Replication Server 0 3 3 4 5 6 Replication Server i 7 Wr e AA AE E E A EEE E 8 aU AGSTE 0 en Fa M EeNNN N bett bid br ME 8 SPAA AEE 8 9 9 9 A Ed J NNI ER TR RR 10 13 C SD nn 13 aile ls icd NR T E 13 nn 14 RKA RAFE PRAF RZ 14 Replication Server i 15 15 22 16 17 A E E E 17 ro MC AE EAEE E PN E ou ch EAEE E E 18 iii 2 es 19 19 19 OLTP 22 OLTP iiriierrrreerrrrierrrrrnenn 23 23 Leu 24 A EEEE N 25 25 EEEak EPT AAA 26 nn 26 esse 27 Less 28
183. function Ouod definition Replication Server WRIA repfunc KES execute applied Replication Server execute TAN Replication Server Replication Server execute Replication Server 157 distribute rs marker 158 function Replication Server execute function create function replication definition create function LTL 200 RepAgent sys sp
184. g A AE RAILS AS MEER OLTP OLTP i AREF HEE Replication Server OLTP 20 Replication Server A
185. gent Replication Server Adaptive Server Replication Agent Adaptive Server RepAgent Sybase SQL Server Replication Agent LTM Log Transfer Manager Replication Agent Replication Server Replication Server Replication Agent Replication Agent RepAgent Adaptive Server Replication Agent Replication Agent Replication Agent Replication Agent Replication Server e Pm bY FATE 2s J Om DY HR P EH T Adaptive Server Open Client Client Serve
186. gent Replication Agent Replication Agent 13 FF TIEN R ES XEF 5 Et Replication Agent Adaptive Server Sybase SQL Server Replication Agent Sybase Sybase DB2 Informix Microsoft SQL Server Oracle Replication Agent HIR Replication Server RCL warn retry log stop_replication 14 Replication Server
187. here Studio MainframeConnect Maintenance Express Manage Anywhere Studio M Business Channel M Business Network M Business Server MDI Access Server MDI Database Gateway media splash MetaWorks My AvantGo My AvantGo Media Channel My AvantGo Mobile Marketing 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 Open Client Server Interfaces Open Gateway Open Server Open ServerConnect Open Solutions Optima PB Gen PC APT Execute PC Net Library PocketBuilder Pocket PowerBuilder Power powerstop 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 Resource Manager 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 SQL Edit TPU SQL Everywhere SQL Modeler SQL Remote SQL Server SQL Server Manager SQL SMART SQL Toolset SQL Se
188. ication Server SQL Server 45 Replication Agent Replication Server Adaptive Server Replication Agent RepAgent Sybase SQL Server Replication Agent LTM Sybase Adaptive Server Anywhere DB2 Informix Microsoft SQL Server Oracle Replication Agent RepAgent Adaptive Server Replication Agent Replication Agent Replication Server ATA Replication Server Manager Sybase Central Replication Server Manager RSM
189. ied table rs datarow for writetext yielding datarow column _list 154 Replication Server MRB yielding datarow column list text image text image always rep rep if changed never rep column_list text image BRA text status text status X B 5 text image ZX 7E text status tpnull text image tpinit hastext text BK image notrep text image text image replicate_if_changed zerolen text BK image text image rs insert rs update text image text status rs_delete applied rs writetex
190. imary at DSSF DBSF with all tables named salesdetail stor id char 4 ord num varchar 20 title id varchare qty smallint discount float primary key stor id ord num searchable columns stor id ord num title id go end of script 42 Replication Server FAI BESTS RAIL OY EAI AI T SEI ll GE SC TUT o DAB ALAS HIT UE Execute this script at Chicago RSCHI Creates subscriptions to ny sales and sf sales create subscription ny sales sub for ny sales rep with replicate at DSCHI DBCHI where stor id 5023 go create subscription sf sales sub for sf sales rep with replicate at DSCHI DBCHI where stor id 8042 go end of script Execute this script at New York RSNY Create subscriptions to chi sales and sf sales create subscription chi sales sub for chi sales sub with replicate at DSNY DBNY where stor id 7067 go create subscription sf sales sub for sf sales rep with replicate at DSNY DBNY where stor id 8042 go end of script Execute this script at San Francisco RSSF Creates subscriptions to chi sales and ny sales create subscription chi sales sub for chi sales rep with replicate at DSSF DBSF where stor id 7067 go create subscription ny sales sub for ny sales rep with replicate at DSSF DBSF Where Stor rd 5023 go end of script 43 Sf 44
191. ion Server Replication Server Replication Server Replication Server SQL select where Replication Server 11 5 Replication Server Replication Server Adaptive Server
192. ion Server LTM Replication Agent SMB RAM RepAgent Adaptive Server Replication Server Replication Server 120 Replication Server RepAgent Adaptive Server LTM Sybase SQL Server Replication Agent Sybase LTM DSD Replication Server HRA BuU AK Adaptive Server 3E ZETEZZSKIJTESH fH RS PA MATT E Sybase Replication Agent Replication Agent Replication Server Replication Server DSI Replication Server Replication Server Replication Server
193. lication Server RSSD LTL Replication Agent LTL Replication Server Replication Server Replication Server Sybase Replication Agent Replication Server Sybase Replication Agent Replication Agent 92 Sybase Replication Agent Java IDBC Replication Agent Sybase JDBC jConnect for JDBC Open Client Open Server Replication Server RSSD Replication Server Manager RSM Syb
194. n Server publishers Execute this script at Tokyo and Sydney data servers Creates stored procedure upd publishers pubs2 create procedure upd publishers pubs2 pub id char 4 pub name varchar 40 city varchar 20 state char 2 as update publishers set pub name pub name Gity wocTty state state where pub id pub id go end of script Replication Server publishers Execute this script at Tokyo replication server Creates replication definition upd publishers pubs2 create function replication definition upd publishers pubs2 with primary at TOKYO DS pubs2 pub id char 4 pub name varchar 40 city varchar 20 state char 2 go end of script ZEB E E it RY create subscription Ip ctos ZX o define subscription activate subscription validate subscription
195. n Server Replication Server create function applied function name RA LH param list yielding param list param list param name iterall Qgparam name iterall param_name literal Replication Server 153 distribute Replication Server 10 1 yielding a
196. nc ltm valid 12 EAGER XE THA MAA XX 72v 1H7h Replication Server Adaptive Server Adaptive Server rs zeroltm data server db name 13 Adaptive Server 14 Replication Server 15 RepAgent EX LTM f D fr din ETI Replication Server J Replication Server resume log transfer from data server db name 16 RepAgent 2X LTM 17 Replication Server SYBASE SYBASE REP scripts rsspmsgl sql rsspmsg2 sgl isql Uuser name Ppassword Srssd name Jeucjis lt SSYBASE SSYBASE REP scripts rsspmsg2 sql isql Uuser name Ppassword Srssd name Jiso 1 lt SSYBASE SSYBASE REP scripts rsspmsgl sqgl EAN UTF 8 rsspmsgl sql rsspmsg2 sql 117 118 Replication Server 1 RSM Server AU ALAR YAIR PETE Al H re B is HH SEES H es FAS n RE ER TB He Sy
197. o RepAgent DBHQ RepA gent send_maint_xacts_to_replicate LTM A LTM RSHQ RSSD RepAgent 49 E AEF DEMRE AEN salesdetail RSHQ Replication Server RSHQ 50 Replication Server Adaptive Server SQL Server Replication Server
198. r Embedded SQL PowerBuilder a C SD IER HIT m IT A LRE E EHET o 25 J Om DY REP DAA A Replication Server Replication Server Replication Agent Adaptive Server Sybase 7c iij Replication Server Servers Replication Server Replication Agent LDAP Replication Servers cain OX AXR LDAP Replication Server
199. ram list after param list table rs insert yielding after param list table rs delete yielding before param list table function name param list yielding after param list before param list table rs datarow for writetext yielding datarow column list table rs writetext append first last changed with log textlenz 700 column _list command tags 149 table e Replication Server table Replication Server 11 5 LTL 200 mode 0x08 Replication Server create replication definition with all tables named table identifier table with all tables named table identifier with primary table named table_identifier FAJ EX table table identifier lil S with all tables named table identifier with primary table named table identifier table RepAgent 1
200. rver 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 Sybase SQL Lifecycle Sybase SQL Workgroup Sybase User Workbench SybaseWare Syber Financial SyberAssist SyBooks System 10 System 11 System XI CRER 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 VOL WarehouseArchitect Warehouse Control Center Warehouse Studio Warehouse WORKS Watcom Watcom SQL Watcom SQL Server Web Deployment Kit Web PB Web SQL WebSights WebViewer WorkGroup SQL Server XA Library XA Server XP Server Sybase Inc Unicode Unicode Unicode Inc Use duplication or disclosure by the government is subject to the restrictions set forth in subparagraph c 1 11 of DFARS 52 227 7013 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 er ix 1 ee ee ee eee Tere TT Cee rT TT rer rr er re
201. s J Commurications _ Network 1 i Replicate alte Local Read Remote Write Client Aplicatiore a WAN EHR m ER TE TG Ke hs H 27 ER EXTR HU ZA 28 WAN Replication Server Adaptive Server RepAgent Replication Server
202. site Replication definitions P articles and publication Communications Network SS 68 66e Se ea ese Se a4 eS ee Ee equa ee Eee e eee Ta One publication subscription here sydney auishers pup qp oa a a a gubs COMM Pepi aie Baers H enl icate EEE aa Heup Euk CdSe st site Ec LLLI TEEPE O update_authors_pubs2 pubs2 authors Execute this script at the Tokyo and Sydney data servers Creates the stored procedure update authors pubs2 create procedure upd authors pubs2 Gau id id au lname varchar 40 au_ fname varchar 20 phone char 12 address varchar 12 city varchar 20 state char 2 RAYE HEL PRG 60 country varchar 12 postalcode char 10 as update authors set au_lname varchar 40 au_fname varchar 20 phone char 12 address varchar 12 city varchar 20 state char 2 country varchar 12 postalcode char 10 where au_id au_id go end of script Execute this script at the Tokyo replication server Creates the function replication definition update authors pubs2 create f
203. t text image rs_writetext 4K text image rs writetext rs_writetext distribute command_tags applied table rs writetext append first last changed with log textlenz 100 column list append text image first text image last text image changed text image changed tf text image Replication Server with log text image textlen text image text image EE ux 155 distribute 156 column list text image a b BUR 44 ADAIR C GE text BG SURE 0 GFN image 3 rs_writetext text image
204. te OutboundMsgOverhead RowWidthChanged 2 PrimaryKeyWidth NumSites 8 133 HIRAI InboundMsgSizeinsert InboundMsgOverhead ColOverhead RowWidth OutboundMsgSizeinsert OutboundMsgOverhead RowWidth NumSites 8 123 Agi BRAZZER EA we 124 InboundMsgSizeinsert InboundMsgOverhead ColOverhead RowWidth OutboundMsgSizeinsert OutboundMsgOverhead RowWidth NumSites 8 InboundMsgSizedelete InboundMsgOverhead ColOverhead PrimaryKeyWidth OutboundMsgSizedelete OutboundMsgOverhead PrimaryKeyWidth NumSites 8 InboundMsgSizefunction InboundMsgOverhead ParameterWidth RowWidth 2 OutboundMsgSizefunction OutboundMsgOverhead ParameterWidth NumSites 8
205. unction replication definition upd authors pubs2 with primary at TOKYO DS pubs2 au_id id au_lname varchar 40 au_fname varchar 20 phone char 12 address varchar 12 city varchar 20 state char 2 country varchar 12 postalcode char 10 go end of script Replication Server Replication Server publishers Execute this script at Tokyo replication server Creates replication definitions pubs rep create replication definition pubs rep with primary at TOKYO DS pubs2 with all tables named publishers pub id char 4 pub name varchar 40 city varchar 20 state varchar 2 primary key pub id go end of script Replication Server pubs2_pub Execute this script at Tokyo replication server Creates publication pubs pub create publication pubs2 pub with primary at TOKYO DS pubs2 go end of script Replication Server pubs2_pub pubs_rep Execute this script at Tokyo replication server Creates articles upd authors art pubs art and pubs copy art create article upd authors art for pubs2_pub with primary at TOKYO DS pubs2 with replication definition upd authors rep go create article pubs art for pu
206. uthors rs update yielding before name green phone 415 986 7020 after name green phone 510 986 7020 distribute origin time Dec 10 1992 8 48 14 750AM origin qid 0x00000000000000000000000000000005 Gtran id 20x000000222222 commit transaction 160 Replication Server MKR B H FIFE iB 22 3 distribute Gorigin time Dec 10 1992 8 48 14 750AM origin qid 0x00000000000000000000000000000006 tran_id 0x000000111111 commit transaction get truncation distribute origin_qid 91 RepAgent Zig KH 162 Replication Server Fa A admin logical status 53 applied distribute 151 assign action 99 KEERA 17 Replication Server 15 17 B begin transaction distribute 150 84 130 A T1 23 23 33 126 134 FA text image 156 xv JE 5 6 C C SI AEF ving ARS 8 O commit transaction distribute 151 connect source LTL 143 143 RepAgent 88 CPU 119 create article 58 create error class 99 create function 153 create function string class 99

Download Pdf Manuals

Related Search

SYBASE Replication Server 12.6 design Service Manual

Related Contents

Agilent Size Exclusion Chromatography for the Analysis of Dental Polymers Manual  SAMPO AD-1681WN dehumidifier Manual    PANJIT SD1020YT Thru SD10100YT handbook              

Copyright © All rights reserved.