DB2 News

Architektentage – 11. – 12. November 2014
DB2 News
Georg Kistenberger
IBM SWG zIM TS Senior IT-Specialist
[email protected]
© 2014 IBM Corporation
IBM’s statements regarding its plans, directions, and intent are subject to change or
withdrawal without notice at IBM’s sole discretion.
Information regarding potential future products is intended to outline our general
product direction and it should not be relied on in making a purchasing decision.
The information mentioned regarding potential future products is not a commitment,
promise, or legal obligation to deliver any material, code or functionality. Information
about potential future products may not be incorporated into any contract. The
development, release, and timing of any future features or functionality described for
our products remains at our sole discretion.
Performance is based on measurements and projections using standard IBM benchmarks in
a controlled environment. The actual throughput or performance that any user will
experience will vary depending upon many factors, including considerations such as the
amount of multiprogramming in the user’s job stream, the I/O configuration, the storage
configuration, and the workload processed. Therefore, no assurance can be given that an
individual user will achieve results similar to those stated here.
2
© 2014 IBM Corporation
Agenda
DB2 11 for z/OS
– Speed
– Simplicity
– Savings
DB2 11 Sequoia
3
© 2014 IBM Corporation
DB2 11 Speed - CPU savings
Keine Verallgemeinerung!
–
–
–
–
4
Bis zu 10% bei OLTP
Bis zu 15% für update-intensive Verarbeitung
Bis zu 40% für Queries
Weniger oder mehr CPU Einsparung ist
abhängig von kundenspezifischen
Systemumgebungen und Workloads
© 2014 IBM Corporation
Interne DB2 Optimierungen
Optimierung für kritische Codepfade
– Cost Model Anpassungen
• Less impact by CPU speed differences, upgrades, NLEVELS
– Optimizer Externalization of missing stats
Weniger Overhead für Decompression
Verbesserungen in unterschiedlichen DB2 Bereichen
– Log, Data Sharing und Workfile Verarbeitung
– Remote workloads
• Sync/receive
• autocommit commits for CALL stmts
• large result sets with package based continuous block fetch
– DRDACBF package option
– Skalierung von Tabellen mit vielen Partitionen
– Bufferpool Management
Weniger Datenreorganisation
– Automatischer cleanup von pseudo-deleted Indexeinträgen
5
© 2014 IBM Corporation
IBM DB2 Analytics Accelerator V4
OLTP meets OLAP
Zielsetzung: Query-Acceleration & Ad-hoc Query Performance
– Beschleunigung langlaufender Datenbankabfragen
– Ad-hoc Query Performance im Sekundenbereich
V11 setzt IBM DB2 Analytics Accelerator V4 voraus
– Neues Loader Tool
zEnterprise
(z196/z114/EC12)
CLIENT
Data Studio
Foundation
DB2 Analytics
Accelerator
Admin Plug-in
Users/
Applications
6
Netezza
Technology
DB2
Image
copy
Loader
External Files
•Higher Availability during LOAD
DRDA
OSAExpress
Data Warehouse application
SAP BW
DB2 for z/OS enabled for
IBM DB2 Analytics
Accelerator
IBM DB2 Analytics Accelerator
Nov. 2012 - V3: Incremental update, High Performance Storage Server
Nov. 2013 - V4: Static SQL, multiple encoding, multi-row fetch
Incremental update +, HPSS +
Support für V10 + V11
© 2014 IBM Corporation
DB2 V11 Simplicity
Wichtige Erweiterungen bei
– Datenstrukturänderungen
• DROP COLUMN, Alter partition limit keys
7
© 2014 IBM Corporation
Online Änderungen von Tabellenstrukturen
Version
8
Feature
V11
ALTER TABLE DROP COLUMN
V9
ALTER TABLE RENAME COLUMN
V8
ALTER TABLE ALTER COLUMN
V1
ALTER TABLE ADD COLUMN
© 2014 IBM Corporation
DB2 V11 Simplicity
Wichtige Erweiterungen bei
– Datenstrukturänderungen
• DROP COLUMN, Alter partition limit keys
– Online Reorganisation
• SWITCH phase performance
• Automatische Gleichverteilung der Daten in einer partitionierten Tabelle
• Alter limit key, Compression dictionary Verbesserungen für IFI306 readers
– BIND/REBIND, DDL break into persistent threads
– Erreichen der log RBA und LRSN Limits
• V10: 6-byte RBA (Relative Byte Address) hat eine Kapazität von 256 TB Log record
Adressierung
• V11: 10-byte RBA/LRSN löst das „end-of-log“ RBA und LRSN Limit Problem!
– Maximale RBA Adressierung: 1 yottabyte (2**80)
– LRSN Limit: > 30000 Jahre!
– Security
• DB2/RACF authorization control Erweiterungen
9
© 2014 IBM Corporation
Lösungen zur Datenverschlüsselung und Compliance
Trennung der Security und DatenbankAdministration
Data Encryption on the wire!
System
Administrator
Tasks
Security
Administrator
Tasks
– SSL und DRDA AES
InfoSphere Guardium Data Encryption for
DB2 & IMS databases
– Datenverschlüsselung
•
•
Tabellen-Exit
UDF
Access
Monitor
Temporale Daten mit System Time
– Historisierung von Daten
– Veränderungen werden protokolliert
Integrierte Audit-Funktion
– Definition von „Audit Policies“ über neue Katalogtabelle
– Guardium S-TAP für DB2 z/OS
10
© 2014 IBM Corporation
DB2 V11 Simplicity
Applikation und SQL Neuerungen
– Temporale Daten
• Views, special register
– Transparente Datenarchivierung auf Tabellenebene
– Globale Variablen, Alias support for SEQUENCES
– Autonomous Transaktionen und Array Datatype Support für SQLPL
– Grouping sets, Cube & Rollup
– XML XQuery support, bessere Performance, mehr Beispiele
– Einstieg in Unicode Column-level support
11
© 2014 IBM Corporation
DB2 Connect – Best Practice
Direct connection to DB2 for z/OS
– No DB2 Connect Server to maintain
Lightweight client packages
– IBM Data Server Driver Package (ds driver - recommended)
– Staying current with driver levels much easier to attain
Latest code levels required for new server feature exploitation
– V10.5 FP2 required for DB2 for z/OS V11 new features
• CALL with ARRAY
• Global session variables
• Enhanced client info properties
Latest code levels required for API specific features
– e.g .NET 4.0 or Visual Studio 2010 require DB2 V9.7 FP4
– Visual Studio 2012 beta was only on V9.7 FP6, GA in V10.1 FP2
Non-Java Client configuration with db2dsdriver.cfg
1212
© 2014 IBM Corporation
APPLCOMPAT: Migration DB2 10 nach DB2 11
DB2 10 New Function
Mode
DB2 11 Enabling New
Function Mode
DB2 11 Conversion Mode
(NFM) With SPE
CATMAINT
UPDATE
(DSNTIJTC)
DB2 11 New Function Mode
(NFM)
CATENFM
COMPLETE
(DSNTIJNF)
CATENFM START
(DSNTIJEN)
DB2 10
Catalog
DB2 11
Catalog
1 – 2 months
2 hours
DB2 10
Libraries
1 week
Data Sharing
Coexistence
DB2 11
Libraries
Bind with APPLCOMPAT(V10R1) option only
Bind with APPLCOMPAT(V10R1)
or APPLCOMPAT(V11R1)
13
© 2014 IBM Corporation
DB2 V11 Savings
Mehr Funktionalität bei unveränderten Lizenzkosten
– = V9 = V10 = V11!
CPU Reduzierung
Mehr zIIP offload
– Cleanup of pseudo-deleted Index entries in DBM1
– Log read/write in MSTR
Mehr Automation
Produktivitätssteigerung
14
© 2014 IBM Corporation
DB2 V11 Planning
15
© 2014 IBM Corporation