DB2 9.7 for Linux, Unix, and Windows has out-of-the-box support for
Oracle's SQL and PL/SQL dialects. This allows many applications written
against Oracle to execute virtually unchanged against DB2. Whether you
want to switch your custom application or extend your DBMS vendor
support, its now time to break free with DB2!
Join experts from the DB2 labs to learn more about what Oracle compatibility means in
Register for this Chat with the Lab
Presenters: Sal Vella, VP, and Serge Rielau,
Thursday July 16, 2009
11:30 a.m. Eastern / 10:30 a.m. Central / 8:30 a.m. Pacific / 4:30 p.m.
London / 5:30 p.m. Munich
The DB2Night Show Episode #2
We're going to talk about Index Design Best Practices for both DB2 LUW and
Oracle! So far we have one special guest lined up:
Independent Oracle Consultant specializing in Oracle performance
optimization (amongst many other things). We're going to look at Oracle
Index Best Practices and see how they compare to DB2. We're also working
on a special guest from the IBM Toronto Lab to spice up this lively
Are you "Joe the DBA"? Do you have a performance challenge you'd like to
discuss? Contact The DB2Night Show per the instructions found at left.
RESERVE YOUR Studio Audience FREE SEAT:
Thursday, October 1, 2009 at 10am CENTRAL.
We will be broadcasting at your favorite screen resolution. For audio,
VoIP and local country telephone numbers will be available for US, Canada,
European countries, Australia, and New Zealand. You are responsible for your
transportation to our "Studio", popping your own popcorn, and your favorite
Save the date for the third episode:
The DB2Night Show Episode #3
HIGH Availability or CONTINUOUS Availability? Join us as we discuss and
debate HADR, HACMP, and Xkoto Gridscale. Ask questions of the experts.
And find out some configuration settings and best practices to sustain
Show guests will include IBM Toronto and Xkoto experts - TBD.
RESERVE YOUR Studio Audience FREE SEAT:
Thursday, October 15, 2009 at 10am CENTRAL.
Did you miss the first episode? Catch it in re-runs:
Did you miss our Webinar on IBM DB2 LUW Index Design Best Practices and Case Studies? Access a recorded replay at
Watching TV is good!
Educate. Inform. Entertain.
Several years ago, Howard Fosdisk
wrote a whitepaper about the Return on Investment of gettng certified. Since Howard is certified in both Oracle and DB2, he was able to do a price comparison between the two programs. I can no longer find the whitepaper on the internet, so you'll have to take my word for it that the conclusion was that it is much cheaper to get certified in DB2, but the benefits are equal to Oracle.
The IBM DB2 exams
are typically $200 per take in the US and $100 in emerging countries.
Scott Hayes the fabulous host of the DB2Night Show has published the details of the upcoming shows that he has planned.
ONLINE TABLE MOVES with special guest Ergin Babani, IBM Toronto Lab
In this episode, special guest Ergin Babani from the IBM Toronto Lab will share with us information and tips on the new Online Table Move capabilities introduced in DB2 9.7. Be a guest in our virtual studio audience so you can learn how easy it is becoming to move data in DB2. There will be an opportunity to ask questions after Ergin's presentation and demonstration.
RESERVE YOUR Studio Audience FREE SEAT: Friday, April 2, 2010 at 10am CENTRAL.
DB2 AUTONOMICS UPDATES and STMM with special guest Adam Storm, IBM Toronto LabIn this episode, special guest Adam Storm, DB2 Kernel Development, from the IBM Toronto Lab will share with us recent updates to DB2 autonomics in V9.5 and V9.7, plus share updates on STMM and best practices. We will take questions from our virtual studio audience after Adam's presentations.
DB2 LUW Performance Update & Best Practices with special guest Berni Schiefer, Distinguished Engineer, IBM Toronto Lab
In the DB2 LUW Community, Berni Schiefer is a man that doesn't need an introduction - but, just in case you are newer to DB2 LUW (like one of the many Oracle converts), Berni is "the performance guy". He's a Distinguished Engineer who leads the Information Management Performance and Benchmarks team at the IBM Toronto Lab. Berni has been a frequent speaker at IDUG conferences and other venues, and he gives terrific presentations that share DB2 Performance Benchmark results and performance best practices.
As always, if something prevents you from attending one of these sessions live, remember that they are recorded
. Scott just mentioned that the Oracle session was downloaded more that 5000 times! Did you see that one yet?
Scott is also trying to fit Sam Lightstone
into a session either as a secondary guest or for a show of his own to promote is new book: Making it Big in Software
DB2 9.7 brought the biggest infusion of SQL features since DB2 V2.1. In this presentation, learn about features that lead to a ten-fold reduction in enablement costs when Oracle-based applications are enabled for DB2. The virtual tech briefing covers the following:
- Business drivers to move Oracle applications to DB2
- SQL enhancements in DB2 9.7
- Tooling support to enable applications from Oracle to DB2
- PL/SQL support in DB2 9.7
- Library extensions in DB2 9.7
We're down to the wire... only 4 episodes remaining in the premier season of the DB2Night Show.
discusses the REDISTRIBUTE command with Scott Hayes in tomorrow's episode (June 4
, 11:00 am Eastern).
June 11 – IBM Mark Wilding on DB2 in the Cloud – a technical talk – probably Part 1 of 3 part series.
June 18 – Comparing DB2 LUW and Oracle by IBM’s Burt Vialpando
June 25 – Our Season 1 show FINALE – Berni Schiefer returns with DB2 LUW Storage I/O optimization
Much thanks to Scott Hayes for pulling these amazing technical talks together!
PS..... If you've missed any episodes, remember that they were recorded and can be found on the DB2Night Show site
Have you seen Leon's
recent blog entry?
Move over Oprah, DB2NightShow.com is moving up in ratings
My last post about the DB2Night Show was in error... I said that Mark Wilding was the special guest this week... but it's actually Mike Winer! I'm sure Mark will be rescheduled for a future show.
So, what's Mike Winer going to talk about? I was a recent guest at his new cottage, but I'm sure that topic won't come up! Instead, he's talking about DB2 Locking. Mike was at the IDUG Tampa conference and at last week's CCDB2UG, so if you missed those talks, you'll be able to catch up in this special 90 minute webinar with Scott Hayes.
Educate - Inform - Entertain ...
Our "mystery" show has turned into a very special feature "The Keys to Mastering DB2 Locking" with guest Mike Winer, IBM STSM and DB2 Kernel Architect.
Mike gave an awesome presentation at IDUG North America in Tampa on DB2 Locking, updates, 9.7 Current Committed, and much more. So that Mike can deliver his full talk on this topic, we are extending the duration of The DB2Night Show to 90 minutes. We should have time for questions from the Studio Audience at the end.
Again, this is a first - a 90 minute show: 10am - 11:30am CENTRAL, 11am - 12:30pm EASTERN.
Remember, all past shows were recorded, so you can listen to previous shows that you may have missed. Also coming this month are:
The DB2Night Show Episode #22
Comparing DB2 LUW and Oracle with Burt Vialpando
The DB2Night Show Episode #23
"DB2 LUW Storage Optimization Best Practices"
with guests Berni Schiefer and Robin Grosman, IBM
Thanks again to the amazing Scott Hayes
for arranging these informative talks with talented speakers!
Improve performance by 74%, while lowering data costs and downtime by up to 40%
Modern day levels of high-velocity data growth have put increased pressure on today's database management systems to support increasingly complex workloads, applications and service levels to meet business demand.
Attend our upcoming seminar to learn how IBM's integrated server and DB2 software offerings can help you improve application performance by up to 73% while lowering your data management costs by up to 40%.
You'll learn how to reduce the complexity of your current DBMS landscape, increase DBA productivity and improve IT service levels by ensuring near-real time access to critical business data.
Register today by calling Jen Tobin at (617) 431-9722 or completing our quick online registration form.
WHY YOU SHOULD ATTEND:
Whether you’re considering a new information infrastructure or are interested in learning how to meet next generation database workloads, attending this complimentary seminar will enable you to:
- Drastically improve the performance of mission-critical business applications.
- Reduce downtime while scaling dynamically to meet growing business requirements.
- Learn how an IBM-based virtualization strategy can help reduce database server costs with DB2’s reduced compression rates.
- Get an up-close look at IBM's DB2 9.7 release and learn how the Oracle compatibility feature can increase DBA productivity.
- Tailor the agenda to suit your specific needs by selecting from a range of sessions on Oracle, SAP, data warehousing and more!
- Network with like-minded, forward-thinking IT leaders from your local area.
Switching information platforms has never been easier or more cost-effective. Find out how to break free from high data management costs while minimizing IT complexity, reducing energy consumption and improving service levels.
Register today by calling Jen Tobin at (617) 431-9722 or completing our quick online registration form.
DW 2.0 - Architecture for the Next Generation of Data Warehousing
Data Warehousing has been around for 20 years and has become an integral part of the IT infrastructure. In this session Bill Inmon, the "father of data warehousing" will discuss the evolution of DW 2.0 and the future of data warehousing that is technologically possible now, at both an architectural level and technology level. Discover how your organization stacks up as Bill explores the overall architecture requirements and delves into the underlying components to help you determine: what new technology to buy, how to plan extensions to the data warehouse, what can be salvaged from the current system, and how to justify the expense--at the most practical level.
You’ll walk away with a comprehensive overview of how best to implement the necessary technology and tools to enable the new generation of the DW: metadata, temporal data, ETL, unstructured data, and data quality control.
Meeting your Next Generation Database Needs
The automation of database admin tasks and sophisticated workload management capabilities are redefining how easy it is to optimize performance for your database software, while industry leading XML data management and data compression capabilities ideally position DB2 to handle your evolving workloads. When these features are tightly integrated with IBM servers to deliver workload-optimized systems, organizations are realizing benefits such as improving performance by up to 73% and lowering costs by up to 40%. Learn how organizations like yours can realize such benefits too.
POWER7 servers are a new generation of Smarter Systems
The new Power systems feature virtualization without limits, resiliency without downtime, dynamic energy optimization, and management with automation. Learn about the workload optimized features that make these systems the choice for both transaction processing and throughput processing - features that can dramatically reduce your costs and improve service to your end users.
Moving to IBM DB2 has Never Been Easier, Cheaper and Faster
In this session you'll learn about the built-in feature's of IBM DB2 that enable smoother, easier migration from other database platforms. In particular, IBM DB2 9.7 enables you to port applications written for a different database, with minimal or no change to your code. In addition, switching to DB2 can reduce operational costs and increase throughput through innovative technologies packed into the heart of the database engine. Learn how a move to DB2 guarantees these benefits, coupled with DB2's strong tradition of reliability, resiliency, and availability.
Smart Warehousing, Smart Decisions with the IBM Smart Analytics System
The recent surge in data warehouse technologies and appliances has led to a lot of hype surrounding the business intelligence (BI) and analytics space. Find out why IBM is uniquely positioned to deliver the most comprehensive workload optimized solution – one that includes not only an integrated data warehouse on IBM Servers – but also the required BI reporting, data mining and OLAP capabilities expected to make smart decisions. This session will provide an overview of how IBM’s Smart Analytics System can provide your organization with BI capabilities to hit the ground running with scalability to grow and adapt as your analytic requirements change. You'll also hear concrete examples from current customers using the technology.
Optimize your SAP system by significantly reducing the TCO
Architected, integrated and optimized together DB2/SAP on Power is the best combination for your SAP applications. Come and learn why customers including SAP have chosen to run their SAP applications on DB2. Over 100 customers migrated with 100% success to DB2 in the past 6 months, come talk to the thought-leaders as to how you too can benefit from DB2/SAP on Power – you will be able to reduce the memory, storage significantly while still getting superior SAP system performance.
Best Practices: Managing DB2 for Oracle® Applications and beyond
Organizations increasingly depend on business-critical enterprise systems to drive results and meet the challenges of daily operations. The combination of skill availability, increasingly complex technology options, and the business demand for a greater ROI have pushed many IT engineering teams to either design or adopt best practices to support these systems. In this session, we will explore case studies and discuss best practices for managing your Oracle applications on DB2. This session will benefit both those who are managing data on DB2 and those considering DB2 as part of their database portfolio.
Attendance is limited. Reserve your seat today by calling Jen Tobin at (617) 431-9722 or apply online.
If you've considered making the move to DB2, developerWorks has made it easier than ever to find out everything you need to know.
The new DB2 enablement page for DBAs and database developers is loaded with resources -- articles, tutorials, demos, webcasts, and more -- to help you understand the benefits of DB2 for Linux, UNIX, and Windows. Benefits like industry-leading performance, autonomic admin features, and lower costs.
Are you already working with another relational database management system (like, say, Oracle)? Why not find out how easy it is to migrate your applications to DB2 9.7? Plus, new SQL compatibility features in DB2 9.7 (including support for Oracle's SQL and PL/SQL dialects) make it easy to reuse your PL/SQL knowledge.
And for more on all of IBM's data solutions, stop by our Information Management zone here on developerWorks.
And don’t forget the great books that are available for you to make the move to DB2:
Beginning DB2: From Novice to Professional
by Grant Allen
Understanding DB2®: Learning Visually with Examples, 2nd Edition
by Raul F. Chong, Xiaomei Wang, Michael Dang, Dwaine R. Snow
Join Scott Hayes and special guest Burt Vialpando from IBM tomorrow (Friday June 18) on the DB2Night Show.
Burt will provide a side by side comparison of architectures, terminology, file system layouts, directory structures, administration commands, memory architectures, parameters, storage models and so much more.
If you are a DB2 LUW professional, after this session you will be able to understand your Oracle peers (really, it isn't a foreign language). If you are an Oracle professional, you will discover that the DB2 people aren't so strange after all.
Don’t miss this free webinar!
I have two upcoming webinars to tell you about today and hope that you can
make one or both of them!
First, the second season of the DB2Night Show starts this
Friday, August 6, 2010. This kickoff episode is special in
that it is 90 minutes in length and Scott will be joined by my two good
friends Serge Rielau and Dwaine Snow.
Together they will give us updates on all the ways that IBM is making it easy
to choose DB2 LUW. If you are a current user of Oracle or Sybase, you really
don’t want to miss this show.
Season 1 ended up with 23 shows and if you missed them, come and listen to
the replays. I was a guest on one of the shows and had much fun with Scott!
View the upcoming shows and register here: DB2Night Show Website.
Second, the DB2 Database professional bloggers are hosting a
free 60-minute virtual session for our the community. The best part is
... YOU GET TO CHOOSE THE TOPIC! Yes, that's right. This virtual
session will be on a topic of your choice. Are you interested in an overview of
the technical advantages of DB2 over Oracle? Want to know more about DB2
pureScale? Maybe you'd like tips on how to migrate an existing Oracle
application to a DB2 application? Whatever your topic(s) of interest, post a
comment and let me know. If you're new to DB2, this is a great opportunity for
you to become familiar with DB2.
Nominate a topic here: DB2 Database
By the way, this is a good blog to “follow”.
Join Scott Hayes and Klaas Brant on the last show of this season.
The DB2Night Show Episode #36
HIGH AVAILABILTY: Comparing DB2 (pureScale), Oracle (RAC), and SQL Server (Cluster)
Friday, December 17, 2010 11:00 – 12:00 EST
DB2 has some great high availability options like HADR and Pure-Scale. But how about the competition? How does DB2 compare to Oracle and SQL Server? In this episode we will look at the architectures that enable high availability and show you why DB2 Pure-Scale is superior to Oracle RAC and SQL Server Cluster.
Special guest Klaas Brant, IBM DB2 GOLD Consultant & Owner KBCE, returns to our show for a second appearance. You might recall Klaas was on our show earlier this year (Episode #18 on 7 May 2010) talking about the Top 10 DB2 LUW mistakes that people make - an Episode that was extremely popular with viewers. Watch the replays on the DB2Night Show website.
If you'd like to learn about DB2 PureScale and competing technologies, then this show is for you! Also, take a look at a previous blog entry I did where I compiled a collection of DB2 Purescale resources: More on DB2 pureScale.
Personal Tidbit: For those keeping score, my blog views are now over 980,000! Lately I’ve been getting nearly 20,000 new views every week, so there is still a chance that I can get to 1M before the end of the year. Thanks for all your support this year!
Don't miss the next chat with the lab featuring Sal Vella and Burt Vialpando as they discuss the architectural differences between DB2 and Oracle.
Date: Thursday, March 31, 2011 (31.3.2010)
Time: 12:30 AM - 2:00 PM Eastern Time (ET)
11:30 AM Central / 9:30 AM Pacific / 17:30hrs London / 18:30hrs Frankfurt, Paris / India 11 PM
Many database professionals and DBAs often ask how DB2 and Oracle compare architecturally, that is, how they are different and similar at their core. They also ask what are the equivalent concepts, names, commands etc. in the other database system. This free webinar will answer those questions by covering the following topics in detail:
- Server architecture comparison (e.g. instances and database model, process vs. thread)
- Memory architecture comparison (e.g. Oracle SGA & PGA vs. DB2 instance, database and application memory)
- Parameters, environment variables and registry variables
- Database storage model comparison (e.g. table space types and layouts, compression approaches)
- Basic database administration comparison (e.g. terminology, create database, start/stop, dictionary vs. system catalog, performance)
- Compatibility mode for running Oracle applications with DB2
This webcast is intended for database professionals:
- familiar with Oracle and looking to learn more about DB2 (for Linux, Unix and Windows),
- familiar with DB2 and looking to learn more about Oracle
- who work in a heterogeneous environment and looking to expand their DBMS knowledge and career prospects.
Join Sal Vella and Burt Vialpando on Thursday Mar 31, 2011, at 12:30 PM Eastern to learn more.
Register and receive instructions for attending this webcast.
For questions/comments/suggestions: http://www.channeldb2.com/group/db2chatwiththelab
Thanks to Rav Ahuja for providing me with these details.
OK, I thought I had produced a pretty good list of free resources, but of course, as soon as I post, I realize that I’ve forgotten to mention some really key resources. Let me try again and hope that I don’t miss anything else! (Of course if I do… please tell me!!)
PlanetDB2.com – Allow us to filter through all the blogs that are on the web to bring you only the bloggers that talk about our favourite subject: DB2, InfoSphere, Warehouse, and other Information Management technologies.
ChannelDB2.com – The single largest community of people working on DB2 and Information Management products, world-wide. You’ll be able to build your network of professionals who work in your country or who are interested in the same technology as you. The best feature is the incredibly large selection of videos of people presenting about this products. Once in awhile, save your eyes and tune into these videos.
DB2Express-C – Maybe you’ve just heard of DB2 or maybe you use a competitor’s product. No worries… give DB2 a try for free. Find out for yourself how easy it is to learn and how much better it is than the product you may be using.
Information Center – Perhaps I’m biased since I worked for 6 years on the Information Development team that produces product documentation, but I really think you’ll find the completeness and the quality of this information to be outstanding. All of the information is online, for every release, for free, and is updated regularly. The benefit of the content being online is that you can search and easily find the information you need.
developerWorks – You’ll find more articles, blogs, tutorials and other training resources than you could possibly consume in a lifetime! The link I’ve provided is for the DB2 Professional Community, but you’ll be able to find technical information about all IBM software products. Endless :)
MeetDB2 – One of the interesting things you’ll find on developerWorks is this utility that will help you analyze your Oracle database to estimate the level of compatibility with DB2. My link will take you to an article written by Serge Rielau that will help you understand how the utility works, and it provides a link the utility.
Read through my previous blog entries for more free or almost free resources:
Not quite free….
DB2Night Show - DB2 for z/OS
This week’s show took place today… and I missed it! I thought I still had an extra day to promote it. So, if you’re like me and missed the show, you can listen to the replays. Here’s what happened in the past week:
Thursday April 21
The DB2Night Show #50: Put on the Boxing Gloves, DB2 LUW vs Oracle, Part 1
Julian Stuhler from Triton Consulting and Rick Sobiesiak of IBM Canada presented findings from their DB2 LUW versus Oracle Usability study. The study examines the major differences between DB2 9.7 and Oracle 11gR2, and assesses the complexity of each. Very impressive results, which I’ll let you discover by reading the study or watching the replay.
Round 1: Installation
Round 2: Data Compression
Round 3: Index Compression
Round 4: Backup & Recovery
If you want to see the complete study, down load the free Whitepaper: Quantitative Complexity Analysis.
Get the commentary and the replay. In the commentary, you’ll find links to several blog entries that were written in conjunction with this study.
Monday April 25
The DB2Night Show #Z01: The history of DB2 for z/OS
The launch of the DB2 for z/OS version of the DB2Night Show hosted by Klaas Brant. The first show featured special guest Roger Miller who spoke of the history of DB2. Klaas mentions in his wrap up of the show that there were many things mentioned that he wasn’t aware of even though he had been using DB2 since V1.2. Also, this show marks the last visit Roger will make on the DB2Night Show as he will retire in a few weeks. Roger, you’ll be missed!!
Get the commentary and the replay.
Thursday April 28
The DB2Night Show #51: Put on the Boxing Gloves, DB2 LUW vs Oracle, Part 2
Julian Stuhler and Rick Sobiesiak continued presented findings from their DB2 LUW versus Oracle Usability study. Make sure you make it known as to which of the tasks covered in either show you’d like to see demonstrated on a future DB2Night Show.
Round 5: Memory Tuning
Round 6: Data Access Control
Interesting comments & questions that came up during the show:
- Scott recommended that audience members also check out The DB2Night Show #14: Crunching the Numbers and DB2 STMM.
- Question from the audience whether IBM is making DB2 so easy to put DBAs out of business or to give DBAs a chance to improve their golf game.
- Question from the audience: why is Oracle so popular if DB2 is so great?
- Many questions on STMM.
There were so many questions today, but they will be answered in the Replay Blog.
Get the commentary and the replay.
Next week: IDUG.
And, the week after IDUG:
Monday May 9
The DB2Night Show z/OS Edition #02: DB2 for z/OS Now and into the Future
Jeff Josten will share the latest news with DB2 z/OS V10 and offer his insights into what may be coming next in DB2 z/OS: The Future of DB2
Friday May 13
The DB2Night Show Episode #52 - : DB2 for LUW Best Practices: Writing and Tuning Queries for Optimal Performance
John Hornibrook from the IBM Toronto Lab will spend 90 minutes to give his query optimization talk. John is also back for another show taking place on Friday May 20. Since that is so long from now, check out a previous show with John that was ranked one of the best of the first season: Episode 11. DB2 9.7 Optimizer Updates with special guest John Hornibrook from IBM.
As always, a great learning and entertainment opportunity via the DB2 Night Show. Thanks Scott! Good luck in Nashville on the marathon.