Nouveautés V9 DB2 Exploitation systèmes

2 jours | 4-DB739

Formations Informatiques > Base de données > Les Bases de Données DB2 for Z/OS

Prochaines sessions inter-entreprises

• Du 21/06/2012 au 22/06/2012
• Du 13/09/2012 au 14/09/2012
• Du 11/10/2012 au 12/10/2012
• Du 29/11/2012 au 30/11/2012

Objectifs

Gérer et administrer la Version 9.

Participants / Pré-requis

Maîtrise des fonctionnalités de DB2 V8.

Contenu

DB2& SYSTEM z (zIIPs)

• Synergy with new I/O and new CPU hardware System z9 Integrated
• Information Processor and speciality engines

EVOLUTIVITE

• Virtual storage management
• WLM assisted buffer pool management
• NOT LOGGED table spaces
• WLM to resolve lock contention
• Universal table space
• Reordered row format
• Index compression
• Native SQL procedures

DISPONIBILITE

• Universal table space support and partitioning Clone table option
• Recovery to point in time with consistency APPEND Conditional Restart
• Log Truncation by Timestamp REFRESH for EARLY code RENAME INDEX RENAME
• COLUMN UPDATE SCHEMA Toleration of DBET errors during DB2 restart

DATA SHARING

• Logging improvement
• Index enhancements
• Reduction in LOB locks
• Locking constraint enhancements
• Group buffer pool enhancements
• Improved WLM routing based on DB2 health Improved workload balancing
• within the same LPAR Open dataset enhancements Enhanced messages for p-locks Initiating Auto GRECP
• recovery at the end of restart Opening
• data sets earlier in restart processing Allowing table level retained locks to support postponed abort URs
• Improvement for open processing
• Coupling Facility Control Code (CFCC) Level 15

APPLICATION

• Automatic creation of objects
• Index on expression
• Optimistic concurrency control and update detection Cultural sort and
• case insensitive comparison CURRENT SCHEMA Skip locked rows FETCH
• CONTINUE Allow ALTER TABLE ... LONG VARCHAR TO VARCHAR RENAME COLUMN
• RENAME INDEX SMS constructs Native SQL procedures Nested compound statements in SQL stored procedures
• New stored procedure related
• special registers
• DB2 and DSN commands for native SQL procedures

SQL

• New data types
• INSTEAD OF triggers
• MERGE
• SELECT FROM MERGE/UPDATE/DELETE
• ORDER BY and FETCH FIRST in subselect
• TRUNCATE
• INTERSECT and EXCEPT

XML

• XML with DB2 for z/OS, usage
• Pure XML
• XML support
• Accessing XML data
• XPath
• XML indexing
• XML schema support
• XML schema validation
• XML decomposition
• Utilities support of XML data

SECURITE

• Security functions overview
• Improved tracing
• View maintenance
• Backing up a DBA, assuming the identity of another user ID Securing
• DBA activities Reducing risk of a table being dropped by another person

UTILITAIRES

• REORG enhancements
• CLONE TABLE support
• BACKUP and RESTORE SYSTEM
• RECOVER enhancements
• LOAD enhancements
• Histogram statistics
• COPY improvements
• TEMPLATE switching
• MODIFY RECOVERY
• DSN1LOGP message enhancement
• Online CHECK DATA
• Online CHECK LOB
• REPAIR LOCATE SHRLEVEL CHANGE
• DB2I and DSNU CLIST enhancement
• Online REBUILD INDEX
• Time stamps in messages
• Large format data sets
• Support of large block interface
• DSN1COPY RESET enhancement
• DSNJU004

INSTALLATION ET MIGRATION

• Currency of versions and migration paths
• DB2 V9 packaging
• Changes to installation and migration
• Removal of support for DB2-managed stored procedures Installation and migration overview Migration and
• coexistence Fallback DSNZPARM change
• summary

PERFORMANCE DU SOUS-SYSTEME DB2

• CPU utilisation (e.g., OLTP processing, query processing and column processing)
• Virtual storage constraint relief
• Real storage
• Latch class contention relief
• Accounting trace overhead
• Reordered row format
• Buffer manager enhancements
• WORKFILE and TEMP database merge
• Native SQL procedures
• Index lookaside
• Enhanced preformatting
• Hardware enhancements