Programme du cours

2 jours (14 H) | 4-DB739Renseignez-vousCette formation vous intéresse ? 
 

Objectifs

Gérer et administrer la Version 9.

Participants / Pré-requis

DBA Etudes, Production et Système.

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
 
Cette formation vous intéresse ? Renseignez-vous