When? Wednesday, September 15th, 2010, 9:00AM-3:30PM (registration at 8:30)
Where? Sheraton Columbia Hotel, 10207 Wincopin Circle, Columbia, MD (410) 730-3900
Meeting Fees:
Pre-registered members: $30
Pre-registered non-members: $40
At-the-door for members: $40
At-the-door for non-members: $50
Meeting Schedule:
| 8:30 – 9:00 | Registration | |
| 9:00 – 10:15 | An overview of the Strange New World of the Clone Table | |
| Richard Wolfson, Principal Consultant, CA | ||
|
In previous releases of DB2, users expressed the need for functionality similar to an online LOAD REPLACE utility. Introduced in DB2 9, clone table support provides users with the ability to generate a table with the exact same attributes as a table that already exists in the current DB2 subsystem. The clone is created within the same universal table space as the base table, and is structurally identical to the base table in every way. Once created, a clone table can be manipulated independently of the base table, and you can exchange data between the base table and the clone table. Clone tables thus provide the functional equivalent of an online LOAD REPLACE utility, allowing users to, for example, reload table data multiple times a day while still being able to access the existing data with read-only operations. This presentation will examine the new clone table feature, discussing concepts, features, commands and restrictions (including the new UTS table space type). |
||
| 10:15 – 10:30 | Coffee Break | |
| 10:30 – 11:45 | Harnessing the power of the DB2 Logs | |
| Rich Wolfson, Principal Consultant, CA | ||
|
DB2 logs are a vital part of DB2 and DB2 recovery, as we look deeper into the logs, and start to exploit its content, many day-to-day tasks can be changed for the better This presentation will look at real-life scenarios of how DB2 sites are squeezing the most out of the log to manage audit control, application recovery, change propagation, application QA, and assist in disaster recovery scenarios. |
||
| 11:45 – 12:45 | Lunch | |
| Optional product-specific lunch presentation Introduction to CA's New Role-Based Mainframe Workspace (presented by Troy Coleman , Principal Product Manager) | ||
| 12:45 – 2:00 | Building and Managing Efficient Data Access to DB2 | |
| Vijay Bommireddipalli, IBM | ||
| Managing performance of your mission critical applications can be a challenge, especially for growing workloads. In this session we will look at options for increasing throughput and reducing CPU utilization for new and existing Java and .Net applications. We will look at options available to stabilize the performance of applications. Finally, you will also see how to proactively avoid problems by taking advantage of database best practices during the development phase. |
||
| 2:00 – 2:15 | Break | |
| 2:15 – 3:30 | DB2 Tablespaces - What's new with V9 NFM and how to implement them | |
| John Lantz, Federal Reserve Board | ||
| When NFM mode of V9 is enabled, the DBA now has more choices when implementing tablespaces. There is a lot more things to consider then just segmented and partitioned. We will discuss how to implement each type (e.g. partition by range, partition by growth) and some of the things we have learned at the Federal Reserve Board as we go forward with V9. |
||
To pre-register, you can 1) use PayPal or 2) mail a check.
1) To pay via PayPal, simply click the link below and follow the directions; then send us an email to let us know the names of everyone in your group who will be attending.
2) To pay by check, mail the check with attendee and company name to:
The Baltimore/Washington DB2 Users' Group
P.O. Box 18554
BWI Airport, Maryland 21240
All pre-registrations must be received by Friday, September 10th, 2010.
Please note: Refunds will not be granted for this seminar for cancellations after this date. However substitution of another person can be made up until the meeting.
- Directions to the Sheraton Columbia Hotel
- Generate directions via Google Maps
- From Baltimore and North
Take I-95 South and exit Rt. 175 West (exit 41B). Travel 6 miles on 175 West. After crossing Rt. 29, go through 5 lights. After the 5th light, make first left onto Wincopin Circle. The Sheraton Columbia Hotel and Conference Center is located at the end of the Wincopin Circle, on the lake. - From Washington and South
Take I-495 East to I-95 to Rt. 32 West. Travel 3 miles North to Rt. 29 North. Travel 2 miles on Rt. 29 North to Broken Land Parkway (exit 18B). Follow signs for Columbia Town Center to Little Patuxent Parkway. Turn right and go through 3 lights. Wincopin Circle is on the right. Go to second entrance of Wincopin Circle and turn right. The Sheraton Columbia Hotel and Conference Center is located at the end of Wincopin Circle, on the lake.
- Speaker Backgrounds
- Rich Wolfson is currently a Principal Consultant for the DB2 products at CA Technologies. Rich has been an IT professional since 1983. He has worked with DB2 since 1989 and has held many roles including Programmer, Project Leader and DBA. Rich had worked as a DB2 consultant for 13 years prior to moving into technical Pre-sales in 2002. Rich currently helps customers realize the full potential of their DB2 for z/OS products.
- Troy L. Coleman is a principal product manager for CA (formerly known as Computer Associates) where he is responsible for all DB2 performance tools on z/OS. He is also an officer and Web master for the Midwest Database User Group. He has extensive experience in all facets of database systems development, including systems analysis and design, database and system administration, data analysis and application development. He has experience on many leading hardware platforms, including DB2 for z/OS, Windows, AIX, Solaris and Linux. Troy was the architect and lead developer of the first wireless database management software for DB2 UDB, PocketDBA, by Expand Beyond Corp. He is an internationally recognized consultant and lecturer, specializing in DB2 database administration and application architecture. Troy is a former adjunct professor teaching database management systems for Concordia University River Forest.
- Vijay Bommireddipalli is a Solutions Architect on the Data Studio Enablement team at IBM's Silicon Valley Lab in San Jose, CA, where he assists customers and partners in developing solutions on DB2. Prior to joining this team, Vijay worked on the Warehouse Manager development team. He joined IBM in July 2000, after finishing his Masters degree in Electrical and Computer Engineering at University of Massachusetts - Dartmouth. Vijay is a popular presenter and frequently travels to deliver pureQuery PoT’s. Vijay has a technical blog on the IBM Developerworks site
- John Lantz is an IBM Certified Database Administrator. He started his career over 25 years ago as a programmer in an IMS environment. Since then he has been a DBA for more than 20 years in a variety of organizations. Currently, he is employed as a DBA at the Federal Reserve Board in Washington DC.
- Have a topic?
- The Baltimore/Washington DB2 Users' Group welcomes suggestions for topics of interest for future meetings. Drop us a line if you have a particular topic you feel would be of interest. If you would like to share, then volunteer as a speaker and gain the satisfaction of helping other DB2 professionals benefit from your experiences.
- Sign up for Email Updates
-