Articles & Content


Designing Database Structures with 24x7 in Mind (H11)

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2005

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

Click Here to Download

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