5 Dec 2010

The Marvellous DB2 10


The Lyrics of DB2 10 Song by Roger Miller

When I was just a wee little lad, full of health and then
IBM came to me one day and gave me DB2 10.
A wonder to behold it was, with many features bright.
The moment I laid eyes on it, it became my heart’s delight.

It went zIIP CPU and faster too and helped me time to tell.
It came out of the box, saved CPU and work, and did it very well.

It first marched left and then marched right, and then marched under a chair.
And when I looked around again, it wasn’t even there.
I started to cry, but my DBA laughed, for she knew that I would find
When I turned around again, my DB2 10 was chugging up behind.

It went zIIP CPU and faster too and helped me time to tell.
It came out of the box, saved CPU and work, and did it very well.

Well, the years have gone by too quickly, it seems, and I’m mentoring new women and men.
And yesterday I gave to them the marvellous DB2 10.
Their eyes nearly popped right out of their heads.
And they gave a squeal of glee.
Not one of us know just what it is, but they love it, just like me.

It still goes zIIP CPU and faster too and helps us time to tell.
It came out of the box, saved CPU and work, and did it very well.

24 Nov 2010

IBM, Information on Demand (IOD) Conference, Las Vegas, 2010




IBM’in Bilgi Teknolojileri (BT) konusundaki yıllık en büyük küresel etkinliği 24-28 Ekim 2010’da Las Vegas, ABD’de yapıldı. En son satın almalarla artık birer IBM şirketi olan Cognos ve SPSS kullanıcılarının da katılımıyla ki, bu markalardan katılan kişi sayısı yaklaşık 3000, toplam 10,000 kişi vardı bu konferansda! 160’ı Cognos ve SPSS olan, toplam 600 Teknik sunum, 110 sektörel ve liderlik sunumu yapıldı. 128 farklı Hands-On-Lab vardı bütün katılımcılara açık. 300’den fazla IBM müşterisi kendi sunumlarını yaptılar. Fuar alanında IBM’in BT çözümleri dışında onlarca ISV ve İş Ortağı’da tanıtımlarını gerçekleştirdi. Konferans süresince bütün katılımcılar istedikleri herhangi 3 konu da (Bilgi Teknolojileri, SPSS, Cognos, Kurumsal İçerik Yönetimi) ücretsiz sertifika sınavlarına katıldılar.

Bu tip konferansların şüphesiz en dikkat çekici yanlarından birisi de, yeni ürünlerin veya mevcut ürünlerin üst versiyonlarının duyurulmasıdır. Bu açıdan bakıldığında konferans çok zengindi. Birçok yeni duyurunun yanında ürün penceresinden bakınca, bence öne çıkan iki duyuru çok önemliydi bütün konferans süresince; Cognos 10 ve DB2 10 for z/OS.

Kısa bir süre önce IBM’in Bilgi Teknolojileri Strateji’si kapsamında satın alınan ve IBM ailesine katılan Cognos, İş Analizi ve İş Zekası alanlarında kendini kanıtlamış bir ürün. Cognos 10 sürümü, bir iş zekası ürününden beklenen geleneksel fonksiyonların yanında, planlama, senaryo modelleme, anlık izleme (real-time monitoring) ve ileriye dönük analitik analiz (predictive analytics) imkanları sunuyor. Cognos 10 ile kurumlar, “daha akıllı” kararlar alabilmenin ve buna bağlı olarak daha hızlı ve doğru sonuçlar üretebilmenin yollarını bulup, yaptıkları işe dair fırsatları, eğilimleri hızlı farkedip, daha zayıf işleyen taraflarını da tanıma şansına sahip oluyorlar.

DB2 10 for z/OS, IBM’in çeyrek asırlık, amiral gemisi veritabanı yazılımının IOD’de duyurusu yapılan son sürümüydü. Ürünün ilk versiyonundan beri bakıldığında, beta programına en fazla katıımcı bu sürümde gerçekleşti. İlk göze çarpan özellik, 2010 içinde duyurulan yeni nesil hibrid zEnterprise donanımı ile entegre çalışan bu sürümün, yeni donanım ve işletim sisteminin özelliklerinden dolayı %5-10 arasında out-of-box CPU kazancı sağlamasıydı. Yani sadece ürün sürümünü yükselterek, herhangi bir uygulama ve veritabanı değişikliği yapmadan bu kazanımı elde etmek mümkün. DB2 10 for z/OS’in SQL, Mimari, Stored Procedure, Utility alanlarında ki yenilikleri uygulanmaya başlandığında %20-25 CPU kazançlarına kadar çıkılabiliyor. Teknoloji’nin ve beraberinde gelen “teknolojik tüketim ve üretimin” aşırı hızlı ilerlemesi, üretilen veri miktarını da, eş zamanlı kullanıcı sayılarını da inanılmaz arttırdı. DB2 10 for z/OS zaten yıllardır bu alanda sahip olduğu liderliğini daha da ileriye taşıyor; Tek bir LPAR’da eş zamanlı çalışabilen 20,000 kullanıcı, 64-Bit mimari’den dolayı neredeyse sınırsız Sanal Bellek (Virtual Storage), Temporal Table (Veritabanı dünyasında ilk), 128 TB tablo büyüklükleri, PureXML desteği bunlardan sadece bazıları.

Master Data Management, İçerik Yönetimi, bütün platformlar için (Intel, Midrange, Mainframe) genel duyurusu yapılan akıllı sistemler, öne çıkan diğer önemli teknolojik gelişmeler ve duyurular oldu.

IOD, Cognos 10 ve DB2 10 for z/OS konusunda daha detaylı bilgiye aşağıdaki bağlantılardan ulaşabilirsiniz.

http://www-01.ibm.com/software/data/2010-conference/

www-01.ibm.com/software/data/db2/zos/

