Share

InfoSphere Data Replication for DB2 for z/OS and WebSphere Message Queue for z/OS: Performance Lessons

2012-12-22 Computers
Download InfoSphere Data Replication for DB2 for z/OS and WebSphere Message Queue for z/OS: Performance Lessons PDF Online Free

Author :
Release : 2012-12-22
Genre : Computers
Kind : eBook
Book Rating : 952/5 ( reviews)

GET EBOOK


Book Synopsis InfoSphere Data Replication for DB2 for z/OS and WebSphere Message Queue for z/OS: Performance Lessons by : Miao Zheng

Download or read book InfoSphere Data Replication for DB2 for z/OS and WebSphere Message Queue for z/OS: Performance Lessons written by Miao Zheng. This book was released on 2012-12-22. Available in PDF, EPUB and Kindle. Book excerpt: Understanding the impact of workload and database characteristics on the performance of both DB2®, MQ, and the replication process is useful for achieving optimal performance.Although existing applications cannot generally be modified, this knowledge is essential for properly tuning MQ and Q Replication and for developing best practices for future application development and database design. It also helps with estimating performance objectives that take these considerations into account. Performance metrics, such as rows per second, are useful but imperfect. How large is a row? It is intuitively, and correctly, obvious that replicating small DB2 rows, such as 100 bytes long, takes fewer resources and is more efficient than replicating DB2 rows that are tens of thousand bytes long. Larger rows create more work in each component of the replication process. The more bytes there are to read from the DB2 log, makes more bytes to transmit over the network and to update in DB2 at the target. Now, how complex is the table definition? Does DB2 have to maintain several unique indexes each time a row is changed in that table? The same argument applies to transaction size: committing each row change to DB2 as opposed to committing, say, every 500 rows also means more work in each component along the replication process. This RedpaperTM reports results and lessons learned from performance testing at the IBM® laboratories, and it provides configuration and tuning recommendations for DB2, Q Replication, and MQ. The application workload and database characteristics studied include transaction size, table schema complexity, and DB2 data type.

End-to-End High Availability Solution for System z from a Linux Perspective

2014-10-30 Computers
Download End-to-End High Availability Solution for System z from a Linux Perspective PDF Online Free

Author :
Release : 2014-10-30
Genre : Computers
Kind : eBook
Book Rating : 06X/5 ( reviews)

GET EBOOK


Book Synopsis End-to-End High Availability Solution for System z from a Linux Perspective by : Lydia Parziale

Download or read book End-to-End High Availability Solution for System z from a Linux Perspective written by Lydia Parziale. This book was released on 2014-10-30. Available in PDF, EPUB and Kindle. Book excerpt: As Linux on System z becomes more prevalent and mainstream in the industry, the need for it to deliver higher levels of availability is increasing. This IBM Redbooks publication starts with an explanation of high availability (HA) fundamentals such as HA concepts and terminology. It continues with a discussion of why a business needs to consider an HA solution and then explains how to determine your business single points of failure. We outline the components of a high availability solution and describe these components. Then we provide some architectural scenarios and demonstrate how to plan and decide an implementation of an end-to-end HA solution, from Linux on System z database scenarios to z/OS, and include storage, network, z/VM, Linux, and middleware. This implementation includes the IBM Tivoli System Automation for Multiplatforms (TSA MP), which monitors and automates applications distributed across Linux, AIX®, and z/OS® operating systems, as well as a GDPS based solution. It includes the planning for an end-to-end scenario, considering Linux on System z, z/VM, and z/OS operating environments, and the middleware used. The TSA MP implements HA for infrastructure, network, operating systems, and applications across multiple platforms and is compared to a Linux HA implementation based on open source Linux-HA, which is Linux only.

The Value of Active-Active Sites with Q Replication for IBM DB2 for z/OS An Innovative IBM Client's Experience

2015-01-23 Computers
Download The Value of Active-Active Sites with Q Replication for IBM DB2 for z/OS An Innovative IBM Client's Experience PDF Online Free

Author :
Release : 2015-01-23
Genre : Computers
Kind : eBook
Book Rating : 036/5 ( reviews)

GET EBOOK


Book Synopsis The Value of Active-Active Sites with Q Replication for IBM DB2 for z/OS An Innovative IBM Client's Experience by : Serge Bourbonnais

