Officers Mission Membership Info Registration Events Past Speakers Contact Us Site Map


July, 2008:

HOTDUG's Third Quarterly Meeting
Download the agenda here!

Speakers:
Bryan Smith of IBM and Willie Favero of IBM.

Presentations:
IBM Data Studio Administrative Tooling (Cross-Platform).

Structure and Format Enhancements in DB29: UTS & RRF (printer friendly version click here).

Find out why all the buzz on Data Studio and all the rave on DB2 V9 Universal Table space.

Location:
IBM Briefing Center
11501 Burnet Road
Building 904
Austin, TX

July 8, 2008:

Save the date: HOTDUG's third quarterly meeting of 2008 will be at IBM's Briefing Center

We will have technical presentations in the morning.

IBM Data Studio Administrative Tooling (Cross-Platform)
A significant part of IBM Data Studio is the set of administration functions that are used by application and system DBAs. These functions include query/workload tuning, automating routine data maintenance, proactive monitoring, and mapping of problem applications - all the way back to the line number of the application that generated the database request. Learn how the cost of database administration can be significantly reduced by this tool set that integrates the life cycle of the data. This presentation will introduce current capabilities as well as discuss future directions.

Structure and Format Enhancements in DB2 for z/OS V9: Universal Table Space & Reordered Row Format
DB2 9 delivers a brand feature that has generated considerable discussion. It's a new structure type called universal table space. There is also a second enhancement that you may not hear as much about; a new storage format referred to as reordered row format. Both of these will significantly improve your DB2 experience by making a couple aspects of DB2 easier to manage. This presentation will give you the details behind how both of these features are implemented, how to use them and a look at a few things you cannot use them for.

April, 2008:

HOTDUG Second Quarterly Meeting
Download the agenda here!

Speakers:
Tom Bauch of IBM and Craig Mullins of NEON Enterprise Software, Inc.

Presentations:
DB2 Migration Tips and Tricks

The Impact of Regulatory Compliance on Database Administration (Cross-Platform)

Location:
Teachers Retirement System
Room 110 West
1000 Red River Street
Austin, TX

April 8, 2008:

Save the date: HOTDUG's second quarterly meeting of 2008 will be at Teachers Retirement System

We will have technical presentations in the morning.

DB2 9 Migration Tips and Tricks � Things Not Commonly Mentioned! (Platform: DB2 for LUW)
Are you responsible for migrating your database to DB2 9? Are you responsible for preparing applications, routines and scripts for migration? Are you looking for details about what has changed? If so, don�t miss this session! Tom will unveil tips and tricks about changes made to DB2 9 that are often overlooked but very important to understand before migrating. Planning your migration can be much easier if you understand things not commonly mentioned.

The Impact of Regulatory Compliance on Database Administration
As governmental regulation and control expands organizations need to deploy better controls to ensure quality data and properly protected database systems. Governmental regulations are increasing in number, and many of them impact the way organizations must treat their data. Sarbanes-Oxley, HIPAA, BASEL II, and more make the news, but what do they mean to a DBA? And what steps do we need to take to be in compliance?

This presentation will offer an overview of the regulations and their impact on database administration. Topics to be discussed include:
* What are the Regulations?
* Compliance Issues
* Long-term Data Retention
* Database Auditing
* Database Security and Data Encryption
* Data Masking
* Additional DBA Concerns

February, 2008:

IBM's Proof of Technology
February 29, 2008
Download the agenda here!

Presentations:
DB2 9.5 Automated Failover with High Availability Disaster Recovery and Tivoli System Automation

Location:
IBM
400 W. 15th Street
12th Floor
Austin, TX

February 29, 2008:

Save the date: IBM's Proof of Technology will be at IBM, 400 W. 15th Street, 12th Floor.

We will have technical presentations in the morning.

IBM DB2 9.5 Support for Automated DB2 HADR Failover
DB2 9.5 Enterprise Server Edition and Workshop Server Edition come with everything you need to automate failover, with High Availability Disaster Recovery (HADR), Tivoli System Automation (TSA) base, and a new configuration tool, db2haicu, that eases the configuration of an automated HADR failover environment. This Proof of Technology provides conceptual overviews of the HA components, discussion of their integration, and hands-on lab exercises to demonstrate the configuration and testing of a highly available DB2 environment with automated failover.

