Articles & Content
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.