Replication Guide and Reference

Index

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

$TA JES2 command (4245)

Numerics

0509 (4159)

1032 (4175)

1067 (4166)

22517 (4161)

330 (4160)

51002 (4168)

57019 (4176)

741 (4752)

805 (4167)

activating subscription sets (4136)

active log size (3696)

ADDEXITPGM command (4327)

ADDJOBSCDE command (4396)

administration

authorization requirements (3926)

timing recommendation (3689)

administration interfaces

Control Center (3434)

DJRA (DataJoiner Replication Administration) tool (3437)

overview (3432)

after-image columns (3465), (3765)

aggregate tables (3506)

See also base aggregate tables, change aggregate tables (3507)

analyzing

Apply program performance (3676)

Capture program performance (3677)

ANZDPRJRN command (4321)

APF authorization (4106), (4152)

application data prerequisites (3620)

Apply job tables (4919)

Apply program

Apply qualifier (3479)

authorization requirements (3930)

binding in DB2 (4804)

capacity planning (3684)

configuring (3603), (4104)

connectivity (3723)

data blocking (3739)

error recovery (4977)

for AS/400

installing (4267)

invocation parameters (4391)

operating (4378)

scheduling (4393)

setting up (4259), (4266)

starting (4388)

stopping (4399)

for OS/390

installing (4189)

invocation parameters (4240)

operating (4182), (4233)

scheduling (4241)

setting up (4186)

starting (4235)

stopping (4247)

for UNIX platforms

binding (4421)

configuring (4419)

invocation parameters (4481)

operating (4409), (4474)

scheduling (4482)

setting up (4414)

starting (4476)

stopping (4486)

for Windows and OS/2

binding (3604), (4503)

configuring (4501)

invocation parameters (4572)

operating (4491), (4563)

scheduling (4573)

Service Control Manager for Windows (4508)

setting up (4496)

starting (4565)

stopping (4577)

full versus differential refresh (3460)

gap detection (4121)

introduction (3444)

local client (4770)

log file (4985)

messages (5056)

mini-cycles (3740)

operating (4101)

performance (4758)

post-installation tasks (4103)

problem determination (4978)

processing cycle (4046)

processor requirements (3683)

push and pull configurations (3731)

run-time processing statements (3774)

setting up (4075)

spill files, storage requirements (3718)

starting

example for Windows (3608)

instructions (4105)

overview (3636)

starting with event (3963)

stopping example for Windows (3614)

synchronization with Capture triggers (3888)

trace files (4982)

user ID (3931)

Apply qualifier (3480), (3599)

Apply trail tables

description (4916)

problem determination (4980)

Apply-qualifier-cross-reference tables (4878)

apply_name.ini file (4759)

ARCHIVE LOG command (4156)

archived log restrictions (3790)

archiving information, example (3570)

ASCII tables (3814)

ASN0000E message (4153)

ASNAPPLY command

for UNIX platforms (4479)

for Windows and OS/2 (4570)

ASNARUN command (4238)

ASNCCP command

for UNIX platforms (4434)

for VM and VSE (4594)

for Windows and OS/2 (4523)

ASNCMD command

for UNIX platforms (4449)

for Windows and OS/2 (4538)

ASNCOPY

command (4732)

parameter definitions (4735)

ASNDIAL environment variable (4705)

ASNDONE exit routine

for AS/400 (4403)

rejected transactions (3951)

using (4082)

ASNHANGUP environment variable (4706)

ASNJDONE exit routine (4671)

ASNJET command (4661)

ASNJSTOP command (4667)

ASNL2RNx command (4197)

ASNLOAD exit routine

error handling (4081)

files generated (4079), (4080)

for AS/400

parameters (4407)

samples (4406)

refreshing point-in-time tables (4076)

ASNMOBIL command (4737)

ASNSAT command (4643)

ASNSTOP command

for UNIX platforms (4489)

for Windows and OS/2 (4580)

asynchronous replication

scheduling (3536)

suitable configurations (3547)

unsuitable configurations (3550)

AT command

Apply program

for UNIX platforms (4485)

for Windows (4576)

Capture program

for UNIX platforms (4443)

for Windows (4532)

AT NetView command

Apply for OS/390 (4246)

Capture for OS/390 (4207)

auditing

archive information (3569)

data usage (3819)

authentication, end-user

for DataPropagator for Microsoft Jet (4656)

for UNIX platforms (4424)

for Windows and OS/2 (4505)

authorization requirements

Capture and Apply programs (3923)

for AS/400 (4282)

base aggregate tables

defining (3976)

description (4943)

introduction (3509)

before-image columns

auditing (3820)

change-aggregate tables (4009)

introduction (3467)

replicating (3762)

restrictions (3786)

binary data types (3803)

binary large object (BLOB) (3778), (3808)

BIND PACKAGE utility (3670)

binding

Apply program

for OS/2 (4726)

for the mobile client (4722)

for UNIX platforms (4422)

for Windows and OS/2 (4504)

Capture program

for UNIX platforms (4418)

for Windows (3602)

for Windows and OS/2 (4500)

DJRA source, target, and control servers (4800)

host RDBMSs (3898)

replication components (4802)

BLOB (binary large object) (3779), (3809)

blocking factor (3737), (4031)

CALL procedures

before and after run-time processing (3773)

defining for subscription set (4020)

capacity planning (3679)

Capture enqueue tables (4861)

Capture program

authorization requirements (3927)

binding in DB2 (4803)

capacity planning (3682)

cold start

automatic (4094)

preventing (4097)

configuring (3600), (4087)

connectivity (3722)

error recovery

for AS/400 (5030)

for VM and VSE (5016)

errors (4988)

for AS/400

attributes, changing (4276)

authorization requirements (4281)

cold start parameter (4374)

