Sometimes, a database must be moved to a new physical home. This can mean new processors, new disk subsystems or sometimes just a new design and architecture on the same hardware or same type of hardware. This article discusses these migrations and some techniques and tools available to migrate...
DATE: 2011-5-6 (10:30 AM - 11:30 AM) SPEAKERS: John Mallonee (Highmark Inc. ) We were faced with the daunting task of modernizing an aging COBOL/mainframe system. This session will describe how we used a simplified, generic DB2 structure to replace the old IMS database. Additionally, you'll see...
NA11E15.pdf
DATE: 2011-5-6 (09:15 AM - 10:15 AM) SPEAKERS: Mary Beth Jeffords (South Carolina Budget & Control Board, DSIT) Cost has increasingly become an issue for applications on any platform, especially the zSeries. This presentation will cover ways to control the costs of both distributed and...
NA11A14.pdf
DATE: 2011-5-6 (10:30 AM - 11:30 AM) SPEAKERS: Alexander Kopac (Home Depot) The DB2 LUW Design Advisor is cool tool designed to help define suitable indexes and for testing SQL workloads. Here's a presentation that covers both the command line syntax basics and the GUI approach for making both...
NA11C15.pdf
DATE: 2011-5-6 (08:00 AM - 09:00 AM) SPEAKERS: Randy Goering (DST Systems Inc ) DB2 LUW 9.5 & 9.7 gives us the ability to have partitioned tables but how do you automate the creation of new partitions or the attachment and detachment of partitions. We have developed SQL Stored Procedure...
NA11D13.pdf
DATE: 2011-5-6 (09:15 AM - 10:15 AM) SPEAKERS: Daniel Luksetich (YL&A) This presentation will address the many different ways you can search of data in DB2 for z/OS. It's concentration will be on table and index design to support searching and scrolling, as well as various SQL coding...
NA11F14.pdf
DATE: 2011-5-5 (02:45 PM - 03:45 PM) SPEAKERS: Steve Schulz (State Farm Insurance ) Recent efforts at State Farm have leveraged BMC's High Speed Apply Engine for z/OS. Using this solution instead of application programs to achieve high volume inserts, updates, and deletes has resulted in...
NA11E12.pdf
DATE: 2011-5-5 (08:30 AM - 09:30 AM) SPEAKERS: Vijay Sitaram (McKesson Corp ), Melanie Stopfer (IBM Software Group) My manager immediately approved upgrading from DB2 LUW V9.1 to 9.7 which is a well documented process and laid out the steps. After installing the code on our UAT box, results...
NA11C09.pdf
DATE: 2011-5-5 (08:30 AM - 09:30 AM) SPEAKERS: Daniel Galvin (Galvin Consulting, Inc), Sonali Surange (IBM ) Java Data Access is becoming a central part of the business critical applications at many large companies. The Object Oriented approaches offers new opportunities for companies to solve...
NA11G09.pdf
DATE: 2011-5-5 (09:45 AM - 10:45 AM) SPEAKERS: Jorg Lueke (Blue Cross Blue Shield Minnesota) I am rushing through LaGuardia airport my intestines threatening to gave way to the parasites inside. I need to find a bathroom but I also need to eat to settle my stomach. I pass a chili dog stand and...
NA11G10.pdf