Articles & Content


Rexx and DB2 (B05)

Topic: DB2 for z/OS

Subtopic: 2006

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.

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.