DB2 Replication Guide and Reference
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
A
B
bandwidth impact, network requirements
(3870)
base aggregate target tables
CREATE TABLE statement
(5145)
defining
(4230)
description
(3656), (3903), (5142)
before-image columns
and change aggregate tables
(4257)
data transformation
(3936), (3965)
description
(4146)
NULL value
(4150)
partitioned key support values
(4177)
restrictions
(4044)
specifying
(4171)
usage
(4149)
binary data types
(4040)
binding non-DB2 Universal Database RDBMs
(4142)
binding the package
Apply for OS/2
(4512), (4974)
Apply for UNIX
(4644)
Apply for Windows NT and Windows 95
(4410)
Capture for OS/2
(4509)
Capture for UNIX
(4635)
Capture for Windows NT and Windows 95
(3753), (4407)
Windows NT and Windows 95 for the mobile client
(4971)
blobs (binary large objects)
(4034)
blocking factor for subscription cycle, defining
(4272)
BUILDDB command
(5035)
building audit trails scenario
(3783)
C
CALL procedures
defining for the replication subscription
(4273)
run-time processing statements
(3945)
capacity requirements
Apply program
(3853)
Capture program
(3850)
Control Center
(3857)
planning
(3845)
Capture enqueue tables
CREATE TABLE statement
(5065)
description
(5063)
Capture program
alert generation (MVS)
(4318)
authorization requirements
(3883)
bandwidth impact
(3867)
capacity requirements
(3849)
Capture user ID
(3884)
capturing changes
(3682)
configuring, overview
(3752)
connectivity requirements
(3861)
control tables
(3689)
dropping V1 tables
(5052)
error recovery
(5200)
Capture for MVS
(4315)
Capture for VM
(4904)
Capture for VSE
(4846)
errors
(5208)
for AIX
authorization for running
(4671)
binding the package
(4631)
cold start parameter
(4697)
cold start, automatic
(4755)
cold start, preventing
(4761)
configuring
(4623), (4683)
log sequence number, providing
(4735)
operating
(4597), (4675)
performance options
(4652)
post-installation tasks
(4679)
preparing for roll-forward recovery
(4627)
pruning
(4730)
reinitializing
(4725)
restrictions
(4667)
resuming
(4720)
scheduling when to start
(4703)
setting up
(4615)
starting
(4687)
stopping
(4708)
suspending
(4715)
troubleshooting information
(4815)
tuning parameters
(4653)
using
(4598)
warm start parameter
(4693), (4741)
warm start, forcing
(4765)
for HP-UX
authorization for running
(4672)
binding the package
(4632)
cold start parameter
(4698)
cold start, automatic
(4756)
cold start, preventing
(4762)
configuring
(4624), (4684)
log sequence number, providing
(4736)
operating
(4601), (4676)
performance options
(4654)
post-installation tasks
(4680)
preparing for roll-forward recovery
(4628)
pruning
(4732)
reinitializing
(4727)
restrictions
(4668)
resuming
(4722)
scheduling when to start
(4705)
setting up
(4617)
starting
(4688)
stopping
(4710)
suspending
(4717)
troubleshooting information
(4816)
tuning parameters
(4655)
using
(4602)
warm start parameter
(4694), (4742)
warm start, forcing
(4766)
for MVS
authorization for running
(4314)
cold start parameter
(4332)
cold start, automatic
(4357)
cold start, preventing
(4360)
configuring
(4328)
DB2 for MVS 3.1, active log size
(3840)
error recovery
(4317)
in a data-sharing environment
(3680)
log sequence number, providing
(4349)
operating
(4294), (4326)
performance options
(4303)
post-installation tasks
(4327)
pruning
(4347)
reinitializing
(4345)
restrictions
(4312)
resuming
(4343)
scheduling when to start
(4335)
setting up
(4299)
starting
(4329)
stopping
(4337)
suspending
(4341)
troubleshooting information
(4385)
tuning parameters
(4304)
unsupported statements
(4313)
using
(4295)
warm start parameter
(4331), (4352)
warm start, forcing
(4361)
for OS/2
authorization for running
(4524)
binding the package
(4508)
cold start parameter
(4532)
cold start, automatic
(4557)
cold start, preventing
(4560)
configuring
(4506), (4527)
log sequence number, providing
(4549)
operating
(4499), (4525)
performance options
(4514)
post-installation tasks
(4526)
preparing for roll-forward recovery
(4507)
pruning
(4547)
reinitializing
(4545)
restrictions
(4523)
resuming
(4543)
scheduling when to start
(4535)
setting up
(4504)
starting
(4528)
stopping
(4537)
suspending
(4541)
troubleshooting information
(4589)
tuning parameters
(4515)
using
(4500)
warm start parameter
(4531), (4552)
warm start, forcing
(4561)
for Solaris
authorization for running
(4673)
binding the package
(4633)
cold start parameter
(4699)
cold start, automatic
(4757)
cold start, preventing
(4763)
configuring
(4625), (4685)
log sequence number, providing
(4737)
operating
(4605), (4677)
performance options
(4656)
post-installation tasks
(4681)
preparing for roll-forward recovery
(4629)
pruning
(4733)
reinitializing
(4728)
restrictions
(4669)
resuming
(4723)
scheduling when to start
(4706)
setting up
(4619)
starting
(4689)
stopping
(4711)
suspending
(4718)
troubleshooting information
(4817)
tuning parameters
(4657)
using
(4606)
warm start parameter
(4695), (4743)
warm start, forcing
(4767)
for UnixWare 7
authorization for running
(4674)
binding the package
(4634)
cold start parameter
(4700)
cold start, automatic
(4758)
cold start, preventing
(4764)
configuring
(4626), (4686)
log sequence number, providing
(4738)
operating
(4609), (4678)
performance options
(4658)
post-installation tasks
(4682)
preparing for roll-forward recovery
(4630)
pruning
(4734)
reinitializing
(4729)
restrictions
(4670)
resuming
(4724)
scheduling when to start
(4707)
setting up
(4621)
starting
(4690)
stopping
(4712)
suspending
(4719)
troubleshooting information
(4818)
tuning parameters
(4659)
using
(4610)
warm start parameter
(4696), (4744)
warm start, forcing
(4768)
for VM
active log size
(3842)
authorization for running
(4903)
cold start parameter
(4919)
cold start, automatic
(4939)
cold start, preventing
(4941)
configuring
(4915)
error recovery
(4906)
log sequence number, providing
(4934)
operating
(4887), (4913)
performance options
(4893)
post-installation tasks
(4914)
pruning
(4932)
reinitializing
(4930)
restrictions
(4902)
resuming
(4928)
setting up
(4890)
starting
(4916)
stopping
(4922)
suspending
(4926)
troubleshooting information
(4944)
tuning parameters
(4894)
using
(4888)
warm start parameter
(4918), (4937)
warm start, forcing
(4943)
for VSE
active log size
(3841)
authorization for running
(4845)
cold start parameter
(4861)
cold start, automatic
(4881)
cold start, preventing
(4883)
configuring
(4857)
error recovery
(4848)
log sequence number, providing
(4876)
operating
(4829), (4855)
performance options
(4835)
post-installation tasks
(4856)
pruning
(4874)
reinitializing
(4872)
restrictions
(4844)
resuming
(4870)
setting up
(4832)
starting
(4858)
stopping
(4864)
suspending
(4868)
troubleshooting information
(4885)
tuning parameters
(4836)
using
(4830)
warm start
(4879)
warm start parameter
(4860)
for Windows NT and Windows 95
authorization for running
(4426)
binding the package
(4406)
cold start parameter
(4434)
cold start, automatic
(4459)
cold start, preventing
(4462)
configuring
(4404), (4429)
log sequence number, providing
(4451)
operating
(4397), (4427)
performance options
(4416)
post-installation tasks
(4428)
preparing for roll-forward recovery
(4405)
pruning
(4449)
reinitializing
(4447)
restrictions
(4425)
resuming
(4445)
scheduling when to start
(4437)
setting up
(4402)
starting
(3760), (4430)
stopping
(3764), (4439)
suspending
(4443)
troubleshooting information
(4491)
tuning parameters
(4417)
using
(4398)
warm start parameter
(4433), (4454)
warm start, forcing
(4463)
gap detection
(4126)
identifying external data sources
(4001)
introduction
(3679)
log file
(5213)
messages
(5221)
migrating
(5039)
minimizing contention
(4118)
naming conventions
(3592)
problem determination
(5209)
processor requirements
(3848)
pruning CCD tables
(3978)
sample JCL
(5229)
Service Control Manager
(4412)
staging data
(3974)
stopping with a trigger (MVS)
(4339)
stopping with a trigger (OS/2)
(4539)
stopping with a trigger (UNIX)
(4713)
stopping with a trigger (VM)
(4924)
stopping with a trigger (VSE)
(4866)
stopping with a trigger (Windows NT and Windows 95)
(4441)
storage dump (MVS)
(4324)
storage dump (VM)
(4911)
storage dump (VSE)
(4853)
trace buffer (MVS)
(4320)
trace buffer (VM)
(4907)
trace buffer (VSE)
(4849)
trace file
(5211)
trace output (MVS)
(4322)
trace output (VM)
(4909)
trace output (VSE)
(4851)
usage
(3684)
capturing changes, overview
(3685)
CCD (consistent change data) tables
auto-registration
(3673), (3998)
condensed, complete
(3663)
condensed, noncomplete
(3661)
CREATE TABLE statement
(5159)
data warehouse
(4016)
defining
(4232)
description
(3660), (3667), (3907), (3979), (5152)
external data sources
(4002), (4191)
external, refreshing
(4010)
internal
(3993), (4005)
local
(3994)
noncondensed, complete
(3668)
noncondensed, noncomplete
(3665)
remote
(3995)
restrictions
(4107)
staging changed data
(3976)
updating condensed copies
(5154)
CD (change data) tables
and consistent change data
(3975)
and the Capture program
(3683)
CREATE TABLE statement
(5071)
description
(3705), (3980), (5067)
pruning
(5069)
change aggregate target tables
CREATE TABLE statement
(5150)
defining
(4231)
description
(3658), (3905), (5147)
changed data retention, planning
(3972)
changing
replication sources
(4197)
replication subscriptions
(4287)
classes, education
(3634)
CLEANUP command
(5051)
CLOBs (character large objects)
(4035)
cloning subscriptions
(4285)
cold start
Capture for MVS
(4334)
Capture for OS/2
(4534)
Capture for UNIX
(4702)
Capture for VM
(4921)
Capture for VSE
(4863)
Capture for Windows NT and Windows 95
(4436)
gaps
(4128)
low lag limit
Capture for MVS
(4308)
Capture for OS/2
(4519)
Capture for UNIX
(4663)
Capture for VM
(4898)
Capture for VSE
(4840)
Capture for Windows NT and Windows 95
(4421)
preventing
Capture for MVS
(4358)
Capture for OS/2
(4558)
Capture for UNIX
(4759)
Capture for VM
(4940)
Capture for VSE
(4882)
Capture for Windows NT and Windows 95
(4460)
switching to automatically
Capture for MVS
(4356)
Capture for OS/2
(4556)
Capture for UNIX
(4754)
Capture for VM
(4938)
Capture for VSE
(4880)
Capture for Windows NT and Windows 95
(4458)
columns
before-image and after-image
(3937), (4148)
changing the definition
(4244)
computed
data transformation
(3941)
defining
(4247)
creating new in target table
(4248)
defining in target table
(4239)
fragmenting
(3916)
removing from target table
(4246)
renaming
data transformation
(3939)
defining
(4243)
restrictions on names
(4045)
specifying the primary key
(4242)
subsetting
(3915), (4240)
commit interval
Capture for MVS
(4310)
Capture for OS/2
(4521)
Capture for UNIX
(4665)
Capture for VM
(4900)
Capture for VSE
(4842)
Capture for Windows NT and Windows 95
(4423)
complete
CCD tables
(3717)
data attribute
(3718)
condensed
CCD tables
(3986), (5157)
copies, updating
(5156)
staging tables
(3985)
configuring
Apply program
(3751)
Capture program
(3750)
client for mobile replication
(4968)
connectivity requirements
(3865)
Control Center for non-DB2 Universal Database RDBMs
(4140)
conflict detection
data integrity
(4083)
description
(4089)
levels
(4091)
lost or rejected transactions
(4088)
planning
(4082)
specifying
(4182)
conflict tables, description
(5014), (5176)
conflicts
lost or rejected transactions
(4098)
recovering from
(4097)
consulting and services
(3624)
contention between the Capture and Apply programs
locking
(4123)
no ISOLATION (UR) support
(4117)
continuous timing
planning
(4053)
setting for the subscription
(4268)
Control Center
authorization requirements
(3881)
bandwidth impact
(3869)
capacity requirements
(3856)
configuring for non-DB2 Universal Database RDBMs
(4139)
connectivity requirements
(3863)
control tables created by
(3675)
introduction
(3639)
objects
(3648)
processor requirements
(3855)
replication objects
(4138)
setting preferences
(4143)
control server
choosing location
(3722)
defining for mobile replication
(4975)
Microsoft Jet
(4990)
specifying
(4219)
control tables
Apply trail
(3725), (5107)
at the control server
(5106)
at the source server
(5061)
at the target server
(5140)
base aggregate target
(5141)
Capture enqueue
(5062)
CCD target
(5151)
CD
(3704), (5066)
change aggregate
(5146)
conflict
(5013), (5175)
created by Control Center
(3676)
critical section
(3692), (5072)
customizing control file
(4152)
DataPropagator for Microsoft Jet
(5008)
error information
(5015), (5177)
error messages
(5017), (5181)
error side information
(5019), (5185)
estimating storage requirements
(3823)
key string
(5021), (5189)
migration
(5054)
planning for customization
(3890)
point-in-time target
(5160)
pruning control
(3700), (5076)
quick reference
at a glance
(5245)
control server
(5058)
source server
(5057)
target server
(5060)
register
(3690), (5080)
replica target
(5165)
row-replica target list
(5009), (5136)
subscription columns
(3735), (5111)
subscription events
(3731), (5115)
subscription schema changes
(5011), (5132)
subscription set
(3727), (5120)
subscription statements
(3729), (5124)
subscription targets member
(3733), (5128)
synchronization generations
(5023), (5193)
trace
(3696), (5084)
tuning parameters
(3694), (5088)
UOW
(3698), (5092)
used by Apply program
(3723)
used by Capture program
(3688)
user copy target
(5170)
warm start
(3702), (5098)
warm start for VSE and VM
(5102)
conventions
highlighting
(3587)
naming
(3590)
copies
loading large
(4381), (4487), (4585), (4811)
point in time
(4382), (4488), (4586), (4812)
types of refresh
(3741)
copy table types
(3650)
correcting a gap
(4133)
CREATE TABLE statement
Apply trail tables
(5109)
base aggregate target tables
(5144)
Capture enqueue tables
(5064)
CCD tables
(5158)
CD tables
(5070)
change aggregate target tables
(5149)
critical section tables
(5074)
error information tables
(5179)
error messages tables
(5183)
error side information tables
(5187)
key string tables
(5191)
point-in-time target tables
(5163)
pruning control tables
(5078)
register tables
(5082)
replica target tables
(5168)
row-replica target list tables
(5138)
subscription columns tables
(5113)
subscription events tables
(5118)
subscription schema changes tables
(5134)
subscription set tables
(5122)
subscription statements tables
(5126)
subscription targets member tables
(5130)
synchronization generations tables
(5195)
trace tables
(5086)
tuning parameters tables
(5090)
UOW tables
(5096)
user copy target tables
(5173)
warm start tables
(5100)
warm start tables for Capture for VSE and VM
(5104)
critical section tables
CREATE TABLE statement
(5075)
description
(3693), (5073)
custom, defining replication sources
(4164)
customizing
control tables
(4151)
planning requirements
(3889)
SQL files
(4153)
D
data archive scenario
(3781)
data blocking
(3829)
DATA CAPTURE CHANGES
(3819)
data capture, specifying
(4166)
data compression restriction
(4027)
data consistency
planning
(4073)
requirements
(4074), (4075)
data consolidation
and distribution scenario
(3777)
data transformation
(3953)
data currency
effect on CPU usage
(3854)
planning
(4047)
requirements
(4048)
data encryption restrictions
(4031)
data enhancements
before-image columns
(3935)
column renaming
(3938)
column subsetting
(3911)
computed columns
(3940)
data consolidation
(3952)
for replication targets
(3895)
noncondensed CCD tables
(3906)
outer join of source tables
(3954)
point-in-time target tables
(3899)
poorly structured data
(3961)
row subsetting
(3923)
run-time processing
(3942)
triggers
(3949)
updateable replica target tables
(3909)
user copy target tables
(3897)
data integrity
DataPropagator for Microsoft Jet
(4987)
resolving gaps
(4129)
data replication solution
(3597)
data sharing
and Capture for MVS
(3681)
data transformation requirements
(4022)
data transformation
advanced transformation
(3951)
auditing requirements
(3963)
basic enhancements
(3896)
condensed CCD tables
(3908)
data restrictions
(4025)
data sharing considerations
(4021)
Extended Enterprise Edition considerations
(4023)
mobile replication
(3968)
planning
(3893)
replication logical partitioning key
(4017)
data types, restrictions
(4032)
data warehouse
(4014)
DataPropagator for Microsoft Jet
control tables
(5007)
operating
(4996)
overview
(4986)
starting
(4997)
stopping
(5000)
troubleshooting
(5003)
DataPropagator NonRelational
(3610)
DB2
ARCHIVE LOG command
(4390)
control intervals
(4388)
log
(3686), (4387)
DB2 DataJoiner
for legacy data
(3608)
for multivendor replication
(3614)
DB2 library
books
(5235)
Information Center
(5244)
language identifier for books
(5236)
late breaking information
(5237)
online help
(5234)
ordering printed books
(5243)
printing PostScript books
(5242)
searching online books
(5241)
setting up document server
(5239)
SmartGuides
(5233)
structure of
(5232)
viewing online books
(5238)
DB2 Tools Settings notebook
(4144)
DB2INSTANCE
when starting Capture for OS/2
(4530)
when starting Capture for UNIX
(4692)
when starting Capture for Windows NT and Windows 95
(4432)
DBCLOBS (double-byte character large objects)
(4036)
deactivating and activating subscriptions
(4283)
decision support system scenario
(3771)
deferring replication requests
(4185), (4217)
defining
external CCD tables as sources
(4189)
replication source joins
(4193)
replication sources
example
(3746)
steps
(4162), (4165)
subscriptions
advanced steps
(4225)
basic steps
(4203)
example
(3748)
Design Master
(4991)
detecting a gap
(4125)
diagnosing errors
(5199)
differential refresh
(3740)
distinct data type
(4042)
distributed database system scenario
(3773)
dropping V1 tables
(5049)
dummy WHERE clause
(4258)
E
EDITPROCs
(4028), (4037)
education
custom classes
(3631)
IBM Global Campus URL
(3632)
enhanced conflict detection
(4094)
enhancements, IBM Replication
(5247)
enhancing data, planning
(3894)
environment variables
ASNDIAL
description
(4957)
specifying for OS/2
(4961)
specifying for Windows 95
(4965)
specifying for Windows NT
(4963)
ASNHANGUP
description
(4958)
specifying for OS/2
(4962)
specifying for Windows 95
(4966)
specifying for Windows NT
(4964)
error information tables
CREATE TABLE statement
(5180)
description
(5016), (5178)
error messages tables
CREATE TABLE statement
(5184)
description
(5018), (5182)
error recovery
Capture for MVS
(4316)
Capture for VM
(4905)
Capture for VSE
(4847)
error side information tables
CREATE TABLE statement
(5188)
description
(5020), (5186)
errors, diagnosing
(5198)
event table
Apply for MVS
(4373)
Apply for OS/2
(4574)
Apply for UNIX
(4800)
Apply for Windows NT and Windows 95
(4476)
description
(5117)
populating
(4064), (4222)
event-based timing
description
(4069)
planning
(4070)
setting for the subscription
(4269)
examples
sample JCL
(5227)
SQL for columns
(4245)
WHERE clauses
(4263)
Extended Enterprise Edition, data transformation requirements
(4024)
extending IBM Replication scenario
(3797)
external CCD tables
defining as sources
(4190)
description
(4003)
maintaining
(4079)
refreshing
(4011)
external data sources
(3999)
F
FALLBACK command
(5045), (5047)
fast path
(3594)
FIELDPROCs
(4029), (4038)
flat file data
(3611)
forward recovery
Apply for MVS
(4376)
Apply for OS/2
(4580)
Apply for UNIX
(4806)
Apply for Windows NT and Windows 95
(4482)
fragmentation
horizontal
(3927)
vertical
(3921)
fragmenting target tables
(3913)
full refresh
description
(3739)
forcing
Apply for MVS
(4396)
Apply for OS/2
(4596)
Apply for UNIX
(4828)
Apply for Windows NT and Windows 95
(4498)
specifying
(4168)
suppressing
Apply for MVS
(4393)
Apply for OS/2
(4593)
Apply for UNIX
(4825)
Apply for Windows NT and Windows 95
(4495)
G
gap detection
description
(4124)
resolving
(4132)
verifying
(4130)
gap messages
for MVS
(4353)
for OS/2
(4553)
for UNIX
(4745)
for Windows NT and Windows 95
(4455)
global lock
(4122)
GROUP BY clause
(4255)
H
hardware requirements
(3811), (4953)
highlighting conventions
(3588)
history data
(3966)
horizontal subsetting
description
(3926)
steps
(4253)
hot-site recovery, description
(3803)
I
IBM Education resources
custom classes
(3629)
IBM Global Campus URL
(3630)
IBM Replication
education
(3633)
enhancements
(5246)
introduction
(3602)
messages
(5217)
planning
(3766)
services and consulting
(3625)
tools
(3599), (3635)
identifiers, ordinary and delimited
(4156)
identifying external data sources
(4000)
improved application availability scenario
(3779)
improved network load scenario
(3775)
IMS and VSAM data
(3613)
installation
Capture and Apply for MVS
(4301)
Capture for VM
(4891)
Capture for VSE
(4833)
considerations for UNIX components
(4645)
independent migration
(5029)
services and consulting
(3628)
internal CCD tables
auto-registration
(3997)
description
(3990)
reducing network load
(4004)
interval timing, planning
(4061)
introduction to IBM Replication
Apply program
(3706)
Capture program
(3677)
Control Center
(3637)
overview
(3603)
ISOLATION (UR)
contention problems
(4116)
platforms that don't support
(4115)
J
JCL, sample
(5231)
joins
defining as sources
(4194)
description
(3933), (3959)
K
key string tables
CREATE TABLE statement
(5192)
description
(5022), (5190)
L
lag limit
Capture for MVS
(4309)
Capture for OS/2
(4520)
Capture for UNIX
(4664)
Capture for VM
(4899)
Capture for VSE
(4841)
Capture for Windows NT and Windows 95
(4422)
large copies, loading
(4380), (4486), (4584), (4810)
large replication jobs
(3831)
legacy data sources
(3609)
loading large copies
(4379), (4485), (4583), (4809)
local CCD tables
(3992)
locking, how it affects contention
(4121)
log file
Apply program
(5207)
Capture program
(5214)
log records
archived before captured
(3838)
determining the size
(3839)
log sequence number
Capture for MVS
(4350)
Capture for OS/2
(4550)
Capture for UNIX
(4739)
Capture for VM
(4935)
Capture for VSE
(4877)
Capture for Windows NT and Windows 95
(4452)
logging requirements, DBMS logging
(3818)
logical partitioning key support
description
(4019)
specifying
(4174)
logical recovery scenario
(3795)
LONG VARGRAPHIC data type
(4041)
lost transactions
(4104)
Lotus Notes Pump
(3621)
LU sessions
(4647)
M
MAX_SYNCH_MINUTES, description
(3830)
messages
Apply program
(5223)
Capture program
(5219), (5222)
migration
(5225)
Microsoft Jet
(4983)
MIGRATE command
(5040), (5043)
migration
analysis
(5027)
analyzing data
(5036)
building
(5033)
collection
(5026), (5034)
control tables
(5053)
deleting unused tables and views
(5048)
falling back to Version 1
Apply program
(5044)
Capture program
(5046)
messages
(5226)
migrating data
Apply program
(5041)
Capture program
(5038)
prerequisites
(5028)
process
(5025)
services and consulting
(3627)
starting
(5031)
mini-cycles
Apply program
(3834)
defining for the subscription
(4271)
minimizing contention
(4120)
mobile replication
configuring
client
(4967)
control server
(4976)
data transformation requirements
(3969)
environment variables
(4956)
for OS/2
binding the package
(4973)
configuring
(4972)
for Windows NT and Windows 95
binding the package
(4970)
configuring
(4969)
Microsoft Jet
(4985)
overview
(4946)
planning
(4950)
processing cycle
(4977)
restrictions
(4948)
scenario
(3786)
mobile replication enabler
starting from the command line
(4978)
starting from the graphical interface
(4980)
MS Jet
mobile replication scenario
(3788)
replication
(4984)
multivendor data
(3618)
N
network requirements
bandwidth impact
(3866)
connectivity
(3860), (3864)
planning
(3859)
throughput capacity
(3875)
no conflict detection
(4092)
non-DB2 data
(3619)
non-DB2 Universal Database RDBMs, configuring the Control Center
(4141)
O
ODBC-accessible data
(3622)
on-demand replication, data transformation
(3970)
ordinary and delimited identifiers
(4155)
outer join of source tables
(3955)
P
parameter definitions
Apply for MVS
(4365)
Apply for OS/2
(4565)
Apply for UNIX
(4778)
Apply for Windows NT and Windows 95
(4467)
password files, authorization requirements
(3887)
performance options
Capture for MVS
(4302)
Capture for OS/2
(4513)
Capture for UNIX
(4651)
Capture for VM
(4892)
Capture for VSE
(4834)
Capture for Windows NT and Windows 95
(4415)
planning
active log size, storage requirements
(3837)
application level
(3891)
capacity requirements
(3844)
contention
(4114)
customization requirements
(3888)
data consistency
(4072)
data currency
(4046)
data transformation
(3892)
hardware requirements
(3809)
mobile replication
(4951)
network requirements
(3858)
processor requirements
(3846)
replication products
(3806)
security and authorization requirements
(3878)
services and consulting
(3626)
software requirements
(3810), (3814)
storage requirements
(3813)
system level
(3804)
update anywhere
CCD tables
(4105)
conflict detection
(4086)
overview
(4080)
recommended usage
(4108)
recovering from conflicts
(4095)
restrictions
(4111)
point-in-time target tables
CREATE TABLE statement
(5164)
defining
(4229)
description
(3654), (3900), (5161)
poorly structured data, data transformation
(3962)
potential replication scenarios
(3790)
predicates, defining for target tables
(4261)
preferences, setting
(4145)
PREPARE command
(5037)
primary key
errors when updating
(3930)
logical partitioning
(4018)
problem determination
(5197)
processor requirements, planning
(3847)
products, replication
(3808)
programming interface information
(5248)
PRTCT
(4648)
prune interval
Capture for MVS
(4311)
Capture for OS/2
(4522)
Capture for UNIX
(4666)
Capture for VM
(4901)
Capture for VSE
(4843)
Capture for Windows NT and Windows 95
(4424)
pruning
Capture for MVS
(4348)
Capture for OS/2
(4548)
Capture for UNIX
(4731)
Capture for VM
(4933)
Capture for VSE
(4875)
Capture for Windows NT and Windows 95
(4450)
CCD tables
(3977)
CD tables
(5068)
condensed CCD tables
(3987)
UOW tables
(5094)
pruning control tables
CREATE TABLE statement
(5079)
description
(3701), (5077)
push and pull Apply program configuration
choosing a configuration
(3874)
data transformation
(3971)
description
(3872)
Q
questions, problem determination
(5216)
quick, defining replication sources
(4161)
R
recommended replication scenarios
(3768)
referential integrity
(4078)
refresh copying
description
(3738)
external CCD tables
(4012)
specifying
(4169)
refresh, suppressing
Apply for MVS
(4395)
Apply for OS/2
(4595)
Apply for UNIX
(4827)
Apply for Windows NT and Windows 95
(4497)
register tables
CREATE TABLE statement
(5083)
description
(3691), (5081)
reinitializing
Capture for MVS
(4346)
Capture for OS/2
(4546)
Capture for UNIX
(4726)
Capture for VM
(4931)
Capture for VSE
(4873)
Capture for Windows NT and Windows 95
(4448)
rejected transactions
(4103)
relative timing
description
(4056)
planning
(4059)
setting for the subscription
(4267)
remote CCD tables
(3991)
removing
replication sources
(4199)
replication subscriptions
(4289)
replica target tables
auto-registration
(3674)
CREATE TABLE statement
(5169)
defining
(4234)
description
(3670), (3910), (5166)
update-anywhere replication
(4084)
replication
administration
(4136)
before-image columns, specifying
(4173)
conflict detection, specifying
(4183)
DataPropagator NonRelational
(3606)
DB2 DataJoiner
(3605)
deferring
(4186), (4218)
IMS and VSAM
(3604)
introduction
Apply program
(3707)
Capture program
(3678)
Control Center
(3638)
legacy data
(3607)
logical partitioning key support, specifying
(4175)
Lotus Notes
(3620)
messages
(5218)
mobile
(4947)
multivendor
(3617)
non-DB2
(3615)
objects, description
(3647)
potential usage scenarios
(3791)
products, description
(3807)
recommended usage scenarios
(3769)
scenarios not recommended
(3799)
solution
(3598)
sources
(3642)
subscriptions
(3645)
supported environments
(3601)
transaction based
(4008)
transaction consistent
(4009)
update anywhere
ASNDONE user exit
(4101)
conflict detection
(4090)
description
(4085)
specifying
(4180)
replication sources
changing
(4196)
conflict detection
(4184)
defining
custom
(4163)
example
(3747)
external CCD
(4188)
for update anywhere
(4292)
joins
(4192)
overview
(4159)
with default values
(4160)
description
(3641)
example of creating
(3743)
outer join
(3956)
overview
(4157)
removing
(4198)
selecting
(3716)
specifying before-image columns
(4172)
specifying data capture
(4167)
specifying refresh copying
(4170)
specifying replication logical partitioning key support
(4176)
specifying update-anywhere replication
(4181)
types
(4158)
views
(3931)
replication subscriptions
activating and deactivating
(4281)
and the Apply qualifier
(3721)
changing
(4286)
cloning
(4284)
completing the definition
(4216)
continuous
(4052)
data consistency
(4076)
defining
advanced steps
(4224)
basic steps
(4202)
columns
(4238)
control server
(4220)
example
(3749)
for update anywhere
(4293)
mini-cycles
(4270)
overview
(4201)
rows
(4250)
run-time processing
(4275)
target table structure
(4215), (4236)
target table type
(4227)
description
(3643)
event-based timing
(4063)
example of creating
(3742)
interval timing
(4057)
mobile replication
(4982)
naming
(4204)
overview
(4200)
referential integrity
(4077)
relative timing
(4058)
removing
(4288)
run-time processing statements
(3948)
selecting user-defined target tables
(4213)
selection order for source
(3714)
setting the timing
(4265)
specifying the Apply qualifier
(4208)
specifying the target server
(4206)
specifying the target table name
(4211)
timing
(4050)
triggering events
(4223)
views
(3957)
resolving a gap
(4134)
restrictions
data types
(4033)
limits on column names
(4043)
mobile replication
(4949)
update anywhere
(4113)
resuming
Capture for MVS
(4344)
Capture for OS/2
(4544)
Capture for UNIX
(4721)
Capture for VM
(4929)
Capture for VSE
(4871)
Capture for Windows NT and Windows 95
(4446)
retention limit
Capture for MVS
(4307)
Capture for OS/2
(4518)
Capture for UNIX
(4662)
Capture for VM
(4897)
Capture for VSE
(4839)
Capture for Windows NT and Windows 95
(4420)
road map of this book
(3595)
row-replica target list tables
CREATE TABLE statement
(5139)
description
(4992), (5010), (5137)
rows
defining in target table
(4251)
defining the predicate
(4260)
restrictions for subsetting
(4254)
subsetting
(3929), (4252)
run-time processing
data transformation
(3943)
defining for the subscriptions
(4276)
S
sample JCL
(5230)
scenarios
building audit trails
(3782)
creating a user copy target table
(3744)
data archive
(3780)
data consolidation and distribution
(3776)
decision support system
(3770)
distributed database system
(3772)
extending IBM Replication
(3796)
hot-site recovery, not recommended
(3802)
improved application availability
(3778)
improved network load
(3774)
logical recovery
(3794)
mobile replication
(3785)
mobile replication with MS Jet
(3787)
not recommended
(3798)
potential customer implementations
(3789)
problem determination
(5215)
recommended customer implementations
(3767)
synchronous replication, not recommended
(3800)
update-anywhere replication
(3792)
scheduling
Apply for MVS
(4368)
Apply for OS/2
(4569)
Apply for UNIX
(4789)
Apply for Windows NT and Windows 95
(4471)
Capture for MVS
(4336)
Capture for OS/2
(4536)
Capture for UNIX
(4704)
Capture for Windows NT and Windows 95
(4438)
event table
for Apply for MVS
(4372)
for Apply for OS/2
(4573)
for Apply for UNIX
(4799)
for Apply for Windows NT and Windows 95
(4475)
event timing
(4068)
relative timing
(4055)
replication subscriptions
(4049)
SECACPT
(4649)
security and authorization requirements, planning
(3879)
selection order for source table
(3712)
Service Control Manager
Apply for Windows NT
(4414)
Capture for Windows NT
(4413)
services and consulting
(3623)
setting up a user account for UNIX
(4613)
setting up document server
(5240)
setting up the Capture and Apply programs
for MVS
(4298)
for OS/2
(4503)
for UNIX
(4614)
for Windows NT and Windows 95
(4401)
setting up the Capture program
for VM
(4889)
for VSE
(4831)
soft errors
(5220)
software requirements
(3812), (3816), (4952)
solution, data replication
(3596)
source server
end-user authentication
(3757)
Microsoft Jet
(4993)
sources
multivendor
(3616)
selection order
(3713)
views
(3934)
SQL
before and after
(3946)
files, customizing
(4154)
statements
defining for the replication subscription
(4274)
run-time processing
(3944)
staging data
benefits of
(3989)
data warehouse
(4013)
description
(3973)
staging table
attributes
(3982)
complete
(3984)
condensed
(3988)
defining
(4233)
ways to use
(3983)
standard conflict detection
(4093)
starting
Apply for MVS
(4364)
Apply for OS/2
(4564)
Apply for UNIX
(4777)
Apply for Windows NT and Windows 95
(3759), (4466)
Capture for MVS
(4330)
Capture for OS/2
(4529)
Capture for UNIX
(4691)
Capture for VM
(4917)
Capture for VSE
(4859)
Capture for Windows NT and Windows 95
(3758), (4431)
DataPropagator for Microsoft Jet
(4998)
migration program
(5030)
stopping
Apply for MVS
(4370)
Apply for OS/2
(4571)
Apply for UNIX
(4797)
Apply for Windows NT and Windows 95
(3763), (4473)
Capture for MVS
(4338)
Capture for OS/2
(4538)
Capture for UNIX
(4709)
Capture for VM
(4923)
Capture for VSE
(4865)
Capture for Windows NT and Windows 95
(3762), (4440)
DataPropagator for Microsoft Jet
(5001)
storage dump (MVS)
(4325)
storage dump (VM)
(4912)
storage dump (VSE)
(4854)
storage requirements
active log size
(3835)
Apply spill file
(3824)
data blocking for large volumes
(3827)
DBMS logging
(3817)
general considerations
(3843)
new tables
(3820)
planning
(3815)
UOW table size
(3822)
virtual memory on MVS
(3826)
subscription columns tables
CREATE TABLE statement
(5114)
description
(3736), (5112)
subscription events tables
CREATE TABLE statement
(5119)
description
(3732), (5116)
subscription schema changes tables
CREATE TABLE statement
(5135)
description
(5012), (5133)
subscription set tables
CREATE TABLE statement
(5123)
description
(3728), (5121)
user load
(4378), (4484), (4582), (4808)
subscription statements tables
CREATE TABLE statement
(5127)
description
(3730), (5125)
subscription targets member tables
CREATE TABLE statement
(5131)
description
(3734), (5129)
subscriptions
Microsoft Jet replication
(4994)
replication
(3644)
subsetting
columns
(3912)
horizontal
(3928)
rows
(3924)
source tables
(3918)
vertical
(3922)
suppressing full refresh
Apply for MVS
(4394)
Apply for OS/2
(4594)
Apply for UNIX
(4826)
Apply for Windows NT and Windows 95
(4496)
suspending
Capture for MVS
(4342)
Capture for OS/2
(4542)
Capture for UNIX
(4716)
Capture for VM
(4927)
Capture for VSE
(4869)
Capture for Windows NT and Windows 95
(4444)
synchronization generations tables
CREATE TABLE statement
(5196)
description
(5024), (5194)
synchronous replication, description
(3801)
syntax diagrams, how to read
(3593)
system planning
(3805)
T
table structures
(5055)
tables
structures
(5056)
tuning parameters
Capture for MVS performance
(4305)
Capture for OS/2 performance
(4516)
Capture for UNIX performance
(4660)
Capture for VM performance
(4895)
Capture for VSE performance
(4837)
Capture for Windows NT and Windows 95 performance
(4418)
target server
Microsoft Jet
(4995)
specifying
(4205)
target tables
auto-registration
(3672)
base aggregate
(3655), (3902), (5143)
CCD
condensed, complete
(3662)
condensed, noncomplete
(3659)
description
(3981), (5153)
noncondensed, complete
(3666)
noncondensed, noncomplete
(3664)
change aggregate
(3657), (3904), (5148)
columns, defining
(4237)
defining for update anywhere
(4291)
fragmenting
(3914)
names, specifying
(4210)
point-in-time
(3653), (5162)
replica
(3669), (5167)
rows, defining
(4249)
specifying a type
(4226)
storage requirements
(3821)
structure, specifying
(4214), (4235)
subsetting columns
(3919)
subsetting rows
(3925)
table structures, quick reference
(5059)
types
(3649)
user copy
(3651), (5172)
user-defined
(4278)
targets
description
(3646)
views
(3960)
terminology
(3589), (4988)
throughput capacity
(3876)
timing
continuous
(4054)
defining for the subscription
(4266)
event-based
(4065), (4071)
interval
(4060)
relative
(4062)
replication subscriptions
(4051)
tools, IBM Replication
(3600), (3636)
trace buffer (MVS)
(4321)
trace buffer (VM)
(4908)
trace buffer (VSE)
(4850)
trace file
Apply program
(5205)
Capture program
(5212)
trace output (MVS)
(4323)
trace output (VM)
(4910)
trace output (VSE)
(4852)
trace tables
CREATE TABLE statement
(5087)
description
(3697), (5085)
problem determination
(5210)
transaction identification
(3967)
transaction-based replication
(4006)
transaction-consistent replication
(4007)
transactions, lost or rejected
(4102)
triggers
data transformation
(3950)
stopping the Capture program (MVS)
(4340)
stopping the Capture program (OS/2)
(4540)
stopping the Capture program (UNIX)
(4714)
stopping the Capture program (VM)
(4925)
stopping the Capture program (VSE)
(4867)
stopping the Capture program (Windows NT and Windows 95)
(4442)
troubleshooting information
Apply for MVS
(4392)
Apply for OS/2
(4592)
Apply for UNIX
(4824)
Apply for Windows NT and Windows 95
(4494)
Capture for MVS
(4386)
Capture for OS/2
(4590)
Capture for UNIX
(4819)
Capture for VM
(4945)
Capture for VSE
(4886)
Capture for Windows NT and Windows 95
(4492)
DataPropagator for Microsoft Jet
(5004)
tuning parameters
Capture for MVS
(4306)
Capture for OS/2
(4517)
Capture for UNIX
(4661)
Capture for VM
(4896)
Capture for VSE
(4838)
Capture for Windows NT and Windows 95
(4419)
tuning parameters tables
CREATE TABLE statement
(5091)
description
(3695), (5089)
U
unit-of-work (UOW) tables
and the Capture program
(3687)
CREATE TABLE statement
(5097)
description
(3699), (5093)
pruning
(5095)
update-anywhere replication
ASNDONE user exit
(4099)
CCD tables
(4106)
conflict detection
(4087)
defining sources and targets
(4290)
planning
(4081)
recommended usage
fragmentation by key
(4109)
fragmentation by time
(4110)
recovering from conflicts
(4096)
restrictions
(4112)
scenario
(3793)
specifying for sources
(4179)
updated primary key columns
(4020)
updating condensed copies, with changed data
(5155)
user copy target tables
CREATE TABLE statement
(5174)
defining
(4228)
description
(3652), (3898), (5171)
scenario for creating
(3745)
user exit program
ASNDIAL
(4959)
ASNHANGUP
(4960)
ASNJDONE
(5006)
user load of tables
(4377), (4483), (4581), (4807)
user-defined target tables
CCD table
(4280)
maintaining
(4279)
specifying
(4212)
subscriptions
(4277)
utility capture restrictions
(4030)
V
VALIDPROCs
(4039)
VERIFY
(4650)
verifying a gap
(4131)
verifying the replication request
(4187), (4221)
vertical subsetting
description
(3920)
steps
(4241)
views
defining as sources
(4195)
description
(3932), (3958)
VSAM data
(3612)
W
warehouse database
(4015)
warm start
Capture for MVS
(4333)
Capture for OS/2
(4533)
Capture for UNIX
(4701)
Capture for VM
(4920)
Capture for VSE
(4862)
Capture for Windows NT and Windows 95
(4435)
forcing
Capture for MVS
(4359)
Capture for OS/2
(4559)
Capture for UNIX
(4760)
Capture for VM
(4942)
Capture for VSE
(4884)
Capture for Windows NT and Windows 95
(4461)
switching to cold start
Capture for MVS
(4351)
Capture for OS/2
(4551)
Capture for UNIX
(4740)
Capture for VM
(4936)
Capture for VSE
(4878)
Capture for Windows NT and Windows 95
(4453)
warm start tables
CREATE TABLE statement
(5101)
description
(3703), (5099)
for Capture for VSE and VM
CREATE TABLE statement
(5105)
descripton
(5103)
WHERE clause
dummy
(4259)
examples
(4262)
filtering rows
(4264)
restrictions
(4256)
[ Top of Page | Previous Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]