+ -
当前位置:首页 → 问答吧 → 关于sybase 复制服务器的排序顺序问题!

关于sybase 复制服务器的排序顺序问题!

时间:2010-08-29

来源:互联网

请教各位,小弟在进行复制服务器的配置时,遇到一个问题。。。
将主、从数据库都通过 rs_init 添加到了复制系统内后,
在执行,以下检查
1> admin healt
2> go
Mode             Quiesce  Status
---------------- -------- --------
NORMAL           TRUE     SUSPECT
1>
后,提示,状态可疑。。。
后执行。。
1> admin who
2> go
Spid Name       State                Info
---- ---------- -------------------- ----------------------------------------
   20 DSI EXEC   Awaiting Command     101(1) test1.rep1_RSSD
   12 DSI        Awaiting Command     101 test1.rep1_RSSD
    8 SQM        Awaiting Message     101:0 test1.rep1_RSSD
   22 DSI EXEC   Awaiting Command     102(1) test2.dbtest2
   13 DSI        Awaiting Command     102 test2.dbtest2
   16 DIST       Active               102 test2.dbtest2
   19 SQT        Awaiting Wakeup      102:1  DIST test2.dbtest2
   10 SQM        Awaiting Message     102:1 test2.dbtest2
    9 SQM        Awaiting Message     102:0 test2.dbtest2
      REP AGENT  Down                 test2.dbtest2
   21 DSI EXEC   Awaiting Command     103(1) test3.dbtest3
   14 DSI        Awaiting Command     103 test3.dbtest3
   11 SQM        Awaiting Message     103:0 test3.dbtest3
   15 dSUB       Active
    6 dCM        Awaiting Message
    7 dAIO       Awaiting Message
   17 dREC       Active               dREC
   18 dSTATS     Active
   32 USER       Active               sa
    5 dALARM     Awaiting Wakeup
1>

其中。。发现,“REP AGENT  Down                 test2.dbtest2”这项没有启动,
为了找到原因,
我查看了,系统日志。。。如下
仔细看了一下,其中的一段错误提示:

W. 2010/08/29 10:02:51. WARNING #13061 DSI(102 test2.dbtest2) - eue(4684)
        Server test2 is using 'nocase_cp850' sort order, which is different from this Replication Server's sort order.
W. 2010/08/29 10:02:51. WARNING #13061 DSI(103 test3.dbtest3) - eue(4684)
        Server test3 is using 'nocase_cp850' sort order, which is different from this Replication Server's sort order.


指出,主库test2和目的库test3的排序顺序与复制服务的不一致,请问,如何进行修改呢?

当前,复制服务器、主库、目的库的排序顺序均设置为:“Dictionary order,case insensitive."

不知道还有什么地方要进行设置才可以一致!
造成状态可疑,是否就是因为这个排序不一致引起的呢?
请各位多多指教!

Sybase Inc.  All rights reserved.
Unpublished rights reserved under U.S. copyright laws.

