Articles & Content


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

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2010

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

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.