cold start, automatic (4375)

current receiver size (3703)

error recovery (5032)

initializing (4366)

installing (4265)

journal entry types (4377)

journals and journal receivers, managing (4306)

operating (4343)

performance options (4277)

problem determination (5033)

progress, determining (4328)

pruning (4369)

restrictions (4289)

scheduling (4354)

setting up (4258), (4264)

starting (4346)

starting automatically (4351)

stopping (4358)

tuning parameters (4274), (4278)

warm start parameter (4372)

for OS/390

alert generation (5005)

captured log progress (4228)

cold start parameter (4199)

error recovery (5002)

installing (4188)

operating (4179), (4190)

problem determination (5003)

pruning (4224)

reinitializing (4220)

restrictions (4192)

resuming (4216)

scheduling (4203)

setting up (4185)

starting (4194)

stopping (4208)

storage dump (5012)

suspending (4212)

trace buffer (5007)

trace output (5009)

warm start parameter (4198)

for UNIX platforms

binding (4417)

cold start parameter (4437)

configuring (4415)

log progress, displaying (4466)

log sequence number (4468)

operating (4408), (4426)

pruning (4462)

reinitializing (4458)

restrictions (4428)

resuming (4454)

scheduling (4440)

setting up (4413)

starting (4430)

stopping (4444)

suspending (4450)

warm start parameter (4436)

for VM and VSE

active log size (3702)

cold start parameter (4597)

error recovery (5018)

log progress, displaying (4622)

log sequence number (4620)

operating (4581), (4585)

problem determination (5019)

pruning (4616)

reinitializing (4612)

restrictions (4587)

resuming (4608)

setting up (4583)

starting (4591)

stopping (4600)

storage dump (5021), (5026)

suspending (4604)

trace output (5023)

warm start parameter (4596)

for Windows and OS/2

binding (3601), (4499)

cold start parameter (4526)

configuring (4497)

log progress, displaying (4557)

log sequence number (4555)

operating (4490), (4513)

pruning (4551)

reinitializing (4547)

restrictions (4515)

resuming (4545)

scheduling (4529)

Service Control Manager for Windows (4507)

setting up (4495)

starting (4517)

stopping (4533)

suspending (4539)

warm start parameter (4525)

gap detection (4120)

introduction (3442)

log file (4998)

messages (5053)

nonrelational data sources, identifying (3877)

operating (4084)

post-installation tasks (4086)

problem determination (4989)

processor requirements (3681)

pruning

CD tables (3829)

example (3612)

reinit command (3938)

replication sources, recognizing new (3939)

restrictions (4073)

setting up (4064)

staging data (3825)

starting

example for Windows (3607)

instructions (4088)

overview (3637)

stopping

example for Windows (3613)

with event (4100)

trace files problem determination (4997)

trace table problem determination (4993)

user ID (3928)

warm start (4092), (4098)

Capture triggers

capturing changes (4744)

introduction (3443), (4743)

maintaining CCD tables (3520)

pre-existing triggers (4750)

relationships to other tables (4749)

synchronization with Apply program (3887)

captured log progress

for OS/390 (4229)

for UNIX platforms (4467)

for VM and VSE (4623)

for Windows and OS/2 (4558)

CCD (consistent-change-data) tables

as replication sources (3873)

Capture triggers (4745)

change-capture mechanisms (3523)

complete (3846)

condensed (3852), (4935)

defining (3972)

description (3833), (4932)

external (3859), (4054)

internal (3858)

local (3840)

noncomplete (3847)

noncondensed (3853)

nonrelational data sources (3878)

pruning (3885), (4112)

remote (3841)

restriction (3560)

staging changed data (3826)

types of (3513)

update-anywhere replication (3838)

uses of (3865)

CCSID translation (4164)

CD (change data) tables

description (3830), (4891)

pruning (3883)

storage requirements (3709)

change aggregate tables

defining (3977)

description (4947)

introduction (3511)

change data (CD) tables

description (3831), (4890)

pruning (3884)

storage requirements (3710)

change-capture

components (3440)

for CCD tables (3522)

process

restarting (3644)

starting (3641)

changing

replication sources (4127)

subscription sets (4144)

character large object (CLOB) (3780), (3810)

CHGDPRCAPA command (4279)

CHGJRN command (4315)

classes, education (5078)

clients

connecting (4774), (4784)

connecting DJRA to DB2 DataJoiner (4790)

local (4769)

satellite (4629)

CLOB (character large object) (3781), (3811)

cloning subscription sets (4141)

CNTRLSVR.REX file (4813)

cold start

automatic (4093)

Capture program

for AS/400 (4373)

for OS/390 (4201), (4599)

for UNIX platforms (4439)

for Windows and OS/2 (4528)

general (4090)

gaps (4122)

preventing (4095)

columns

after-image (3469), (3764)

available for replication (3751)

before-image (3468), (3763)

changing definition (3991)

computed (3768), (3994)

creating new in target table (3995)

defining in target table (3985)

names, restrictions (3787)

primary key, specifying (3989)

relative record numbers on AS/400 (4341)

removing from target table (3993)

renaming (3766), (3990)

subsetting

DB2 Control Center (3987)

DJRA (3998)

introduction (3484)

planning (3747)

commands

$TA JES2

Apply for OS/390 (4243)

Capture for OS/390 (4205)

ADDEXITPGM (4326)

ADDJOBSCDE (4395)

ANZDPRJRN (4320)

ASNAPPLY

for UNIX platforms (4478)

for Windows and OS/2 (4569)

ASNARUN (4237)

ASNCCP

for UNIX platforms (4433)

for VM and VSE (4593)

for Windows and OS/2 (4522)

ASNCMD

for UNIX platforms (4448)

for Windows and OS/2 (4537)

ASNCOPY (4733)

