Search results

Switching database vendors is often considered an exhausting challenge for database administrators and developers. Complexity, total cost, and the risk of downtime are often the reasons that restrain IT decision makers from starting the migration project. The primary goal of this book is to show that, with the proper planning and guidance, converting from MySQL to IBM® DB2® is not only feasible but straightforward. If you picked up this book, you are most likely considering converting to DB2 and are probably aware of several of the advantages of to converting to DB2 data server. In this IBM Redbooks® publication, we discuss in detail how you can take advantage of this industry leading database server. This book is an informative guide that describes how to convert the database system from MySQL™ 5.1 to DB2® V9.7 on Linux® and the steps that are involved in enabling the applications to use DB2 instead of MySQL. This guide also presents the best practices in conversion strategy and planning, conversion tools, porting steps, and practical conversion examples. It is intended for technical staff that is involved in a MySQL to DB2 conversion project.

In this IBM® Redbooks® publication, we describe the new DB2 Oracle Database compatibility features. The latest version of DB2® includes extensive native support for the PL/SQL procedural language, new data types, scalar functions, improved concurrency, built-in packages, OCI, SQLPlus, and more. These features dramatically improve the ease of developing applications that run on both DB2 and Oracle, and simplify the process of moving from Oracle to DB2. In addition, IBM now provides rich tooling to simplify the enablement process, such as the highly scalable IBM Data Movement Tool for moving schema and data into DB2, and an Editor and Profiler for PL/SQL provided by way of the Optim™ Data Studio tool suite. This Oracle to DB2 migration guide describes new technology, best practices for moving to DB2, and how to handle some common scenarios. It is now dramatically easier than ever to move to DB2 and experience the benefits of the IBM industry leading database, which offers a lower cost of ownership, ease of use, storage savings, industry leading performance, and superior customer support. Within six weeks of DB2 9.7 becoming generally available, scores of companies had already reported very high compatibility between the code they developed for Oracle and what they were experiencing with DB2 9.7. These companies reported out-of-the-box compatibility rates between 90%-100% (measured by the percentage of statements that required modification), with typical compatibility in the high 90s. These statistics come

Server virtualization technologies are becoming more popular to help efficiently utilize resources by consolidating servers. IBM® , the first company that developed and made available the virtual technology in 1966, offers advanced, powerful, reliable, and cost-saving virtualization technologies in various hardware and software products including DB2® for Linux, UNIX, and Windows. This IBM Redbooks® publication describes using IBM DB2 9 with server virtualization. We start with a general overview of virtualization and describe specific server virtualization technologies to highlight how the server virtualization technologies have been implemented. With this introduction anyone new to virtualization will have a better understanding of server virtualization and the industry server virtualization technologies available in the market. Following the virtualization concept, we describe in detail the setup, configuration, and managing of DB2 with three leading server virtualization technologies: IBM Power Systems™ with PowerVM™ VMware Hyper-V We discuss the virtual machine setup with DB2 in mind to help IT support understand the effective ways of setting up a virtual environment specific for DB2. We explain the architecture and components of these three server virtualization technologies to allow DBAs to understand how a database environment using DB2 can benefit from using the server virtualization technologies. In addition, we discuss the DB2 features and functions that can take advantage o

Distributed Relational Database Architecture™ (DRDA®) is a set of protocols that permits multiple local and remote database systems and application programs, to work together. Any combination of relational database management products that use DRDA can be connected to form a distributed relational database management system. DRDA coordinates communication between systems by defining what can be exchanged and how it must be exchanged. DB2® for z/OS® Distributed Data Facility (DDF) is a built-in component which provides the connectivity to and from other servers or clients over the network. DDF is a full-function DRDA compliant transaction monitor which, equipped with thread pooling and connection management, can support very large networks. Different z/OS workload management priorities can be assigned to different, user-specified classes of DDF-routed application work. In this IBM® Redbooks® publication we describe how to set up your DDF environment, and how to deploy the DDF capabilities in different configurations, including how to develop applications that access distributed databases. We also describe a set of more advanced features, such as thread pooling and high availability distributed configurations, in a DB2 data sharing environment, as well as the traces available to you to do performance monitoring and problem determination. In summary, we show how a high-volume, highly available transactional application can be successfully implemented with a DB2 for z/OS data server accessed by all types

