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