ASNJET (4662)

ASNJSTOP (4668)

ASNL2RNx (4196)

ASNMOBIL (4738)

ASNSAT (4642)

ASNSTOP

for UNIX platforms (4488)

for Windows and OS/2 (4579)

Apply for UNIX platforms (4484)

Apply for Windows (4575)

Capture for UNIX platforms (4442)

Capture for Windows (4531)

AT NetView

Apply for OS/390 (4244)

Capture for OS/390 (4206)

BIND PACKAGE (3666)

CHGDPRCAPA (4280)

CHGJRN (4314)

CRTDPRPKG (4381)

CRTDPRTBL (4272), (4385)

CRTJRN (4298)

CRTJRNRCV (4296)

DB2LFSN

for UNIX platforms (4472)

for Windows and OS/2 (4561)

db2synch (4639)

DPCNTL.SAT (4637)

DSPJRN (4332)

ENDDPRAPY (4398)

ENDDPRCAP (4361)

ENDJOB (4363)

GETLSEQ

for OS/390 (4231)

for UNIX platforms (4470)

for VM and VSE (4624)

for Windows and OS/2 (4559)

GRTDPRAUT (4284)

INZDPRCAP (4365)

LOADX (3609)

PRUNE

for OS/390 (4226)

for UNIX platforms (4464)

for VM and VSE (4618)

for Windows and OS/2 (4552)

RCVJRNE (4307)

REINIT

for OS/390 (4222)

for UNIX platforms (4460)

for VM and VSE (4614)

for Windows and OS/2 (4549)

replication sources, recognizing new (3937)

REORG (3655), (3668)

RESUME

for OS/390 (4218)

for UNIX platforms (4456)

for VM and VSE (4610)

for Windows and OS/2 (4541)

REVOKE (3667)

RGZPFM (3654)

RMVEXITPGM (4322)

RUNSTATS (3656), (3669)

RVKDPRAUT (4287)

SBMJOB (4356)

STOP

for OS/390 (4210)

for UNIX platforms (4446)

for VM and VSE (4602)

for Windows and OS/2 (4535)

STRDPRAPY (4387)

STRDPRCAP (4345)

STRJRNPF (4302)

STRSBS (4353)

SUSPEND

for OS/390 (4214)

for UNIX platforms (4452)

for VM and VSE (4606)

for Windows and OS/2 (4543)

WRKRDBDIRE (4383), (4401)

WRKREGINF (4324)

WRKSBMJOB (5036)

WRKSBSJOB (5035)

commit interval (4071)

communication

log-based (3446)

trigger-based (3448)

complete CCD tables (3516), (3850)

components

See also Apply program, Capture program, Capture triggers, Control Center, DJRA (DB2 DataJoiner Replication Administration) tool (3419)

administration interfaces (3433)

communication between (3445)

introduction (3418)

computed columns (3769), (3996)

concepts

after-image columns (3464)

Apply qualifier (3478)

before-image columns (3466)

change capture (3441)

column subsetting (3488)

conflict detection (3470)

control tables (3420)

differential-refresh copying (3458)

full-refresh copying (3456)

joins (3493)

logical servers (3422)

replication (3450)

replication sources (3451)

row subsetting (3487)

subscription sets (3472)

subscription-set members (3474)

subsetting source tables (3483)

table partitioning (3485)

target tables (3499)

unions (3494)

user tables (3453)

views as sources (3491)

condensed CCD tables

introduction (3518)

overview (3856)

updating (4936)

condensing hot-spot updates (3870)

configuration, replication

changing (3642)

copying (3645)

modifying (4124)

operating (3647)

planning, overview (3617)

setting up, overview (3628)

configuring

Apply program

for satellite (4645)

for UNIX platforms (4420)

for Windows and OS/2 (4502)

Capture program

for satellite (4644)

for UNIX platforms (4416)

for Windows and OS/2 (4498)

connectivity (3727), (3900)

Control Center for host RDBMSs (3896)

mobile replication

clients (4719)

control servers (4729)

for OS/2 (4724)

conflict detection

introduction (3471)

levels of (3942)

mobile environment (3943)

overview (3948)

conflict tables (4685), (4955)

connecting

databases in DB2 DataJoiner (4772), (4782)

databases to DJRA (4787)

connectivity (3721), (3899)

consistent-change-data (CCD) tables

as replication sources (3874)

Capture triggers (4746)

change-capture mechanisms (3524)

complete (3848)

condensed (3854), (4934)

defining (3973)

description (3834), (4931)

external (3861), (4055)

internal (3860)

local (3842)

noncomplete (3849)

noncondensed (3855)

nonrelational data sources (3879)

pruning (3886), (4113)

remote (3843)

staging changed data (3827)

types of (3514)

update-anywhere replication (3839)

uses of (3866)

consolidating data (3572)

constraints, referential (3626)

consulting and services (5071)

Control Center

authorization requirements (3924)

capacity planning (3686)

columns, defining (3988)

configuring for host RDBMSs (3895)

connectivity (3724)

introduction (3436)

processor requirements (3685)

replication sources

changing (4129)

defining (3935)

removing (4133)

rows, defining (4004)

setting preferences (3901)

setting up replication (3894)

SQL statements and stored procedures (4025)

subscription sets

activating (4138)

changing (4145)

cloning (4142)

deactivating (4139)

defining (3961)

removing (4150)

timing (4036)

target-table type, choosing (3969)

tutorial (3592)

user-defined tables (4019)

control servers

defining for mobile replication (4727)

for DB2 replication (3431)

control tables

Apply job (4918)

Apply trail (4915)

Apply-qualifier-cross-reference (4877)

at the control server (4843), (4893)

at the source server (4841), (4847)

at the target server (4845), (4921)

authorization requirements for AS/400 (4336)

