Cargando…

IBM infoSphere replication server and data event publisher : design, implement, and monitor a successful Q replication and event publishing project /

Annotation

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Kumar-Chatterjee, Pav
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham, U.K. : Packt Pub., ©2010.
Temas:
Acceso en línea:Texto completo
Tabla de Contenidos:
  • 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
  • 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
  • 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
  • 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
  • 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