Author: Paolo Bruni
Publisher: IBM Redbooks
ISBN: 0738437123
Category : Computers
Languages : en
Pages : 268
Book Description
Time to market, flexibility, and cost reduction are among the top concerns common to all IT executives. If significant resource investments are placed in mature systems, IT organizations need to balance old and new technology. Older technology, such as non-IBM pre-relational databases, is costly, inflexible, and non-standard. Users store their information on the mainframe and thus preserve the skills and qualities of service their business needs. But users also benefit from standards-based modernization by migrating to IBM® DB2® for z/OS®. With this migration, users deliver new application features quickly and respond to changing business requirements more effectively. When migrating, the main decision is choosing between conversion and re-engineering. Although the rewards associated with rebuilding mature applications are high, so are the risks and customers that are embarking on a migration need that migration done quickly. In this IBM Redbooks® publication, we examine how to best approach the migration process by evaluating the environment, assessing the application as a conversion candidate, and identifying suitable tools. This publication is intended for IT decision makers and database administrators who are considering migrating their information to a modern database management system.
Streamline Business with Consolidation and Conversion to DB2 for z/OS
Author: Paolo Bruni
Publisher: IBM Redbooks
ISBN: 0738437123
Category : Computers
Languages : en
Pages : 268
Book Description
Time to market, flexibility, and cost reduction are among the top concerns common to all IT executives. If significant resource investments are placed in mature systems, IT organizations need to balance old and new technology. Older technology, such as non-IBM pre-relational databases, is costly, inflexible, and non-standard. Users store their information on the mainframe and thus preserve the skills and qualities of service their business needs. But users also benefit from standards-based modernization by migrating to IBM® DB2® for z/OS®. With this migration, users deliver new application features quickly and respond to changing business requirements more effectively. When migrating, the main decision is choosing between conversion and re-engineering. Although the rewards associated with rebuilding mature applications are high, so are the risks and customers that are embarking on a migration need that migration done quickly. In this IBM Redbooks® publication, we examine how to best approach the migration process by evaluating the environment, assessing the application as a conversion candidate, and identifying suitable tools. This publication is intended for IT decision makers and database administrators who are considering migrating their information to a modern database management system.
Publisher: IBM Redbooks
ISBN: 0738437123
Category : Computers
Languages : en
Pages : 268
Book Description
Time to market, flexibility, and cost reduction are among the top concerns common to all IT executives. If significant resource investments are placed in mature systems, IT organizations need to balance old and new technology. Older technology, such as non-IBM pre-relational databases, is costly, inflexible, and non-standard. Users store their information on the mainframe and thus preserve the skills and qualities of service their business needs. But users also benefit from standards-based modernization by migrating to IBM® DB2® for z/OS®. With this migration, users deliver new application features quickly and respond to changing business requirements more effectively. When migrating, the main decision is choosing between conversion and re-engineering. Although the rewards associated with rebuilding mature applications are high, so are the risks and customers that are embarking on a migration need that migration done quickly. In this IBM Redbooks® publication, we examine how to best approach the migration process by evaluating the environment, assessing the application as a conversion candidate, and identifying suitable tools. This publication is intended for IT decision makers and database administrators who are considering migrating their information to a modern database management system.
DB2 11 for z/OS Technical Overview
Author: Paolo Bruni
Publisher: IBM Redbooks
ISBN: 0738439053
Category : Computers
Languages : en
Pages : 484
Book Description
IBM® DB2® Version 11.1 for z/OS® (DB2 11 for z/OS or just DB2 11 throughout this book) is the fifteenth release of DB2 for IBM MVSTM. It brings performance and synergy with the IBM System z® hardware and opportunities to drive business value in the following areas. DB2 11 can provide unmatched reliability, availability, and scalability - Improved data sharing performance and efficiency - Less downtime by removing growth limitations - Simplified management, improved autonomics, and reduced planned outages DB2 11 can save money and save time - Aggressive CPU reduction goals - Additional utilities performance and CPU improvements - Save time and resources with new autonomic and application development capabilities DB2 11 provides simpler, faster migration - SQL compatibility, divorce system migration from application migration - Access path stability improvements - Better application performance with SQL and XML enhancements DB2 11 includes enhanced business analytics - Faster, more efficient performance for query workloads - Accelerator enhancements - More efficient inline database scoring enables predictive analytics The DB2 11 environment is available either for new installations of DB2 or for migrations from DB2 10 for z/OS subsystems only. This IBM Redbooks® publication introduces the enhancements made available with DB2 11 for z/OS. The contents help database administrators to understand the new functions and performance enhancements, to plan for ways to use the key new capabilities, and to justify the investment in installing or migrating to DB2 11.
Publisher: IBM Redbooks
ISBN: 0738439053
Category : Computers
Languages : en
Pages : 484
Book Description
IBM® DB2® Version 11.1 for z/OS® (DB2 11 for z/OS or just DB2 11 throughout this book) is the fifteenth release of DB2 for IBM MVSTM. It brings performance and synergy with the IBM System z® hardware and opportunities to drive business value in the following areas. DB2 11 can provide unmatched reliability, availability, and scalability - Improved data sharing performance and efficiency - Less downtime by removing growth limitations - Simplified management, improved autonomics, and reduced planned outages DB2 11 can save money and save time - Aggressive CPU reduction goals - Additional utilities performance and CPU improvements - Save time and resources with new autonomic and application development capabilities DB2 11 provides simpler, faster migration - SQL compatibility, divorce system migration from application migration - Access path stability improvements - Better application performance with SQL and XML enhancements DB2 11 includes enhanced business analytics - Faster, more efficient performance for query workloads - Accelerator enhancements - More efficient inline database scoring enables predictive analytics The DB2 11 environment is available either for new installations of DB2 or for migrations from DB2 10 for z/OS subsystems only. This IBM Redbooks® publication introduces the enhancements made available with DB2 11 for z/OS. The contents help database administrators to understand the new functions and performance enhancements, to plan for ways to use the key new capabilities, and to justify the investment in installing or migrating to DB2 11.
Smarter Business: Dynamic Information with IBM InfoSphere Data Replication CDC
Author: Chuck Ballard
Publisher: IBM Redbooks
ISBN: 0738436372
Category : Computers
Languages : en
Pages : 484
Book Description
To make better informed business decisions, better serve clients, and increase operational efficiencies, you must be aware of changes to key data as they occur. In addition, you must enable the immediate delivery of this information to the people and processes that need to act upon it. This ability to sense and respond to data changes is fundamental to dynamic warehousing, master data management, and many other key initiatives. A major challenge in providing this type of environment is determining how to tie all the independent systems together and process the immense data flow requirements. IBM® InfoSphere® Change Data Capture (InfoSphere CDC) can respond to that challenge, providing programming-free data integration, and eliminating redundant data transfer, to minimize the impact on production systems. In this IBM Redbooks® publication, we show you examples of how InfoSphere CDC can be used to implement integrated systems, to keep those systems updated immediately as changes occur, and to use your existing infrastructure and scale up as your workload grows. InfoSphere CDC can also enhance your investment in other software, such as IBM DataStage® and IBM QualityStage®, IBM InfoSphere Warehouse, and IBM InfoSphere Master Data Management Server, enabling real-time and event-driven processes. Enable the integration of your critical data and make it immediately available as your business needs it.
Publisher: IBM Redbooks
ISBN: 0738436372
Category : Computers
Languages : en
Pages : 484
Book Description
To make better informed business decisions, better serve clients, and increase operational efficiencies, you must be aware of changes to key data as they occur. In addition, you must enable the immediate delivery of this information to the people and processes that need to act upon it. This ability to sense and respond to data changes is fundamental to dynamic warehousing, master data management, and many other key initiatives. A major challenge in providing this type of environment is determining how to tie all the independent systems together and process the immense data flow requirements. IBM® InfoSphere® Change Data Capture (InfoSphere CDC) can respond to that challenge, providing programming-free data integration, and eliminating redundant data transfer, to minimize the impact on production systems. In this IBM Redbooks® publication, we show you examples of how InfoSphere CDC can be used to implement integrated systems, to keep those systems updated immediately as changes occur, and to use your existing infrastructure and scale up as your workload grows. InfoSphere CDC can also enhance your investment in other software, such as IBM DataStage® and IBM QualityStage®, IBM InfoSphere Warehouse, and IBM InfoSphere Master Data Management Server, enabling real-time and event-driven processes. Enable the integration of your critical data and make it immediately available as your business needs it.
z/OS Version 1 Release 12 Implementation
Author: Paul Rogers
Publisher: IBM Redbooks
ISBN: 0738434981
Category : Computers
Languages : en
Pages : 888
Book Description
This IBM® Redbooks® publication describes changes in installation and migration when migrating from a current z/OS® V1R10 and z/OS V1R11 to z/OS V1R12. Also described are tasks to prepare for the installation of z/OS V1R12, including ensuring that driving system and target system requirements are met, and coexistence requirements are satisfied. New migration actions are introduced in z/OS V1R12. This book focuses on identifying some of the new migration actions that must be performed for selected elements when migrating to z/OS V1R12. This book describes the following enhancements: z/OS V1R12 installation, HiperDispatch, System Logger, Auto-reply to WTORs, Real Storage Manager (RSM) DFSMS, DFSORT, Services aids, z/OS Infoprint Server, TSO/E, RMFTM, Language Environment®, BCP allocation XML System Services, z/OS UNIX® System Services, BCP supervisor, Extended Address Volumes HyperSwap®. BCPii, (de)ciphering, Predictive Failure Analysis, C language, Hardware instrumentation services FICON® dynamic channel-path management, Workload Manager, SDSF, JES2, JES3, SMF, GRS, XCF, HCD Unicode, Capacity provisioning, RRS, Parallel subsystems initialization z/OS Management Facility (z/OSMF)
Publisher: IBM Redbooks
ISBN: 0738434981
Category : Computers
Languages : en
Pages : 888
Book Description
This IBM® Redbooks® publication describes changes in installation and migration when migrating from a current z/OS® V1R10 and z/OS V1R11 to z/OS V1R12. Also described are tasks to prepare for the installation of z/OS V1R12, including ensuring that driving system and target system requirements are met, and coexistence requirements are satisfied. New migration actions are introduced in z/OS V1R12. This book focuses on identifying some of the new migration actions that must be performed for selected elements when migrating to z/OS V1R12. This book describes the following enhancements: z/OS V1R12 installation, HiperDispatch, System Logger, Auto-reply to WTORs, Real Storage Manager (RSM) DFSMS, DFSORT, Services aids, z/OS Infoprint Server, TSO/E, RMFTM, Language Environment®, BCP allocation XML System Services, z/OS UNIX® System Services, BCP supervisor, Extended Address Volumes HyperSwap®. BCPii, (de)ciphering, Predictive Failure Analysis, C language, Hardware instrumentation services FICON® dynamic channel-path management, Workload Manager, SDSF, JES2, JES3, SMF, GRS, XCF, HCD Unicode, Capacity provisioning, RRS, Parallel subsystems initialization z/OS Management Facility (z/OSMF)
z/OS Version 1 Release 11 Implementation
Author: Paul Rogers
Publisher: IBM Redbooks
ISBN: 073843387X
Category : Computers
Languages : en
Pages : 736
Book Description
This IBM® Redbooks® publication positions the new z/OS® Version 1 Release 11 for migration by discussing many of the new functions that are available. The goal for the z/OS platform is to eliminate, automate, and simplify tasks without sacrificing z/OS strengths, and to deliver a z/OS management facility that is easy to learn and use. z/OS is a highly secure, scalable, high-performance enterprise operating system on which to build and deploy Internet- and JavaTM-enabled applications, providing a comprehensive and diverse application execution environment. This books describes the following new and changed functions: - IBM z/OS Management Facility - Allocation enhancements in z/OS V1R11 - BCPii function enhancements in z/OS V1R11 - JES2 and JES3 enhancements - zFS file sharing enhancements - Extended access volume enhancements - Choosing whether to run zAAP work on zIIP processors - System REXX enhancements in V1R11 - RRS global panel options - Service aids enhancements in V1R11 - GRS ENQ contention notification enhancements and analysis for GRS latches - Basic HyperSwap® support enhancement - Message Flood Automation enhancements - Program Management new Binder IEWPARMS - Predictive failure analysis (PFA) - SMF enhancements in V1R11 - System Logger enhancements - XCF/XES enhancements in V1R11 - AutoIPL support - Displaying PDSE caching statistics - ISPF enhancements - IBM Health Checker for z/OS enhancements
Publisher: IBM Redbooks
ISBN: 073843387X
Category : Computers
Languages : en
Pages : 736
Book Description
This IBM® Redbooks® publication positions the new z/OS® Version 1 Release 11 for migration by discussing many of the new functions that are available. The goal for the z/OS platform is to eliminate, automate, and simplify tasks without sacrificing z/OS strengths, and to deliver a z/OS management facility that is easy to learn and use. z/OS is a highly secure, scalable, high-performance enterprise operating system on which to build and deploy Internet- and JavaTM-enabled applications, providing a comprehensive and diverse application execution environment. This books describes the following new and changed functions: - IBM z/OS Management Facility - Allocation enhancements in z/OS V1R11 - BCPii function enhancements in z/OS V1R11 - JES2 and JES3 enhancements - zFS file sharing enhancements - Extended access volume enhancements - Choosing whether to run zAAP work on zIIP processors - System REXX enhancements in V1R11 - RRS global panel options - Service aids enhancements in V1R11 - GRS ENQ contention notification enhancements and analysis for GRS latches - Basic HyperSwap® support enhancement - Message Flood Automation enhancements - Program Management new Binder IEWPARMS - Predictive failure analysis (PFA) - SMF enhancements in V1R11 - System Logger enhancements - XCF/XES enhancements in V1R11 - AutoIPL support - Displaying PDSE caching statistics - ISPF enhancements - IBM Health Checker for z/OS enhancements
DB2 10 for z/OS Technical Overview
Author: Paolo Bruni
Publisher: IBM Redbooks
ISBN: 0738435112
Category : Computers
Languages : en
Pages : 724
Book Description
IBM® DB2® Version 10.1 for z/OS® (DB2 10 for z/OS or just DB2 10 throughout this book) is the fourteenth release of DB2 for MVSTM. It brings improved performance and synergy with the System z® hardware and more opportunities to drive business value in the following areas: Cost savings and compliance through optimized innovations DB2 10 delivers value in this area by achieving up to 10% CPU savings for traditional workloads and up to 20% CPU savings for nontraditional workloads, depending on the environments. Synergy with other IBM System z platform components reduces CPU use by taking advantage of the latest processor improvements and z/OS enhancements. Streamline security and regulatory compliance through the separation of roles between security and data administrators, column level security access, and added auditing capabilities. Business insight innovations Productivity improvements are provided by new functions available for pureXML®, data warehousing, and traditional online TP applications Enhanced support for key business partners that allow you to get more from your data in critical business disciplines like ERP Bitemporal support for applications that need to correlate the validity of data with time. Business resiliency innovations Database on demand capabilities to ensure that information design can be changed dynamically, often without database outages DB2 operations and utility improvements enhancing performance, usability, and availability by exploiting disk storage technology. The DB2 10 environment is available either for brand new installations of DB2, or for migrations from DB2 9 for z/OS or from DB2 UDB for z/OS Version 8 subsystems. This IBM Redbooks® publication introduces the enhancements made available with DB2 10 for z/OS. The contents help you understand the new functions and performance enhancements, start planning for exploiting the key new capabilities, and justify the investment in installing or migrating or skip migrating to DB2 10.
Publisher: IBM Redbooks
ISBN: 0738435112
Category : Computers
Languages : en
Pages : 724
Book Description
IBM® DB2® Version 10.1 for z/OS® (DB2 10 for z/OS or just DB2 10 throughout this book) is the fourteenth release of DB2 for MVSTM. It brings improved performance and synergy with the System z® hardware and more opportunities to drive business value in the following areas: Cost savings and compliance through optimized innovations DB2 10 delivers value in this area by achieving up to 10% CPU savings for traditional workloads and up to 20% CPU savings for nontraditional workloads, depending on the environments. Synergy with other IBM System z platform components reduces CPU use by taking advantage of the latest processor improvements and z/OS enhancements. Streamline security and regulatory compliance through the separation of roles between security and data administrators, column level security access, and added auditing capabilities. Business insight innovations Productivity improvements are provided by new functions available for pureXML®, data warehousing, and traditional online TP applications Enhanced support for key business partners that allow you to get more from your data in critical business disciplines like ERP Bitemporal support for applications that need to correlate the validity of data with time. Business resiliency innovations Database on demand capabilities to ensure that information design can be changed dynamically, often without database outages DB2 operations and utility improvements enhancing performance, usability, and availability by exploiting disk storage technology. The DB2 10 environment is available either for brand new installations of DB2, or for migrations from DB2 9 for z/OS or from DB2 UDB for z/OS Version 8 subsystems. This IBM Redbooks® publication introduces the enhancements made available with DB2 10 for z/OS. The contents help you understand the new functions and performance enhancements, start planning for exploiting the key new capabilities, and justify the investment in installing or migrating or skip migrating to DB2 10.
IBM z15 (8561) Technical Guide
Author: Octavian Lascu
Publisher: IBM Redbooks
ISBN: 0738458120
Category : Computers
Languages : en
Pages : 554
Book Description
This IBM® Redbooks® publication describes the features and functions the latest member of the IBM Z® platform, the IBM z15TM (machine type 8561). It includes information about the IBM z15 processor design, I/O innovations, security features, and supported operating systems. The z15 is a state-of-the-art data and transaction system that delivers advanced capabilities, which are vital to any digital transformation. The z15 is designed for enhanced modularity, which is in an industry standard footprint. This system excels at the following tasks: Making use of multicloud integration services Securing data with pervasive encryption Accelerating digital transformation with agile service delivery Transforming a transactional platform into a data powerhouse Getting more out of the platform with IT Operational Analytics Accelerating digital transformation with agile service delivery Revolutionizing business processes Blending open source and Z technologies This book explains how this system uses new innovations and traditional Z strengths to satisfy growing demand for cloud, analytics, and open source technologies. With the z15 as the base, applications can run in a trusted, reliable, and secure environment that improves operations and lessens business risk.
Publisher: IBM Redbooks
ISBN: 0738458120
Category : Computers
Languages : en
Pages : 554
Book Description
This IBM® Redbooks® publication describes the features and functions the latest member of the IBM Z® platform, the IBM z15TM (machine type 8561). It includes information about the IBM z15 processor design, I/O innovations, security features, and supported operating systems. The z15 is a state-of-the-art data and transaction system that delivers advanced capabilities, which are vital to any digital transformation. The z15 is designed for enhanced modularity, which is in an industry standard footprint. This system excels at the following tasks: Making use of multicloud integration services Securing data with pervasive encryption Accelerating digital transformation with agile service delivery Transforming a transactional platform into a data powerhouse Getting more out of the platform with IT Operational Analytics Accelerating digital transformation with agile service delivery Revolutionizing business processes Blending open source and Z technologies This book explains how this system uses new innovations and traditional Z strengths to satisfy growing demand for cloud, analytics, and open source technologies. With the z15 as the base, applications can run in a trusted, reliable, and secure environment that improves operations and lessens business risk.
IBM Information Infrastructure Solutions Handbook
Author: Sangam Racherla
Publisher: IBM Redbooks
ISBN: 0738434485
Category : Computers
Languages : en
Pages : 282
Book Description
An information infrastructure is comprised of software, servers, storage, and networks, integrated and optimized to deliver timely, secure, and trusted information throughout the organization and to its clients and partners. With the explosive growth in data and information—coupled with demands for projects with rapid ROI—IT infrastructures and storage administrators are reaching a breaking point. IBM® can help with the changes needed to manage information availability, security, and regulatory and compliance requirements on a tighter budget. And because the health of any business often depends on its ability to take advantage of information in real time, a sound, intelligent information infrastructure becomes critical to supporting new growth initiatives. IBM offers an innovative approach to help you manage information growth more effectively and mitigate risks with a dynamic infrastructure that efficiently and securely stores and protects information, and optimizes information access. You can control, protect, manage, and gain new intelligence from your information with the IBM leading-edge Information Infrastructure products, services and integrated solutions, supported by world-class expertise and access to top experts from around the world. This IBM Redbooks® publication provides an overview of the IBM Information Infrastructure solutions that are designed to help you manage the information explosion and address challenges of information compliance, availability, retention, and security. This will lead your company toward improved productivity, service delivery, and reduced risk, while streamlining costs.
Publisher: IBM Redbooks
ISBN: 0738434485
Category : Computers
Languages : en
Pages : 282
Book Description
An information infrastructure is comprised of software, servers, storage, and networks, integrated and optimized to deliver timely, secure, and trusted information throughout the organization and to its clients and partners. With the explosive growth in data and information—coupled with demands for projects with rapid ROI—IT infrastructures and storage administrators are reaching a breaking point. IBM® can help with the changes needed to manage information availability, security, and regulatory and compliance requirements on a tighter budget. And because the health of any business often depends on its ability to take advantage of information in real time, a sound, intelligent information infrastructure becomes critical to supporting new growth initiatives. IBM offers an innovative approach to help you manage information growth more effectively and mitigate risks with a dynamic infrastructure that efficiently and securely stores and protects information, and optimizes information access. You can control, protect, manage, and gain new intelligence from your information with the IBM leading-edge Information Infrastructure products, services and integrated solutions, supported by world-class expertise and access to top experts from around the world. This IBM Redbooks® publication provides an overview of the IBM Information Infrastructure solutions that are designed to help you manage the information explosion and address challenges of information compliance, availability, retention, and security. This will lead your company toward improved productivity, service delivery, and reduced risk, while streamlining costs.
DS8870 Data Migration Techniques
Author: Bertrand Dufrasne
Publisher: IBM Redbooks
ISBN: 0738440604
Category : Computers
Languages : en
Pages : 330
Book Description
This IBM® Redbooks® publication describes data migrations between IBM DS8000® storage systems, where in most cases one or more older DS8000 models are being replaced by the newer DS8870 model. Most of the migration methods are based on the DS8000 Copy Services. The book includes considerations for solutions such as IBM Tivoli® Productivity Center for Replication and the IBM Geographically Dispersed Parallel SysplexTM (GDPS®) used in IBM z/OS® environments. Both offerings are primarily designed to enable a disaster recovery using DS8000 Copy Services. In most data migration cases, Tivoli Productivity Center for Replication or GDPS will not directly provide functions for the data migration itself. However, this book explains how to bring the new migrated environment back into the control of GDPS or Tivoli Productivity Center for Replication. In addition to the Copy Services based migrations, the book also covers host-based mirroring techniques, using IBM Transparent Data Migration Facility (TDMF®) for z/OS and the z/OS Dataset Mobility Facility (zDMF).
Publisher: IBM Redbooks
ISBN: 0738440604
Category : Computers
Languages : en
Pages : 330
Book Description
This IBM® Redbooks® publication describes data migrations between IBM DS8000® storage systems, where in most cases one or more older DS8000 models are being replaced by the newer DS8870 model. Most of the migration methods are based on the DS8000 Copy Services. The book includes considerations for solutions such as IBM Tivoli® Productivity Center for Replication and the IBM Geographically Dispersed Parallel SysplexTM (GDPS®) used in IBM z/OS® environments. Both offerings are primarily designed to enable a disaster recovery using DS8000 Copy Services. In most data migration cases, Tivoli Productivity Center for Replication or GDPS will not directly provide functions for the data migration itself. However, this book explains how to bring the new migrated environment back into the control of GDPS or Tivoli Productivity Center for Replication. In addition to the Copy Services based migrations, the book also covers host-based mirroring techniques, using IBM Transparent Data Migration Facility (TDMF®) for z/OS and the z/OS Dataset Mobility Facility (zDMF).
DB2 10 for z/OS Performance Topics
Author: Paolo Bruni
Publisher: IBM Redbooks
ISBN: 0738435716
Category : Computers
Languages : en
Pages : 422
Book Description
DB2® 10 for z/OS can reduce the total DB2 CPU demand from 5-20%, compared to DB2 9, when you take advantage of all the enhancements. Many CPU reductions are built in directly to DB2, requiring no application changes. Some enhancements are implemented through normal DB2 activities through rebinding, restructuring database definitions, improving applications, and utility processing. The CPU demand reduction features have the potential to provide significant total cost of ownership savings based on the application mix and transaction types. Improvements in optimization reduce costs by processing SQL automatically with more efficient data access paths. Improvements through a range-list index scan access method, list prefetch for IN-list, more parallelism for select and index insert processing, better work file usage, better record identifier (RID) pool overflow management, improved sequential detection, faster log I/O, access path certainty evaluation for static SQL, and improved distributed data facility (DDF) transaction flow all provide more efficiency without changes to applications. These enhancements can reduce total CPU enterprise costs because of improved efficiency in the DB2 10 for z/OS. DB2 10 includes numerous performance enhancements for Large Objects (LOBs) that save disk space for small LOBs and that provide dramatically better performance for LOB retrieval, inserts, load, and import/export using DB2 utilities. DB210 can also more effectively REORG partitions that contain LOBs. This IBM Redbooks® publication® provides an overview of the performance impact of DB2 10 for z/OS discussing the overall performance and possible impacts when moving from version to version. We include performance measurements that were made in the laboratory and provide some estimates. Keep in mind that your results are likely to vary, as the conditions and work will differ. In this book, we assume that you are somewhat familiar with DB2 10 for z/OS. See DB2 10 for z/OS Technical Overview, SG24-7892-00, for an introduction to the new functions.
Publisher: IBM Redbooks
ISBN: 0738435716
Category : Computers
Languages : en
Pages : 422
Book Description
DB2® 10 for z/OS can reduce the total DB2 CPU demand from 5-20%, compared to DB2 9, when you take advantage of all the enhancements. Many CPU reductions are built in directly to DB2, requiring no application changes. Some enhancements are implemented through normal DB2 activities through rebinding, restructuring database definitions, improving applications, and utility processing. The CPU demand reduction features have the potential to provide significant total cost of ownership savings based on the application mix and transaction types. Improvements in optimization reduce costs by processing SQL automatically with more efficient data access paths. Improvements through a range-list index scan access method, list prefetch for IN-list, more parallelism for select and index insert processing, better work file usage, better record identifier (RID) pool overflow management, improved sequential detection, faster log I/O, access path certainty evaluation for static SQL, and improved distributed data facility (DDF) transaction flow all provide more efficiency without changes to applications. These enhancements can reduce total CPU enterprise costs because of improved efficiency in the DB2 10 for z/OS. DB2 10 includes numerous performance enhancements for Large Objects (LOBs) that save disk space for small LOBs and that provide dramatically better performance for LOB retrieval, inserts, load, and import/export using DB2 utilities. DB210 can also more effectively REORG partitions that contain LOBs. This IBM Redbooks® publication® provides an overview of the performance impact of DB2 10 for z/OS discussing the overall performance and possible impacts when moving from version to version. We include performance measurements that were made in the laboratory and provide some estimates. Keep in mind that your results are likely to vary, as the conditions and work will differ. In this book, we assume that you are somewhat familiar with DB2 10 for z/OS. See DB2 10 for z/OS Technical Overview, SG24-7892-00, for an introduction to the new functions.