TDUG Yıllık Toplantı Programı - 2012

25 Eylül 2012

IBM Türk Binası

Büyükdere Cad. Levent, Istanbul

09:00-09:30                   Kayıt ve Tanışma

09:30-09:45                   Açılış.

Cüneyt Göksu, VBT, IBM Gold Consultant, TDUG Lideri

Arzu Gelgeç, IBM Türkiye, TDUG-IBM Liason

Surekha Parekh, IBM UK, WW Strategist & Market Program Director

09:45-10:45                    

Christopher J. Crone, IBM Distinguished Engineer, DB2 for z/OS Development

DB2 and System z Synergy

10:45-11:45                    

Cüneyt Göksu, VBT,

Practical Recipes for Daily DBA Activities using DB2 9 and 10 for z/OS

12:00-13:00                   Öğle Yemeği arası

13:15-14:15                    

Hüseyin YILMAZ, IBM Türkiye, Senior IT Specialist, Information Management

What's New for DB2 10 for Linux, Unix, Windows

14:15-15:15                    

Christopher J. Crone, IBM Distinguished Engineer, DB2 for z/OS Development

Overview of SQL Enhancements in IBM DB2 9 and 10

15:30                            Soru & Cevap ve Kapanış

Katılım için lütfen isim, soyad ve kurum bilginizi aşağıdaki eposta’ya iletir misiniz.

Cuneyt Goksu / tdug@idug.org

REFERENTIAL INTEGRITY(RI)

DB2 for z/OS açısından RI kullanımı veri kalitesinin, veritabanında güvenli olarak sağlanmasını garanti ediyorsa da, RI her zaman kullanılması desteklenen bir özellik değildir. RI’nin kullanılmasının bazı riskleri vardır.

Availability:
1) Parent (P) Tablo PIT Recovery yapılırsa, Dependent bütün tablolar CHECK Pending’e düşer.
2) Dependent (D) Tablo PIT Recovery yapılırsa tablo CHECK Pending’e düşer.
3) Code Tabloları Parent olarak kabul edilip, sistemdeki bütün tablolardan Foreign Key yaratılırsa ve Code Tablosuna yapılacak bir LOAD REPLACE bütün operasyonel tabloları CHECK PENDING’e düşürür.
4) P ve D, Crash Recovery yapılırsa CHECK Pending oluşmaz.

İlk 3 madde availability riski taşımaktadır. Problem yaşanması durumunda kesinti oluşturur.

Performans:
1) D tablo üzerinde FK için Index tanımlamak gerekir. Bu Indexin cardinality’si çoğunlukla düşük kalır ve Optimizer tarafından performans amaçlı seçilmeyebilir. Sadece P’den yapılan CASCADE DELETE’lerde ve JOIN işlemlerinde Dependent kayıtları bulmak için kullanılır. Dolayısı ile Uygulama SQL’lerin kullanma ihtimalinin az oldugu bir index her FK için tanımlanır. Bu da D tablolarının DELETE/INSERT maaliyetini arttırır.
2) D tabloya bir UOW’de aynı FK için yapılacak birden fazla INSERT olursa, DB2 her bir INSERT’de P tabloya gidip bakar. Eger DB2-RI değil, APP-RI kullanılırsa uygulama mantığı doğru yazıldıgı taktirde P tabloya tek bir lookup ile bu işe gerek kalmaz.
3) Eger Partitioned TS’de FK, DPSI (Data Partitioned Secondary Index) olarak tanımlanırsa, P’den yapılacak DELETE, bütün partition’ları tarar. Application ile yapılırsa WHERE koşulu ile atlanacak bu durum, DB2-RI ile kaçınılmaz olabilir.

DB2 for z/OS Architecture in Nutshell

YTU ve ODTU'de Bilgisayar Muh. Ogrencileri icin hazirladigim sunum
Aşağıdaki linkten indirebilirsiniz.

http://www.slideshare.net/CuneytGoksu/db2-for-zos-architecture-in-nutshell

DB2 for z/OS Tracks in IDUG EMEA 2011

DB2 for z/OS Sessions provides you the best technical content about IBM’s flagship database. IBM Distinguished Engineers talk about product updates, V10 Migration experiences and enhancements. Industry experts and Leading Gold Consultants provides you the best practices and tips&tricks from the ground. Top User speakers share their experiences with DB2 for z/OS Migration and performance tuning efforts. Top vendor experts talk about experiences and new functions. What you will learn from those sessions will provide the maximum ROI to your skills and to your enterprise.

For instance;

Terry Purcell's session called "What's new from the optimizer in DB2 10 for z/OS?" will have the latest query optimization enhancements for DB2 10 for z/OS, the world’s most respected cost based optimizer. And as delivery of DB2 10 draws closer, the plan solidifies, and beta customer and internal measurement feedback is more readily available. This presentation will share the insight uncovered in the early usage, provide the motivation for each enhancement, and highlight that actual enhancements


John Campbell's "DB2 10 for z/OS Planning and Very Early Migration Experience" will introduce and discuss very early experiences and lessons to be learned with DB2 10 for z/OS. It will provide quick hits on preparing for and executing the migration, performance expectations and opportunities, virtual storage constraint relief, some instrumentation changes, use of 1MB real storage frame size, use of hash access, value of rebind, etc.


Bryan Paulsen with "DB2 10 for z/OS - John Deere's Beta Experience" will talk about John Deere's participation to the IBM Beta program for DB2 10 for z/OS. This presentation will introduce you to some of the new features available in DB2 10 that we tested at John Deere. You will gain a general understanding of these features along with some items of interest we found while testing. I will also introduce you to some of the equipment John Deere makes during the course of the presentation.


