Articles & Content


Designing and Maintaining DB2 for 24x7 (Part 1 of 2) (J08)

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!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.