Klaas Brant

Speaker Details

Bio

Klaas Brant is the founder of KBCE, a company that specializes in DB2. He specializes in administration, tuning and backup/recovery strategies. Klaas has been working with DB2 for more than 20 years and has published many DB2 articles. He has been the organizer of the DB2 Symposium for more than 15 years. Klaas is the chairman of the Dutch DB2 User Group (DDUG) and an IBM certified DB2 Database Administrator. Klaas is a member of IBM's DB2 Gold Consultants Team. He can be reached at: kbrant@kbce.com

Past presentation
18 June 2015
09:00 - 16:00
European SQLAdria Seminar – Dubrovnik 2015 DBA update 10.1 and 10.5
Have you recently upgraded to 10.1 or 10.5? Are you planning to do so soon? Then you would like to know all the details of what's new and changed! And there is a lot more to tell then just BLU. This seminar will not only tell you about all the new options but also teaches you the practical use of many new features. After this update you completely up to date with the latest releases AND the many changes in the fix packs. A must for every LUW DBA / Administrator!
 
Topics:
Upgrading to 10.1 and 10.5
What's changed , deprecated and discontinued?
Automatic Storage, Storage Groups and Multi-temperature storage
Row and Column Access Control (RCAC) in practice
HADR enhancements
Compression & encryption enhancements
New DDL options
Dealing with deadlocks & timeouts
What's new with the utilities
Using DB2 as NOSQL (JSON support)
Clients & drivers enhancements
New DB2pd & DB2 Support options
BLU enhancements & future
SQL/PL Enhancements

17 June 2015
11:30 - 12:30
European SQLAdria Seminar – Dubrovnik 2015 Improving performance without touching the SQL

The majority of the performance problems is caused by bad SQL. How case you test, find and solve some problems without touching the SQL? In this session we will look at DB2BATCH, DB2 Design Advisor, and some performance snapshots to analyze and fix problems.


17 June 2015
10:00 - 11:00
European SQLAdria Seminar – Dubrovnik 2015 How compression works

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.


16 June 2015
16:00 - 17:00
European SQLAdria Seminar – Dubrovnik 2015 SQL/PL for stored procs and more

Most people know you can build SQL/PL stored procedures. But you can do other things with it as well. You can use it for triggers or UDFs for example. Let’s take a closer look what you can do with it. The open source monitoring... is Cristian’s topic. Attached is the last version of the agenda we got from Zeljen. I have 5 topics (the four I did send + SQL/PL) 


16 June 2015
15:00 - 16:00
European SQLAdria Seminar – Dubrovnik 2015 Help, I have a problem!

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


16 June 2015
14:00 - 15:00
European SQLAdria Seminar – Dubrovnik 2015 New locking options & monitoring deadlocks / timeouts

DB2 sneaked in a new option which became the default called “currently committed”. What is it and why did it become the default? If I upgraded should I switch it on? Another issue which keeps DBAs busy are deadlocks and timeouts. In this sessions we will review what causes it and who you can start a low overhead event monitor to detect them.


29 May 2014
09:00 - 16:00
European SQLAdria Seminar – Dubrovnik 2014 DB2 LUW - keeping your server in good condition

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


13 June 2013
09:00 - 16:00
European SQLAdria Seminar – Dubrovnik 2013 DB2 LUW advanced topics

11 June 2013
16:00 - 17:00
European SQLAdria Seminar – Dubrovnik 2013 Keeping your data in shape

11 June 2013
15:00 - 16:00
European SQLAdria Seminar – Dubrovnik 2013 Advanced data movement

14 June 2012
09:00 - 16:00
SQLAdria Seminar – Dubrovnik 2012 DB2 LUW advanced topics

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

 


13 June 2012
10:00 - 11:00
SQLAdria Seminar – Dubrovnik 2012 Practical guide for DB2 snapshots using SQL