base aggregate (4942)

Capture enqueue (4860)

CCD target (4930)

CD (4889)

change aggregate (4946)

conflict (4684), (4954)

creating

DJRA (3916)

DPCNTL files (3909)

for AS/400 (4273)

critical section (4868)

CRTDPRTBL command (4270)

customizing, example (3594)

DataPropagator for Microsoft Jet (4678)

error information (4686), (4957)

error messages (4688), (4960)

error-side-information (4690), (4963)

granting authority for AS/400 (4285)

introduction (3421)

key string (4692), (4966)

location of (3622)

point-in-time (4926)

prune lock (4871)

pruning control (4854)

pruning of, overview (3651)

quick reference

at a glance (4839)

control server (4842)

source server (4840)

target server (4846)

replica (4938)

revoking authority for AS/400 (4288)

row-replica (4950)

row-replica-target-list (4679), (4906)

storage requirements (3707)

subscription columns (4900)

subscription events (4912)

subscription set (4894)

subscription statements (4903)

subscription-schema-changes (4681), (4909)

subscription-targets-member (4897)

synchronization generations (4694), (4969)

trace (4874)

tuning parameters (4857)

UOW (4883)

user copy (4922)

warm start (4863)

warm start for VSE and VM (4865)

conversion, data types (4829)

copies, types of refresh (3461)

copying replication configuration (4062)

country code, DB2CODEPAGE (4794)

creating control tables

CRTDPRTBL command (4269)

DJRA (3915)

DPCNTL files (3908)

critical section tables (4869)

CRTDPRPKG command (4380)

CRTDPRTBL command (4271), (4384)

CRTJRN command (4300)

CRTJRNRCV command (4297)

current receiver size (3697), (4312)

customizing

SQL files (3918)

SQL for control tables (3914)

data

accessing continuously (3584)

consolidation configuration (3558)

distributing to remote sites (3576)

distribution configuration (3556)

IMS, distributing (3579)

manipulating source (3482)

manipulating target (3744)

prerequisites (3621)

data blocking (3735)

data compression restrictions (3792)

data consistency (4049)

data currency (4033)

data encryption restrictions (3798)

data integrity

DataPropagator for Microsoft Jet (4649)

resolving gaps (4123)

data manipulations (3481), (3743)

data restrictions (3788)

data sharing (4027)

data types, restrictions (3800)

data-type conversion

DB2 to Informix (4832)

DB2 to Microsoft Jet (4836)

DB2 to MS SQL Server (4833)

DB2 to Oracle (4831)

DB2 to SQL Anywhere (4835)

DB2 to Sybase (4834)

databases

maintenance tasks (3658), (4108)

non-IBM target tables (3623)

DataPropagator for Microsoft Jet

ASNJDONE parameters (4674)

ASNJET parameters (4664)

control tables (4677)

data integrity (4650)

error recovery (4676)

operating (4657)

overview (4648)

setting up (4655)

starting (4659)

stopping (4665)

terminology (4652)

troubleshooting (4669)

DataPropagator NonRelational

data distribution example (3582)

maintaining CCD tables (3521)

DB2 Control Center

See Control Center (3435)

DB2 DataJoiner

AIX (4763)

connecting

clients for replication (4775), (4785)

databases for replication (4773), (4783)

creating databases for replication (4771), (4781)

data-type conversions (4830)

DB2CODEPAGE (4795)

DJRA as a client (4791)

installing (4764), (4777)

instance (4767), (4780)

overview (4742)

restrictions (3818)

setting up (4762)

Windows NT (4776)

DB2 DataJoiner Replication Administration (DJRA) tool

See DJRA (DB2 DataJoiner Replication Administration) tool (3439)

DB2 for OS/390

Apply program

operating (4181)

ARCHIVE LOG command (4157)

Capture program

operating (4180)

CCSID translation (4165)

control intervals (4155)

data sharing (4028)

DB2 ODBC Catalog (4251)

index types (4250)

log (4154)

password verification (3729)

DB2 library

books (5061)

Information Center (5065)

language identifier for books (5062)

late-breaking information (5063)

online help (5060)

ordering printed books (5069)

printing PostScript books (5068)

searching online information (5067)

setting up document server (5066)

SmartGuides (5059)

structure of (5058)

viewing online information (5064)

DB2 ODBC Catalog

function calls (4256)

setting up server (4254)

setting up workstation client (4253)

tables (4255)

Version 6 enhancements (4252)

DB2 Tools Settings notebook (3902)

DB2CODEPAGE setting from DJRA (4793)

DB2INSTANCE

starting Capture for UNIX (4432)

starting Capture for Windows and OS/2 (4521)

DB2LFSN command

for UNIX platforms (4473)

for Windows and OS/2 (4562)

db2synch command (4638)

DBCLOB (double-byte character large object) (3783), (3813)

DBLIB connections, improving performance (4757)

deactivating subscription sets (4137)

decision support systems (3586)

defining

replication source joins (3953)

replication sources (3934)

subscription sets (3597)

delete journal receiver exit routine (4319)

Design Master (4653)

designing

overview (3618)

replication configurations (3549)

unsuitable configurations (3551)

detecting a gap (4119)

diagnosing errors (4974)

differential-refresh copying (3459)

distinct data type (3815)

distributing

data to remote sites (3575)

IMS data (3578)

DJRA (DB2 DataJoiner Replication Administration) tool

authorization requirements (3925)

binding source, target, and control servers (4799)

capacity planning (3688)

columns, defining (3997)

connecting to DB2 DataJoiner (4792)

connectivity (3725)

control tables, creating (3917)

data-type conversions (4828)

DB2CODEPAGE (4796)

editing

logic (4809)

SQL (4820)

installing (4786)

introduction (3438)

offline load (4057)

overview (3907), (4740)

