Home Page Icon
Home Page
Table of Contents for
Front cover
Close
Front cover
by Acacio Ricardo Gomes Pessoa, Tammie Dang, Meg Bernal
IBM DB2 12 for z/OS Technical Overview
Front cover
Notices
Trademarks
Preface
Authors
Now you can become a published author, too!
Comments welcome
Stay connected to IBM Redbooks
Part 1 Overview
Chapter 1. DB2 12 for z/OS at a glance
1.1 Subsystem
1.2 Application functions
1.3 Operations and performance
Chapter 2. Continuous delivery
2.1 Function level
2.1.1 Star function level
2.2 Catalog level
2.3 Code level
2.4 Activating a function level
2.5 DISPLAY GROUP command
2.6 Catalog changes
2.6.1 The SYSIBM.SYSLEVELUPDATES table
2.7 Application compatibility (APPLCOMPAT)
2.7.1 Managing applications through function level changes
2.7.2 Data Definition Language (DDL) statements sensitive to APPLCOMPAT
2.8 SQL processing option SQLLEVEL
2.9 New built-in global variables
2.9.1 PRODUCTID_EXT
2.9.2 CATALOG_LEVEL
2.9.3 DEFAULT_SQLLEVEL
2.10 DB2 supplied stored procedures
2.10.1 ADMIN_COMMAND_DB2
2.10.2 GET_CONFIG
2.11 Resource access control facility exit
2.12 Instrumentation
Part 2 Subsystem
Chapter 3. Scalability
3.1 Range-partitioned table spaces changes
3.1.1 PBR RPN table space characteristics
3.1.2 PBR RPN partitioned index characteristics
3.1.3 PBR RPN non-partitioned index characteristics
3.1.4 PBR RPN considerations
3.2 DB2 internal latch contention relief
3.3 Buffer pool simulation
3.4 Support for sizes greater than 4 GB of active log data sets
Chapter 4. Availability
4.1 Improved availability for pending definition changes
4.1.1 Altering index compression attribute
4.1.2 Altering column
4.2 Catalog availability improvements
4.2.1 Handling dynamic SQL statement
4.2.2 Single phase catalog migration
4.3 Removal of point-in-time recovery restrictions for PBG table spaces
4.4 PBR RPN DSSIZE increase
4.5 Insert partition
4.6 REORG enhancements for PBGs, FlashCopy and LOBs
4.6.1 Partition-by-growth (PBG)
4.6.2 FlashCopy
4.6.3 Large object (LOB)
4.7 LOAD RESUME YES BACKOUT YES option
4.8 Faster point-in-time recovery
4.8.1 Single object by defaulting to the PARALLEL(1) option
4.8.2 SCOPE UPDATED keyword
4.9 TRANSFER OWNERSHIP SQL statement
4.10 Auto-retry of GRECP and LPL recovery
Chapter 5. Data sharing
5.1 DISPLAY GROUP command
5.2 XA support for global transactions
5.3 Peer recovery
5.4 Automatic retry of GRECP and LPL recovery
5.5 Improved lock avoidance checking
5.6 Asynchronous lock duplexing
Part 3 Application functions
Chapter 6. SQL
6.1 Introduction
6.2 Additional support for triggers
6.2.1 Basic triggers
6.2.2 Advanced triggers
6.2.3 Differences between basic triggers and advanced triggers
6.2.4 Maintaining trigger activation order
6.3 Pagination support
6.3.1 Returning a subset of rows
6.3.2 Data-dependent pagination support
6.3.3 Numeric-based pagination
6.4 Additional support for arrays
6.4.1 Arrays as global variables
6.4.2 Associative array support on ARRAY_AGG aggregate function
6.4.3 Optional ORDER BY clause on ARRAY_AGG aggregate function
6.5 MERGE statement enhancements
6.5.1 Additional source value support
6.5.2 Additional data modification support
6.5.3 Additional matching condition option
6.5.4 Additional predicates on matching conditions support
6.5.5 Atomicity
6.5.6 Enhanced MERGE statement example
6.6 New built-in functions
6.6.1 Aggregate functions for statistics
6.6.2 Scalar functions for hashing
6.6.3 GENERATE_UNIQUE_BINARY scalar function
6.6.4 VARCHAR_BIT_FORMAT scalar function enhancement
6.7 Enhanced built-in function support
6.7.1 TIMESTAMP scalar function enhancement
6.7.2 XMLMODIFY scalar function enhancement
Chapter 7. Application enablement
7.1 Ensuring application compatibility
7.2 Temporal table enhancements
7.2.1 Enhanced application periods
7.2.2 Referential constraints for temporal tables
7.2.3 Temporal logical transactions
7.2.4 Auditing capabilities using temporal tables
Chapter 8. Connectivity and administration routines
8.1 Maintaining session data on the target server
8.2 Preserving prepared dynamic statements after a ROLLBACK
8.3 DRDA fast load
8.4 Profile monitoring for remote threads and connections
8.4.1 Automatic start of profiles during subsystem start
8.4.2 Support for global variables
8.4.3 Support for wildcarding
8.4.4 Idle thread enhancement
8.5 Stored procedures supplied by DB2
Part 4 Operations and performance
Chapter 9. Administrator function
9.1 Dynamic plan stability
9.1.1 Stabilization into and loading from catalog tables
9.1.2 Stabilization method
9.1.3 Catalog tables
9.1.4 Calculating the EDM statement cache hit ratio
9.1.5 Invalidation of stabilized dynamic statements
9.1.6 EXPLAIN changes
9.1.7 The FREE STABILIZED DYNAMIC QUERY subcommand
9.1.8 Monitor for stabilization
9.1.9 DSNZPARM and installation panel
9.2 Resource limit facility for static SQL
9.2.1 Reactive governing static SQL
9.2.2 Use cases
9.2.3 RLF DSNZPARMs and installation panels
9.3 Column level deferred alter (pending alter column)
9.3.1 Utility
9.3.2 ALTER INDEX
9.4 Insert partition
9.4.1 ALTER ADD PARTITION
9.4.2 Utilities affected
9.4.3 Catalog changes
Chapter 10. Security
10.1 Installation or migration without requiring SYSADM
10.2 UNLOAD privilege
10.2.1 Enforcing new privilege
10.2.2 Using DB2 security facility
10.2.3 Using Resource Access Control Facility (RACF)
10.3 Object ownership transfer
10.3.1 Supported objects
10.3.2 New owner
10.3.3 Revoking privileges of current owner
Chapter 11. Utilities
11.1 Backup and recovery enhancements
11.1.1 Sequential image copy enhancements
11.1.2 Copy support for FASTREPLICATION
11.1.3 Alternate copy pools for system-level backups
11.1.4 FLASHCOPY_PPRCP keyword option
11.1.5 Point-in-time recovery enhancements
11.1.6 MODIFY RECOVERY enhancements
11.2 RUNSTATS enhancements
11.2.1 Specifying FREQVAL without the COUNT n keywords
11.2.2 USE PROFILE support for inline statistics
11.2.3 INVALIDATECACHE option
11.2.4 RUNSTATS TABLESPACE LIST INDEX improvements
11.2.5 New keyword REGISTER for RUNSTATS utility
11.3 REORG enhancements
11.3.1 Improved FlashCopy management
11.3.2 Preventing COPY-pending on a LOB table space during REORG of PBG
11.3.3 Improved partition-level PBG REORGs
11.3.4 REORG option for empty PBG partitions deletion
11.3.5 Support for the COMPRESSRATIO catalog column
11.3.6 Display claimers information on each REORG drain failure
11.3.7 Additional REORG enhancements
11.4 LOAD and UNLOAD enhancements
11.4.1 LOAD enhancements
11.4.2 UNLOAD enhancements
Chapter 12. Installation and migration
12.1 Prerequisites for DB2 12
12.1.1 Data sharing
12.1.2 Processor requirements
12.1.3 Software requirements
12.1.4 DB2 Connect prerequisites
12.1.5 Programming language requirements, minimum levels
12.1.6 Minimum configuration (IEASYSxx)
12.2 Single-phase migration and function level
12.2.1 Fallback SPE
12.2.2 EARLY code
12.2.3 Pre-migration checkout
12.2.4 Creating DSNZPARM and DECP modules
12.2.5 Creating and verifying routines supplied by DB2
12.2.6 REBIND at each new release
12.2.7 Activating new function level
12.2.8 Deprecated in earlier releases and removed in DB2 12
12.3 Installing a new DB2 12 system
12.3.1 Defines DB2 to z/OS
12.4 Subsystem parameters
12.4.1 New subsystem parameters
12.4.2 Removed subsystem parameters
12.4.3 Install Parameters Default Changes
12.4.4 Deprecated system parameters
12.5 Installation or migration without requiring SYSADM
12.6 Installation with z/OS Management Facility (z/OSMF)
12.6.1 How to use DB2 installation CLIST and panels to generate z/OSMF artifacts
12.6.2 Feeding the generated artifacts to z/OSMF
12.7 Temporal catalog
12.7.1 System-period data versioning for two RTS catalog tables
12.7.2 Real-time statistics externalization during migration
Chapter 13. Performance
13.1 Performance expectations
13.2 In-memory buffer pool
13.3 In-memory index optimization
13.4 Improved insert performance for non-clustered data
13.4.1 DDL clause on CREATE TABLESPACE and ALTER TABLESPACE
13.4.2 SYSIBM.SYSTABLESPACE new column: INSERTALG
13.4.3 ZPARM: DEFAULT_INSERT_ALGORITHM
13.5 Query performance enhancements
13.5.1 UNION ALL and Outer Join enhancements
13.5.2 Sort improvements
13.5.3 Predicate optimization
13.5.4 Execution time adaptive index
Part 5 Appendixes
Appendix A. Information about IFCID changes
IFCID header changes
New IFCIDs
Application compatibility IFCID changes
Dynamic SQL plan stability IFCID changes
Fast INSERT IFCID changes
Lift partition limits IFCID changes limits
Large object (LOB) compression IFCID changes
Transfer ownership IFCID changes
UNLOAD privilege for UNLOAD utility IFCID changes
Additional changed IFCIDs
Appendix B. Additional material
Locating the web material
Downloading and extracting the web material
Back cover
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Note: Before using this information and the product it supports, read the information in “Notices” on page ix.
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset