Do you ever wonder what kind of gadgets will be invented in the near future and how they'll impact our daily lives? IBM held a LiveJam last year for all employees and has published the 5 top ideas discussed by employees in an article called Next Five in Five.
The top five ideas are:
* We will be able to access healthcare remotely, from just about anywhere in the world * Real-time speech translation-once a vision only in science fiction-will become the norm * There will be a 3-D Internet * Technologies the size of a few atoms will address areas of environmental importance * Our mobile phones will come close to reading our minds
Enjoy the article!
Keep on Learning
svisser1 2700018UK9 2,585 Views
svisser1 2700018UK9 2,673 Views
The first tutorial in the DB2 9 Application Development 733 certification prep series is now available.
DB2 9 Application Development exam 733 prep, Part 1: Database objects and programming methodsGet an introduction to the different types of database objects and programming methods. The material in this tutorial primarily covers the objectives in Section 1 of the exam, entitled "Database objects and programming methods."
This one was authored by Clara Liu who you may recognize as one of the authors of the Understanding DB2: Learning Visually with Examples book. Pass Exam 733 (and its prerequisite) earns you the IBM Certified Application Developer certification, which confirms that you are an intermediate or advanced level DB2 application developer and shows that you have strong skills in all common programming tasks as well as embedded SQL programming, ODBC/CLI programming, or Java programming.
The series will consist of nine free tutorials and is designed to help you prepare for Exam 733. Each tutorial includes a link to a free DB2 for Linux, UNIX, and Windows trial download. These tutorials provide a solid base for each section of the exam. However, you should not rely on these tutorials as your only preparation for the exam.
After a quick registration, you can begin a tutorial. Each tutorial should take about an hour to complete. You can take the tutorials online, or download a PDF.
Other tutorials in this series will follow very soon, and include:
* DB2 9 Application Development exam 733 prep, Part 2: Data manipulation* DB2 9 Application Development exam 733 prep, Part 3: XML data manipulation* DB2 9 Application Development exam 733 prep, Part 4: Embedded SQL programming* DB2 9 Application Development exam 733 prep, Part 5: ODBC/CLI programming* DB2 9 Application Development exam 733 prep, Part 6: .NET programming* DB2 9 Application Development exam 733 prep, Part 7: Java programming* DB2 9 Application Development exam 733 prep, Part 8: Advanced programming* DB2 9 Application Development exam 733 prep, Part 9: User-defined routines
Unfortunately at this point, we have no plans to update the Certification Study Guides to support this exam. I'm hoping that will change and will let you know if it does.
svisser1 2700018UK9 2,619 Views
Living in Canada, I'm often sent offers to purchase books online at a discount... only to find that I must pay for the book in US dollars and then pay a shipping fee that can easily double the price of the book. Have you encountered this issue as well?
Amazon has done an amazing job of populating the world with local bookstore choices, so I tend to go to amazon.ca or chapters.ca to buy books, but shipping fees aren't always waived through these sites.
To help those of us outside of the US, I worked with the local publishing representatives from Pearson Education to set up bookstores where you can buy books in your own currency, with low or no shipping fees. We have websites for Canada and EMEA, and local contacts for many other countries. You can get to any of the local information from the International tab on our bookstore site: ibm.com/software/data/education/bookstore.
My team has created flyers and business cards to help promote these websites, so don't be surprised if this information is presented to you multiple times:)
svisser1 2700018UK9 2,512 Views
DB2 Magazine has put together a list of electronic books that you can view for free. The content is displayed in a format that is easy to read with plenty of graphics. You can choose from the following topics:
XML FOR JAVA DEVELOPERSDB2 9 introduced powerful XML management capabilities. Download this new e-book from DB2 Magazine to find out how the techniques you use every day can help you put that power to work. You'll learn XML programming tips for Java developers, see detailed Java application examples, and get a recap of all the new features and functions that ease Java development.
TAKING AIM AT PERFORMANCE PROBLEMSStop wasting time on hit-or-miss tuning exercises. Event monitors and snapshots show you exactly where to point your efforts.
SPOTLIGHT ON XMLDB2 9's "pureXML" technology introduces powerful XML management capabilities. Here's how to use the skills you already have to put that power to work.
APPLICATION DEVELOPMENT OPTIONS: PERL, PHP, AND REXXWhen it comes to Development, DB2 is open to all options. IBM's commitment to open, standards-based interfaces and its support for a range of tools mean that developers can build DB2 applications with the tools and programming languages they like.
This special e-book presents DB2-specific code, tips, and techniques for working with three increasingly popular choices: Perl, PHP and Rexx.
DEVELOPING DB2 APPLICATIONS: THE PLATFORM CHOICE IS YOURSWhen it comes to application development, Java junkies and .Net devotees may never see eye to eye. If they're developing for DB2, they don’t have to. DB2 UDB v.8.2 shipped earlier this year with something for every developer, regardless of platform preference. This must-read e-book highlights the latest in DB2 application development, with platform-specific examples, expert guidance, and more.
BRIDGING THE ISLANDSNow you can connect Informix data with other corporate information. The result? An impressive enterprise view.
DB2 UDB THE AUTONOMIC COMPUTING ADVANTAGEGetting the most from today's complex database systems is a challenge. Learn how self-managing capabilities in DB2 UDB v.8.2 do some of the work for you.
THE BIG LEAGUESIn this special e-book for Informix customers, you'll read how businesses are using the new release of Informix Dynamic Server, how Informix technology is finding its niche in the IBM world, and what IBM's Janet Perna says about the future of Informix at IBM.
THE PERFORMANCE DIARIESThis special e-book, compiled from three installments of Robert Catterall’s popular DB2 DBA column, brings you all the instructions you'll need to find these details and put them to use in your tuning efforts.
OPEN THE THROTTLE: Tuning DB2 UDB v.8.1In this three-part series, database performance engineer Roger E. Sanders explains the seven tuning rules every DBA should know and gives a platform-specific guide to getting the best performance from your DB2 UDB implementation. Portable e-book format!
ON DEMAND: Real Companies, Real BenefitsA special editorial section for CEOs, CTOs, technology-focused executives and managers, and anyone interested in IBM's on-demand concept. These brief articles showcase real companies reaping real benefits from the information-on-demand approach — an infrastructure for getting the right information to the right person at the exact moment it's needed.
Thanks to Kim and the rest of the staff at DB2 Magazine for pulling together relevant documents such as this!
svisser1 2700018UK9 2,561 Views
Securing data in a database has always been an important topic, but with the recent events with customer's personal information ending up in the hands of the wrong people I would say that having a security plan is top priority on every DBA's mind.
Rebecca Bond and her team's book Understanding DB2 9 Security is a must read for any DBA, regardless of the product that they support. Much of the book covers sound techniques that should be followed to ensure proper protection of precious data.
I read much of the book while it was being written.... and I must say that the authors have succeeded in making this topic readable... and as the cover mentions... understandable. Yesterday when I spoke to Grant Hutchison who is in the middle of reading the book, he stressed that the parts he's read so far are so well written that he thinks the style should be used to describe many other topics as well.
Fred Sobotko of FRS Consulting has also read the book and put a very favourable review in his blog.
Today I noticed that an excerpt of chapter 2 can be found on SearchDataManagement.com. Chapter 2 is entitled "The Starting Point" and describes very eloquently how having a security plan can help a company achieve success in their business.
If you've had a chance to read this book, and liked it, please let your opinion be known! Amazon.com is a wonderful place to put customer reviews that get read and actually help people decide which book to buy.
svisser1 2700018UK9 2,539 Views
I just started reading the IOD BlogCentral Site today on the recommendation of Grant Hutchison.
The various blogs within IOD BlogCentral can be found at this site and they are updated by various IBM product managers, technical architects, marketing managers and strategists. The blogs typically discuss the key issues and market trends across Information Management. As with any blog, you are able to participate by making a comment.
svisser1 2700018UK9 3,062 Views
The good news is that Roger Sanders has just completed the manuscript for the Exam 730 Study Guide. The bad news is that it won't be published until May, just in time for the IDUG NA Conference in San Jose. By the way, Roger will also be running his extremely popular and well-received crammer course at the IDUG NA conference as well. See the conference agenda for information.
I've known Roger since 1997 when he first began writing retail books for DB2. In the past 10 years, Roger has been successful at writing numerous books, redbooks, articles, tutorials and ebooks. By far, the most prolific author I know... although Paul Zikopoulos is a close rival :)
I recommend Roger's publications for a number of reasons. First of all, he is an excellent writer! He makes complicated topics easy to understand and is successful at writing material that is NOT BORING. Secondly, when it comes to study guides, Roger makes sure that he creates many extra questions for readers to try to answer and then learn from the answer. His up coming book has 150 study questions! And some of the explanations take over a page to explain why the correct answer is correct.
Not including the study guide mentioned above, here is a list of the publications that Roger has published. I've added links to the current content.
Using the IBM System Storage N Series with Databases (co-author)IBM Redbooks, 2007 (To be published early 2007)
Integrating IBM DB2 with the IBM System Storage N Series (co-author)IBM Redbooks, 2006 (ISBN 0738496855, 102 pages)
Using IBM DB2 UDB with IBM System Storage N Series (co-author)IBM Redbooks, 2006 (ISBN 0738496820, 130 pages)
DB2 Universal Database V8.1 Certification Exam 703 Study GuideIBM Press/Prentice Hall, 2004 (ISBN 0131840495, 499 pages)Also available in Books 24x7 and Safari.
DB2 Universal Database V8.1 Certification Exam 701/706 Study GuideIBM Press/Prentice Hall, 2004 (ISBN 0131840487, 486 pages)Also available in Books 24x7 and Safari.
DB2 Universal Database V8.1 Certification Exam 700 Study GuideIBM Press/Prentice Hall, 2003 (ISBN 0131424653, 416 pages)Also available in Books 24x7 and Safari.Translated and printed in Russian
DB2 UDB Exploitation of NAS Technologies (co-author)IBM Redbooks, 2002 (ISBN 0738425222, 288 pages)
All-in-One DB2 Administration Exam GuideMcGraw-Hill, 2002 (ISBN 0072133759, 840 pages)Translated and printed in Chinese
DB2 Universal Database SQL Developer’s GuideMcGraw-Hill, 2000 (ISBN 0071353895, 834 pages)Translated and printed in Chinese
DB2 Universal Database API Developer’s GuideMcGraw-Hill, 2000 (ISBN 0071353925, 640 pages)Translated and printed in Chinese
DB2 Universal Database Call Level Interface (CLI) Developer’s GuideMcGraw-Hill, 1999 (ISBN 0071345728, 740 pages)
ODBC 3.5 Developer’s GuideMcGraw-Hill, 1999 (ISBN 0070580871, 975 pages)
The Developer’s Handbook to DB2 for Common ServersMcGraw-Hill, 1997 (ISBN 007057725, 1146 pages)
Database Cloning (Distributed DBA Column)DB2 Magazine, Quarter 4, 2006 – Volume 11 Number 4
What’s it to you? DB2’s XML support is here. Are you ready to handle it? (Distributed DBA Column)DB2 Magazine, Quarter 3, 2006 – Volume 11 Number 3
Beyond the Default (Part 2) (Distributed DBA Column)DB2 Magazine, Quarter 2, 2006 – Volume 11 Number 2 Beyond the Default (Distributed DBA Column)DB2 Magazine, Quarter 1, 2006 – Volume 11 Number 1
Split Mirroring (Distributed DBA Column)DB2 Magazine, Quarter 4, 2005 – Volume 10 Number 4
Rollforward Recovery (Distributed DBA Column)DB2 Magazine, Quarter 3, 2005 – Volume 10 Number 3
Protecting DB2’s Image (Distributed DBA Column)DB2 Magazine, Quarter 2, 2005 – Volume 10 Number 2
The Cornerstone of Crash Recovery (Distributed DBA Column)DB2 Magazine, Quarter 1, 2005 – Volume 10 Number 1
Performance Monitoring, Part 3 (Distributed DBA Column)DB2 Magazine, Quarter 4, 2004 – Volume 9 Number 4
Improving DB2 Universal Database PerformanceCertification Magazine, October, 2004
Performance Monitoring, Part 2 (Distributed DBA Column)DB2 Magazine, Quarter 3, 2004 – Volume 9 Number 3
Performance Monitoring, Part 1: It’s a Snap(shot)(Distributed DBA Column)DB2 Magazine, Quarter 2, 2004 – Volume 9 Number 2
Basic Performance Tuning, Part 3 (Distributed DBA Column)DB2 Magazine, Quarter 1, 2004 – Volume 9 Number 1
Basic Performance Tuning, Part 2 (Distributed DBA Column)DB2 Magazine, Quarter 4, 2003 – Volume 8 Number 4
Basic Performance Tuning, Part 1 (Distributed DBA Column)DB2 Magazine, Quarter 3, 2003 – Volume 8 Number 3
Demystifying FFDC DataDB2 Magazine, Quarter 1, 2003 – Volume 8 Number 1
Understanding DB2 for Common Server’s Two-Phase Commit Process,DB2 Magazine, Spring 1998, Volume 3 Number 1,
Developing Database Applications with Call Level Interface in DB2 for Common Servers,IDUG Solutions Journal, Volume 4 Number 2, May 1997
Database Recovery Mechanisms for DB2 for Common Servers,Platinum Edge, Volume 3 Number 4, December 1996
TECHNICAL WHITE PAPERS:
Integrating PeopleSoft 8.4 GL Batch with IBM DB2 UDB ESE V8.1 (64 Bit) for AIX on IBM eServer pSeries p630 and Network Appliance FAS960 Enterprise ServerNetwork Appliance, Inc. (Technical Report 3279)http://www.netapp.com/tech_library
DB2 Universal Database Enterprise Server Edition V8.1 - Basic Performance Tuning GuidelinesNetwork Appliance, Inc. (Technical Report 3290)http://www.netapp.com/tech_library
IBM DB2 UDB Enterprise Server Edition V8.1 for UNIX: Integrating with a NetApp FilerNetwork Appliance, Inc. (Technical Report 3272)http://www.netapp.com/tech_library
DB2 Universal Database Enterprise Edition V7.2 - Basic Performance Tuning GuidelinesNetwork Appliance, Inc. (Technical Report 3222)http://www.netapp.com/tech_library
DB2 Universal Database Enterprise Edition V7 for Solaris: Integrating with DAFS Database Accelerator (DDA) and a Network Appliance FilerNetwork Appliance, Inc. (Technical Report 3185)http://www.netapp.com/tech_library
DB2 UDB Enterprise Edition V7 for Windows NT, Backup and Recovery Using a NetApp FilerNetwork Appliance, Inc. (Technical Report 3126)http://www.netapp.com/tech_library
Accessing Data from Your PC Using Version 7 of the SAS System,Proceedings of the 23rd Annual SAS Users Group International Conference, March 1998
OTHER: Tutorials: DB2 V9.1 Database Administration for Linux, UNIX, and Windows Certification Preparation - Part 4: Database Monitoring, 2006
Tutorials: DB2 V9.1 User Certification Preparation - Part 6: Database Concurrency, 2006
DB2 UDB Triggers,Knowledge Xpert for DB2, Quest Software, 2005
DB2 UDB Error Handling,Knowledge Xpert for DB2, Quest Software, 2005
DB2 UDB SQL Overview,Knowledge Xpert for DB2, Quest Software, 2004
Demystifying First Failure Data Capture (FFDC) Data,Knowledge Xpert for DB2, Quest Software, 2004
Understanding DB2 UDB’s Two-Phase Commit Process,Knowledge Xpert for DB2, Quest Software, 2004
Basic DB2 UDB Performance Tuning Guidelines,Knowledge Xpert for DB2, Quest Software, 2004
DB2 UDB’s Snapshot Monitor,Knowledge Xpert for DB2, Quest Software, 2004
Managing Log Files with a User Exit Program,Knowledge Xpert for DB2, Quest Software, 2004
Tutorials: DB2 V8 Application Development Certification Preparation - Part 3 of 7: Embedded SQL Programming,http://www.ibm.com/developerWorks, 2004
Tutorials: DB2 V8 Application Development Certification Preparation - Part 4 of 7: CLI/ODBC Programming,http://www.ibm.com/developerWorks, 2004
Tutorials: DB2 V8.1 Family Fundamentals Certification Preparation - Part 6: Database Concurrency,http://www.ibm.com/developerWorks, 2003
Tutorials: DB2 V7.1 User Certification Preparation - Part 6: Database Concurrency,http://www.ibm.com/developerWorks, 2002
svisser1 2700018UK9 2,501 Views
Thanks to Melissa, Kate, and Heather from my team for putting this much-needed DVD together!
This interactive self-study DVD helps you to get started on IBM Content Manager Enterprise Edition Version 8.3 to take control of your information.
IBM Content Management software captures, stores, manages, integrates and delivers all forms of digital content across a company’s entire value chain from employees to customers to suppliers and partners - to create real business value.
This DVD provides you with a set of learning resources to help you discover ways to increase productivity and turn business information into business value, including:
* Learn about the latest tutorials, Redbooks, and articles about Content Manager * Discover how Content Manager can help you leverage business information * Prepare to become an IBM Certified Solution Designer - DB2 Content Manager V8.3 with our series of nine Content Manager Tutorials * Listen to IBM and industry experts discuss the key benefits Content Manager * Check out our latest case studies and read though our informative whitepapers
To order your complimentary copy, you must complete a brief online order form.
Side note: I proctored Exam 443 for someone this afternoon who was taking the exam for a second time. The first time he took the exam, he was unable to pass it. This time he was able to pass the exam with a near perfect score! How did he do it? He told me that since his first attempt, he has been using CM V8.3 extensively as part of his job. Experience using the product, along with reading the available training resources is an excellent strategy for passing a certification exam.
svisser1 2700018UK9 2,147 Views
In the December Edition of DB2 Magazine, the feature article is
Tracking The TruthBy Cynthia Harvey
The article is a follow up to the joint research project from IBM and the National Geographic Society, called the The Genographic Project. The project asked for volunteers to send a sample of their DNA to project so it could be analyzed and tracked to help determine the origins of people. Apparently there are unique DNA markers that are passed from parent to child that rarely mutate, allowing the scientists to trace the migration paths of the earliest humans.
I was interested in this story for two reasons. First of all, I've always been interested in family history, so I was one of the volunteers who sent DNA in. I received my report a couple of years ago and found it very interesting. The second reason is that the technology used to store the DNA and to analyze the very large amount of collected data is IBM technology, specifically DB2 and WebSphere.
Read about the technical challenges that the team was faced with and how they overcame those challenges with the help of IBM as their technology partner.
DB2 Magazine: http://www.db2mag.com/
svisser1 2700018UK9 2,751 Views
There were plenty of notes about the DB2 wiki when it first launched, but have you had a chance to benefit from it yet?
The purpose of this wiki is to provide technical information about using DB2 on Windows/Unix/Linux platforms in a slightly less formal manner than the product documentation. The wiki was started to support DB2 Express C users who have downloaded DB2 for free, but since DB2 Express C is largely the same as other editions of DB2, all can benefit from this information.
If you would like to ask questions about the product, try the Discussion/ Help forums. You'll see a lot of ongoing activity on these forums, so join in if you can.
svisser1 2700018UK9 14,776 Views
Have you ever used an online book engine such as Safari or Books 24x7? Both Safari and Books 24x7 are online book engines that give you access to thousands of retail books. These engines are quite powerful and very suitable in today’s electronic world. IBM Press books are available in both engines.
Safari is an online book engine that is jointly owned by Pearson and O’Reilly. All books that are published by these publishers are automatically formatted for Safari and made available to anyone who has a subscription to Safari. If you have a subscription, you can read the entire book electronically, search for a keyword across the entire library or a subset of the library, bookmark well-used pages in the books you’ve read, make notes for your co-workers who also have subscriptions, download chapters to print or read offline, or copy code directly from the book into your programs. You can sign up for a 2-week trial from Safari Online. Monthly subscription rates can be as low as $19.99 depending on the number of books you choose for your bookshelf.
Books 24x7 has all the same features as Safari, but a slightly different set of books. Books 24x7 is a direct competitor to Safari and as such, typically carry only the books published outside of Pearson or O’Reilly. Exceptions are made when Books 24x7 buys the electronic rights to use a Pearson or O’Reilly book. This was an arrangement that was made for the IBM Press books that are published through Pearson. You can get further information about the subscription details and prices from Books 24x7.
IBM employees have a paid subscription to Books 24x7 and you can sign up to use it through this internal site: Internal IBM Site for Books 24x7.
I’ve used Books 24x7 to review books and table of contents, searched for specific topics in a set of books, but one of the key benefits is their newsletter. At least every week I’m sent a note telling me about the new books that are available on the engine. I end up seeing titles that are very interesting and useful that I wouldn’t have known about without this newsletter! Another thing that I’ve recently discovered is that some of the books have a mp3 teaser available that allows you to listen to someone reading part of the book to you. This is great for commuters or for anyone who wants a break from reading!
Let me know if you’ve tried these engines and if you see benefits to using them.
svisser1 2700018UK9 2,952 Views
Today I'd like to tell you about the DB2 Chat with the Lab series of webcasts that feature Lab experts who have developed breakthrough technology. All of the sessions listed here are replays, but a new one is coming in February about Performance Tuning. Listen live so you can get YOUR questions answered.
Here is a list of the chats that were recorded earlier: * SAP on DB2 LUW: An Inside Look at TechnologyReplay of this Chat held on December 12, 2006 is now available.Learn how DB2 is optimized for SAP applications, focusing on features such as multi-dimensional clustering, automatic storage management, self tuning memory management, automated table maintenance, deep compression, online inplace reorganization, High Availability Disaster Recovery, and the "Optimized for SAP" switch. Our speakers, Matt Huras, IBM Distinguished Engineer, and Torsten Ziegler, Development Manager with SAP, cover how the key capabilities of DB2 9 are exploited through SAP applications and how they provide unique value to DB2 and SAP customers.
* DB2 9: Simplify database management with Automatic StorageReplay of this Chat held on November 14, 2006 is now available.Managing database storage can be a resource intensive and a time consuming task. The recently introduced Automatic Storage in DB2 9 represents a major leap forward. This feature can associate a set of storage paths with a database, create table spaces on these storage paths without explicitly specifying storage or containers, and let DB2 automatically extend and add containers on the fly. All these capabilities contribute to lowering the Total Cost of Ownership (TCO) of your database environment by substantially reducing the amount of storage administration that database administrators have to perform. This Chat with the Lab will dive into the details on Automatic Storage and the role it plays in DB2 for LUW's storage strategy.
Join Sal Vella, VP of DB2 development, Aamer Sachedina, Senior Software Engineer in DB2 Development, to learn about Automatic Storage in DB2 9, and understand how you can make your job as a DBA much easier. * DB2 9: Securing your data with Label-Based Access ControlReplay of this Chat held on October 12, 2006 is now available.Securing information assets and restricting data access to only those with the need to know is becoming a significant challenge for many organizations, especially in highly classified environments such as government agencies, armed forces, healthcare institutions, etc. Label-Based Access Control (LBAC) is a new security capability in DB2 9 that allows you to control access to your data at a very granular level. With LBAC you can limit data access at the row and/or column level based on security labels. Unlike traditional implementations of mandatory access control (e.g., Multilevel Security), the DB2 LBAC capability allows you to tailor the security label definition to best suit your application specific needs. DB2 LBAC integrates well with other DB2 capabilities (like data partitioning) and can be combined with such capabilities to offer an even stronger security.
Join Sal Vella, VP of DB2 Development, and Walid Rjaibi, Senior DB2 Software Engineer - Security and Privacy, for a deep dive into the LBAC capability in DB2 9 on Linux, UNIX, and Windows. * DB2 9 pureXML: Unlock Your XML PotentialReplay of this Chat held on September 20, 2006 is now available.If you are an IT manager, database administrator, solutions architect or application developer, you are already aware that working with XML data has become increasingly important in your job. XML is a backbone for service-oriented architectures — and XML-based data standards are fueling information exchange and integration in virtually every industry.
Join Sal Vella, vice president of DB2 development, Matthias Nicola, DB2 XML performance expert, and Rav Ahuja, DB2 program manager, for an in depth look at the innovative pureXML technology in DB2 9, and understand how you can unlock the latent potential of your XML data. * Turbo Charge Your Data Server with DB2 9 Query and System Optimization ToolsReplay of this Chat held on August 29, 2006 is now available.Everyday database administrators (DBAs) are under pressure to take an organization's data assets to the next level by optimizing data server throughput and query activities. This webcast is about easy-to-implement tools and strategies that can simplify your DBAs work life and boost the value of your data server. You will learn about DB2 Performance Expert and DB2 Query Patroller tools and how to:* Gain control of and optimize DB2 on Linux, UNIX, and Windows * Improve throughput response time and consistency * Automatically prioritize, coordinate and control multiple queries * Generate valuable reports about current and long-term database behavior
Join Sal Vella Vice President, DB2 for Linux, Unix and Windows; Dwaine Snow, IBM senior product manager; and Alice Ma, IBM Information Management DB2 Tools Specialist for this one-hour complimentary Webcast and find out how you can take back control of your database environment. * DB2 9: Automatic Database Configuration and Memory TuningReplay of this Chat held on July 20, 2006 is now available.IBM has been a pioneer in autonomic computing. A number of self-configuring, self-optimizing, and self-healing capabilities were introduced in the earlier DB2 releases. DB2 9 continues along this strategy of helping you derive more value from your data, while spending less time managing it. This new version contains revolutionary features like self-tuning memory and automatic configuration of newly created databases. These autonomic features are designed to make database administration effortless, improve administrator productivity, and lower ownership costs.
Join Sal Vella, VP of DB2 development, and Adam Storm, DB2 autonomic computing developer, for an in-depth look at some of the new autonomic capabilities in DB2 9. * DB2 9: Using Data Compression to Cut CostsReplay of this Chat held on June 15, 2006 is now available.Disk storage systems can often be the most expensive components of a database solution. For large warehouses or databases with huge volumes of data, the cost of the storage subsystem can easily exceed the combined cost of the hardware server and the data server software. Therefore even a small reduction in the storage subsystem can result in substantial cost savings for the entire database solution. Data row compression in DB2 9 is a remarkable new feature that can reduce storage requirements, improve I/O efficiency, and result in savings of up to 80%.
Join Sal Vella, VP of DB2 Development, Bill Minor, DB2 Development Manager, and Chris Eaton, DB2 Product Manager, to take you through a deep dive into DB2 9's compression technology and its impact for your business. * DB2 9: Range Partitioning and Large RID supportReplay of this Chat held on May 24, 2006 is now available.DB2 9 contains innovative features for delivering information on demand and scaling databases to new levels. The Table (Range) Partitioning capabilities in DB2 9 provide a number of advantages including better query performance, improved large table manageability, and dynamic data roll-in/roll-out. The Large Row Identifier (RID) allows for creation of tables and indexes that are terabytes in size. Together these features enable the ability to create and easily manage databases with virtually unlimited capacity, and are especially beneficial in large data-warehousing environments. Join Sal Vella, VP of DB2 Development, and Matt Huras, IBM Distinguished Engineer and lead DB2 Architect, for an in-depth look at the new Table Partitioning and Large RID support in DB2 9 on Linux, UNIX, and Windows. * DB2 9 OverviewReplay of this Chat held on April 6, 2006 is now available.DB2 9 is the code-name for a new version of DB2 due out in summer 2006 that introduces numerous innovations to help organizations realize the business value of information. These innovations include the industry’s first hybrid data server - serving data from both pure relational and pure XML structures. DB2 9 also includes other compelling enhancements such as additional optimizations for powering SAP faster with lower cost than alternatives, new storage optimization advances that will dramatically reduce storage costs, and advanced security capabilities to control access and meet compliance requirements.
Join Sal Vella, VP of DB2 Development, and Peter Kohlmann, Senior DB2 Product Manager, from the IBM Toronto Lab to learn about the exciting new capabilities available in DB2 9 on Linux, UNIX, and Windows platforms and understand:* How DB2 9 leads the way in providing Information as a Service* How DB2 9 helps you manage your business, not your database* How DB2 9 is part of an agile development environment, and* How DB2 9 is even more secure and resilient
svisser1 2700018UK9 2,651 Views
Rav Ahuja put together the Voice of the DB2 Community - Podcast series that I wanted to tell you about. It includes interviews and discussions on topics vital to DB2 for Linux, UNIX, and Windows. The interviews are with technical leaders, users, and business partners, who offer their expert insights and discuss technology innovation and evolution.
Here are the topics that you will find on the site at this time:
DB2 9 Strategy and Overview [9 Nov 2006, 15 min, 5.2MB] Chief DB2 Architect, Tim Vincent, discusses DB2 9 strategic priorities and introduces the key features in this most significant version of DB2 for Linux, UNIX, and Windows. Tim also gives a sneak preview into the future of DB2.
Related resources: Webcast: DB2 9 Overview White paper: Introducing DB2 9 DB2 9 Certification [16 Nov 2006, 5 min, 1.8MB] Heather Ramsey, Training and Certification Program Manager, talks about the roadmap and the resources available for getting DB2 9 certified.
Related resources: Website: Prep for DB2 9 administration certification Quest Toad for DB2 [23 Nov 2006, 5 min, 1.7MB] Jim Wankowski and Amit Agarwal, technology specialists at Quest Software, discuss Toad for DB2, a database development and administration tool.
Related resource: Website: Toad for DB2 DB2 9 pureXML usage scenarios [27 Nov 2006, 6min, 2MB] Matthias Nicola from the DB2 team in IBM Silicon Valley Lab talks to the common use cases for DB2 9 pureXML technology, including a couple of industry specific scenarios.
Related resources: Webcast: DB2 9: Unlock your XML PotentialRedbook: DB2 9 pureXML Guide DB2 9 Table Partitioning overview [28 Nov 2006, 5min, 1.8MB] Kevin Beck from the DB2 development team explains how this new DB2 9 feature can be used for partitioning data using range values and simplify roll-in and roll-out.
Related resources: Webinar: DB2 9 Range Partitioning and Large RID Support Article: Introducing Table Partitioning in DB2 9
Enjoy listening... instead of reading, for a change!Susan[Read More]
svisser1 2700018UK9 2,722 Views
A friend / co-worker of mine has just self-published a book about her dog, Dylan. The book is filled with humourous stories about Dylan when he was a puppy. Lots of photos too! I haven't received my copy yet, but I'm quite impressed with the comments posted on amazon:
Dylanisms - Short Stories About a Dog by Ellice D. Uffer[Read More]
svisser1 2700018UK9 2,472 Views
Pearson Education, the publisher for the latest IBM Press book, Understanding DB2 9 Security has just issued an online coupon for this book, and I wanted to let you know first:
Coupon Expires: June 30, 2007Use code BOND5907 during the checkout step.Discount: 35% offISBNs: 0131345907 Understanding DB2 9 Security
If you've read the book and liked it, post here or in amazon to let others know!
svisser1 2700018UK9 3,521 Views
Here's another very long list for you.... this one lists all of the tutorials that were created on dWorks in the past year. Tutorials are very popular learning resources and they now cover most of our product areas. Check them out, or pass this information onto someone who you think would benefit from finding these learning materials.
Data Servers Cross Product The ultimate mashup, Part 6: Give the user control DB2 9 Fundamentals exam 730 prep, Part 1 DB2 9 Fundamentals exam 730 prep, Part 2 DB2 9 Fundamentals exam 730 prep, Part 3 DB2 9 Fundamentals exam 730 prep, Part 4 DB2 9 Fundamentals exam 730 prep, Part 5 DB2 9 Fundamentals exam 730 prep, Part 6 DB2 9 Fundamentals exam 730 prep, Part 7DB2 XML evaluation guide DB2 EveryplaceBuild end-to-end DB2 Everyplace mobile applications
DB2 for LUWDB2 9 table partitioningHello World, Part 7: DB2 for Linux, UNIX, and WindowsDevelop proof-of-concept .NET applications, Part 5: Create and consume Web services Kick-start takes you to the movies, Part 2 DB2 9 self-tuning memory management Shrink your database using DB2 9 row compressionDB2 Developer Workbench, Part 3: Developer Workbench and XMLThe ultimate mashup, Part 5: Change out Web servicesInformation on Demand Global Conference Web 2.0 Personal PlannerKick-start your J2EE apps using DB2 9 with pureXML and WebSphereSet up an SQL realm with DB2 Express-C, and WebSphere DB2 Developer Workbench and stored proceduresCreate XML-based stored procedures using the DB2 Developer WorkbenchSQL and XQuery tutorial for IBM DB2, Part 7: XML and XQuerySQL and XQuery tutorial for IBM DB2, Part 5: Data comparison SQL and XQuery tutorial for IBM DB2, Part 6: Data definition language and data control language The ultimate mashup, Part 1: Use and combine Web servicesDevelop a personal movie database app based on PHP and DB2 Create an XML-based Java application using DB2 9SQL & XQuery tutorial for IBM DB2, Part 4: Data analysisDB2 Developer Workbench concepts and basic tasksSQL & XQuery tutorial for IBM DB2, Part 3: Joins and unionsWire your application to DB2 pureXML data (Part 4)SQL & XQuery tutorial for IBM DB2, Part 1: Introduction to Aroma and SQLSQL & XQuery tutorial for IBM DB2, Part 2: Basic queriesDocument-level security using DB2 9 pureXML and LBAC DB2 9 DBA certification exam 731 prep, Part 1 DB2 9 DBA certification exam 731 prep, Part 2 DB2 9 DBA exam 731 prep, Part 3 DB2 9 DBA exam 731 prep, Part 4 DB2 9 DBA exam 731 prep, Part 5 DB2 9 DBA exam 731 prep, Part 6 DB2 9 DBA exam 731 prep, Part 7 Develop proof-of-concept .NET applications, Part 2 Develop proof-of-concept .NET applications, Part 3 Tutorial: DB2 label-based access control, a practical guide, Part 2: A step-by-step guide to protect sensitive data using LBAC Create database objects in DB2 Viper using .NET Integrate DB2 Express-C in apps with ActiveGrid LAMP StudioTutorial: Build Web services using IBM Database Add-ins for Visual Studio 2005: Highlights of the refreshDevelop DB2 applications using persistence-based frameworksDB2 and Rational: Working together, Part 2 Tutorial: Develop and test SQLJ programs for DB2 using Rational Application Developer Developing DB2 UDB User Defined Functions with .NET
DB2 for z/OSCreate z/OS procedures with Database Add-Ins for Visual Studio 2005
IMSIntegrate an IMS transaction into a Business Process Execution Language process
Classics/4GL/EGLCut out the Middle-Man: Use Informix Dynamic Server with J/Foundation to host a Java application service
CloudscapeApache Derby resources from the Web services perspective, Part 2: Producing and consuming WS-Notifications with DerbyApache Derby resources from the Web services perspectiveGet a head start with JDBC 4.0 using Apache Derby
U2A Hitchhiker's Guide to the UniVerse, Part 4: File and performance implicationsA Hitchhiker's guide to the UniVerse, Part 3Travels with Mark: A Hitchhiker's Guide to the UniVerse, Part 2: Sizing hashed files in UniVerse
Content ManagerContent Manager V8.3 Certification Exam TutorialsSearch legacy data sources
Document ManagerGet started with DB2 Document Manager, Part 2DB2 Document Manager: Build a simple client application (Tutorial)
OmniFind Discovery ServerStore selected OmniFind analysis results to a relational database
OmniFind Enterprise EditionSemantic search in IBM OmniFind Enterprise Edition, Part 2
DataStageIntegrated access to application data
Information IntegratorFederation Configuration Wizard
MDM-WebSphere Product CenterWebSphere Product Center - First steps
svisser1 2700018UK9 2,664 Views
I was just reminded yesterday about a blog entry that I read early last year about the book Understanding DB2(R): Learning Visually with Examples. The entry was from James F. Koopmann. The statement that I found most interesting was this:
Now it has been close to 15 years since I worked with DB2 on MVS and have over the years wanted to pick up DB2 again. But having enough time to pull away from Oracle and all the projects I seem to be doing never really gave me the opportunity. Honestly I can say that I am glad I waited. If I would have started with any other book instead of Understanding DB2 I may have gotten discouraged.
One of the best parts of reading this book was that it went into just enough detail for experienced database practitioners to obtain a clear understanding of the components of DB2. Often I was able to easily relate my Oracle, and old DB2 experience, to the concepts in this book. This made learning even easier. This is no easy. I am not even sure that the authors of this book sought out to do. But I can tell you from experience that I have in the past tried to relate database systems, such as Oracle, DB2, SQL Server, and Sybase, together and it is not an easy task to find the information needed. This book cuts through the chase and quickly and easily points out the physical and logical components of DB2 that now allows me to do this.
One of our training courses that was created specifically for those trained on other relational databases has been recently update and is another good way to expand existing skills to include DB2: CF282 Fast Path to DB2 9 for Experienced Relational DBA * Classroom * 3 Days *
svisser1 2700018UK9 2,719 Views
I started my career in database as a technical writer working on the Toronto Information Development team. This is the team of people who create the documentation that is available to support the product in manuals and online help. The team of people has changed much since I left 9 years ago... and the sheer volume of information that the team creates is incredible! I hope the job is as much fun now as it was during my 6 years.
(Interesting side note: One of the technical writers who is back on the team on an assignment is sci-fi author Karl Schroeder. Welcome back Karl!)
To see of list of the manuals that are available to support DB2 9, click List of DB2 Manuals. Here is the large number you can select from :
Release Notes * Release Notes for Fix Pack 1 * Net Search Extender Release Notes
Getting started * What's New * Quick Beginnings for DB2 Clients * Quick Beginnings for DB2 Servers * Getting started with DB2 installation and administration on Linux and Windows * Migration Guide
Administration * Administration Guide: Planning * Administration Guide: Implementation * Data Movement Utilities Guide and Reference * Data Recovery and High Availability Guide and Reference * National Language Support Guide and Reference * Performance Guide * Query Patroller Administration and User's Guide * Spatial Extender and Geodetic Data Management Feature User's Guide and Reference * System Monitor Guide and Reference * Troubleshooting Guide * XML Guide
Application development * Getting Started with Database Application Development * Developing ADO.NET and OLE DB Applications * Developing Embedded SQL Applications * Developing Java Applications * Developing Perl and PHP Applications * Developing SQL and External Routines * XML Extender Administration and Programming
Reference * Administrative API Reference * Administrative SQL Routines and Views * Call Level Interface Guide and Reference Vol.1 * Call Level Interface Guide and Reference Vol.2 * Command Reference * Precompiler Services APIs * Message Reference Vol.1 * Message Reference Vol.2 * SQL Reference Vol.1 * SQL Reference Vol.2 * XQuery Reference
Tutorial * DB2 Visual Explain Tutorial
Additional component information * DB2 Connect * Quick Beginnings for DB2 Connect Servers * Quick Beginnings for DB2 Connect Personal Edition * DB2 Connect User's Guide * IBM WebSphere Information Integration * Administration Guide for Federated Systems * ASNCLP Program Reference for Replication and Event Publishing * Configuration Guide for Federated Data Sources * SQL Replication Guide and Reference
Of course the standard these days is to deliver PDF versions of the manuals, but for those of you who like to have a printed copy sitting on your desk for easy access, you can buy printed / bound copies (in many but not all countries or regions) from the IBM Publications Center.
To order printed DB2 manuals: Order Printed DB2 Manuals.[Read More]
svisser1 2700018UK9 2,871 Views
Happy New Year to Everyone!
A series of new certification roadmaps have been created to help you find your way around the latest exams that are available to support the newest product releases for Information Management Software.
This series of certification roadmaps will help you define and map out your certification path for a variety of job-related certifications for our Information Management software products.
These roadmaps are designed to provide a comprehensive, concise view of all the exams and roles available as well as provide you with the most efficient path to achieve the various levels of certification. Once you earn one or more of these certifications, you earn the right to display the Information Management professional certification mark.
The roadmaps fall into the following categories:
Content Management and Discovery Content Manager V8.3 => Exam 443 Content Management On Demand => Exam 444 Content Management Document Manager => Exam 445 (currently under development) DB2 9 Family Fundamentals => Exam 730 Database Administration for DB2 on Linux, Windows and UNIX => Exam 731 Database Administration for DB2 on z/OS => Exam 732 (currently under development) Application Development => Exam 733 (currently under development) Advanced Database Administration => Exam 734 (currently under development)
Dynamic Data Warehousing and Business Intelligence IBM Alphablox => Exam 715 Business Intelligence Solutions => Exam 705 DB2 Data Warehouse Edition => Exam 716 Information Integration Websphere IIS QualityStage V7.5 => Exam 416 WebSphere IIS DataStage Enterprise Edition V7.5 => Exam 415 Informix Informix Dynamic Server V9 => Exam 915 Informix 4GL V10 => Exam 917 Red Brick™ Warehouse => Exam 914 U2 U2 Family => Exam 713 UniVerse V10 => Exam 714 UniData V6.1 => Exam 711 To access the roadmaps, click Certification Roadmaps
I hope that the new year brings you and your family much joy, laughter and love.
svisser1 2700018UK9 2,719 Views
With the end of the year come lists… lists of all the accomplishments made throughout the year. A few posts ago I listed all of the retail books that were published in 2006. This post lists the redbooks that published this year… and what a list! Thirty books that span the wide range of topics in the Information Management area. I’m sure there is a book that would be valuable to you and others you know.
Congratulations to everyone who was involved in producing these 30 books. No small feat!
DB2 9: pureXML Overview and Fast Start
DB2 Express-C: The Developer Handbook for XML, PHP, C/C++, Java, and .NET
Developing PHP Applications for IBM Data Servers
DB2 Performance Expert for Multiplatforms V2.2
Coupling Facility Performance: A Real World Perspective
IBM DB2 Recovery Expert for Multiplatforms V2 Usage Guide
Powering SOA with IBM Data Servers
LOBs with DB2 for z/OS: Stronger and Faster
DB2 Recovery Expert for z/OS User Scenarios
Data Integrity with DB2 for z/OS
WebSphere Replication Server for z/OS Using Q Replication: High Availability Scenarios for the z/OS Platform
Disk storage access with DB2 for z/OS
DB2 UDB for z/OS: Design Guidelines for High Performance and Availability
A Deep Blue View of DB2 Performance: IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS
Leveraging DB2 Data Warehouse Edition for Business Intelligence
Improving Business Performance Insight . . . with Business Intelligence and Business Process Management
Dimensional Modeling: In a Business Intelligence Environment
Stored Procedures, Triggers, and User-Defined Functions on DB2 Universal Database for iSeries
The Ins and Outs of XML and DB2 for i5/OS
Preparing for and Tuning the SQL Query Engine on DB2 for i5/OS
SQL Performance Diagnosis on IBM DB2 Universal Database for iSeries
Moving Forward with the On Demand Real-time Enterprise
How does the MIDAW facility improve the performance of FICON channels using DB2 and other workloads?
Performance Tuning for Content Manager
Content Manager OnDemand Guide
Content Manager Implementation and Migration Cookbook
WebSphere Replication Server Using Q Replication High Availability Scenarios for the AIX Platform
IBM DB2 Document Manager with IBM Records Manager Solution Guide
E-mail Archiving and Records Management Integrated Solution Guide Using IBM DB2 CommonStore and DB2 Records Manager
IMS Connectivity in an On Demand Environment: A Practical Guide to IMS Connectivity
Publishing IMS and DB2 Data using WebSphere Information Integrator: Configuration and Monitoring Guide[Read More]