Objectives: Learn how to use the new EXPLAIN tables to help with query tuning efforts.
Outline: Discuss IBM Visual Explain and Optimization Service Center Discuss the tables that support them for information Discuss how to use these tables without the tools Discuss the DSN_STATEMENT_CACHE_TABLE for dynamic SQL tuning
Full Abstract: DB2 z/OS V8 and 9 have introduced us to many new EXPLAIN tables. This session will introduce users some of the new EXPLAIN tables to be used for advanced query analysis, and demonstrate how SQL queries can be used to gather and analyze the this information. The session will also include information about using the DSN_STATEMENT_CACHE_TABLE to perform analysis on the dynamic SQL cache.
Objectives: To give the audience an overview of the implementation of triggers in DB2 for z/OS. A number of examples will be given.
Outline: What is a trigger? Implementation Examples Some warnings
Full Abstract:
Objectives: To firstly look at the real business reasons behind why we tune and why a little knowledge can be a dangerous thing when it comes to SQL. The bulk of the presentation will concentrate on illustrating how SQL can be ‘tweaked’ to produce better performance at a cheaper cost.
Outline: Why do we tune? What are the benefits? Tuning SQL Tips, techniques and pointers
Full Abstract: Get more from your SQL, this section will cover how to tune your statements to provide the best return with the least resources. It’s often easy to get SQL to return the data you are looking for...but could you be doing it better?
Objectives: Get a detailed understanding on how to get most out of the dynamic statements cache.
Outline: How dynamic statements cache works Virtual storage impact Common access path challenges Monitoring
Full Abstract: The use of dynamic SQL continues to grow. Enterprise packaged applications as well as web applications use almost exclusively this flexible way of accessing databases. However, the flexibility is coupled with additional challenges when it comes to resources utilization, performance monitoring and tuning of SQL statements. This presentation focuses on dynamic statements cache – the key factor of a well performing dynamic statements environment. It covers all the relevant aspects of the statements cache: how it works, how to control its CPU and memory utilization, and how to monitor and tune it.
Objectives: To give the audience an understanding of new elements introduced in DB2 for z/OS V8: Scalar fullselect Common table expression Recursive SQL
Outline: The result of a Select is a table Scalar fullselect View Nested table expression Common table expression Recursive SQL
Objectives: To give an overview of the importance of collecting and providing DB2 with good statistics and ensuring filtering takes place as early as possible. The session also looks to introduce some of the new statistics related features available in DB2 9 as well as highlighting the problem of column correlation and providing steps to both detect and fix it.
Outline: The DB2 Catalog A brief History Real Time Statistics Distribution Statistics Including Histogram Statistics Defining, detecting and fixing column correlation A look at the importance of good filtering
Full Abstract: We spin a lot of cycles collecting them, how can we get the best out of them? A look back at how the catalog has grown in recent releases and what DB29 brings us in this area. We will also take a look at column correlation, what it is, how to detect it and how to fix it. Real Time Statistics, filtering and the importance of Distribution Statistics are also covered.
Objectives:
Outline: Introduction – who wants what and why? What have we done about it? What are we doing about it? What is the overhead and what are the benefits? Real life example – or how do I get that certificate?
Full Abstract: For years DBA at Zagrebacka banka tried to follow different best practices we have learned about in database management, security, data privacy, availability and so on being unaware of different regulations. However, looking back at last few years and all the things DBA at Zagrebacka banka were involved with, it seems that number of regulations in effect are already met. However there is also a number of those we're still working on.Come join me in this presentation and I'll show you the steps undertaken at Zagrebacka banka to be in compliance.
Objectives: Improve efficiency and productivity of DB2 administrators and programmers by exploiting the full power of DB2 9
Outline: Rationale behind implementing selected DB2 9 features Usage recommendations for optimal exploitation of new functions Less known techniques to address specific programming tasks More efficient programming practices
Full Abstract: DB2 9 brings a wealth of new features that improve productivity of administrators and programmers. This presentation shows how some of the common database administration and programming tasks can be done more efficiently in DB2 9. It also presents numerous hints and tips about less obvious usage capabilities of selected DB2 9 features that efficiently solve some long standing programming challenges such as application controlled locking, destructive reads, efficient mass deletes etc
Objectives: This session will first look at how CA Recovery Analyzer can be used to define a disaster backup and recovery strategy and the jobs that will be generated to enable an off-site recovery. Secondly, we will look at screenshots of an actual disaster recovery process that was performed at European IDUG in 2008. This performed a disaster recovery of a destroyed DB2 subsystem in under 30 minutes – and all without any of the complex disaster recovery knowledge that would normally be required
Outline: How to define a Disaster Recovery strategy to Recovery Analyzer Non-DB2 additions to the backup The jobs created to run at your live site A DISASTER HAS HAPPENED The jobs to be run to recover your DB2 subsystem again
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