(Susan Visser) Coming in time for the IDUG conference in Philadelphia is the latest DB2 certification guide:

(Henrik Loeser) Today I wanted to try using a DB2 Optimization Profile for a statement impacted by the DB2 Statement Concentrator. It turned out to be a longer exercise than thought, but also with more fun, covering a lot of the DB2 tuning and monitoring infrastructure.

(Audrey S. Tan) This tutorial shows you how to configure HTTP and HTTPS tunneling for WebSphere MQ Internet Pass-Thru (MQIPT), including configuring MQIPT HTTP and HTTPS options, setting up an SSL certificate for HTTPS, and testing the HTTP and HTTPS options configured.

(Dave Beulke) With the all the hacking stories getting a lot of news coverage, security of a company’s information will definitely be on everyone’s mind. There are many DB2 security options and features that can be used within the system, database, and application environments.

(mkrafick) I had been in conversation with a respected DBA who is a well known speaker and author. I had mentioned how difficult it is to come up with advanced topics to write and speak about. That is when he responded “Advanced topics only narrow the audience”.

(Vaibhav Kulkarni and Madhuri Vuddaraju) This tutorial describes the IBM DB2 stored procedure framework, methods to monitor stored procedure performance, and methods to optimize stored procedure performance. DB2 provides a routine monitoring framework that helps pinpoint the statements or parts of t

(Scott) 100% of our studio audience learned something! Today’s presentations were again very good considering that we had contestants from Austria, Iran, and India!

(Lockwood Lyon) The DBA is responsible for recoverability, data availability, data access performance, and security. Within each of these areas there are many possible places to begin. Below, I provide the three most important areas for the DBA to address immediately.

(Gary Crupi) The IBM DB2 Analytics Accelerator has been available for over 3 years. The technology has achieved “Triple Status” with a triple digit number for both customers and units deployed.

(Troy L Coleman) When designing the physical structure “table space” used to store table data, DBAs must understand the types of processing that will occur against the table. Will the table have lots of inserts, updates or deletes, or is it mainly read-only?