Discover the best practices for IBM DB2 for Linux, UNIX, and Windows. Get practical guidance for the most common DB2 9 product configurations and use this knowledge to improve the value of your DB2 data servers.
Notice that updates and additions were made recently:
"Database Storage" (October 2008) Updated!Discover best practices for database storage including guidelines and recommendations for spindles and logical unit numbers (LUNs), stripe and striping, transaction logs and data, file systems versus raw devices, Redundant Array of Independent Disks (RAID) devices, registry variable and configuration parameter settings, and automatic storage.
"Physical Database Design" (May 2008)Learn about all of the design features that relate to the physical structure of the database such as datatype selection, table normalization and denormalization, indexes, materialized views, data clustering, multidimensional data clustering, table (range) partitioning, and database (hash) partitioning.
"Information Modeling with Rational Data Architect Version 7" (October 2008) New!Discover the best practices for information modeling based on the experiences of a team of data modelers using Rational Data Architect with DB2. Rational Data Architect is an information modeling tool that can help you establish and use standards in design based on proven design methodologies to create highly reusable models that satisfy business requirements.
"Data Life Cycle Management" (October 2008) Updated!See the best practices to design and implement scalable solutions that facilitate the continuous feed or roll-in and roll-out of data, with minimal interruption of data access.
"DB2 High Availability Disaster Recovery" (October 2008) New!Get recommendations for setting up and maintaining a DB2 High Availability Disaster Recovery (HADR) environment in ways that balance the protection HADR provides with performance and cost. This best practice explains optimizing for fast failovers, tuning parameters for network and logging performance, and understanding table reorganization methods and load operations in an HADR environment.
"Tuning and Monitoring Database System Performance" (October 2008) Updated!See best practices for the performance evolution of a Data Server. From important principles of initial hardware and software configuration to monitoring techniques that help you understand system performance under both operational and troubleshooting conditions. For troubleshooting performance problems, this paper provide a step-wise, methodical method for determining the problem.
"DB2 Workload Management" (October 2008) New!DB2 Workload Management helps prevent, detect, and resolve conflicting resource requirements on a DB2 data server based on defined business objectives. This paper details the current best practices for DB2 workload manager.
Keep on Learning
svisser1 2700018UK9 3,928 Views
Join us for this webcast that will help you understand where DB2 is headed in the future...
IBM DB2 Chat with the Lab - Thursday, April 12th at 11 AM Eastern, 10 AM Central, 8 AM PacificBeyond DB2 Viper - Technology Trends and Directions
The next offering in IBM's Chat with the Lab series will feature Sal Vella, Vice President of DB2 Development for Linux, Unix and Windows and Les King, Program Director of the Data Services Portfolio, who will talk about the next release of DB2 on the distributed platform. A detailed look at key requirements that drive product plans in areas such as XML exploitation, manageability, scalability and performance, optimization and warehousing will be discussed.
Click here to register for the chat.
If you are trained on a database management system other than DB2, we have many resources available that can help you expand your skills to also include DB2. I've been told that it is quite easy to learn DB2 after Oracle or MS SQL Server have been mastered.
Why would you want to learn DB2? You may wish to broaden your skills to make you more marketable in case you are affected by your company downsizing. Perhaps your company will choose to install DB2 in addition to your current database system, or instead of your current system. Maybe you'll try using DB2 and prefer it to your current system because of specific features or due to ease of use. Whatever the reason, we have the resources for you. Please note that many of these resources are FREE.
For starters, I would like to thank Amyris Rada for helping me make this information as complete as it can be! Some of the articles that I'll be mentioning were written by Amyris and she has plans to use her talents in this area for future projects, so stay tuned.
DB2 Universal Database versus Oracle data movement
A comparative guide
Leveraging your Oracle 9i skills to learn DB2 UDB for Linux, UNIX and Windows V8
IBM DB2 UDB versus Oracle backup and recovery
A comparative guide
Converting Oracle Pro*C Programs to DB2 Universal Database
Migrating Recursive SQL from Oracle to DB2 UDB
Using DB2 routines to ease migration
Truncating tables, getting the client's host name, and calling stored procedures from UDFs
Oracle to DB2 UDB Conversion Guide
This IBM Redbook is an informative guide that describes how to migrate the database system from Oracle to DB2 UDB Version 8.1 on AIX, Linux, and the Microsoft Windows platform. This guide presents the best practices in migration strategy and planning, migration tools, and practical migration examples. It is intended for technical staff who are involved in an Oracle to DB2 UDB conversion project.
This redbook provides migration planning guidelines, with step-by-step instructions for installing and using IBM Migration Toolkits (MTK) to port the database objects and data from Oracle to DB2 UDB. It illustrates with examples how to convert the stored procedures, functions, and triggers. Application programming and conversion considerations are discussed along with the differences in features and functionality of the two products.
In addition, you can find script conversion samples for data loading, database administration, and reports, which are useful for DBAs. The testing section provides procedures and tips for conversion testing and database tuning.
SQL In A Nutshell, 2nd Edition
by Kevin Kline, Daniel Kline, Brand Hunt
This invaluable desktop quick reference drills down and documents every SQL command and how to use it in both commercial (Oracle, DB2, and Microsoft SQL Server) and open source implementations (PostgreSQL, and MySQL).
Understanding DB2(R) : Learning Visually with Examples
by Raul F. Chong, Clara Liu, Sylvia F. Qi, Dwaine R. Snow
Understanding DB2 doesn't just present the big picture. It thoroughly introduces every DB2 concept, procedure, and tool you'll need to get results as an administrator, user, or developer. You'll find authoritative coverage of installation, configuration, objects, database instances, storage, connectivity, security, performance, backup and recovery, SQL fundamentals, and much more. Virtually every new concept is explained with screenshots, diagrams, or tables, all designed to help you learn faster and remember more.
DB2(R) SQL PL : Essential Guide for DB2(R) UDB on Linux(TM), UNIX(R), Windows(TM), i5/OS(TM), and z/OS(R) (2nd Edition)
by Zamil Janmohamed, Clara Liu, Drew Bradstock, Raul F. Chong, Michael Gao, Fraser McArthur, Paul Yip
DB2 SQL PL, Second Edition shows developers how to take advantage of every facet of the SQL PL language and development environment. The authors offer up-to-the-minute coverage, best practices, and tips for building basic SQL procedures, writing flow-of-control statements, creating cursors, handling conditions, and much more. Along the way, they illuminate advanced features ranging from stored procedures and triggers to user-defined functions. Whether you're developing new SQL PL applications, migrating or tuning existing applications, or administering DB2, you'll find this book indispensable.
IBM MTK Toolkit Web
The IBM DB2 Migration Toolkit helps you migrate from Oracle (versions 7, 8i and 9i) to DB2 UDB V8.1 and DB2 V8.2 on Windows, UNIX and Linux.
Sample Database Migration Tutorial Using IBM DB2 Migration Toolkit
Automate the Switch to DB2 Using the IBM DB2 Migration Toolkit
The no-charge IBM DB2 UDB Migration Toolkit can simplify and improve your migration to DB2 Universal Database (DB2 UDB). This migration utility provides a wizard and an easy-to-use interface with only five steps to help you quickly convert existing Sybase, Microsoft SQL Server, Oracle, and Informix database objects to DB2 UDB.
There are a number of DB2 UDB Porting Guides and other documents available to assist you in moving your database and application from its existing DBMS to DB2 UDB.
DB2 Sample UDFs for migration:
PS: We have resources for those using SQL Server, Sybase, and other products, but I felt that I should cover those in a separate post.
Another 200 exams taken on the second day of the conference! That brings our two day total of exams given to 400! We appear to be on our way to breaking our previous record of conference exams.
Lots of action in the bookstore as well. Many people are choosing to purchase one of the Sanders study guide or the certification guides rather than paying $10 to take an assessment exam. The study guides have a set of assessment questions that explain reason an answer is correct. This may be more helpful to prepare for the exam than taking the assessment exams on their own.
Another observation: For those of us in Canada, we're used to having two prices on any book we purchase: a US price and a Canadian price. These prices are set when the book cover is produced and the Canadian price is set based on the exchange rate at that time. Several of our very popular books were published 3 years ago when the Canadian dollar was very low compared to the US dollar. As a result, a $50 book in the United States costs $90 in Canada. The current exchange rate is about 20%, so these prices are very much out of whack. Unfortunately prices are not changed until a new edition is published, so the Canadian buyer must pay the price listed on the book. One way around this is for Canadians who are attending the conference to purchase the books while they are here. They will need to carry the book back with them, but they will pay the US price and get a 30% conference discount. So that $50 book will cost $35 US plus the exchange rate, so about $45 Canadian. What a great deal!
Yesterday morning I administered exams at the Content Management Techical Conference which is being held at the Swan. Business is slower here, but there is lots of interest in the new Content Management Exam 443: DB2 Content Manager V8.3. There was a course in the evening from 6:30 - 9:30 to help people prepare for this exam. I'll let you know tomorrow if that changes the results at all.
That's all for now. Back to networking with people at the conference.
Happy 2009 to one and all! May it be a joyful and prosperous year for you and your loved ones!
The last week of December the following announcement was made and I wanted to make sure that you didn't miss it: DB2 Express-C for Mac OS X is finally available for download.
This beta release will no doubt be of interest to developers, particularly those who use scripting languages like Ruby, Python and PHP. These communities are in fact, increasingly embracing Mac OS X as their operating system of choice.
If you haven't already seen it, see also an announcement from Antonio Cangiano.
Funny side note.... I own a Mac myself and when I tell people, they treat me like I'm a traitor to IBM! I'm quite pleased that IBM is not tying their software to a single platform and that we long term IBMers can happily and proudly say that we use a Mac... and our top tier software runs quite nicely on it.
We'd like to personally invite you to the 2nd Annual Women in Technology reception at IOD 2008 in Las Vegas. We are excited to announce that this year's event will be hosted by Debbie Landers, VP IBM WW Client Support for Information Management and Nancy Pearson, VP IBM Information Management Marketing. Given the success of last year's event, we've decided to structure this year's in a similar manner.
If you have any specific suggestions on the session, please do not hesitate to provide comments on my blog so I can let Jennifer Gibbs and Katherine Franklin know.
Please find details of the event below along with the link to enroll via the IOD website.
Event Details:Session: BOF-2267A Women In Technology: Leveraging Our Unique Abilities to Build SuccessTime: Wed, 29/Oct, 06:00 PM - 07:00 PMLocation: Mandalay Bay South Convention Center - Jasmine A
Please spread the word to your women colleagues. Many thanks for your participation and support of this reception!
Looking forward to seeing you there. Don't forget your business cards!
Thanks to Jennifer for sending this information to me:) I'll definitely be attending!
Are you aware of the IDUG Online Learning Center?
IDUG Learning Center offerings are download-on-demand streaming media files featuring original presenter audio synchronized with presentation slides, along with some audio only offerings. Using standard desktop controls within an Internet browser, users can pause, rewind, fast-forward, stop and resume sessions from the Learning Center at their convenience. Offerings from the IDUG Online Learning Center session can be viewed an unlimited number of times for three months from the date of purchase.
Select offerings from the Online Learning Center are available at no cost. For others, IDUG Membership is required to access. (Basic Membership in IDUG is free-of-charge, requiring only completion of our membership application.) The majority of Learning Center offerings are available at a cost of $5 per (USD) for Premier Members and $10 per for Basic Members. IDUG Premier Members also enjoy complimentary access to keynote presentations, spotlight sessions and panel discussions hosted in the Learning Center, while these sessions are available for a fee to Basic Members.
The IDUG Online Learning Center is a leading-edge resource to make technical education from IDUG events available anytime, anywhere through your Web browser. Experience the Learning Center with a free introductory sample of the Best User Presentation from IDUG 2007 - North America.
The IDUG Online Learning Center library features more than 220 in-depth sessions captured at IDUG 2007 - North America, which took place May 6-10 in San Jose, California, U.S.A. The sessions captured at IDUG Europe 2007 - Athens will be added to the library very soon.
Among the titles now available in the Learning Center are the following:
Session F13/G10: Magic of V8 RebindBonnie Baker, Bonnie Baker Corporation
Session F03: Hard Lesson Learned when OO Meets RelationalJohn Campbell, IBM DB2 for z/OS Development
Session F06: Put a Smile on Your DBA's Face - Performance for the Developer (and You Know It All DBA's)Rob Crane II and Marc Costa, FedEx Freight System
Session C02: Application Performance Tuning in DB2 9 for z/OSGene Fuh, IBM Silicon Valley Lab
Session E10/E11: A Sneak Peak at the Next Release of DB2 Linux, Unix and WindowsMatt Huras and Aamer Sachedina, IBM Toronto Lab
Session B08: Top 10 Ways to Waste CPUSusan Lawson and Daniel Luksetich, YL&A
Session A03: The Effect of Distribution and Correlation Statistics on the DB2 OptimizerTom Moulder, TREX Associates, Inc.
Session G06: More Ways to Challenge the DB2 z/OS OptimizerTerry Purcell, IBM Silicon Valley LabVoted Best Overall Presenter at IDUG 2007 - North America
Session B01: Availability Enhancements in DB2 for z/OSHaakon Roberts, IBM DB2 for z/OS DevelopmentBest attended session at IDUG 2007 - North America
Session J01: IBM DB2 Utilities: What's New in DB2 9 and Often Overlooked Features Before 9Bryan Smith, IBM Silicon Valley Lab
To commemorate the launch of this vital new resource and to encourage use of the Online Learning Center, IDUG is pleased to make the session voted Best User Presentation (as selected conference by attendees) available free-of-charge for a limited time. To access the file, simply click on the session title below:
DB2 9 for z/OS: John Deere's Early Ship Pilot (ESP) ExperiencePresenter: Bryan Paulsen, John Deere
IDUG invites you to benefit from this new, exciting program as we extend the organization's boundaries as the worldwide DB2 user community. Enjoy!
The other day I had a request for Don Chamberlin's book that was published 9 years ago: A Complete Guide to DB2 Universal Database. I know the book is EXCELLENT, especially since it was written by one of the inventor's of SQL! But, like most books, I figured that it was out of date and not very useful at this point. But when I made this comment, here was the response back to me:
The Don Chamberlin book is more of a complete DB2 SQL manual that many JDBC developers will need.
I'm not a JDBC developer, so I'm looking for comments on this one. Where do you go for SQL help???
I'm busily preparing for the IDUG 2008– North America Conference taking place in Dallas in approximately 6 weeks, May 18-22, 2008 at the Hyatt Regency Dallas.
The early-bird discount expires on April 16, so register now to save $200. See the online conference schedule to see what the conference has to offer you. Here are a few of the highlights:
1) Once again... free certification exams. This provides you a savings of $150 per take... pass or fail. If you are looking to upgrade to V9 certifications, you have 6 exams to choose from: 730, 731, 732, 733, 734, and 736. Even if you took only five exams, that would be a savings of $750! Could this be the justification that you need to go to the conference?
2) Prepare for the exams now... and/or take one of the Pre-conference Crammer classes by exam developer / authors: Roger Sanders or Susan Lawson.
3) Discounted books: I'm putting together a list of books to suggest to the bookseller, Breakpoint books. In creating this list, I'm trying to ensure that you have the latest books with the highest ratings. If there is a book that you'd like to suggest that I add to my list, let me know. I believe the normal 10% discount will apply at the conference.
4) Skills Hub: I will be located at the bookstore for the week, or right next to it, at the Skills Hub. This is a new area for an IDUG conference and is based loosely on what we did at IDUG Athens last November. We encourage people to come and ask questions, browse the books, talk to us about your particular needs, and if possible, pick up a freebie or two.
5) Authors who will be speaking at the conference. I don't know if I have a complete list yet, but here's what I was able to pull together from the Advance Program:
* Roger Sanders* Susan Lawson* Daniel Luksetich* George Baklarz* Leon Katsnelson* Dwaine Snow* Chris Eaton* Craig Mullins* Phil Gunning
6) Presentations / Education - there are at least 150 hours of education provided by experts and users.
7) Exhibit Hall: eight hours available for you to meet related vendors who can help with your specific needs for products or services.
8) Keynote speakers: Arvind Krishna, Curt Cotner and Chad Fowler.
9) IBM Panel discussions.
10) Special Interest Groups
and last, but not least.... networking opportunities!
Looking forward to seeing you!
I blogged about this new voucher promotion last week.... we now have a link to this promotion on the amazon page for the book: IBM DB2 9 New Features and we're getting amazing response. Make sure you don't miss out!
Here is my original post:
Buy a book... get 50% off a certification exam! We only have a limited number of vouchers, so we're expecting to run out quickly. Be one of the first to get a voucher by buying a copy of the IBM DB2 9 New Features by Paul Zikopoulos, George Baklarz, Leon Katsnelson, and Chris Eaton. You don't need to buy the book from amazon, but you do need to send us proof of purchase.
Normally exams cost about $150 ... so this is a savings of $75. For full details, read: Voucher Promotion Details