Articles & Content
Topic: 2006 NA
Subtopic: DB2 for LUW
DATE: 2006-05-10 (08:30 AM - 09:40 AM)
SPEAKERS: James Surber (Universal Underwriters Group)
We will cover critical Parms, Buffers and DB2 Memory usage that will keep your database running in a near 24 x 7 environment. We will cover designing tables and structures with 24x7 in mind and table designs including Rule base table structures. Flexible code table design to keep your database up during changes. Application coding for 24x7 techniques Views and aliases Triggers and stored procedures. Table changes are typically incompatible with the goal of full availability. When a table drop or create is required, we describe a process that has allowed us to shrink table downtime from hours to minutes. We will also cover some of the new DB2 Version 8 24x7 features, when and how best to use them.
EXP. LEVEL: Beginner,Intermediate,Advanced
Parms, Buffers and DB2 Memory usage for near 24 x 7 environments
Designing Table and Structures. "Rule base" table structures
Views, Aliases, Triggers and Stored Procedures
Database design choices and operational techniques
Shrink table downtime during a table drop and recreate
This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.