Goldengate for DB2 8.2的介質為DB2 9.7做init load

趙宇發表於2009-11-27
GoDB2

如果用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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章