Replication Guide and Reference
A
B
C
D
E
F
G
H
I
J
L
M
N
O
P
Q
R
S
T
U
V
W
A
B
bandwidth impact, network requirements
(3727)
base aggregate target tables
control tables at the target server
(4734)
CREATE TABLE statement
(4736)
data transformation, planning
(3758)
defining
(3977)
description
(3416), (3480)
before-image columns
and change aggregate tables
(4004)
data transformation, planning
(3774), (3792)
description
(3463)
NULL value
(3467)
specifying
(3919)
usage
(3466)
binary data types
(3821)
binding the package
Apply for OS/2
(4242)
Apply for UNIX
(4352)
Apply for Windows NT and Windows 95
(4150)
Capture for OS/2
(4239)
Capture for UNIX
(4345)
Capture for Windows NT and Windows 95
(3620), (4147)
blobs (binary large objects)
(3815)
blocking factor for subscription cycle, defining
(4019)
building audit trails scenario
(3651)
C
CALL procedures
defining for the replication subscription
(4020)
run-time processing statements
(3494)
capacity requirements
Apply program
(3710)
Capture program
(3707)
Control Center
(3714)
planning
(3703)
Capture and Apply for OS/400
(3292)
Capture enqueue tables
control tables at the source server
(4668)
CREATE TABLE statement
(4670)
Capture program
alert generation (MVS)
(4064)
authorization requirements
(3739)
bandwidth impact
(3724)
capacity requirements
(3706)
Capture user ID
(3740)
capturing changes
(3350)
configuring, overview
(3617)
connectivity requirements
(3718)
control tables
(3358)
error recovery
Capture for MVS
(4061)
Capture for VM
(4569)
Capture for VSE
(4513)
for AIX
authorization for running
(4376)
binding the package
(4342)
cold start parameter
(4396)
cold start, automatic
(4441)
cold start, preventing
(4446)
configuring
(4336), (4385)
log sequence number, providing
(4425)
operating
(4317), (4379)
performance options
(4360)
post-installation tasks
(4382)
preparing for roll-forward recovery
(4339)
pruning
(4421)
reinitializing
(4417)
restrictions
(4373)
resuming
(4413)
scheduling when to start
(4401)
setting up
(4330)
starting
(4388)
stopping
(4405)
suspending
(4409)
troubleshooting information
(4484)
tuning parameters
(4361)
using
(4318)
warm start parameter
(4393), (4430)
warm start, forcing
(4449)
for HP-UX
authorization for running
(4377)
binding the package
(4343)
cold start parameter
(4397)
cold start, automatic
(4442)
cold start, preventing
(4447)
configuring
(4337), (4386)
log sequence number, providing
(4426)
operating
(4321), (4380)
performance options
(4362)
post-installation tasks
(4383)
preparing for roll-forward recovery
(4340)
pruning
(4423)
reinitializing
(4419)
restrictions
(4374)
resuming
(4415)
scheduling when to start
(4403)
setting up
(4332)
starting
(4389)
stopping
(4407)
suspending
(4411)
troubleshooting information
(4485)
tuning parameters
(4363)
using
(4322)
warm start parameter
(4394), (4431)
warm start, forcing
(4450)
for MVS
authorization for running
(4060)
cold start parameter
(4078)
cold start, automatic
(4101)
cold start, preventing
(4104)
configuring
(4074)
DB2 for MVS 3.1, determining the active log size
(3698)
error recovery
(4063)
in a data-sharing environment
(3383)
log sequence number, providing
(4093)
operating
(4040), (4072)
performance options
(4049)
post-installation tasks
(4073)
pruning
(4091)
reinitializing
(4089)
restrictions
(4058)
resuming
(4087)
scheduling when to start
(4081)
setting up
(4045)
starting
(4075)
stopping
(4083)
suspending
(4085)
troubleshooting information
(4125)
tuning parameters
(4050)
unsupported statements
(4059)
using
(4041)
warm start parameter
(4077), (4096)
warm start, forcing
(4105)
for OS/2
authorization for running
(4254)
binding the package
(4238)
cold start parameter
(4262)
cold start, automatic
(4285)
cold start, preventing
(4288)
configuring
(4236), (4257)
log sequence number, providing
(4277)
operating
(4229), (4255)
performance options
(4244)
post-installation tasks
(4256)
preparing for roll-forward recovery
(4237)
pruning
(4275)
reinitializing
(4273)
restrictions
(4253)
resuming
(4271)
scheduling when to start
(4265)
setting up
(4234)
starting
(4258)
stopping
(4267)
suspending
(4269)
troubleshooting information
(4309)
tuning parameters
(4245)
using
(4230)
warm start parameter
(4261), (4280)
warm start, forcing
(4289)
for Solaris
authorization for running
(4378)
binding the package
(4344)
cold start parameter
(4398)
cold start, automatic
(4443)
cold start, preventing
(4448)
configuring
(4338), (4387)
log sequence number, providing
(4427)
operating
(4325), (4381)
performance options
(4364)
post-installation tasks
(4384)
preparing for roll-forward recovery
(4341)
pruning
(4424)
reinitializing
(4420)
restrictions
(4375)
resuming
(4416)
scheduling when to start
(4404)
setting up
(4334)
starting
(4390)
stopping
(4408)
suspending
(4412)
troubleshooting information
(4486)
tuning parameters
(4365)
using
(4326)
warm start parameter
(4395), (4432)
warm start, forcing
(4451)
for VM
authorization for running
(4568)
cold start parameter
(4584)
cold start, automatic
(4602)
cold start, preventing
(4604)
configuring
(4580)
determining the active log size
(3700)
error recovery
(4571)
log sequence number, providing
(4597)
operating
(4552), (4578)
performance options
(4558)
post-installation tasks
(4579)
pruning
(4595)
reinitializing
(4593)
restrictions
(4567)
resuming
(4591)
setting up
(4555)
starting
(4581)
stopping
(4587)
suspending
(4589)
troubleshooting information
(4607)
tuning parameters
(4559)
using
(4553)
warm start parameter
(4583), (4600)
warm start, forcing
(4606)
for VSE
authorization for running
(4512)
cold start parameter
(4528)
cold start, automatic
(4546)
cold start, preventing
(4548)
configuring
(4524)
determining the active log size
(3699)
error recovery
(4515)
log sequence number, providing
(4541)
operating
(4496), (4522)
performance options
(4502)
post-installation tasks
(4523)
pruning
(4539)
reinitializing
(4537)
restrictions
(4511)
resuming
(4535)
setting up
(4499)
starting
(4525)
stopping
(4531)
suspending
(4533)
troubleshooting information
(4550)
tuning parameters
(4503)
using
(4497)
warm start
(4544)
warm start parameter
(4527)
for Windows NT and Windows 95
authorization for running
(4166)
binding the package
(4146)
cold start parameter
(4174)
cold start, automatic
(4197)
cold start, preventing
(4200)
configuring
(4144), (4169)
log sequence number, providing
(4189)
operating
(4137), (4167)
package name
(3619)
performance options
(4156)
post-installation tasks
(4168)
preparing for roll-forward recovery
(4145)
pruning
(4187)
reinitializing
(4185)
restrictions
(4165)
resuming
(4183)
scheduling when to start
(4177)
setting up
(4142)
starting
(3627), (4170)
stopping
(3631), (4179)
suspending
(4181)
troubleshooting information
(4221)
tuning parameters
(4157)
using
(4138)
warm start parameter
(4173), (4192)
warm start, forcing
(4201)
gap detection
(3599)
identifying external data sources
(3542)
introduction
(3349)
minimizing contention
(3883)
naming conventions
(3284)
processor requirements
(3705)
pruning CCD tables
(3519)
Service Control Manager
(4152)
staging data
(3515)
stopping with a trigger
(4646)
storage dump (MVS)
(4070)
storage dump (VM)
(4576)
storage dump (VSE)
(4520)
trace buffer (MVS)
(4066)
trace buffer (VM)
(4572)
trace buffer (VSE)
(4516)
trace output (MVS)
(4068)
trace output (VM)
(4574)
trace output (VSE)
(4518)
usage
(3352)
capturing changes, overview
(3353)
CCD (consistent change data) tables
auto-registration
(3490), (3539)
condensed, complete
(3424)
condensed, noncomplete
(3421)
control tables at the target server
(4742)
CREATE TABLE statement
(4744)
data transformation, planning
(3762), (3764)
data warehouse
(3553)
defining
(3979)
description
(3420), (3423), (3426), (3429), (3520)
external data sources
(3543)
external, refreshing
(3547)
internal
(3534), (3546)
local
(3535)
noncondensed, complete
(3430)
noncondensed, noncomplete
(3427)
remote
(3536)
restrictions
(3871)
staging changed data
(3517)
updating condensed copies
(3561)
CD (change data) tables
and consistent change data
(3516)
and the Capture program
(3351)
control tables at the source server
(4672)
CREATE TABLE statement
(4674)
description
(3374), (3521)
pruning
(3378), (3595)
change aggregate target tables
control tables at the target server
(4738)
CREATE TABLE statement
(4740)
data transformation, planning
(3760)
defining
(3978)
description
(3418), (3483)
changed data retention, planning
(3799)
changing
replication sources
(3943)
replication subscriptions
(4037)
CLOBs (character large objects)
(3816)
cloning subscriptions
(4035)
cold start
Capture for MVS
(4080)
Capture for OS/2
(4264)
Capture for UNIX
(4400)
Capture for VM
(4586)
Capture for VSE
(4530)
Capture for Windows NT and Windows 95
(4176)
gaps
(3601)
low lag limit
Capture for MVS
(4054)
Capture for OS/2
(4249)
Capture for UNIX
(4369)
Capture for VM
(4563)
Capture for VSE
(4507)
Capture for Windows NT and Windows 95
(4161)
preventing
Capture for MVS
(4102)
Capture for OS/2
(4286)
Capture for UNIX
(4444)
Capture for VM
(4603)
Capture for VSE
(4547)
Capture for Windows NT and Windows 95
(4198)
switching to automatically
Capture for MVS
(4100)
Capture for OS/2
(4284)
Capture for UNIX
(4440)
Capture for VM
(4601)
Capture for VSE
(4545)
Capture for Windows NT and Windows 95
(4196)
columns
aggregate
(3459)
before-image and after-image
(3465)
changing the definition
(3991)
computed
data transformation, planning
(3778)
defining
(3994)
creating new in target table
(3457), (3995)
defining in target table
(3986)
fragmenting
(3441)
removing from the target table
(3993)
renaming
data transformation, planning
(3776)
defining
(3990)
specifying the primary key
(3989)
subsetting
(3440), (3448), (3987)
commit interval
Capture for MVS
(4056)
Capture for OS/2
(4251)
Capture for UNIX
(4371)
Capture for VM
(4565)
Capture for VSE
(4509)
Capture for Windows NT and Windows 95
(4163)
complete
CCD tables
(3559)
data attribute
(3560)
condensed
CCD tables
(3527), (3564)
copies, updating
(3563)
staging tables
(3526)
configuring
Apply program
(3616)
Capture program
(3615)
client for mobile replication
(4634)
connectivity requirements
(3722)
Control Center for non-DB2 Universal Database RDBMs
(3896)
conflict detection
data integrity
(3855)
description
(3573)
levels
enhanced
(3861)
none
(3859)
standard
(3860)
lost or rejected transactions
(3858)
planning
(3854)
specifying
(3928)
conflicts
lost or rejected transactions
(3868)
recovering from
(3867)
consulting and services
(3314)
contention between the Capture and Apply programs
locking
(3888)
no ISOLATION (UR) support
(3881)
continuous timing
planning
(3841)
setting for the subscription
(4015)
Control Center
authorization requirements
(3737)
bandwidth impact
(3726)
capacity requirements
(3713)
configuring for non-DB2 Universal Database RDBMs
(3895)
connectivity requirements
(3720)
customizing control tables
(3338), (3343)
introduction
(3328)
managing the replication environment
(3329)
processor requirements
(3712)
replication objects, navigating to
(3891)
replication sources, navigating to
(3892)
replication subscriptions, navigating to
(3893)
setting preferences
(3897)
control server
choosing location
(3407)
defining for mobile replication
(4635)
description
(3269)
specifying
(3965)
control tables
Apply trail
(3395)
at the control server
(4707), (4708), (4712), (4716), (4720)
, (4724), (4728)
at the source server
(4666), (4667), (4671), (4675), (4679)
, (4683), (4687), (4691), (4695), (4699)
, (4703), (4741)
at the target server
(4733), (4737), (4745), (4749), (4753)
CD tables
(3373)
critical section tables
(3361)
customizing control file
description
(3341)
DPCNTL.*
(3340)
steps
(3900)
customizing SQL files, description
(3345)
estimating storage requirements
(3685)
planning for customization
(3746)
pruning
(3376), (3593)
pruning control tables
(3369)
register tables
(3359)
subscription columns
(3405)
subscription events
(3401)
subscription set
(3397)
subscription statements
(3399)
subscription targets members
(3403)
table structures, quick reference
(4664)
trace tables
(3365)
tuning parameters tables
(3363)
UOW tables
(3367)
used by Apply program
(3393)
used by Capture program
(3357)
warm start tables
(3371)
conventions
highlighting
(3262)
naming
(3282)
copies, loading large
(4120)
copy table types, comparisons
(3469)
correcting a gap
(3606)
CREATE TABLE statement
Apply trail tables
(4710)
base aggregate target tables
(4735)
Capture enqueue tables
(4669)
CCD table
(4743)
CD tables
(4673)
change aggregate target tables
(4739)
critical section tables
(4677)
point-in-time target tables
(4747)
pruning control tables
(4681)
register tables
(4685)
replica target tables
(4751)
subscription columns tables
(4714)
subscription events tables
(4718)
subscription set tables
(4722)
subscription statements tables
(4726)
subscription targets member tables
(4730)
trace tables
(4689)
tuning parameters tables
(4693)
UOW tables
(4697)
user copy target tables
(4755)
warm start tables
(4701)
for Capture for VSE and VM
(4705)
critical section tables
control tables at the source server
(4676)
CREATE TABLE statement
(4678)
description
(3362)
custom, defining replication sources
(3912)
customizing
control tables
description
(3339)
steps
(3899)
planning requirements
(3745)
SQL files
description
(3344)
steps
(3901)
D
data archive scenario
(3649)
data blocking
Apply spill file, storage requirements
(3691)
description
(3499)
DATA CAPTURE CHANGES
(3681)
data capture, specifying
(3914)
data compression restriction
(3808)
data consistency
planning
(3847)
replication subscriptions
(3462)
requirements
(3848)
data consolidation
and distribution scenario
(3645)
data transformation, planning
(3785)
data currency
effect on CPU usage
(3711)
planning
(3826)
requirements
(3827)
data encryption restriction
(3812)
data enhancements
base aggregate target tables
(3757)
before-image columns
(3773)
change aggregate target table
(3759)
column renaming
(3775)
column subsetting
(3767)
computed columns
(3777)
data consolidation
(3784)
for replication targets
(3751)
noncondensed CCD tables
(3761)
outer join of source tables
(3786)
point-in-time target tables
(3755)
poorly structured data
(3788)
row subsetting
(3770)
run-time processing
(3781)
triggers
(3779)
updateable replica target tables
(3765)
user copy target tables
(3753)
data integrity
(3602)
data sharing, data transformation requirements
(3803)
data transformation
advanced transformation
(3783)
auditing requirements
(3790)
basic enhancements
(3752)
condensed CCD tables
(3763)
data restrictions
(3806)
data sharing considerations
(3802)
Extended Enterprise Edition considerations
(3804)
mobile replication
(3795)
planning
(3749)
replication logical partitioning key
(3800)
data types, restrictions
(3813)
data warehouse
(3551)
data-sharing and Capture for MVS
(3384)
DataJoiner, using with DPROPR V1
(3307)
DataPropagator NonRelational, using with IBM Replication
(3306)
DataPropagator Relational Capture and Apply for OS/400
(3291)
DataPropagator Relational V1, support for DataJoiner
(3290)
DB2
ARCHIVE LOG command
(4130)
control intervals
(4128)
log
(3354), (3356), (4127)
DB2 Tools Settings notebook
setting replication preferences
(3898)
DB2INSTANCE
when starting Capture for OS/2
(4260)
when starting Capture for UNIX
(4392)
when starting Capture for Windows NT and Windows 95
(4172)
DBCLOBS (double-byte character large objects)
(3817)
deactivating and activating subscriptions
(4033)
decision support system scenario
(3639)
deferring replication requests
specifying
(3931), (3963)
defining
external CCD tables as sources
steps
(3936)
replication source joins
steps
(3939)
replication sources
example
(3611)
steps
(3910), (3913)
subscriptions
advanced steps
(3972)
basic steps
(3949)
example
(3613)
defining new columns
(3456)
detecting a gap
(3598)
determining the size of the log record
(3695)
distinct data type
(3824)
distributed database system scenario
(3641)
DPCNTL.* sample file
(3342)
dummy WHERE clause
(4005)
E
EDITPROCs
(3809), (3818)
education
custom classes
(3318)
IBM Global Campus URL
(3319)
enhanced conflict detection
(3864)
enhancing data, planning
(3750)
environment variables
ASNDIAL
description
(4619)
specifying for OS/2
(4627)
specifying for Windows 95
(4631)
specifying for Windows NT
(4629)
ASNHANGUP
description
(4620)
specifying for OS/2
(4628)
specifying for Windows 95
(4632)
specifying for Windows NT
(4630)
environment, understanding
(3321)
error recovery
Capture for MVS
(4062)
Capture for VM
(4570)
Capture for VSE
(4514)
event table
Apply for MVS
(4117)
Apply for OS/2
(4302)
Apply for UNIX
(4477)
Apply for Windows NT and Windows 95
(4214)
populating
(3969)
event-based timing
description
(3513)
planning
(3837)
populating event control table
(3844)
setting for the subscription
(4016)
examples
SQL for columns
(3992)
WHERE clauses
(4010)
Extended Enterprise Edition
data transformation requirements
(3805)
extending IBM Replication scenario
(3663)
external CCD tables
defining as sources
(3937)
description
(3544)
refreshing
(3548)
external data sources
(3540)
F
fast path
(3286)
FIELDPROCs
(3810), (3819)
forward recovery
Apply for MVS
(4124)
Apply for OS/2
(4308)
Apply for UNIX
(4483)
Apply for Windows NT and Windows 95
(4220)
fragmentation
horizontal
(3451)
vertical
(3446)
fragmenting target tables
(3438)
full refresh
description
(3271), (3436)
forcing
Apply for MVS
(4136)
Apply for OS/2
(4316)
Apply for UNIX
(4495)
Apply for Windows NT and Windows 95
(4228)
specifying
(3916)
suppressing
Apply for MVS
(4133)
Apply for OS/2
(4313)
Apply for UNIX
(4492)
Apply for Windows NT and Windows 95
(4225)
G
gap detection
description
(3597)
resolving
(3605)
verifying
(3603)
gap messages
for MVS
(4097)
for OS/2
(4281)
for UNIX
(4433)
for Windows NT and Windows 95
(4193)
global lock
(3887)
GROUP BY clause
(4002)
H
hardware requirements
(3674), (4615)
history data, planning
(3793)
horizontal subsetting
description
(3450)
planning
(3772)
steps
(4000)
hot-site recovery, description
(3668)
I
IBM Education resources
custom classes
(3316)
IBM Global Campus URL
(3317)
IBM Replication
consulting and services
(3315)
education
(3320)
introduction
(3324)
tools
(3289)
identifiers, ordinary and delimited
(3904)
identifying external data sources
(3541)
improved application availability scenario
(3647)
improved network load scenario
(3643)
installation
Capture and Apply for MVS
(4047)
Capture for VM
(4556)
Capture for VSE
(4500)
considerations for UNIX components
(4353)
independent, migration
(4652)
internal CCD tables
auto-registration
(3538)
description
(3531)
reducing network load
(3545)
interval timing, planning
(3834)
introduction to IBM Replication
(3325)
Apply program
(3385)
Capture program
(3347)
Control Center
(3326)
overview
(3323)
ISOLATION (UR)
contention problems
(3880)
platforms that don't support
(3879)
J
joins
defining as sources
(3940)
description
(3580), (3584)
L
lag limit
Capture for MVS
(4055)
Capture for OS/2
(4250)
Capture for UNIX
(4370)
Capture for VM
(4564)
Capture for VSE
(4508)
Capture for Windows NT and Windows 95
(4162)
large copies, loading
(4119)
large replication jobs
(3501)
legacy data sources
(3305)
loading large copies
(4118)
local CCD tables
description
(3533)
locking, how it affects contention
(3886)
log records
archived before captured
(3696)
determining the size
(3697)
log sequence number
Capture for MVS
(4094)
Capture for OS/2
(4278)
Capture for UNIX
(4428)
Capture for VM
(4598)
Capture for VSE
(4542)
Capture for Windows NT and Windows 95
(4190)
logging requirements, DBMS logging
(3680)
logical partitioning key support
description
(3381)
specifying
(3922)
logical recovery scenario
(3661)
LONG VARCHAR data type
(3822)
LONG VARGRAPHIC data type
(3823)
Lotus Notes Pump and IBM Replication
(3312)
LU sessions
(4355)
M
MAX_SYNCH_MINUTES, description
(3500)
messages
Apply program
(4760)
Capture program
(4757), (4759)
Migration
(4761)
migration
analysis
(4650)
collection
(4649)
prerequisites
(4651)
process
(4648)
migration program
analyzing data
(4656)
building
(4655)
deleting unused tables and views
(4661)
falling back to Version 1
Apply program
(4659)
Capture program
(4660)
migrating data
Apply program
(4658)
Capture program
(4657)
starting
(4654)
mincycles
defining for the subscription
(4018)
minimizing contention
(3885)
mobile replication
configuring
defining the control server
(4636)
setting up the client
(4633)
data transformation requirements
(3796)
description
(3589)
environment variables
(4618)
description
(4623)
specifying for OS/2
(4624)
specifying for Windows 95
(4626)
specifying for Windows NT
(4625)
overview
(4609)
planning
(4612)
processing cycle
(4637)
restrictions
(4610)
scenario
(3654)
Mobile Replication Enabler
mobile replication enabler
description
(3588)
starting from the command line
(4638)
starting from the graphical interface
(4640)
N
network requirements
bandwidth impact
(3723)
connectivity
(3717)
connectivity requirements
(3721)
planning
(3716)
throughput capacity
(3729)
no conflict detection
(3862)
O
occasionally connected replication
(3590)
on-demand replication
data transformation, planning
(3797)
description
(3591)
ordinary and delimited identifiers
(3903)
outer join of source tables
(3787)
P
parameter definitions
Apply for MVS
(4109)
Apply for OS/2
(4293)
Apply for UNIX
(4459)
Apply for Windows NT and Windows 95
(4205)
password files, authorization requirements
(3743)
performance options
Capture for MVS
(4048)
Capture for OS/2
(4243)
Capture for UNIX
(4359)
Capture for VM
(4557)
Capture for VSE
(4501)
Capture for Windows NT and Windows 95
(4155)
planning
active log size, storage requirements
(3694)
application level
(3747)
capacity requirements
(3702)
contention
minimizing
(3882)
platforms with no ISOLATION (UR) support
(3878)
customization requirements
(3744)
data consistency
(3846)
data currency
(3825)
data transformation
(3748)
hardware requirements
(3672)
mobile replication
(4613)
network requirements
(3715)
processor requirements
(3704)
replication products
(3670)
security and authorization requirements
(3734)
software requirements
(3673), (3677)
storage requirements
(3676)
system level
(3669)
update anywhere
(3852)
CCD tables
(3869)
conflict detection
(3856)
recommended usage
(3872)
recovering from conflicts
(3865)
restrictions
(3875)
planning for IBM Replication
(3633)
point-in-time target tables
compare to aggregate table
(3474)
control tables at the target server
(4746)
CREATE TABLE statement
(4748)
data transformation, planning
(3756)
defining
(3976)
description
(3413), (3473)
usage
(3478)
poorly structured data, data transformation
(3789)
potential replication scenarios
(3656)
predicates, defining for target tables
examples
(4008)
primary key
errors when updating
(3454)
logical partitioning
(3380)
point-in-time target table
(3414)
user copy target table
(3411)
programming interface information
(4762)
PRTCT
(4356)
prune interval
Capture for MVS
(4057)
Capture for OS/2
(4252)
Capture for UNIX
(4372)
Capture for VM
(4566)
Capture for VSE
(4510)
Capture for Windows NT and Windows 95
(4164)
pruning
Capture for MVS
(4092)
Capture for OS/2
(4276)
Capture for UNIX
(4422)
Capture for VM
(4596)
Capture for VSE
(4540)
Capture for Windows NT and Windows 95
(4188)
CCD tables
(3518)
CD and UOW tables
(3377), (3594)
condensed CCD tables
(3528)
pruning control tables
control tables at the source server
(4680)
CREATE TABLE statement
(4682)
description
(3370)
push and pull Apply program configuration
choosing a configuration
(3568)
compared
(3566)
data transformation, planning
(3798)
description
(3565)
Q
quick, defining replication sources
(3909)
R
recommended replication scenarios
(3636)
referential integrity
planning
(3851)
replication subscriptions
(3461)
refresh copying
description
(3435)
external CCD tables
(3549)
specifying
(3917)
specifying for replication objects
(3934), (3968)
refresh, suppressing
Apply for MVS
(4135)
Apply for OS/2
(4315)
Apply for UNIX
(4494)
Apply for Windows NT and Windows 95
(4227)
register tables
control tables at the source server
(4684)
CREATE TABLE statement
(4686)
description
(3360)
reinitializing
Capture for MVS
(4090)
Capture for OS/2
(4274)
Capture for UNIX
(4418)
Capture for VM
(4594)
Capture for VSE
(4538)
Capture for Windows NT and Windows 95
(4186)
relative timing
description
(3511)
planning
(3832)
setting for the subscription
(4014)
remote CCD tables
(3532)
removing
replication sources
(3945)
replication subscriptions
(4039)
replica target tables
auto-registration
(3491)
control tables at the target server
(4750)
CREATE TABLE statement
(4752)
data transformation, planning
(3766)
defining
(3981)
description
(3432), (3486)
update-anywhere replication, description
(3570)
replication
before-image columns, specifying
(3921)
conflict detection, specifying
(3929)
description
(3264)
full refresh, description
(3272)
introduction
Apply program
(3386)
Capture program
(3348)
Control Center
(3327)
logical partitioning key support, specifying
(3923)
mobile replication enabler, description
(3586)
objects, description
(3331)
on demand, description
(3587)
overview of tools and concepts
(3322)
potential usage scenarios
(3657)
products, description
(3671)
recommended usages scenarios
(3637)
request, deferring
(3932), (3964)
sources
(3333)
subscriptions
(3334)
supported environments
DataJoiner
(3296), (3301), (3304)
DB2 family
(3293), (3298)
IMS and VSAM
(3294), (3299), (3303)
Lotus Notes
(3311)
Lotus NotesPump
(3297), (3302)
Non-DB2
(3295), (3300), (3308)
tables
(3332)
update anywhere
(3281)
ASNDONE user exit
(3577)
conflict detection
(3574)
description
(3571)
specifying
(3926)
update copying, description
(3274)
replication interval, planning
(3828)
replication logical partitioning key, data transformation requirements
(3801)
replication scenarios not recommended
(3664)
replication sources
changing
(3942)
conflict detection
(3930)
defining
custom
(3911)
example
(3612)
external CCD
(3935)
for update anywhere
(4644)
joins
(3938)
overview
(3907)
with default values
(3908)
description
(3275), (3335)
example of creating
(3608)
overview
(3905)
removing
(3944)
selecting
(3558)
specifying before-image columns
(3920)
specifying data capture
(3915)
specifying refresh copying
(3918)
specifying replication logical partitioning key support
(3924)
specifying update-anywhere replication
(3927)
types
(3906)
views
(3578)
replication subscriptions
activating and deactivating
(4031)
and the Apply qualifier
(3392)
changing
(4036)
cloning
(4034)
completing the definition
(3962)
continuous
(3840)
data consistency
(3849)
defining
advanced steps
(3971)
basic steps
(3948)
example
(3614)
overview
(3947)
defining columns
(3985)
defining for update anywhere
(4645)
defining minicycles
(4017)
defining rows
(3997)
defining run-time processing
(4022)
defining target table structure
(3961), (3983)
defining the control server
(3966)
defining the target table type
(3974)
description
(3277), (3279), (3337), (3460), (3556)
event-based timing
(3836), (3843)
example of creating
(3607)
interval timing
(3830)
naming
(3950)
overview
(3946)
referential integrity
(3850)
relative timing
(3831)
removing
(4038)
run-time processing statements
(3497), (3498), (3503), (3504)
selecting user-defined target tables
(3959)
setting the timing
(4012)
specifying the Apply qualifier
(3954)
specifying the target server
(3952)
specifying the target table name
(3957)
timing
(3507)
triggering events
(3970)
views
(3582)
replication targets
(3278)
restrictions
data types
(3814)
Extended Enterprise Edition
(3894)
mobile replication
(4611)
update anywhere
(3877)
resuming
Capture for MVS
(4088)
Capture for OS/2
(4272)
Capture for UNIX
(4414)
Capture for VM
(4592)
Capture for VSE
(4536)
Capture for Windows NT and Windows 95
(4184)
retention limit
Capture for MVS
(4053)
Capture for OS/2
(4248)
Capture for UNIX
(4368)
Capture for VM
(4562)
Capture for VSE
(4506)
Capture for Windows NT and Windows 95
(4160)
road map of this book
(3287)
rows
defining in target table
(3998)
defining the predicate
(4007)
restrictions for subsetting
(4001)
subsetting
(3453), (3999)
run-time processing
data transformation, planning
(3782)
defining for the subscriptions
(4023)
statements
(3492)
S
scenarios
building audit trails
(3650)
creating a user copy target table
(3609)
customer implementations
(3634), (3635), (3655)
data archive
(3648)
data consolidation and distribution
(3644)
decision support system
(3638)
distributed database system
(3640)
extending IBM Replication
(3662)
improved application availability
(3646)
improved network load
(3642)
logical recovery
(3660)
mobile replication
(3653)
not recommended
hot-site recovery
(3667)
synchronous replication
(3665)
update-anywhere replication
(3658)
scheduling
Apply for MVS
(4112)
Apply for OS/2
(4297)
Apply for UNIX
(4468)
Apply for Windows NT and Windows 95
(4209)
Capture for MVS
(4082)
Capture for OS/2
(4266)
Capture for UNIX
(4402)
Capture for Windows NT and Windows 95
(4178)
event table
for Apply for MVS
(4116)
for Apply for OS/2
(4301)
for Apply for UNIX
(4476)
for Apply for Windows NT and Windows 95
(4213)
event timing
(3512)
relative timing
(3510)
replication subscriptions
(3506)
SECACPT
(4357)
security and authorization requirements, planning
(3735)
selection order for source table
(3554)
servers
control
(3270)
source
(3266)
target
(3268)
Service Control Manager
Apply for Windows NT
(4154)
Capture for Windows NT
(4153)
services and consulting
(3313)
setting up the Capture and Apply programs
for MVS
(4044)
for OS/2
(4233)
for UNIX
(4329)
for Windows NT and Windows 95
(4141)
setting up the Capture program
for VM
(4554)
for VSE
(4498)
soft errors
(4758)
software requirements
(3675), (4614)
solution, data replication
(3288)
source server
(3265)
source tables
table structures, quick reference
(4663)
sources
multivendor
(3309), (3310)
selection order
(3555)
views
(3581)
SQL
before and after, description
(3495)
files
customizing, steps
(3902)
description
(3346)
statements
defining for the replication subscription
(4021)
run-time processing
(3493)
staging data
benefits of
(3530)
data warehouse
(3550)
description
(3514)
staging table
attributes
(3523)
complete
(3525)
condensed
(3529)
defining
(3980)
ways to use
(3524)
standard conflict detection
(3863)
starting
Apply for MVS
(4108)
Apply for OS/2
(4292)
Apply for UNIX
(4458)
Apply for Windows NT and Windows 95
(3626), (4204)
Capture for MVS
(4076)
Capture for OS/2
(4259)
Capture for UNIX
(4391)
Capture for VM
(4582)
Capture for VSE
(4526)
Capture for Windows NT and Windows 95
(3625), (4171)
migration program
(4653)
stopping
Apply for MVS
(4114)
Apply for OS/2
(4299)
Apply for UNIX
(4474)
Apply for Windows NT and Windows 95
(3630), (4211)
Capture for MVS
(4084)
Capture for OS/2
(4268)
Capture for UNIX
(4406)
Capture for VM
(4588)
Capture for VSE
(4532)
Capture for Windows NT and Windows 95
(3629), (4180)
storage dump (MVS)
(4071)
storage dump (VM)
(4577)
storage dump (VSE)
(4521)
storage requirements
active log size
(3692)
Apply spill file
(3686)
data blocking for large volumes
(3689)
DBMS logging
(3679)
general considerations
(3701)
new tables
(3682)
planning
(3678)
UOW table size
(3684)
virtual memory on MVS
(3688)
subscription columns tables
control tables at the control server
(4713)
CREATE TABLE statement
(4715)
description
(3406)
subscription events tables
control tables at the control server
(4717)
CREATE TABLE statement
(4719)
description
(3402)
subscription set tables
control tables at the control server
(4721)
CREATE TABLE statement
(4723)
description
(3398)
subscription sets
description
(3276)
subscription statements tables
control tables at the control server
(4725)
CREATE TABLE statement
(4727)
description
(3400)
subscription targets member tables
control tables at the control server
(4729)
CREATE TABLE statement
(4731)
subscription targets members tables
description
(3404)
subsetting
columns, planning
(3768)
horizontal
(3452)
rows, planning
(3771)
source tables, description
(3443)
vertical
(3447)
suppressing full refresh
Apply for MVS
(4134)
Apply for OS/2
(4314)
Apply for UNIX
(4493)
Apply for Windows NT and Windows 95
(4226)
suspending
Capture for MVS
(4086)
Capture for OS/2
(4270)
Capture for UNIX
(4410)
Capture for VM
(4590)
Capture for VSE
(4534)
Capture for Windows NT and Windows 95
(4182)
synchronous replication, description
(3666)
syntax diagrams, how to read
(3285)
T
table structures
(4662)
tables
pruning
advanced concepts
(3592)
description
(3375)
tuning parameters
Capture for MVS performance
(4051)
Capture for OS/2 performance
(4246)
Capture for UNIX performance
(4366)
Capture for VM performance
(4560)
Capture for VSE performance
(4504)
Capture for Windows NT and Windows 95 performance
(4158)
target server
description
(3267)
specifying
(3951)
target tables
at the target server
(4732)
auto-registration
(3489)
base aggregate
(3415), (3479)
CCD
condensed, complete
(3422)
condensed, noncomplete
(3419)
description
(3522)
noncondensed, complete
(3428)
noncondensed, noncomplete
(3425)
change aggregate
(3417), (3482)
columns, defining
(3984)
comparisons between types
(3468)
defining for update anywhere
(4643)
fragmenting
(3439)
names, specifying
(3956)
new columns, description
(3455)
new, storage requirements
(3683)
point-in-time
(3412), (3472)
replica
(3431), (3485)
rows, defining
(3996)
specifying a type
(3973)
structure, specifying
(3960), (3982)
subsetting columns
(3444)
subsetting rows
(3449)
table structures, quick reference
(4665)
types
(3408)
user copy
(3409), (3470)
user-defined
(4025)
targets
description
(3336)
views
(3585)
terminology
(3263)
throughput capacity
approach to estimating
(3733)
factors influencing
(3731)
network requirements
(3730)
timing
continuous
(3842)
defining for the subscription
(4013)
event-based
(3838), (3845)
interval
(3833)
relative
(3835)
replication subscriptions
(3508)
Subscription Timing notebook
(3839)
trace buffer (MVS)
(4067)
trace buffer (VM)
(4573)
trace buffer (VSE)
(4517)
trace output (MVS)
(4069)
trace output (VM)
(4575)
trace output (VSE)
(4519)
trace tables
control tables at the source server
(4688)
CREATE TABLE statement
(4690)
description
(3366)
transaction identification, planning
(3794)
triggers
data transformation, planning
(3780)
stopping the Capture program
(4647)
troubleshooting information
Apply for MVS
(4132)
Apply for OS/2
(4312)
Apply for UNIX
(4491)
Apply for Windows NT and Windows 95
(4224)
Capture for MVS
(4126)
Capture for OS/2
(4310)
Capture for UNIX
(4487)
Capture for VM
(4608)
Capture for VSE
(4551)
Capture for Windows NT and Windows 95
(4222)
tuning parameters
Capture for MVS
(4052)
Capture for OS/2
(4247)
Capture for UNIX
(4367)
Capture for VM
(4561)
Capture for VSE
(4505)
Capture for Windows NT and Windows 95
(4159)
tuning parameters tables
control tables at the source server
(4692)
CREATE TABLE statement
(4694)
description
(3364)
U
unit-of-work (UOW) tables
and the Capture program
(3355)
control tables at the source server
(4696)
CREATE TABLE statement
(4698)
description
(3368)
pruning
(3379), (3596)
update copying
(3273), (3437)
update-anywhere replication
ASNDONE user exit
(3575)
CCD tables
(3870)
conflict detection
(3572), (3857)
defining sources and targets
(4642)
description
(3280), (3569)
planning
(3853)
recommended usage
fragmentation by key
(3873)
fragmentation by time
(3874)
recovering from conflicts
(3866)
restrictions
(3876)
scenario
(3659)
specifying for sources
(3925)
updated primary key columns
(3382)
updating condensed copies, with changed data
(3562)
user copy target tables
control tables at the target server
(4754)
CREATE TABLE statement
(4756)
data transformation, planning
(3754)
defining
(3975)
description
(3410), (3471)
scenario for creating
(3610)
user exit program
ASNDIAL
(4621)
ASNHANGUP
(4622)
user-defined target tables
CCD table
(4030)
condensed
(4026)
maintaining
(4029)
selecting
(4028)
specifying
(3958)
subscriptions
(4024)
unique indexes for
(4027)
utility capture restrictions
(3811)
V
VALIDPROCs
(3820)
VERIFY
(4358)
verifying a gap
(3604)
verifying the replication request
steps
(3933), (3967)
vertical subsetting
description
(3445)
planning
(3769)
steps
(3988)
views
defining as sources
(3941)
description
(3579), (3583)
W
warehouse database
(3552)
warm start
Capture for MVS
(4079)
Capture for OS/2
(4263)
Capture for UNIX
(4399)
Capture for VM
(4585)
Capture for VSE
(4529)
Capture for Windows NT and Windows 95
(4175)
forcing
Capture for MVS
(4103)
Capture for OS/2
(4287)
Capture for UNIX
(4445)
Capture for VM
(4605)
Capture for VSE
(4549)
Capture for Windows NT and Windows 95
(4199)
switching to cold start
Capture for MVS
(4095)
Capture for OS/2
(4279)
Capture for UNIX
(4429)
Capture for VM
(4599)
Capture for VSE
(4543)
Capture for Windows NT and Windows 95
(4191)
warm start tables
control tables at the source server
(4700)
CREATE TABLE statement
(4702)
description
(3372)
for Capture for VSE and VM
(4704)
CREATE TABLE statement
(4706)
WHERE clause
dummy
(4006)
examples
(4009)
filtering rows
(4011)
restrictions
(4003)
This section lists ways you can get more information from
IBM.
If you have a technical problem, please take the time to review and carry
out the actions suggested by the Troubleshooting
Guide before contacting DB2 Customer Support. Depending on the nature of your
problem or concern, this guide will suggest information you can gather to help
us to serve you better.
For information or to order any of the Database Server products contact an
IBM representative at a local branch office or contact any authorized IBM
software remarketer.
Telephone
If you live in the U.S.A., call one of the following numbers:
- 1-800-237-5511 to learn about available service options.
- 1-800-IBM-CALL (1-800-426-2255) or 1-800-3IBM-OS2 (1-800-342-6672) to
order products or get general information.
- 1-800-879-2755 to order publications.
For information on how to contact IBM outside of the United States, see
Appendix A of the IBM Software Support Handbook. You can access this document
by selecting the "Roadmap to IBM Support" item at:
http://www.ibm.com/support/.
Note that in some countries, IBM-authorized dealers should contact
their dealer support structure instead of the IBM Support Center.
- World Wide Web
- http://www.software.ibm.com/data/
http://www.software.ibm.com/data/db2/library/
The DB2 World Wide Web pages provide current DB2 information about news,
product descriptions, education schedules, and more. The DB2 Product and
Service Technical Library provides access to frequently asked questions,
fixes, books, and up-to-date DB2 technical information. (Note
that this information may be in English only.)
- Anonymous FTP Sites
- ftp.software.ibm.com
Log on as anonymous. In the directory /ps/products/db2, you can find
demos, fixes, information, and tools concerning DB2 and many related products.
- Internet Newsgroups
- comp.databases.ibm-db2, bit.listserv.db2-l
These newsgroups are available for users to discuss their experiences with
DB2 products.
- CompuServe
- GO IBMDB2 to access the IBM DB2 Family forums
All DB2 products are supported through these forums.
To find out about the IBM Professional Certification Program for Database
Server, go to http://www.software.ibm.com/data/db2/db2tech/db2cert.html
|
[ Top of Page | Previous Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]