Replication Guide and Reference
Special Characters
Numerics
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
Special Characters
Numerics
A
B
base aggregate tables
defining
(4073)
description
(4990)
introduction
(3475)
before-image columns
auditing
(3941)
change-aggregate tables
(4107)
introduction
(3425)
replicating
(3750)
restrictions
(3755)
binary data types
(3815)
binary large object (BLOB)
(3769), (3820)
BIND PACKAGE utility
(3648)
binding
Apply program
for UNIX platforms
(4622)
for Windows and OS/2
(4752)
Capture program
for UNIX platforms
(4618)
for Windows
(3579)
for Windows and OS/2
(4748)
host RDBMSs
(3957)
BLOB (binary large object)
(3770), (3821)
blocking factor
(3721), (4129)
C
CALL procedures
before and after run-time processing
(3764)
defining for subscription set
(4118)
capacity planning
(3657)
Capture enqueue tables
(4908)
Capture program
authorization requirements
(4017)
capacity planning
(3660)
cold start
automatic
(4209)
first
(4216)
preventing
(4212)
configuring
(3577), (4202)
connectivity
(3706)
error recovery
(4311)
for AS/400
(4324)
errors
(4296)
for AS/400
attributes, changing
(4393)
authorization requirements
(4398)
cold start parameter
(4491)
cold start, automatic
(4492)
current receiver size
(3685)
error recovery
(4326)
initializing
(4483)
installing
(4380)
journal entry types
(4494)
journals and journal receivers, managing
(4423)
operating
(4454)
performance options
(4394)
problem determination
(4327)
progress, determining
(4465)
pruning
(4486)
restrictions
(4406)
scheduling
(4471)
setting up
(4373), (4379)
starting
(4457)
starting automatically
(4462)
stopping
(4475)
tuning parameters
(4391), (4395)
warm start parameter
(4489)
for OS/390
alert generation
(4322)
captured log progress
(4578)
cold start parameter
(4549)
installing
(4538)
operating
(4529), (4540)
pruning
(4574)
reinitializing
(4570)
restrictions
(4542)
resuming
(4566)
scheduling
(4553)
setting up
(4535)
starting
(4544)
stopping
(4558)
suspending
(4562)
warm start parameter
(4548)
for UNIX platforms
binding
(4617)
cold start parameter
(4644)
configuring
(4615)
log progress, displaying
(4669)
log sequence number
(4671)
operating
(4608), (4626)
pruning
(4665)
reinitializing
(4661)
restrictions
(4628)
resuming
(4657)
scheduling
(4630)
setting environment variables
(4634)
setting up
(4613)
starting
(4637), (5037)
stopping
(4647)
suspending
(4653)
warm start parameter
(4643)
for VM and VSE
active log size
(3684)
cold start parameter
(4709)
log progress, displaying
(4734)
log sequence number
(4732)
operating
(4693), (4697)
pruning
(4728)
reinitializing
(4724)
restrictions
(4699)
resuming
(4720)
setting up
(4695)
starting
(4703)
stopping
(4712)
suspending
(4716)
warm start parameter
(4708)
for Windows and OS/2
binding
(3578), (4747)
cold start parameter
(4777)
configuring
(4745)
log progress, displaying
(4808)
log sequence number
(4806)
operating
(4738), (4761)
pruning
(4802)
reinitializing
(4798)
restrictions
(4763)
resuming
(4796)
scheduling
(4780)
Service Control Manager for Windows
(4755)
setting environment variables
(4766)
setting up
(4743)
starting
(4768)
stopping
(4784)
suspending
(4790)
warm start parameter
(4776)
gap detection
(4245)
introduction
(3408)
log file
(4307)
messages
(4282), (5023)
nonrelational data sources, identifying
(3926)
operating
(4199)
post-installation tasks
(4201)
problem determination
(4297)
processor requirements
(3659)
pruning
CD tables
(3930)
example
(3589)
reinit command
(4028)
replication sources, recognizing new
(4029)
restrictions
(4175)
setting up
(4166)
staging data
(3855)
starting
example for Windows
(3584)
instructions
(4203)
overview
(3615)
stopping
example for Windows
(3590)
storage dump
(4317)
trace buffer
(4313)
trace file
(4306)
trace output
(4315)
trace table problem determination
(4301)
user ID
(4018)
warm start
(4207), (4213)
Capture triggers
capturing changes
(3842)
introduction
(3409), (3841)
maintaining CCD tables
(3486)
pre-existing triggers
(3849)
relationships to other tables
(3848)
synchronization with Apply program
(3938)
captured log progress
for OS/390
(4579)
for UNIX platforms
(4670)
for VM and VSE
(4735)
for Windows and OS/2
(4809)
cascade full refresh
(3904)
CCD (consistent-change-data) tables
as replication sources
(3895), (4054)
attributes of
(3864)
Capture triggers
(3843)
change-capture mechanisms
(3489)
complete
(3877)
condensed
(3884), (4982)
defining
(4050), (4069)
description
(3866), (4979)
external
(3898), (4154)
internal
(3897)
internal CCD for multiple targets
(3920)
local
(3871)
maintaining external
(4155)
non-IBM data sources
(3923)
noncomplete
(3878)
noncondensed
(3885)
nonrelational data sources
(3927)
pruning
(3936), (4237)
remote
(3872)
restriction
(3528)
staging changed data
(3856)
types of
(3479), (3892)
unique indexes
(3890)
update-anywhere replication
(3862)
with DB2 Enterprise - Extended Edition
(3797)
CCSID translation
(4351)
CD (change data) tables
description
(3858), (4938)
maximum size
(3694)
pruning
(3934)
storage requirements
(3691)
change aggregate tables
defining
(4074)
description
(4994)
introduction
(3477)
change data (CD) tables
description
(3859), (4937)
maximum size
(3695)
pruning
(3935)
storage requirements
(3692)
change-capture
components
(3406)
for CCD tables
(3488)
process
restarting
(3622)
starting
(3619)
changing
replication sources
(4252)
subscription sets
(4269)
character large object (CLOB)
(3771), (3822)
CHGDPRCAPA command
(4396)
CHGJRN command
(4432)
classes, education
(5047)
clients, satellite
(3537)
CLOB (character large object)
(3772), (3823)
cloning subscription sets
(4266)
CNTRLSVR.REX file
(3987)
cold start
automatic
(4208)
Capture program
for AS/400
(4490)
for OS/390
(4551), (4711)
for UNIX platforms
(4646)
for Windows and OS/2
(4779)
general
(4205), (5024)
first
(4215)
gaps
(4247)
preventing
(4210)
columns
after-image
(3427), (3752)
available for replication
(3735)
before-image
(3426), (3751)
changing definition
(4089)
computed
(3759), (4092)
creating new in target table
(4093)
defining in target table
(4082)
names, restrictions
(3756)
primary key, specifying
(4086)
relative record numbers on AS/400
(4452)
removing from target table
(4091)
renaming
(3757), (4088)
subsetting
DB2 Control Center
(4084)
DJRA
(4096)
introduction
(3450)
planning
(3731)
commands
$TA JES2
Apply for OS/390
(4593)
Capture for OS/390
(4555)
ADDEXITPGM
(4443)
ADDJOBSCDE
(4516)
ANZDPRJRN
(4437)
ASNAPPLY
for UNIX platforms
(4681)
for Windows and OS/2
(4820)
ASNARUN
(4587)
ASNCCP
for UNIX platforms
(4640)
for VM and VSE
(4705)
for Windows and OS/2
(4773)
ASNCMD
for UNIX platforms
(4651)
for Windows and OS/2
(4788)
ASNJET
(4849)
ASNJSTOP
(4855)
ASNL2RNx
(4546)
ASNSAT
(4832)
ASNSTOP
for UNIX platforms
(4691)
for Windows and OS/2
(4830)
AT
Apply for UNIX platforms
(4687)
Apply for Windows
(4826)
Capture for UNIX platforms
(4632)
Capture for Windows
(4782)
AT NetView
Apply for OS/390
(4594)
Capture for OS/390
(4556)
BIND PACKAGE
(3644)
CHGDPRCAPA
(4397)
CHGJRN
(4431)
CRTDPRPKG
(4498)
CRTDPRTBL
(4389), (4506)
CRTJRN
(4415)
CRTJRNRCV
(4413)
CRTSQLPKG
(4500)
DB2FLSN
for UNIX platforms
(4675)
DBFLFSN
for Windows and OS/2
(4812)
DSPJRN
(4469)
ENDDPRAPY
(4519)
ENDDPRCAP
(4478)
ENDJOB
(4480)
GETLSEQ
for OS/390
(4581)
for UNIX platforms
(4673)
for VM and VSE
(4736)
for Windows and OS/2
(4810)
GRTDPRAUT
(4401)
INZDPRCAP
(4482)
LOADX
(3586)
PRUNE
for OS/390
(4576)
for UNIX platforms
(4667)
for VM and VSE
(4730)
for Windows and OS/2
(4803)
RCVJRNE
(4424)
REINIT
for OS/390
(4572)
for UNIX platforms
(4663)
for VM and VSE
(4726)
for Windows and OS/2
(4800)
replication sources, recognizing new
(4027)
REORG
(3633), (3646)
RESUME
for OS/390
(4568)
for UNIX platforms
(4659)
for VM and VSE
(4722)
for Windows and OS/2
(4792)
REVOKE
(3645)
RGZPFM
(3632)
RMVEXITPGM
(4439)
RUNSTATS
(3634), (3647)
RVKDPRAUT
(4404)
SBMJOB
(4473)
STOP
for OS/390
(4560)
for UNIX platforms
(4649)
for VM and VSE
(4714)
for Windows and OS/2
(4786)
STRDPRAPY
(4508)
STRDPRCAP
(4456)
STRJRNPF
(4419)
STRSBS
(4464)
SUSPEND
for OS/390
(4564)
for UNIX platforms
(4655)
for VM and VSE
(4718)
for Windows and OS/2
(4794)
WRKRDBDIRE
(4504), (4522)
WRKREGINF
(4441)
WRKSBMJOB
(4330)
WRKSBSJOB
(4329)
commit interval
(4173)
communication
log-based
(3412)
trigger-based
(3414)
complete CCD tables
(3482), (3881)
components
See also Apply program, Capture program, Capture triggers, Control Center, DJRA (DB2 DataJoiner Replication Administration) tool
(3385)
administration interfaces
(3399)
communication between
(3411)
introduction
(3384)
computed columns
(3760), (4094)
concepts
after-image columns
(3422)
Apply qualifier
(3444)
before-image columns
(3424)
change capture
(3407)
column subsetting
(3454)
conflict detection
(3436)
control tables
(3386)
differential-refresh copying
(3430)
full-refresh copying
(3428)
joins
(3459)
logical servers
(3388)
replication
(3416)
replication sources
(3417)
row subsetting
(3453)
subscription sets
(3438)
subscription-set members
(3440)
subsetting source tables
(3449)
table partitioning
(3451)
target tables
(3465)
unions
(3460)
user tables
(3419)
views as sources
(3457)
condensed CCD tables
introduction
(3484)
overview
(3888)
updating
(4983)
configuration, replication
changing
(3620)
copying
(3623)
modifying
(4249)
operating
(3625)
planning, overview
(3594)
setting up, overview
(3606)
configuring
Apply program
for UNIX platforms
(4620)
for Windows and OS/2
(4750)
Capture program
for UNIX platforms
(4616)
for Windows and OS/2
(4746)
connectivity
(3711), (3959)
Control Center for host RDBMSs
(3955)
conflict detection
levels of
(3437), (4032)
mobile environment
(4033)
overview
(4038)
conflict tables
(4872), (5002)
connecting
to AS/400 server
(4384)
connectivity
(3705), (3958)
consistent-change-data (CCD) tables
as replication sources
(3896), (4055)
attributes of
(3865)
Capture triggers
(3844)
change-capture mechanisms
(3490)
complete
(3879)
condensed
(3886), (4981)
defining
(4051), (4070)
description
(3867), (4978)
external
(3900), (4156)
internal
(3899)
internal CCD for multiple targets
(3921)
local
(3873)
maintaining external
(4157)
non-IBM data sources
(3924)
noncomplete
(3880)
noncondensed
(3887)
nonrelational data sources
(3928)
pruning
(3937), (4238)
remote
(3874)
staging changed data
(3857)
types of
(3480), (3893)
unique indexes
(3891)
update-anywhere replication
(3863)
consolidating data
(3545)
constraints, referential
(3604)
consulting and services
(5040)
Control Center
authorization requirements
(4014)
capacity planning
(3664)
columns, defining
(4085)
configuring for host RDBMSs
(3954)
connectivity
(3708)
introduction
(3402)
processor requirements
(3663)
replication sources
changing
(4254)
defining
(4025)
removing
(4258)
rows, defining
(4102)
setting preferences
(3960)
setting up replication
(3953)
SQL statements and stored procedures
(4123)
subscription sets
activating
(4263)
changing
(4270)
cloning
(4267)
deactivating
(4264)
defining
(4057)
removing
(4275)
timing
(4134)
target-table type, choosing
(4066)
tutorial
(3569)
user-defined tables
(4117)
control servers
for DB2 replication
(3397)
location of
(3600)
control tables
Apply job
(4965)
Apply trail
(4962)
Apply-qualifier-cross-reference
(4924)
at the control server
(4889), (4940)
at the source server
(4887), (4893)
at the target server
(4891), (4968)
authorization requirements for AS/400
(4447)
base aggregate
(4989)
Capture enqueue
(4907)
CCD target
(4977)
CD
(4936)
change aggregate
(4993)
conflict
(4871), (5001)
creating
DJRA
(3999)
DPCNTL files
(3992)
for AS/400
(4390)
critical section
(4915)
CRTDPRTBL command
(4387)
customizing, example
(3571)
DataPropagator for Microsoft Jet
(4865)
error information
(4873), (5004)
error messages
(4875), (5007)
error-side-information
(4877), (5010)
granting authority for AS/400
(4402)
introduction
(3387)
key string
(4879), (5013)
location of
(3599)
point-in-time
(4973)
prune lock
(4918)
pruning control
(4901)
pruning of, overview
(3629)
quick reference
at a glance
(4885)
control server
(4888)
source server
(4886)
target server
(4892)
register
(4894)
register extension
(4898)
register synchronization
(4927)
replica
(4985)
revoking authority for AS/400
(4405)
row-replica
(4997)
row-replica-target-list
(4866), (4953)
storage requirements
(3689)
subscription columns
(4947)
subscription events
(4959)
subscription set
(4941)
subscription statements
(4950)
subscription-schema-changes
(4868), (4956)
subscription-targets-member
(4944)
synchronization generations
(4881), (5016)
trace
(4921)
tuning parameters
(4904)
UOW
(4930)
user copy
(4969)
warm start
(4910)
warm start for VSE and VM
(4912)
copies, types of refresh
(3433)
copying replication configuration
(4164)
creating control tables
CRTDPRTBL command
(4386)
DJRA
(3998)
DPCNTL files
(3991)
critical section tables
(4916)
CRTDPRPKG command
(4497)
CRTDPRTBL command
(4388), (4505)
CRTJRN command
(4417)
CRTJRNRCV command
(4414)
CRTSQLPKG command
(4499)
current receiver size
(3679), (4429)
customizing
DJRA
(3980)
SQL files
(4001)
SQL for control tables
(3997)
table names
(3965)
D
data
accessing continuously
(3557)
consolidation configuration
(3526)
distributing to remote sites
(3549)
distribution configuration
(3524)
IMS, distributing
(3552)
manipulating source
(3448)
manipulating target
(3728)
prerequisites
(3598)
data blocking
(3719)
data compression restrictions
(3789)
data consistency
(4149)
data currency
(4131)
data encryption restrictions
(3809)
data integrity
DataPropagator for Microsoft Jet
(4836)
resolving gaps
(4248)
data manipulations
(3447), (3727)
data restrictions
(3783)
data sharing
(4125)
data types, restrictions
(3811)
databases
maintenance tasks
(3636), (4233)
non-IBM target tables
(3601)
DATALINK values
ASNDLCOPY exit routine
(4189)
ASNDLCOPYD file-copy daemon
(4197)
link control level
(4058)
planning
(3778)
DataPropagator for Microsoft Jet
ASNJDONE parameters
(4861)
ASNJET parameters
(4851)
control tables
(4864)
data integrity
(4837)
error recovery
(4863)
operating
(4844)
setting up
(4842)
starting
(4846)
stopping
(4852)
terminology
(4839)
troubleshooting
(4856)
DataPropagator NonRelational
maintaining CCD tables
(3487)
DB2 Control Center
See Control Center
(3401)
DB2 DataJoiner
restrictions
(3833)
setup
(4198)
DB2 DataJoiner Replication Administration (DJRA) tool
See DJRA (DB2 DataJoiner Replication Administration) tool
(3405)
DB2 Extenders
restrictions
(3777)
DB2 File Manager
(3779)
DB2 for OS/390
Apply program
operating
(4531)
Capture program
operating
(4530)
CCSID translation
(4352)
data sharing
(4126)
DB2 ODBC Catalog
(4601)
index types
(4600)
password verification
(3713)
DB2 ODBC Catalog
function calls
(4606)
setting up server
(4604)
setting up workstation client
(4603)
tables
(4605)
Version 6 enhancements
(4602)
DB2 Tools Settings notebook
(3961)
DB2FLSN command
for UNIX platforms
(4676)
for Windows and OS/2
(4813)
DB2INSTANCE
starting Capture for UNIX
(4639)
starting Capture for Windows and OS/2
(4772)
DBCLOB (double-byte character large object)
(3774), (3825)
DBLIB connections
improving performance
(4227)
Microsoft SQL Server
(3971)
deactivating subscription sets
(4262)
decision support systems
(3559)
defining
replication source joins
(4043)
replication sources
(4024)
subscription sets
(3574)
delete journal receiver exit routine
(4436)
Design Master
(4840)
designing
overview
(3595)
replication configurations
(3517)
unsuitable configurations
(3519)
detecting a gap
(4244)
diagnosing errors
(4277)
differential-refresh copying
(3431)
distinct data type
(3830)
distributing
data to remote sites
(3548)
IMS data
(3551)
DJRA (DB2 DataJoiner Replication Administration) tool
authorization requirements
(4015)
capacity planning
(3666)
columns, defining
(4095)
connectivity
(3709)
control tables, creating
(4000)
customizing
(3978)
editing
logic
(3979)
SQL
(4004)
installing
(3974)
introduction
(3404)
offline load
(4159)
overview
(3969)
preferences
(3976)
processor requirements
(3665)
promote functions
(4162)
Replication Monitor
(4242)
replication sources
changing
(4253)
defining
(4026)
removing
(4257)
rows, defining
(4113)
running SQL
(4007)
setting up replication
(3967)
SQL
editing
(4005)
running
(4008)
SQL statements and stored procedures
(4124)
subscription sets
changing
(4271)
defining
(4059)
removing
(4274)
timing
(4135)
target-table type, choosing
(4076)
targets supported
(3970)
using for AS/400
defining replication sources and subscription sets
(4448)
relative record numbers
(4378), (4450)
Replication Monitor
(4466)
DJX_ASYNC_APPLY variable
(4231)
double-byte character large object (DBCLOB)
(3773), (3824)
DPCNTL files
(3993)
DPNCNTL files
(3995)
DPREPL.DFT file
(3964)
DSPJRN command
(4470)
dummy WHERE clause
(4108)
dump, storage
(4318)
E
EDITPROC
(3792)
education
custom classes
(5045)
IBM Global Campus URL
(5046)
ENDDPRAPY command
(4518)
ENDDPRCAP command
(4477)
ENDJOB command
(4479)
environment
copying, overview
(3624)
planning, overview
(3593)
setting up, overview
(3607)
environment Analyzer
(4341)
environment variables
Capture program
for UNIX platforms
(4636)
for Windows and OS/2
(4765)
error information tables
(4874), (5005)
error messages tables
(4876), (5008)
error recovery
AS/400
(4325)
Capture and Apply programs
(4284)
DataPropagator for Microsoft Jet
(4862)
for OS/390, VM, and VSE
(4310)
error-side-information tables
(4878), (5011)
errors, diagnosing
(4276)
event-based timing
(3509), (4146)
examples
See also replication configurations
(3539)
CD table, pruning
(3693)
spill file size, setting
(3703)
SQL for columns
(4090)
WHERE clauses
(3550), (4111)
exit routines
ASNDLCOPY
configuration files
(4195)
input
(4193)
parameters
(4192)
using
(4188)
ASNDONE
for AS/400
(4525)
using
(4186)
ASNJDONE
(4859)
ASNLOAD
for AS/400
(4526)
using
(4179)
delete journal receiver (AS/400)
(4435)
external CCD tables
(4158)
overview
(3902)
planning multiple targets
(3919)
F
FIELDPROC
restrictions for Capture for VM and VSE
(4702)
restrictions, general
(3793)
files
apply_names.ini
(4230)
CNTRLSVR.REX
(3988)
DPCNTL
(3994)
DPNCNTL
(3996)
spill
(3672), (3701)
SRCESVR.REX
(3986)
TARGSVR.REX
(3990)
TBLSPACE.REX
(3983)
fragmentation
horizontal
(3738)
update-anywhere replication
(4035)
vertical
(3734)
full-refresh copying
Apply for AS/400
(4453), (4513)
external CCD table
(3903)
forcing in Apply for OS/390
(4361)
internal CCD table
(3905)
introduction
(3429)
suppressing in Apply for OS/390
(4358)
G
gap detection
(3945), (4243)
generated SQL
editing
(4006)
running
(4010)
GETLSEQ command
for OS/390
(4582)
for UNIX platforms
(4674)
for VM and VSE
(4737)
for Windows and OS/2
(4811)
global record
(4897)
GROUP BY clause
(4106)
GRTDPRAUT command
(4400)
H
history data
(3942)
horizontal subsets
(3737)
host RDBMSs, configuring the Control Center
(3956)
hot-site backup
(3522)
I
IBM Software Support
(4371)
IMS DataPropagator
data distribution example
(3555)
using CCD tables
(3929)
index types, rules for OS/390
(4599)
Informix
restrictions
(3840)
initializing Capture program for AS/400
(4484)
installation
Capture and Apply programs
for AS/400
(4383)
for OS/390
(4537)
for UNIX platforms
(4623)
for VM and VSE
(4696)
DJRA
(3973)
restrictions
(3951)
services and consulting
(5044)
internal CCD tables
overview
(3901)
planning multiple targets
(3918)
interval-based timing
(3506)
invocation parameters
Apply program
for AS/400
(4511)
for OS/390
(4589)
for UNIX platforms
(4683)
for Windows and OS/2
(4822)
Capture program
for AS/400
(4459)
for OS/390
(4552)
for UNIX platforms
(4642)
for VM and VSE
(4707)
for Windows and OS/2
(4775)
INZDPRCAP command
(4481)
J
joins
defining as sources
(4044)
for targets
(3461)
planning to use
(3605)
replicating
(3744)
journal receivers
creating for source tables
(4412)
current, size
(3681)
delete journal receiver exit routine
(4434)
managing
(4422)
system management
(4426)
threshold
(4428)
user management
(4430)
journaling requirements
(3676)
journals
creating
(4416)
default message queue
(4433)
entry types
(4493)
managing
(4421)
problem determination
(4335)
QSQJRN journal
(4409)
remote journal function
(4410)
starting
(4418)
use
(4408)
K
KEEPDICTIONARY keyword
(4236)
key string tables
(4880), (5014)
key-update
restrictions
(3781)
L
lag limit
(4172)
large object (LOB)
(3767), (3818)
large replication jobs
(3722)
LE for OS/390 environment
(4345)
legacy data sources
(3554)
LOADX command
ASNLOAD exit routine
(4180)
example
(3587)
LOB (large object)
(3768), (3819)
local cache for committed changes
(3906)
local CCD tables
(3875)
log file
Apply program
(4294)
Capture program
(4308)
log records, archived before captured
(3683)
log sequence number
for OS/390
(4580)
for UNIX platforms
(4672)
for VM and VSE
(4733)
for Windows and OS/2
(4807)
log-based communication
(3413)
logging requirements
(3675)
logic, editing DJRA
(3981)
logical partitioning keys
description
(4047)
row subsets
(3742), (3847)
logical servers
(3389)
LONG VARCHAR data type
(3817)
LONG VARGRAPHIC data type
(3816)
M
maintenance
database
(4232)
overview of tasks
(3635)
MAX_SYNCH_MINUTES
(3720), (4130)
members, subscription-set
(3442)
messages
Apply for AS/400
(5030)
Apply program
(5019), (5026), (5028)
Capture for AS/400
(5031)
Capture program
(5021), (5025)
delete receiver exit program
(5035)
for problem determination
(4283)
Trigger Program for Critical Section Table
(5034)
Trigger Program for Prune Control Table
(5033)
Trigger Program for Register Table
(5032)
Microsoft Jet
(4834)
Microsoft SQL Server
DBLIB connections
(3972)
improving performance
(4226)
restrictions
(3836)
migration
planning
(3948)
services and consulting
(5043)
mini-cycles
Apply program
(3725)
defining for subscription set
(4128)
mobile replication
see also Microsoft Jet
(4835)
monitoring
Capture program progress for AS/400
(4468)
introduction
(3630)
replication environment
(4240)
multi-tier staging
(3908)
multiple source tables
(3546)
multiple target tables
(3916)
N
network connectivity
(3710)
non-DB2 distributed data store
(3564)
non-DB2 reports
query database
(3566)
non-IBM data sources
(3922)
noncomplete CCD tables
(3483), (3882)
noncondensed CCD tables
(3485), (3889)
nonrelational data sources
(3925)
NT Service Control Manager
Apply for Windows
(4760)
Capture for Windows
(4758)
NT Services
starting Apply program
(4819)
starting Capture program
(4771)
O
Object Rexx
(3975)
occasionally connected environments
See also satellite replication, Microsoft Jet
(3533)
description
(3534)
example configuration
(3562)
introduction
(3532)
offline load
(4160)
on-demand timing
(3512)
operating
Apply program
example
(3616)
for AS/400
(4496)
for OS/390
(4584)
for UNIX platforms
(4678)
for Windows and OS/2
(4815)
overview
(4219)
Capture program
example
(3617)
for AS/400
(4455)
for OS/390
(4541)
for UNIX platforms
(4627)
for VM and VSE
(4698)
for Windows and OS/2
(4762)
overview
(4200)
DataPropagator for Microsoft Jet
(4845)
overview
(3627)
options, performance
(4168)
ORA-04081 message
(3850)
Oracle
restrictions
(3838)
overview
P
parameter definitions
DataPropagator for Microsoft Jet
(4850), (4860)
partitioning key
(3801)
password files
creating, example
(3583)
for Apply program
for UNIX platforms
(4625)
for Windows and OS/2
(4754)
password verification, DB2 for OS/390
(3712)
performance
improving
(4224)
options
(4167)
troubleshooting, introduction
(3653)
planning
active log size
(3682)
capacity
(3658)
conflict detection
(4036)
migration
(3949)
multiple target tables
(3917)
network
(3704)
overview
(3596)
security
(4011)
services and consulting
(5042)
staging data
(3853), (3907), (3915)
storage requirements
(3668)
point-in-time tables
defining
(4068)
description
(4974)
introduction
(3470)
PREDICATES column capacity
(3745)
predicates, defining for target tables
(4103)
preferences, setting
DB2 Control Center
(3963)
DJRA
(3977)
PREFORMAT keyword
(4235)
primary keys
logical partitioning
(4046)
relative record numbers for AS/400
(4451)
problem determination
administration
(4280)
alert generation for OS/390
(4323)
Apply program
(4286)
Apply trail table
(4288)
Capture program
for AS/400
(4328)
for OS/390, VM, and VSE
(4312)
Capture program trace table
(4300)
collecting data (AS/400)
(4337)
errors
Capture program
(4298)
IBM Software Support
(4372)
journal
(4336)
log file
Apply program
(4295)
Capture program
(4309)
scenario
(4279)
storage dump
(4321)
trace buffer
(4314)
trace file
Apply program
(4292)
Capture program
(4305)
trace output
(4316)
WRKSBMJOB command
(4333)
WRKSBSJOB command
(4334)
programming interface information
(5048)
promote functions
(4163)
PRUNE command
for OS/390
(4577)
for UNIX platforms
(4668)
for VM and VSE
(4731)
for Windows and OS/2
(4804)
prune interval
(4174)
prune lock tables
(4919)
pruning
Capture program
for AS/400
(4487)
for OS/390
(4575)
for UNIX platforms
(4666)
for VM and VSE
(4729)
for Windows and OS/2
(4805)
CCD tables
(4239)
CCD tables, with Capture triggers
(3933)
CD tables
(3931)
control tables
(3628), (4902)
example
(3588)
UOW tables
(3932), (4934)
push and pull Apply program configurations
choosing a configuration
(3716)
description
(3714)
Q
questions, problem determination
(4370)
R
RCVJRNE command
(4425)
read dependencies
(4040)
real-time replication
(3521)
receiver size, current
(3680)
referential constraints
(3603), (3805)
referential integrity
(4152)
refresh
differential
(3434)
full
(3435)
suppressing for Apply for OS/390
(4360)
register extension tables
(4899)
register synchronization tables
(4928)
register tables
(4153), (4895)
REINIT command
for OS/390
(4573)
for UNIX platforms
(4664)
for VM and VSE
(4727)
for Windows and OS/2
(4801)
reinitializing Capture program
for OS/390
(4571)
for UNIX platforms
(4662)
for VM and VSE
(4725)
for Windows and OS/2
(4799)
relative record numbers
as primary key for AS/400
(4449)
push configuration
(3718)
support for AS/400
(4377)
relative timing
(4140)
remote
Apply program
for AS/400
(4502)
remote CCD tables
(3876)
remote journal
restrictions
(3798)
remote journal function
(4411)
remote journaling
(3717)
removing
replication sources
(4256)
subscription sets
(4273)
renaming columns
(3758), (4087)
REORG utility
(3638), (3649), (4234)
replica tables
See also row-replica tables
(3492)
defining
(4075)
description
(4986)
introduction
(3491)
Replication Analyzer
(3656), (4340)
replication configurations
accessing data continuously
(3556)
auditing archive information
(3541)
data consolidation
(3525), (3544)
data distribution
(3523), (3547)
decision support systems
(3558)
examples of
(3540)
IMS data, distributing
(3553)
occasionally connected systems
(3531), (3561)
replicating operational data
(3565)
retrieving data
(3563)
typical
(3516)
update-anywhere
(3529)
replication environment
copying
(4165)
operating
(3626)
setting up
(3612)
starting to replicate
(3613)
updating
(3621)
replication messages
(5020), (5029)
Replication Monitor
introduction
(3631)
overview
(4241)
using for AS/400
(4467)
replication sources
CCD (consistent-change-data) tables as
(3894)
changing
(4250)
DATALINK values
(3780)
defining
example
(3570), (3572)
for AS/400
(4445)
joins
(4042)
overview
(4023)
introduction
(3418)
large objects
(3775)
removing
(4255)
setting up, overview
(3609)
subsetting
(3456)
viewing
(4251)
restrictions
DB2 Enterprise - Extended Edition
(3796)
archived log
(3787)
AS/400
(3800)
ASCII tables
(3828)
Capture program
for AS/400
(4407)
for OS/390
(4543)
for UNIX platforms
(4629)
for VM and VSE
(4700)
for Windows and OS/2
(4764)
general
(4176)
CCD tables as sources
(3527)
column names, limits
(3754)
data compression
(3790)
data encryption
(3810)
data types
(3812)
DB2 DataJoiner
(3832)
EDITPROC
(3794)
FIELDPROC
(3795), (4701)
for DB2 Extenders large objects
(3776)
general
(3784)
Informix
(3839)
key-update
(3782)
Microsoft SQL Server
(3834)
MVS
(3791)
Oracle
(3837)
partitioning key
(3802)
referential constraints
(3806)
remote journal
(3799)
stored procedures
(3804)
Sybase
(3835)
table-name length
(3785)
Unicode tables
(3829)
utility program
(3808)
VALIDPROC
(3814)
views
(3747)
VM & VSE
(3788)
WHERE clause
(4105)
RESUME command
for OS/390
(4569)
for UNIX platforms
(4660)
for VM and VSE
(4723)
for Windows and OS/2
(4793)
resuming Capture program
for OS/390
(4567)
for UNIX platforms
(4658)
for VM and VSE
(4721)
for Windows and OS/2
(4797)
retention limit
(4171)
REVOKE utility
(3651)
Rexx
RGZPFM command
(3637)
RMVEXITPGM command
(4440)
row-replica tables
See also replica tables
(3495)
description
(4841), (4998)
introduction
(3494)
row-replica-target-list tables
(4867), (4954)
rows
defining in target table
(4099)
subsetting
DB2 Control Center
(4100)
DJRA
(4114)
introduction
(3455), (3740)
run-time processing
(3761), (4122)
RUNSTATS utility
(3639), (3650)
RVKDPRAUT command
(4403)
S
satellite clients
(3538)
satellite replication
(3535), (3536)
satellites
SBMJOB command
(4474)
scenarios
problem determination
(4278)
typical
(3514)
using Control Center
(3567)
scheduling
Apply program
for AS/400
(4515)
for OS/390
(4592)
for UNIX platforms
(4686)
for Windows and OS/2
(4825)
Capture program
for AS/400
(4472)
for OS/390
(4554)
for UNIX platforms
(4631)
for Windows and OS/2
(4781)
subscription sets
(4132)
timing
event
(4145)
relative
(4139)
security
(4012)
servers
control
(3396)
logical
(3391)
source
(3392)
target
(3394)
Service Control Manager
Apply for Windows
(4759)
Capture for Windows
(4757)
services and consulting
(5039)
setting environment variables
Capture program
for UNIX platforms
(4635)
for Windows and OS/2
(4767)
setting up
Apply program
for AS/400
(4375)
for OS/390
(4534)
for UNIX platforms
(4611)
for Windows and OS/2
(4742)
Capture program
for AS/400
(4376)
for OS/390
(4533)
for UNIX platforms
(4612)
for VM and VSE
(4694)
for Windows and OS/2
(4741)
replication
DB2 Control Center
(3952)
DJRA
(3968)
replication criteria
(3608)
source servers
introduction
(3393)
password file for
(3582)
source tables
See replication sources
(3421)
spill files
(3671), (3700)
SQL
editing
(4003)
errors
(5022)
files, customizing
(3573), (4002)
running DJRA
(4009)
statements
defining for subscription set
(4120)
run-time processing
(3763)
SQLCODEs
-1032
(4364)
-206
(4367)
-330
(4349)
-741
(3852)
-805
(4356)
1108
(4369)
SQLSTATEs
22517
(4350)
51002
(4357)
57019
(4365)
SRCESVR.REX file
(3985)
staged replication
(4052)
staging data
(3854)
staging table
See also CCD (consistent-change data) tables
(4072)
defining
(4071)
starting
Apply program
for AS/400
(4510)
for OS/390
(4586)
for UNIX platforms
(4680)
for Windows and OS/2
(4817)
using NT Services
(4818)
with event
(4061)
Capture program
for AS/400
(4458)
for OS/390
(4545)
for UNIX platforms
(4638), (5038)
for VM and VSE
(4704)
for Windows and OS/2
(4769)
general
(4204)
using NT Services
(4770)
change capture
(3618)
DataPropagator for Microsoft Jet
(4847)
STOP command
for OS/390
(4561)
for UNIX platforms
(4650)
for VM and VSE
(4715)
for Windows and OS/2
(4787)
stopping
Apply program
for AS/400
(4521)
for OS/390
(4598)
for UNIX platforms
(4690)
for Windows and OS/2
(4829)
Capture program
for AS/400
(4476)
for OS/390
(4559)
for UNIX platforms
(4648)
for VM and VSE
(4713)
for Windows and OS/2
(4785)
DataPropagator for Microsoft Jet
(4853)
storage
active log size
(3677)
Apply spill files
(3670), (3699)
CD table
(3690)
control tables
(3687)
database log and journal data
(3674)
dump
(4320)
planning
(3669)
target tables
(3686)
UOW table
(3696)
stored procedures
(3762), (3803), (4119)
STRDPRAPY command
(4507)
STRDPRCAP command
(4461)
STRJRNPF command
(4420)
STRSBS command
(4463)
subscription columns tables
(4948)
subscription cycle
(3726)
subscription events tables
description
(4960)
populating
(4142)
subscription set tables
(4942)
subscription sets
activating
(4259)
changing
(4268)
cloning
(4265)
continuous
(4136)
data consistency
(4150)
deactivating
(4260)
defining
columns
(4081)
Control Center or DJRA
(4056)
example of
(3575)
for AS/400
(4446)
mini-cycles
(4127)
rows
(4098)
run-time processing
(4121)
target-table structure
(4078)
target-table type
(4065)
update-anywhere replication
(4063)
introduction
(3439)
referential integrity
(4151)
removing
(4272)
run-time processing statements
(3766)
setting up, overview
(3610)
timing
changing
(4148)
event-based
(4141)
interval
(4137)
relative
(4138)
subscription statements tables
(4951)
subscription-schema-changes tables
(4869), (4957)
subscription-set members
introduction
(3441)
setting up, overview
(3611)
subscription-targets-member tables
(4945)
subscriptions
See subscription sets, subscription-set members
(3443)
subsetting
columns
(3729), (4083)
horizontal
(3739)
rows
(3736), (4101)
source tables
(3732)
target tables
(4079)
subsystems
See logical servers
(3390)
suppressing full-refresh copying for OS/390
(4359)
SUSPEND command
for OS/390
(4565)
for UNIX platforms
(4656)
for VM and VSE
(4719)
for Windows and OS/2
(4795)
suspending Capture program
for OS/390
(4563)
for UNIX platforms
(4654)
for VM and VSE
(4717)
for Windows and OS/2
(4791)
Sybase
DBLIB connections
(3972)
improving performance
(4226)
restrictions
(3836)
Sybase, improving performance
(4225)
synchronization generations tables
(4882), (5017)
synchronous replication
(3502), (3520)
SYS1.DUMP data set
(4319)
system change journal management
(4427)
T
table partitioning
See column subsetting, row subsetting
(3452)
table space, specifying in logic
(3984)
table structures
(4883)
tables
See also control tables, source tables, target tables
(3463)
Apply job
(4967)
Apply trail
(4289), (4964)
Apply-qualifier-cross-reference
(4926)
base aggregate
(4992)
Capture enqueue
(4909)
change aggregate
(4996)
change data (CD)
(3860), (4939)
complete, condensed CCD tables
(3909)
complete, noncondensed CCD tables
(3911)
conflict
(5003)
consistent-change-data (CCD)
(3869), (4984)
critical section
(4917)
customizing names
(3966)
DB2 ODBC Catalog
(4607)
error information
(5006)
error messages
(5009)
error-side-information
(5012)
key string
(5015)
Microsoft Jet target server
(4870)
noncomplete, condensed CCD tables
(3912)
noncomplete, noncondensed CCD tables
(3914)
point-in-time
(4976)
prune lock
(4920)
pruning control
(4903)
register
(4896)
register extension
(4900)
register synchronization
(4929)
replica
(4988)
row-replica
(5000)
row-replica-target-list
(4955)
staging
(3870)
structures
(4884)
subscription columns
(4949)
subscription events
(4961)
subscription set
(4943)
subscription statements
(4952)
subscription-schema-changes
(4958)
subscription-targets-member
(4946)
synchronization generations
(5018)
target types
(3464)
trace
(4302), (4923)
tuning parameters
(4169), (4906)
unit-of-work (UOW)
(4933)
user
(3497)
user copy
(3469), (4972)
warm start
(4913)
target servers, introduction
(3395)
target tables
aggregate
(3474)
base aggregate
(3476), (4991)
CCD (consistent-change-data)
description
(3868), (4980)
introduction
(3481)
change aggregate
(3478), (4995)
columns, defining
(4080)
fragmenting
(3730)
in non-IBM databases
(3602)
offline load
(4161)
point-in-time
(3471), (4975)
replica
(3493), (4987)
row-replica
(3496), (4999)
rows, defining
(4097)
storage requirements
(3688)
structure, specifying
(4077)
table structures, quick reference
(4890)
type, specifying
(4064)
types of
(3466)
update anywhere, defining
(4031)
user
(3499)
user copy
(3468), (4971)
user defined
(4116)
TARGSVR.REX file
(3989)
tasks, overview
(3592)
TBLSPACE.REX file
(3982)
terminology
DataPropagator for Microsoft Jet
(4838)
DB2 DataPropagator
(3383)
three-tier replication configuration
(4053)
timing
event-based
(3510), (4143)
interval-based
(3507)
on-demand
(3513)
subscription sets
changing
(4147)
setting
(4133)
Tools Settings notebook
(3962)
trace files
Apply program
(4291)
Capture program
(4303)
problem determination
(4304)
trace tables
description
(4922)
problem determination
(4299)
transaction identification
(3946)
trigger-based communication
(3415)
troubleshooting
Capture and Apply programs
(4342)
DataPropagator for Microsoft Jet
(4857)
introduction
(3652)
services and consulting
(5041)
tuning parameters
Capture for AS/400
(4392), (4485)
specifying
(4170)
tuning parameters tables
(4905)
tutorial for Windows NT
(3568)
U
Unicode tables
(3827)
unions for targets
(3462)
unit-of-work (UOW) tables
Capture triggers
(3845)
description
(4931)
pruning
(4935)
storage requirements
(3697)
UOW (unit-of-work) tables
Capture triggers
(3846)
description
(4932)
storage requirements
(3698)
update-anywhere replication
CCD (consistent-change-data) tables
(3861)
conflict detection
(4037)
defining sources
(4030)
defining subscription sets
(4062)
example configuration
(3560)
fragmentation for
(4034)
introduction
(3530)
updated primary key columns
(4048)
updates
as inserts and deletes
(4049)
asynchronous
(3503)
conflicts
(4039)
event-based timing
(3508)
interval-based timing
(3505)
on-demand timing
(3511)
scheduling
(3500)
synchronous
(3501)
user copy tables
defining
(4067)
description
(4970)
introduction
(3467)
user ID
Apply program
(4022)
Capture program
(4019)
requirements
for UNIX
(4610)
Windows and OS/2
(4740)
user tables
as targets
(3498)
introduction
(3420)
user-defined data types
(3831)
user-defined tables
(4115)
user-oriented identification
(3947)
utilities
BIND PACKAGE
(3640)
REORG
(3642)
REVOKE
(3641)
RUNSTATS
(3643)
utility program restrictions
(3807)
V
VALIDPROC
(3813)
vertical subsets
(3733)
views
defining as sources
(3458), (4045)
description
(3743)
double delete
(3749)
restrictions
(3748)
W
warm start tables
description
(4911)
for Capture for VSE and VM
(4914)
warm start, Capture program
for AS/400
(4460), (4488)
for OS/390
(4550)
for UNIX platforms
(4645)
for VM and VSE
(4710)
for Windows and OS/2
(4778)
forcing
(4211)
general
(4206)
WARMNS keyword
(4214)
Web pages
(3950)
WHERE clause
dummy
(4109)
examples
(4110)
filtering rows
(4112)
PREDICATES column restriction
(3746)
restrictions
(4104)
row subsets
(3741)
WRKRDBDIRE command
(4503), (4523)
WRKREGINF command
(4442)
WRKSBMJOB command
(4332)
WRKSBSJOB command
(4331)
[ Top of Page | Previous Page | Next Page ]