Articles & Content


Designing Database Structures with 24x7 in Mind (H11)

Topic: 2005 NA

Subtopic: Cross Platform DB2 for z/OS & LUW

DATE: 2005-5-25 (10:00 AM - 11:10 AM)
SPEAKERS: James Surber (Werner Enterprises, Inc.)

There are database design choices and operational techniques that can reduce outages. We discuss designing tables and structures with 24x7 in mind with the following concepts: rule base table structures, segregate tables to maintain table information (partition keys etc.), flexible code table design, and referential Integrity and constraints. We will also cover some techniques through application coding for 24x7.

EXP. LEVEL: Beginner,Intermediate


Designing Tablespaces and tables for 24x7.

Designs with Rule base table, Flexible code Tables

Application coding for 24x7 techniques

Static verses Dynamic SQL

Versioning Static SQL

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.