Peter Plevka

Speaker Details

Bio

I started my IT career in 1987 at a large Austrian insurance company as an MVS Operator and later as a DB2 systems programmer and Database Administrator. In 1994 I joined Platinum technology as a software consultant for their DB2 solutions. Later with CA my role expanded being the european technology leader for CA’s database management solutions for DB2, IMS and ORACLE. Since 2003 with BMC, I assume a very similar position in the European mainframe market as a brand manager for Data Management and I am involved in customer support, product training and sales training, as well as presenting at local and international user groups.

Past presentation
28 September 2012
10:15 - 11:15
SQLAdria Seminar – Zagreb 2012 DB2 10 for z/OS Security Features: Early customer experiences

Stored Procedures were first added to DB2 for z/OS back in V5. Most every release of DB2 since has added additional functionality or type of stored procedures. The different types of stored procedures have strengths and weaknesses. This presentation will provide a brief history of Stored Procedures in DB2 for z/OS, along with an overview of the schema used to create stored procedures. It will discuss the different types of stored procedures, External, External SQL and Native touching on some of the advantages and disadvantages of the different types. How can you test a new version of a Native stored procedure without affecting other executions of the active version? When it comes to deploying Native Stored Procedures across your environment, what options do you have available? 


23 September 2011
11:30 - 12:30
SQLAdria Seminar – Zagreb 2011 Squeeze the Most out of your Indexes in DB2 9!

Index compression was announced as part of DB2 9 for z/OS, but it remains a mystery to many users. Is it the same as tablespace compression? If not, how is it different? How do I take advantage of it, and how can I know which indexes to compress? This presentation will cover some of the internals of index compression, and then it will answer your questions about when and how to most effectively use the feature.


24 September 2010
11:30 - 12:30
SQLAdria Seminar – Zagreb 2010 System Performance Optimization

This session will help you to understand how to decrease IO through better usage of bufferpools. I will take a close look at the DB2 bufferpool architecture, and how to make it work for your database and application design. You will understand performance attributes, we will discuss the concept of the application hit ratio, and show an example on how to measure improvements after changes to the bufferpool configuration.
 
 


23 September 2005
11:00 - 11:45
SQLAdria Seminar – Zagreb 2005 Reorganization Strategies in Depth

24 September 2004
11:15 - 12:00
SQLAdria Seminar – Zagreb 2004 Where did all my storage go

24 September 2004
10:25 - 11:15
SQLAdria Seminar – Zagreb 2004 Unicode

26 September 2003
10:25 - 11:15
SQLAdria Seminar – Zagreb 2003 Reorganization Strategies Reviewed

08 June 2003
15:15 - 16:15
SQLAdria Seminar – Dubrovnik 2003 What's New on the P01 Release?

27 September 2002
11:15 - 12:00
SQLAdria Seminar – Zagreb 2002 The Index - A Review

28 September 2001
12:15 - 13:00
SQLAdria Seminar – Zagreb 2001 The Index - A Review

13 June 2001
09:00 - 10:00
SQLAdria Seminar – Dubrovnik 2001 DB2 Administration and Tuning for SAP R3 on DB2

07 April 2000
11:20 - 12:20
SQLAdria Seminar – Zagreb 2000 Triggers - What, How and When?

 

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 2024

VODICE -  10th - 13th June 2024