Robert Brock

HOTDUG - The Austin DB2 User Group

Come to the 1st Quarter HOTDUG Meeting.
HOTDUG would like to thank Crossroads Systems Inc. for sponsoring our meeting.

Date: Tuesday Jan 9, 2007

Location: Texas Department of Transportation (TXDOT)

Lonestar Room Building 1

4000 Jackson Ave.

Austin, TX

Registration & Continental Breakfast: 8:30 A.M. - 9:00 A.M

Meeting: 9:00 A.M. - 12:00 P.M.

Lunch 12:00 - 1:00 please RSVP to [login to unmask email] for a lunch headcount

First Speaker

Willie Favero

Presentation Overview

DB2 Visual Explain V8

Visual Explain Version 8 has been redesigned to expose lots of information that customers want to see. This presentation walks users through using the new Visual Explain to identify problems in their queries. Visual Explain exposes estimated qualified rows, costs that are associated with using indexes, predicate sargability, screening predicates, predicate filter factors, the partitions that qualify for limited partition scan, and more.

Dynamic SQL Examined

Is dynamic SQL really bad? Of course, the DB2 answer will be "It depends!" There is a place for everything and everything has its place, including dynamic SQL. You just need to know the When's and How's to use it successfully. This presentation gives you that information. Come hear how to use dynamic SQL, the different types of dynamic SQL, and what DB2 for z/OS has done to help make dynamic SQL perform as well as possible.

Speaker Biography

Willie Favero is currently the DB2 for z/OS Sales Specialist for the West Region in IBM's Sales and Distribution organization, an IBM Senior Certified IT Software Specialist, and an IBM Certified Solutions Expert for DB2 for z/OS Version 8, for DB2 UDB, and for DB2 for OS/390 Version 7. Between IMS/VS DB/DC, Cincom's Total and Supra, IDMS, and DB2, he has over 29 years experience working with database. However, Willie has spent his last 21 years working primarily with the DB2 family. His responsibilities include consulting to IBM's customers on DB2 for z/OS and OS/390, DB2 tools, and PeopleSoft, SAP, Siebel, and WebSphere from DB2's perspective. He performs DB2 subsystem, performance, and security health checks, performance tuning for the DB2 subsystem, performance analysis for DB2 applications and SQL, design reviews, data modeling, general DB2 consultation, CritSit resolution, DB2 installation assistance, migration planning to DB2 for z/OS Version 8, and all forms of DB2 education.

Willie is a recognized worldwide as a DB2 expert and is a highly sought after speaker on a variety of DB2 for z/OS, Client/Server, and Object Technology topics.

Second Speaker

Mita Roychowdhury

Presentation Overview

Database Security: An essential component of Enterprise Security

Databases - repositories of sensitive information - are integral to an enterprise's security framework. With the dramatic rise in sensitive data, security breaches, and government regulations - ensuring data security, particularly, safeguarding from internal attacks has assumed critical position. Architecting a layered security platform that complements and enhances traditional approaches is gaining acceptance in the enterprise market.

Speaker Biography

Mita Roychowdhury, senior product manager at Crossroads is responsible for managing the "StrongBox' line of security products. Mita worked as senior product manager for Oracle, prior to joining Crossroads. She is currently completing her PhD in Communications at UT Austin.

Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at