Articles & Content


Rexx and DB2 (B05)

Topic: 2006 EU

Subtopic: DB2 for z/OS

DATE: 2006-10-3 (10:15 - 11:15)
SPEAKERS: Jim Addison (Standard Life)

The challenging world of DBA attracts frequent interruptions for often repetitive tasks. Rexx is a powerful, easy to use language which can be used to reduce or eliminate manual effort. The Rexx/DB2 interface can be used for further exploitation by DBAs and Stored Procedures written in Rexx provide additional advantages.This presentation demonstrates the fundementals of Rexx, using the DB2 interface and the use of Rexx stored procedures. Examples of the use of Rexx DBA applications at Standard Life is included, one of which is the autonomic creation and scheduling of targeted housekeeping operations (runstats, modify, reorganisation, image copy, quiesce).The presentation is suitable for DBAs and Application staff.

EXP. LEVEL: Beginner


An appreciation that Rexx is a readily exploitable language for DB2 applications.

The building blocks for Rexx/DB2 applications

The advantages of Rexx stored procedures.

Confidence to explore Rexx in a DB2 environment.

An insight into how Rexx/DB2 has proven invaluable at Standard Life.

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.