| Document Type
|
:
|
BL
|
| Record Number
|
:
|
1017301
|
| Doc. No
|
:
|
b771671
|
| Main Entry
|
:
|
Kumar-Chatterjee, Pav.
|
| Title & Author
|
:
|
IBM infoSphere replication server and data event publisher : : design, implement, and monitor a successful Q replication and event publishing project /\ Pav Kumar-Chatterjee.
|
| Publication Statement
|
:
|
Birmingham, U.K. :: Packt Pub.,, ©2010.
|
| Page. NO
|
:
|
1 online resource (viii, 325 pages)
|
| ISBN
|
:
|
1849681546
|
|
|
:
|
: 1849681554
|
|
|
:
|
: 9781849681544
|
|
|
:
|
: 9781849681551
|
|
|
:
|
9781849681544
|
| Contents
|
:
|
Cover; Copyright; Credits; About the Author; About the Reviewer; Table of Contents; Preface; Chapter 1: Q Replication Overview; Why do we want to replicate data; Overview of what is available today; The different replication options; Replication toolset; The Replication Center GUI; The ASNCLP command interface; Q replication constituent components; The different types of Q replication; Unidirectional replication; Replicating to a stored procedure; Bidirectional replication; Peer-to-peer replication; Tree replication; Replicating to a Consistent Change Data table; Event Publishing
|
|
|
:
|
Create/start/stop a Queue ManagerStarting a Queue Manager; Checking that the Queue Manager is running; Stopping a Queue Manager; Deleting a Queue Manager; The Queue Manager configuration file; MQ logging; Issuing commands to a Queue Manager (runmqsc); Displaying the attributes of a Queue Manager; Changing the attributes of a Queue Manager; MQ Listener management; Defining/Starting an MQ Listener; Displaying an MQ Listener; Stopping an MQ Listener; MQ Channel management; To define a Channel; To start a Channel; To display a list of Channels; To display the status of a Channel
|
|
|
:
|
DB2 replication sourcesReplicating XML data types; Replicating compressed tables; Replicating large objects; Other DB2 objects; Q replication filtering and transformations; Filtering rows/columns; Before and After SQL-alternatives; Stored procedure processing; Q replication conflict detection; What is conflict detection?; When do conflicts occur?; Q replication and HADR; Q replication in a DPF environment; Tables with referential integrity; Table load and insert considerations; Summary; Chapter 2: Q Replication Components; The DB2 database layer; Database/table/column name compatibility
|
|
|
:
|
DB2 to DB2 replicationDB2 to non-DB2 replication; Non-DB2 to DB2 replication; How are the Q replication control tables populated; Pruning of the control tables; The IBMQREP_SIGNAL control table; Sending signals using the IBMQREP_SIGNAL table; Sending signals using an INSERT statement; Sending signals using ASNCLP; Using a signal to determine where Q Capture is up to; Restricting access to IBMQREP_SIGNAL; Summary; Chapter 4: WebSphere MQ for the DBA; An introduction to MQ; MQ queues; MQ queue naming standards; MQ queues required for different scenarios; WebSphere MQ commands
|
|
|
:
|
The WebSphere MQ layerThe Q replication layer; What is a logical table?; What is a Replication/Publication Queue Map?; What is a Q subscription?; What is a subscription group?; Q subscription activation; The relationship between the components; The Q Capture and Q Apply programs; Q Capture internals; Q Apply internals; How do Q Capture and Q Apply communicate?; Summary; Chapter 3: The DB2 Database Layer; Database creation; The control tables; The Q Capture control tables; The Q Apply control tables; The Replication Alert Monitor control tables; Where do the control tables go
|
| Abstract
|
:
|
Annotation
|
| Subject
|
:
|
Client/server computing.
|
| Subject
|
:
|
Electronic data processing-- Distributed processing.
|
| Subject
|
:
|
Client/server computing.
|
| Subject
|
:
|
COMPUTERS-- Client-Server Computing.
|
| Subject
|
:
|
Electronic data processing-- Distributed processing.
|
| Dewey Classification
|
:
|
004/.36
|
| LC Classification
|
:
|
QA76.9.C55K86 2010eb
|