January, 2008:

HOTDUG Quarterly Meeting
January 30, 2008
Download the agenda here!

Speakers:
Wayne Slomiany and Luis Gasca of Compuware

Presentations:
Application Performance for DB2

Application Data Privacy

Location:
Texas Department of Transportation
Lone Star Room, Building 1
4000 Jackson Avenue
Austin, TX

January 30, 2008:

Save the date: HOTDUG's first quarterly meeting of 2008 will be at Texas Department of Transportation

We will have technical presentations in the morning.

Application Performance for DB2
As DB2 has evolved, it has never been more important to improve the quality and performance of DB2 applications in test and production. Wayne will discuss approaches that help users avoid the inefficient use of DB2 system services and techniques to reduce excessive wait time or execution in DB2 system services. Wayne will also offer approaches to help reduce resource consumption and best practices to improve application performance.

Application Data Privacy
Complying with Data Privacy regulations, mitigating the risk of sensitive data exposure, and obtaining Data Privacy audit certifications have become priorities for IT organizations. Research indicates that the majority of data mishandling occurs internally. In addition to security measures for production environments, organizations need to protect data used for application testing and quality assurance. To address this issue, IT organizations must enhance their QA processes to protect test data while maintaining integrity, consistency and usability.

October, 2007:

HOTDUG Quarterly Meeting
October 9, 2007
Download the agenda here!

Speakers:
Bill Arledge of BMC Software, Inc.

Presentations:
Dynamic SQL and the Dynamic Statement Cache

Ins and Outs of Distributed Processing in DB2 z/OS

Location:
BMC Software, Inc. Executive Briefing Center
10415 Morado Circle
Building 5
Austin, TX
78750

October 9, 2007:

Save the date: HOTDUG's final quarterly meeting of 2007 will be at BMC Software's Executive Briefing Center.

We will have technical presentations in the morning and an optional demo and Q/A of BMC's Log Master for DB2 during lunch.

Dynamic SQL and the Dynamic Statement Cache
Dynamic SQL is being used more and more in DB2 shops around the world. Multiple factors are driving this increase in usage. As with most DB2 options, dynamic SQL offers potential benefits as well as new management challenges. This technical session begins with a brief overview on SQL tuning followed by a more detailed discussion on managing and tuning dynamic SQL. Finally, we�ll discuss the dynamic statement cache, a DB2 feature that can help address dynamic SQL performance issues.

Ins and Outs of Distributed Processing in DB2 z/OS
More and more DB2 application workload originates off the mainframe utilizing technologies like DB2 Connect, Websphere Application Server, and others. This shift to increased distributed processing presents new challenges in understanding and managing DB2 application implementation. This session discusses basic issues about distributed applications, including distributed fundamentals, implementation considerations, problem identification, and performance management for your DB2 on z/OS distributed applications.

July, 2007:

HOTDUG Quarterly Meeting
July 10, 2007
Download the agenda here!

Speakers:
Terry Purcell and Brian Baggette of IBM

Presentations:
More Ways to Challenge the DB2 z/OS Optimizer.
Presentation
Handouts for printing

What's new with the Optimizer in DB2 for z/OS V8?
Presentation
Handouts for printing

Location:
IBM Briefing Center
11501 Burnet Road
Building 904
Austin, TX

July 10, 2007:

Save the date: HOTDUG's 3rd quarterly meeting will be at IBM on Burnet Road.

We will have technical presentations in the morning and FREE certification testing in the afternoon (a $150 value per test). You may take multiple tests as long as space and time permit. Check exam information here!

What's new with SQL Optimization in DB2 V8 for z/OS?
This presentation will provide an update of the optimization enhancements delivered in DB2 z/OS for V8. The GA enhancements include (1) Complex Join, (2) Star Join optimization, (3) Predicate Sargability, (4) Visual Explain, (5) REOPT (ONCE) bind option, (6) Runstats enhancements, (7) Materialized Query Tables and (8) Page range screening. Recent enhancements will also be discussed as part of this presentation.

