Articles & Content


Crossing Over - A Mainframers Guide to DB2 LUW (C01)

Topic: 2010 NA

Subtopic: Cross Platform DB2 for z/OS & LUW

DATE: 2010-5-11 (12:30 PM - 01:30 PM)
SPEAKERS: Jim Wankowski (Quest Software)

DB2 running on Linux, Unix, and Windows (LUW) continues to grow at a rapid pace. This rapid growth has resulted in a shortage of experienced non-mainframe DB2 DBAs. IT departments today have to deal with tightening budgets and shrinking staffs. The luxury of being a single platform DBA is quickly becoming a thing of the past. Many DB2 mainframe DBAs find themselves supporting DB2 on these distributed platforms. Many DB2 DBAs now have to be well versed on managing DB2 on multiple platforms. This presentation focuses in on comparing the key architectural and administrative differences between DB2 running on LUW vs. z/OS. DBAs having to manage DB2 on multiple platforms will find this information essential.

EXP. LEVEL: Beginner,Intermediate


I. Database Architecture Oveview. Component comparison b. What version of DBMS do I use? c. Native access methods d. Architectural overview

II. Terminology Differences a. Similar terms, similar meaning b. Subsystem vs. Instance comparison

III. Storage Management a. Terminology for each platform b. How space is allocated on LUW vs. z/OS

IV. Object Comparisons a. Bufferpools b. Databases c. Tablespaces d. Tables e. Indexes

V. Administrative Differences a. Differences in optimizer b. Parallelism differences c. Monitoring options d. Backup/Recovery e. Differences in logging f. Differences in Utilities

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.