This seminar details the new features coming in DB2 9 for z/OS. DB2 9 is bringing new life to our already robust DB2 z/OS database management system. These new features go well beyond the boundaries that were present in the past and also open up new opportunities and uses for the DB2 z/OS platform in terms of data storage and application exploitation. DB2 9 for z/OS brings new business insight innovations, cost savings through optimization and business resiliency. We will take a detailed look at the new features and as always we look closely at the new performance features.
Key Points:
- Discuss overall objectives of DB2 9
- Discuss new database availability features
- Look at the new SQL and optimization features
- Review new utilities options
- Look at new application/database features such as XML
Outline:
- Availability
- Online Reorg with no BUILD2 phase
- Rename column and index
- Alter index/change page size
- Modify early code without IPL
- Restart improvements
- Table replacement
- Scalability
- Table space partitioning by growth
- Log latch contention reduction
- CREATE/ALTER STOGROUP SMS constructs
- New table space type
- Logging improvements
- Memory improvements
- Larger index page sizes
- Application Development
XML
- Powerful querying and transformation capabilities
- Native SQL Procedure Language
- Data Types
- BIGINT, VARBINARY, BINARY, DECIMAL FLOAT
- Built in functions
- LOB File reference variable
SQL
- MERGE and TRUNCATE
- SELECT FROM UPDATE, DELETE MERGE
- INSTEAD OF trigger
- FETCH FIRST and ORDER BY in subselect and fullselect
- INTERSECT and EXCEPT
- OLAP extensions
- RANK, DENSE_RANK, ROW_NUMBER
- Caseless expressions
- Cultural Sort
Performance
- Optimistic Locking
- Index on Expression
- Randomization
- Large index page sizes
- Improved handling of index page splits
- Improved Optimization
- Histogram Statistics
- Cross query block optimization
- Generalize space index and in memory data cache method
- Dynamic index ANDing for star schema
- Nested Compound
- Load and Reorg CPU reductions
- Improved varying length data
- Improved logging and inserts
Security
- ROLEs
- Network Trusted Context
- Enhanced Auditing
- Encryption enhancements
- Secure Socket Layer (SSL)
Usability
- OSC – Optimization Service Center
- WLM
- Used to adjust bufferpool sizes
- Backup and Restore
- Truncate Table
If you have any questions or wish to request a class, please contact YL&A at
info@ylassoc.com
We are now also offering transition consulting!
Version 8 for DB2 on z/OS is the largest release in DB2s history and it impacts several areas of our DB2 subsystem and applications. The theme for V8 is ‘Breaking the Limits’ and it does so in many places. Many old restrictions have been lifted and there are even new areas of memory to take advantage of. There are also several new constructs in DB2 in the next release such as data partitioned secondary indexes (DPSI)s and table based partitioning that are going to change the way we have performed physical implementations in the past. There are also many new features that will effect of application performance such as materialized query tables, multi-row fetch/insert, sequences and more. Other features include improvements to Java, XML, backup and recovery, and much more. If you are not going to take advantage of the new features V8 has to offer, you will simply be paying the price in overhead just to have this new release. V8 also has a different type of migration and more dependencies (hardware and software) than previous releases that will take more coordination and planning, and that needs to start now. Are you ready?
Outline:
- SQL
- Materialized Query Tables
- Multi-row FETCH and INSERT
- INSERT within SELECT
- Multiple DISTINCTs
- Group By Expression
- Dynamic Scrollable Cursors
- Enhancements to Identity Columns
- Sequence Objects
- More built-in Functions
- Encryption
- GET_VARIABLE
- GET_UNIQUE
- Recursion
- Common Nested Table Expressions
- Optimization and Performance
- Volatile Tables
- Star Join Improvements
- Declared Temp Improvements
- Stage 1 promotion for unlike types
- In list processing
- Lock avoidance enhancements
- UDF enhancements
- EXPLAIN of Dynamic SQL Cache
- DSN_DYNAMIC_STATEMENT_CACHE
- 9 New EXPLAIN tables
- New special registers
- 2MB SQL Statements
- Up to 225 Tables in a Join
- Indexes and Tablespaces
- Backward scanning of indexes
- Varying length indexes
- Distribution statistics on non-index columns
- More matching predicates
- Star Join Sparse Indexes
- Data Partitioned Secondary Indexes (DPSIs)
- Table Controlled Partitioning
- Adding and Rotating Partitions
- Utility Enhancements
- Frequency Distribution Statistics
- Delimited UNLOAD/LOAD
- Parallel COPY/RECOVER Using Tape
- Repair Enhancements
- Online Check Index
- Cross Loader with LOB Support
- System Level PIT Recovery
- SORTKEYS/SORTDATA Default Impacts
- Data Sharing Improvements
- Less XES Contention
- CASTOUT performance improvements
- Locking Improvements
- RESTART LIGHT Improvement
- System Administration
- Improved LPL Recovery
- More Archive and Active Logs
- Aggregated Accounting Data
- Enhanced IFCIDs
- Catalog Changes
- Unicode Support
- Enhancements to Visual Explain and DB2 Estimator
- Control Center Enhancements
- Multi-Level Security
- Network Computing and XML
- DRDA Enhancements
- Universal Driver
- ODBC, JDBC and REXX Enhancements
- Java Enhancements
- SQL Procedure Language Enhancements
- Stored Procedure and UDF Improvements
- XML Support with Built-in Functions
- SQL Statements up to 2MB
- XML Extender
- Installation and Migration Considerations
- Three Migration Modes
- Proper Release Levels
- Discontinued Support Items
- Rebinds
- NEWFUN
- Catalog Reorgs and DFSORT
- How to Prepare
- What to Test
If you have any questions or wish to request a class, please contact YL&A at
info@ylassoc.com
