Home Page Icon
Home Page
Table of Contents for
Front cover
Close
Front cover
by Cristian Molaro, Glenn McGeoch, Sabine Kaschta, Ravikumar Kalyanasundaram, Felip
DB2 11 for z/OS Technical Overview
Front cover
Figures
Tables
Examples
Notices
Trademarks
Preface
Authors
Now you can become a published author, too!
Comments welcome
Stay connected to IBM Redbooks publications
Chapter 1. DB2 11 for z/OS at a glance
1.1 Subsystem
1.2 Application functions
1.3 Operations and performance
Part 1 Subsystem
Chapter 2. Synergy with System z
2.1 Synergy with IBM zEnterprise System
2.1.1 Faster CPU speed
2.1.2 More system capacity
2.1.3 zEC12 hardware features
2.2 Synergy with IBM System z and z/OS
2.2.1 AUTOSIZE options VPSIZEMIN and VPSIZEMAX
2.2.2 1 MB page frames for DB2 execution code
2.2.3 Improved performance of batch updates in data sharing
2.2.4 Improved usability and consistency for security administration
2.2.5 Log writing
2.3 Using zIIP speciality processors
2.4 Reduced need for REORG
2.5 DFSMS storage tiers
2.5.1 Use cases for storage tiers
2.5.2 Setup and invocation of storage tiers
2.5.3 Use cases for DB2
2.6 Additional System z enhancements
2.6.1 Enhancing DB2 BACKUP SYSTEM solution
2.6.2 z/OS DFSMS VSAM RLS for z/OS catalog support
2.6.3 DDF Synchronous Receive support
2.6.4 zEnterprise Data Compression
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.2.1 Syntax extension
3.2.2 Undo processing for NOT LOGGED DGTTs
3.2.3 Thread reuse
3.2.4 Sample scenarios
3.3 More open data sets (DSMAX)
3.4 PBG mapping tables to lift the 64 GB limit
3.4.1 Autonomic creation of the mapping table
3.4.2 Mapping tables up to 16 TB
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.2.1 RESTORE SYSTEM after two-pass LPL/GRECP recovery has occurred
4.2.2 RECOVER INDEX after two-pass LPL/GRECP recovery has occurred
4.3 Improved availability when altering limit keys
4.3.1 Considerations for tables containing LOBs
4.3.2 LOAD REPLACE
4.3.3 RECOVER
4.4 Work file database enhancements
4.4.1 WFSTGUSE_AGENT_THRESHOLD subsystem parameter
4.4.2 WFSTGUSE_SYSTEM_THRESHOLD subsystem parameter
4.4.3 Systems programmer response to DSNI052I/DSNI053I
4.5 Governing of parallel processing of utilities
4.6 Compression dictionary availability for CDC tables
4.7 DROP column support
4.7.1 Changes to the catalog as a result of dropping a column
4.7.2 Undo a DROP COLUMN
4.7.3 Impact of DROP COLUMN on utilities
4.7.4 Impact of DROP COLUMN on applications
4.7.5 Restrictions for DROP COLUMN
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.10.1 Improvements for DDF threads
4.10.2 Improvements for non-DDF threads
Chapter 5. Data sharing
5.1 Group buffer pool write-around protocol
5.2 Improved castout processing
5.2.1 Reduced wait time for I/O completion
5.2.2 Reduced notify message size sent to castout owners
5.2.3 More granular class castout threshold
5.3 Improved DELETE_NAME performance
5.4 Restart light with CASTOUT option
5.5 Locking enhancements
5.5.1 Conditional propagation of child Update locks to the coupling facility
5.5.2 Improved performance in handling lock waiters
5.5.3 Increase in maximum number of CF lock table entries
5.5.4 Throttle batched unlock requests
5.5.5 Improved IRLM resource hash table algorithm
5.6 Index availability and performance
5.6.1 Avoid placing indexes in RBDP state during group restart
5.6.2 Reduce synchronous log writes during index structure modifications
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.2.1 DDL and catalog information
6.2.2 Qualifying global variables
6.2.3 Global variable’s scope
6.2.4 Global variable’s naming resolution
6.3 Array data type
6.3.1 Ordinary arrays
6.3.2 Associative arrays
6.3.3 ARRAY_EXISTS predicate
6.4 Aliases and public aliases for SEQUENCES
6.4.1 Private ALIAS for a SEQUENCE
6.4.2 Public ALIAS for a SEQUENCE
6.4.3 Dropping an alias for sequence
6.4.4 Security considerations
6.4.5 Considerations regarding application compatibility setting
6.5 New built-in functions
6.5.1 ARRAY_AGG
6.5.2 ARRAY_DELETE
6.5.3 ARRAY_FIRST
6.5.4 ARRAY_LAST
6.5.5 ARRAY_NEXT
6.5.6 ARRAY_PRIOR
6.5.7 CARDINALITY
6.5.8 MAX_CARDINALITY
6.5.9 TRIM_ARRAY
6.5.10 UNNEST (table function)
6.5.11 Arrays in MERGE statement
6.6 SET CURRENT APPLICATION COMPATIBILITY
6.7 Temporal special registers
6.7.1 Scope of session-level special registers
6.7.2 SYSTIMESENSITIVE and BUSTIMESENSITIVE
6.8 Temporal support on VIEWs
6.9 DGTT
6.10 CUBE, ROLLUP and GROUPING SETS
6.10.1 GROUPING SETS
6.10.2 ROLLUP
6.10.3 CUBE
6.10.4 Grand total
6.10.5 Grouping expression
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.3.1 Enhancing big data analytics with Apache Hadoop
7.3.2 Example HDFS_READ with a generic table UDF
7.3.3 Example JAQL_SUBMIT
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
8.1 XQuery support
8.1.1 FLWOR expressions
8.1.2 XQuery constructors
8.1.3 Conditional expressions
8.1.4 Built-in functions
8.1.5 XQuery prolog
8.2 XML performance enhancements in DB2 10 and DB2 11
8.2.1 Eliminate hotspots during XML insert
8.2.2 Validate binary XML
8.2.3 Avoid revalidation during LOAD
8.2.4 Partial revalidation
8.2.5 XMLTABLE performance improvements
8.3 XQuery FLWOR expressions performance enhancements
8.4 XMLTABLE performance enhancements in DB2 11
8.4.1 Date/Time predicate pushdown
8.4.2 Optimize index key range for varchar predicates
8.4.3 Pushdown of column casting into XPath
Chapter 9. Connectivity and administration routines
9.1 Client information enhancements
9.1.1 Expansion of the length of some Client information fields
9.1.2 Introduction the new client information field Client Correlation Token
9.1.3 Introduction of a new built-in session global variable
9.1.4 Using the client information fields
9.2 Cancel thread and cancel SQL statement improvements
9.2.1 Changes in Cancel DDF thread
9.2.2 Changes in SQL statement interruption processing
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
10.1 Enhancements for exit authorization checking
10.1.1 Use owner privileges for authorization
10.1.2 Refresh DB2 cache entries when RACF permissions change
10.2 Enhancements to program authorization
10.3 Column masking enhancements
10.3.1 Remove column access control restrictions for GROUP BY
10.3.2 Correct implementation of aggregate function with DISTINCT
10.3.3 Column access control for UNION
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.2.1 RUNSTATS RESET ACCESSPATH
11.2.2 RUNSTATS USE PROFILE usability for LISTDEF
11.3 Backup and recovery enhancements
11.3.1 SYSLGRNX recording for catalog and directory table
11.3.2 VCAT name translation for RESTORE SYSTEM
11.3.3 Remove the incompatibility of REORG and COPY
11.3.4 Removal of many point-in-time recovery restrictions
11.4 LOAD and UNLOAD enhancements
11.4.1 LOAD SHRLEVEL NONE with PARALLEL option
11.4.2 LOAD SHRLEVEL CHANGE with PARALLEL option
11.4.3 Addition of crossloader support for XML
11.4.4 More offload to zIIP with NPSIs
11.5 Compression dictionaries for Change Data Capture
11.6 General enhancements
11.6.1 DISPLAY UTILITY additional output
11.6.2 Improved TEMPLATE for extended format data sets
11.6.3 DSN1COPY
11.6.4 REPAIR utility
11.6.5 Command to externalize RTS statistics
11.6.6 DSNACCOX
11.7 Deprecated functions
Chapter 12. Installation and migration
12.1 Currency of versions and migration paths
12.2 Prerequisites for DB2 11
12.2.1 Processors
12.2.2 Auxiliary storage
12.2.3 Operational requirements
12.2.4 Optional program requirements
12.3 DB2 11 installation changes and considerations
12.3.1 More support of naming standards in install and IVP jobs
12.3.2 No more EDM calculations
12.3.3 Modified installation jobs
12.3.4 New installation job DSNTIJCB
12.3.5 Miscellaneous
12.4 Considerations for migrating to DB2 11
12.4.1 Premigration considerations
12.4.2 DB2 11 CM
12.4.3 DB2 11 ENFM and NFM
12.5 Subsystem parameters
12.5.1 New system parameters
12.5.2 Changed defaults for existing system parameters
12.5.3 Removed system parameters
12.5.4 Deprecated system parameters
12.6 Release incompatibilities
12.6.1 Application and SQL release incompatibilities
12.6.2 Utility release incompatibilities
12.6.3 Command release incompatibilities
12.6.4 Storage release incompatibilities
12.6.5 Functions that are deprecated
12.6.6 Functions that are no longer supported
12.7 Controlling application compatibility
12.7.1 Example of DB2 10 application compatibility
12.7.2 Overview of application compatibility in DB2 11
Chapter 13. Performance
13.1 Performance expectations
13.2 System level performance
13.2.1 Internal optimization
13.2.2 Logging
13.2.3 Synergy with System z
13.2.4 Buffer management
13.2.5 Data sharing
13.3 Reduced need for REORG
13.3.1 Asynchronous removal of pseudo-deleted indexes
13.3.2 Indirect reference avoidance
13.4 More opportunities for RELEASE(DEALLOCATE)
13.5 Optimizer enhancements
13.5.1 Identification of critical statistics for improved query performance
Part 4 Appendixes
Appendix A. Information about IFCID changes
A.1 New IFCIDs
A.2 Aggregate accounting overview and purpose
A.3 IFCID 53 and 58 enhancements overview
A.4 Accounting trace enhancements overview
A.5 IRLM Storage Accounting enhancement
A.6 Stored procedure monitoring overview and purpose
A.7 Other accounting changes
Appendix B. Summary of relevant maintenance
B.1 DB2 APARs
B.2 z/OS APARs
B.3 OMEGAMON PE APARs
Related publications
IBM Redbooks publications
Other publications
Online resources
Help from IBM
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 xxi.
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