www-01.ibm.com/software/analytics/cognos/cognos10/

29 Sep 2010

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

27 Feb 2010

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!

9 Feb 2010

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.

2 Feb 2010

Countering Larry Ellison's claims about DB2 - Q&A





ORACLE: "We blew the doors off of IBM. We crushed them." [Referring to
TPC-C benchmark results] In a machine that took up less than 10% the
floor space, of IBM's record setting computer. We ran faster, we ran a
lot faster: using a tiny fraction of the floor space, a tiny fraction of
the power, cost less."


IBM: Until late last year, DB2 enjoyed a massive 49% lead over Oracle.
With Oracle's most recent result, they have taken the lead by 25% (and
by the way, they used more than six times as many CPU cores to do it).
We are confident that DB2 will retain its lead this year. Also,
remember that DB2 has dominated TPC-C performance leadership over the
past seven years, with almost twice as many days of leadership as Oracle
Database.
Regarding the claim of using less space and power, this is a result of
Oracle using flash memory and comparing it with an IBM benchmark using
conventional disk technology. If Oracle compared its benchmark to an IBM
system using flash memory, they could not make these outlandish claims.
For a more detailed look at Oracle's outlandish claims, see
http://www.ibm.com/systems/migratetoibm/getthefacts/powersystem.html

ORACLE: "SAP chooses the Oracle Database to run under SAP in almost all
their large accounts."


IBM: SAP themselves favor DB2 for their own systems. They operate more
than a thousand SAP systems, and all of those systems run on DB2
(www.youtube.com/watch?v=DZNXbqorQU0). Not only that, but the past
couple of years has seen literally hundreds of SAP clients ripping out
Oracle Database and replacing it with DB2 (
http://www.ibm.com/press/us/en/pressrelease/28403.wss). They have been
migrating off Oracle Database and on to DB2 to lower costs, improve
performance, and ease administration.

ORACLE: "We have the best Unix in the world"


IBM: AIX has demonstrated performance leadership with 7 of top 10 TPC-C
performance results (
http://www.tpc.org/tpcc/results/tpcc_perf_results.asp). Also, the ITIC
2009 Global Server Hardware & Server OS Reliability Survey Results
reveal that AIX is 2.3 more reliable than the closest UNIX competitor.

ORACLE: "The Oracle Database scales out, IBM DB2 for Unix does not. Let
me see, how many servers can IBM put together for an OLTP application?
Let's see, how many can they group together? Um, one. They can have up
to one server attacking really big jobs. When they need more capacity,
they make that server bigger. And then they take the old server out,
put a bigger one in. And when you've got the biggest server, that's it.
That's all the can do for OLTP."


ORACLE: "They can't scale out, they can't do cloud, they can't do
clusters, the can't do any of this."


IBM: This statement has been false since the inception of DB2. DB2
Parallel Edition was brought to market in 1995, along with the
capability to scale to a system of over a 100 Unix servers. DB2 for LUW
scalability is proven in many of the world's largest OLTP environments.
In fact, IBM believes that DB2 for LUW powers one of the largest OLTP
system in the world, if not the largest (
http://www.ibm.com/press/us/en/pressrelease/19698.wss). As regards
support for clusters, DB2 pureScale was introduced to market in 2009.
For a cluster of 64 nodes, DB2 pureScale maintains 95% efficiency. At
128 nodes, DB2 pureScale maintains 84% efficiency. This is important
because if you are growing a cluster to handle bigger workloads, you
want your hardware to be doing productive work, not handling system
overhead. On the other hand, Oracle RAC [Real Application Clusters]
has a 100 server limit. And to my knowledge, Oracle has yet to publish
any efficiency numbers.

ORACLE: "You would've thought, years ago, that IBM would have come out
with a database machine. I mean its so obvious, they've got hardware,
they've got DB2. Why in the world didn't they come out with a database
machine? It's fascinating."


IBM: Remember that IMS and DB2 have made System z a database machine for
more than 40 years. In recent years, IBM has also brought “database
machines” to market. In 2005, IBM introduced an integrated offering for
data warehousing that has evolved into the IBM Smart Analytic System. In
2009, IBM also introduced DB2 pureScale, an integrated hardware/software
stack for OLTP.

ORACLE: "IBM doesn't have the same assets, and that's a big problem for
them. They don't have Java, they don't have the Oracle Database. What
they've got is a problem."


IBM: He's right. IBM does not have the same assets as Oracle. We have
more. Oracle does not have System z, the world's top performing, most
reliable and secure server; does not have business consulting arm such
as 4,000 business analytics consultants with industry specific expertise
and IBM Research - a leader in developing patents for the 17th year in a
row.

ORACLE: "They're so far behind, I don't think they have any chance at
all. I'm serious. I mean they've been working on this DB2 thing for I
don't know how long, and they still can have up to one. I would say in
database, they're a decade or so behind us. I'm serious. "


IBM: IBM has led the industry in developing patents for the last 17
years. In 2009, IBM produced 4914 patents while Oracle did not even
place in the top 50 patent leaders. A search of the US Patent office
database reveals 1588 patents with "database" in the patent description
while Oracle produced only 184 patents. (
http://www.ificlaims.com/IFI%202009%20patents%20011210%20final.htm)

ORACLE: "They are not competitive in the database business, except on
the mainframe. The IBM DB2 product on mainframe is a good product. In
fact the two best databases on the planet are IBM on mainframes and
Oracle. The trouble is that Oracle runs on modern computer systems and
IBM on mainframes runs on mainframes.


IBM: Larry is on record saying, "Our vision for 2010 is the same as
IBM's in the 1960." IBM has added 50 years of experience in hardware
software and services since then. Oracle is giving IBM the sincerest
form of flattery by attempting to imitate IBM.