preferences (4797)

processor requirements (3687)

promote functions (4060)

Replication Monitor (4117)

replication sources

changing (4128)

defining (3936)

removing (4132)

rows, defining (4015)

running SQL (4824)

setting up replication (3905), (4807)

SQL

editing (4821)

running (4825)

SQL statements and stored procedures (4026)

starting (4806)

subscription sets

changing (4146)

defining (3962)

removing (4149)

timing (4037)

target-table type, choosing (3979)

targets supported (4741)

using for AS/400

defining replication sources and subscription sets (4337)

relative record numbers (4263), (4339)

Replication Monitor (4329)

DJX_ASYNC_APPLY variable (4761)

double-byte character large object (DBCLOB) (3782), (3812)

DPCNTL files (3910)

DPCNTL.SAT command (4636)

DPNCNTL files (3912)

DSPJRN command (4333)

dummy WHERE clause (4010)

dumps

Capture for OS/390 (5013)

Capture for VM and VSE (5027)

EDITPROC (3794)

education

custom classes (5076)

IBM Global Campus URL (5077)

ENDDPRAPY command (4397)

ENDDPRCAP command (4360)

ENDJOB command (4362)

environment

copying, overview (3646)

planning, overview (3616)

setting up, overview (3629)

environment variables

ASNDIAL

description (4708)

OS/2 (4712)

Windows 95 (4716)

Windows NT (4714)

ASNHANGUP

description (4709)

OS/2 (4713)

Windows 95 (4717)

Windows NT (4715)

error information tables (4687), (4958)

error messages tables (4689), (4961)

error recovery

DataPropagator for Microsoft Jet (4675)

for AS/400 (5031)

for OS/390 (5001)

for VM and VSE (5017)

error-side-information tables (4691), (4964)

errors, diagnosing resources for (4973)

event-based timing (3541), (4048)

examples

See also replication configurations (3566)

CD table, pruning (3711)

spill file size, setting (3719)

SQL for columns (3992)

WHERE clauses (3577), (4013)

exit routines

ASNDIAL (4710)

ASNDONE

for AS/400 (4404)

using (4083)

ASNHANGUP (4711)

ASNJDONE (4672)

ASNLOAD

for AS/400 (4405)

using (4077)

delete journal receiver (AS/400) (4318)

external CCD tables (3863), (4056)

FIELDPROC

restrictions for Capture for VM and VSE (4590)

restrictions, general (3795)

files

apply_name.ini (4760)

CNTRLSVR.REX (4814)

DPCNTL (3911)

DPNCNTL (3913)

spill (3717)

SRCESVR.REX (4812)

TARGSVR.REX (4816)

TBLSPACE.REX (4818)

fragmentation

horizontal (3754)

update-anywhere replication (3945)

vertical (3750)

full-refresh copying

Apply for AS/400 (4342), (4392)

external CCD table (3864)

forcing in Apply for OS/390 (4174)

introduction (3457)

suppressing in Apply for OS/390 (4171)

gap detection (4118)

generated SQL

editing (4823)

running (4827)

GETLSEQ command

for OS/390 (4232)

for UNIX platforms (4471)

for VM and VSE (4625)

for Windows and OS/2 (4560)

GROUP BY clause (4008)

GRTDPRAUT command (4283)

hardware requirements, mobile (4703)

history data (3821), (3867)

horizontal subsets (3753)

host RDBMSs, configuring the Control Center (3897)

hot-site backup (3554)

hot-spot updates, condensing (3871)

IBM Software Support Services (5047)

index types, rules for OS/390 (4249)

initializing Capture program for AS/400 (4367)

installation

Capture and Apply programs

for AS/400 (4268)

for OS/390 (4187)

for UNIX platforms (4423)

for VM and VSE (4584)

DB2 DataJoiner (4765), (4778)

DJRA (4788)

restrictions (3891)

services and consulting (5075)

instance, DB2 DataJoiner (4766), (4779)

internal CCD tables (3862)

interval-based timing (3538)

invocation parameters

Apply program

for AS/400 (4390)

for OS/390 (4239)

for UNIX platforms (4480)

for Windows and OS/2 (4571)

Capture program

for AS/400 (4348)

for OS/390 (4202)

for UNIX platforms (4435)

for VM and VSE (4595)

for Windows and OS/2 (4524)

INZDPRCAP command (4364)

joins

defining as sources (3954)

for targets (3495)

planning to use (3627)

replicating (3760)

journal receivers

creating for source tables (4295)

current, size (3699)

delete journal receiver exit routine (4317)

managing (4305)

system management (4309)

threshold (4311)

user management (4313)

journaling requirements (3694)

journals

creating (4299)

default message queue (4316)

entry types (4376)

managing (4304)

problem determination (5042)

QSQJRN journal (4292)

remote journal function (4293)

starting (4301)

use (4291)

KEEPDICTIONARY keyword (4111)

key string tables (4693), (4967)

lag limit (4070)

large object (LOB) (3776), (3806)

large replication jobs (3738)

LE/370 environment (4158)

legacy data sources (3581)

LOADX command

ASNLOAD exit routine (4078)

example (3610)

LOB (large object) (3777), (3807)

local cache for committed changes (3875)

local CCD tables (3844)

local client (4768)

log file

Apply program (4986)

Capture program (4999)

log records, archived before captured (3701)

log sequence number

for OS/390 (4230)

for UNIX platforms (4469)

for VM and VSE (4621)

for Windows and OS/2 (4556)

log-based communication (3447)

logging requirements (3693)

logic, editing DJRA (4810)

logical partitioning keys

description (3957)

row subsets (3758)

logical servers (3423)

LONG VARCHAR data type (3805)

LONG VARGRAPHIC data type (3804)

maintenance

database (4107)

