Articles & Content


DB2 Z/OS V8 Data Warehouse Conversion to DB2 LUW 9.5 (E01)

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2010

DATE: 2010-5-11 (12:30 PM - 01:30 PM)
SPEAKERS: William Gannon (Palm Beach County School District)

This presentation will detail the steps followed, the tools used and the challenges overcome in our efforts to convert our 200gig Data Warehouse from DB2 Z/OS to DB2 LUW. The presentation will detail the use of the Xload process to transfer data, the use of Federated Services and will highlight the lessons learned in the process.

EXP. LEVEL: Intermediate


Setting up Production DB2 Z/OS database as a Federated Server in DB2 LUW 9.5

Creation and Maintenance of Database objects on LUW using Federated Server.

Moving data from Z/OS to LUW via XLoad Process.

Conversion of the Z/OS DBA to an LUW DBA

Obstacles and challenges encounters in the conversion and detailed resolutions.

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.