Goldengate for DB2 8.2的介质为DB2 9.7做init load

如果用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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/175005/viewspace-620790/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/175005/viewspace-620790/