The number of applications using dynamic SQL is increasing. The large enterprise systems such as SAP are based on this flexible way of accessing databases. However, the flexibility is coupled with additional challenges when it comes to resources utilization, performance monitoring and tuning. Caching of the dynamic SQL statements, impact on virtual storage, reoptimization and EXPLAIN considerations need to be understood in order to take advantage of the feature and ensure optimal execution for the applications that use dynamic SQL. This presentation will help you gain that understanding.
Problems concerning daily database maintenance are down to big amount of necessary out-of-working-hours DBA time. Solution to this problem is automation of maintenance jobs. After automating execution of imagecopies and runstats jobs, DBA in Zagrebačka banka implemented complete automation of index and tablespace reorganization. Through numerous planning and categorization steps we managed to elaborate in detail schedule and prerequisites for a database/table/application reorganization. We used standard DB2 utility jobs and standard z/OS capabilities to devise the way the jobs are executed, execution time control, as well as error and abend control. All solutions with examples, as well as imperfections and shortcomings and potential future enhancements are topic of this presentation.
Full Presentation Abstract: The DB2 V8 Optimizer has many enhancements under the hood. As DBAs it is our nature to care about performance implications during migration. At several customers, we implemented procedures that kept us in control of access paths and insured good SQL performance before V8 migration. In this presentation, I will show the methodology we used to implement a V8 early precheck of all dynamic and static SQL while still on a production V7 system. Not only were we able to predict and evaluate the resulting V8 access paths, we also determined that patterns of expected access path changes will occur using the V8 Optimizer. By making such Optimizer decisions transparent, we took our performance-securing measures one step further. By using the results of the early precheck in combination with the new function of the V8 RUNSTATS utility regarding the column distribution statistics and skewed columns, we were able to influence Optimizer decisions under V8.
Presentation Outline: 1.Comparing access path changes between two DB2 Versions: the procedure Simulating a V8 comparison environment Evaluating V7 and V8 differences 2.A look at specific types of access path changes that are typical under V8 Static SQL Dynamic SQL 3.Risk control management Pinpointing which access path changes are relevant Securing access paths under V8 4.Exploiting V8 Column Distribution Stats Nourishing the V8 Optimizer with extended statistics And, how early recognition of expected access path changes can help 5.Summary Presentation Bullet Points: Stage a V8 environment in which to do an SQL performance early precheck Identify the Optimizer differences between V7 and V8 Show expected access path changes when migrating Show access path change patterns for static and dynamic SQL Opportunities to secure application performance using extended features of the V8 RUNSTATS
DB2 V9 is the new feature-packed release of the IBM's industry-leading mainframe data server. It introduces numerous enhancements in database administration, particularly backup/recovery, reorganization and space management, as well as various performance and programming improvements. Rich new SQL capabilities, increased security and regulatory compliance, database on demand capabilities, performance-boosting innovations for varying length data, improved logging and inserts are only some of the features brought by DB2 V9. This presentation will give you an overview of DB2 V9 and demonstrate benefits you can expect from migrating to the new release.
European SQLAdria Seminar – Vodice 2024
SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.
8 reasons to come Speakers Events Contact
VODICE - 10th - 13th June 2024