DB2 10.5 for SAP

Yvonne Göbel
Technical Sales DB2/SAP
IBM Deutschland
[email protected]
Erfahrungen aus der Praxis
– Upgrade auf DB2 10.5
© 2014 IBM Corporation
DB2 10.5 für Linux, Unix und Windows (LUW) im SAP Umfeld
DB2 10.5 is supported for system releases with SAP NetWeaver 7.0 and higher
DB2 10.5: SAP-Certified Levels 101809 - DB6: Supported Versions and Fix Pack Levels
– DB2 Advanced Enterprise Server Edition (AESE) version 10.5 for Linux, UNIX, and
Windows
– DB2 Enterprise Server Edition (ESE) version 10.5 for Linux, UNIX, and Windows.
Important SAP Notes:
Note 1851853: Using DB2 10.5 with SAP applications
Note 1851832: DB2 10.5 standard parameter settings
Note 1837312: Upgrade to DB2 10.5
Note 1871004: Installing DB2 10.5 Fix Packs (Windows)
Note 1871003: Installing DB2 10.5 Fix Packs (Linux and UNIX)
© 2014 IBM Corporation
10.5 Fixpacks
10.5 GA (SAP) 09.08.2013
10.5 FP1 (FP1SAP only for Linux PPC)
10.5 FP2
– No certification from SAP. FP2 contains only client-side adaptions relevant for
connections against an IBM DB2 for z/OS server. It does not contain changes
relevant for customers using an IBM DB2 for LUW Server
10.5 FP3 / FP3SAP (25.06.2014)
– to use BLU acceleration, you must use FP3aSAP.
© 2014 IBM Corporation
Voraussetzungen für DB2 10.5
DB2 10.5 for SAP
Editions supported
– DB2 Advanced Enterprise Server Edition (AESE) version 10.5 for Linux, UNIX, and
Windows
– DB2 Enterprise Server Edition (ESE) version 10.5 for Linux, UNIX, and Windows.
To monitor a DB2 10.5 database using the DBA Cockpit, you must implement
SAP Note 1835822 on top of some minimum SAP Basis release levels (find the list in
SAP Note 1851853)
SL Toolset 1.0 SP08 or higher für DB2 10.5 (including Installation und Upgrade)
DB2 10.5 BLU (nur in DB2 AESE enthalten)
AIX/ Linux on the X86_64 platform
Unicode database
DB2 automatic storage tablespaces, reclaimable tablespaces
=> 1819734 - DB6: Use of BLU Acceleration (spec. Support Packages)
© 2014 IBM Corporation
Planning Your Upgrade to DB2 10.5 LUW
DB2 10.5 LUW Upgrade from pre-DB2 Version 10.5 copy:
– DB2 10.1-> DB2 10.5
– DB2 9.8 -> DB2 10.5
– DB2 9.7 -> DB2 10.5
If DB2 servers are running on release prior DB2 9.7:
– Upgrade to DB2 9.7 or 10.1 latest fixpack
– Then upgrade to DB2 10.5
C27-5513-00 Upgrading to DB2 V10.5 Guide
more details
Database Upgrade Guide Upgrading to Version 10.5 of IBM DB2 for Linux, UNIX, and Windows
http://service.sap.com/instguides --> Database Upgrades --> DB2 UDB
=> Always upgrade Server before upgrading Client!
© 2014 IBM Corporation
Upgrade nach DB2 10.5 – einzelne Steps
Preparation
Install DB2 software
– Create DB2 V10.5 Directory
– Prepare Response File (opt)
– Install DB2 Software
– Run Backup
Save DB2 Configs
• dbm cfg
• db cfg
• db2set
Stop SAP
© 2014 IBM Corporation
Upgrade nach DB2 10.5 – einzelne Steps
Upgrade Process
DB2 Software Upgrade
– DB2 CLI Driver Update
• 1365982 - DB6: Aktuelles db6_update_db/db6_update_client Script (V40)
– Disable Client Requests
• db2set -null DB2COMM
– Instance Upgrade
• db2iupgrade
– DB Upgrade
• db2 upgrade database <sid>
• db2set DB2COMM=TCPIP (enable client access)
© 2014 IBM Corporation
Upgrade nach DB2 10.5 – einzelne Steps
Post activities & Backup
Install new license
db2 update db script
Anpassen DB2 Parameter
Note 1851832: DB2 10.5 standard parameter settingsStart SAP
Run backup
Deinstallation of old DB2 SW
– db2_deinstall -a
© 2014 IBM Corporation
Upgrade nach DB2 10.5 – einzelne Steps
Enable new DB2 Feature
Disable REORGCHK
– DB13 --> disable old scheduling for REORGCHK - no longer needed for 10.5
1851853 - DB6: Verwendung von DB2 10.5 mit SAP-Anwendungen
Insert Time Clustering Tables
– DB6CONV offers (based on SAP Release) a list of ITC candidates
Adaptive Compression
– db2 ALTER table <tab_name> COMPRESS YES adaptive
– Reorg (db6conv)
Index Compression (relevant for Upgrades from DB2 V9.5 only)
– db2 SELECT COUNT (DISTINCT indname)FROM TABLE
(SYSPROC.ADMIN_GET_INDEX_INFO('I', '<schema>', ''))
AS T WHERE index_compressed = 'Y‘
– db2 ALTER INDEX <index_name> COMPRESS YES
Reclaimable Storage (relevant for Upgrades from DB2 V9.5 only)
– db2 “SELECT tbsp_name FROM TABLE (MON_GET_TABLESPACE('',-2)) AS T WHERE
reclaimable_space_enabled = 1“
Automatic StorageColumn
– db2 ALTER TABLESPACE <tablespace name> MANAGED BY AUTOMATIC STORAGE
© 2014 IBM Corporation
Automatic Storage
Ab DB2 10.1 FP1 werden DMS Tablespaces nicht mehr unterstützt
– Verwendung von automatic storage
Storage-Pfade mit gleicher Größe verwenden
REBALANCE nur ausführen, wenn nötig
– Mitlerweile kann man rebalance aber auch wieder stoppen
Temporäre Tablespaces
– SMS
– Neue Pfade werden erst nach aktivieren der DB genutzt
⇒Tempspace auf eigene Storagegroup legen
Auslesen aktueller Status
– db2 get snapshot for tablespaces on n73 |grep -i "using automatic"
Using automatic storage
= Yes
Konvertierung DMS Tablespaces mit AUTOMATIC STORAGE
– db2 ALTER TABLESPACE <tablespace name> MANAGED BY AUTOMATIC STORAGE
=> 1895425 - DB6: Using Automatic Storage
© 2014 IBM Corporation
Fazit einiger Kundenprojekte Upgrade DB2 9.7 -> DB2 10.5 und
DB2 10.5 BLU
Verbesserung im Bereich Komprimierung mit adaptive Compression und bei columnar
Bereich mit BLU
Performanceverbesserung mit DB2 9.7 auf DB2 10.5
DB2 10.5 BLU bringt Vorteile im Bereich Ladezeiten und bei Queries
DB2 10.5 BLU skaliert
Diskussion über den Upgradepfad:
– Upgrade
oder
– Migration mittels heterogener Systemcopy
weniger Einzelsteps
© 2014 IBM Corporation
Thank You
© 2014 IBM Corporation