More ways to challenge the DB2 z/OS Optimizer.
Ever wondered what can cause the DB2 z/OS optimizer to choose a non-optimal access path? The more that you understand the challenges that make query optimization difficult to perfect, the better equipped you will be to manage the performance of your SQL queries. This presentation will cover more than just the simple correlation and data skew challenges for optimal access path selection.

June, 2007:

Event:
Maximizing IBM DB2 V8 using the DB2 utilities.

Register here!

IBM will be hosting a webcast:
Maximizing IBM DB2 V8 using the DB2 utilities
Date: June 5, 2007
First Call: 9:30AM EDT
Second Call: 12:30PM EDT

Register here!

Speaker: Bryan Smith, IBM Distinguished Engineer, DB2 for z/OS� utilities development.

This teleconference will also be available for replay after the event.

April, 2007:

Event:
Discovering the Value of IBM DB2 V9 Administration for the SQL Server DBA. A proof of Technology.

Download agenda here!

Directions:
IBM
400 W. 15th Street
Austin, Texas
RSVP only; no walk-ins.

RSVP to mary.lo@tgslc.org

April 24th and 25th, 2007:

DB2 9 comes with many powerful features that help ease the day-to-day activities all DBAs must perform in every IT shop. In this Proof of Technology, specific comparisons with SQL Server are made throughout to help customers better understand the feature and function differences between DB2 and the competitive SQL Server product. This session consists of both presentation and hands-on lab exercises.

This session enables customers to gain an understanding of IBM DB2 9 administration, evaluate the DB2 9 administration vs. SQL Server administration, and expedite their purchasing decision process. In breif, DBAs already working with SQL Server, or those considering adding SQL Server to their repertoire, will be able to see just how easy and yet powerful DB2 administration can be.

April 10, 2007:

First Presentation
Scott Hayes, Database-Brothers Inc.
Download presentation here!

Accelerate Your DB2 Business On Demand Autonomically!
Over ten years of crisis and fine tuning DB2 LUW and its applications (SAP, Siebel, PeopleSoft, Lawson, Websphere, and I2 to name a few) have yielded many valuable lessons and performance tuning solutions. This session describes performance best practices and tips for exploiting the many autonomic tuning capabilities of DB2 LUW. It is loaded with practical, technical, and usable lessons for achieving dramatic and measurable performance improvements on any DB2 Multi-Platform database, with emphasis on V8.2 and V9. Attendees will hear anecdotes and customer success stories from actual customer situations and learn the physical design and/or configuration solutions that provided remarkable performance results, and will also take home a checklist to verify performance integrity in their own shops. With all of the new AUTOMATIC and AUTONOMIC capabilities of DB2, attend this session to learn what is left for the DBA to do - if anything!

Second Presentation
Alexander Kopac, Database-Brothers, Inc.
Download presentations here

Parlez-Vous Klingon? Recursion SQL for Generating Test Data
Often when the words 'recursive query' are heard, application developers & DBA's may hear a 'klingon' or guttural groan. Here�s a simple step-by-step presentation about using SQL and �recursive queries� to quickly generate DB2 test data. See how SQL in Stored Procedures & Command Line scripts generates & refreshes DB2 test data without a programmer to compile a C/COBOL/Java programs. These recursive queries techniques run on any DB2 family member version 8 and above. We will explain �recursive queries� in simple terms and give lots of examples to take back to the office.

January 9, 2007

Event:
First Quarterly Meeting
Registration: 8:30 - 9:00am
Meeting: 9:00am - 1:00pm
Download agenda here!

Breakfast and Lunch will be sponsored by Crossroads Systems

Willie Favero of IBM will present: Dynamic SQL Examined, and DB2 Visual Explain V8.

Mita Roychowdhury of Crossroads Systems will present: Database Security: An essential component of Enterprise Security.

RSVP to mary.lo@tgslc.org

Location:
Texas D.O.T.
Lone Star Room, Building 1
4000 Jackson Ave.
Austin, TX

First Presentation
Willie Favero, IBM

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.

Second Presentation
Mita Roychowdhury, Crossroads Systems

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.



HOME