Many organizations require almost continuous availability of their mission-critical, IBM® FileNet® P8 systems. Loss of system resources and services can translate directly into lost revenue and lost customers. The goal, therefore, is to design and implement IBM FileNet P8 systems that are highly available by compensating for both planned and unplanned system outages and eliminating single points of failure. IBM FileNet P8 Platform provides availability features that are built-in to the core components. With these features, high availability of an IBM FileNet P8 system can be achieved through redundancy: redundant components, redundant systems, and redundant data. Hardware and software components might fail. With redundancy, the failure can be eliminated or minimized. This IBM Redbooks® publication describes strategies and options for core IBM FileNet P8 system components. In addition, the book provides detailed, step-by-step procedures that we used to implement high availability for our case study IBM FileNet P8 system. This book serves as a practical reference when you design and implement highly available IBM FileNet P8 systems. This book is intended for IT architects, IT specialists, project managers, and decision makers identifying the best high availability strategies and integrating them into the IBM FileNet P8 system design process.

IBM InfoSphere Rapid Deployment Package (RDP) for MDM provides a rapid deployment approach to implementing MDM solutions that provide immediate return on investment. It provides a seamless upgrade path to IBM InfoSphere MDM Server which provides the complete range of MDM functionally in the market today. In this IBM® Redbooks® publication, we use a simple financial services MDM scenario to describe in detail the RDP for MDM offering and show how it can deliver a return on investment in a short timeframe using a phased approach that ensures minimal risk.

As organizations strive to do more with less, IBM® DB2® for Linux®, UNIX®, and Windows® provides various built-in high availability features. DB2 further provides high availability solutions by leveraging enterprise system resources with broad support for clustering software such as HACMP™, TSA, and Microsoft® Windows Cluster Server. This IBM Redbooks® publication describes DB2's high availability functions and features, focusing on High Availability Disaster Recovery (HADR) in the OLTP environment. The book provides a detailed discussion of HADR, including setup, configuration. administration, monitoring, and best practices. We explain how to configure cluster software HACMP, TSA, and MSCS with DB2 and show how to use these products to automate HADR takeover. DB2 also provides unprecedented enterprise-class disaster recovery capability. This book covers single system view backup, backup and restore with snapshot backup, as well as the db2recovery command, in detail.

This IBM Redbooks publication presents many of the new and improved features and functions of DB2 V9.1 for z/OS and DB2 Connect V9.1. It explains how they complement and benefit your SAP NetWeaver environment. This book also shares some of our experiences in migrating our DB2 V8 SAP data sharing environment to DB2 9 for z/OS with a minimal amount of outage. This book is written for SAP and DB2 administrators. Knowledge of these products and of the z/OS environment is assumed.

This IBM® Redbooks® publication helps you design and create demonstrations or solutions that meet ACORD insurance standards with minimal application coding. If you are not interested in creating such demonstrations yourself, we show you two and provide you with contacts to show those demonstrations. ACORD has published and maintains insurance industry standards. The two most complete and often used standards are ACORD eForms and ACORD messaging. ACORD eForms includes hundreds of electronic forms, which can be used as-is with the IBM Lotus® Forms Viewer or modified slightly for use with the Lotus Forms Server to support straight-through processing scenarios. ACORD messaging formats can be tailored to the needs of individual insurance companies by using industry supplied tools. This book shows you how to use IBM tools and tool content such as Lotus ACORD Forms, WebSphere® Transformation Extender ACORD Pack, and DB2® PureXML® to minimize efforts to build and maintain ACORD solutions. The solutions used in this book are available from the authors as demonstrations. This can help IBM clients understand both the value of using ACORD standards and the value of using IBM products that already incorporate these standards. We review both developer and run-time environments. We do this to maximize the discussion potential for both open and industry standards. The run-time environment provides a demonstration utilizing ACORD eForms (Lotus Forms) and the IBM SOA software stack to produce a seamless showcase of eForm

IBM Information Server is a revolutionary new software platform that helps organizations derive more value from the complex heterogeneous information that is spread across their systems. It enables organizations to integrate disparate data and deliver trusted information wherever and whenever needed, in line and in context, to specific people, applications, and processes. IBM WebSphere Information Analyzer is a data profiling and analysis tool that is a critical component of IBM Information Server. It is designed to help business and data analysts understand the content, quality, and structure of their data sources by automating the data discovery process. Bundled with IBM WebSphere Information Analyzer is AuditStage, a data rule monitoring tool that is designed to help business and data analysts validate data and assess ongoing data quality trends. This book describes a usage scenario that covers all dimensions of profiling, rule building, deployment, and quality monitoring through a data integration life cycle.