Come and Join our Party!
As you have likely seen already.... DB2 turned 25 this year! 25 years as a provider high performance, reliable and secure data servers.
IBM will be hosting birthday parties at the following events:
* IDUG 2008 Europe — October 13-17, 2008* IBM Information On Demand Global Conference — October 26-31, 2008
Register now for a party and collect your free e-ticket. Limited tickets are available.
Keep on Learning
For anyone who was at the IOD Conference last year in Las Vegas' Mandalay Bay, you'll remember how **tired** you were after walking the large distances! Do you want an interesting strategy to deal with the strain your poor legs and back will be under?
If you get certified at the conference or were previously certified, you are welcome to join the Certification Lounge. The Lounge will once again be featuring tables, chairs, food, beverages, and best of all.... free massages. We want to ensure that you are specially rewarded for earning your certification.
Prepare in advance to make sure that you can begin using the certification lounge from day 1:
Each exam has a time limit of 90 minutes, except the upgrade exam which has a time limit of 60 minutes. The number of questions and the cutscore for each exam varies. For example, exam 730 has 64 questions and you must score 59 percent or higher to pass it.
How do I prepare to pass an exam?Here is the recommended path I suggest you take to prepare for a DB2 exam:
1) Choose the exam you want to take based on your job role. The DBA and AppDev certifications first require that you are certified as a Database Associate. To help you decide where to start, see the certification roadmaps: ibm.com/software/data/education/cert-roadmaps.html.
2) Read through the exam objectives. Every question on the exam relates directly to one or more of the exam objectives. For a breakdown of the exam objectives and the recommended study materials, see ibm.com/software/data/education/certprep.html
Here are the exams that cover the DB2 9 product: * Exam 730 - DB2 9 Fundamentals
* Exam 731 - DB2 9 DBA for Linux, Unix, and Windows
* Exam 732 - DB2 9 DBA for z/OS
* Exam 733 - DB2 9 Application Developer
* Exam 734 - DB2 9 Advanced DBA for Linux UNIX and Windows
* Exam 735 - DB2 9.5 Developer. Although not specifically written for this exam, the book 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) might help you prepare for this exam.
* Exam 736 - DB2 9 Database Administrator for Linux UNIX and Windows Upgrade. See also Kate's blog entry about the upgrade exam!
3) If you are experienced with DB2 and feel that you are prepared to pass the exam based on what you saw in the exam objectives, take an assessment exam: ibm.com/software/data/education/cert/assessment.html. You'll get a report after taking the assessment exam that can help you pinpoint your weaknesses. Assessment exams cost $10 per take, so if you really think you are ready, come and take the exam to see.
4) If you are NOT experienced with DB2, download a free version of DB2 Express-C and give it a try!
5) Decide on how you want to increase your skills: a) Consider buying one of the Certification Study Guides to refresh and deepen your skills: ibm.com/software/data/education/bookstore.
For exam prep, the best books are these:DB2 9 Fundamentals Certification Study Guide by Roger SandersDB2 9 Database Administration Certification Study Guide for Exam 731 by Roger Sanders DB2 9 Database Administration Certification Study Guide for Exam 732 by Susan Lawson and Daniel Luksetich DB2 9 Database Administration Upgrade Certification Study Guide for Exam 736 by Roger SandersDB2 9 Advanced Database Administration Certification Study Guide for Exam 734 by Roger Sanders and Dwaine Snow.
All five of these certification prep guides were written by members of the exam development team. That is, they created the questions for the certification exam that you are about to take! Also, each chapter of the book corresponds directly to a section on the exam. So, if you take the assessment exam and find out that you are week on a single topic, you simply need to read the chapter that corresponds to the topic where you need improvement. Lastly, the authors created a set of sample questions for the book that provides you with the correct answer to the question as well as an explanation as to why the correct answer is correct and the incorrect ones are not.
For reference and guidance beyond the exam, I suggest the following: DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition) by George Baklarz and Paul Zikopoulos
b) For self-study, also check out the free tutorials that IBM provides for most of the exams. The tutorials are broken into hour long segments of information based on the exam objectives. If you have a great deal of experience, this may be all you need to prepare for the exam. To see the full set of exam prep tutorials that are available, see ibm.com/software/data/education/selfstudy.html.
c) Take an education class from IBM or one of its partners. These classes typically have a fee, even for employees, so check with management to see if you can take one of these classes. Classroom education is an excellent way to learn, but may be difficult to justify due to costs. Don't forget to look into ILO training as this type of training gives you all the benefits of classroom education, but eliminates the travel costs. The best place to start to determine the classroom education that best fits your needs is with the training roadmaps: ibm.com/software/data/education/roadmaps.html.
d) Take a pre-conference class at the ILO Conference:
DB2 for z/OS DBA Certification Crammer (Exam 732)
Speaker: Susan Lawson
This high level certification preparation review is intended to help you take IBM Certification Test 732, DB2 9 DBA for z/OS. Gain an intense overall review of those areas that are on the certification exam.
DB2 9 for Linux & Windows DBA Certification Crammer (Exam 731)
Speaker: Roger Sanders
This training is designed to introduce the student to the concepts a test candidate must know in order to take and pass the DB2 9 DBA for Linux, UNIX, and Window certification exam (Exam 731). The material for this course is aligned with the 731 exam objectives.
6) If this is your first time taking a certification exam, review the steps on this site: ibm.com/certify/process/t_proc.shtml.
Can I gain experience by reading DB2 Forums and Blogs? Absolutely! There are several DBAs who firmly believe helping out on the various forums have helped us gain a deeper understanding of subjects that were on the exams. So, contribute to those forums. You're not only helping other people, you're helping yourself as well! Most likely you'll find members of the DB2 development team actively taking part in the forums as well.
Here are the sites that I recommend, at the least:Planet DB2 - a blog aggregator that combines DB2 blogs from around the world.IBM developerWorks - DB2 PortalIDUG – International DB2 User’s GroupMy blog: ibm.com/developerworks/blogs/page/susanvisserKate's blog: ibm.com/developerworks/blogs/page/katedawson
Enjoy the lounge!
Earlier this week I blogged about the TDD Workshop that Justin Gordon is running tomorrow (July 25) in Chicago: link. I have a recommended book list to go with this session:
xUnit Test Patterns: Refactoring Test Code (The Addison-Wesley Signature Series) by Gerard Meszaros
Automated testing is a cornerstone of agile development. An effective testing strategy will deliver new functionality more aggressively, accelerate user feedback, and improve quality. However, for many developers, creating effective automated tests is a unique and unfamiliar challenge.
xUnit Test Patterns is the definitive guide to writing automated tests using xUnit, the most popular unit testing framework in use today. Agile coach and test automation expert Gerard Meszaros describes 68 proven patterns for making tests easier to write, understand, and maintain. He then shows you how to make them more robust and repeatable--and far more cost-effective.
Loaded with information, this book feels like three books in one. The first part is a detailed tutorial on test automation that covers everything from test strategy to in-depth test coding. The second part, a catalog of 18 frequently encountered "test smells," provides trouble-shooting guidelines to help you determine the root cause of problems and the most applicable patterns. The third part contains detailed descriptions of each pattern, including refactoring instructions illustrated by extensive code samples in multiple programming languages.
Topics covered include:# Writing better tests--and writing them faster# The four phases of automated tests: fixture setup, exercising the system under test, result verification, and fixture teardown# Improving test coverage by isolating software from its environment using Test Stubs and Mock Objects# Designing software for greater testability# Using test "smells" (including code smells, behavior smells, and project smells) to spot problems and know when and how to eliminate them# Refactoring tests for greater simplicity, robustness, and execution speed
This book will benefit developers, managers, and testers working with any agile or conventional development process, whether doing test-driven development or writing the tests last. While the patterns and smells are especially applicable to all members of the xUnit family, they also apply to next-generation behavior-driven development frameworks such as RSpec and JBehave and to other kinds of test automation tools, including recorded test tools and data-driven test tools such as Fit and FitNesse.
Working Effectively with Legacy Code (Robert C. Martin Series) by Michael Feathers
Get more out of your legacy systems: more performance, functionality, reliability, and manageability
Is your code easy to change? Can you get nearly instantaneous feedback when you do change it? Do you understand it? If the answer to any of these questions is no, you have legacy code, and it is draining time and money away from your development efforts.
In this book, Michael Feathers offers start-to-finish strategies for working more effectively with large, untested legacy code bases. This book draws on material Michael created for his renowned Object Mentor seminars: techniques Michael has used in mentoring to help hundreds of developers, technical managers, and testers bring their legacy systems under control.
The topics covered include:# Understanding the mechanics of software change: adding features, fixing bugs, improving design, optimizing performance# Getting legacy code into a test harness# Writing tests that protect you against introducing new problems# Techniques that can be used with any language or platform—with examples in Java, C++, C, and C## Accurately identifying where code changes need to be made# Coping with legacy systems that aren't object-oriented# Handling applications that don't seem to have any structure
This book also includes a catalog of twenty-four dependency-breaking techniques that help you work with program elements in isolation and make safer changes. Next Generation Java Testing: TestNG and Advanced Concepts by Cédric Beust and Hani Suleiman
Enterprise Java developers must achieve broader, deeper test coverage, going beyond unit testing to implement functional and integration testing with systematic acceptance. Next Generation Java™ Testing introduces breakthrough Java testing techniques and TestNG, a powerful open source Java testing platform.
Cédric Beust, TestNG's creator, and leading Java developer Hani Suleiman, present powerful, flexible testing patterns that will work with virtually any testing tool, framework, or language. They show how to leverage key Java platform improvements designed to facilitate effective testing, such as dependency injection and mock objects. They also thoroughly introduce TestNG, demonstrating how it overcomes the limitations of older frameworks and enables new techniques, making it far easier to test today's complex software systems.
Pragmatic and results-focused, Next Generation Java™ Testing will help Java developers build more robust code for today's mission-critical environments.
This book: # Illuminates the tradeoffs associated with testing, so you can make better decisions about what and how to test# Introduces TestNG, explains its goals and features, and shows how to apply them in real-world environments# Shows how to integrate TestNG with your existing code, development frameworks, and software libraries# Demonstrates how to test crucial code features, such as encapsulation, state sharing, scopes, and thread safety# Shows how to test application elements, including JavaEE APIs, databases, Web pages, and XML files# Presents advanced techniques: testing partial failures, factories, dependent testing, remote invocation, cluster-based test farms, and more# Walks through installing and using TestNG plug-ins for Eclipse, and IDEA# Contains extensive code examples
Whether you use TestNG, JUnit, or another testing framework, the testing design patterns presented in this book will show you how to improve your tests by giving you concrete advice on how to make your code and your design more testable.
Test Driven: TDD and Acceptance TDD for Java Developers by Lasse Koskela
In test driven development, you first write an executable test of what your application code must do. Only then do you write the code itself and, with the test spurring you on, you improve your design. In acceptance test driven development (ATDD), you use the same technique to implement product features, benefiting from iterative development, rapid feedback cycles, and better-defined requirements. TDD and its supporting tools and techniques lead to better software faster.
Test Driven brings under one cover practical TDD techniques distilled from several years of community experience. With examples in Java and the Java EE environment, it explores both the techniques and the mindset of TDD and ATDD. It uses carefully chosen examples to illustrate TDD tools and design patterns, not in the abstract but concretely in the context of the technologies you face at work. It is accessible to TDD beginners, and it offers effective and less well known techniques to older TDD hands.
What's Inside:# Learn hands-on to test drive Java code# How to avoid common TDD adoption pitfalls# Acceptance test driven development and the Fit framework# How to test Java EE components-Servlets, JSPs, and Spring Controllers# Tough issues like multithreaded programs and data access code
Refactoring Databases: Evolutionary Database Design by Scott Ambler and Pramodkumar J. Sadalage
Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility, and performance. Now, for the first time, leading agile methodologist Scott Ambler and renowned consultant Pramodkumar Sadalage introduce powerful refactoring techniques specifically designed for database systems.
Ambler and Sadalage demonstrate how small changes to table structures, data, stored procedures, and triggers can significantly enhance virtually any database design–without changing semantics. You’ll learn how to evolve database schemas in step with source code–and become far more effective in projects relying on iterative, agile methodologies.
This comprehensive guide and reference helps you overcome the practical obstacles to refactoring real-world databases by covering every fundamental concept underlying database refactoring. Using start-to-finish examples, the authors walk you through refactoring simple standalone database applications as well as sophisticated multi-application scenarios. You’ll master every task involved in refactoring database schemas, and discover best practices for deploying refactorings in even the most complex production environments.
The second half of this book systematically covers five major categories of database refactorings. You’ll learn how to use refactoring to enhance database structure, data quality, and referential integrity; and how to refactor both architectures and methods. This book provides an extensive set of examples built with Oracle and Java and easily adaptable for other languages, such as C#, C++, or VB.NET, and other databases, such as DB2, SQL Server, MySQL, and Sybase.
Using this book’s techniques and examples, you can reduce waste, rework, risk, and cost–and build database systems capable of evolving smoothly, far into the future.
svisser1 2700018UK9 3,714 Views
Leon's blog post just made me aware of this Consumability Survey for Information Management products.
The Consumability Survey was designed to gain insight into your business priorities and experiences with IBM software. It will take approximately 30 minutes to complete and must be completed in one session. The survey allows you to provide your input based on your experience and priorities for 31 product characteristics. You are then given the opportunity to prioritize those areas that matter most according to the demands of your business. When answering the survey, please be as specific as possible so that we can take appropriate actions to improve the product. At the survey Web site, please enter the optional invitation code: IMSOFTWARE.
You may wonder, what is consumability? The term is used to describe the difference between a product that works and one that makes your work easier, such as:
* How easily you were able to find the product that matched your business needs* How quickly you installed and configured the product to your environment* How well the product fulfilled its function within your organization* How efficiently the product suited your organization's usage on a daily basis* How easily you were able to derive business value from the product on a long-term basis
By taking the participating in our Consumability Survey, you're helping IBM focus on improving our software in ways that make the difference to your success.
See instructions in Leon's blog post if you want to provide feedback for DB2 Express-C.
Your opinion is very important to us, so thanks in advance for taking the survey.
IBM Data Studio software is a revolutionary approach to managing data and data-centric applications throughout the lifecycle, from requirements to retirement.
Read the overview article by Holly Hayes that explains both the vision and reality of Data Studio and how you -- whether a data architect, developer or tester, DBA, or data steward -- can use Data Studio today to improve productivity, increase quality of service, and encourage greater alignment across IT roles.
I've recently "met" Justin Gordon who is now working on writing a book for Addison-Wesley. Justin sent me this information about a workshop he is running this coming Friday and I thought I'd send it along for anyone who may be interested .
Test Driven Development (TDD) Workshop
When: July 25th, 2008 10AM to 3PMWhere: Chicago Innovation Center – 71 Wacker – Room 6612Web Conference details: DetailsWho Should Attend: GBS developers or other IBMersHow Much: FreePresenters: Justin Gordon & Donald BellRSVP: Not required, but RSVP is recommended a download will be required for labs exercises
Description:A comprehensive suite of unit tests is the single most important artifact created in a software project because it reduces bugs, facilitates adding new developers, and enables refactoring and performance tuning with confidence. Test-driven development (TDD) is the best way to build a test suite. Justin will discuss this assertion and address practical issues encountered on test-driven projects, including: How to get team members to adopt TDD on a project; how to implement TDD on a project with large amounts of existing untested legacy code, tooling, design patterns to facilitate TDD, including mock objects, dependency location, and the Dependent Object Framework. These techniques solve the difficult technical problems of isolating code to be tested and setting up required persistent data. For example, have you ever worked on a large enterprise software project (one that heavily uses a database) and wanted to add JUnit tests? And did you quickly realize that it’s easier said than done? Why is that? Want to learn a better way? Justin created the open source project "Dependent Object Framework" (DOF) to solve just this problem.
The discussion will cover the same material that Justin is presenting at Dr. Dobbs Architecture and Design World on July 24 and previously presented at Dr. Dobbs SD West in Santa Clara this past March. The lecture and exercises will work as follows:1. Justin will explain the concepts in the slides2. To illustrate the concepts, Justin will be doing a “pair-programming” session with Donald and the audience. Members of the audience will be able to run some of the JUnit tests along with Justin.3. The audience will have an opportunity after the led discussion to add some additional JUnit tests for the exercises, getting tips from Justin and Donald on both JUnit, TDD, and use of Rational Team Concert. Download Workshop MaterialsMaterials should be downloaded before. Check website after July 22nd
Agenda (all times central time)10:30 to 12:00 – Introduction to Test Driven Development (motivation, basic techniques)12:00 to 12:30 – Break (Optional)12:30 to 2:00 – Advanced TDD – TDD with dependencies and the Dependent Object Framework (DOF) 2:00 to 3:00 – Lab Exercises with assistance from Justin and Donald (chance to add JUnit tests to the ones that Justin and Donald setup earlier)
Note: Lunch is not provided, feel free to bring your own lunch.
Remote Attendance DetailsAudio Conference Access NumbersToll: 1-770-615-1258Toll Free: 1-877-421-0528ITN: 2421-0528Passcode: 144034
Web Conference DetailsURL Password: workshop4you
Thanks to Justin for forwarding this to me. Justin, congratulations on the birth of your very cute baby boy!
Carlton Doe's long awaited IDS book is near completion. It is so near completion that you can find it listed on amazon.com now... with a hefty pre-order discount:
Administering Informix Dynamic Server: Building the FoundationList Price: $59.95Price: $37.77 & this item ships for FREE with Super Saver Shipping. You Save: $22.18 (37%)
Carlton's previous published books, Informix Dynamic Server Handbook and Administering Informix Dynamic Server on Windows NT are 11 and 9 years old, respectively.
Except for the two "flashbooks" that Carlton published via IBM, no other IDS books have made it to the bookstores! You'll be happy to learn that there is a certification guide in the works as well as a possible second book from Carlton (with more advanced material).
Here is an online version of the first flashbook that introduced IDS 11: IBM Informix Dynamic Server 11: The Next Generation in OLTP Data Server Technology. The second smaller one that introduced 11.5 will be available for free at the IOD Conference.
What's in the new book:
Geared towards database server administrators who need to get a server up and running in a short amount of time, this guide focuses on the basic skills required to administer and maintain the Informix Dynamic Server (IDS) data server. Each of the major functional areas of the database server are reviewed, including designing, initializing, monitoring, building availability layers, securing data, and the data processing environment. This book reviews how the IDS works, how to install it, how to configure a database environment, back up, recovery, and includes an introduction to monitoring instance operations, making it useful to current IDS users who need to upgrade from earlier versions of the data server as well as those who have never used IDS before.
Table of Contents:Chapter 1 – Introduction to Informix Dynamic ServerThis chapter covers the general design of the IDS data server. Terms and keywords used extensively throughout the rest of the book are introduced and defined here.
Chapter 2 – An Introduction to ExtensibilityThis chapter explores the object-relational features and capabilities of Informix Dynamic Server.
Chapter 3 – Preparing for InitializationIn this chapter, Carlton covers many of the topics you need to address from a design perspective when planning for the implementation of an IDS environment. For the most part, the discussion is general in scope because there are few hard and fast rules to follow when building a database environment. Where rules do exist, they are stated. At the close of the chapter, Carlton explains the required environment variables, files, and other objects as well as how to set them up.
Chapter 4 – Installing and Initializing IDSThis chapter covers all the steps and configuration parameters for creating an IDS database environment or instance, with specific recommendations given for the most critical configuration parameters. At the end, Carlton introduces the system-level databases that manage and control an IDS environment.
Chapter 5 – Basic Administrative TasksIn this chapter, Carlton explains most of the general day-to-day, or occasional, instance-oriented administrative tasks. These include adding or dropping disk space, starting up or shutting down the instance, and killing user sessions in the instance. The major graphical administration tools are introduced as an alternative to performing many of these tasks using the command line.
Chapter 6 – Building a Database EnvironmentIn this chapter, Carlton trades his DSA’s hat for that of a DBA and covers building and populating databases in IDS instances. The chapter explains features such as table and index partitioning, constraints, logging, database and table population utilities, and a collection of IDS-specific SQL statements that Carlton thinks are interesting to know about and use.
Chapter 7 – Backing Up and RestoringOne of the least glamorous, but still important, functions of operating a database environment is backing up what’s on disk to tape. In this chapter, Carlton covers a couple of backup strategies and their relative strengths and weaknesses. He explains how Informix Dynamic Server can execute moment-in-time backup and restore operations with the database environment online and fully functioning. The process of executing backup and restore operations using the ontape utility, as well as the ON-Bar utility suite in conjunction with the Informix Storage Manager (ISM), is covered in great detail.
Chapter 8 – Monitoring the InstanceThroughout the book, discussions make reference to, and include illustrations of, output generated by the various IDS monitoring commands. In this chapter, Carlton focuses exclusively on those commands and some of the more commonly monitored activities of a database environment. He concentrates primarily on IDS’s command-line utilities as well as the functionality available in the new OpenAdmin Tool for IDS (OAT).
For those of you who don't know Carlton, here's his bio and website:
Carlton Doe is one of the five founders of the International Informix Users Group (IIUG) and has served as the IIUG president. He is the author of Administering Informix Dynamic Server on Windows NT and Informix: OnLine Dynamic Server Handbook. He lives in Dallas, Texas.
Congratulations Carlton! The entire IDS community will be proud of this book!
svisser1 2700018UK9 3,865 Views
The Information On Demand 2008 Conference is the premier IBM information management event... meaning that you will have opportunities for extensive learning opportunities via the 780 Sessions: 120 Business Leadership, 600 Technical Skill Building, and 60 Cognos Sessions.
Did you also know that there is a further learning opportunity via the pre-conference classes? These full day education classes will be offered on Sunday only, October 26th, 2008 from 8:30 am to 4:30pm at the Mandalay Bay Convention Center.
Take advantage of preferred attendee pricing of US $399.00 and get a full day of education, delivered by professional IBM instructors.
Available education is listed below, on-line registration will open to conference attendees soon! Seats will be limited.
IBM Cognos 8 BI: Essentials for Managing BI Projects (version 8.3) Accelerated
Speaker: Norm Goddard
IBM Cognos 8 BI: Essentials for Managing BI Projects (version 8.3) is a one-day, instructor-led course that provides participants with essential knowledge to ensure the success of their Cognos 8 BI implementation. Participants will be introduced to the Cognos Solutions Implementation Methodology (Cognos SIM), the elements of IBM Cognos 8 BI, and the underlying architecture. They will examine the process of creating an IBM Cognos 8 BI solution, and discuss how IBM Cognos 8 BI relates to the other parts of IBM Cognos 8. Participants will be shown a range of resources to help them successfully manage their implementations.
DB2 Migration, How To Move Forward and Never Fall Back
Speaker: Albert Grankin
Production system migration, whether hardware or software is a task that requires very detailed and careful preparation. This session will go over aspects of database migration that are usually not covered in our migration guides. We’ll cover topics including how to prepare your production system for migration and what additional information to collect before starting. It will also cover important steps after migration including comparative performance monitoring, identifying and resolving issues.
DB2 V9/V9.5 for Linux, UNIX and Windows Problem Determination
Speakers: Aman Lalla, Pavel Sustr
Learn how to identify and resolve problems such as database hangs, locking problems, crashes and optimizer/performance problems. DB2 V9 also provides various problem determination facilities and tools such as db2fodc (First Occurrence Data capture). Knowing how and when to use these tools is critical in resolving problems quickly.
DB2 Operational Performance, Success Without Stress
Speaker: Rajib Sarkar
This session will demonstrate effective ways to monitor a DB2 database system for performance and provide tips & tricks in analyzing & monitoring data. The session will also focus on diagnostic tools and techniques used by IBM support personnel and how some of them could be used by DB2 Database Administrators, IT Specialists and Developers for identifying and solving operational performance issues.
Speakers: Hyun-Ju Vega, Suma Vinod, Mark Jamison, Ron Privett
Learn more about troubleshooting from the experts – the IBM Informix advanced support team. Attendees will learn Informix diagnostic methods and tools, how to troubleshoot and diagnose performance problems, connectivity and network issues, memory problems, ER/HDR problems, and Windows specific issues.
Leveraging DB2 Optimizer
Speaker: Yasir Warraich & Samir Kapoor
Learn everything there is to know about the optimizer architecture. We start with discussion about basic concepts such as optimization levels and timer ons. Advanced topics such as data access methods, join methods, analyzing the optimizer access plans will be covered and additionally we'll describe different operators and help identify problematic areas to look into in an access plan. We'll also show how to take counts at different branches in an access plan. Having understood how to analyze an access plan, we'll also demonstrate usage of STATVIEWS, CGS ger,and OPTIMIZATION GUIDELINES to improve query performance.
DB2 for z/OS DBA Certification Crammer (Exam 732)
Speaker: Susan Lawson
This high level certification preparation review is intended to help you take IBM Certification Test 732, DB2 9 DBA for z/OS. Gain an intense overall review of those areas that are on the certification exam.
DB2 9 for Linux & Windows DBA Certification Crammer (Exam 731)
Speaker: Roger Sanders
This training is designed to introduce the student to the concepts a test candidate must know in order to take and pass the DB2 9 DBA for Linux, UNIX, and Window certification exam (Exam 731). The material for this course is aligned with the 731 exam objectives.
Insuring Data Privacy in Your Test Environment using Optim
Speaker: Tom Bauch
Data in your testing environment is often not as tightly controlled or audited as your production data. This 1-day class provides an overview of how to mask your test data to eliminate the risk of data loss and comply with privacy standards using Optim. The class will also review how to simplify the creation and management of your test data, easily creating a subset of your test data to minimize disk requirements, and simplify your ability to create and manage test data environments.
And... if you need help justifying your attendance at the conference, use this conference justification information.
Just published: Cognos 8 Business Intelligence: The Official Guide by Dan Volitich .
This is the only authorized guide to IBM Cognos 8 Business Intelligence.
Develop, deploy, and maintain a complete BI solution across your enterprise. IBM Cognos 8 Business Intelligence: The Official Guide shows you how to take full advantage of the robust service-oriented architecture and simplified role-based user interfaces. Learn how to create, share, and analyze data-rich reports that lead to increased productivity and better business decisions. Featuring real-world insight and expert tips, this is a must-have guide for IBM Cognos 8 Business Intelligence users of all levels, from administrators to end users.
* Measure and monitor performance using dashboards and scorecards * Assign user roles and privileges * Provide complete and consistent access to a broad range of data sources via Cognos Connection* Use Cognos 8 Go! to extend BI to Office applications, mobile devices, and search engines* Enable business users to create reports with Query Studio* Develop new insights by exploring data in multiple dimensions and perspectives with Analysis Studio* Build Dimensional Reports with Report Studio* Use Event Studio to identify and deliver mission-critical information * Create, modify, organize, and publish a model from Cognos Framework Manager * Implement sound security measures * Take advantage of the management tools in Cognos Administration to ensure maximum reliability and availability
When at the IOD EMEA Conference last month, I had many requests for this book, but unfortunately it had not yet been released in Europe. Here are some options for buying the book:
1. For Canada/Canadians – mcgrawhill.ca 2. All other, USA & Intl etc – mhprofessional.commhprofessional.com 3. For Cognos employee purchases, contact me directly for information.
A new ILO course has just been added. This one is an SQL workshop that is spread over 4 half-days in two weeks. ILO courses are the IBM courses that you take without traveling by joining a remote instructor via your computer.
Here are some details:
SQL Workshop - Multi Week Instructor Led Online
On completion of this course, you should be able to:
* Code SQL statements to retrieve data from a DB2 or Informix table, including the SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses* Code inner joins and non-correlated subqueries* Use SQL arithmetic operations* Use scalar and column functions* Use UNION and UNION ALL* INSERT, UPDATE and DELETE rows* Code simple CREATE TABLE and CREATE VIEW statements
The DB2 books that you may wish to have to complement this course are:
* Understanding DB2(R): Learning Visually with Examples (2nd Edition)* DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition)
If you are interested in passing the DB2 9 Family Fundamentals certification exam (Test 730), you should notice that about 23% of the exam covers SQL knowledge. The book DB2 9 Fundamentals Certification Study Guide by Roger Sanders corresponds to the exam objectives and therefore covers the SQL that you need to pass the exam.
An interesting way to get a start on learning SQL is through the DB2 Games. Here are some details that I found on Kate Dawson's blog:
If you are a beginner, choose the IBM DB2 Detective GameIf you like watching crime investigation shows, this might just be the perfect game for you. Using a crime investigation theme, you will enforce your DB2 9 and SQL skills while learning relational database concepts and how they can be applied to real-life problems. I’ve played this game and highly recommend it.
If you have some existing DB2 skills, choose the IBM DB2 Business GameTry a “run your own business” scenario and put your DB2 and SQL skills to the test with the Business Game. Your company’s future depends on a key report needed to secure funds for a critical upgrade… can you put your DB2 skills into action and beat the game? Play now and find out.
Whenever I ask people who are SQL experts, they tell me that they rely heavily on these books:
* Graeme Birchall's DB2 SQL Cookbook* The SQL Reference for Cross-Platform Development* Product Docs for DB2 LUW* Product Docs for DB2 z/OS
When at conferences, I've noticed that the following books are popular:* Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition* SQL Demystified* SQL: The Complete Reference, Second Edition* SQL In A Nutshell, 2nd Edition* SQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation in SQL (2nd Edition)* SQL Pocket Guide
In writing this blog I realize how many resources are available for SQL. Clearly that means that it is a very important topic.... and one that you can continue to improve in.
The ITSO constantly produces IBM Redbooks to help you use the many IBM products and technology. Make sure you check often to keep up to date on all their releases: IBM Redbooks for Information Management Software. If you are a technical expert, consider becoming an author of an IBM Redbook signing up to be a Resident
Here are a few of the latest releases:
Security and Compliance Solutions for IBM Informix Dynamic Server
In this IBM Redbooks publication, we discuss, in detail, the security features available in IBM Informix Database Server (IDS). These enriched IDS security features provide you with the capability to protect your data and comply with regulatory requirements.
We discuss how IDS integrates with operating system security functions for user authentication and user permissions. The role separation divides the security duty among administrators. Auditing enables the database server to log sensitive operations performed by users and administrators for analysis and identifying system misuses.
Discretionary access control (DAC) is the primary access control mechanism that enables access to SQL objects using privileges and roles. Using label-based access control (LBAC), you can control read and write access of users to individual rows and columns at the table level. We then discuss how to secure server-server and server-client communication in an IDS environment, as well as address the security issues for backup and restore.
IBM InfoSphere DataStage Data Flow and Job Design
IBM Information Server is a revolutionary new software platform that helps organizations derive more value from the complex heterogeneous information spread across their systems. It enables organizations to integrate disparate data and deliver trusted information wherever and whenever needed, in line and in context, to specific people, applications, and processes.
IBM InfoSphere™ DataStage® is a critical component of the IBM Information Server, and the parallel framework of IBM InfoSphere DataStage is also the foundation for IBM InfoSphere QualityStage and IBM InfoSphere Information Analyzer components.
This IBM® Redbooks® publication develops usage scenarios that describe the implementation of IBM InfoSphere DataStage flow and job design with special emphasis on the new features such as the distributed transaction stage (DTS) in Version 8.0.1, slowly changing dimensions stage ( Version 8.0.1), complex flat file stage (Version 8.0.1), and access to mainframe data.
Up and Running with DB2 on Linux
Linux® is one of the fastest growing server operating platforms within the past few years. DB2® has long been known for its technology leadership. This IBM® Redbooks® publication is an informative guide that describes how to effectively integrate DB2 for Linux, UNIX®, and Windows® (LUW) with SUSE and Red Hat Linux operating systems. This book provides both introductory and detailed information about installing, configuring, managing, and monitoring DB2 in a Linux environment.
We describe the DB2 product family and features for Linux, and we provide step-by-step instructions for a single as well as for a multiple partition DB2 system installation and configuration. We discuss how to migrate single and multiple partition DB2 to DB2 Version 9.5, and discuss, in detail, DB2 database administration in a Linux environment, procedures and tools for database backup and recovery, online maintenance, and system monitoring. We cover DB2 integrated tools and their features and use.
We discuss aspects of DB2 application development in the Linux environment and provide general tips about building and running DB2 applications on Linux and the use of DB2 application development tools.
Introducing OmniFind Analytics Edition: Customizing Text Analytics
IBM® OmniFind™ Analytics Edition uses information in unstructured and structured content to improve decision making. It provides unstructured information analysis, which can improve customer service levels, create cross-sell capabilities and provide early problem detection.
IBM® OmniFind™ Analytics gives business users the tools to gain valuable insights, facilitating better business decisions, by exploring and using key information assets in the enterprise. It also provides multiple ways to explore and analyze information; delivers sophisticated entity extraction capabilities when working with unstructured content. It is based on the open Unstructured Information Management Architecture (UIMA) standard.
This IBM Redbooks publication will help you understand the power and capability of IBM OmniFind Analytics Edition Version 8.4. The book provides instructions on installing and configuring IBM OmniFind Analytics Edition. It explains how to use it for text mining, and how to work with Dictionary Editor and Rule Editor to customize the application for better analysis and discovery. The book also discusses how to setup the Alerting System for automatically watch for increased unusual activities. The integration with IBM OmniFind Enterprise Edition (OEE) is also covered.
One of the things I'm doing this summer is planning for the IOD conference... specifically arranging for books to be at the bookstore and authors to be available for book signings. I have a lot of work left to do, but here are some of the people I know who are ready to sign your books:
Carlton Doe for his soon to be published book: Administering Informix Dynamic Server: Building the Foundation
Roger Sanders for his entire cert prep series, but especially DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification: Certification Study Guide.
Martin Oberhofer and possibly his co-authors of Enterprise Master Data Management: An SOA Approach to Managing Core Information.
Martin Short... just kidding! It would be great if we could arrange for him to sign something that he's produced, but don't count on it.
Stewart Friedman will be a speaker at the conference. Read this article that appeared in the NY times: Hot Ticket in B-School: Bringing Life Values to Corporate Ethics. The book that he wrote and will sign is Total Leadership: Be a Better Leader, Have a Richer Life.
I'll be at the conference and hope you will be too!
I'll post more secrets about the conference when I find them!
I use google to find links to just about anything I'm interested in. I'm not always successful in finding what I am looking for, but I'm sure it is just because of my bad search arguments.
Mark Wilding, a member of the Toronto Lab Development team, was looking for DB2 sites and was frustrated at not being able to find what he wanted to. So, always a problem solver... Mark created the following site:
Forever growing, this site should be one of the first places to go if you are looking for specific DB2 information.
Just a quick comment about Mark. Mark is one of the many prolific authors that we seem to attract in the Toronto Lab. He's been involved with a few books with many ideas still unpublished. He was the driving force behind the latest DB2 Best Practices initiative. If you don't know about this yet, check out the bookmark list to find it.
Also, Mark, along with Dan Behman, wrote a book about Linux that should be popular with many people: Self-Service Linux(R): Mastering the Art of Problem Determination .
Thanks Mark for the bookmark list as well as your passion for writing!
You may have taken part in this survey of IDUG members on the topic of evolving roles and eduction / training needs. I can't say that the results are unexpected, but I can say that it is very helpful to see the analysis and results as they are discussed in the final survey report, "Data Professionals Broaden Their Skills,". The document is currently posted on IDUG's Web site and can be downloaded free-of-charge.
IDUG partnered with Unisphere Media to conduct the survey of IDUG members on this important topic. Sponsored by CA, the survey gathered input from more than 850 data professionals, with some enlightening results that will help IDUG further serve your needs.
From a publishing perspective, I was encouraged to see that many of the books that are currently available, along with those that are in the works, meet the needs of most of the respondents.
For example, it was mentioned several times in the document that DBAs need the following types of information: database performance and tuning, SQL performance, backup and recovery, and data availability. The recently published book by George Baklarz and Paul Zikopolous, DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition) covers all of the topics and confirms to me that this book is the must have book for all DBAs! The upcoming book by Roger Sanders and Dwaine Snow, DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification: Certification Study Guide will make an excellent companion book for this audience as it may go into more depth on some of the topics mentioned.
The document also mentioned that more DBAs are finding the need to perform application development tasks such as SQL statement development, data modeling and design, and data access methods. In addition to the Baklarz/Zikopolous book already mentioned, you should consider the book by Philip Gunning: DB2 9 for Developers . As the title implies, the book covers the application development tasks that a DBA is required to perform.
Always an important topic is database security: "Forty-one percent reported their time engaged in data security activities has grown over the past year. Most activity in this area has been focused on access control and user authentication, and managing users, roles and permissions." I would recommend the following book: Understanding DB2 9 Security by Rebecca Bond, Kevin Yeung-Kuen See, Carmen Ka Man Wong, and Yuk-Kuen Henry Chan
Certification was also mentioned in the survey results, but the message was: "Certification, while valuable, is only prevalent at a minority of sites, the survey found. About 47 percent of respondents - the largest segment - said a quarter or fewer of staff members are certified or working toward certification. Another 21 percent have no certified staff at all." I found this to be surprising as certification exams are extremely popular with the IDUG conference attendees. The books that support our certification program are: DB2 Certification Study Guides.
Lastly I found the difference between database consultants and database administrators interesting: "The priorities of respondents who spend most of their time in business consulting-related activities differ sharply from those mainly engaged in traditional database administration. While both types of data professionals are likely to be focused on managing explosive data growth, data managers engaged in business consulting are far more likely than traditional database administrators to be focusing on developing service-oriented architectures (34 percent versus 18 percent). Likewise, respondents engaged in business consulting roles are more likely to be moving forward business intelligence initiatives (33 percent versus 18 percent). Enterprise information integration is also more of a top concern among professionals engaged with the business (31 percent versus 21 percent)."
For this audience, I'd highly recommend the growing list of SOA titles from IBM Press, especially Enterprise Master Data Management: An SOA Approach to Managing Core Information which I was closely involved with.
I encourage everyone to read and interpret the results from this survey for themselves. The document is 23 pages in length and worth the time to read.
svisser1 2700018UK9 3,437 Views
From the July IBM Press Books Newsletter
*****************************************************************FREE eBOOK + "BUY 2 GET 1 FREE" OFFER ON SOA AND WEBSPHERE BOOKS*****************************************************************We have several special offers to celebrate the publication of anumber of important new SOA and WebSphere IBM Press books:
* Download a FREE eBook, the Summer SOA and WebSphere Sampler.Check out important content from six new and classic SOA andWebSphere titles. Topics covered include: SOA project planning, amethodology for service modeling and design, MDM as an SOA enabler,business integration architecture and patterns, and more. Downloadthis FREE eBook to read about these important topics.
* Place an order on ibmpressbooks.com for two (2) IBM Pressbooks –- one of the six featured SOA and WebSphere books plus anyother IBM Press book –- and you'll receive a FREE copy of "The NewLanguage of Business: SOA and Web 2.0" by Sandy Carter. Don't wait;this offer is only available while supplies last.
* Get a 35% discount on six new and best-selling SOA and WebSpherebooks, plus free ground shipping in the US.
* Listen to two audio podcast series from expert SOA authors whoexplain concepts from their books: Robert Laird, co-author of thejust-published "Executing SOA: A Practical Guide for the Service-Oriented Architect" has a 3-part podcast series, as does SandyCarter, author of "The New Language of Business: SOA and Web 2.0."
Visit ibmpressbooks.com/SOAspecial to learn details aboutthe special offer, and listen to the audio podcasts.
Here are the other IBM Press titles that you may wish to consider as part of this offer:
Enterprise Master Data Management: An SOA Approach to Managing Core Information By Allen Dreibelbis, Eberhard Hechler, Ivan Milman, Martin Oberhofer, Paul Van Run, Dan Wolfson.Take your career to the next level by understanding how and why master data management can improve your business.
Understanding DB2(R): Learning Visually with Examples (2nd Edition) By Raul F. Chong, Xiaomei Wang, Michael Dang, Dwaine R. Snow.With 20 5-star reviews, how can you go wrong with this book? Whether you've never used DB2 before or whether you're just trying to get up to speed with the latest features, this book is the one for you.
DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition) By George Baklarz, Paul C. Zikopoulos.This is the essential book that should be on everyone's bookshelf!
Understanding DB2 9 Security By Rebecca Bond, Kevin Yeung-Kuen See, Carmen Ka Man Wong, Yuk-Kuen Henry Chan.Improving the security of your environment is definitely something you should consider.
PS. Happy Independence Day to all my American friends!![Read More]
svisser1 2700018UK9 3,419 Views
pureXML™ – “The two most beautiful words in the English language" when it comes to storing and handling XML data.
The pureXML capabilities unique to IBM DB2 software allow you to store your XML data natively in a database table, providing seamless integration of XML and relational data and allowing you to use both SQL and XQuery to query your XML data. What does this mean? Performance improvements, productivity improvements, and cost savings, just like those being realized by other businesses like yours.
OK... sure, this is product information. But check out these videos:
The Pitch Part 1The Pitch Part 2The Pitch Part 3
Do you like watching videos for this kind of thing? Take a look at the large number of videos that are now available on ChannelDB2.com and YouTube.com.
See also Kate's Blog and PlanetDB2.
PS... I need to remember to bring my headphones into work so I don't disturb all those around me by watching / listening to these videos![Read More]
One of the things that I'm trying to find out this year is where do people normally buy their books... and why. It seems that most people go to amazon.com. I go to amazon.com, but only to see the prices, selection, and reader comments. I typically buy at one of the local online bookstores such as amazon.ca or chapters.indigo.ca.
During my travels in the past month, I've found out that many people in Europe choose to buy directly from amazon.com rather than their local sites. Why? I think primarily because of the very favourable currency exchange... and also the price, selection and reader comments!
If you look at the bookstore site that my team maintains, we also point to amazon for the books that we mention. Not really to say that you should buy it there, but for you to see the price and the reader comments.
Since I work directly with several publishers, I also work directly with them on various book promotions. If there is a special discount promotion available for a book... I make sure that the details are mentioned on our bookstore site. For instance, next week you'll see the following information posted:
Enterprise Master Data Management: An SOA Approach to Managing Core Information
Save 35% on the new MDM book published in June that is sure to be the only complete technical primer for every MDM planner and implementer! Written by a team of 6 authors, this book systematically introduces MDM’s key concepts and technical themes, explains its business case, and illuminates how it interrelates with and enables SOA.
Save 35% with the following code at checkout:Coupon Code: IBM6250Active until 12/31/08
We've also arranged for people to buy IBM Press books direct from the publisher in Europe and Canada as well. Here are the sites:Pearson Canada - for a 35% discount on all featured books.Pearson EMEA - provides free shipping and duty for EMEA residents.Employees in Canada - contact me directly :)
For all other places in the world, international information is placed on this page: International sites
We now have many books available through MC Press as well. In the US, the recommended site is: MC Press Online. MC Press has published all of the DB2 V9 Certification Study Guides and have the long awaited Advanced DBA Study Guide coming in September. When MC Press has preorder information, it will be posted on our bookstore site.
In India, Shroff Publishers & Distributors Pvt. Ltd or Computer Bookshop. I see some IBM Press books on the Computer Bookshop site as well. Check it out and let me know if the prices are good!
I've mentioned Kindle before... If you have amazon's electronic reader, then you will be happy to note that all IBM books are kindle-ready! What a better way to have all the reference materials in a single place?
IBMers are encouraged to use Books 24x7 for electronic access to most retail books. All IBMers, worldwide, have access to Books 24x7. If you need info, let me know. If you don't work for IBM, you can pay for a subscription to either Books 24x7 or Safari for electronic books. You can read entire books electronically... or search a library of books for just the right topic.
I know I wasn't able to cover all the countries in the world. I'm still doing research! If you can help me by enlightening me on how you buy your books, please send me a comment! I'd love to hear from you!
As always, check out other bloggers via Planet DB2
svisser1 2700018UK9 3,261 Views
You have until Monday, June 30th to register for a certification voucher that entitles you to a 50% off the price of an exam fee... if you've purchased one of the cert guides. For details see: http://www.ibm.com/developerworks/blogs/page/SusanVisser?entry=follow_the_pig
Follow the pig!
The promotion has been hugely successful! If you were one of the many people who has already received a voucher, good luck on your exam! You'll be happy to know that the book you bought is proven to help people prepare for the exams... not only because of the content, but because of the sample questions and answers that are in the books.
I'm packed and ready for the IOD EMEA conference that is taking place next week in my homeland: Holland! After the conference I will stay a couple of extra weeks to explore the places where my parents grew up... before moving to Canada.
At the conference I'll be working at the bookstore, recommending books to the attendees. If you are planning to be there... come and say hi to me! I've worked closely with many of the authors who have published DB2 and related titles over the past 10 years.... so I may be able to help you choose the best book for your needs.
The bookstore is located at the main entrance of the World Forum Convention Center during the following hours:
Monday, 2 June 3 pm - 8 pmTuesday, 3 June 10 am – 6 pmWednesday, 4 June 8 am – 6 pmThursday, 5 June 8 am – 6 pm
I mentioned in a previous entry that we will be launching the new Enterprise Master Data Management: An SOA Approach to Managing Core Information book by Allen Dreibelbis, Eberhard Hechler, Ivan Milman, Martin Oberhofer, Paul Van Run, and Dan Wolfson. We've arranged to have a special author signing session that will be held outside the World Forum Theater immediately following the Information Platform & Solutions featured keynote on Wednesday, 4 June at 12.20
Another newly published book that will be available for purchase at the bookstore is Executing SOA: A Practical Guide for the Service-Oriented Architect by Norbert Bieberstein, Robert G. Laird, Keith Jones, and Tilak Mitra.
Pick up your free copy of Carlton Doe's IBM Informix Dynamic Server 11, the Next Generation in OLTP Data Server Technology outside World Forum Theater immediately following the Data Management featured keynote on Tuesday, 3 June at 12.20.
Pick up your free copy of DB2 VIPER Strikes Again, New Features in DB2 9.5 outside World Forum Theater immediately following the Data Management featured keynote on Tuesday 3 June at 12.20.
The booksellers I’ll be working with have the following website where books may be purchased following the conference: www.vanstockum.nl
I’m not sure how connected I’ll be at the conference, so I am not sure how many posts I’ll be able to make, but I’ll try.
While I’m away, make sure that you keep an eye on Kate’s blog!
Do you ever wish that you could get practical guidance regarding the BEST way to use DB2 9 to improve the value of your DB2 data servers? For the past 6 months, the development teams have been creating Best Practice papers to help you discover the best practices for the most common DB2 9 product configurations with IBM® DB2® for Linux®, UNIX®, and Windows®.
These Best Practice papers present advice on the most optimal ways you can use DB2 to satisfy key business data processing needs. These papers are authored by leading experts in IBM's development and consulting teams, and have been extensively tested.
Each Best Practice paper is designed to provide practical guidance for the most common DB2 9 product configurations. By applying these recommendations, you may improve the value of your DB2 data servers and align yourself with IBM's technical direction for DB2.
Currently available are:
Database storage, (May 2008)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.
Data life cycle management, (May 2008)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.
Minimizing planned outages, (May 2008)View the best practices for minimizing, or even potentially eliminating, planned database outages. Planned outages can include activities such as routine database maintenance activities or upgrades to your database environment.
IBM data server security, (May 2008)This Best Practices roadmap details how to protect data servers against the common data security threats, some uncommon threats, and useful countermeasures for these threats.
Deploying IBM DB2 products, (May 2008)Discover best practices for deploying the DB2 9.5 family of products on Linux, UNIX, and Windows platforms across multiple computers quickly, easily, and consistently.
Writing and tuning queries for optimal performance, (May 2008)Learn best practices for minimizing the impact of SQL statements on DB2 database performance. This paper focuses on good fundamental writing and tuning practices that can be widely applied to help improve DB2 database performance.
Tuning and monitoring database system performance, (May 2008)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.
Managing XML data, (May 2008)Get principles and guidelines for using DB2 pureXML™ to solve business problems effectively and to achieve high performance when managing XML data in enterprise applications - illustrated with a real-world example easily adapted to other types of XML applications. See Downloads for the files associated with this paper.
Improving data server utilization and management through virtualization, (May 2008)Discover best practices for deploying DB2 9 with the IBM System p™ virtualization technology. Select the right blend of virtualization features and their configurations to achieve desired business goals, while improving the utilization of IT resources.
Frequently asked questions from problem management reports, (May 2008)Get answers to the most common questions that DB2 customers have about the DB2 data server.
Additional Best Practice papers are in development, and will be published on developerWorks as they become available.
Congratulations and THANKS to all the authors for their very valuable contribution to these papers!
PS... see also Kate's blog...[Read More]