DBA Cockpit Update 2016_V3 (2)
Werbung
Advanced Insight in your SAP Systems with DBA Cockpit Enhancements Petra Bührer (IBM), Julia Konstantinova (SAP), Jochen Röhrig (IBM), Isgandar Valizada (IBM) SAP on System z Development April, 2016 Public Agenda DB2 12 Enablement Requirements and Readiness Check Installation Parameters with DB12 Statement Cache Enhancements Lift Partition Limits and new TS Type PBR RPN Explain Table Changes DB13 Enhancements Recent Development DBA Cockpit Display Role Explain Enhancements Accelerator Monitoring CDS & ZDO Monitoring Support SAPCL & Alert Router News Development Outlook © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 2 DB2 12 Enablement Requirements for DBA Cockpit with DB2 12 Minimum Requirements for Toleration of DB2 12: Recommended Requirements to be met in order to provide Full Support for DB2 12: SAP Support Package Requirements have been aligned to the DB2 11 Requirements – if your system is ready for DB2 11, it works with DB2 12 as well See SAP Note 2302525 - DB2-z/OS:v12:CCMS: DBA Cockpit with DB2 12 SAPCL 721 Patch Level 11 or higher © 2016 SAP SE or an SAP affiliate company. All rights reserved. Provides an overview about the changed areas Lists the ABAP support package levels for SAP and SAPCL Customer 4 DB2 12 Readiness Check Run Report DB2_V12_CHECK in order to check if prerequesites are met. will also be available as correction instruction © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 5 Installation Parameters with DB2 12 Installation Parameters has been enabled for DB2 12 New SAP Note 2239553 has been made available © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 6 Statement Cache Enhancements New Wait time counters for L-locks and P-locks are helpful for monitoring the workload on DB2 Data Sharing Avg wait time for pipe wait (INSERTS) concerns the monitoring of new SQL INSERT algorithm in DB2 12 Avg wait time for parallel queries to sync parent/child tasks provides better monitoring for query parallelism. This is helpful for CDS. © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 7 New TS Type PBR RPN & Lift Partition Limits (1) New TS Type PBR RPN now supported In that context – DSSIZE on partition level © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 8 New TS Type PBR RPN & Lift Partition Limits (2) Dependent on a new TS type adjusted limit calculations within DB02 KPIs TS Limits Partition Limits Index Limits In correlation to new TS type support of extended RID © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 9 EXPLAIN Table Changes So far: Explain Table Maintenance performed directly by DBA Cockpit Table layout etc. delivered via SAP SPs Check and adaption done automatically Now: Explain Table maintenance performed via Stored Procedure ADMIN_EXPLAIN_MAINT DBA Cockpit now simply calls ADMIN_EXPLAIN_MAINT Effective for DB2 11 as well Benefits: Explain table layout always current (independent of SAP maintenance level) Robust against DB2 intra-release changes © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 10 Planning Calendar (DB 13) Enabled DB12 features within the Planning Calendar (DB 13): New keyword for RUNSTATS: Invalidatecache YES/ NO 2261867 - DB2-z/OS:CCMS: DB2 12 RUNSTATS Invalidatecache - changed default behavior New mapping table format for REORG DB2 12 extended the SOURCE_RID field from 5 to 7 chars and the TARGET_XRID field from 9 to 11 chars 2251508 - DB2-z/OS:CCMS: DB2 12 REORG Mapping Table Changes Automated RUNSTATS PROFILE via SYSSTATFEEDBACK New feature can be activated via new ZPRAM STATFDBK_PROFILE. This one is set toYES per default. © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 11 Recent Development Monitoring New Display Only Role The new Display Role provides a possibility To delimit the usage of DBA Cockpit up to monitoring functions To use the DBA Cockpit without performing any changes in a system or database © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 13 BIND QUERY integrated into DBA Cockpit Explain Several possibilities to influence the access path for matching SQL statements DB2 10 Specifying statement-level optimization parameters Specifying statement level access paths DB2 11 Overriding the selectivity of predicates Specifying statement-level optimization parameters Specifying statement level access paths SYSPROC.ADMIN_COMMAND_DSN to submit the BIND QUERY command © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 14 Use of CTE Hints in Conjunction with BIND QUERY Possibility to add a CTE Hint in order to influence the access path and freeze it, as soon as you achieve the desired access path © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 15 Maintained Access Paths Possibility to display all the frozen Access Paths with the option to release them again (FREE Query) © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 16 IDAA Integrated in Explain © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 17 Catalog Browser to Display Accelerator Tables © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 18 Accelerator System Statistics History (Q8ST) © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 19 Accelerator System Statistics (Current) Snapshot © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 20 Data Distribution within IDAA in order to detect Skew Exploit information generated by the IDAA Studio (with PTF6) © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 21 Planned Development Items & Summary Planned Items Integrate into the Dynamic Statement Cache (316_ACCEL) Integrate into the Thread Activity (Q8AC) New IDAA Explain Summary The SAP DBA Cockpit will provide IDAA Monitoring integrated into several existing DBA Cockpit monitors, and as well be enhanced by some special IDAA monitors soon. Thus our SAP support and our clients will be able to start their problem investigation from within the DBA Cockpit, as usual, with the possibility to monitor their DB2s and IDAAs as a unit. © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 22 Core Data Services (CDS) & Zero Downtime Optimization (ZDO) Completely new requirements due to increased complexity So far, views did not play an important role in the SAP context For CDS views are essential - no monitoring available crucial to have a possibility to monitor CDS statements, which means the views / functions, especially with regards to their dependencies So far, static SQL was not common in the SAP context no monitoring available With ZDO it changed (~thousands of procedures & triggers for ZDO) - two detail views to provide information about them, their create statements, and their dependencies… With CDS it changed (new need to monitor the CDS functions) © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 23 Dependency Browser Possibility to browse the dependencies of Views Table Functions Scalar Functions Tables Procedures Global Variables Triggers Structured display of the dependencies of all the dependent object Possibility to look for dependencies up and downwards Two detail views Get detail information on the selected object Display the create statement of the selected object © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 24 Dependency Browser Possibility to select any of the displayed objects in order to get some detail information! © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 25 Detail Information on the various Objects Information is retrieved from the corresponding catalog tables! © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 26 Create Statements of the various objects Possibility to display the create statements in a consumable format! © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 27 Trigger Monitoring © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 28 SAPCL and Alert Router News SAP Kernel Patch of 07/2015 * Support only DB2 10+11 Patch of 09/2015 ** Support DB2 10+11 Patch of 11/2015 *** Support DB2 10+11 7.00, 7.01, 7.10, .11 EOM 08.2012 EOM 08.2012 EOM 08.2012 7.20 EOM 04.2015 EOM 04.2015 EOM 04.2015 7.21 Patch 9 Patch 10 Patch 11 7.22 Patch 2 Patch 3 Patch 4 7.40 EOM 08.2014 EOM 08.2014 EOM 08.2014 7.41 Patch 6 EOM 09.2015 EOM 09.2015 7.42 Patch 5 Patch 6 Patch 7 7.45 n/a Patch 1 Patch 2 * Changes static embedded SQL to dynamic embedded SQL, to avoid locks on DB2 Catalog of Alert Router + IDAA support. ** Fixes DB02 space collection problem (computed too high values for #tablespace, #tables, #indexes. See SAP Note 2214659.) *** Tolerates DB2 12 © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 29 Development Outlook Current Activities & Development Outlook Current Activities DB2 12 Statement Cache Explain IDAA Monitoring – Accelerator System Statistics – Data Slice Distribution Outlook IDAA Monitoring Thread Activity Virtual Indexes Static SQL Monitoring © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 31 Thank you! Contact information: Petra Bührer, IBM R&D [email protected] [email protected] Julia Konstantinova, SAP SE [email protected] © 2016 SAP SE oder ein SAP-Konzernunternehmen. Alle Rechte vorbehalten. Weitergabe und Vervielfältigung dieser Publikation oder von Teilen daraus sind, zu welchem Zweck und in welcher Form auch immer, ohne die ausdrückliche schriftliche Genehmigung durch SAP SE oder ein SAP-Konzernunternehmen nicht gestattet. SAP und andere in diesem Dokument erwähnte Produkte und Dienstleistungen von SAP sowie die dazugehörigen Logos sind Marken oder eingetragene Marken der SAP SE (oder von einem SAP-Konzernunternehmen) in Deutschland und verschiedenen anderen Ländern weltweit. Weitere Hinweise und Informationen zum Markenrecht finden Sie unter http://global.sap.com/corporate-de/legal/copyright/index.epx. Die von SAP SE oder deren Vertriebsfirmen angebotenen Softwareprodukte können Softwarekomponenten auch anderer Softwarehersteller enthalten. Produkte können länderspezifische Unterschiede aufweisen. Die vorliegenden Unterlagen werden von der SAP SE oder einem SAP-Konzernunternehmen bereitgestellt und dienen ausschließlich zu Informationszwecken. Die SAP SE oder ihre Konzernunternehmen übernehmen keinerlei Haftung oder Gewährleistung für Fehler oder Unvollständigkeiten in dieser Publikation. Die SAP SE oder ein SAP-Konzernunternehmen steht lediglich für Produkte und Dienstleistungen nach der Maßgabe ein, die in der Vereinbarung über die jeweiligen Produkte und Dienstleistungen ausdrücklich geregelt ist. Keine der hierin enthaltenen Informationen ist als zusätzliche Garantie zu interpretieren. Insbesondere sind die SAP SE oder ihre Konzernunternehmen in keiner Weise verpflichtet, in dieser Publikation oder einer zugehörigen Präsentation dargestellte Geschäftsabläufe zu verfolgen oder hierin wiedergegebene Funktionen zu entwickeln oder zu veröffentlichen. Diese Publikation oder eine zugehörige Präsentation, die Strategie und etwaige künftige Entwicklungen, Produkte und/oder Plattformen der SAP SE oder ihrer Konzernunternehmen können von der SAP SE oder ihren Konzernunternehmen jederzeit und ohne Angabe von Gründen unangekündigt geändert werden. Die in dieser Publikation enthaltenen Informationen stellen keine Zusage, kein Versprechen und keine rechtliche Verpflichtung zur Lieferung von Material, Code oder Funktionen dar. Sämtliche vorausschauenden Aussagen unterliegen unterschiedlichen Risiken und Unsicherheiten, durch die die tatsächlichen Ergebnisse von den Erwartungen abweichen können. Die vorausschauenden Aussagen geben die Sicht zu dem Zeitpunkt wieder, zu dem sie getätigt wurden. Dem Leser wird empfohlen, diesen Aussagen kein übertriebenes Vertrauen zu schenken und sich bei Kaufentscheidungen nicht auf sie zu stützen. © 2016 SAP SE or an SAP affiliate company. All rights reserved. Customer 34
