3 Review(s)

Business planning is no longer just about defining goals, analyzing critical issues, and then creating strategies. You must aid business integration by linking changed-data events in DB2 databases on Linux, UNIX, and Windows with EAI solutions , message brokers, data transformation tools, and more. Investing in this book will save you many hours of work (and heartache) as it guides you around the many potential pitfalls to a successful conclusion. This book will accompany you throughout your Q replication journey. Compiled from many of author's successful projects, the book will bring you some of the best practices to implement your project smoothly and within time scales. The book has in-depth coverage of Event Publisher, which publishes changed-data events that can run updated data into crucial applications, assisting your business integration processes. Event Publisher also eliminates the hand coding typically required to detect DB2 data changes that are made by operational applications. We start with a brief discussion on what replication is and the Q replication release currently available in the market. We then go on to explore the world of Q replication in more depth. The latter chapters cover all the Q replication components and then talk about the different layers that need to be implemented-the DB2 database layer, the WebSphere MQ layer, and the Q replication layer. We conclude with a chapter on how to troubleshoot a problem. The Appendix (available online) demonstrates the implementation of 13 Q replication scenarios with step-by-step instructions. Publish changed data events in order to operate updated data into critical applications, thus helping your business integration processes with this professional guide What you will learn from this book : Use Q replication to feed a data warehouse and explore the way it interacts with the DB2 High Availability Disaster Recovery (HADR) function Master the main phases of the DB2 database layer, the WebSphere MQ layer, and the Q replication layer, which make up a Q replication solution Create and configure the control tables required by Q replication, and quickly examine how the Q replication components communicate from a DB2 perspective Set up a Q replication and Event Publishing environment Administer a Q replication and Event Publishing environment Troubleshoot an existing Q replication and Event Publishing environment Implement 13 Q replication scenarios, ranging from the unidirectional replication to peer-to-peer, with step-by-step instructions Approach This is a developer's guide and is written in a style suitable to professionals. The initial chapters cover the basic theory and principles of Q replication and WebSphere MQ. As the book advances, numerous real-world scenarios and examples are covered with easy-to-understand code. The knowledge gained in these chapters culminate in the Appendix, which contains step-by-step instructions to set up various Q replication scenarios. Who this book is written for If you are a professional who needs to set up and administer a Q replication or Event Publishing environment, then this is the book you need. The book will give you a clear idea of how to implement Q replication on z/OS whether you work on Linux, Unix, or Windows operating system. About the Author Pav Kumar-Chatterjee (Eur Ing, CENG, MBCS) has been involved in DB2 support on the mainframe platform since 1991, and on midrange platforms since 2000. Before joining IBM, he worked as a database administrator in the airline industry as well as various financial institutions in the UK and Europe. He has held various positions during his time at IBM, including in the Software Business Services team and the global BetaWorks organization. His current position is a DB2 technical specialist in the Software Business. He has been involved with Information Integrator (the forerunner of Replication Server) since its inception, and has helped numerous customers design and implement Q replication solutions, as well as speaking about Q replication at various conferences. Pav Kumar-Chatterjee has co-authored the DB2 pureXML Cookbook, published in August 2009. Table of ContentsPreface Chapter 1: Q Replication Overview Chapter 2: Q Replication Components Chapter 3: The DB2 Database Layer Chapter 4: WebSphere MQ for the DBA Chapter 5: The ASNCLP Command Interface Chapter 6: Administration Tasks Chapter 7: Monitoring and Reporting Index