Q¸´ÖÆÊÇDB2¸´ÖƼ¼ÊõÖнÏеÄÒ»ÖÖ¼¼Êõ£¬Í¨¹ý½«Websphere MQÒý½øµ½¸´ÖÆÌåϵ½á¹¹ÖУ¬¿ÉÒÔʹµÃ¸´ÖƸü¼Ó¿É¿¿¡¢Îȶ¨ºÍ¿ìËÙ¡£±¾ÎĽ«Í¨¹ýÒ»¸öÍêÕûµÄÀý×ÓÀ´ËµÃ÷ÈçºÎ´î½¨»ù±¾»·¾³£¬ÒÔ¼°ÈçºÎ½øÐвÙ×÷£¬´Ó¶øÊµÏÖÔ¶³ÌQ¸´ÖÆ¡£
¼ò½é
±¾ÎĽ«´ó¸Å½²ÊöSQL Replication£¬È»ºóÒý³öQ ReplicationµÄÒâÒå¡£±¾ÎĵµÍ¨¹ýλÓÚÁ½Ì¨²»Í¬Ö÷»úÉϵÄÊý¾Ý¿â¼äµÄµ¥Ïò¸´ÖÆÀ´Õ¹ÏÖÔ¶³ÌQ¸´ÖƵÄʹÓᣳýÁË˵Ã÷²Ù×÷²½ÖèÒÔÍ⣬±¾ÎĵµÍ¬Ê±Ò²¶ÔÏà¹ØµÄ¹Ø¼ü¸ÅÄһЩ³£¼ûµÄ´íÎóÒÔ¼°Ïà¹ØµÄÐÅÏ¢×ö³öÁËÏàÓ¦½âÊÍ¡£
ÔÚʵ¼Ê²Ù×÷֮ǰ£¬¶ÁÕßÓ¦¸Ã¾ßÓÐDB2Êý¾Ý¿âµÄÏà¹Ø¹ÜÀí²Ù×÷µÄ»ù±¾¸ÅÄîºÍ»ù´¡ÖªÊ¶£¬Í¬ÑùÒ²Ó¦¸Ã¶ÔWebsphere Information IntegratorºÍWebsphere MQÓÐÏà¹ØÁ˽⡣Èç¹û¶ÁÕßÔÀ´ÔÚÒ»¸ö»úÆ÷ÉÏ×ö¹ýDB2¸´ÖÆÏà¹ØµÄÁ·Ï°£¬ÀýÈçIBMÌṩµÄT3Á·Ï°£¬½«¶Ô±¾ÎĵÄѧϰºÜÓаïÖú¡£
±¾ÎĵµÖ÷Òª·ÖΪÈý¸ö´ó²¿·Ö£ºµÚÒ»¸ö²¿·ÖÊÇÅäÖúͱàĿԶ³ÌÊý¾Ý¿â£¬µÚ¶þ¸ö²¿·ÖÊÇÅäÖÃWebsphere MQµÄÏà¹Ø¶ÔÏ󣬵ÚÈý¸ö²¿·ÖÊÇͨ¹ýReplication CenterÀ´½¨Á¢Æð×îÖյĸ´ÖÆ»·¾³¡£¶ÔÓÚÿһ¸ö²¿·Ö£¬¶¼°üÀ¨²Ù×÷²½Ö裬Ïà¹ØÎÊÌâºÍ½â¾ö°ì·¨£¬ÒÔ¼°Ò»Ð©Ïà¹ØµÄÌáʾÐÅÏ¢¡£


|
»ØÒ³Ê× |
|
ǰÌáÌõ¼þ
1£® ƽ̨µÄÑ¡Ôñ
¿¼Âǵ½´ó²¿·Ö¶ÁÕß¿ÉÄܸüÈÝÒ×»ñµÃWindows²Ù×÷ϵͳ»·¾³£¬ËùÒÔ£¬±¾ÎĵµµÄʵÏÖ£¬Ô´Êý¾Ý¿âºÍÄ¿±êÊý¾Ý¿âÊÇ·Ö±ðÔÚÁ½¸öWindows²Ù×÷ϵͳÉÏ¡£µ«ÊÇ£¬Êµ¼ÊÉÏÈç¹û»»³ÉÆäËû²Ù×÷ϵͳƽ̨£¬ÈçUnix/Linux£¬ËùÓеIJÙ×÷²½Ö轫ÊÇ´óͬСÒì¡£
2£® Èí¼þµÄ°²×°
¶ÁÕßÐèÒª°²×°ºÃDB2£¬Websphere MQ¡£ÒÀ¾ÝÏà¹Ø°²×°ÎĵµÖ´Ðм´¿É¡£
3£® ±¾ÎĵÄÏà¹ØÔ¼¶¨
ΪÁ˱ãÓÚ¶ÁÕßѧϰºÍʵ¼ù±¾ÎÄ£¬ÏÂÃæ¸ø³öÁ˱ÊÕßÔÚʵ¼Ê²Ù×÷¹ý³ÌÖÐËù½¨Á¢ÆðÀ´µÄ»·¾³µÄ¾ßÌåÐÅÏ¢£¬¶ÁÕßµ±È»Ò²¿ÉÒÔ¶Ô×Ô¼ºµÄÏà¹Ø»úÆ÷ºÍ¶ÔÏóÖ¸¶¨ÆäËûµÄÃû³Æ¡£ÔÚ±¾ÎÄÖУ¬ËùʹÓõĶÔÏóÐÅÏ¢¼´ÈçÏÂËùÊö£¨Ö÷Òª°üÀ¨Ö÷»úµÄÉèÖã¬DB2µÄÉèÖã¬ÒÔ¼°Websphere MQµÄÉèÖã©¡£
4£® Ö÷»úºÍDB2µÄÏà¹ØÉèÖÃÐÅÏ¢
×¢Òâ: ÔÚʹÓø´Öƹ¦ÄÜ֮ǰ£¬Êý¾Ý¿âITARGETºÍSAMPLE¶¼Ó¦¸Ã½«ÈÕ־ģʽÉèÖÃΪarchive loggingģʽ£¨¹éµµÈÕ־ģʽ£©¡£
5£® Websphere MQµÄÏà¹ØÅäÖÃÐÅÏ¢
6£® Q¸´ÖƵÄÅäÖÃÐÅÏ¢
×¢Òâ: 1. ÉÏÃæµÄReplication q map name¿ÉÒÔÓÉÓû§×ÔÐж¨Ò壬һ°ã¿ÉÒÔ°´ÕÕ¸´ÖƵŦÄÜÌØµãÀ´½øÐÐÃüÃû¡£
2. ¶ÔÓÚ±¾ÎÄÖÐËùʹÓõ½µÄÏà¹ØµÄMQµÄÍêÕû¶¨Ò壬¿ÉÒÔÔÚEAST_QUEUE_DEFINE.TXTÎļþºÍWEST_QUEUE_DEFINE.TXTÎļþÖÐÕÒµ½¡£¶ÁÕßÒ²¿ÉÒÔʹÓÃÉÏÊö½Å±¾À´Éú³ÉËùÐèÒªµÄMQ¶ÔÏó¡£


