Raymond Bell

Speaker Details

Company: 
BMC Software
Bio

Raymond is a Software Consultant with BMC Software, having joined the company in 2007. He's worked as a DB2 DBA on Windows, AIX and OS/2 (!) but is most at home with Big Iron, having started along the DB2 DBA path 20 years ago on DB2 for MVS V1.3. He's worked in a variety of industries in several countries and now calls Reigate home - about as far from Wellington, NZ, as you can get.

Past presentation
24 September 2010
12:45 - 13:45
SQLAdria Seminar – Zagreb 2010 SQL Tuning

The Dynamic Statement Cache in DB2 has the potential to greatly improve performance for dynamic SQL. As with most things, there are tradeoffs and costs to be considered with this DB2 feature. Meanwhile, the implementation of the cache often changes from release to release. This technical session will discuss the Dynamic Statement Cache to help you understand how the cache is implemented, the contents of the cache and how you can mine the statistics stored there, potential benefits and costs of the cache, including potential issues related to use of the Dynamic Statement Cache.
 
 


24 September 2010
10:15 - 11:15
SQLAdria Seminar – Zagreb 2010 Change Management

Metadata stored in the DB2 Catalog is very well known and easy to interrogate using SQL. However, at run time, DB2 makes extensive use of the other primary DB2 system database, the Directory or DSNDB01. This presentation describes the contents of the Directory, explains how to look at its contents, and discusses how you can improve your overall system performance and recovery times by paying a little more attention to this often forgotten resource.
 
 


 

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