Objectives: To learn ALL of the new features and functions of DB2 9 for z/OS. Although it has been GA for almost 2 years, DB2 9 IS still new for most people. Not only that, but IBM are continuing to add new items to DB2 9 during maintenance, so we will also take time to look at what has been added recently
Outline: How to migrate to DB2 9 What has been removed and what might be removed in the future What is new in Performance, SQL, Availability, Security What has been added since GA
Full Abstract: This session covers everything (and I mean EVERYTHING) that is new in DB2 9 for z/OS. We'll cover Universal Table Spaces, Clones, Utility enhancements, new SQL and XML support. As well, there is a growing section of what's BEEN ADDED to DB2 9 since GA. So, you can come to this session safe in the knowledge that afterwards there will be no secrets in DB2 9.
Objectives: Gain more insight in the way DB2 works and obtain skills to analyze performance data in order to make the right decision for system tuning.
Outline: How to do tuning and monitoring CPU resource TCB / SRB / ZIIP Concept Where various CPU type are used Thread CPU breakdown Types of parallelism and when (not) used Stored Procedures Memory resources Virtual v.s. Physical Signs of Stress DB2 Buffer Pools DB2 EDM Pool DB2 Sort Pool DB2 RID Pool Other DB2 Memory areas Impact of DB2 V8 on memory tuning
I/O Efficiency Signs of stress Logging and how to improve Does dataset placement & extents matter using VSAM Striping Impact of FICON and PAV Compression
Full Abstract: The more you understand how DB2 is internally structured, the easier it will be to do system tuning. This presentation will teach you the different components that make up DB2 for z/OS. With every part we examine, we also will look how we can tune this component to achieve maximum performance. This seminar is unique since it focuses completely on the system side of DB2. Once you know how DB2 services your requests you also will find it easier to understand application tuning and the recent DB2 enhancements. The target audience is people who have multiple years of experience with DB2 and who want to learn more about the internal structure of DB2. During previous presentation at the DB2 Symposium this seminar was rated with 8.2 on average!
Objectives:
Outline:
Full Abstract: Achieving maximum performance from DB2 requires a different approach and stricter methodologies than simply getting a DB2 application to perform well. In today's web and e-business environment the rules have changed and we must find every tuning knob in order to get another transaction through the system. This seminar focuses on specific issues of system design, physical object design, application design and tuning methods used to achieve high performance. The performance techniques of the some of the new object-relational SQL features are also covered. Focus is on the complete set of design points of DB2, and how they will affect performance of your applications. Discover why many old guidelines no longer apply, how old standards can actually hurt us and learn the approaches to systems management and tuning for the DB2 environment. The rules have changed and certainly in DB2 9 there are many more features to take advantage of and to be careful with.
Objectives: To learn how CA Detector helps you not only find your high cpu consumers but also helps you find those that you will get the most benefit from tuning. We will look at the work flow process used to track down the best tuning candidates. We will also look at some ways you can use the Detector information to track your tuning successes over time and to help your company get the best use out of your valuable cpu resources.
Outline: What is CA Detector? And what it isn’t Why is proactive better? Examples of Detector screens – finding those cpu hogs Advanced categorisation of activity Externalising the data Summary
Full Abstract: One of the best tuning measures is to look at high cpu consumers and tune them so that they consume less. The snag is, how DO you find them? In fact, is it good enough to just find the highest cpu consuming statement or program – surely you also need to consider how often the application or statement is being used. Tuning a statement that is only executed once per hour, might give you a good feeling, but you would have been better looking for highly active things to tune. This presentation looks at how CA Detector helps you not only find your high cpu consumers but also helps you find those that you will get the most benefit from tuning
Objectives: Learn about some new features in DB2 9 that will help us achieve high performance in our applications and database designs
Outline: Application Features Database Features
Full Abstract: This presentation will look at the features of DB2 9 that we can use achieve maximum performance. We will look at new SQL features, database features as well as a few new enhancements our overall subsystem performance.
Objectives: Obtain some knowledge about DB2 security using RACF and the new V9 role and trusted context
Outline: Using RACF for DB2 Security New options in V9 security Roles Trusted context
Full Abstract: During this presentation Klaas will review the “new” options of DB2 in the security area. Many companies have started to use RACF to replace DB2’s native security. What are the benefits and what downsides of such an approach? DB2 version 9 makes a leap forward in security options. New facilities like trusted context and roles are introduced. These are perfect option to make DB2 more secure but also require some thinking as they require a new way of working with DB2 security. To end the session we will look a bit forward in time to see what DB2 (possibly) has for us in future releases with regards to security
Objectives: Understand the basic rules of writing performing SQL
Outline: To index or not to index Access paths explained Predicate solving when and how Suboptimal coding and their improvements Other easy to use CPU saving techniques Mips and money
Full Abstract: This presentation is a PRACTICAL, HANDS ON way to SQL performance tuning and SQL improvement. When logically correct SQL will always return and answer, the statement might be expensive or cheap but is quite often suboptimal. This presentation will explain the ground rules to writing performing SQL and has numerous EASY-TO-FIX, REAL LIFE improvements. If you are a developer or a beginning DBA, you’ll gain an understanding to better SQL writing and tuning. If you are a more experienced DBA you’ll get a thorough refresh, learn something new and walk a way with an idea of “how to explain SQL to your developers”.
Objectives: Learn how to use efficiently the new programming facilities like wide cursor, array insert, merge final table.
Outline: Wide cursor Group insert Atomic vs non-atomic New error processing Merge Final table usage
Full Abstract: Have you started to use wide cursors under DB2 version 8? It is pretty easy and the CPU savings can be shocking! It is not very difficult to use them but there are a few things you should know about them before using them. Slightly more difficult are array inserts but also in this area you can save CPU again. DB2 version 9 bring another great feature: the MERGE statement. Complex programs can be condensed into a single, fast statement. Finally Klaas will review the so called FINAL TABLE which was introduced in version 8. Its use has been extended in version 9 and can be a great help in making your programs smaller and less complex.
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 - 12th - 15th June 2023