And Last but not the least Frank Petersen with "Experience DB2 10 experiences" will go through the experiences from Bankdata/JN data concerning going to DB2 10. Bankdata took part in the beta program for DB2 10 and there will be some brief information about this process. In the spring 2011 the Bankdata systems are planned to go through a 6 months process to be upgraded to DB2 10. Frank will give experiences from this process, both from a performance related view as from talking about problems met during the way. He will try to make the presentation as up to date as possible as the process is continuing right up to the conference.

This is just a subset of conference grid.

And there some more

1) IBM Pre-Certification & Migration Planning Workshop classes
http://bit.ly/IDUGEMEAMP

2)Registration for DB2 10 Migration Planning Workshop at IDUG
http://bit.ly/MPWIDUG

3) Registration for IDUG EMEA 2011 Conference
http://bit.ly/IDUGEMEA

Dünyayı değiştirecek dört teknolojik eğilim

IBM ArGE'sinden sorumlu VP John Kelly'nin yaptığı bir sunum geleceği belirleyecek 4 teknolojik eğilim hakkında sinyaller veriyor

1.Nano Sistemler: Bu sistemler kısaca kablolu iletişim değil ışıkla iletişim üzerine olacak. Böylece çok daha az enerji ile çok yüksek iletişim performansları sağlanabilecek. Nano sistemlere geçildiğinde hesaplama hızlarında 1000 kat artışlar bekleniyor.

2.Exascale Sistemler: Günümüzde en hızlı sistemler petaflop seviyesinde. IBM Ar&GE, Blue Waters olarak isimlendirilen, 10 petaflop'luk bir sistem hazırladı ve gelecek 10 yıl içinde exaflop tasarlama peşinde. Petflop'tan exaflop'a geçiş demek performansta 1000 kat artış demek.

3.Çok büyük ve Çok hızlı data: 2020 yılında, dünyada 50Milyar birbiri ile bağlı cihaz olması bekleniyor. Bu yeni dünyada veri üretim hızı makina hızı ile eşdeğer. Bunun üstesinden gelmek için, yüzlerce gigabyte'ı saniyeler içinde işleyen ve microsaniye bazında karar veren sistemlere ihtiyaç var ve bu konuda ki geliştirmeler devam ediyor.

4.Kavramsal hesaplamalar: Dünyadaki neredeyse bütün bilgi sayısallaşmış durumda. Bu yüzden yaratılan sistemlerin bilgiyi işleme metodları daha önce hiç olmadığı kadar farklı. Bunun en güzel örneği Watson. http://www-03.ibm.com/innovation/us/watson/index.html

Revolutionary Technology for Data Warehouse and Business Intelligence Workloads

IBM Smart Analytics Optimizer: Revolutionary Technology for Data Warehouse and Business Intelligence Workloads by Patric Becker and Cuneyt Goksu. The IBM Smart Analytics Optimizer lets businesses integrate Business Intelligence (BI) into their environment.

http://www.mainframezone.com/it-management/ibm-smart-analytics-optimizer-revolutionary-technology-for-data-warehouse

The IBM User Experience team is looking for volunteers

The IBM User Experience team is looking for volunteers to give us feedback on your usage of the DB2 for z/OS Quick Reference, DB2 for z/OS Diagnostic Quick Reference, and DB2 for z/OS Installation Guide. The feedback you provide can play an important role in improving our documentation.

If you are interested, please complete the survey at this URL:
https://www.ibm.com/survey/oid/wsb.dll/s/ag2a1

Thanks in advance for your help!

Announcing DB2 10 for z/OS Beta

http://www-01.ibm.com/software/data/db2/zos/testimonials.html

Out-of-the-box Savings by improving operational efficiencies

IBM continues to invest in new features to support your efforts to make your business more efficient, and DB2 10 delivers great value in this area. Compared to previous DB2 versions, some customers can achieve a 5% to 10% out-of-the-box CPU savings for traditional workloads and up to 20% out-of-the-box CPU savings for non-traditional workloads. Productivity improvements in DB2 10 for database and system administrators can drive additional operational efficiencies and cost savings. Synergy with other IBM System z platform components reduces CPU use by leveraging the latest processor improvements, larger amounts of memory, solid-state disk and z/OS enhancements.

Unsurpassed DB2 for z/OS and System z Resiliency for business critical information

Business resiliency is a key component of the value proposition of DB2 for z/OS and the System z platform, supporting your efforts to keep your business running even when things go wrong or you need to make changes. DB2 10 innovations drive new value in resiliency through scalability improvements and fewer outages - planned or unplanned. Scalability delivers the ability to handle up to 20,000 concurrent active users on a single DB2 subsystem than in previous versions. Schema evolution or data definition on demand as well as query performance manageability enhancements support improved availability.

Rapid Application and Warehouse Deployment for business growth

Staying competitive in today's global economy is tougher than ever, requiring agility, adaptability and responsiveness. SQL and pureXML enhancements in DB2 10 help extend usability, improve performance and ease application portability to DB2 for z/OS, supporting your efforts to create a sustainable competitive advantage.

Enhanced query and reporting facilities

Query Management Facility (QMF) 10 allows you to do more with your existing QMF investment than ever before. Built-in data visualizations and graphical page-based reports extend QMF usage from the traditional technical user to a broader community of business end users. QMF's new metadata layer simplifies the underlying data model, empowering non-technical users with self-service reporting and extends access to DB2 for z/OS across the enterprise, helping to further increase the return on your investment.

Migration to DB2 10 is provided from DB2 9 for z/OS (New Function Mode) and from DB2 for z/OS V8 (New Function Mode) subsystems. Customers not yet running V8 should plan to migrate to DB2 for z/OS V8 as preparation for a migration to DB2 10. Customers who plan to migrate to DB2 9 in year 2010 or 2011 should continue with their migration.