IBM solidDB Universal Cache V6.3 user manual
Contents
1. X IBM solidDB Universal Cache 1 IBM solidDB Universal Cache IBM solidDB Universal Cache solidDB li solidDB IBM InfoSphere Change Data Cap ture InfoSphere CDC CDC DBMS jE solidDB Universal Cache solidDB2. API IBM IBM HJH Universal Cache CE IBM Corp Copyright IBM Corp All rights reserved IBM IBM ER ibm com Solid solidDB InfoSphere DB2 Informix WebSphere International Business Machines Corporation
3. lt gt InfoSphere CDC 1 Linux Windows Universal Cache TSINSTANCE TSINSTANCE InfoSphere CDC TSINSTANCE Windows SET TSINSTANCE lt instance_name gt e lt instance_na
4. dmstartmirror I lt instance_name gt c n lt A s lt subscription_names gt gt L lt locale gt lt instance_name gt InfoSphere CDC TSINSTANCE c InfoSphere CDC c n InfoSphere CDC c n InfoSphere CDC A InfoSphere CDC S lt subscription_names gt InfoSphere CDC L lt locale gt InfoSphere CDC 0 dmstartmirror I myinstance c s Finance InfoSphere CDC Finance
5. 1000 1 mirror commit on transaction boundary InfoSphere CDC InfoSphere CDC true false true refresh_commit after_max_operations InfoSphere CDC
6. Java 2 UserExitlF Java UserExitF public class UE1 implements UserExitIF UE1 lt Java package gt UE1 Java com datamirror interface UE1 rh CLASSPATH 8 getParameter 255 9 InfoSphere CDC
7. InfoSphere Change Data Capture Management Console Administration Guide 1 CDC InfoSphere Change Data Capture Management Console Administration Guide wm gt F Q N Ending replication on a subscription 19 20 IBM solidDB Universal Cache 6 CDC for solidDB soli dDB Universal Cache CDC IBM InfoSphere Change Data Capture for IBM solidDB ET CDC solidDB Universal Cache CDC InfoSphere CDC InfoSphere CDC for solidDB InfoSphere CDC for IBM solidDB IBM InfoSphere Change
8. 6 CDC for solidDB 61 62 IBM solidDB InfoSphere CDC 2004 1 J 2004 2 2006 11 InfoSphere CDC for IBM solidDB A lt fe E F 1 Ba S gt DS InfoSphere CDC for IBM solidDB Java XHP EO Java Java InfoSphere CDC for IBM solidDB UserExitIF Java gt
9. InfoSphere CDC Managemen wasi EE L Console Adininistration Guide InfoSphere CDC for IBM solidDB 2 lt 21 21 21 22 2 22 2 A 3 28 28 lt 29 s 29 30 30 31 31 7 32 32 33 33 599 39 43 41 48 51 252 22 52 252 56 OI v 39 61 61 63 69 iv IBM solidDB Universal Cache 1 solidDB Universal Cache solidDB solidDB Universal 2 solidDB Universal Cache 4 Cache N W vi IBM solidDB Universal Cache 1 2 six 3 solidDB Universal Cache Vii viii IBM solidDB Universal Cache IBM solidDB Universal Cache SQL
10. solidDB Uni versal Cache CDC Universal Cache solidDB Universal Cache
11. solidDB solidDB solidDB r 1 LOBS solidDB 30 1 solidDB solidDB HA 7 TCDC 1 D LOB solidDB 6 IBM solidDB Universal Cache M LOB miniLOB LOB
12. Change Data Capture InfoSphere CDC InfoSphere CDC InfoSphere CDC dmmarktablecapturepoint I lt instance name gt s lt subscription names gt lt A t lt schema gt lt table gt gt L lt locale gt lt instance_name gt InfoSphere CDC TSINSTANCE d s lt subscription_names gt A InfoSphere CDC t lt Schema gt lt table gt InfoSphere CDC schema table L lt locale gt InfoSphere CDC
13. my CDC 2 solidDB Universal Cache ERLE solidDB solidDB Universal Cache soli dDB HotStandby HotStandby solidDB Universal Cache CDC solidDB HotStandby solidDB Universal Cache 4 IBM solidDB Universal Cache solidDB HSB solidDB HSB solidDB E solidDB CDC CDC E 3 solidDB nf HFE solidDB Universal Cache KA solidDB HA
14. dmdecodebookmark dmdecodebookmark I lt instance name gt b f d L lt locale gt 6 CDC for solidtDB 35 36 IBM solidDB lt instance_name gt InfoSphere CDC TSINSTANCE InfoSphere CDC b lt bookmark gt f lt bookmark _ file gt d lt database_version gt InfoSphere CDC L lt locale gt InfoSphere CDC 0 dmdecodebookmark f bookmark txt T InfoSphere CDC bookmark txt dmsetbookmark dmsetbookmark I lt instance_n
15. Windows 1 InfoSphere CDC 2 samples jar InfoSphere CDC lib xp m jar jar lt InfoSphere CDC installation folder gt lib com datamirror ts target publication userexit sample 6 CDC for solidtDB 57 58 IBM solidDB UserExitSample java lib javac classpath ts jar com datamirror ts target publication userexit sample UserExitSample java Ez 24 E Java JDK UserExitSample class lt InfoSphere CDC installation directory gt lib com datamirror ts target publication userexit sample InfoSphere CDC 7 UserExitSample com datamirror t
16. IBM IBM Web www ibm com legal copytrade shtml ET IBM Java Java Sun Microsystems Inc Linux Linus Torvalds Microsoft and Windows Microsoft Corporation The Open Group UNIX 71 S151 1149 00
17. lt InfoSphere CDC Installation Directory gt bin dmconfigurets 6 CDC for solidDB 27 3 1 Enter InfoSphere CDC 4 3 Enter InfoSphere CDC 5 Enter 6 5 Enter 6 Enter InfoSphere CDC UNIX Linux 1 InfoSphere CDC 2 lt InfoSphere CDC Installation Directory gt bin dmconfigurets 3 1 Enter InfoSphere CDC 4 4 Enter InfoSphere CDC 5 Enter InfoSphere CDC 28
18. InfoSphere Change Data Capture CDC CDC CDC S solidDB 1 CDC for solidDB 22 InfoSphere CDC Windows 1 25 InfoSphere CDC UNIX Linux J ZT jk solidDB solidDB solidDB 2 CDC InfoSphere Change Data Cap ture InfoSphere CDC 7 CDC SOLIDDBCACHE InfoSphere Change Data Capture Management Console Administration Guide E
19. 1 AFTERIMG Y N TGTIMG 1 1 TGTTRNC TGTIMG Y N WINIMG 1 1 WINTRNC WINIMG Y N BEFOREIMG AFTERIMG TGTIMG WINIMG VARCHAR raw LOB ya Universal Cache
20. 11101 iF J IT P UDP InfoSphere CDC RAM T 64 MB 512 MB RAM 32 1024 MB RAM 64 32 64 32 InfoSphere CDC 4 Windows InfoSphere CDC 6 CDC for solidDB 23 24 IBM solidDB
21. 32KB miniLOB 30KB solidDB D R 2GB LOB maxiLOB maxiLOB D A LOB solidDB LOB M miniLOB soli dDB TRUNCATE TABLE solidDB
22. InfoSphere CDC InfoSphere CDC H Universal Cache InfoSphere CDC H InfoSphere CDC El InfoSphere CDC H InfoSphere CDC jl InfoSphere CDC ui InfoSphere CDC El InfoSphere CDC InfoSphere CDC 10 InfoSphere CDC for IBM solidDB InfoSphere CDC InfoSphere CDC Info
23. DEUserExitSample USER SPUserExitSample 1 PopWindow X Windows GUI UNIX Linux com datamirror ts target publication userexit sample UserExitSample ts jar xH ts jar lt class directory gt 1ib FF lt InfoSphere CDC installation Win dows Linux Co Java
24. InfoSphere Change Data Capture Management Con sole Administration Guide Setting up datastores for replication H T solidDB InfoSphere Change Data Capture Management Con sole Administration Guide Setting system parameters on source and target datastores 77 RAMII a solidDB b solidDB InfoSphere Change Data Capture Management Con sole Administration Guide Setting up subscriptions gt 3 solidDB Universal Cache 13 InfoSphere Change Data Capture Management Con sole Administration Guide Mapping tables 7 Universal Cache Change Data Cap ture 9 InfoSphere Change Data Capture Management Con sole Administration Guide
25. MYCOLUMN a MYCOLUMN 2 k lt gt d lt gt H 6 CDC for solidDB 55 Create or replace procedure PROD AUDIT_STPROC result OUT INT returnMsg OUT CHAR s entry IN NUMBER s srcSysId IN CHAR s srcTabId IN CHAR s tgtTabId IN CHAR j ENTT IN CHAR a IDNO IN NUMBER a PRICE IN NUMBER a DESC IN CHAR a LONGDESC IN CHAR a TRANSDATE IN DATE d IDNO IN NUMBER d PRICE IN NUMBER d DESC IN CHAR d LONGDESC IN CHAR d TRANSDATE IN DATE result 0
26. CTRR CNTRRN j ENTT j ENTTYP VARCHAR j JRN j JOURNAL VARCHAR InfoSphere CDC j JOB VARCHAR j MBR j MEMBER VARCHAR j NBR j JOBNO VARCHAR j PGM j PROGRAM VARCHAR j SEQN j SEQNO VARCHAR j SYNM j SYSTEM VARCHAR j USER VARCHAR I j USPF VARCHAR j TSTP j TIMSTAMP VARCHAR
27. InfoSphere Change Data Capture Access Server and Management Console Installation Guide InfoSphere CDC InfoSphere Change Data Capture Access Server and Management Console Installation Guide 3 solidDB Universal Cache CDC for solidDB IBM solidDB 6 3 IBM solidDB Universal Cache TCDC for solidDB 1 CDC InfoSphere Change Data Capture v6 3 InfoSphere Change Data Capture CDC InfoSphere Change Data Capture v6 3 InfoSphere Change Data Capture Man agement Console Administration Guide CDC 10 IBM solidDB Universal Cache 3 solidDB Universal Cache solidDB Universal Cache Uni versal Cache
28. 2 CDC 3 solidDB LogReader MaxLogSize HR solidDB CDC CDC CDC 4 solidDB Universal Cache 17 18 IBM solidDB Univer
29. true false False InfoSphere CDC InfoSphere CDC
30. 7 8 JE InfoSphere CDC 9 wm mm PR 21 InfoSphere CDC Unix Linux X Windows Windows 1 InfoSphere CDC 2 Linux InfoSphere CDC 3 4 3 Enter 6 L 7 Enter
31. solidDB solidDB UNIQUE NULL solidDB solidDB UNIQUE NULL NULL UNIQUE CDC CDC CDC for solidDB CDC for solidDB DBMS CDC 1 IBM sol
32. 0 Universal Cache dmmarktablecapturepoint I myinstance s Finance A InfoSphere CDC Finance dmmarktablecapturepoint I myinstance s Finance t myschema mytable InfoSphere CDC Finance dmpark InfoSphere CDC InfoSphere CDC i 33 rdmendreplication 1 dmpark I lt instance_name gt s lt subscription_names gt lt A t lt schema gt lt table gt gt L lt locale gt lt instance_name gt InfoSphere CDC
33. solidDB solidDB solidDB CDC 1 12 IBM solidDB Universal Cache InfoSphere Change Data Capture Management Con sole Administration Guide Logging into Management Console Connecting to Access Server T solidDB a InfoSphere Change Data Cap ture Management Console Administration Guide To add a new datastore b InfoSphere Chang
34. 1000 1 Unicode global unicode as char Unicode InfoSphere CDC Unicode Unicode 6 CDC for solidtDB 65 true InfoSphere CDC Unicode Unicode false InfoSphere CDC Unicode Unicode I false InfoSphere CDC InfoSphere CDC mE
35. DurabilityLevel solidDB DurabilityLevel 1 w3 solidDB solid ini Logging DurabilityLevel 3 ik soli dDB HA HotStandby 2 Safe AH BATER DefaultStorelsMemory solidDB M K DefaultStorelsMemory yes 11 IsolationLevel solidDB IsolationLevel 1 4 CLASSPATH solidDB JDBC jar solidDB JDBC jdbcreadme html jdbcreadme txt CDC
36. InfoSphere CDC dmbackupmd I lt instance name gt L lt locale gt lt instance_name gt InfoSphere CDC TSINSTANCE eE L lt locale gt InfoSphere CDC 0 dmset InfoSphere CDC InfoSphere CDC dmset I lt instance_name gt lt parameter_name gt lt parameter_value gt L lt locale gt lt instance_name gt InfoSphere CDC TSINSTANCE eE lt parameter_name gt InfoSphere CDC p Universal Cache lt parameter_value gt
37. L lt locale gt InfoSphere CDC 6 CDC for solidDB 33 34 IBM solidDB 0 dmendreplication I myinstance c s Finance InfoSphere CDC Finance dmrefresh InfoSphere CDC InfoSphere CDC InfoSphere CDC dmrefresh I lt instance name gt a f lt A s lt subscription names gt
38. solidDB IO solidDB Universal Cache solidDB Universal Cache solidDB SolidDB CDC r 1 solidDB Universal Cache solidDB solidDB CDC DBMS CDC CDC DBMS CDC 2 IBM solidDB Universal Cache CDC for DB2 CDC for solidDB
39. 6 CDC for solidDB 51 InfoSphere CDC result returnMsg InfoSphere CDC
40. EEA EMR 5 6 CDC for solidDB He HA HotStandby solidDB E solidDB CDC for solidDB 11 11 a l 12 12 2 15 15 15 16 16 s17 oe 19 21 InfoSphere CDC for IBM solidDB InfoSphere CDC Tf CDC InfoSphere CDC InfoSphere CDC Windows InfoSphere CDC Windows InfoSphere CDC UNIX Linux InfoSphere CDC UNIX Linux InfoSphere CDC oe InfoSphere CDC InfoSphere CDC SQL InfoSphere CDC InfoSphere CDC InfoSphere CDC H InfoSphere CDC TSINSTANCE InfoSphere CDC
41. InfoSphere CDC InfoSphere CDC dmshowevents I lt instance name gt lt a s lt subscription gt t lt source_ID gt s lt subscription gt t lt source_ID gt gt h c max_msg L lt locale gt dmshowevents I lt instance name gt lt a s lt subscription gt t lt source_ID gt gt gt h c max msg L lt locale gt lt instance_name gt InfoSphere CDC TSINSTANCE F EAE a InfoSphere CDC s lt subscription gt InfoSphere CDC JE W Sat EB T 6 CDC for solidDB 45 46 IBM solidDB t lt source_ID gt InfoSphere CDC h InfoSphere CDC
42. TS_CONFAUD InfoSphere CDC InfoSphere CDC BEFOREIMG AFTERIMG TS_CONFAUD CNFTIME SRCTIME SRCSYSID SRCSCHEMA SRCNAME SRCMEMBER TGTSCHEMA TGTNAME OPTYPE 1 2 3 CNFTYPE
43. InfoSphere CDC InfoSphere CDC solidDB HKS T solidDB JDBC JDBC IBM solidDB Programmer Guide 6 solidDB HA H HotStandby solidDB Universal Cache HA HotStandby solidDB solidDB
44. ENTRYPOINT VARCHAR 50 BEGIN CASE s entry WHEN 16 THEN ENTRYPOINT User Exit program called Before Insert WHEN 1048576 THEN ENTRYPOINT User Exit program called After Insert WHEN 64 THEN ENTRYPOINT User Exit program called Before Update WHEN 4194304 THEN ENTRYPOINT User Exit program called After Update END CASE 56 IBM solidDB Universal Cache insert into PROD AUDIT_TABLE1 values s entry s srcSysId s srcTabId s tgtTabId j ENTT a IDNO a PRICE a DESC a LONGDESC a TRANSDATE d IDNO d PRICE d DESC d LONGDESC d TRANSDATE ENTRYPOINT PROD AUDIT_TABLE result 1 returnMsg OK IE IHH END AUDIT_STPROC 0 InfoSphere CDC InfoSphere CDC e UserExitSample F UserExitSample1
45. 1 T IBM solidDB ERER WAW ATIE PA TR solidDB 1 H CDC InfoSphere Change Data Capture InfoSphere CDC for IBM solidDB 21 InfoSphere CDC 1 CDC 11 solidDB i solidDB InfoSphere CDC CDC InfoSphere Change Data Capture CDC InfoSphere Change Data Capture solidDB InfoSphere CDC
46. Java sql Connection LockHashSize Windows argument UNIX IERIE PHE O K 1 2 UNIX Microsoft Windows UNIX solidDB 2 INSERT INTO toble_nome solid ini
47. Management Console Administration Guide solidDB InfoSphere Change Data Capture Management Console Administration Guide InfoSphere CDC InfoSphere CDC InfoSphere CDC InfoSphere CDC InfoSphere CDC InfoSphere CDC
48. InfoSphere CDC s s s entry InfoSphere CDC j j j USER H b e InfoSphere CDC lt
49. S lt subscription_names gt InfoSphere CDC L lt locale gt InfoSphere CDC 0 dmdescribe I new_instance s Finance InfoSphere CDC Finance dmflagforrefresh dmflagforrefresh I lt instance_name gt S lt subscription_names gt lt A t lt schema gt lt table gt gt L lt locale gt lt instance_name gt InfoSphere CDC TSINSTANCE s lt subscription_names gt A InfoSphere CDC
50. CDC solidDB solidDB solidDB 5 CDC CDC for solidDB solidDB CLASSPATH solidDB JDBC CDC for solidDB solidDB 1 solidDB solid ini LogReaderEnabled 39 yes LogReader LogReaderEnabled yes CDC solidDB po 2 solidDB solid ini MaxLogSize LogReader MaxLogSize lt MB gt 10 240 10 GB 1 CheckpointDeleteLog Yes 3
51. TSINSTANCE F EAE s lt subscription_names gt A InfoSphere CDC t lt Schema gt lt table gt BE InfoSphere CDC schema table L lt locale gt InfoSphere CDC 0 dmpark I myinstance S Finance A InfoSphere CDC Finance dmreaddtable iy CDC RDBMS dmreaddtable I lt instance_name gt lt A t lt schema gt lt table gt gt L lt locale gt 6 CDC for solidDB 41 lt instance_name gt InfoSphere CDC TSINSTANCE A InfoSphere CDC
52. XML dmimportconfiguration i XML InfoSphere CDC XML dmexportconfiguration lt path to configuration file gt L lt locale gt lt path_to_configuration_file gt XML InfoSphere CDC L lt locale gt InfoSphere CDC 0 dmexportconfiguration c configurations configuration xml InfoSphere CDC XML dmimportconfiguration InfoSphere CDC dmexportconfiguration
53. 10 InfoSphere CDC s srcSysId VARCHAR s srcTabId VARCHAR s tgtTabId VARCHAR jb InfoSphere CDC 6 CDC for solidDB 53 54 IBM solidDB j CCID VARCHAR j CODE VARCHAR U R j CTRR j CNTRRN VARCHAR iF
54. InfoSphere CDC dmshowlogdependency I lt instance_name gt c i t 1 s lt subscription_name gt A v L lt locale gt lt instance_name gt InfoSphere CDC TSINSTANCE InfoSphere CDC C InfoSphere CDC OK i t InfoSphere CDC InfoSphere CDC s lt subscript
55. IBM solidDB solidDB solidDB IBM solidDB solidDB MaxLogSize IBM solidDB 1 solidDB MaxLogSize MaxLogSize IBM solidDB r 1
56. 6 CDC for solidDB 39 40 IBM solidDB t lt schema gt lt table gt InfoSphere CDC schema table L lt locale gt InfoSphere CDC 0 dmflagforrefresh I myinstance s Finance A InfoSphere CDC Finance dmmarktablecapturepoint InfoSphere CDC
57. 7 InfoSphere CDC 8 InfoSphere CDC InfoSphere CDC Windows 1 dmshutdown InfoSphere CDC 2 lt InfoSphere CDC Installation Directory gt bin dmconfigurets 3 4 InfoSphere CDC 5 6 7 InfoSphere CDC Windows 1 amshutdown InfoSphere CDC 2 lt InfoSph
58. returnMsg s entry CDC e s entry CDC s srcSysld s srcSysld e s srcTabld s srcTabld s tgtTabld e s tgtTabld HIH gt Er L gt H HE peny JA Er L e a IDNO PRICE DESC a IDNO PRICE DESC InfoSphere InfoSphere j ENTT j ENTT LONGDESC TRANSDATE LONGDESC TRANSDATE d IDNO PRICE DESC LONGDESC TRANSDATE e d IDNO PRICE DESC LONGDESC TRANSDATE IS
59. InfoSphere CDC InfoSphere CDC IBM solidDB Windows InfoSphere CDC InfoSphere CDC Windows Linux InfoSphere CDC InfoSphere CDC InfoSphere CDC Windows 1 lt InfoSphere CDC Installation Directory gt bin dmconfigurets 2 InfoSphere CDC Windows InfoSphere CDC InfoSphere CDC UNIX Linux InfoSphere CDC e dmts32 I lt instance_name gt e dmts64 I lt instance_name gt Universal Cache InfoSphere CDC
60. 2 Safe solidDB Universal Cache m MWA CDC Universal Cache CDC dmstartmirror InfoSphere Change Data Capture Management Console Admin istration Guide Starting and ending replication on subscriptions CDC HA HotStandby HAC IBM solidDB solidDB HAC
61. IBM IBM Director of Licensing IBM Corporation North Castle Drive Armonk NY 10504 1785 U S A DBCS IBM IBM World Trade Asia Corporation Licensing 2 31 Roppongi 3 chome Minato ku Tokyo 106 0032 Japan INTERNA TIONAL BUSINESS MACHINES CORPORATION
62. L lt locale gt InfoSphere CDC 0 dmset I myinstance dmset I myinstance global_unicode_as_char false global _ unicode _as_char false dmset I myinstance global_unicode_as_char dmset I myinstance stop replication stop_replication dmshowversion InfoSphere CDC InfoSphere CDC IBM InfoSphere CDC dmshowversion L lt locale gt L lt locale gt InfoSphere CDC 0 dmshutdown InfoSphere CDC InfoSphere CDC
63. c max_msg HAE InfoSphere CDC InfoSphere CDC 0 2147483647 L lt locale gt InfoSphere CDC 0 dmshowevents I new_instance s Finance TT InfoSphere CDC Finance dmshowevents I myinstance a h InfoSphere CDC dmshowevents I newinstance s Finance t Atlanta s Marketing h c 20 dmshowevents I myinstance s Finance Marketing t Atlanta h c 20 InfoSphere CDC Finance Marketing Atlanta 20 EVENTTIME EVENTSOURCE ORIGINATOR EVENTID SEVERITY EVENTPROGRAM EVENTTEXT 2006 04 21 17 23 08 817 T ATLANTA 95 Information class com datamirror ts
64. solidDB Universal Cache f solidDB Universal Cache 1 H solidDB Universal Cache CDC CDC 1 IBM solidDB Universal Cache 5 BE solidDB CDC ODBC JDBC solidDB
65. InfoSphere CDC InfoSphere CDC Windows InfoSphere CDC Windows UNIX Linux InfoSphere CDC InfoSphere CDC InfoSphere CDC Windows 1 lt InfoSphere CDC Installation Directory gt bin dmconfigurets 2 InfoSphere CDC Windows InfoSphere CDC InfoSphere CDC UNIX Linux 1 2 InfoSphere CDC dmshutdown I lt instance_name gt I
66. 3 global memory_lob cache mb LOB LOB 2 mirror queue for buffers between _cdc threads operations ffin InfoSphere CDC W H RMH AE Jl UZ balas E Ba i 66 IBM solidDB Universal Cache 100 100 InfoSphere CDC mirror_end_ on error tue false true refresh_end_on_ error
67. Enter InfoSphere CDC InfoSphere CDC 11101 J Enter UDP Enter DISABLE InfoSphere CDC RAM 64 MB 512 MB RAM 32 1024 MB RAM 64 8 solidDB 1
68. 8 Enter 10 1 InfoSphere CDC InfoSphere CDC InfoSphere CDC InfoSphere CDC UNIX Linux 1 InfoSphere CDC 2 InfoSphere CDC 3 4 InfoSphere CDC lt setup bin gt r lt response file gt 5 lt setup bin gt i silent f lt response file gt e lt response file gt 9 InfoSphere CDC InfoSphere CDC InfoSphere CDC Windows InfoSphere CDC 22 IBM solidDB InfoSphere CDC InfoSphere CDC Universal
69. YYYY MM DD HH MM SS UUUUUU f InfoSphere CDC UUUUUU 0 Universal Cache b k d ws b lt gt a lt gt UPDATE source table set MYCOLUMN 2 where MYCOLUMN 1 2 MYCOLUMN SQL 1 MYCOLUMN b MYCOLUMN 1 UPDATE source_table set MYCOLUMN 2 where MYCOLUMN 1 2 MYCOLUMN SQL 1
70. TS_BOOKMARK TS_CONFAUD InfoSphere CDC InfoSphere CDC SQL TS_SQL_EXECAUTH InfoSphere CDC 32 InfoSphere CDC InfoSphere CDC IBM solidDB InfoSphere CDC shell InfoSphere CDC bin ik Enter dmterminate
71. t lt Schema gt lt table gt InfoSphere CDC schema table L lt locale gt InfoSphere CDC 0 dmreaddtable I new_instance A InfoSphere CDC dmreassigntable InfoSphere CDC RDBMS dmreassigntable I lt instance name gt s lt subscription names gt lt A t lt schema gt lt table gt gt L lt locale gt lt instance_name gt InfoSphere CDC TSINSTANCE Z EIE s lt subscription_names gt InfoSphere CDC A InfoSphere CDC t lt Schema gt lt table gt InfoS
72. IBM 69 70 IBM solidDB IBM Web Web Web IBM Web IBM G IBM Canada Limited Office of the Lab Director 8200 Warden Avenue Markham Ontario L6G 1C7 CANADA IBM IBM
73. length value value length NULL nul VARCHAR VARCHAR WINTRNC Y WA WINIMG length value value ERM length IMAGE NTEXT TEXT
74. tue false true 6 CDC for solidtDB 67 68 IBM solidDB Universal Cache P Copyright Solid Information Technology Ltd 1993 2008 All rights reserved Solid Information Technology Ltd International Business Machines Cor poration 6144941 7136912 6970876 7139775 6978396 7266702 a ECCN 5D992b IBM IBM IBM IBM IBM IBM IBM
75. v tmdecodebookmark L lt locale gt InfoSphere CDC 0 6 CDC for solidDB 37 38 IBM solidDB dmshowbookmark I myinstance s master InfoSphere CDC dmshowlogdependency InfoSphere CDC InfoSphere CDC
76. S lt Subscription_names gt A t lt Schema gt lt table gt schema table L lt locale gt InfoSphere CDC 0 dmsetreplicationmethod I myinstance r s Finance A Finance InfoSphere CDC dmsetreplicationmethod I new_instance m s Finance t acct taxcodes Finance acct taxcodes InfoSphere CDC InfoSphere CDC 6 CDC for solidDB 43 44 IBM solidDB dmclearevents dmclearevents I lt instance_name gt S T B lt A s lt subscription_names gt gt L lt locale gt
77. SQL 1 InfoSphere CDC InfoSphere CDC InfoSphere CDC InfoSphere CDC F InfoSphere CDC 2 SQL TS_SQL_EXECAUTH HR ul R N F InfoSphere CDC InfoSphere CDC 30 IBM solidDB gt H B InfoSphere CDC bigint binary blob char clob date decimal double precision float integer long varbinary long varchar nchar nclob numeric nvarchar real Smallint time timestamp tinyint varbinary
78. InfoSphere CDC KIRE a L lt locale gt InfoSphere CDC 0 dmsetbookmark I MYINSTANCE b 2FC5GJHKLKSJLKJL458K9K809IK9 s FINANCE InfoSphere CDC Finance dmshowbookmark dmshowbookmark I lt instance name gt s lt subscription name gt f v L lt locale gt lt instance_name gt InfoSphere CDC TSINSTANCE InfoSphere CDC S lt subscription_name gt f lt file_name gt
79. InfoSphere CDC InfoSphere CDC lt domain gt lt user name gt lt domain gt lt user name gt lt computer name gt lt user name gt Win dows InfoSphere CDC Windows Windows InfoSphere CDC TA 5
80. CDC solidDB CDC for solidDB 16 IBM solidDB solidDB CDC for solidDB 1 CDC 28 InfoSphere CDC j 2 InfoSphere Change Data Capture Management Console Admin istration Guide Starting and ending replication on subscriptions T solidDB LogReader MaxLogSize Universal Cache 1
81. IBM IBM IBM IBM IBM H IBM
82. Java JDK UserExitSample class lt InfoSphere CDC installation directory gt 1ib com datamirror ts target publication userexit sample 6 Jaz InfoSphere CDC 7 UserExitSample com datamirror ts target publication userexit sample UserExitSample Universal Cache ik class Java IBM InfoSphere CDC TS_CONFAUD AFTERIMG r
83. lt instance_name gt InfoSphere CDC TSINSTANCE eE S InfoSphere CDC T InfoSphere CDC S T B InfoSphere CDC B B InfoSphere CDC schema table A InfoSphere CDC s lt subscription_names gt InfoSphere CDC L lt locale gt InfoSphere CDC 0 dmclearevents I myinstance S A T s TI InfoSphere CDC dmclearevents I myinstance T s Finance Marketing qlig InfoSphere CDC Finance Marketing
84. Enter HA HotStandby 2 Enter 9 1 Enter 2 Enter 1964 Universal Cache HA HotStandby Enter Enter 1964 Enter E Enter 1964 E 2 ber 10 JDBC n Enter L A y
85. Enter 2 lt parameter gt lt value gt lt parameter gt lt value gt HA solid_tf_level CONNECTION 11 Enter 12 Enter 13 Enter HE 14 Enter solidDB InfoSphere CDC InfoSphere CDC F InfoSphere CDC y InfoSphere CDC UNIX Linux 1 InfoSphere CDC MAKHE 2
86. dmshutdown InfoSphere CDC dmshutdown InfoSphere CDC JZ EH dmterminate dmshutdown InfoSphere CDC dmterminate L lt locale gt L lt locale gt InfoSphere CDC 0 dmts32 InfoSphere CDC InfoSphere CDC 32 dmts32 I lt instance_name gt L lt locale gt lt instance_name gt InfoSphere CDC KM Universal Cache L lt locale gt InfoSphere CDC 0 dmts32 I I myinstance InfoSphere CDC dmts64 InfoSphere CDC InfoSphere CDC 64 dmts64 I lt instance name gt L lt locale gt lt instance_name gt InfoSphere CDC L lt locale gt
87. mirror _commit after max _ transactions 10 1 mirror_commit_ after _ max secomas 1 P 1 Universal Cache mirror commit after max_ operations
88. varchar Universal Cache A KEFF M 28 s 2538 M E Z VE 26 E IBM solidDB SQL bigint LOB binary LOB blob LOB char CLOB LOB clob CLOB LOB date decimal LOB double precision LOB float LOB integer LOB long varbinary LOB long varchar CLOB LOB nchar CLOB LOB
89. 1 2 tz 3 4 6 CDC for solidDB 59 60 IBM solidDB RESMTD 1 Q A OO N InfoSphere CDC CNFRES Y e N BEFOREIMG 1 9 BEFORETRNC BEFOREIMG Y N AFTERIMG AFTERTRNC
90. InfoSphere CDC 0 dmts64 I myinstance InfoSphere CDC InfoSphere CDC InfoSphere CDC Java B InfoSphere CDC Javadoc API InfoSphere CDC Java Javadoc API lt system drive gt lt installation direc tory gt docs api index html InfoSphere CDC
91. false Unicode Unicode InfoSphere CDC W false InfoSphere CDC InfoSphere CDC Java 512 MB mirror memory_txqueue total mb RARE 15 KF mirror memory_txqueue each_mb W
92. solidDB IBMS InfoSphere TM Change Data Capture solidDB solidDB Universal Cache solidDB Universal Cache InfoSphere CDC for solidDB solidDB Uni versal Cache InfoSphere Change Data Capture DBMS SQL solidDB solidDB 7 NOT NULL SQL solid ini SET SYNC MASTER YES COMMIT WORK SQL run sh TRIG_COUNTO
93. Setting conflict detection and resolution 10 InfoSphere Change Data Capture Management Con sole Administration Guide Starting and ending replication on subscriptions Ho He 14 IBM solidDB Universal Cache 4 solidDB Universal Cache CDC solidDB solidDB 1 solidDB IBM solidDB solidDB 1 T CDC 28 InfoSphere CDC 3 2 ml InfoSphere Change Data Capture Management Console Admin istration Guide Startin
94. CDC for solidDB JDBC solidDB CDC solidDB CDC APL CDC CDC CDC CDC for solidDB CDC HA HotStandby CDC solidDB solidDB Universal Cache HAZ solidDB CDC CDC 1 IBM solidDB Universal Cache 3 solidDB SolidDB
95. InfoSphere CDC InfoSphere CDC dmterminate 6 CDC for solidDB 49 50 IBM solidDB dmshutdown I lt instance_name gt L lt locale gt lt instance_name gt InfoSphere CDC TSINSTANCE L lt locale gt InfoSphere CDC 0 dmterminate InfoSphere CDC JE Windows a UNIX Linux InfoSphere CDC InfoSphere CDC UNIX si s nin E InfoSphere CDC
96. fk dmgetsubscriptionstatus dmgetsubscriptionstatus I lt instance_name gt p lt A s lt subscription_name gt gt L lt locale gt Universal Cache lt instance_name gt InfoSphere CDC TSINSTANCE FF EIE p InfoSphere CDC A InfoSphere CDC S lt subscription_name gt L lt locale gt InfoSphere CDC 0 1 ME dmgetsubscriptionstatus I myinstance p A InfoSphere CDC dmshowevents InfoSphere CDC
97. gt L lt locale gt lt instance_name gt InfoSphere CDC TSINSTANCE a InfoSphere CDC f InfoSphere CDC a f InfoSphere CDC f A InfoSphere CDC s lt subscription_names gt InfoSphere CDC H L lt locale gt InfoSphere CDC 0 dmrefresh I new_instance a s Finance E InfoSphere CDC Finance Universal Cache dmstartmirror
98. solidDB solidDB CDC for solidDB CDC GUI CDC CDC GUI CDC
99. Data Capture InfoSphere CDC CDC InfoSphere CDC InfoSphere CDC InfoSphere CDC InfoSphere CDC Windows UNIX Linux InfoSphere CDC InfoSphere CDC Windows InfoSphere CDC InfoSphere CDC InfoSphere CDC 6
100. target publication c Transformation Server Communications ending 2006 04 21 17 23 08 614 T ATLANTA 1538 Information class com datamirror ts target publication c Transformation Server for ATLANTA terminating normally 2006 04 21 17 23 08 333 T ATLANTA 1537 Information class com datamirror ts target publication c Describe conversation with ATLANTA completed successfully 2006 04 21 17 23 07 911 T ATLANTA 1536 Information class com datamirror ts target publication c Describe conversation started by ATLANTA 2006 04 21 17 23 07 333 T ATLANTA 1531 Information class com datamirror ts target publication c Communication with ATLANTA successfully started on Data channel 2006 04 21 17 23 06 973 T ATLANTA 1534 Information class com datamirror ts engine a Code page conversation from the source database s code page 1252 to the target database s code page Cp1252 for ATLANTA will be performed by the Remote system 1 EVENTSOURCE FUF S 7 Universal Cache InfoSphere CDC dmexportconfiguration InfoSphere CDC InfoSphere CDC
101. Cache InfoSphere CDC Windows InfoSphere CDC InfoSphere CDC InfoSphere CDC Windows InfoSphere CDC 3 1 3 lt InfoSphere CDC Installation Directory gt bin dmconfigurets 2 3 IBM InfoSphere CDC EE InfoSphere CDC InfoSphere CDC TCP IP InfoSphere CDC
102. IBM solidDB IBM solidDB Universal Cache V6 3 IBM solidDB Universal Cache I du EE software S151 1149 00 IBM solidDB IBM solidDB Universal Cache V6 3 IBM solidDB Universal Cache nnn ETEC GE software S151 1149 00 69 PRA Solid Information Technology Ltd 1993 2008 HF IBM solidDB 5724 V17 IBM solidDB Universal Cache J Ph H Z HH WE 5724 W91 V6R3 R 1 IBM solidDB Universal Cache solidDB Universal Cache Universal Cache CDC 2 solidDB Universal Cache 3 solidDB Universal Cache solidDB solidDB CDC 4 solidDB Universal Cache solidDB CDC E LLL HF o
103. Sphere CDC InfoSphere CDC InfoSphere CDC InfoSphere CDC InfoSphere CDC global shutdown_after_no_heartbeat response minutes 15 3 999 InfoSphere CDC global conversion not possible warning 6 CDC for solidtDB 63 64 IBM solidDB InfoSphere CDC
104. XML InfoSphere CDC ik InfoSphere CDC dmimportconfiguration lt path to _configuration file gt L lt locale gt lt path_to_configuration file gt XML InfoSphere CDC L lt locale gt InfoSphere CDC 6 CDC for solidDB 47 48 0 dmimportconfiguration c configurations configuration xml InfoSphere CDC XML IBM solidDB InfoSphere CDC InfoSphere CDC UNIX dmbackupmd InfoSphere CDC instance lt instance_name gt conf backup
105. ame gt s lt subscription_name gt b 1 f t a L lt locale gt lt instance_name gt InfoSphere CDC TSINSTANCE InfoSphere CDC s lt subscription_name gt InfoSphere CDC b lt bookmark gt InfoSphere CDC InfoSphere CDC dmshowbookmark lt bookmark gt dmdecodebookmark 35 dmdecodebookmark 1 f lt bookmark file gt InfoSphere Universal Cache CDC InfoSphere CDC t lt datetime gt
106. e Data Cap ture Management Console Administration Guide To set connection param eters on a datastore H solidDB a Management Console Admin istration Guide Managing user accounts b Management Con sole Administration Guide Assigning users to datastores c D gt gt 2 gt gt T InfoSphere Change Data Capture Management Con sole Administration Guide Setting connection preferences f a solidDB b
107. ere CDC Installation Directory gt bin dmconfigurets 3 4 5 InfoSphere CDC UNIX Linux InfoSphere CDC InfoSphere CDC InfoSphere CDC InfoSphere CDC UNIX Linux InfoSphere CDC InfoSphere CDC 6 CDC for solidDB 25 26 IBM solidDB InfoSphere CDC UNIX Linux InfoSphere CDC 4 S s n a lt InfoSphere CDC Installation Directory gt bin dmconfigurets Enter 2 Enter InfoSphere CDC InfoSphere CDC
108. g and ending replication on subscriptions fi CDC CDC 1 CDC 28 InfoSphere CDC 2 InfoSphere Change Data Capture Management Console Admin istration Guide Starting and ending replication on subscriptions fT solidDB LogReader MaxLogSize 15 HA HotStandby solidDB solidDB HotStandby solidDB solidDB HAC solidDB
109. idDB Universal Cache 7 1 2 3 4 CDC CDC CDC CDC JDBC CDC 8 IBM solidDB Universal Cache 2 solidDB Universal Cache solidDB Universal Cache solidDB CDC
110. ion_name gt InfoSphere CDC t A v L lt locale gt InfoSphere CDC 0 dmshowlogdependency I MyInstance Universal Cache InfoSphere CDC dmdescribe dmdescribe I lt instance_name gt lt A s lt subscription_names gt gt L lt locale gt lt instance_name gt InfoSphere CDC TSINSTANCE A InfoSphere CDC
111. me gt InfoSphere CDC Linux EXPORT TSINSTANCE lt instance_name gt e lt instance_name gt InfoSphere CDC InfoSphere CDC dmendreplication dmendreplication I lt instance name gt c i lt A s lt subscription names gt gt L lt locale gt lt instance_name gt InfoSphere CDC TSINSTANCE C InfoSphere CDC InfoSphere CDC c i InfoSphere CDC c i InfoSphere CDC InfoSphere CDC A InfoSphere CDC s lt subscription_names gt InfoSphere CDC
112. nclob CLOB LOB nvarchar CLOB LOB numeric LOB real LOB smallint LOB tim timestamp tinyint LOB varbinary LOB varchar CLOB LOB InfoSphere CDC InfoSphere CDC InfoSphere CDC TS_AUTH IBM 6 CDC for solidDB 31 TS_AUTH GRANT SELECT
113. nfoSphere CDC Linux InfoSphere CDC InfoSphere CDC dmterminate I lt instance_name gt Linux InfoSphere CDC dmshutdown InfoSphere CDC SQL InfoSphere CDC SQL SQL SQL InfoSphere CDC InfoSphere CDC TS_SQL_EXECAUTH InfoSphere CDC SQL SQL fE 6 CDC for solidDB 29
114. phere CDC schema table L lt locale gt InfoSphere CDC 0 42 IBM solidDB Universal Cache dmreassigntable I new_instance s Finance A InfoSphere CDC Finance dmsetreplicationmethod InfoSphere CDC dmsetreplicationmethod I lt instance name gt lt r m gt s lt subscription_names gt lt A t lt schema gt lt table gt gt L lt locale gt lt instance_name gt InfoSphere CDC TSINSTANCE AE JAB m Change Data Capture r
115. s target publication userexit sample UserExitSample ik class Java IBM UNIX Linux 1 2 InfoSphere CDC samples jar InfoSphere CDC 1ib jar jar lt InfoSphere CDC installation directory gt 1ib com datamirror ts target publication userexit sample UserExitSample java 1ib javac classpath ts jar com datamirror ts target publication userexit sample UserExitSample java
116. sal Cache 5 solidDB Universal Cache 9 2 r solidDB Universal Cache 1 11 3 solidDB Universal Cache 1 solidDB Universal Cache soli dDB e CDC for soli dDB CDC CDC for solidDB CDC CDC 11 solidpB AGE 12 1 CDC
117. x gt lt value gt lt x gt lt value gt 52 IBM solidDB Universal Cache s PRANA s entry NUMBER 1 InfoSphere CDC 2 InfoSphere CDC 3 InfoSphere CDC 4 InfoSphere CDC 5 InfoSphere CDC 6 InfoSphere CDC 7 InfoSphere CDC 8 InfoSphere CDC 9 InfoSphere CDC
Download Pdf Manuals
Related Search
IBM solidDB Universal Cache V6.3 user manual