Articles & Content


DB2 on Rails 2.1 - Building a Peformance Application from the Ground Up (G02)

Topic: 2009 NA

Subtopic: Cross Platform DB2 for z/OS & LUW

DATE: 2009-5-12 (11:00 AM - 12:00 PM)

The goal of the presentation is to present the primary Rails 2.1 topics that might be of interest to a DBA or Application developer. The slides will contain much of the background information and references while the presentation itself will use a hands-on approach demonstrating the concepts by building an interactive project. The demonstration project will build a tool to graphically display DB2 performance data. The performance application will feature a login screen, a report selection menu, graphical views, and the ability to define new reports all in the space of one session.Rails 2 was released in December 2007. This presentation will provide an updated understanding of Ruby on Rails with DB2 on the current version (Rails 2.1). The topics included have been tested with DB2 for z/OS V8, DB2 for z/OS V9, and DB2 UDB for LUW V 9.5. The rails install has been tested on Windows, Ubuntu Linux 7.10 and 8.04 as well as SUSE Linux 10 on zseries.

EXP. LEVEL: Beginner,Intermediate


I.Getting Starteda.Installing Rubyb.Installing Gemsc.Installing Railsd.Working with pluginsII.The Beauty of Railsa.Object Orientationb.Complete Application Stacke.The dreaded Firewall

III.Rails Basic Conceptsa.Models - Active Record and the Databaseb.Controllersc.Viewsd.Helperse.Layoutsf.Migrations

IV.Rails Associations (Database Relationships)a.One to Oneb.One to Manyc.Many to Many HABTMd.HABTM with :through

V.Modeling the data with Modelsa.Expected Foreign Keysb.Expected Naming Conventionsc.Enforcing Referential Integrityd.Overriding defaultse.Table InheritanceVI.Performance Considerationsa.Using custom SQLb.Stored Procedures

VII.Design Considerationsa.Tablespace names on DB2 for z/OSb.Default names versus Legacy Namesc.The Identity column as the foreign keyd.Database enforced constraintse.Multi-column foreign keys and indexesVII.Design Consideratio

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.