Once there were just snapshot command and a difficult API interface. But then IBM decided to wrap snapshots (and more!) into table functions. To make life easier these table function have been rolled into views. Nowadays you can retrieve every piece of information regarding performance, utilities, messages, space, environment etc. etc. from the many administrative views by IBM. Klaas will show how to obtain the best information from them and how to you can, with some simple procedures, create a history of performance and data growth.


12 June 2012
13:00 - 14:00
SQLAdria Seminar – Dubrovnik 2012 DB2 LUW security and audit

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.


16 June 2011
09:00 - 16:00
SQLAdria Seminar – Dubrovnik 2011 Crash course DB2 Linux/Unix/Windows for z/OS people

DB2 for Linux/Unix/Windows (LUW) is becoming more popular every day. Many IBM customers who run DB2 for z/OS are using DB2 LUW also, or will do so in the next year. For cost saving and optimization reasons many companies, who have both products, have decided that they will combine DBA activities to be done by a single group of DBA’s. People who have been doing DB2 for z/OS for a (very) long time are suddenly facing a “new” DB2. DB2 = DB2 is a simple assumption which is only partly true. So, some things are similar, and other things are completely different. Klaas Brant has been using both products for a very long time and can explain to you were the major differences are and how to avoid some pitfalls in DB2 LUW for DB2 for z/OS DBA’s. The seminar assumes you have a good knowledge of DB2 for z/OS and its components and have no or limited knowledge of DB2 for LUW.

Outline
Architectural comparison
Architectural overview
Subsystem vs. Instance comparison
Access methods
Similar and different terms
Storage Management
How space is allocated
How space is managed
How performance is optimized
Object Comparisons
Databases
Tablespaces
Container
Tables
Indexes
Bufferpools
Administrative Differences
Logging
Backup/Recovery
The differences in optimizer
Monitoring options
Autonomic Computing
Utilities


18 June 2009 (All day)
(All day)
SQLAdria Seminar – Dubrovnik 2009 DB2 System Tuning 2009

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!


17 June 2009
11:15 - 12:15
SQLAdria Seminar – Dubrovnik 2009 What’s new in security

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


16 June 2009
15:45 - 17:00
SQLAdria Seminar – Dubrovnik 2009 Spice up your application with hot SQL

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.


26 June 2008 (All day)
(All day)
SQLAdria Seminar – Dubrovnik 2008 Application performance & design 2008

Objectives:
Get more knowledge about how DB2 processes applications. With this knowledge tune applications for maximum performance.

Outline:
Part 1 DB2 Accounting trace

DB2 trace: classes & destinations
What is (not) in the DB2 accounting record
Nested activity (Stored Procedures, UDFs & Triggers)
Your Performance Indicators
CPU
Getpages
Wait time (not lock)
Lock time
IO's
Sort

Part 2 SQL Access Path
Explain: What does this (not) tell you
DSNSTMT table, use it!
Can the statement be improved?
Tuning toolbox
Groundrules for tuning
SQL Tuning
Forcing DB2 (optimize for / Hints)
Optimizer rewrite, when and how
Asking DB2 to reconsider
More and better stats
Bad thing you should not consider
Parallelism, why and why not!
How about dynamic SQL?

Part 3 Hints and tips for a better performance
Better SQL
Beter Database design
Improving your application logic
Batch Issues

Full Abstract:
There are many, many things that influence your performance. Where to find your performance indicators? How to interpret them?
This seminar looks at collecting and interpreting performance figures, looks at alternatives and discusses what should be done in order to obtain better performance. The last few releases of DB2 gave us some great things (e.g. multi row insert and fetch, and volatile tables). We will review these things in order to improve our applications. You will go home with some new idea's to improve your application.


25 June 2008
09:00 - 10:00
SQLAdria Seminar – Dubrovnik 2008 Universal Table Spaces, what are they?

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.


24 June 2008
15:30 - 16:15
SQLAdria Seminar – Dubrovnik 2008 Clone Table, Hot or not?

