Page: <<   1  2  3  4  5  6  7  8  9  10  11  12  13  >> 

1.	Title:	Conference Orientation Session
	Experience Levels:	Beginner Intermediate Advanced
	Presentation Category:	Other
	Date:	Monday, Oct 13, 2008
	Time:	9:00 AM - 9:25 AM
	Venue/Room:	Warsaw Hilton - Hilton Meeting Room 8
	Abstract:	IDUG will provide you with a brief and informative overview of the conference and describe the many opportunities available to you as a first-time IDUG attendee.

2.	Title:	DB2 9 for z/OS: A New Spin on a Classic Database
	Speaker:	Lawson, Susan M
	Experience Level:	Intermediate
	Presentation Category:	Other, Performance and Tuning
	Date:	Monday, Oct 13, 2008
	Time:	11:15 AM - 12:15 PM
	Venue/Room:	Warsaw Hilton - Warsaw Hall IV
	Abstract:	This presentation details the new features coming in DB2 9 for z/OS. DB2 9 is bringing new life to our already robust DB2 z/OS database management system. These new features go well beyond the boundaries that were present in the past and also open up new opportunities and uses for the DB2 z/OS platform in terms of data storage and application exploitation. DB2 9 for z/OS brings new business insight innovations, cost savings through optimization and business resiliency. We will take a detailed look at the new features and as always we look closely at the new performance features.

3.	Title:	Memory Management for Dynamic SQL
	Speaker:	Baumann, Thomas
	Experience Levels:	Beginner Intermediate Advanced
	Presentation Category:	Managing Performance
	Date:	Monday, Oct 13, 2008
	Time:	11:15 AM - 12:15 PM
	Venue/Room:	Warsaw Hilton - Hilton Meeting Room 2
	Abstract:	Dynamic Queries use many memory resources to back dynamic statement caches, buffer pools etc.. The new 64bit systems offer a large amount of tuning opportunities, and many possibilities to waste memory. This presentation takes you from an overview of cache usage, dives into the caches to detect meaningfuel information, comes up with a 'memory efficiency score', and shows you how to estimate the benefit you could expect if you would install 2GByte of additional memory. All with a specific focus on dynamic SQL queries.

4.	Title:	Exploring the Internals of DB2 for LUW (Part 1 of 2)
	Speaker:	Huras, Matt
	Experience Levels:	Beginner Intermediate
	Presentation Category:	Other, Managing performance or availability
	Date:	Monday, Oct 13, 2008
	Time:	11:15 AM - 12:15 PM
	Venue/Room:	Warsaw Hilton - Warsaw Hall I
	Abstract:	This presentation is an in-depth explanation of the internals of DB2 UDB on the Unix, Windows and Linux platforms. It will delve into storage management, table management, logging, locking, memory management and other areas in detail. The session will describe those aspects of DB2's internal workings that are important for DBAs to appreciate in order to get the most out of their DB2 installations and keep their user communities happy. Special attention will be given to recently added capabilities such as threading, automatic storage, compression, and workload management, and other topics for which internals have not be covered previously.

5.	Title:	Building Flexible Database Systems: A Review
	Speaker:	Beauson, Dirk
	Experience Levels:	Beginner Intermediate
	Presentation Category:	Application Design
	Date:	Monday, Oct 13, 2008
	Time:	11:15 AM - 12:15 PM
	Venue/Room:	Warsaw Hilton - Hilton Meeting Room 1
	Abstract:	At KBC we had to devellop a new project to contain all Non Life Insurances. Has to contain Belgium, Polish and in the future .... Non Life Insurances. (cars, houses, ...). Has to be very very flexibel, other companies, other needs (columns, authorisations, ...). So our database has to deal a lot with flexibel flavours. I will show the possibilities we POC-ed. And desdcribe how we tried to solve this, trying to be as performant as possible. We also needed to introduce fine grained authorisation. So some users can see things on the browser that other may not see. I will also try to explain what solution we selected and why (create and consult environment).

6.	Title:	Monitoring SQL Performance Using the DB2 Statement Cache
	Speaker:	Perry, Mike
	Experience Level:	Intermediate
	Presentation Category:	Other, Creative methods for managing database resources
	Date:	Monday, Oct 13, 2008
	Time:	11:15 AM - 12:15 PM
	Venue/Room:	Warsaw Hilton - Hilton Meeting Room 10&12
	Abstract:	This session discusses a low cost method of detecting and diagnosing SQL performance problems. The V8 EXPLAIN STMTCACHE and the V9 EXPLAIN MONITORED STMTS statements form the basis of the technique. You will learn how to use the DSN_STATEMENT_CACHE_TABLE to find unexpected statistics values, to obtain the statement text and to execute an EXPLAIN PLAN statement. The session reveals the cost of collecting the statistics.

7.	Title:	Bottlenecks Elimination in Real World DB2 Applications
	Speaker:	Chen, Sigen
	Experience Level:	Intermediate
	Presentation Category:	Other, Managing performance or availability
	Date:	Monday, Oct 13, 2008
	Time:	11:15 AM - 12:15 PM
	Venue/Room:	Warsaw Hilton - Hilton Meeting Room 9&11
	Abstract:	Database application performance for a given system (hardware and software) may be determined by application behavior, APIs, database design and layout, data size, system configurations. This presentation will cover these aspects based on the performance improving practice from real world database applications. The focus will be on understanding the application behavior; creating the right indexes; writing optimal queries, exploring the query features wisely; using appropriate APIs for a given requirement, not only on the programming language level, but also on the statement attributes such as cursor type, data type for binding, fetch orientation, array options; practicing proactive maintenance to ensure optimal data layout and statistics; tuning the key configuration parameters based on application behavior and system monitoring data. The troubleshooting examples and sample code segments are used to exemplify the practice. Performance issue debugging and analysis is also included.

8.	Title:	RUG Meeting
	Experience Levels:	Beginner Intermediate Advanced
	Presentation Category:	Other
	Date:	Monday, Oct 13, 2008
	Time:	12:15 PM - 1:15 PM
	Venue/Room:	Warsaw Hilton - Hilton Meeting Room 9&11
	Abstract:	Spend time with members of your Regional User Grop at this networking event.

9.	Title:	What It Takes to Present at IDUG
	Experience Levels:	Beginner Intermediate Advanced
	Presentation Category:	Other
	Date:	Monday, Oct 13, 2008
	Time:	12:45 PM - 1:15 PM
	Venue/Room:	Warsaw Hilton - Hilton Meeting Room 8
	Abstract:	During this session, IDUG will provide you with a brief and informative overview of what it takes to present at an IDUG conference (and receive a free conference registration!)

10.	Title:	Table and Table Space Changes in DB2 9 for z/OS
	Speaker:	Grainger, Phil
	Experience Level:	Beginner
	Presentation Category:	Implementing new DB2 releases and features
	Date:	Monday, Oct 13, 2008
	Time:	1:30 PM - 2:30 PM
	Venue/Room:	Warsaw Hilton - Warsaw Hall IV
	Abstract:	Since the introduction of segmented tablespaces to DB2 for z/OS (when WAS that??) nothing really significant has happened to either tables or table spaces DB2 9 changes all that We gain a new table space type (the Universal Table Space) and say "good bye" to Simple Table Spaces We also now have GROWTH as well as RANGE partitioning Not to mention table Clones This is a big time of change for those humble table sand table spaces

Page: <<   1  2  3  4  5  6  7  8  9  10  11  12  13  >>