Zhao Yu of Oracle Life

暂无签名

  • 博客访问: 882404
  • 博文数量: 86
  • 用 户 组: 普通用户
  • 注册时间: 2007-12-25 11:07
个人简介

暂无介绍

文章分类

全部博文(86)

文章存档

2010年(4)

2009年(22)

2008年(60)

我的朋友

分类: Linux

2009-11-27 10:41:02

如果用Goldengate for DB2 8.2的介质为DB2 9.7做初始化数据同步可以的,虽然会提示:

Database Language and Character Set:

Warning: Unable to determine the application and database codepage settings.
Please refer to user manual for more information.


Processing table DB2ADMIN.TCUSTMER

Processing table DB2ADMIN.TCUSTORD

***********************************************************************
*                   ** Run Time Statistics **                         *
***********************************************************************


Report at 2009-11-27 10:27:10 (activity since 2009-11-27 10:26:44)

Output to RINIDB:

From Table DB2ADMIN.TCUSTMER:
       #                   inserts:         2
       #                   updates:         0
       #                   deletes:         0
       #                  discards:         0
From Table DB2ADMIN.TCUSTORD:
       #                   inserts:         2
       #                   updates:         0
       #                   deletes:         0
       #                  discards:         0

但数据还是可以同步过去的。但如果用这个介质做CDC,就会报下面错误

 

GGSCI (zhao-cn) 8> view report edb2db

***********************************************************************
                   Oracle GoldenGate Capture for DB2
                      Version 10.4.0.19 Build 002
       Windows (optimized), DB2 8.1.0.36 on Sep 23 2009 14:25:54

Copyright (C) 1995, 2009, Oracle and/or its affiliates.  All rights reserved.


                    Starting at 2009-11-27 10:38:25
***********************************************************************

Operating System Version:
Microsoft Windows XP Professional, on x86
Version 5.1 (Build 2600: Service Pack 3)

Process id: 5128

Description:

***********************************************************************
**            Running with the following parameters                  **
***********************************************************************
EXTRACT EDB2DB

-- Login info for source database
SOURCEDB sample, USERID DB2ADMIN, PASSWORD "**********"

-- To ignore transactions applied by the replicat (i.e. loop detection)
TRANLOGOPTIONS EXCLUDEUSER db2admin

-- Set report generation interval
REPORTCOUNT EVERY 10000 RECORDS, RATE
--REPORTCOUNT EVERY 30 MINUTES, RATE

-- Location of trail file on remote system
EXTTRAIL ./dirdat/sl

-- Resolve meta. data for table def as it appears in log record
--WILDCARDRESOLVE DYNAMIC

-- Identify tables to extract
TABLE db2admin.*;

CACHEMGR virtual memory values (may have been adjusted)
CACHEBUFFERSIZE:                         64K
CACHESIZE:                                1G
CACHEBUFFERSIZE (soft max):               4M
CACHEPAGEOUTSIZE (normal):                4M
PROCESS VM AVAIL FROM OS (min):        1.82G
CACHESIZEMAX (strict force to disk):   1.60G

Database Version:
DB2/NT
Version 09.07.0001
ODBC Version 03.01.0000

Driver Information:
DB2CLI.DLL
Version 09.07.0001
ODBC Version 03.51

Database Language and Character Set:

Warning: Unable to determine the application and database codepage settings.
Please refer to user manual for more information.


Source Context :
  SourceModule            : [er.redo.db2]
  SourceID                : [$Id: //depot/releases/OpenSys/v10.4.0/src/app/er/re
do/db2luw/redodb2.c#1 $]
  SourceFunction          : [REDO_position]
  SourceLine              : [1232]
  ThreadBacktrace         : [2] elements
                          : [( 0x0053E3F4) [0x0053E3F4]]
                          : [( 0x004EE2B0) [0x004EE2B0]]

2009-11-27 10:38:26  GGS ERROR       146  Execution cannot continue - Program Te
rminating.

Source Context :
  SourceModule            : [er.redo.db2.ops]
  SourceID                : [$Id: //depot/releases/OpenSys/v10.4.0/src/app/er/re
do/db2luw/db2ops.c#1 $]
  SourceFunction          : [DB2OPS_getNextStartLsn]
  SourceLine              : [935]
  ThreadBacktrace         : [2] elements
                          : [( 0x0053E3F4) [0x0053E3F4]]
                          : [( 0x004EE2B0) [0x004EE2B0]]

2009-11-27 10:38:26  GGS ERROR       138  db2ReadLog error [SC=-2032:SQL2032N  "
versionNumber" 参数无效。  SQLSTATE=22531:SQLSTATE 22531: 内置或系统提供的例程的
自变量导致错误。].

2009-11-27 10:38:26  GGS ERROR       190  PROCESS ABENDING.

阅读(4020) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~

zhoujiongfield2010-11-05 11:00:22

我在使用GoldenGate for DB2 8.1 8.2,向ORACLE同步时也出现这个问题,导致DB2端的提取进程跑不起来。但是如果反过来从ORACLE向DB2同步缺是可以。正在寻找原因中

赵宇2009-11-27 10:53:35

D:\ggs>ggsci Oracle GoldenGate Command Interpreter for DB2 Version 10.4.0.19 Build 002 Windows (optimized), DB2 8.1.0.36 on Sep 23 2009 14:11:08 Copyright (C) 1995, 2009, Oracle and/or its affiliates. All rights reserved.

评论热议
请登录后评论。

登录 注册