Thanks to an amazing team of authors led by Raul Chong, people of the world have high-quality ebooks available to them to learn about DB2 and related products. The authors who have worked on these books are experts in their area and they have volunteered to share their expertise with you for no financial gain to themselves.
The authors can be found around the world, so as a result, you’ll see that many of the titles have already or will one day be translated to another language. We at IBM want to make sure that everyone in the world is able to benefit from the knowledge that is being shared.
Seven books are already completed and at this time are only available in electronic format from the sites linked below.
Learn the basics of relational database theory and other information models. This book discusses database logical and physical design, and introduces you to the SQL language. Practice with hands-on exercises!
Adobe® Flex® is the technology of the future; it takes you to the next level of Web application development by providing a free open source framework to develop Rich Internet Applications (RIAs). Using the Flex framework, you can build software that can be used in combination with other server side technologies such as PHP, J2EE, ColdFusion, .NET, and so on. Learn how to use it and develop applications in conjunction with DB2 Express-C, the no-charge edition of DB2; or IBM Data Studio, a free eclipse-based IDE that can help you develop data Web services in minutes.
This book introduces you to DB2® application development using DB2 Express-C. Learn about DB2 stored procedures, functions and Data Web services using SQL and XQuery. Learn how to work with DB2 and JavaTM, C/C++, .NET, PHP, Ruby on Rails, Perl, and more!
Raul F. Chong, Xiqiang Ji, Priyanka Joshi, Vineet Mishra, Min Wei Yao
IBM Data Studio is an Eclipse-based tool that is the replacement of the DB2® Control Center and other tools for DB2. In conjunction with DB2 Express-C, the no-charge edition of DB2, Data Studio is ideal for DBAs, developers, students, ISVs, or consultants because it's easy and free to use. You can extend Data Studio with additional robust management and development capabilities from IBM to help accelerate solution delivery, optimize performance, protect data privacy, manage data growth, and more.
Debra Eaton, Vitor Rodrigues, Manoj K. Sardana, Michael Schenker, Kathryn Zeidenstein & Raul F. Chong
Open source software development is a community-driven methodology to develop products, from the design and development stages to distribution. Developers across differents part of the world are passionate about their collaboration, and several successful projects including Firefox, Moodle, and Drupal are widely used today. Moreover, many companies are using open source software as the foundation to build their business models. This book gets you started into the fascinating world of open source software development. Using the exercises and case studies provided, you will get good hands-on experience to contribute to and start open source projects.
Rachna Kapur, Mario Briggs, Pedro Carvalho, Ulisses Costa, Tapas Saha, Raul F. Chong, Peter Kohlmann
WebSphere Application Server Community Edition (Community Edition for short) is part of the IBM WebSphere Application Server family. Community Edition is the free edition built on top of Apache Geronimo. Learn how to use Community Edition to develop Java EE applications in conjunction with Eclipse and DB2 Express-C, the no-charge edition of DB2.
Jiang Lin Quan, Dai Xuan, Wang Lei, Juliano Marcos Martins, Chi Run Hua, Xia Ming, Tang Ying, Raul F. Chong
Are you interested in checking out some new books in electronic form? Safari Books Online is a great electronic book engine and right now, you can receive a free 15-day trial. With Safari Books Online, you can search for a particular keyword, read the entire book cover to cover, or simply ensure that this is the book you need before you buy the printed version. Hurry! This offer ends the end of June, 2009!
are all looking for ways to be green these days, and for opportunities
to save money–without sacrificing our ability to keep our work skills
sharp and current. Thankfully, with Safari Books Online you can be
green and spend less, with searchable access to over 7,600 books,
certification guides and videos online, all for less than a penny each!
Safari Books Online
is an on-demand digital library providing subscription-based access to
thousands of the best technology, creative and business titles from top
publishers like IBM Press, O'Reilly Media, Addison-Wesley, Apress,
Manning and more. With searchable online access from your computer or
mobile device, Safari Books Online makes sure you have the right
information when and where you need it.
Be more efficient and get more done—for less money—with Safari Books Online:
Quickly search over 7,600 books, videos, and certification guides to find the information you need.
New! Search and access mobile-friendly books directly from cell phones and mobile devices.
Watch thousands of hours of expert instructional videos.
Read pre-publication manuscripts and interact with the authors.
Download book chapters or an entire book (PDF) to print or read on the go.
Copy and paste code directly from leading technical books.
Save up to 35% off the price of print books.
*Offer ends June 30, 2009. Available to new subscribers only. Copyright 2009 Safari Books Online. All rights reserved.
All fields are required.
Please verify the following fields have the correct information:
What’s the book about? Briefly, in the word of Arvind Krishna, General Manager at IBM:
IBM has assembled a comprehensive approach to Information Governance that delivers the industry’s strongest portfolio of products, services, and best practices to address every organization’s needs. This book provides a practical set of detailed steps and sub-steps to implement an Information Governance program, as well as the associated automation provided by IBM Software.
Many of my blog entries had their origins in a question posed to me. Earlier this week someone asked me for some free resources that can be used to stay on the cutting edge of all DB2 changes. I went through recent blog entries and without much effort, I was able to come up with 10 different types of free stuff. Check it out:
Keeping your skills sharp are extremely important and getting certified can certainly help you do that. But, we need to watch the amount of money we spend on everything these days. Good news: IBM’s certification program offers ways to help you keep the costs down while keeping your skills up.
Here are some ideas:
Take It Again is a voucher program
This promotion has been offered in the past and will happen again this year. The details on this year’s promotion are not on the web yet, but I’ve been told that they’ll be there soon. Here’s how the program works: With Take It Again you may purchase specially priced vouchers so that in the event you do not pass an exam on your first attempt, you may quickly and easily retake the same exam for no additional costs. Learn more about Take it Again!
Free or discounted exams at conferences
Conference fees and travel can be quite expensive, so to help, IBM quite often offers conference attendees a chance to take 3 exams free while at the conference and perhaps half price for further exams. Exam fees are normally $200 a take, so this can be an immediate $600 savings to you if you take the exams. Add this justification to your conference request and maybe you’ll be approved to attend the conference of your choice. Find out what conference have free or discounted exams.
Free Assessment Tests
Typically before a conference, the Certification team waives the $10 fee for the assessment exam in the 3 weeks prior to the conference. We want you to pass your exam and to help you do that, you are given tools to help you increase your skills before attempting a free exam at the conference. For the conferences that offer this program, you should be emailed a promotion code after you’ve registered for the event.
For less expensive study materials, check out my previous entries about electronic books, tutorials, product documentation, Express-C versions of products, free webinars, and WBTs:
started my career at the Toronto Lab writing DB2 product documentation.
I learned a lot, met many great people, and created my career. One of
the things I learned during my 6 years writing is that there is much
work put into this content. Planning, writing, discussing, reviewing,
revising, translating, publishing, and more. Bottom line: there is
quality in the product docs! Another
thing about the product docs is that they cover every area of the
product. People are always asking me how they should prepare to pass
the IBM Certification exams, and one of the valid options is to read the
might have sounded like an impossible task until now. Amyris Rada, a
very creative member of the DB2 product documentation team decided to
build a book based on the exam objectives... using only... you guessed
it, content from the documentation. And here are the results:
They are rather large, but they should provide you all what you need to know to pass the exam. So, what’s different from the other study resources? My favourite study materials for the DB2 LUW area are the series of study guides produced by Roger Sanders.
Harness the Power of Big Data - The IBM Big Data Platform
by Paul Zikopoulos, Dirk deRoos, David Corrigan, Tom
Deutsch, Krishnan Parasuraman, James Giles
Information about book:
Big Data represents a new era of computing – an inflection point of
opportunity where data in any format may be explored and utilized for
breakthrough insights - whether that data is in-place, in-motion, or at-rest.
IBM is uniquely positioned to help clients navigate this transformation. This
book reveals how IBM is leveraging open source Big Data technologies, infused
with deep IBM innovation from over 6 billion dollars in analytics acquisitions,
that manifest in a platform capable of 'changing the game'.
The four defining characteristics of Big Data – volume, variety,
velocity, and veracity – are discussed. You’ll understand how IBM is fully
committed to Hadoop and integrating it into the enterprise. Hear about how
organizations are taking inventories of their existing Big Data assets, with
search capabilities that helps organizations put their hands around what they
already know, and extending their reach into new data territories for
unprecedented model accuracy and discovery.
In this book you will also learn not just about the technologies that make up
the IBM Big Data platform, but when to leverage its purpose built engines for
analytics on data in-motion and data at-rest. And you’ll gain an understanding
of how and when to govern big data, and how IBM’s industry-leading InfoSphere
integration and governance portfolio helps you understand, govern, and
effectively utilize big data. Industry use cases are also included in this
An excerpt of this book is available and can be found: The
Big Data Hub. Also see the Big Data Hub for blog entries, videos, and other
resources that will help you on your journey in the Big Data world.
If you are attending the IBM
Information on Demand Conference, get a free printed copy of this book at the Information Desk at the big data booth #622 in the Expo. Bring your book to get signed by the authors at the IOD bookstore Tuesday October 23, 9:30 – 10:30.
After the conference is over, a free e-version of the book will be available
for you to download. Follow my blog to ensure that you are one of the first to
know where you can download the book.
Other sessions by these authors:
3818A Top Enterprise Big Data Use Cases - South Pacific B; Mon, Oct 22,
2012; 2:15 PM - 3:15 PM
3920B Ask the Experts: How Can A Big Data Platform Help Me? - Tradewinds A;
Tue, Oct 23, 2012; 1:45 PM - 2:45 PM
3920C Ask the Experts: How Can A Big Data Platform Help Me? - Tradewinds A;
Wed, Oct 24, 2012; 3:45 PM - 4:45 PM
2017B How to Get Started with Your First Big Data Project - South Pacific F;
Mon, Oct 22, 2012; 3:45 PM - 5:00 PM
3618A Big Data Reference Architectures - South Pacific A; Tue, Oct 23, 2012;
10:00 AM - 11:00 AM
3802A Customer Insight and the Customer Experience: New Capabilities with
Big Data and Analytics - Palm A; Tue, Oct 23, 2012; 11:15 AM - 12:15 PM
1660B Big Data Governance: An Emerging Imperative - South Pacific H; Tue,
Oct 23, 2012; 4:30 PM - 5:45 PM
3822A How to Build an Exploratory Big Data Analytics Capability for the
Enterprise - South Pacific B; Wed, Oct 24, 2012; 5:00 PM - 6:00 PM
2017C How to Get Started with Your First Big Data Project - South Pacific B;
Thu, Oct 25, 2012; 8:15 AM - 9:30 AM
4000A Trusted Information - The Foundation for Efficient Operations and
Smarter Analytics - Jasmine F; Sun, Oct 21, 2012; 2:15 PM - 3:15 PM
2309A InfoSphere Information Integration and Governance Track Keynote:
Future Directions for InfoSphere - South Pacific J; Mon, Oct 22, 2012; 10:15 AM
- 11:15 AM
3524A Real-Time Analytics on Extreme Data: Optimization of a Bayesian
Algorithm Within InfoSphere Streams - South Pacific B; Tue, Oct 23, 2012; 1:45
PM - 2:45 PM
2092A Using Big Data Technology to Revolutionize Cyber Threat Detection -
South Pacific F; Wed, Oct 24, 2012; 5:00 PM - 6:00 PM
Time: 12:30-2:00 PM Eastern / 11:30 AM Central / 9:30 AM Pacific / 17:30hrs London / 18:30hrs Frankfurt, Paris / India 11 PM
The availability and integrity of data is critical to the business enterprise. When a problem occurs and your data is compromised or unavailable, it is paramount to be able to recover from such an 'outage' as quickly as possible. Equally important, is the ability to recover efficiently by quickly identifying recovery assets and minimizing the recovery scope, required resources and effort. This session will explore in detail the Advanced Recovery Solutions for DB2 LUW. The solutions are comprised of the Recovery Expert, Merge Backup and High Performance Unload tools. The Advanced Recovery Solutions for DB2 LUW provide unique capabilities for changed data analysis, elimination of physical or logical data errors and maximizing data availability. We will examine in detail the features these solutions present and demonstrate, through realistic user scenarios, the business value that can be gained by complementing and extending your data management and recovery strategies with these tools.
Presentation slides will be available for download from ibm.com/db2/labchats shortly before the webcast starts.
DB2 Chat with the Lab is a free webinar series from the IBM labs.
The chat is recorded and available for replay. Here are some previous chats you may be interested in:
Flashbook: Big Data Analytics by Dr. Arvind Sathi About the Book: Big
Data Analytics is a popular topic. While everyone has heard stories
of new Silicon Valley valuation bubbles and critical shortage of data
scientists, there are equal number of concerns – Will it take away my
current organization or investment? How do I integrate my Data Warehouse
and Business Intelligence with Big Data? How do I get started, so I can
show some results? What are the skills required? What happens to data
governance? Unlike many other Big Data Analytics blogs and books, this
book presents a practitioner’s viewpoint. It identifies the demand for
Big Data Analytics, its engineering components and what happens on the
production floor. In doing so, it respects the large investments in
Data Warehouse and Business Intelligence and shows both evolutionary and
revolutionary ways of moving forward to the new brave world of Big
book discusses three perspectives on Big Data Analytics. First, why is
Big Data Analytics becoming so important and what can we do with it.
It presents major trends behind the rise of Big Data and shows typical
use cases tackled by Big Data Analytics – where leading organizations
are already seeing major benefits in using Big Data Analytics. Second,
it lists major components of Big Data Analytics - Unstructured Data
Analytics, Massively Parallel Processing, Adaptive Real-time and
Predictive Modeling, Data Privacy Management, Data Visualization, and
Ontologies. It shows how these components work together to provide an
integrated engine that can combine Big Data with traditional Data
Warehouse and Business Intelligence to provide an overall solution.
Third, it provides a glimpse at implementation concerns and how they
must be tackled. How do we combine various components, which are running
at different velocities and volumes? How do we get structured
information out of unstructured data and combine with other structured
data? How do we provide governance across this data, when the
originating data may have varying quality or privacy constraints? How
do we embark on an implementation road map in a systematic way to show
results as we go and build skill level and momentum for Big Data
Analytics in our organization?
Monday October 22, 4:00 p.m.–5:00 p.m. IOD Bookstore, Bayside Foyer; Session # 4243A in Smart Site.
the conference is over, a free e-version of the book will be available
for you to download. Follow my blog to ensure that you are one of the
first to know where you can download the book. Also attend this session by the author of this book:
Session # 3645A - Smarter Operations at Verizon - A Case Study - Tue, Oct 23, 2012; 3:00 PM - 4:00 PM - South Seas J
Session # 1813A - Extreme Targeted Marketing: Micro Segmentation for Utilities and Cross-Industry Applications; Tue, Oct 23, 2012; 4:30 PM - 5:45 PM - South Pacific A
Join this IBM developerWorks Live! virtual technical briefing and
learn about Integrated Data Management solutions from IBM.
Better performance translates to greater revenue, greater customer
satisfaction, and greater ability to meet SLAs. Tired of the finger pointing
among staff when performance is an issue? Find out how you can create exception
monitoring metrics, track and measure performance indicators, and quickly
diagnose performance problems when they arise. Use IBM DB2 Performance Expert
and Extended Insight Feature to make the process easier and more efficient.
Flashbook: IBM DB2: The Past, Present and Future: 30 Years of Superior Innovation
by Surekha Parekh, Terry Purcell, John Campbell, Ruiping Li and Don Haderle About the book: Top
DB2 experts John Campbell and Terry Purcell have contributed to this
book, but as a special treat, we also managed to have Don Haderle - "The
FATHER of DB2" contribute to the book. This book is not only full of
RICH, TECHNICAL content but is will also be a "keepsake" for DB2 fans
for years. For further information on the 30th Anniversary details, see Surekha’s blog: New Book To be Launched at IBM Information On Demand: IBM DB2: The Past, Present and Future If you are attending the IBM Information on Demand Conference, get a free printed copy of this book at the Author Signing and Giveaway that is scheduled:
Monday October 22, 12:30 – 1:30 at bookstore
This is a limited edition book and limited copies will be printed so don't miss the book signing. After
the conference is over, a free e-version of the book will be available
for you to download. Follow my blog to ensure that you are one of the
first to know where you can download the book. Other sessions by these authors:
# 2032A - IBM DB2 for z/OS Migration: Query Performance Considerations
- Islander A; Tue, Oct 23, 2012; 8:15 AM - 9:30 AM
# 1723A - Application Best Practices and Recommendations Specific to
IBM DB2 for z/OS Data Sharing - Islander A; Tue, Oct 23, 2012; 11:15 AM -
# 4012A - IBM DB2 10 for z/OS Migration Planning and Experiences -
Part 1 - Islander A; Wed, Oct 24, 2012; 10:45 AM - 11:45 AM
# 4013A - IBM DB2 10 for z/OS Migration Planning and Experiences -
Part 2 - Islander A; Wed, Oct 24, 2012; 12:00 PM - 1:00 PM
Session # 3942B BOF: IBM DB2 for z/OS and Tools: Ask the Experts Panel - South Pacific F; Wed, Oct 24, 2012; 6:15 PM - 7:15 PM
# 1840A - Protecting Your IBM DB2 for z/OS Assets With Effective
Backup and Recovery Strategies - Islander A; Thu, Oct 25, 2012; 8:15 AM -
Session # 1845A - Runstats Challenges for Optimal Query Performance - Islander B; Mon, Oct 22, 2012; 11:30 AM - 12:30 PM
# 3922B BOF - New SQL Function and Performance in DB2 10 for z/OS -
Bayside Dining IM BoF Tables 5&6; Tue, Oct 23, 2012; 12:45 PM - 1:45
Session # 2049A - Do These IBM DB2 10 Optimizer Enhancements Apply to Me? - Islander B; Wed, Oct 24, 2012; 12:00 PM - 1:00 PM
# 3923B BOF - Query Performance Challenges with DB2 10 for z/OS -
Bayside Dining IM BoF Tables 3&4; Wed, Oct 24, 2012; 1:15 PM - 2:15
# 2054A - The IBM DB2 Analytics Accelerator Hands-On Learning Lab -
Shorelines B Lab Room 1; Thu, Oct 25, 2012; 9:30 AM - 12:30 PM
Session # 2991A - Social Business for IT Professionals: Career Enhancements - Islander B; Mon, Oct 22, 2012; 3:45 PM - 5:00 PM
# 3921B BOF - IBM DB2 for z/OS e-Communities, Collaboration Groups
-Social Networking World - Bayside Dining IM BoF Tables 3&4; Tue,
Oct 23, 2012; 12:45 PM - 1:45 PM
Are you feeling left out that you are back to work and NOT back to school like so many others? Take one of the the Self-Paced Virtual Classes (SPVC) trials for free and you'll be "back in school" too!
What is SPVC?
Self-Paced Virtual Classes (SPVC) are recorded lectures, demonstrations and exercises that you can access on-demand. Meaning... you can take the class in the middle of the night if you like, wearing whatever you choose to wear, and wherever you choose to be (as long as you have high speed internet access! The classes are narrated by IBM classroom instructors.
What is the benefit of this type of class?
* Big savings with no travel costs and lower tuition * Delivers same content, exercises and hands-on labs as classroom courses * Instructors are included “virtually” through recorded lecture, demonstrations and exercises * Conduct hands-on labs with real IBM software – not simulations * Access to course Forums with expert feedback from instructors and fellow students * Flexibility to train when and where you want What is offered in the Free Trial?
The trial courses include a portion of a real course that, depending on the course, includes instructor lecture, demonstrations, and exercises. The trial courses do not include access to the hands-on lab environments. However, a copy of the lab exercise books are included on the materials tab.
After enrolling,you receive your access and login information by email. At your convenience, anytime within the next 30 days, log in and begin your course. Once you login, your class material is presented as an integrated eLearning environment, with all course components in one easy-to navigate interface.
Begin your study by reading the course content and to reinforce key concepts, you are challenged to multiple interactive online exercises.
Enjoy the free trial and if you like it... let me (and others) know!
I know! We're on a roll here with all the new books that are publishing or about to publish. October seems to be our big month!
I'm very happy about all of the books, but especially this one! I've been working with Liwen for what seems like 10 years on getting a book about DB2 & SAP published! Lots of hurdles, lack of authors, lack of time...you name it... it was a problem. But persistence from everyone and look what we have! Right now we only have the e-version of the book...which you can print if you want a printed copy... and hopefully we can go the next step with this book in the near future.
Here are the details: SAP DBA Cockpit - Flight Plans for DB2 LUW Administrator by Eduardo Akisue Jeremy Broughton Patrick Zeng Liwen Yeow
This book is a reference document on the fully integrated monitoring and management of DB2 through the brilliantly designed SAP front end. The book takes the reader through all aspects of the DBACOCKPIT tooling and suggest certain best practices that should be considered.
DB2 & SAP have been partners for many years now... so take a look at what that partnership brings you! You won't be disappointed!
top 7 finalists of the DB2Night Show “DB2’s Got Talent” competition
presented today. And guess what we got? Another 7 great presentations
that were both entertaining and informative! The
last round of the competition ended up with 964 votes! Can we top that
in the next round? As a result of the votes, we’ve identified the top 4
and the bottom 3 ⇒ The judges will save 1 from the bottom 3 in this
show. Next week we’ll hear from the Top 5 as determined by your votes. So support these rising stars... listen, vote, and share! Here’s a summary of today’s show: Armando The Secret Armando
is a family man who plays chess and lives in Portugal. He’s been a DBA
for 12 years and was an Application Programmer before that. Great charts, but Armando ran out of time for his conclusion. Topic a bit too big for 5 minutes. Renu These tennis shots make me win my match in just 2 sets (1.5 hours) Renu is passionate about DB2 and would like to write a book about it at one time. She also loves tennis. Very creative SQL statements were demonstrated in her presentation: SQL from the battlefield. Perfect timing. Theme was great with helpful information. Ember Altering a Data Type: Two Different Methods Ember
is married with two children and lives in Denver. She has a blog and
will present at IDUG in Orlando this year for her first time! If you’ll
be there, you must plan to attend her talk! Perfect
timing; great story. Ember is very easy to listen to and presented a
relevant topic. The hints she provided in the presentation are very
valuable. Chris Restrictive Databases: It’s for Members Only Chris is married with 3 children. He became a DBA in the last year and is an avid reader. This presentation was about how you deal with some of the
nuances or snafus of restrictive databases, which are *not* public
by default. And how you use RBAC to help solve
Excellent tips provided! Great presentation; very professional. Sreeharsha Data Compression Sree Lives in India and has worked 2.5 years as a DBA on z/OS. He likes cooking and social media interaction. His presentation was entertaining and informative. He provided great tips and had perfect timing. Eric Improving Performance: Understanding isolation levels Eric is single and living in Brazil. He has a computer engineering degree and loves working with DB2. He also likes running. Great tips on optimizing performance through the careful choice of isolation levels. He
provided great examples to lead you through his tips. Perfect timing.
It was a complex topic, but presented perfectly in 5 minutes. Mohan How to Migrate the DB2 9.7 database from BCU D5100 Stack to ISAS 5600 V2Stack Mohan is married and living in the UK. He likes to go into detail with DB2 and is interested in writing articles and books. This
was a very complex topic: look at those acronyms! Mohan spoke very
fast and had amazing slides. Very thorough story presented. “How to”
tips with great examples. Perfect timing. Another great day filled with awesome presentations! Who will get the most votes this week? The judges chose to save Ember! Check out the great shows that are coming up. Make sure you block your calendar for all the shows you wish to attend... and remember, there are over 100 great episodes waiting for you to download and replay.
You've heard of IBM & Cloud Computing & Amazon.... what do the three have in common? For one, IBM & Amazon have joined together to bring you a FREE webinar about Cloud Computing.
DB2 database software running on Amazon EC2 lets you get the most out
of your IT budget . IBM and Amazon Web Services provide a lot of
flexibility for cloud computing, including free DB2 AMIs, low cost
by-the-hour production-ready DB2 AMIs, and the ability to bring your
existing DB2 licenses to the cloud.
Attend the event to learn more about DB2 AMIs and the
unique capabilities in DB2, including the new features in DB2 9.7 that make it
much easier to move applications from Oracle to DB2.
Even better.... attend the event and get $35 in Amazon Web Services credits to practice
everything you learned.
start your skills to build Software as a Service (SaaS) offerings.
selecting a combination of industry-leading IBM software running on Amazon Web
Services (AWS) allows you to focus all your resources on innovation instead of
In DB2 pureXML Cookbook,
two of IBM's leading experts provide the single most comprehensive
coverage of DB2's pureXML capabilities. This book explains DB2 pureXML
in over 700 practical examples, including 250+ XQuery and SQL/XML
queries, taking the reader from simple introductions all the way to
advanced scenarios. The authors have distilled their hands-on
experience with many pureXML applications so that you can benefit from
best practices, tips & tricks, performance guidelines, and other
gems that are not documented elsewhere.
This book is invaluable for database administrators and application
developers, beginners and DB2 experts. The topics are organized by
typical user tasks throughout the life cycle of XML database projects,
from planning, designing, and implementing databases all the way to
tuning, problem determination, and application development. It includes
code samples for Java, .NET, COBOL, PL/1, C, PHP, and Perl programmers.
Join Serge Rielau, DB2 SQL Architect from IBM in this free webinar:
Thursday, June 3
11:00 AM - 12:00 PM Eastern
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
the three judges of the DB2Night Show “DB2’s Got Talent” Competition
presented along with host Scott Hayes. It was fun, and hopefully
informative to the audience. I
presented first and sadly ran out of time! It is much harder than it
looks. My presentation was on the Power of Social media. I gave tips
on how people can promote the work that they do to the DB2 community,
how to listen to what is going on in the community, and how people can
contribute via likes, comments and sharing the content provided by
I didn’t come close to finishing (did I spend too much time on my bio?
give too many examples?), I’ve posted my slides in SlideShare. Here’s
where you can get them: Db2 night social_promoting_susan. Martin
presented next: “How I Started Dropping DB2 Indexes & Put my Girls
Through College”. Martin is a great teacher and his presentation was
very informative. He also ran out of time and reminded us that he’ll
being doing a similar presentation at IDUG this year. Scott
was next: “ Breakthrough DB2 LUW Performance Every Day!” . I loved the
one quote that Scott used: “Success comes to those who focus on helping
other people be successful”. I would say that all involved in this
show have this sentiment in mind! Entertaining presentation and even
Scott ran out of time! Lastly
came Klaas: “Da House is on Fire: How to Fix a Performance Problem”.
Very interesting graphics, but very effective as well. Klaas is a
natural speaker and if you get a chance, you should attend his talks.
Of the 4 presentations, Klaas was the only one who finished on time!
voting was interesting, but not surprising. Clearly the audience
prefers technical content about DB2. My presentation was in a
completely different category! Congratulations to Martin for being the
overall “winner” of this show. Some reminders:
Attend the shows in March to witness our finalists presenting in aim of the big prize.
Watch the replays! There have been 220,000 downloads so far. Only 30,000 more to get to ¼ million!
When you watch today’s replay, be sure to fill out the survey. Every week someone wins a $25 Amazon.com gift certificate.
Whei-Jen Chen Jason Chan Olaf Mueller Malcolm Singh Tapio Väättänen
technologies are becoming more popular to help efficiently utilize
resources by consolidating servers. IBM, the first company that
developed and made available the virtual technology in 1966, offers
advanced, powerful, reliable, and cost-saving virtualization
technologies in various hardware and software products including DB2®
for Linux, UNIX, and Windows. This IBM Redbooks publication describes
using IBM DB2 9 with server virtualization.
The book starts with a
general overview of virtualization and describes specific server
virtualization technologies to highlight how the server virtualization
technologies have been implemented. With this introduction anyone new
to virtualization will have a better understanding of server
virtualization and the industry server virtualization technologies
available in the market.
Following the virtualization concept, the book describes in detail the setup, configuration, and managing of DB2 with
three leading server virtualization technologies:
IBM Power Systems™ with PowerVM™
The virtual machine setup is done with DB2 in mind to help IT support
understand the effective ways of setting up a virtual environment
specific for DB2. The architecture and components of these
three server virtualization technologies are explained to allow DBAs to understand
how a database environment using DB2 can benefit from using the server
In addition, the DB2
features and functions that can take advantage of using server
virtualization are discussed. These features are put into practice when describing
how to set up DB2 with the three virtualization technologies discussed
in this book. This book also includes a list of best practices from the
various tests performed while using these virtualization technologies.
These best practices can be used as a guideline or a reference when
setting up DB2 using these virtualization technologies.
For those of you attending the IBM Information on Demand Conference later this month, you'll be given a chance to get a free printed copy of this book and meet author Jason Chan.
Lots of people love IBM Redbooks. As you know, they are FREE and available
for you to download in PDF or EPUB versions at anytime from the IBM Redbooks website.
One of the most popular giveaways at IBM Information on Demand Conference is
printed IBM Redbooks. This year we have 10 different titles to give away.
Please note that the PRINTED copies are in limited quantity.
Make sure you attend one of the sessions planned at the bookstore to make sure
you get the title that you want. While you're getting your free copy, meet the authors who wrote the book and have them sign it for you!
I included links to the eversion of the book if it already exists. Notice
that some are not yet published? They’ll be launched specifically for IOD:
Tuesday, October 23, 12:00 – 1:00 at the IOD bookstore
As you can see, we’ve made it easy for you. Come by the bookstore Tuesday,
Wednesday and Thursday at lunchtime to get a printed book!
While you’re at the bookstore, check out the technical books that are available for you to purchase at a
20% discount as well as pick up one of the many free Flashbooks that are scheduled to
be handed out at the bookstore on Monday, October 22.
The IBM Information on Demand Conference is a great place to promote books
that are published through out the year. In fact, quite often publishers time
the release of their books to coincide with this conference. As a result, we
are typically able to set up book signings and giveaways to help promote the
This year is no different. We have quite a few books that have published
already that we’ll promote as well as books launching just for the conference
and we’ll have 4 (possibly 6) new Flashbooks that we’ll be giving away!
“Flashbooks” are small-sized books that have fewer than 150 pages, and have
easy-to-read messages about products, solutions, or technology. Flashbooks are
published to coincide the IBM Information on Demand Conference. The huge
quantity of messages and content delivered at the conference makes it difficult
for attendees to retain all the key messages. Flashbooks are designed to contain
the key messages IBM experts want you to take away with you.
Here is the list of Flashbooks. More details for each will be available in
my blog shortly.
Warp Speed, Time Travel, Big Data, and more: DB2 10 for Linux, Unix
and Window New Features
by Paul Zikopoulos, Walid Rjaibi, George Baklarz,
Matt Huras, Matthias Nicola, Dale McInnis, and Leon
As usual it’s been a very productive year for the ITSO who publish IBM Redbooks. Here is a list of 30 titles that were released for the Information Management area in 2010. Notice that the ITSO allows you to give reader feedback and ratings for these books. If you like a book, make sure you leave a comment. Word of mouth feedback is impressively influential.
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!
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.
Three more days till I fly to Vegas.... for the IOD Conference! I really can't believe how busy I am... and most of it is prep work for IOD! My primary function at the conference will be to introduce you to the many books that are available for you to read to grow your skills on multiple Information Management topics. And guess what? I have much to announce to you on this topic!
First of all, if you are attending the conference, come and visit me at the IOD bookstore: Bayside Foyer, Mandalay Bay Convention Center - South, Level 1 **Books at the IOD Conference bookstore are 20% off the retail price
There are too many books to list here, so come by and browse. Of particular interest are the following books that you can buy and get signed by one or more of the authors:
Mark Jeffries signing copies of What’s Up With Your Handshake? –Mon 11:00 am - 12:30 pm –Tue 1:30 pm – 2:30 pm –Location: At Conference Bookstore
Neal Fishman signing copies of Viral Data in SOA: An Enterprise Pandemic –Mon 1:30 pm – 2:30 pm –Location: At Conference Bookstore
Malcolm Gladwell signing copies of his newest book, Outliers, along with his best-sellers, Blink and The Tipping Point –Wed 10:15 am - 11:15 am –Location: At Conference Bookstore
Matthias Nicola signing copies of DB2 pureXML Cookbook –Mon & Wed 1:30 pm - 2:30 pm –Location: At Conference Bookstore
As usual, we also have a collection of books that we are giving out free of charge. I call these "flashbooks" because they are small, easy to read, and introduce you to a new topic. These books are in limited quantity... and you MUST be at the conference to get a copy:
Judith Hurwitz, Fern Halper, Marcia Kaufman, Glenn Hintze, Adam Gartenberg –Mon 2:30 pm - 3:30 pm –Authors will be available to sign your copy of Information on Demand for Dummies –Exchange your coupon for a free book at the Bayside Level Ticket Counter (across from the IOD Main Information Desk) –Signing location: At Conference Bookstore
Bill Wong, Rex Wiederanders, Alan Meyer, Pat Bates, Mike Biere –Wed 3:45 pm - 4:45 pm –Authors will be available to sign your copy of New Intelligence for a Smarter Planet - Driving Business Innovation with IBM Analytic Solutions –Location: Mandalay Bay Registration Desk South
Kelvin Looi –Mon 3:30 pm – 430 pm; Tue 3:30 pm – 4:30 pm –Signing copy of book MDM for Customer Data: Optimizing Customer Centric Management of Your Business –Location: Mandalay Bay South: Bayside D – Data Management Room
Paul Zikopoulos, Belal Tassi, George Baklarz & Chris Eaton –Tue 12:00 pm - 1:00 pm –Authors will be available to sign your copy of Break free with DB2 9.7: A Tour of Cost-Slashing New Features –Location: Mandalay Bay Registration Desk South
Jason Chan –Tue 12:00 pm - 1:00 pm –Author will be available to sign your copy of IBM Redbook: DB2 Virtualization –Location: Mandalay Bay Registration Desk South
Jacques Roy –Tue 12:00 pm - 1:00 pm –Author will be available to sign your copy of Informix Dynamic Server Application Development – Getting Started –Location: Mandalay Bay Registration Desk South
I'd also like to invite you to the new group I created on MyDeveloperWorks. I will add information about new or existing books as I learn it. If you have questions, this is also a great place to ask it. I'm planning to invite every author who I work with to join me and ask them to answer your questions!
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:
DB2Night Show featured the top 10 contestants who were chosen by the
judges in February. They each had four minutes to impress the audience
and replay listeners. That’s correct. This time the judges are giving
feedback, but are not choosing the best competitor. I must say that
I’m very glad I’m not choosing the best. If you were in the audience
today or if you listen to the replay, you’ll see what I mean: All presenters were incredible Lots of learning happening today! Here’s a summary: Ember The Fragmentation of DBADM Noticed
in DB2 9.7. DBADM is still a superuser of sorts, but there are
granularities. SECADM and DATAACCESS authorities were added. Great
presentation on the permissions for each user type. Great information
presented in an educational fashion. AND, she finished in time. Mohan Simple Steps for Substantially Reducing report execution time in a Data Warehouse Environment. Great graphics, very clear description of the problem and how to fix it. Eric How to Configure an Efficient HA and DR on DB2 10.1 I
like that the tradeoffs slide: puts the problem in perspective. Clear
description of the solution. Seems like this could be a common problem
that needs to be solved: good reasons to upgrade to V10! Chris Getting Siblings to Talk - Federating DB2 LUW and DB2 for i Synchronized DB2 LUW on AIX to their legacy iseries system. Very good description on Federation and how it is set up. Renu My New Moving Vehicle DB2MOVE "With more POWER and Less Gas" Lots of situations when you'd use DB2MOVE. Good description on what the command does, its options, actions and how to use them. Mkiko How do you work with Application Development to Ensure Performance What
do you do when performance problems arises after new features are
added? Problem well defined and quantitative results shown. Armando SQL Performance Tuning using MQT Part 2 Interesting
scenario created to define problem and how it was analyzed and solved
using MQT. And... he spelled cheque correctly! Way to go! Sanjay Temporal Data Management in DB2 for z/OS Good
definitions and contrast between snapshot and temporal. Lots of
details in the scenario that shows the problem and how it is solved.
The topic was too large to complete in time. Sreeharsha DML Scanner DML
= Data Manipulation Scanner. Great presentation style. I like how
different approaches were discussed with pros & cons. Good use of
examples and sample code. Juliano The 8 Selects that All DBAs Want to Have Unfortunately Juliano did not show up today. So without Juliano, we had 9 great presentations today. Who was the best? Listen to the replay and VOTE. Remember if you complete the survey at the end of the replay, you’ll have a chance to win an amazon.com gift certificate. Thanks to all the presenters for your hard work on creating these great presentations. See also: Judges present on the DB2Night Show "DB2's Got Talent" Competition DB2 NightShow: Episode 3 of the DB2's Got Talent Competition DB2 NightShow's 2013 DB2's Talent Competition Susan PS: Promote yourself and DB2 with the help of my slides in SlideShare. Here’s where you can get them:Db2 night social_promoting_susan.
This document describes IBM Smart Analytics Systems scenarios where DB2 software manages multiple database partitions in a cluster. The scenarios describe optimization methods that can help improve performance in a short time.
The two main tasks for query optimization are:
Provide the DB2 optimizer with rich statistical information. The DB2 optimizer uses the statistical information to perform its analysis and find a good execution plan. This article describes the best practices for gathering statistics.
Determine the best query execution plan. If a query needs further tuning, you must inspect the explain plan for the query. This article provides a list of patterns to look for in explain plans. Each pattern is paired with recommended actions.
The key design goals of ingest application design are to balance the required rate of ingest with the availability of processing resources, to ingest data without affecting data availability, and to maintain flexibility in the volumes of data ingested. Identifying service level objectives for the speed and volume of data ingested into the data warehouse will determine the architecture, design, and development of the data ingest application.
I’ve promoted many, if not all, of the DB2Night Show episodes that took place in 2010. Scott Hayes, the host of these free webinars has produced a list of the most highly attended shows. All of these shows were recorded, so if you missed one or more, you can catch up.
Thanks Scott for pulling together such a valuable and well attended series of educational webinars!
I work in the Toronto Lab, so I’m very lucky to know all of the listed speakers personally. I’m constantly humbled by the high quality people I get to work with! Sheryl and Klaas I also personally know, but from my association with IDUG instead of IBM.
Join us on the following dates: Feb 4, 2011 11:00 AM - 12:30 AM EST Feb 11, 2011 11:00 AM - 12:30 AM EST Feb 18, 2011 11:00 AM - 12:30 AM EST Feb 25, 2011 11:00 AM - 12:30 AM EST Mar 4, 2011 11:00 AM - 12:30 AM EST Mar 11, 2011 11:00 AM - 12:30 AM EST Mar 18, 2011 11:00 AM - 12:30 AM EDT Mar 25, 2011 11:00 AM - 12:30 AM EDT
We’re looking for contestants…. are you up for it? Check the site for eligibility. Maybe this will convince you to become a contestant: the prizes!
1st Prize: One FREE IDUG Conference Registration to any IDUG Conference in 2011 (North America, Europe, or Australia) provided by IDUG, plus up to $1,500 USD travel expense allowance provided by DBI. Approximate value of prize package: $3,500 USD
2nd Prize: Xbox 360 250GB Console with Kinect (approximate value $500) provided by IDUG.
3rd Prize: $100 Amazon.com Gift Certificate provided by DBI.
Finalist Prizes: Each of the top 10 Contestants that are invited by the judges to participate in Finals Shows will win $50 Amazon.com Gift Certificates provided by DBI.
I’m looking forward to a fun & rewarding new year and wish all the best for you and your families as well!
DB2 for Linux, UNIX and Windows 10.5 with new BLU Acceleration
Technical Immersion Workshop
Fees: No Charge
Date: Friday, May 3, 2013
Hours: 8 AM to 2 PM
Presenters: Chris Eaton, Danny Arnold and Eric Alton
IBM is sponsoring a technical DB2 workshop at the upcoming IDUG DB2 Tech Conference in Orlando, Florida. Taught by IBM DB2 technical experts Chris Eaton, Danny Arnold and Eric Alton, this workshop covers key features from the recently announced DB2 10.5 with BLU Acceleration as well as the compression features of DB2 10.1 as previously announced.
This FREE technical workshop is an ideal way to extend your technical skills to include the best capabilities of DB2 for Linux, UNIX and Windows. Specifically:
DB2 10.5 with BLU Acceleration - This hot new technology helps deliver decision-making information to your organization with precision that is termed “speed of thought” analytics. We’ll explain how BLU Acceleration implements new column organized tables and how compression works on these tables along with other new processing techniques to deliver superior performance for analytic workloads.
New improvements in DB2 pureScale that handle maintenance and capacity expansion needs more easily—plus new integration with HADR capabilities to support always available transactions.
SQL and Oracle Database compatibility enhancements added in DB2 10.5
DB2 compression technologies introduced in DB2 10.1 that offer key advantages in managing and better utilizing costly storage resources.
And of course there will be time for your questions and active discussion with these DB2 experts. Don’t miss what is sure to be a lively session. It is an excellent opportunity to update your knowledge of DB2 for LUW and the techniques that are increasingly required in a Big Data world.
If you are planning to attend the conference, make your travel arrangements so you can take advantage of this workshop. If you cannot attend the IDUG conference, you can still attend the workshop only at no charge.
IOD EMEA which took place in Rome last week was a huge success. I'm working on my trip report and will post some of it here.
Monday and Tuesday next week, I'll be at the Toronto conference CCDB2UG where the Central Canada DB2 Users Group is celebrating their 25th anniversary! I'm quite looking forward to my annual visit with some of the most amazing people I've ever met. For more information, see this blog entry I did recently: Local Conference - Central Canada User Group.
I've already began planning for our huge IOD event that will take place in Vegas the last week of October. I'm looking forward to see the sessions and speakers who have been chosen for the event. The bookstore is arranged already, so just the signings are left to plan. I'm hoping this year that we have the book signing events included in the agenda builder so you won't miss what the signings that you want to attend. More on this conference coming up.
I've talked to a few people about the IDUG conference that is taking place in Vienna the second week of November. I'm not sure what my involvement will be at this point, but it would be a nice one to attend, don't you think?
There are many free webinars that are coming up soon... I hope you are able to take advantage of the amazing content that is available to you for free! I know time is always a factor, but most of the webinars are recorded so you can benefit from the content after the fact.
My favourite ones are:
1) DB2Night Show - tomorrow is Sam Lightstone, and there are several more speakers planned for the coming weeks.
2) Chat with the Lab - there was an event today, but you can keep on top of the scheduled and recorded events by joining this group: Channel DB2 Chat with the Lab
3) Surekha Parekh does a fine job of informing the world of the events surrounding DB2 for z/OS. I strongly suggest that you join one of the groups that she posts to in order to stay on top of what's happening. The World of DB2 for z/OS is one of the places she updates regularly.