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 MVS™. 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.
Table of contents
- Front cover
- Figures
- Tables
- Examples
- Notices
- Preface
- Chapter 1. DB2 11 for z/OS at a glance
- Part 1 Subsystem
- Chapter 2. Synergy with System z
-
Chapter 3. Scalability
-
3.1 Extended RBA and LRSN
- 3.1.1 Reaching the end of the basic RBA
- 3.1.2 The new 10 byte RBA and LRSN
- 3.1.3 Considerations before converting to extended format
- 3.1.4 Steps for enabling the extended RBA/LRSN format
- 3.1.5 Converting the BSDS
- 3.1.6 Converting DB2 catalog and directory
- 3.1.7 Converting data from 6 byte to 10 byte RBA/LRSN or vice versa
- 3.1.8 Additional considerations regarding utilities
- 3.2 NOT LOGGED for declared global temporary tables
- 3.3 More open data sets (DSMAX)
- 3.4 PBG mapping tables to lift the 64 GB limit
-
3.1 Extended RBA and LRSN
-
Chapter 4. Availability
-
4.1 Online schema changes and enhanced recovery options
- 4.1.1 Scope of enhancements for online schema changes in DB2 11
- 4.1.2 How it works
- 4.1.3 Effect of MODIFY RECOVERY
- 4.1.4 Considerations for LOBs
- 4.1.5 Restrictions for the window between PIT recovery and REORG
- 4.1.6 More restrictions for PIT recovery after materializing REORG
- 4.1.7 Determine if a table space is eligible for PIT recovery prior to REORG
- 4.2 Automatic recovery of indexes from GRECP or LPL status
- 4.3 Improved availability when altering limit keys
- 4.4 Work file database enhancements
- 4.5 Governing of parallel processing of utilities
- 4.6 Compression dictionary availability for CDC tables
- 4.7 DROP column support
- 4.8 Defer define object enhancements
- 4.9 Allow BIND, REBIND, and DDL to break-in persistent threads
- 4.10 Idle thread break-in
-
4.1 Online schema changes and enhanced recovery options
-
Chapter 5. Data sharing
- 5.1 Group buffer pool write-around protocol
- 5.2 Improved castout processing
- 5.3 Improved DELETE_NAME performance
- 5.4 Restart light with CASTOUT option
- 5.5 Locking enhancements
- 5.6 Index availability and performance
- 5.7 Group buffer pool write performance
- 5.8 Automatic LPL recovery at end of restart
- 5.9 Log record sequence number spin avoidance
- Part 2 Application functions
-
Chapter 6. SQL
- 6.1 Introduction
- 6.2 Global variables
- 6.3 Array data type
- 6.4 Aliases and public aliases for SEQUENCES
- 6.5 New built-in functions
- 6.6 SET CURRENT APPLICATION COMPATIBILITY
- 6.7 Temporal special registers
- 6.8 Temporal support on VIEWs
- 6.9 DGTT
- 6.10 CUBE, ROLLUP and GROUPING SETS
- 6.11 ALTER TABLE DROP COLUMN
- 6.12 LIKE_BLANK_INSIGNIFICANT DSNZPARM
-
Chapter 7. Application enablement
- 7.1 Ensuring application compatibility
-
7.2 Transparent archiving of temporal data
- 7.2.1 Controls of archive transparency
- 7.2.2 Sample code for enabling archive transparency
- 7.2.3 Inserting rows into archive enabled table
- 7.2.4 Deleting rows from an archive enabled table
- 7.2.5 Querying archive enabled table
- 7.2.6 Using a dynamic transaction with archive transparency
- 7.2.7 Static application scenario
- 7.2.8 DISABLE ARCHIVE
- 7.2.9 Analytics Accelerator - HPSS considerations
- 7.3 Providing support for big data
- 7.4 Using the scoring adapter to add predictive analytics to OLTP applications
- 7.5 Using JavaScript Object Notation with IBM DB2
- 7.6 Suppressing null indexes
- Chapter 8. XML
-
Chapter 9. Connectivity and administration routines
- 9.1 Client information enhancements
- 9.2 Cancel thread and cancel SQL statement improvements
- 9.3 Continuous block fetching
- 9.4 Support for global variables
- 9.5 Local stored procedure execution improvement
- 9.6 Multi-threaded Java stored procedure environment
- 9.7 ADMIN_COMMAND_MVS stored procedure
- 9.8 Drivers, clients, and connectivity requirements
- Part 3 Operations and performance
- Chapter 10. Security
-
Chapter 11. Utilities
-
11.1 Online REORG enhancements
- 11.1.1 Improve performance of partition-level REORG with non partitioned secondary indexes
- 11.1.2 SWITCH phase impact reduction
- 11.1.3 Physically delete empty partition-by-growth partitions
- 11.1.4 Automated REORG mapping table management
- 11.1.5 REORG without SORTing data
- 11.1.6 Partition-level inline image copy
- 11.1.7 Improved REORG LISTDEF processing
- 11.1.8 REBALANCE enhancements
- 11.1.9 REORG of LOB enhancements
- 11.1.10 Improved REORG serviceability
- 11.1.11 REORG change of defaults to match preferred practices
- 11.2 Enhanced statistics
- 11.3 Backup and recovery enhancements
- 11.4 LOAD and UNLOAD enhancements
- 11.5 Compression dictionaries for Change Data Capture
- 11.6 General enhancements
- 11.7 Deprecated functions
-
11.1 Online REORG enhancements
- Chapter 12. Installation and migration
- Chapter 13. Performance
- Part 4 Appendixes
- Appendix A. Information about IFCID changes
- Appendix B. Summary of relevant maintenance
- Related publications
- Back cover
Product information
- Title: DB2 11 for z/OS Technical Overview
- Author(s):
- Release date: December 2013
- Publisher(s): IBM Redbooks
- ISBN: 9780738439051
You might also like
book
IBM DB2 12 for z/OS Technical Overview
IBM® DB2® 12 for z/OS® delivers key innovations that increase availability, reliability, scalability, and security for …
book
DB2 10 for z/OS Performance Topics
DB2® 10 can reduce the total DB2 CPU demand from 5-20% when you take advantage of …
book
DFSMShsm Fast Replication Technical Guide
DFSMShsm fast replication provides DFSMShsm management for the use of volume-level fast replication. Fast replication is …
book
DB2 Administration Solution Pack for z/OS: Streamlining DB2 for z/OS Database Administration
IBM® DB2® tools for z/OS® support and exploit the most current versions of DB2 for z/OS. …