overview of tasks (3657)

MAX_SYNCH_MINUTES (3736), (4032)

members, subscription-set (3476)

messages

Apply program (5049), (5055)

Capture for AS/400 (5057)

Capture program (5051), (5054)

Microsoft Jet (4646)

Microsoft SQL Server, improving performance (4756)

migration

planning (3889)

services and consulting (5074)

mini-cycles

Apply program (3741)

defining for subscription set (4030)

mobile replication

see also Microsoft Jet (4647)

see also satellite replication (4627)

configuring

client (4718)

control server (4728)

environment variables (4707)

for OS/2

binding (4725)

configuring (4723)

for Windows NT and Windows 95

binding the package (4721)

configuring (4720)

hardware requirements (4704)

overview (4696)

planning (4699)

processing cycle (4730)

restrictions (4697)

software requirements (4702)

mobile-replication-enabler

command line (4731)

user interface (4736)

monitoring

Capture program progress for AS/400 (4331)

introduction (3652)

replication environment (4115)

multiple source tables (3573)

multiple target tables (3868)

network connectivity (3726)

noncomplete CCD tables (3517), (3851)

noncondensed CCD tables (3519), (3857)

nonrelational data sources (3876)

NT Service Control Manager

Apply for Windows (4512)

Capture for Windows (4510)

NT Services

starting Apply program (4568)

starting Capture program (4520)

ObjectREXX (4789)

occasionally connected environments

See also satellite replication, Microsoft Jet, mobile replication (3565)

description (4626)

example configuration (3589)

introduction (3564)

offline load (4058)

on-demand timing (3544)

operating

Apply program

example (3638)

for OS/390 (4234), (4379)

for UNIX platforms (4475)

for Windows and OS/2 (4564)

overview (4102)

Capture program

example (3639)

for OS/390 (4191), (4344)

for UNIX platforms (4427)

for VM and VSE (4586)

for Windows and OS/2 (4514)

overview (4085)

DataPropagator for Microsoft Jet (4658)

overview (3649)

options, performance (4066)

ORA-04081 message (4751)

parameter definitions

ASNCOPY (4734)

DataPropagator for Microsoft Jet (4663), (4673)

password files

creating, example (3606)

for Apply program

for UNIX platforms (4425)

for Windows and OS/2 (4506)

password verification, DB2 for OS/390 (3728)

performance

improving (4754)

options (4065)

troubleshooting, introduction (3675)

planning

active log size (3700)

capacity (3680)

conflict detection (3946)

migration (3890)

mobile replication (4700)

network (3720)

overview (3619)

security (3921)

services and consulting (5073)

storage requirements (3690)

point-in-time tables

defining (3971)

description (4927)

introduction (3504)

PREDICATES column capacity (3761)

predicates, defining for target tables (4005)

preferences, setting

DB2 Control Center (3904)

DJRA (4798)

PREFORMAT keyword (4110)

primary keys

logical partitioning (3956)

relative record numbers for AS/400 (4340)

problem determination

alert generation for OS/390 (5006)

Apply trail table (4981)

Capture program

for AS/400 (5034)

for OS/390 (5004)

for VM and VSE (5020)

Capture program trace table (4992)

collecting data (AS/400) (5043)

diagnosis resources (4972)

errors

Apply program (4976), (4979), (4990)

Capture program (4975)

IBM Software Support Services (5048)

journal (5039)

log file

Apply program (4987)

Capture program (5000)

scenario (5045)

storage dump

Capture for OS/390 (5015)

Capture for VM and VSE (5029)

trace buffers

Capture for OS/390 (5008)

Capture for VM and VSE (5022)

trace file

Apply program (4984)

Capture program (4996)

trace output

Capture for OS/390 (5011)

Capture for VM and VSE (5025)

WRKSBMJOB command (5040)

WRKSBSJOB command (5041)

programming interface information (5079)

promote functions (4061)

PRUNE command

for OS/390 (4227)

for UNIX platforms (4465)

for VM and VSE (4619)

for Windows and OS/2 (4553)

prune interval (4072)

prune lock tables (4872)

pruning

Capture program

for AS/400 (4370)

for OS/390 (4225)

for UNIX platforms (4463)

for VM and VSE (4617)

for Windows and OS/2 (4554)

CCD tables (4114)

CCD tables, with Capture triggers (3882)

CD tables (3828), (3880)

control tables, overview (3650)

example (3611)

UOW tables (3881), (4887)

pruning control tables (4855)

push and pull Apply program configurations

choosing a configuration (3732)

description (3730)

questions, problem determination (5046)

RCVJRNE command (4308)

read dependencies (3950)

real-time replication (3553)

receiver size, current (3698)

referential constraints (3625)

referential integrity (4052)

refresh

differential (3462)

full (3463)

suppressing for Apply for OS/390 (4173)

REINIT command

for OS/390 (4223)

for UNIX platforms (4461)

for VM and VSE (4615)

for Windows and OS/2 (4550)

reinitializing Capture program

for OS/390 (4221)

for UNIX platforms (4459)

for VM and VSE (4613)

for Windows and OS/2 (4548)

relative record numbers

as primary key for AS/400 (4338)

push configuration (3734)

support for AS/400 (4262)

relative timing (4042)

remote CCD tables (3845)

remote journal function (4294)

remote journaling (3733)

removing

replication sources (4131)

subscription sets (4148)

renaming columns (3767)

REORG utility (3660), (3671), (4109)

replica tables See also row-replica tables

defining (3978)

description (4939)

introduction (3525)

Replication Analyzer (3678)

replication configurations

accessing data continuously (3583)

auditing archive information (3568)

data consolidation (3557), (3571)

data distribution (3555), (3574)

decision support systems (3585)

examples of (3567)

IMS data, distributing (3580)

