Klaas Brant

DB2 can compress data. How does it work? Is it needed? To compress or not to compression, that’s the question! Once you know how it works and when it is good for you then you can also identify the cases when not to use it. Next to compression there is encryption. When to use encryption? Should it / Can it be combined with compressions. This sessions discusses the details.

Under normal conditions DB2 is not too difficult to handle. But there might be a day that DB2 decides that it is time for trouble. Where to find information. Where to start and what tools do we have available. This session will introduce you to: DB2DIAG, DB2PD, DB2DART and INSPECT

This one day seminar is a number of best practices in many areas. It is a great resource for experienced DBA’s how question themselves if they are doing the right thing.
Topics:
- Configuring your server
- Fix packs and upgrades
- Table space and bufferpool strategy
- Security and audit
- Collecting performance data / tuning
- Runstats and Reorg
- Your recovery strategy

Viper (9.1 and 9.5) and Cobra (9.7) were the codenames IBM used for the Version 9 releases of DB2 LUW. These releases are packed with many great new features which speed up your applications, save time / money or simplify things. But as always new features come with new questions. How to use? What are the new guidelines? Are there any new pitfalls? What is wise? Klaas Brant used all of these releases since their beta program and has compiled a brand new training for you. He will explain the new features of Version 9 (all releases). The training contains new guidelines for using these new features. If you are serious about DB2 LUW then this training is a must.

Topics:
Automatic Storage
Table Partitioning
Database rebuild / restore
Enhanced Monitoring
Self-Tuning Memory Manager (STMM)
Work Load Manager (WLM)
PureXML
Oracle compatibility
Large Table support
Runstats & Statistics
Deep Compression
Security Enhancements
Performance improvements
Problem determination
HADR enhancements
Install / Migrate / Fixpacks

Have you seen how IBM made many security changes in DB2 9? With all the new possibilities in DB2 you can change your procedures to be compliant with the latest security standards. Klaas will review IBM’s blueprint on security and what and where it has been implemented in DB2 LUW like LBAC, SSL, Audit, Trusted Context, Roles and Security Administration. After this session you will be up-to-date with all the security changes and have an idea how they will impact your procedures when you implement them.

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:
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.

Objectives:
Understand the new Universal Table Space and underatnd IBM intentions for the future

Outline:
What we have now and what’s wrong with it
The new type of table space: universal
Partition by Growth
Partition by Range
Interaction with utilities

Full Abstract:
DB2 9 comes with a brand new table space type called Universal table space. Why do we need this tablespace? What is the diference between Partion by Growth and Partion by Range type. What are IBM plans for the future regarding table spaces. This session explains all about these new features.

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. This seminar is completely up to date with Version 8 aspects. 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.
 

With Unicode being dominantly present in Version 8 and the strict checking of CCSID’s during the migration to Version 8 a lot people started to discuss CCSID’s and Unicode. But what are CCSID’s? When does DB2 translate for me. Or better, when should DB2 translate and when not. How to interpret the output of the migration jobs? What is true about Unicode and what is plain non-sense? Klaas will try to guide you through the jungle so you can make a judgment yourself: do we have a problem or not? Some answers are surprising…
 

Online reorg has been with us for several releases now. But with every release IBM has been improving this utility. So things were and are not always perfect. Let’s review again how online reorg works and what has been changed since the introduction. Finally Klaas will review which issues still exist and will be changed in the next release.
Topics: How online reorg works, your perfect reorg run, issues fixed and issues to be fixed

Stored Procedures, a DBA view - Part I
Although Stored Procedures have been available since DB2 version 4 many shops are now starting to use them. And even if you don’t use them yourself you will probably install some software that will use them. This session will not only explain what they are but also how DBA’s should take care of them. There are many aspects of Stored Procedures from ZPARM settings to Security. This session will give a DBA a jumpstart but also some food for thought when starting with Stored Procedures. Topics covered are:
a.What are SP’s and how do I deal with them
b.DDL parameters
c.Commands
d.Programs and binding
e.Security
f.Tuning

Stored Procedures, a Programmer view - Part II
Stored Procedures are programs executed by DB2. But there are many aspects to programming Stored Procedures. Which parameter style to use. What programming language to use. What are the pitfalls and what are smart techniques. In this session you will see it all. From making the right choices to advanced techniques like Stored Procedures which call each other or the use of temporary tables. Armed with this knowledge you should be able to get going with Stored Procedures in no-time. Topics covered are:
a.Programming languages
b.Types and parameters
c.Programming aspects
d.Nesting
e.Use of temp tables
f.Development Center

From the first day DB2 has been known as a system that needs a lot of resources.
For some users in the world 2 GB is yet not enough but they will have to wait intil DB2 V8 before they can break through that limit.
DB2's hunger for memory doesn't seem to stop. Where does all this momory go?
Klaas will discuss all pieces of DB2 that will storage like bufferpool, rid pool, sort pool etc. Can we control DB2's hunger?
What happens if we tweak the parameters? Klaas will discuss where to look for performance figures.