|
|
 |
|
|
|
DB2 for z/OS
|
DB2 for OS/390
|
DB2 for MVS
|
|
|
|
|
|
Die abgebildeten Tabellen erheben nicht den Anspruch auf Vollständigkeit, Sie sollen dem Leser lediglich einen Überblick über die wichtigsten Eigenschaften verschaffen. Weitergführende Informationen finden Sie in den "General Overview" oder "What´s New" Broschüren der IBM!
|
|
Wichtige Links im Zusammenhang mit Versions-Ständen und End of Service Informationen
|
|
Neuerung der DB2 UDB Version 9 for z/OS: GA 16.03.2007
Announcement: http://www-306.ibm.com/common/ssi/fcgi-bin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=877&letternum=ENUSZP07-0158
- Rich hybrid data server support for both relational and pureXML storage, with the necessary services to support both data structures.
- New data types (DECFLOAT, BIGINT, and VARBINARY)
- Native SQL procedural language.
- Improved security with roles, trusted context, and new encryption functions
- Extensions of DB2 for z/OS V8 capabilities to make changes to the data.
- Enhancements to large object support and performance.
- Volume-based copy and recover
- Refinements to the DB2 industry-leading optimization
- QMF interface design changes that provide on demand access to data, reports, and interactive visual solutions with optional Web browser
- Enablement for IBM System z Integrated Information Processors (zIIP)
- Some selected Details:
- SHRLEVEL(REFERENCE) for REORG of LOB table spaces
- Online RENAME COLUMN
- Online RENAME INDEX
- Online CHECK DATA and CHECK LOB
- Faster REORG by intra-REORG parallelism
- More online REORG by eliminating BUILD2 phase
- LOB Lock reduction
- Skipping locked rows option
- Online REBUILD INDEX
- Change SCHEMA & VCAT
- Tape support for BACKUP and RESTORE SYSTEM utilities
- Recovery of individual tablespaces and indexes from volume-level backups
- Enhanced STOGROUP definition
- Utility TEMPLATE switching
- Conditional restart: automatic search for appropriate checkpoint
- CLONE Table: fast replacement of one table with another
- Buffer management by WLM
- Global query optimization
- Generalizing sparse index and in-memory data caching method
- Optimization Service Center
- Autonomic reoptimization
- Logging enhancements
- LOBs Network Flow Optimization
- Faster operations for variablelength rows
- NOT LOGGED table spaces
- Index on expressions
- Universal Table spaces
- Partition-by-growth table spaces
- APPEND option at insert
- Autonomic index page split
- Index page sizes 8K, 16K, 32K
- Support for optimistic locking
- Faster and more automatic DB2 restart
- MODIFY RECOVERY enhancements
- RLF improvements for remote application servers such as SAP
- Preserving consistency when recovering individual objects to a prior point in time
- DECIMAL FLOAT, BIGINT
- VARBINARY, BINARY
- TRUNCATE TABLE statement
- MERGE statement
- FETCH CONTINUE
- ORDER BY and FETCH FIRST n ROWS in sub-select and full-select
- ORDER OF extension to ORDER BY
- Various scalar functions
- XML support in DB2 engine
- Native SQL Stored Procedures, able to use zIIP
- SELECT FROM UPDATE/DELETE/MERGE
- Enhanced CURRENT SCHEMA
- IPv6 support
- Unified Debugger
- Network Trusted Context
- Database ROLEs
- Automatic creation of database objects
- Modify early code without requiring an IPL
- Utilities CPU reduction
- Temporary space consolidation
- und mehr ...
|
|
Neuerungen der DB2 UDB Version 8 for z/OS: GA in 03/2004
Zusammengefaßt:
- SQL Erweiterungen:
- SELECT FROM INSERT statement
- Generation of unique sequential numbers for applications
- Ability to alter identity column attributes
- Dynamic scrollable cursors
- Scalar fullselects in SQL statements
- Integrated XML publishing functions in DB2
- Common table expressions in SQL statements
- Recursive SQL
- CURRENT PACKAGE PATH special register
- GET DIAGNOSTICS statement
- More than one DISTINCT keyword allowed in a single query
- Größere Sicherheit:
- New built-in functions for data encryption and decryption
- New data encryption tool
- Multilevel security with row-level granularity
- Easier identification of system users
- Session variables
- Improved encrypted security in distributed computing environments
- Größer Kompatibilität zwischen den Mitgliedern der DB2 Family:
- Extended limits for names and SQL statements
- Significant support for Unicode and long names in the DB2 catalog
- Network computing enhancements
- IBM z/OS Application Connectivity to DB2 for z/OS feature
- ODBC expands support for encoding schemes
- Unicode, längere Objektnamen, Änderungen im DB2 Catalog:
- Unicode
- Long names
- Unicode, EBCDIC, and ASCII columns in the same SQL statement
- Skalierbarkeit und Performance:
- 64-bit virtual storage
- Materialized query tables
- Ability to use an index in more situations
- Additional distribution statistics for improved optimization
- Improved optimization for dynamic SQL
- Improved trigger performance
- More parallelism for sort operations
- Performance enhancements for star join qualified queries
- Multiple fetches and inserts allowed within a single SQL statement
- 4096 partitions in a partitioned table space
- Greater resource control with stored procedures and user-defined functions
- Reduced overhead costs for data sharing workloads
- Reduced lock propagation in the coupling facility
- Improved control for accounting aggregation
- Improved package-level accounting
- Greater availability and flexibility with online schema evolution
- More flexibility and faster recovery with system-level point-in-time recovery
- Enhanced LPL recovery processing
- Increased maximum number of active and archive log data sets
-
|
|
|
|
Neuerungen der DB2 UDB Version 7 für OS/390: FCS Early Support Programm Juni 2000, GA später
Zusammengefasst:
- (natürlich!) verbesserte Performance, Verfügbarkeit, Skalierbarkeit für e-Business und Data Warehouse Anwendungen
- Scrollable Cursor
- UNION und UNION ALL in Views
- Veränderungen der 'ZPARMS', ohne DB2 stoppen zu müssen
- UNLOAD Utility
- Mehr als 15 Tables in einem Join mit Star-Join-Technique
- Schnellerer REORG ONLINE
- RESTART light für schnelleres Data Sharing Recovery
- Neue IBM-Upgrade-Strategie: Upgrade von Version 5 und von Version 6 möglich!
- UNICODE Support
- Zusatz-Feature
- DB2 XML Extenders for OS/390 (kostenfrei)
- DB2 Warehouse Manager (Restricted-Use Lizenz von DB2 UDB 71. EE, OLAP Starter Kit, DW Center, Information Catalog, OS/390 Agents and Transformers), QMF for OS/390, QMF HPO und QMF for Windows)
- DB2 Tools Package (Try & Buy, dann kostenpflichtig):
- DB2 Administration Tool
- DB2 Bind Manager
- DBRM Checker
- DB2 Buffer Pool Tool (siehe auch Tool auf dieser Site)
- DB2 Data Propagator for OS/390 (siehe auch Tool auf dieser Site)
- DB2 Forms
- DB2 Performance Monitor
- SQL Performance Analyzer
- DB2 Recovery Manager
- DB2 Management Tools Package (kostenfrei):
- DB2 Control Center
- DB2 Stored Procedures Builder
- DB2 Installer
- DB2 Visual Explain
- DB2 Estimator
- Net.Data (kostenfrei)
- REXX Language Support (kostenfrei, seit V5.2 Service Pack)
|
|
|
|
Neuerungen der DB2 UDB Version 6 für OS/390: ca. Juni 1999
Universally extensible:
- Very large objects
- User-defined functions
- User-defined distinct data types
- Triggers for active data
- More Built-In Functions
Universally accessible through network computing:
- SQLJ (Java embedded SQL)
- DDF connection pooling (Type 2 Inactive Thread)
- DRDA three-part names
- Stored procedure enhancements
- Net.Data Version 2 with enhanced performance
- QMF, QMF HPO, and QMF for Windows (opt.)
- DB2 DataPropagator Version 6 (opt.)
Universally scalable and reliable:
- Support for 16 TB tables (single tablespace)
- Faster, more usable, more parallel utilities (COPY, LOAD, REORG, REBUILD INDEX)
- Data sharing enhancements
- Easier to alter partitions
- Virtual storage constraint relief
- Faster restart and recovery
- Query enhancements, prediction/governing, Query performance enhancements
- 8 and 16 KB page sizes
Universally manageable:
- Workstation tools for Windows NT and OS/2:
- DB2 Installer
- Visual Explain
- Tuning and Analysis
- DB2 Estimator
- DB2 PM V6 (opt.)
- DB2 Admin Tool (opt.)
- DB2 Buffer Pool Tool (opt.)
|
|
Neuerungen der DB2/MVS Version 5: 1997
Client/Server und Open Systems Erweiterungen:
- Native TCP/IP Support
- ATM Support (SNA oder TCP/IP)
- Verbesserung bei Stored Procedures durch temporäre Ergebnistabellen
- Verbesserung der Umgebung von Stored Procedures
- Bessere Performance für DRDA Anwendungen: Besserer Block Fetch, SELECT mit OPTIMIZE FOR n ROWS, ASCII Tables, schnelleres Dynamic SQL, effizientere VTAM SEND/RECEIVE Operationen
- Verbesserte Security: DCE Security Tokens, RACF Passticket, DRDA User Password Change Prompt
- Call Level Interface
Performance, Kapazität und Verfügbarkeit:
- Query Performance: Sysplex Query Parallelism
- Data Sharing Erweiterungen
- Cache für Dynamic SQL
- Reoptimierung des Zugriffspfads zur Laufzeit
- SQL Sprachumfang: CASE, Index-Use trotz komplexer Ausdrücke
- Geschwindigkeitszuwachs Batch und Online: Authorization Caching, `Pieces´, User-defined `Rows per Page´, Log Preformatting
- Large Partitioned Tablespaces: Grenze 1 TByte statt bisher 64 GBytes
- Online Reorg Utility
- Diverse Utility Erweiterungen:
- LOAD und REORG mit Inline COPY
- Höhere Geschwindigkeit von LOAD, REORG, RUNSTATS durch Sampling, RECOVER INDEX
- Dynamisches COPY (kein, Incremental, Full)
User Productivity Erweiterungen:
- DB2 Installer und DB2 Visual Explain von Workstations aus
- Aufnahme von C++ in Installation Panels und DB2I Interactive Panels
- RRSAF Attachment Facility mit 2-Phase-Commit-Fähigkeit, Thread Reuse
- Neue SQL Funktionen:
- WITH CHECK OPTION CASCADED|LOCAL
- Foreign Key Reference auf Unique oder Primary Key
- Delete Rule NO ACTION
- REFERENCES mit Spaltenliste
- Multi-Row UPDATE von Primary Keys
- CASE Ausdruck
- Temporäre Tables
- RENAME TABLE
- neue eingebaute Funktionen
- EXPLAIN Erweiterungen
- max. Anzahl von Rows nun 255 ohne Alteration-Aufwand
- DB2 Meldung bei ungenügender COMMIT-Frequenz von Anwendungen
- SYSOPR-Autorisierung für START DATABASE Command
|
|
Neuerungen der DB/MVS Version 4: 1995
- Database Administration Features:
- DB2 Catalog Reorg, User-defined Indexes für den Catalog
- COPY, RECOVER und Reorg Verbesserungen
- Data Sharing
- TYPE 2 INDEX, UNIQUE WHERE NOT NULL Indexes, Row Level Locking
- Client/Server Feature:
- Stored Procedures
- bis zu 25.000 Distributed Connections
- Performance Feature:
- Partition Scanning
- Query CP Parellelism
- Uncommited Read
- keine Locks auf Type 2 Indexes
- Programming Features:
- Outer Join
- In-Line Views
- COALESCE Funktion
- AS um Spalten umzubenennen
- DB2 Catalog
- 3 neue Tables
- 16 veränderte Tables, Communications Database (CDB) wird in die DB2 Catalog Database verlegt
|
|
Neuerungen der DB/MVS Version 3: 1994
- Erweiterung der Bufferpools (50 x 4K und 10 x 32K)
- Unterstützung von Hiperpools
- Parellel I/O Processing für Query-Anforderung auf Partitioned Tablespaces
- Partition-Unabhängigkeit durch Sperr-Niveau Partition
- Multi-Site-Update-Fähigkeit bei verteilten Datenbanken
|
|
Neuerungen der DB/MVS Versionen 1.1 bis 2.3:
- Version 2.3: 1992
- Packages und Collections
- Remote Unit of Work Konzept (Application Directed Access)
- Performance Verbesserungen: verzögerter CLOSE, Index Lookaside
- erweiterte Limits
- Version 2.2: 1990
- Distributed Databases (Distributed Unit of Work, System Directed Access)
- Performance Verbesserungen: z.B. Multiple Index Access
- Version 2.1: 1988
- Referential Integrity
- Untersützung der RACF Autorisierungsgruppen
- Audit Trace
- Resource Limit Facility
- Performance Verbesserungen
- Version 1.3: 1987
- SQL Spracherweiterungen: DATE, TIME, TIMESTAMP, Scalar Functions
- Performance Verbesserungen (wer hätte es gedacht)
- Version 1.2: 1985
- Performance-Release mit erheblichen Verbesserungen
- Restrukturierung des DB2 Catalogs
- Version 1.1 1983
|
|
|
|
|
 |
|
|
© Gernot Ruban
|
|