Objectives:
Understand the new CLONE SQL instruction. What is (im)possible using this V9 feature?

Outline:
When it can (not) be used
How it works
Restrictions
Utilities
Impact on recovery

Full Abstract:
The SQL CLONE statement is a new powerful statement. But there are restrictions and pitfalls. This sessions explain how it works and what the restrictions are. When used wisely the new instruction is a great addition to the DBA toolkit.


21 June 2007
09:00 - 15:00
SQLAdria Seminar – Dubrovnik 2007 DB2 for z/OS System Tuning

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.
 


20 June 2007
12:15 - 13:15
SQLAdria Seminar – Dubrovnik 2007 DB2 z/OS Locking Problems and Solutions

XML is here to stay. More and more is this method used to transmit and store data. What is so cool about XML? XML data is different from relational data. So how are we going to handle this? Klaas will explain what XML is and why it is used so much. Then we will analyse how we can store, extract and assemble XML. All options are available in DB2. We will go a complete journey with XML functions, XML extender and Native XML storage.
 


19 June 2007
11:15 - 12:15
SQLAdria Seminar – Dubrovnik 2007 CCSID’s and Unicode explained: myths and facts

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…
 


29 June 2005
11:00 - 11:45
SQLAdria Seminar – Dubrovnik 2005 Bufferpool design anno 2005

Buffer pools and there settings is the #1 tuning opportunity in DB2. But there are many settings and there so many stories about buffer pools that it sometimes not clear where to begin and what to expect as result. Also when you move to version 8 options like hiper pool and data space no longer exist. Now what? Klaas will tell you how to prepare for version 8 with a practical working solution in version 7. Because the golden rule still is: your DB2 performs better if the buffer pool setting are tuned.
Topics: What are buffer pools and why are they important, one of more buffer pools?, getting rid of the hiper pool, monitoring the efficiency


28 June 2005
09:45 - 10:35
SQLAdria Seminar – Dubrovnik 2005 Online Reorg, almost perfect

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


28 June 2005
09:00 - 09:45
SQLAdria Seminar – Dubrovnik 2005 DB2 parallelism, the beauty and beast in one

SQL can be processed in parallel by DB2.  How does this work? What is the difference between IO parallelism and CPU parallelism? How do I ask for parallelism and how can I find out it has will be or has been used? Which settings and parameters are important? Klaas will show you that processing SQL can be a great feature of DB2 but there are cases when parallelism is very bad option.
Topics: Types of parallelism, asking for parallelism (degree), parameters that influence parallelism (Bufferpools, ZPARM, SQL), Monitoring and predicting (Explain and accounting trace), Rules for using parallelism


08 June 2004
14:15 - 15:45
SQLAdria Seminar – Dubrovnik 2004 DB2 Stored Procedures Part II

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


08 June 2004
09:00 - 10:30
SQLAdria Seminar – Dubrovnik 2004 DB2 Stored Procedures Part I

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 


10 June 2003
14:30 - 15:30
SQLAdria Seminar – Dubrovnik 2003 Where does all this memory go?

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.


10 June 2003
11:00 - 12:00
SQLAdria Seminar – Dubrovnik 2003 Dynamic SQL

Dynamic SQL has a bad reputation.
Why? Is it really that bad?
Many users don't even know what dynamic SQL really is.
Ask a ten users and get ten (wrong) answers to the question: what is dynamic SQL?
Klaas will review what dynamic SQL is and why it is regarded as "bad".
But it seems dynamic SQL is used more and more. ODBC and SAP are good examples.
What can we do to boost the performance of dynamic SQL?
You might have heared about the dynamic SQL cache.
How does it work and when can we benefit from it or more important when doesn't it work for us...


 

sqladria

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.

Follow us

facebook
linkid
twitter

 

Events in 2018

Ljubljana - 9th & 10th April 2018
Belgrade - 12th April 2018
Šibenik - 10th - 14th June 2018
Zagreb - 18th September 2018
Opatija - 29th & 30th November 2018