Crash course DB2 Linux/Unix/Windows for z/OS people

Date: 
Thursday, 16 June, 2011 - 09:00 - 16:00
Speaker: 
Klaas Brant

DB2 for Linux/Unix/Windows (LUW) is becoming more popular every day. Many IBM customers who run DB2 for z/OS are using DB2 LUW also, or will do so in the next year. For cost saving and optimization reasons many companies, who have both products, have decided that they will combine DBA activities to be done by a single group of DBA’s. People who have been doing DB2 for z/OS for a (very) long time are suddenly facing a “new” DB2. DB2 = DB2 is a simple assumption which is only partly true. So, some things are similar, and other things are completely different. Klaas Brant has been using both products for a very long time and can explain to you were the major differences are and how to avoid some pitfalls in DB2 LUW for DB2 for z/OS DBA’s. The seminar assumes you have a good knowledge of DB2 for z/OS and its components and have no or limited knowledge of DB2 for LUW.

Outline
Architectural comparison
Architectural overview
Subsystem vs. Instance comparison
Access methods
Similar and different terms
Storage Management
How space is allocated
How space is managed
How performance is optimized
Object Comparisons
Databases
Tablespaces
Container
Tables
Indexes
Bufferpools
Administrative Differences
Logging
Backup/Recovery
The differences in optimizer
Monitoring options
Autonomic Computing
Utilities

 

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2024

VODICE -  10th - 13th June 2024