Download or read book The Value of Active-Active Sites with Q Replication for IBM DB2 for z/OS An Innovative IBM Client's Experience written by Serge Bourbonnais. This book was released on 2015-01-23. Available in PDF, EPUB and Kindle. Book excerpt: Any business interruption is a potential loss of revenue. Achieving business continuity involves a tradeoff between the cost of an outage or data loss with the investment required for achieving the recovery point objective (RPO) and recovery time objective (RTO). Continuous system availability requires scalability, as well as failover capability for maintenance, outages, and disasters. It also requires a shift from standby to active-active systems. Active-active sites are geographically distant transaction processing centers, each with the infrastructure to run business operations and with data synchronized by using database replication, such as the Q Replication technology that is part of IBM® InfoSphere® Data Replication software. This IBM Redbooks® publication describes preferred practices and introduces an architecture for continuous availability and disaster recovery that is used by a very large business institution that runs its core business on IBM DB2® for z/OS® databases. This paper explains the technologies and procedures that are required for the implementation of an active-active sites architecture. It also explains an innovative procedure for major IT upgrades that uses Q Replication for DB2 on z/OS, Multi-site Workload Lifeline, and Peer-to-Peer Remote Copy/Extended Distance (PPRC-XD). This paper is of value to decision makers, such as executive and IT architects, and to database administrators who are responsible for design and implementation of the solution.

Understanding and Using Q Replication for High Availability Solutions on the IBM z/OS Platform

2014-02-11 Computers
Download Understanding and Using Q Replication for High Availability Solutions on the IBM z/OS Platform PDF Online Free

Author :
Release : 2014-02-11
Genre : Computers
Kind : eBook
Book Rating : 207/5 ( reviews)

GET EBOOK


Book Synopsis Understanding and Using Q Replication for High Availability Solutions on the IBM z/OS Platform by : Cecile Madsen

Download or read book Understanding and Using Q Replication for High Availability Solutions on the IBM z/OS Platform written by Cecile Madsen. This book was released on 2014-02-11. Available in PDF, EPUB and Kindle. Book excerpt: With ever-increasing workloads on production systems from transaction, batch, online query and reporting applications, the challenges of high availability and workload balancing are more important than ever. This IBM® Redbooks® publication provides descriptions and scenarios for high availability solutions using the Q Replication technology of the IBM InfoSphere® Data Replication product on the IBM z/OS® platform. Also included are key considerations for designing, implementing, and managing solutions for the typical business scenarios that rely on Q Replication for their high availability solution. This publication also includes sections on latency analysis, managing Q Replication in the IBM DB2® for z/OS environment, and recovery procedures. These are topics of particular interest to clients who implement the Q Replication solution on the z/OS platform. Q Replication is a high-volume, low-latency replication solution that uses IBM WebSphere® MQ message queues to replicate transactions between source and target databases or subsystems. A major business benefit of the low latency and high throughput solution is timely availability of the data where the data is needed. High availability solutions are implemented to minimize the impact of planned and unplanned disruptions of service to the applications. Disruption of service can be caused by software maintenance and upgrades or by software and hardware outages. As applications' high availability requirements evolve towards continuous availability, that is availability of the data 24 hours a day and 7 days a week, so does the Q Replication solution, to meet these challenges. If you are interested in the Q Replication solution and how it can be used to implement some of the high availability requirements of your business scenarios, this book is for you.

WebSphere Replication Server for Z/OS Using Q Replication

2006
Download WebSphere Replication Server for Z/OS Using Q Replication PDF Online Free

Author :
Release : 2006
Genre :
Kind : eBook
Book Rating : /5 ( reviews)

GET EBOOK


Book Synopsis WebSphere Replication Server for Z/OS Using Q Replication by : Nagraj Alur

Download or read book WebSphere Replication Server for Z/OS Using Q Replication written by Nagraj Alur. This book was released on 2006. Available in PDF, EPUB and Kindle. Book excerpt: This IBM Redbooks publication provides detailed instructions and scripts for managing failover and switchback in a WebSphere Replication Server for z/OS bidirectional Q replication environment for the z/OS platform. A typical business scenario is used to showcase the bidirectional failover/switchback implementation. This book also includes a WebSphere MQ shared disk and WebSphere MQ shared queue high availability scenario for the source system in a Q replication environment involving unidirectional replication. Key considerations in designing and implementing such environments are discussed. This book is aimed at an audience of IT architects and database administrators (DBAs) responsible for developing high-availability solutions on the z/OS platform. Please note that the additional material referenced in the text is not available from IBM.

You may also like...