occasionally connected systems (3563), (3588)

typical (3548)

update-anywhere (3561)

replication environment

copying (4063)

operating (3648)

setting up (3634)

starting to replicate (3635)

updating (3643)

replication messages (5050)

Replication Monitor

introduction (3653)

overview (4116)

using for AS/400 (4330)

replication sources

changing (4125)

defining

example (3593), (3595)

for AS/400 (4334)

joins (3952)

overview (3933)

introduction (3452)

large objects (3784)

removing (4130)

setting up, overview (3631)

subsetting (3490)

viewing (4126)

restrictions

archived log (3791)

Capture program

for AS/400 (4290)

for OS/390 (4193)

for UNIX platforms (4429)

for VM and VSE (4588)

for Windows and OS/2 (4516)

general (4074)

CCD tables as sources (3559)

column names, limits (3785)

data compression (3793)

data encryption (3799)

data types (3801)

DB2 DataJoiner (3817)

FIELDPROC (4589)

general (3789)

mobile replication (4698)

satellites (4632)

utility program (3797)

WHERE clause (4007)

RESUME command

for OS/390 (4219)

for UNIX platforms (4457)

for VM and VSE (4611)

for Windows and OS/2 (4542)

resuming Capture program

for OS/390 (4217)

for UNIX platforms (4455)

for VM and VSE (4609)

for Windows and OS/2 (4546)

retention limit (4069)

REVOKE utility (3673)

RGZPFM command (3659)

RMVEXITPGM command (4323)

row-replica tables See also replica tables

description (4654), (4951)

introduction (3527)

row-replica-target-list tables (4680), (4907)

rows

defining in target table (4001)

subsetting

DB2 Control Center (4002)

DJRA (4016)

introduction (3489), (3756)

run-time processing (3770), (4024)

RUNSTATS utility (3661), (3672)

RVKDPRAUT command (4286)

satellite clients (4630)

see satellites (4631)

satellite replication overview (4628)

satellites

restrictions (4633)

setting up (4634)

starting (4640)

SBMJOB command (4357)

scenarios

problem determination (5044)

typical (3546)

using Control Center (3590)

scheduling

Apply program

for AS/400 (4394)

for OS/390 (4242)

for UNIX platforms (4483)

for Windows and OS/2 (4574)

Capture program

for AS/400 (4355)

for OS/390 (4204)

for UNIX platforms (4441)

for Windows and OS/2 (4530)

subscription sets (4034)

timing

event (4047)

relative (4041)

security (3922)

servers

binding from DJRA (4801)

control (3430)

logical (3425)

source (3426)

target (3428)

Service Control Manager

Apply for Windows (4511)

Capture for Windows (4509)

services and consulting (5070)

setting up

Apply program

for AS/400 (4260)

for OS/390 (4184)

for UNIX platforms (4411)

for Windows and OS/2 (4494)

Capture program

for AS/400 (4261)

for OS/390 (4183)

for UNIX platforms (4412)

for VM and VSE (4582)

for Windows and OS/2 (4493)

replication

DB2 Control Center (3893)

DJRA (3906), (4808)

replication criteria (3630)

satellites (4635)

soft errors (5052)

software requirements, mobile (4701)

source servers

introduction (3427)

password file for (3605)

source tables

See replication sources (3455)

spill files (3716)

SQL

editing (3920), (4822)

files, customizing (3596), (3919)

running DJRA (4826)

statements

defining for subscription set (4022)

run-time processing (3772)

SQLCODEs

-1032 (4177)

-330 (4162)

-741 (4753)

-805 (4169)

SQLSTATEs

22517 (4163)

51002 (4170)

57019 (4178)

SRCESVR.REX file (4811)

staging data (3824)

staging table

See also CCD (consistent-change data) tables, CD (change data) tables (3975)

defining (3974)

starting

Apply program

for AS/400 (4389)

for OS/390 (4236)

for UNIX platforms (4477)

for Windows and OS/2 (4566)

using NT Services (4567)

with event (3964)

Capture program

for AS/400 (4347)

for OS/390 (4195)

for UNIX platforms (4431)

for VM and VSE (4592)

for Windows and OS/2 (4518)

general (4089)

using NT Services (4519)

change capture (3640)

DataPropagator for Microsoft Jet (4660)

DJRA (4805)

satellites (4641)

STOP command

for OS/390 (4211)

for UNIX platforms (4447)

for VM and VSE (4603)

for Windows and OS/2 (4536)

stopping

Apply program

for AS/400 (4400)

for OS/390 (4248)

for UNIX platforms (4487)

for Windows and OS/2 (4578)

Capture program

for AS/400 (4359)

for OS/390 (4209)

for UNIX platforms (4445)

for VM and VSE (4601)

for Windows and OS/2 (4534)

DataPropagator for Microsoft Jet (4666)

storage

active log size (3695)

Apply spill files (3715)

CD table (3708)

control tables (3705)

database log and journal data (3692)

planning (3691)

target tables (3704)

UOW table (3712)

storage dump

for OS/390 (5014)

for VM and VSE (5028)

stored procedures (3771), (4021)

STRDPRAPY command (4386)

STRDPRCAP command (4350)

STRJRNPF command (4303)

STRSBS command (4352)

subscription columns tables (4901)

subscription cycle (3742)

subscription events tables

description (4913)

populating (4044)

subscription set tables (4895)

subscription sets

activating (4134)

changing (4143)

cloning (4140)

continuous (4038)

data consistency (4050)

deactivating (4135)

defining

columns (3984)

Control Center or DJRA (3960)

example of (3598)

for AS/400 (4335)

mini-cycles (4029)

rows (4000)

run-time processing (4023)

target-table structure (3981)

target-table type (3968)

update-anywhere replication (3966)

introduction (3473)

mobile replication (4739)