|
»ØÒ³Ê× |
|
²Ù×÷²½Öè¡¢³ö´í·ÖÎö¼°½â¾ö
µÚÒ»²¿·Ö ÅäÖÃÔ¶³ÌÊý¾Ý¿âÁ¬½Ó
²Ù×÷²½Öè
±¾ÎÄÖУ¬SAMPLEÊý¾Ý¿âÊÇÔ´Êý¾Ý¿â£¬Ô´±í¼´ÔÚÕâ¸öÊý¾Ý¿âÖС£¶øÊý¾Ý¿âITARGETΪĿ±êÊý¾Ý¿â¡£¶ø¶ÔÓÚÒª´´½¨µÄMQ¶ÔÏóÀ´Ëµ£¬Ãû×ÖÖеÄEASTºÍWESTÒ²½«ÓÃÀ´Çø·ÖÁ½¸öÖ÷»ú£¬EASTÏà¹ØµÄMQ¶ÔÏóºÍITARGETÊý¾Ý¿âÔÚͬһ¸öÖ÷»úÉÏ£¬¶øWESTÏà¹ØµÄMQ¶ÔÏóºÍSAMPLEÊý¾Ý¿âÔÚͬһ¸öÖ÷»úÉÏ¡£ËùÒÔ£¬Êý¾Ý½«ÊÇ´ÓSAMPLE£¨WEST£©¸´ÖƵ½ITARGET £¨EAST£©£¬Æä¼äͨ¹ý¶¨ÒåºÃµÄÏà¹Ø¶ÓÁÐÀ´ÊµÏÖÊý¾ÝµÄÖм䴫µÝ×÷Óá£
ÔÚEAST¶Ë£¨¼´Apply Server¶Ë£¬Ò²¾ÍÊÇITARGETÄ¿±êÊý¾Ý¿â¶Ë£©£¬Í¨¹ýÏÂÃæµÄ²Ù×÷²½ÖèÀ´±àĿλÓÚÁíÍâÒ»¸öÖ÷»úÉϵÄSAMPLEÔ´Êý¾Ý¿â¡£
1£®´ò¿ªCLP£¬ÊäÈëÏÂÃæµÄÃüÁîÀ´ÊµÏÖ¶ÔÔ¶³ÌSAMPLEÊý¾Ý¿âµÄ±àÄ¿£º
db2 catalog tcpip node WEST remote 9.181.135.61 server 50000
db2 catalog database SAMPLE at node WEST
db2 terminate;
|
2£®ÔÚCLPÖÐÊäÈëÏÂÃæµÄÃüÁîÀ´²âÊÔ´ÓEASTµ½WESTµÄÁ¬½ÓÊÇ·ñÓÐЧ£º
db2 connect to SAMPLE user administrator using ***
db2 terminate;
|
ÔÚÉÏÊö²½ÖèÖУ¬¿ÉÄÜ»áÓöµ½Ò»Ð©´íÎ󣬱ÊÕß½«Æä×ܽáÔÚÏÂÃæµÄ²¿·Ö£¬ÄãÒ²¿ÉÒÔͨ¹ý±¾ÎĺóÃæµÄ²Î¿¼ÐÅÏ¢»ñµÃ¸ü¶à°ïÖú¡£ÕâÑù£¬Ò»¸öÔ¶³ÌÊý¾Ý¿âµÄ±àÄ¿²Ù×÷¾ÍÍê³ÉÁË£¬Óû§±ã¿ÉÒÔͨ¹ýCLPÃüÁîÐз½Ê½»òÕßDB2µÄ¿ØÖÆÖÐÐÄͼÐνçÃæ·½Ê½À´ÊµÏÖ¶ÔÔ¶³ÌÊý¾Ý¿âµÄ²Ù×÷¡£
¶ÔÓÚQ¸´ÖÆÖеĵ¥Ïò¸´ÖÆÀ´Ëµ£¬ÉÏÊö±àÄ¿²½Öè¼´¿É¡£Èç¹ûÏëʵÏÖQ¸´ÖÆÖеÄË«Ïò¸´ÖÆ»òÕßP2P¸´ÖÆ£¬ÄÇôÐèÒªÔÚÁíÍâÒ»¶ËÍê³ÉÀàËÆÉÏÊöµÄ²½Ö裬²Ù×÷·½Ê½ÈçÏ¡£
ÔÚWEST½Úµã£¨¼´SAMPLEÊý¾Ý¿âËùÔÚµÄÖ÷»ú£©ÉÏ£¬Ö´ÐÐÈçϵIJÙ×÷£º
1£®´ò¿ªCLP£¬ÊäÈëÏÂÃæµÄÃüÁîÀ´ÊµÏÖ¶ÔÔ¶³ÌITARGETÊý¾Ý¿âÖеıàÄ¿£º
db2 catalog tcpip node EAST remote 9.181.135.238 server 50000
db2 catalog database ITARGET at node EAST
db2 terminate;
|
2£®ÔÚCLPÖÐÊäÈëÏÂÃæµÄÃüÁîÀ´²âÊÔ´ÓEASTµ½WESTµÄÁ¬½ÓÊÇ·ñÓÐЧ£º
db2 connect to ITARGET user administrator using xxx
db2 terminate;
|
²½Öè×¢½â
ÔÚ±¾²¿·Ö¹ý³ÌÖУ¬ÎÒÃǻᾳ£Óõ½ÈçÏÂһЩÓÐÓõÄÃüÁдÔÚÕâÀ½ö¹©²Î¿¼: £¨Óû§¿ÉÒÔÐ޸ĴÖÌ岿·ÖÒÔ·ûºÏ×ÔÉíÐèÒª£©
1) db2 list node directory
2) db2 list node directory show detail
3) db2 catalog tcpip node WSII remote 9.181.139.155 server 50000
4) db2 catalog database source at node WSII
5) db2 terminate
6) db2 list database directory
7) db2 create database database_name
8) db2 drop database database_name
9) db2sampl -k £¨¸ÃÃüÁîÓÃÀ´´´½¨DB2ȱʡµÄSAMPLEÊý¾Ý¿â£¬²ÎÊýk±íʾ½¨Á¢´øÓÐÖ÷¼üµÄ±í£¬Èç¹ûûÓиòÎÊý£¬ËùÓÐ±í½«Ã»ÓÐÖ÷¼üºÍË÷Òý£©
10) db2ilist (list instance)
11) db2 uncatalog database database_name
12) db2 uncatalog node node_name
×¢Òâ: Ô¶³ÌÊý¾Ý¿â¿ÉÒÔ±»±àÄ¿£¬±»±àÄ¿µÄÊý¾Ý¿âÒ²¿ÉÒÔɾ³ýÕâÖÖ±àÄ¿¹ØÏµ£¬µ«ÊÇÊý¾Ý¿â²»ÄÜÔÚÔ¶¶Ë±»´´½¨ºÍɾ³ý¡£
Ò»Ð©ÖØÒªµÄ¸ÅÄ
db2c_DB2
ÔÚÃüÁî"db2 catalog tcpip node WSII remote 9.181.139.155 server 50000"ÖУ¬ÆäÖеIJÎÊý50000£¬²»½ö¿ÉÒÔÓÃÕâÖֶ˿ڵÄÊý×ÖÐÎʽ£¬Ò²¿ÉÒÔÓÃÒ»¸ö½Ð×ödb2c_DB2µÄ·þÎñÃû³Æ¡£
db2c_DB2Ö÷ҪʵÏÖDB2µÄÍøÂç·þÎñ¹¦ÄÜ¡£db2c_DB2ºÍÊý×Ö¶Ë¿ÚÖ®¼äµÄ¹ØÏµÊµ¼ÊÉÏ¿ÉÒÔÔÚdbm cfgÎļþÖÐÕÒµ½¡£
ʹÓÃ"db2 get dbm cfg"ÃüÁî²¢²é¿´Èçϲ¿·Ö£º
TCP/IP Service name (SVCENAME) = db2c_DB2
|
ÒòΪdbmÔÚDB2ʵÀý¼¶±ð¶ÔÏà¹Ø²ÎÊý½øÐÐÉ趨£¬ËùÒÔ£¬ÉÏÊöµÄSVCENAME¼´ÊÇÒ»¸ö¶¨ÒåTCP/IP·þÎñ¶Ë¿ÚµÄʵÀý¼¶±ðµÄ²ÎÊý£¬ÆäȱʡֵΪ50000¡£
ÁíÍ⣬Èç¹ûÊÇÔÚÀàUNIXϵͳÖУ¬ÔÚetc/serviceĿ¼Ï£¬ÔÚservicesÎļþÖаüº¬Á˵±Ç°DB2ËùʹÓõ½µÄÏà¹Ø¶Ë¿ÚÐÅÏ¢£¬¿ÉÒÔͨ¹ýÐÞ¸ÄÕâ¸öÎļþÀ´½øÐÐÏà¹ØÐ޸ĺÍÉ趨¡£ÏÂÃæ¼´ÊÇÏà¹ØÄÚÈݵĽØÈ¡¡£
DB2_DB2 60000/tcp
DB2_DB2_1 60001/tcp
DB2_DB2_2 60002/tcp
DB2_DB2_END 60003/tcp // These ports reserved for
DB2 Fast Communications Manager
db2c_DB2 50000/tcp // this is the connection port for instance DB2
|
Codepage:
ÒòΪ±ÊÕßÔÚ²Ù×÷µÄ¹ý³ÌÖУ¬Ôø¾ÊÔÑé¹ýÒ»¸öÊÇÖÐÎIJÙ×÷ϵͳ£¬ÁíÍâÒ»¸öÊÇÓ¢ÎIJÙ×÷ϵͳµÄÇé¿ö¡£ÔÚÉÏÊöÇé¿öÏ£¬»á·¢ÉúËùνµÄcodepage²»¼æÈݵÄÎÊÌ⣨Õâ¸öÎÊÌâÔÚÏÂÃæµÄ"³ö´í·ÖÎö¼°½â¾ö"ÓнøÒ»²½ËµÃ÷£©¡£Codepage¾ÍÊÇÖ¸DB2µÄÓïÑԵİ汾¡£Ò»°ãÀ´Ëµ£¬Èç¹û²Ù×÷ϵͳÊÇÖÐÎĵϰ£¬ÄÇôDB2×Ô¶¯°²×°³ÉΪÖÐÎİ汾£¬Èç¹û²Ù×÷ϵͳÊÇÓ¢Îĵϰ£¬ÄÇôDB2×Ô¶¯°²×°³ÉΪӢÎİ汾¡£¾¡¹ÜÈç¹ûÔ´Êý¾Ý¿âºÍÄ¿±êÊý¾Ý¿âµÄcodepage²»Ò»Ñù£¬Óû§ÈÔÈ»¿ÉÒԳɹ¦µØ´ÓÔ´Êý¾Ý¿âÁ¬½Óµ½Ä¿±êÊý¾Ý¿â£¨¼´connectÃüÁîÈÔÈ»¿ÉÒԳɹ¦ÔËÐУ©£¬µ«ÊÇÈç¹ûûÓж¨ÒåÇ¡µ±µÄת»»±í£¨ÓÃÀ´×ª»»Á½¸ö²»Í¬Êý¾Ý¿âÖ®¼äµÄcodepageµÄ±í£©£¬ÔÚ¸´ÖƵÄʱºò´íÎ󽫲»¿É±ÜÃ⡣ΪÁ˼òµ¥Æð¼û£¬ÔÚ±¾²Ù×÷ʵ¼ù¹ý³ÌÖУ¬Á½¸öÊý¾Ý¿â¶¼ÊÇʹÓõÄͬÑùµÄcodepage¡£ÐèÒªÌá¼°µÄÊÇ£¬codepage¿ÉÒÔÔÚ´´½¨¸ÃÊý¾Ý¿âµÄʱºòΪÆäÖ¸¶¨¡£
¹ØÓÚcodepageºÍÊý¾Ý¿âÁ´½Ó·½ÃæµÄ½øÒ»²½ÐÅÏ¢£¬Çë²Î¿¼ÈçÏÂÍøÖ·£º
http://www.ibm.com/developerworks/cn/db2/library/techarticles/dm-0506chong/
http://chinaunix.net/jh/22/16779.html
³ö´í·ÖÎö¼°½â¾ö
ÎÊÌâ1ÃèÊö£º
SQL30081N ¼ì²âµ½Í¨ÐÅ´íÎó¡£ÕýÔÚʹÓõÄͨÐÅÐÒ飺"TCP/IP"¡£ÕýÔÚʹÓõÄͨÐÅAPI£º "SOCKETS"¡£¼ì²âµ½´íÎóµÄλÖãº"9.181.139.155"¡£¼ì²âµ½´íÎóµÄͨÐź¯Êý£º"connect"¡£ÐÒéÌØ¶¨µÄ´íÎó´úÂ룺"10060"¡¢"*"¡¢"*"¡£ SQLSTATE=08001
·ÖÎö£º
Õâ¸ö´íÎóµÄÔÒòͨ³£ÊÇÍøÂçÁ¬½Ó²»Îȶ¨Ôì³ÉµÄ¡£
½â¾ö£º
¼ì²é²¢È·±£Ô´Êý¾Ý¿âËùÔÚµÄÖ÷»úºÍÄ¿±êÊý¾Ý¿âËùÔÚµÄÖ÷»úÖ®¼äµÄÍøÂçÁ¬½Ó¿ÉÓ㬲¢ÇÒ¶Ë¿ÚÕýÈ·¡£ÔںܶàÇé¿öÏ£¬ÍøÂ粡¶¾µ¼ÖÂÍøÂç²»¿ÉÓÃÊÇÐèÒªÊ×Ïȼì²éµÄ·½Ãæ¡£
ÎÊÌâ2ÃèÊö£º
SQL0332N ûÓдÓÔ´´úÂëÒ³ "1252" ÖÁÄ¿±ê´úÂëÒ³ "1386" µÄת»»¡£ÔÒòÂëΪ "1"¡£
SQLSTATE=57017
·ÖÎö£º
Õâ¸öÎÊÌâÖ÷ÒªÊÇÓÉÓÚ±¾µØÊý¾Ý¿âºÍÔ¶³ÌÊý¾Ý¿âµÄ´úÂëÒ³£¨codepage£©²»Ò»ÖÂÔì³ÉµÄ¡£±ÈÈç±¾µØÊý¾Ý¿âÊÇ´úÂëҳΪ1386µÄÖÐÎİ汾£¬¶øÔ¶³ÌÊý¾Ý¿âÊÇ´úÂëҳΪ1252µÄÓ¢Îİ汾£¬ÕâÑù¿ÉÄÜ»á²úÉúһЩÒâÍâµÄ´íÎó¡£
½â¾ö£º
ͨ¹ýÈçÏÂÃüÁîÀ´¼ì²é´úÂëÒ³µÄÏà¹ØÉèÖ㺣¨ºìÉ«×ÖÌå¿ÉÒÔÓÉÓû§Ö¸¶¨£©
db2 get db cfg for clientdb (¼ì²éclientdbËùʹÓõĴúÂëÒ³)
db2 get db cfg for serverdb (¼ì²éserverdbËùʹÓõĴúÂëÒ³)
db2set (¼ì²éµ±Ç°Êý¾Ý¿âϵͳËùʹÓõĴúÂëÒ³)
ͨ¹ýÈçÏÂÃüÁîÀ´¸Ä±ä±¾µØDB2Êý¾Ý¿âϵͳµÄ´úÂëÒ³£º
db2set db2codepage=serverdb codepage (e.g. "1252")
db2 terminate
|
¿ÉÒÔͨ¹ýÈçϼòµ¥µÄÃüÁîÀ´ºË¶ÔÉÏÊöÐÞ¸ÄÊÇ·ñ³É¹¦£º
db2 connect to source user administrator using passw0rd // sourceÊÇ
Ô¶³ÌÊý¾Ý¿â·þÎñÆ÷
|
Èç¹ûsourceÊý¾Ý¿âºÍtargetÊý¾Ý¿â¿É¼æÈÝ£¬ÄÇô¸ÃÃüÁî¿ÉÒԳɹ¦·µ»Ø¡£
µÚ¶þ²¿·Ö ÅäÖÃMQ¶ÔÏó
²Ù×÷²½Öè
1. ±¾Îĸ½¼þÌṩÁËһЩ½Å±¾À´´´½¨Ïà¹ØµÄMQ¶ÔÏó£¬Óû§¿ÉÒÔͨ¹ýÐ޸ĻòÕßÖ±½ÓʹÓÃËüÃÇÀ´´´½¨³ö±ØÒªµÄMQ¶ÔÏó¡£EAST_QUEUE_DEFINE.TXTÎļþÊÇÓÃÀ´´´½¨QM_EASTÏà¹ØµÄÏûÏ¢¶ÔÏó£¬WEST_QUEUE_DEFINE.TXTÎļþÊÇÓÃÀ´´´½¨QM_WESTÏà¹ØµÄÏûÏ¢¶ÔÏó¡£ÉÏÊöÁ½¸ö½Å±¾£¬ÀïÃæ¶¼¶¨ÒåÁËqueues¡¢channels£¬ÒÔ¼°queue managersµÈ¶ÔÏó¡£Çë×¢Ò⣬ÉÏÊöÎļþ¶¨ÒåµÄ¶ÔÏó£¬Êµ¼ÊÉÏÊÇÓÃÀ´×öbidirectionalµÄQ¸´ÖÆ£¬¶ÔÓÚ±¾Îĵĵ¥Ïò¸´ÖƶøÑÔ£¬Ö»ÐèÒªÓõ½ÆäÖеÄÒ»²¿·Ö¼´¿É¡£
2. ÔÚServer AÉÏ£¬¶¨ÒåÃû½ÐQM_EAST µÄMQ manager¡£
Èç¹ûQM_EASTÒѾ´æÔÚ£¬°´ÕÕÈçϲ½Öèɾ³ý¾ÉµÄQM_EAST£º
(1) endmqm QM_EAST
(2) endmqlsr £¨Í£Ö¹queue manager µÄlistener£¬Ò²¿ÉÒÔͨ¹ýMQ servicesµÄstart/stop Íê³É¡££©
(3) dltmqm QM_EAST
È»ºóͨ¹ýÏÂÃæµÄ²½ÖèÀ´´´½¨Ö®£º
(1) crtmqm -q QM_EAST
(2) strmqm
(3) runmqlsr -t tcp -p 1451
(4) runmqsc QM_EAST<EAST_QUEUE_DEFINE.TXT £¨ÐèÒªÔÙ¿ªÒ»¸öcmdÔËÐÐÖ®£©
EAST_QUEUE_DEFINE.TXTÔÚ¸½¼þÖпÉÒÔÕÒµ½¡£
3. ÔÚServer BÉÏ£¬¶¨ÒåÃû½ÐQM_WESTµÄMQ manager¡£²½ÖèºÍ2ÀàËÆ¡£
Èç¹ûQM_WESTÒѾ´æÔÚ£¬°´ÕÕÈçϲ½ÖèÏÈɾ³ýÖ®£º
(1) endmqm QM_WEST
(2) endmqlsr
(3) dltmqm QM_WEST
È»ºóÔÙ´´½¨Ö®£º
(1) crtmqm -q QM_WEST
(2) strmqm
(3) ÔÚMQ ServicesµÄ¿ØÖÆÃæ°åÖУ¬Ñ¡ÔñQM_WEST£¬ÓÒ¼üµ¥»÷£¬È»ºóÑ¡Ôñnew->new listener£¬ È»ºóÌí¼ÓÒ»¸ölistener£¨TCP£¬¶Ë¿Ú1451£©£¬²¢È·±£¸ÃlistenerÔËÐÐÕý³£¡£
(4) runmqsc QM_WEST<WEST_QUEUE_DEFINE.TXT
EAST_QUEUE_DEFINE.TXTÔÚ¸½¼þÖпÉÒÔÕÒµ½¡£
×¢Ò⣺QM_EASTºÍQM_WEST µÄlistener¶Ë¿Ú¿ÉÒÔÈÎÒâÖ¸¶¨¿ÉÓõĶ˿ڣ¬ËüÃÇ¿ÉÒÔÏàͬ£¬Ò²¿ÉÒÔ²»Ïàͬ¡£ÕâÀÎÒÃǽ«QM_EASTºÍQM_WEST µÄ¶Ë¿Ú·Ö±ðÖ¸¶¨Îª1450ºÍ1451£¬ÒÔÊ¾Çø±ð¡£
ÉÏÃæ½²ÊöÁË´´½¨Ïà¹ØMQ¶ÔÏóµÄ²½Ö裬ÏÂÎĽ«¶ÔÈçºÎ²âÊÔMQ¶ÔÏó£¨ÈçMQ channelsºÍqueuesµÈ£©ÊÇ·ñÕý³£¹¤×÷½øÐÐÏêϸ½²½â¡£
²âÊÔWSMQ¶ÔÏóµÄÁ¬½ÓÐÔ
ÔÚ¶¨ÒåºÃWSMQ¶ÔÏóÖ®ºó£¬Óû§¿ÉÒÔÏÈ¶ÔÆäÁ¬Í¨ÐÔ½øÐвâÊÔ£¬ÒÔÈ·±£ºóÃæµÄ²½Öè¿ÉÒÔÕýÈ·½øÐС£Ö÷Òª¿ÉÒÔ´ÓÈçÏ·½Ãæ½øÐвâÊÔ£º
1. ͨ¹ýMQ ExplorerÀ´¼ì²échannelsÁ¬½ÓµÄÓÐЧÐÔ.
(1) ÔÚQM_EASTËùÔÚµÄÖ÷»úÉÏ£¬´ò¿ªMQ Explorer£¬Æô¶¯QM_EAST£¬ÄÇôÔÚ"channels"->"advanced"ÀïÃæ£¬½«¿ÉÒÔ¿´¼ûEAST_TO_WESTºÍWEST_TO_EASTÁ½¸öchannel¡£
(2) Óû§¿ÉÒÔÓÒ¼üµã»÷EAST_TO_WEST²¢Ñ¡ÔñstartÆô¶¯Ö®£¬È»ºó¿ÉÒÔÑ¡ÔñStatusÑ¡ÏîÀ´²é¿´ÆäÊÇ·ñÕý³£ÔËÐС£
(3) Èç¹ûstatusÊÇ"running"£¬±íÃ÷channelÔË×÷Õý³£¡£
(4) Èç¹ûstatusÊÇ"binding"£¬±íÃ÷channelÕýÔڰ󶨼àÌý¶Ë¿Ú£¬ÉÔºó½«ÓпÉÄÜ¿ªÊ¼´¦ÓÚÕý³£ÔË×÷״̬¡£ÕâÖÖÇé¿öÏ£¬ÉÔµÈÆ¬¿Ì²¢Ôٴμì²éÆä״̬£¬Èç¹ûÈÔÈ»ÊÇ´¦ÓÚ"binding"µÄ״̬£¬ÄÇôֹͣ²¢ÖØÐÂÆô¶¯¡£
(5) Èç¹ûstatusÊÇ"retrying"£¬±íÃ÷µ±Ç°channel²»ÄÜÕý³£ÔË×÷£¬Õâ¸öͨ³£ÊÇÓÉÓÚÍøÂçÔÒòÔì³ÉµÄ¡£¼ì²éÍøÂç×´¿ö£¬ÀýÈçͨ¹ýping³ÌÐòÀ´¼ì²éÍøÂçÊÇ·ñÓÐÎÊÌ⣬·À»ðǽÓÐʱҲ¿ÉÄܵ¼ÖÂMQ channelµÄretrying״̬£»¼ì²éÔ¶¶ËµÄqueue manager (ÕâÀïÊÇÖ¸QM_WEST)ÊÇ·ñÒѾÆô¶¯£¬ÆälistenerÊÇ·ñÔË×÷Õý³££¬²¢ÇÒ¼ì²éCCSIDÊÇ·ñÒ»Ö¡£Èç¹ûÔ¶¶ËµÄQM_WESTûÓÐÆô¶¯£¬ÄÇôstatusºÜÓпÉÄܾÍÊÇretryingµÄ״̬¡£ËùÒÔÓ¦¸Ã¼ì²éQM_WEST£¬±£Ö¤Æä´¦ÓÚÕý³£×´Ì¬£¬È»ºóÔÚQM_EASTÖÐÍ£Ö¹EAST_TO_WEST Õâ¸öchannel²¢ÖØÐÂÆô¶¯Ö®¡£ÕâЩ²½ÖèÖ®ºó£¬Ó¦¸ÃÄܽâ¾öÉÏÊöÎÊÌâ¡£
¶ÔÓÚWEST_TO_EASTÕâ¸öchannel£¬ÔÚQM_EAST£¬Óû§¿ÉÒÔ¼ì²éÆä״̬µ«ÊDz»ÄÜÆô¶¯»òÕßÍ£Ö¹Ëü£¬ËüÖ»Äܱ»·¢ËÍ·½Æô¶¯»òÕßÍ£Ö¹¡£Óû§Ó¦¸ÃÔÚQM_WEST¶ËÆô¶¯»òÕßÍ£Ö¹Ëü¡£
2. ͨ¹ýCLP·½Ê½À´¼ì²échannelsµÄÁ¬½ÓÐÔ²¢»ñÈ¡¸ü¶àÏà¹ØÐÅÏ¢ÓÐʱºò£¬Í¨¹ýÃüÁîÐз½Ê½¿ÉÒÔ¸ßЧ¿ì½ÝµØ¼ì²éһЩÏà¹ØµÄÐÅÏ¢£¬ÕâÖÖ·½Ê½¿ÉÒԽű¾»¯£¬µ±ÎÒÃÇÒª¼ì²éµÄchannelºÜ¶àʱ£¬»òÕßÏà¹Ø²Ù×÷ÖØ¸´ÐԱȽϴóʱ£¬Ó¦¸Ã¿¼ÂÇÃüÁîÐз½Ê½À´×ö¡£ÁíÍ⣬ÃüÁîÐз½Ê½Äܹ»»ñÈ¡¸ü¶àµÄ³ö´í·½ÃæµÄÏêϸÐÅÏ¢¡£
(1). ÔÚEASTÉÏÔËÐÐÈçÏÂÃüÁ
runmqchl -c EAST_TO_WEST -m QM_EAST
|
Èç¹ûûÓдíÎóÐÅÏ¢ÏÔʾ£¬±íÃ÷¸Ãchannel³É¹¦ÔËÐС£Ö®ºó´ò¿ªÁíÍâÒ»¸öÃüÁîÐд°¿Ú£¬²¢ÊäÈëÈçϵÄÃüÁ
runmqchl -c WEST_TO_EAST -m QM_WEST
|
Èç¹û´Ëʱ·µ»ØÏà¹Ø´íÎóÂ룬ÄÇô¶ÔÆä½øÐзÖÎö²¢¸ù¾Ý´íÎóÌáʾȥ²ÉÈ¡ÏàÓ¦µÄ½â¾ö°ì·¨¡£
(2). ²âÊÔ±¾µØµÄqueues ÔÚEASTÉÏ£¬Ö´ÐÐÈçÏÂÃüÁһ¸öÏûÏ¢·Åµ½¶ÓÁÐÉÏ£º
/usr/mqm/samp/bin/amqsput EAST_RESTARTQ QM_EAST
Sample AMQSPUT0 start
target queue is EAST_RESTARTQ
This is a test message to a local queue
Sample AMQSPUT0 end
|
È»ºóͨ¹ýÖ´ÐÐÏÂÃæµÄÃüÁîÀ´´ÓqueueÖлñÈ¡ÐÅÏ¢¡£Õâ¸öʱºòÓ¦¸Ã»áÏÔʾ³öÉÏÃæÊäÈëµÄÏûÏ¢Îı¾¡£
/usr/mqm/samp/bin/amqsget EAST_RESTARTQ QM_EAST
Sample AMQSGET0 start
message <This is a test message to a local queue>
no more messages
Sample AMQSGET0 end
|
ÔÚWEST¶Ë£¬Ö´ÐÐÈçÏÂÃüÁîÀ´½«Ò»¸öÏûÏ¢·Åµ½¶ÓÁÐÀïÃæ£º
/usr/mqm/samp/bin/amqsput WEST_RESTARTQ QM_WEST
Sample AMQSPUT0 start
target queue is WEST_RESTARTQ
This is a test message to a local queue
Sample AMQSPUT0 end
|
ͬÑùµÄ£¬Ö´ÐÐÈçÏÂÃüÁîÀ´´ÓqueueÖлñÈ¡ÐÅÏ¢¡£Õâ¸öʱºòÓ¦¸ÃÒ²»áÏÔʾ³öÉÏÃæÊäÈëµÄÏà¹ØÏûÏ¢Îı¾¡£
/usr/mqm/samp/bin/amqsget WEST_RESTARTQ QM_WEST
Sample AMQSGET0 start
message <This is a test message to a local queue>
no more messages
Sample AMQSGET0 end
|
(3). ²âÊÔÔ¶³ÌµÄqueues ²âÊÔ´ÓÔ¶¶ËµÄqueueÉÏÃæ·ÅÈëºÍÈ¡³öÏûÏ¢¡£
ÔÚEASTÉÏÖ´ÐÐÈçÏÂÃüÁîÀ´½«ÏûÏ¢·ÅÈëµ½WEST_ADMINQÕâ¸ö¶ÓÁÐÖС£
/usr/mqm/samp/bin/amqsput WEST_ADMINQ QM_EAST
Sample AMQSPUT0 start
target queue is WEST_ADMINTQ
This is a test message to a remote queue
Sample AMQSPUT0 end
|
ÔÚWESTÖÐÖ´ÐÐÈçÏÂÃüÁî»ñÈ¡À´×ÔWEST_ADMINQ ¶ÓÁÐÉϵÄÏûÏ¢¡£
/usr/mqm/samp/bin/amqsget WEST_ADMINQ QM_WEST
Sample AMQSGET0 start
message <This is a test message to a remote queue>
no more messages
Sample AMQSGET0 end
|
²½Öè×¢½â
Remote queues:
Remote queuesÊÇÒ»¸öÏà¶ÔµÄ¸ÅÄÊÇÓÃÀ´ÔÚÁíÍâÒ»¸öqueue managerÉ϶¨Òålocal queue¡£ÔÚ±¾ÎÄÖУ¬Ã¿¸öqueue manager·Ö±ð¶¨ÒåÁËÁ½¸öremote queue¡£ÔÚQM_EASTÉÏ£¬WEST_ADMINQºÍEAST_TO_WEST_Q±»¶¨Òå³ÉΪremote queue¡£ÔÚQM_WESTÉÏ£¬EAST_ADMINQºÍWEST_TO_EAST_Q±»¶¨Òå³ÉΪremote queue¡£
WSMQ objects:
¹ØÓÚMQ¶ÔÏóµÄ¸ü¶àÐÅÏ¢£¬Çë²Î¿¼¡¶Fast Track implementation scenarios¡·µÄ¸½Â¼A¡£¸Ã×ÊÁÏÔÚ¸½¼þÖÐÒѸø³ö¡£
³ö´í·ÖÎö¼°½â¾ö
ÎÊÌâ1ÃèÊö£º
C:\Documents and Settings\Administrator>runmqchl -c EAST_TO_WEST -m QM_EAST 5724-B41 (C) Copyright IBM Corp. 1994, 2002. ALL RIGHTS RESERVED.
2005-09-25 17:46:56 ͨµÀ³ÌÐòÒÑÆô¶¯¡£
2005-09-25 17:47:04 AMQ6047: ²»Ö§³Öת»»¡£
2005-09-25 17:47:04 AMQ9999: ͨµÀ³ÌÐòÒì³£ÖÕÖ¹¡£
·ÖÎö£º
ÔÚMQÏûÏ¢ÊÖ²áÖвéÕÒ¹ØÓÚAMQ6047µÄÏà¹ØÐÅÏ¢£¬ÈçÏ£º
AMQ6047 Conversion not supported.
Explanation: WebSphere MQ is unable to convert string data tagged in CCSID &1 to data in CCSID &2.
User Response: Check the WebSphere MQ Application Programming Reference Appendix and the appropriate National Language Support publications to see if the CCSIDs are supported by your system.
Õâ¸ö´íÎóµÄÔÒòÊÇÓÉÓÚÁ½¸öqueue managerµÄCCSID µÄÉèÖò»¼æÈÝÔì³ÉµÄ¡£¶øÕâÖÖ²»¼æÈݵÄ×î¸ù±¾ÔÒòÊÇÓÉÓÚ±¾µØµÄlocaleºÍÔ¶³ÌÖ÷»úµÄlocale²»Ò»ÖÂÔì³ÉµÄ£¨´Ó¶øWebSphere MQµÄ°²×°ÓïÑÔ°æ±¾²»Ò»Ñù£©¡£ÕâµãºÍDB2µÄcode pageÎÊÌâºÜÀàËÆ¡£
½â¾ö£º
(1) ÔÚMQ explorerÖÐÕÒµ½CCSID¼°Ïà¹ØÊôÐÔ¡£ÔÚ±ÊÕߵĻ·¾³ÖУ¬Èç¹û°²×°µÄÊÇÖÐÎİæµÄMQ£¬ÄÇôCCSIDµÄȱʡֵÊÇ1381£¬¶øÓ¢ÎİæµÄÔòÏàӦΪ437¡£ÔÚÕâÁ½ÕßÖ®¼ä£¬ËüÃDz¢Ã»ÓÐÖ±½ÓµÄת»»·½Ê½À´½øÐмæÈÝÐÔ´¦Àí¡£
(2) ÓÉÓÚ(1)£¬ÎÒÃDZØÐëÔÚ±¾µØ¶ÔCCSID½øÐÐת»»¡£ÔÚEAST(CCSID=1381)¶Ëͨ¹ýÈçÏÂÃüÁîÀ´ÊµÏÖÆäת»»£º
strmqm
runmqsc
display qmgr // ¼ì²éµ±Ç°queue managerµÄCCSIDÖµ
alter qmgr ccsid(437)
end
|
µÚÈý²¿·Ö ͨ¹ýReplication CenterͼÐνçÃæ½¨Á¢Ô¶³ÌQ¸´ÖÆ
²Ù×÷²½Öè
Õⲿ·ÖÖ÷Ҫͨ¹ýGUIͼÐνçÃæ£¨¼´Replication Center£©À´Íê³É¡£Í¬Ê±£¬ÎªÁË·½±ãÆð¼û£¬ÆäÖÐÒ²»áÓõ½CLPÃüÁîÐз½Ê½¡£¶ÔÓÚ±¾Îĵĵ¥Ïò¸´ÖƶøÑÔ£¬ÕâÀïÖ÷Ҫͨ¹ýÅäÖÃEAST¶ËÀ´ËµÃ÷Ïà¹ØÊ¹Ó÷½·¨¡£
ÔÚ¿ªÊ¼ÅäÖÃCaptureºÍApply֮ǰ£¬Ê×ÏÈÓ¦¸Ã¶ÔÃÜÂëºÍÁ¬½ÓÐÔ½øÐвâÊÔ¡£ÔÚReplication CenterÖУ¬Ñ¡ÔñManage Password and Connectivity£¬È»ºóÑ¡ÔñSystems£¬ÔÚÆäÖÐÌí¼ÓÁ½ÐÐÐÅÏ¢£¬¼´±¾µØEASTºÍÔ¶³ÌWESTµÄÏà¹ØÃÜÂëºÍÁ¬½ÓÐÅÏ¢¡£
¶ÔÓÚÔ¶³ÌQ replicationͼÐνçÃæ·½ÃæµÄ»ù±¾²Ù×÷£¬´óÌåºÍÍêÈ«ÔÚÒ»¸ö»úÆ÷ÉϵÄQ replicationÀàËÆ£¬Ö÷ÒªµÄÇø±ðÔÚÓÚ¶ÔMQÏà¹Ø¶ÔÏóµÄ²Ù×÷ÉÏÓÐËù²»Í¬¡£ËùÒÔÏÂÃæµÄ²Ù×÷²¿·ÖÖØµãÔÚÓÚMQµÄÏêϸ½éÉÜ¡£
1£®½¨Á¢Q CaptureÏà¹ØµÄ¿ØÖƱí
ͨ¹ýÇ°ÃæµÄ²½Ö裬ÕâÀïÖÁÉÙ¿ÉÒÔÓÐÁ½¸öDB2 server¿ÉÓã¬Ò»¸öÊÇServer A£¬Ò»¸öÊÇServer B¡£¿ÉÒÔʹÓÃÈçÏÂÃüÁîÀ´»ñÈ¡Ïà¹ØÐÅÏ¢£ºdb2 list db directory
¾ßÌå²Ù×÷²½ÖèÈçÏ£º
- Ñ¡ÔñSample×÷ΪCapture Server¡£
- ½«Q CaptureµÄSchemaÖ¸¶¨ÎªASN¡£
- Q ManagerÑ¡ÔñΪQM_WEST£¬È»¶øadmin queueÓ¦¸ÃΪWEST_ADMINQ²¢ÇÒrestart queueΪST_RESTARTQ¡£
- ÔÚÍê³ÉÉÏÊöÅäÖúó£¬SampleÕâ¸öCapture ServerÓ¦¸ÃÄܹ»ÓÃÀ´½øÐи´ÖÆÁË¡£
2£®½¨Á¢Q ApplyÏà¹ØµÄ¿ØÖƱí
- Ñ¡ÔñITARGET×÷ΪApply Server¡£
- ½«Q ApplyµÄSchemaÖ¸¶¨ÎªASN¡£
- Q ManagerÓ¦¸ÃΪQM_EAST¡£
3£®½¨Á¢Replication Queue Maps
- ÔÚSample½ÚµãÏ£¬Ñ¡Ôñ"create Replication Queue Maps"¡£
- Ñ¡ÔñApply ServerΪITARGET¡£
- ÒòÎªÇ°ÃæÎÒÃÇÑ¡¶¨ÁËWEST_ADMINQ×÷ΪSampleÕâ¸öCapture ServerµÄAdminQ£¬ËùÒÔ£¬Apply serverµÄadmin queueÒ²Ó¦¸ÃͬÑùÖ¸¶¨ÎªWEST_ADMINQ¡£Í¬Ê±£¬Ó¦¸ÃÖ¸¶¨send queueºÍreceive queueΪWEST_TO_EAST_Q¡£
- Ϊ Queue mapÖ¸¶¨Ò»¸öÃû³Æ¡£
4£®½¨Á¢¸´ÖÆÔ¤¶©¼¯
- ´ÓSample½Úµã£¬Ñ¡Ôñ"create Replication Subscriptions"¡£
- Ñ¡Ôñ"unidirectional replication"¡£
- Ñ¡ÔñITARGET×÷ΪĿ±ê·þÎñÆ÷£¬²¢ÇÒʹÓÃÇ°ÃæËù½¨Á¢µÄQueue map¡£
- ´ÓCapture ServerÖÐÑ¡ÔñÇ¡µ±µÄÔ´±í¡£
- ¶ÔÓÚÄ¿±ê±íµÈÆäËû·½ÃæµÄÉèÖã¬Ê¹ÓÃȱʡֵ¡£
- Íê³ÉÔ¤¶¨¼¯µÄ½¨Á¢¡£
5£®½¨Á¢ApplyËùÐèÒªµÄpasswordÎļþ
- ÔÚÄ¿±êϵͳÖн«µ±Ç°Â·¾¶×ªµ½apply_pathÉÏ¡£
- ÊäÈëÃüÁî"asnpwd init"¡£
- ÊäÈëÃüÁî"asnpwd add alias SAMPLE id administrator password ***"¡£ÕâÑù¾Í»áÉú³ÉÒ»¸öÏàÓ¦µÄpasswordÎļþ¡£
6£®Æô¶¯Q Capture³ÌÐò
É趨Ïà¹Ø²ÎÊý£¬Æô¶¯Q Capture¡£
7£®Æô¶¯Q Apply³ÌÐò
É趨Ïà¹Ø²ÎÊý£¬Æô¶¯Q Apply¡£
²½Öè×¢½â
1. µ±ÔÚReplication CenterÖÐÅäÖÃpasswordºÍconnectivityµÄʱºò£¬Ëü»áÒªÇóÖ¸¶¨Directory £¬ÕâÓ¦¸ÃÊÇDB2°²×°Ä¿Â¼ÏµÄbinĿ¼ËùÔڵķ¾¶£¬Èç"c:\sqllib\bin"¡£
2. µ±ÔÚReplication CenterÖÐÅäÖÃpasswordºÍconnectivityµÄʱºò£¬Ô¶³ÌÖ÷»úÃû×ÖÓ¦¸ÃÕýÈ·Ö¸¶¨¡£Êµ¼ÊÉÏ£¬ÔÚÕâÀïIPµØÖ·Ò²¿ÉÒÔºÍÔ¶³ÌÖ÷»úÃû×ÖͬÑù±»Ê¹Óá£
3. ÔÚÉèÖø´ÖÆ»·¾³µÄʱºò£¬¼ÇµÃ½«Capture ServerËùÔÚµÄÊý¾Ý¿âÉèÖÃΪarchive loggingģʽ¡£
4. PasswordÎļþÔÚÈçÏÂÇé¿öÏÂÊDZØÐëµÄ£º
a. µ±Q ApplyÐèҪʹÓÃexportÀ´µ¼³öÊý¾Ýʱ
b. µ±Q CaptureÐèÒªÁ¬½Óµ½¶à¸öÊý¾Ý¿â·ÖÇøÊ±
c. µ±ÐèÒª½¨Á¢ÏàÓ¦µÄAlert Monitorʱ
d. µ±ÐèÒªÔËÐÐQ Analyzer£¨¸Ã³ÌÐòÐèÒªÁ¬½Óµ½±»·ÖÎöµÄQ CaptureºÍQ Apply£©Ê±
e. µ±ÐèÒªÓõ½TDIFF¹¤¾ßʱ
5. ¹ØÓÚDead Letter Queue£¬¿ÉÒԲο¼¡¶Fast Track Implementation Scenarios¡·ÖеÄAppendix C. Dead letter queues in a Q replication environment
³ö´í·ÖÎö¼°½â¾ö
ÎÊÌâ1ÃèÊö£º
Capture¿ÉÒÔÕý³£Æô¶¯£¬µ«ÊÇApply²»ÄÜÕý³£Æô¶¯£¬´¦ÓÚpresume stoppedµÄ״̬¡£Receive queueÕý³£ÔË×÷£¬subscription´¦ÓÚ"inactive"µÄ״̬£¬MQ channelsÕý³£ÔË×÷¡£
·ÖÎö£º
Õâ¸öÎÊÌâºÜÓпÉÄÜÊÇÍøÂçÔÒòÔì³ÉµÄ£¬ÀýÈçIPÉèÖôíÎóµÈµÈ¡£
½â¾ö£º
±£Ö¤ÍøÂçÕý³£Á¬½Ó£¬É趨ÕýÈ·µÄIPµØÖ·µÈµÈ¡£
ÎÊÌâ2ÃèÊö£º
ÔÚapplyÈÕÖ¾ÖУ¬ÓÐÈçÏÂÐÅÏ¢£º
2005-10-14 12:12:49.578000 ERROR ASN7551E "Q Apply" : "ASN" : "BR00000" : The Q Apply program detected a gap in message numbers on receive queue "WEST_TO_EAST_Q", replication queue map "SAMPLE_ASN_TO_ITARGET_ASN". It read message ID "51524550434D6AB0000000000000000000000000000003F0", but expected to find message ID "51524550434D6AB000000000000000000000000000000001". The Q Apply program cannot process any messages until if finds the expected message.
·ÖÎö£º
Q apply³ÌÐò¼ì²é´ÓQ Capture³ÌÐò·¢Ë͹ýÀ´µÄÏûÏ¢£¬ÕâЩÏûÏ¢¶¼¾ßÓÐÒ»¸öÒÀ´ÎµÝÔöµÄºÅÂ룬µÝÔöÔö·ùΪ1¡£µ±Q apply·¢ÏÖÏûÏ¢Ö®¼äµÄºÅÂë²»ÊÇÒÀ´ÎµÝÔöʱ£¬Apply³ÌÐò½«Í£Ö¹´¦Àí²¢ÇÒ½«Ïà¹ØÐÅϢдÈëapply logÖС£¿ÉÒÔͨ¹ýÃüÁî"db2 ? ASN7551E"À´»ñÈ¡¸ü¶àÐÅÏ¢¡£ÏÂÃæ¼´ÊǽØÈ¡µÄÒ»²¿·Ö£º
Óû§ÏìÓ¦£¨ASN7551E£©:
ÔÚÓÃÀ´ÔÚ Q Capture ºÍ Q Apply ³ÌÐòÖ®¼ä´«ÊäÏûÏ¢µÄËùÓÐWebSphere MQ ¶ÓÁйÜÀíÆ÷µÄËùÓÐ"ËÀÐŶÓÁÐ"ÉϲéÕÒ¾ßÓÐÆÚÍûÏûÏ¢±êʶµÄÏûÏ¢¡£Èç¹û»Ö¸´ÏûÏ¢£¬Ôò½«Ëü·ÅÖÃÔÚ½ÓÊÕ¶ÓÁÐÉÏ£¬²¢±£ÁôWebSphere MQ ÏûϢͷÐÅÏ¢£¨ÓÈÆäÊÇÏûÏ¢±êʶ£©¡£Èç¹û²»Äָܻ´ÏûÏ¢£¬Ôò×ñÑÏÂÁв½Ö裺
1. ʹÓà stopq ÃüÁîÀ´Í£Ö¹ Q Apply ³ÌÐò´Ó½ÓÊÕ¶ÓÁÐÖнøÐжÁÈ¡¡£
2. È¡Ïû¼¤»î´Ë¸´ÖƶÓÁÐͼµÄËùÓÐ Q Ô¤¶©¡£
3. Çå¿Õ·¢ËͶÓÁкͽÓÊÕ¶ÓÁС£
4. ʹÓà startq ÃüÁÒÔ±ã Q Apply ³ÌÐò¼ÌÐø´Ó½ÓÊÕ¶ÓÁÐÖнøÐжÁÈ¡¡£
5. ¼¤»î´Ë¸´ÖƶÓÁÐͼµÄËùÓÐ Q Ô¤¶©¡£
½â¾ö£º
ͨ¹ýÈçϲ½Ö裬¿ÉÒÔ½â¾öÕâ¸öÎÊÌ⣺
1. asnqacmd apply_server=ITAGGET apply_schema=ASN stoptq=WEST_TO_EAST_Q
2. ÔÚRCÖн«¸ÃQ subscriptionsÉèÖóÉΪ"deactivate"µÄ״̬¡£
3. ͨ¹ýRC½«WEST_TO_EAST_QÇå¿Õ¡£
4. asnqacmd apply_server=ITARGET apply_schema=ASN startq=WEST_TO_EAST_Q
5. Ôٴν«Q subscriptionsÉèÖóÉΪ"active"µÄ״̬¡£
¶ÔÓڸôíÎóÒ»¸ö½ÏºÃµÄ·½·¨¾ÍÊÇ£ºÔÚÆô¶¯Q Capture»òÕßQ Apply֮ǰ£¬½«QM_EASTºÍQM_WEST ÉϵÄadmin¡¢restart¡¢ºÍsend_receive queueus Çå¿Õ¡£
ÎÊÌâ3ÃèÊö£º
2005-10-16 15:48:16.171000 ERROR ASN0005E CAPTURE "ASN" : "WorkerThread". The Capture program encountered an error when reading the DB2 log. The log sequence number is "0000:0000:0000:0697:A8BD", the SQLCODE is "-2650", and the reason code is "piStartLSNÿdb2ReadLogÿ2".
·ÖÎö£º
Õâ¸ö´íÎóÖ÷Òª¿ÉÄÜÊÇÓÉÓÚDB2µÄÄÚ²¿´íÎóÒýÆðµÄ¡£
½â¾ö£º
ÍêÈ«ÖØÐ°²×°DB2À´½â¾öÕâ¸öÎÊÌâ¡£
ÎÊÌâ4ÃèÊö£º
2005-10-16-19.40.47.328000 <dbConnection::dbConnectCtx> ASN0552E "Q Apply" : "ASN" : "BR00000SP001" : The program encountered an SQL error. The server name is "SAMPLE". The SQL request is "CONNECT". The table name is "N/A". The SQLCODE is "-30082". The SQLSTATE is "08001". The SQLERRMC is "3ÿPASSWORD MISSINGÿ". The SQLERRP is "SQLEXSMC".
·ÖÎö£º
Õâ¸ö´íÎóÖ÷ÒªÊÇÓÉÓÚȱÉÙpasswordÎļþ¶øµ¼Öµġ£
½â¾ö£º
°²×°±¾ÎÄÉÏÊöÏà¹ØÄÚÈÝÉú³ÉpasswordÎļþ¼´¿É¡£


|
»ØÒ³Ê× |
|
½áÊøÓï
±¾ÎÄÖ÷Òª½éÉÜÁËÔ¶³ÌQ¸´ÖƵÄÏà¹Ø²Ù×÷£¬ÒÔ¼°Ò»Ð©Ïà¹ØµÄºËÐĸÅÄî¡£¶ÔÓÚ²Ù×÷¹ý³ÌÖг£¼ûµÄÎÊÌâºÍ´íÎó½øÐÐÁË·ÖÎö²¢¸ø³öÁËÒ»°ãµÄ½â¾ö·½·¨¡£


|
»ØÒ³Ê× |
|
ÏÂÔØ
| Ãû×Ö | ´óС | ÏÂÔØ·½·¨ |
| attachment.zip |
4KB |
HTTP |
|