This software contains confidential and trade secret information of Sybase,
Inc.   Use, duplication, or disclosure of the software and documentation by
the  U.S.  Government  is  subject  to  restrictions set forth in a license
agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
agreement  specifying  the  Government's rights to use the software and any
applicable FAR provisions, for example, FAR 52.227-19.
Sybase, Inc. 5000 Hacienda Drive, Dublin, CA 94568, USA.'
I. 2010/08/29 10:02:51. Logging messages in file 'C:\Sybase\REP-12_5\install\rep1.log '.
I. 2010/08/29 10:02:51. Using interfaces file 'C:\Sybase\ini\sql.ini '.
I. 2010/08/29 10:02:51. Server name is 'rep1'.
I. 2010/08/29 10:02:51. SYSAM: Replication Server received a valid 'REP_SERVER' license.
I. 2010/08/29 10:02:51. Reading 'C:\Sybase\REP-12_5\install\rep1.cfg ' for configuration information.
I. 2010/08/29 10:02:51. Using the 'cp850' character set.
I. 2010/08/29 10:02:51. Using the 'us_english' language.
I. 2010/08/29 10:02:51. Using the 'binary' sort order.
I. 2010/08/29 10:02:51. Using the 'binary' unicode sort order.
I. 2010/08/29 10:02:51. Using server 'rep1' for an ID Server.
I. 2010/08/29 10:02:51. Using config file password for the ID user.
I. 2010/08/29 10:02:51. Using user 'rep1_id_user' for the ID Server.
I. 2010/08/29 10:02:51. Using config file maintenance password for the RSSD maint user.
I. 2010/08/29 10:02:51. RSSD maintenace user is 'rep1_RSSD_maint'.
I. 2010/08/29 10:02:51. Using config file password for the RSSD primary user.
I. 2010/08/29 10:02:51. RSSD primary user is 'rep1_RSSD_prim'.
I. 2010/08/29 10:02:51. RSSD database is 'rep1_RSSD'.
I. 2010/08/29 10:02:51. RSSD server is 'test1'.
I. 2010/08/29 10:02:51. Reading 'test1.rep1_RSSD..rs_config' for system configuration parameters.
I. 2010/08/29 10:02:51. Value of the 'memory_limit' config parameter is: 20 megabytes.
I. 2010/08/29 10:02:51. Maximum outbound connections allowed: 64.
I. 2010/08/29 10:02:51. System outbound connection fadeout time: '30'.
I. 2010/08/29 10:02:51. System table cache size: 100 rows.
I. 2010/08/29 10:02:51. Maximum number of Open Server threads allowed: 50.
I. 2010/08/29 10:02:51. Maximum number of Open Server mutexes allowed: 128.
I. 2010/08/29 10:02:51. Maximum number of incoming client connections allowed: 30.
I. 2010/08/29 10:02:51. Maximum number of Open Server message queues allowed: 178.
I. 2010/08/29 10:02:51. Maximum number of Open Server messages allowed: 45568.
I. 2010/08/29 10:02:51. Maximum number of stable queues allowed: 32.
I. 2010/08/29 10:02:51. Password encryption option: 0.
I. 2010/08/29 10:02:51. Use SSL service is set to 'off'.
I. 2010/08/29 10:02:51. Default for connection ha_failover is set to 'off',
I. 2010/08/29 10:02:51. Default directory service provider is: 'InterfacesDriver'.
I. 2010/08/29 10:02:51. System configuration complete.
I. 2010/08/29 10:02:51. Server using Open Server version Sybase Server-Library/12.5/P-EBF10092-10091/PC Intel/BUILD125-012/OPT/Wed Feb 27 11:13:05 2002
I. 2010/08/29 10:02:51. Server using Open Client version Sybase Client-Library/12.5/P-EBF10091/PC Intel/BUILD125-012/OPT/Wed Feb 27 11:13:05 2002
W. 2010/08/29 10:02:51. WARNING #13061 GLOBAL RS(GLOBAL RS) - eue(4684)
        Server test1 is using 'nocase_cp850' sort order, which is different from this Replication Server's sort order.
I. 2010/08/29 10:02:51. Server site id is '16777317'.
I. 2010/08/29 10:02:51. Embedded database id is '101'.
I. 2010/08/29 10:02:51. The DSI thread for database 'test1.rep1_RSSD' is started.
I. 2010/08/29 10:02:51. The DSI thread for database 'test2.dbtest2' is started.
I. 2010/08/29 10:02:51. The DSI thread for database 'test3.dbtest3' is started.
I. 2010/08/29 10:02:51. Replication Server 'rep1' is started.
I. 2010/08/29 10:02:51. DIST for 'test2.dbtest2' is Starting
I. 2010/08/29 10:02:51. SQM starting: 102:0 test2.dbtest2
I. 2010/08/29 10:02:51. SQM starting: 101:0 test1.rep1_RSSD
I. 2010/08/29 10:02:51. SQM starting: 103:0 test3.dbtest3
I. 2010/08/29 10:02:51. SQM starting: 102:1 test2.dbtest2
W. 2010/08/29 10:02:51. WARNING #13061 DSI(102 test2.dbtest2) - eue(4684)
        Server test2 is using 'nocase_cp850' sort order, which is different from this Replication Server's sort order.
W. 2010/08/29 10:02:51. WARNING #13061 DSI(103 test3.dbtest3) - eue(4684)
        Server test3 is using 'nocase_cp850' sort order, which is different from this Replication Server's sort order.

作者: youwei   发布时间: 2010-08-29

修改复制点服务器的字符集,跟主服务器一致,可以解决问题,这是最简单有效的方式

作者: hobbylu   发布时间: 2010-08-30