referential integrity (4051)

removing (4147)

run-time processing statements (3775)

setting up, overview (3632)

timing

event-based (4043)

interval (4039)

relative (4040)

subscription statements tables (4904)

subscription-schema-changes tables (4682), (4910)

subscription-set members

introduction (3475)

setting up, overview (3633)

subscription-targets-member tables (4898)

subscriptions

See subscription sets, subscription-set members (3477)

subsetting

columns (3745), (3986)

horizontal (3755)

rows (3752), (4003)

source tables (3748)

target tables (3982)

subsystems

See logical servers (3424)

suppressing full-refresh copying for OS/390 (4172)

SUSPEND command

for OS/390 (4215)

for UNIX platforms (4453)

for VM and VSE (4607)

for Windows and OS/2 (4544)

suspending Capture program

for OS/390 (4213)

for UNIX platforms (4451)

for VM and VSE (4605)

for Windows and OS/2 (4540)

Sybase, improving performance (4755)

synchronization generations tables (4695), (4970)

synchronous replication (3534), (3552)

system change journal management (4310)

table partitioning

See column subsetting, row subsetting (3486)

table space, specifying in logic (4819)

table structures (4837)

tables

See also control tables, source tables, target tables (3497)

Apply job (4920)

Apply trail (4917)

Apply-qualifier-cross-reference (4879)

base aggregate (4945)

Capture enqueue (4862)

change aggregate (4949)

change data (CD) (3832), (4892)

conflict (4956)

consistent-change-data (CCD) (3836), (4937)

critical section (4870)

DB2 ODBC Catalog (4257)

error information (4959)

error messages (4962)

error-side-information (4965)

key string (4968)

Microsoft Jet target server (4683)

point-in-time (4929)

prune lock (4873)

pruning control (4856)

replica (4941)

row-replica (4953)

row-replica-target-list (4908)

staging (3837)

structures (4838)

subscription columns (4902)

subscription events (4914)

subscription set (4896)

subscription statements (4905)

subscription-schema-changes (4911)

subscription-targets-member (4899)

synchronization generations (4971)

target types (3498)

trace (4876)

tuning parameters (4067), (4859)

unit-of-work (UOW) (4886)

user (3529)

user copy (3503), (4925)

warm start (4866)

target servers, introduction (3429)

target tables

aggregate (3508)

base aggregate (3510), (4944)

CCD (consistent-change-data)

description (3835), (4933)

introduction (3515)

change aggregate (3512), (4948)

columns, defining (3983)

fragmenting (3746)

in non-IBM databases (3624)

offline load (4059)

point-in-time (3505), (4928)

replica (3526), (4940)

row-replica (3528), (4952)

rows, defining (3999)

storage requirements (3706)

structure, specifying (3980)

table structures, quick reference (4844)

type, specifying (3967)

types of (3500)

update anywhere, defining (3941)

user (3531)

user copy (3502), (4924)

user defined (4018)

TARGSVR.REX file (4815)

tasks, overview (3615)

TBLSPACE.REX file (4817)

terminology

DataPropagator for Microsoft Jet (4651)

DB2 DataPropagator (3417)

three-tier replication configuration (3869)

timing

event-based (3542), (4045)

interval-based (3539)

on-demand (3545)

subscription sets (4035)

Tools Settings notebook (3903)

trace files

Apply program (4983)

Capture program (4994)

problem determination (4995)

trace output

for OS/390 (5010)

for VM and VSE (5024)

trace tables

description (4875)

problem determination (4991)

transaction identification (3822)

transaction-consistent replication (3872)

trigger-based communication (3449)

troubleshooting

Capture and Apply programs (4151)

DataPropagator for Microsoft Jet (4670)

introduction (3674)

services and consulting (5072)

tuning parameters

Capture for AS/400 (4275), (4368)

specifying (4068)

tuning parameters tables (4858)

tutorial for Windows NT (3591)

unions for targets (3496)

unit-of-work (UOW) tables

Capture triggers (4747)

description (4884)

pruning (4888)

storage requirements (3713)

UOW (unit-of-work) tables

Capture triggers (4748)

description (4885)

storage requirements (3714)

update-anywhere replication

conflict detection (3947)

defining sources (3940)

defining subscription sets (3965)

example configuration (3587)

fragmentation for (3944)

introduction (3562)

updated primary key columns (3958)

updates

as inserts and deletes (3959)

asynchronous (3535)

conflicts (3949)

event-based timing (3540)

interval-based timing (3537)

on-demand timing (3543)

scheduling (3532)

synchronous (3533)

user copy tables

defining (3970)

description (4923)

introduction (3501)

user ID

Apply program (3932)

Capture program (3929)

requirements

for UNIX (4410)

Windows and OS/2 (4492)

user tables

as targets (3530)

introduction (3454)

user-defined data types (3816)

user-defined tables (4017)

user-oriented identification (3823)

utilities

BIND PACKAGE (3662)

REORG (3664)

REVOKE (3663)

RUNSTATS (3665)

utility program restrictions (3796)

VALIDPROC (3802)

vertical subsets (3749)

views

defining as sources (3492), (3955)

description (3759)

warm start tables

description (4864)

for Capture for VSE and VM (4867)

warm start, Capture program

for AS/400 (4349), (4371)

for OS/390 (4200)

for UNIX platforms (4438)

for VM and VSE (4598)

for Windows and OS/2 (4527)

forcing (4096)

general (4091)

WARMNS keyword (4099)

Web pages (3892)

WHERE clause

dummy (4011)

examples (4012)

filtering rows (4014)

restrictions (4006)

row subsets (3757)

WRKRDBDIRE command (4382), (4402)

WRKREGINF command (4325)

WRKSBMJOB command (5038)

WRKSBSJOB command (5037)

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]