Just a reminder to those of you outside of the United States, some of our publishing partners have set up local online bookstores that provide a discount, allow you to use your own currency PLUS reduce the duty, taxes, and shipping costs of the books. For details on all of the international sites, see ibm.com/software/data/education/bookstore/international.html.
For the direct URLs:
Europe, Middle East and Africa (EMEA) Orders: www.pearson-books.com/ibmpressbookshop/Canadian Orders: www.pearsontechnology.ca/DB2/
Keep on Learning
svisser1 2700018UK9 2.576 Visualizações
svisser1 2700018UK9 2.561 Visualizações
I posted information about this offer last month, but the publisher had a few problems on their end. These problems have been fixed, so I wanted to once again make you aware of this special offer:
Buy any two DB2 V8 books from the IBM Press Bookstore and save 50% off cover price as well as free ground shipping in the U.S. Be sure to make space on your library shelf for these invaluable resources. Quantities are limited, so order soon as this offer ends on July 31, 2007! Please be sure to enter the case sensitive promotion code: DB2DEALS during checkout to receive this discount.
As always, check out our bookstore page for the latest releases and offers: ibm.com/software/data/education/bookstore/
I'm on vacation next week - to all: have a wonderful Canada Day and Independence Day :)
svisser1 2700018UK9 2.598 Visualizações
I was talking to Sam Lightstone yesterday about his book that published in March: Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more.
It covers DB2 very heavily, but also some competitive products (Oracle, SQL Server, and to a lesser extent some others).
From the back cover of the book:
The rapidly increasing volume of information contained in relational databases places a strain on databases, performance, and maintainability: DBAs are under greater pressure than ever to optimize database structure for system performance and administration.
Physical Database Design discusses the concept of how physical structures of databases affect performance, including specific examples, guidelines, and best and worst practices for a variety of DBMSs and configurations. Something as simple as improving the table index design has a profound impact on performance. Every form of relational database, such as Online Transaction Processing (OLTP), Enterprise Resource Management (ERP), Data Mining (DM), or Management Resource Planning (MRP), can be improved using the methods provided in the book.
Features* The first complete treatment on physical database design, written by the authors of the seminal, Database Modeling and Design: Logical Design, 4th edition. * Includes an introduction to the major concepts of physical database design as well as detailed examples, using methodologies and tools most popular for relational databases today: Oracle, DB2 (IBM), and SQL Server (Microsoft). * Focuses on physical database design for exploiting B+tree indexing, clustered indexes, multidimensional clustering (MDC), range partitioning, shared nothing partitioning, shared disk data placement, materialized views, bitmap indexes, automated design tools, and more!
Currently there are no customer reviews on amazon.com. If you have read the book and can give us feedback, post here or on amazon.
svisser1 2700018UK9 2.903 Visualizações
Top 10 Reasons To Deploy DB2 9 For z/OS Now! is a 90-minute webinar that will examine the top 10 most compelling reasons that will convince managers, database administrators (DBAs), and application developers to install and deploy DB2 9 for z/OS as quickly as they possibly can!
DATE: Thursday, June 28, 2007TIME: 2:00 PM - 3:30 PM EDT
Featured speakers Troy Coleman of SoftBase and Roger Miller of IBM will review real-life success stories from companies already receiving significant benefits from using DB2 9 for z/OS and provide a live Q&A session for attendees.
The Top 10 Reasons to Deploy DB2 9 for z/OS Now! will be presented from the following perspectives:
Corporate Officers and Managers * Plug and play CPU cycle reductions with DB2 9 for z/OS* Business agility - new pureXML™ enables companies to include DB2 9 for z/OS into their SOA and XML application initiatives
Database Administrators (DBAs) * Improved database availability and performance including LOB, reorganization, backup and recovery, and partitioning enhancements* Easier role-based security and improved DBMS regulatory compliance* DB2 9 for z/OS enhancements to improve ERP application and data warehouse functionality and performance
Application Developers * Powerful new SQL enhancements including MERGE and TRUNCATE statements, INSERT and EXCEPT set operations, and spatial support for geographical data * Improved SQL and data definition compatability with other DB2s * PureXML adds a powerful SQL and XML interface to access all XML data stored in DB2 9 for z/OS.
To register for this event, please complete the following form: http://www.softbase.com/db2v9top10/
svisser1 2700018UK9 2.687 Visualizações
Informix Dynamic Server (IDS) 11 was announced to the world on June 12. Thanks to hard work by the team, we were able to produce a 100-page book written by Carlton Doe that introduces all the latest features: IBM Informix Dynamic Server 11, The Next Generation in OLTP Data Server Technology. Did you get a copy of the book? Likely not.... we're only distributing the book through our marketing teams. If you want one, check with your rep or attend one of the many IDS events planned for the coming months. See the IDS 11 Launch page for further details.
svisser1 2700018UK9 2.627 Visualizações
I spent the day presenting to Lab employees about the process of publishing external publications about IBM products and technology. I hope you feel that you reap many benefits from employees sharing their knowledge and experience in the form of articles, conference presentations, tutorials, white papers, redbooks, and published books. In most cases employees are asked to write this information while continuing to focus on their day jobs. This means that employees quite often give up their evenings, weekends, and vacations to write this information.
IBM very much appreciates these efforts and has recently promoted Paul Zikopoulos... not entirely because of his publishing efforts, but certainly that helped increase his profile! Congratulations to Paul! Congratulations and Thanks to all of our authors!
As always, here is the best website to go in order to see what books we've published to support the many products within Information Management: http://www.ibm.com/software/data/education/bookstore.
Since I volunteer to proctor exams to employees of the Toronto Lab, I quite often get questions about how to get certified. At this point the most common question is whether people who have not received any DB2 certifications, where should they start? Here is the path I recommend.
If you are using DB2 V8, start there. The exams are experienced-based, so you'll likely have an easier time preparing for the exam since you are using that level of product. The V8 exams are: 700, 701, 702, 703, 704, and 706
If you are using DB2 V9 and have little experience with previous releases, stay with the V9 path. The V9 exams are: 730, 731, 732, 733, 734, and 736
Exam 700 and 730 are equivalent in that they are fundamentals exams for their respective version and they are valid prerequisites for EITHER the V8 or V9 exams. But at least one of these must be taken.
If you want to be certified on BOTH V8 and V9, start with Exam 700 and follow the V8 path. Then all you need to do is to take the upgrade exam, 736 to upgrade to a DB29 DBA certification.
Exam 706 and 736 are upgrade exams. Exam 706 allows those certified as a DBA on DB2 V7 to upgrade with a shorter test. Exam 736 can only be taken by people who already have their V8 DBA cert. So you will not take this exam unless you wanted to get certified on both versions.
As for study materials, both versions have free tutorials. Book availability is a more difficult issue. The V8 certification guides were published by Pearson Education, and most of them are now out of print. Long story as to why they are out of print, but I'm trying to find a workaround. So if you are trying to buy a book and find that it isn't on amazon, you'll need to look for a used copy. If you have V8 books that you no longer need, consider passing them on to those who may need them.
Only one of the V9 study guides has published so far... the one for Exam 730. More are coming, but you'll have to wait till fall.
If you weren't able to follow all these exam numbers, you can find roadmaps and legends on www.ibm.com/certify. For all book information, see www.ibm.com/software/data/education/bookstore/.
As always, feel free to contact me if you need further information.
I've pretty much caught up with my work after a two week vacation to Tuscany, so hopefully I'll be able to post regularly again.
svisser1 2700018UK9 2.650 Visualizações
Join us October 14-19th, 2007 at the Mandalay Bay Hotel and Convention Center in Las Vegas, Nevada for the econd annual IBM Information On Demand 2007 global conference. Book before the end of August to qualify for the discounted rate.
Attending the conference is a great way for you to learn about IBM's Information Management software, industry trends, and how to maximize the value of your existing investments. If you are an IT professional, a line of business manager, a developer or compliance officer, you won't want to miss this event.
See the agenda that provides 500 Technical Skill Building sessions, 120 Business Leadership sessions, the addition of the IBM ECM UserNet Conference, and an EXPO of more than 200 Business Partners. You'll have an opportunity to meet with experts to discuss topics of your interest, use our Hands On Labs to experiment and test solutions for your business, and utilize our Onsite Certification to enhance your personal skills. Attend our executive keynotes, breakout sessions and more than 130 demonstrations.
As for entertainment... that's in place as well: Dana Carvey will be our conference master of ceremonies; Steven Covey is our keynote speaker; and Donna Summer is the featured entertainer.
I hope you are able to make it to the conference for the learning opportunities, certification exams, networking, and of course, for a bit of fun in Vegas!
PS... Signing off for a couple weeks of vacation. Ciao![Read More]
The Version 9 books are slowly arriving, so now is your chance to pick up any Version 8 books that you may want for 50% off the usual price. Here are the details:
************************************************************SPECIAL OFFER - Save 50% on DB2 8 Books************************************************************
BUY any two DB2 8 books from IBM Press and save 50%, plus free ground shipping in the U.S. Make room on your library shelf for these invaluable resources, quantities are limited.
DB2 Universal Database V8 for Linux, UNIX, and Windows Database Administration Certification Guide, 5th Edition The V9 book will publish this summer. It is still worth buying this book if you have not yet earned your V8 certification.
Understanding DB2: Learning Visually with Examples, 1/e The V9 book is expected in the first half of 2008.
High Availability Guide for DB2 There are no plans to update this book for V9. The book is amazing, but is missing information on some of the latest features related to High Availability. It is still worth reading this book as you can find articles related to the missing features on dworks.
DB2 SQL PL: Essential Guide for DB2 UDB on Linux, UNIX, Windows, i5/OS, and z/OS There are no plans to update this book for V9. This is, however, an IBM Redbook about to publish. It is worth reading this book and getting the updates from the IBM Redbook.
DB2 for z/OS Version 8 DBA Certification Guide The V9 book is coming out this summer. It is still worth buying this book if you have not yet earned your V8 certification.
DB2 Universal Database V8.1 Certification Exam 700 Study GuideDB2 Universal Database V8.1 Certification Exams 701 and 706 Study GuideDB2 Universal Database V8.1 Certification Exams 703 Study GuideThis is an extremely popular series of books and excellent for helping you prepare for 4 of the 5 DB2 V8 Certification Exams. It is worth buying these books, if only for the library of sample questios! Also, there are currently no plans to create a study guide for the V9 Application Development Exam.
Official Introduction to DB2 for z/OS, The: Covers DB2 Universal Database for z/OS V8, 2nd EditionWhat an excellent way to come up to speed on DB2 for z/OS. The book is at the Version 8 level, but there are currently no plans to update this book for V9. There will be online help with the product... but get this book instead.
DB2 Express: Easy Development and AdministrationThere are currently no plans to update it for Version 9, but the DB2 Express team is looking into creating an electronic version that is similar to this book. This book is worth buying since it gets you up to speed very quickly in both the DBA and AD areas.
Quantities are limited. Promotion ends June 30, 2007. Click here for more details and for a complete list of the DB2 8 books on promotion.
For this offer and more, see our Offer Page
Several people have notified me that Prometric was listing our upgrade exam (Exam 736) for the price of $150 per take. This was an error and it's now been corrected.
Roger Sanders is currently working on follow-ons to his DB2 9 Fundamentals Certification Study Guide.... one for Exam 731 and one for Exam 736. These books will continue with the tradition started by Roger in that they'll contain as many sample questions as possible. The Fundamentals book just arrived last week at our site's library and there is already a huge waiting list for the book.... perhaps the library needs to buy more copies to keep up with the demand! I hope the book is as popular for your company as well. If not... it should be!
Speaking of Roger Sanders, Part 1 of his in-depth LBAC article can be found on db2mag.com: Understanding Label-Based Access Control, Part 1.
svisser1 2700018UK9 3.321 Visualizações
Willie Favero gave an excellent summary of the best speakers at IDUG NA last week, but I don't remember seeing the complete list.... Melanie Stopfer who is on my extended team, was one of the top 10 speakers! Congratulations!
During the conference closing session on Thursday, May 10, IDUG announced the best-rated presentations from the conference. Listed in alphabetical order, the top 10 DB2 technical session presenters for this event, based on evaluations received from attendees, were:
• Bonnie Baker, Bonnie Baker Corporation • Leon Katsnelson, IBM • Bob Lyle, IBM • Dale McInnis, IBM • Roger Miller, IBM / Chris Munson, IBM • Bryan Paulsen, John Deere Corporation • Terry Purcell, IBM • Suresh Sane, DST Systems, Inc. • Bryan Smith, IBM • Melanie Stopfer, IBM
Congratulations to all the speakers!
PS..... I underlined the people who I've had the pleasure to work directly with over the past few years.
svisser1 2700018UK9 2.766 Visualizações
The May 2007 DB2 Magazine Email Newsletter contains a number of excellent articles including:
IN THE MAY 2007 ISSUE:
1. From the Editor: DB2 Magazine gets the community spirit2. Poll Positions: Rate your company's information security efforts3. Asked and Answered: How do you clone just a portion of a database?4. Skills Set: News and information about IBM education5. Must Read: DB2 9 Fundamentals6. In the Zone: The latest articles on DB2, Informix, U2, and more
Of significance is the new DB2 Magazine Community Wiki... a great place for you to post your favorite tips and tricks for working with DB2, Informix, U2, Cloudscape, and related tools and solutions. Today, the DB2 Magazine Community Wiki is something of a blank slate. With your help, we can compile the best online technical resource for IBM information management software outside of IBM.
The mission of this wiki is to gather DB2, Informix, U2, Cloudscape and other IBM information management know-how and make it available to the DB2 Magazine community.
Thanks to Kim and her amazing team for continually making this magazine a must read!
The latest Certification Today ejournal was recently published on the ibm.com/certify website. In this journal you'll learn about all the latest IBM certification exams, study resources, and offers that are available to you.
If you were one of the many people to take an exam at an IBM conference or an employee who took an exam at one of the Labs, you likely used the PRIME system. Did you know that you may log into PRIME at any time, using the username and password that you indicated when you created your profile. From this site, you may change any of your demographic information plus you can review the score reports for any exam that you took using PRIME (under that username and password, of course).
If you don't remember your username or your password, you may recover them from this site as well. If you choose Method # 2, you won't need to have access to your mail system.
If you didn't take the exam through this system, you may find some of the same information through the Member Site on ibm.com/certify. Also from this site, you can request a missing certificate or merge IDs should you have multiple by mistake.
These may not be the tips that you were looking for... but they are questions that I seem to answer quite frequently.
svisser1 2700018UK9 2.613 Visualizações
You must register ON or BEFORE May 15... You'll have the rest of the month to send in your proof of purchase:
Buy the IBM DB2 9 New Features Book & Save 50% off select DB2 9 Certification! For a limited time, when you purchase the newly released IBM DB2 9 New Features book (ISBN: 0072264594), you can receive a Professional Certification Voucher good for 50% off the list price of IBM DB2 9 Fundamentals Exam 730, or IBM DB2 9 DBA for Linux, UNIX and Windows Exam 731.
svisser1 2700018UK9 2.681 Visualizações
A number of new classroom courses are now available from IBM to help you build your skills on DB2 9. Here are two of them:
Manage your XML data with DB2 9 -- Enroll in Course CG130 (US), CG13XX (Worldwide), and explore the non-traditional ways of using DB2 to work with native Extensible Markup Language (XML) data.
This 2-day course is designed to introduce you to non-traditional ways of using DB2 to work with native XML data. It is also designed to enable database administrators to manage the DB2-native XML environment.
You will learn how to store native XML data in DB2 and create XML indexes. Then you would analyze plan information for queries and take steps for improving query execution. The course also teaches how to manage the XML schemas and the techniques available for decomposing the XML documents.
DB2 9 for Linux, UNIX and Windows Performance Tuning and Monitoring Workshop -- In this 4-day class, you'll learn how to tune for optimum performance the IBM DB2 for Linux, UNIX and Windows relational database management system and associated applications for this environment.
Learn about DB2 9 for Linux, UNIX, and Windows in a single partition database environment. Explore performance issues affecting the design of the database and applications using the database, the major database performance parameters, and the different tools that assist in performance monitoring and tuning. Use tools in class that are common across the Linux, UNIX, and Windows environments. During labs running on DB2 9, develop your ability to use monitoring tools, explain tools and DB2 utilities, such as RUNSTATS , REORG and db2batch, to tune a database running on your local Linux workstation.
IBM Education PackIf you are going to purchase training this year, purchase the IBM Education Pack-online account, and save big! The IBM Education Pack-online account is a prepaid electronic debit account that can automatically save you up to 10% on your IBM training. And with the precision payment option you get even greater flexibility with your account. That's like an extra $2,000 - $5,000 in IBM Training!
svisser1 2700018UK9 2.737 Visualizações
I'm not at IDUG NA this week for a number of reasons, but a few of my team mates are there representing Education and Certification :)
Susan Dykman is keeping very busy giving primarily DB2 V8 and V9 certification exams, but is also offering other IBM exams as well.
Angela Moore is meeting people in the Expo to tell them about the latest classes, books, and tutorials that are available.
Lucy from Breakpoint Books is well stocked with the latest DB2 9 books such as:
1) IBM DB2 9 New Features2) Understanding DB2 9 Security3) DB2 9 Fundamentals Certification Study Guide
Susan Lawson and Roger Sanders taught Sunday education sessions to help people cram for their exams. Other authors I'm working with are there as well.
I hope if you are at the conference that you are finding it educational. If you have a story about certification, books, or something that isn't being covered by Willie or Chris, let me know.... I'll be happy to share your story :)
svisser1 2700018UK9 2.638 Visualizações
Congratulations to Mark Wilding of the IBM Toronto Lab for his promotion to STSM! Mark Wilding is one of Information Management's top experts on problem determination, reliability, availability and serviceability. Mark's appointment to STSM is a testament to what he has accomplished leading the DB2 Linux/UNIX/Windows RAS/PD team. His innovation and leadership has driven a significant improvement in DB2 quality and RAS characteristics.
Learn from Mark's expertise by reading his book: Self-Service Linux: Mastering the Art of Problem Determination . Amazon has the book at a 34% discount right now and there are 5 excellent reviews posted for the book. Here are the headings provided in the amazon.com reader review section to give you an idea of how well-liked the book is:
* The high art of problem investigation and software debugging, June 14, 2006* Required reference for power users and administrators, December 15, 2005* Will likely have a long shelf life..., November 14, 2005* Nice chapter on explaining GDB , October 16, 2005* I don't give 5 stars lightly, October 13, 2005
Sam Poon and Fraser MacArthur recently updated their popular list of recommended articles for those specializing in DB2 for Linux, UNIX, and Windows database administration. Sam and Fraser have filtered through the many articles posted on dWorks and sorted them into the following categories to make it easier for you to find the article that you need:
* Native XML support * Installation and migration * Administration * Monitoring and tuning * High availability * Linux platform * Windows platform * Porting * Problem determination * Certifications
They focus on the content for the DB9, for example, in the Certification category, you'll find links to the tutorial series that were created for Exams 730, 731, and 733.
DB2 9 Fundamentals certification 730 prep series
* Type: Tutorial * Date: 2006 * The Fundamentals tutorial series provides an introduction to SQL (Structured Query Language) and covers how DB2® 9 is packaged and installed, how to create databases and database objects, and the basics of database security and transaction isolation. 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.
DB2 9 Database administration 731 certification prep series
* Type: Tutorial * Date: 2006 * If you know DB2 9 and can perform intermediate to advanced level administrative tasks, you may benefit from becoming an IBM Certified Database Administrator. This series of seven tutorials is designed to help you prepare for the DB2® 9 for Linux®, UNIX® and Windows? Database Administration (Exam 731) certification exam to attain the certification "IBM Certified Database Administrator - DB2 9 for Linux, UNIX and Windows." 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.
DB2 9 Application Development 733 certification prep series
* Type: Tutorial * Date: 2007 * The IBM Certified Application Developer certification confirms to others that you are an intermediate or advanced level DB2 for Linux, UNIX, and Windows 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. This series of nine free tutorials is designed to help you prepare for the DB2 for Linux, UNIX, and Windows Application Development certification exam (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. You can take the tutorials online, or download a PDF.
svisser1 2700018UK9 2.615 Visualizações
Have you subscribed to the IBM Press Newsletter to see the latest books published by IBM Press? To subscribe to this newsletter, visit: ibmpressbooks.com/newsletters.
Here are some of the items from April edition:
************************************************************Approaching crucial decisions about RFID technology?************************************************************RFID SourcebookBy Sandip Lahiri
This book will help you make choices that maximize the business value of RFID technology and minimize its risks. IBM's Sandip Lahiri, an experienced RFID solution architect, presents insight for evaluating RFID; defining optimal strategies, blueprints, and timetables; and deploying systems that deliver what they promise.
Read Chapter 1: RFID Technology Overview to get started
************************************************************Access IBM Press and Thousand of Books Online************************************************************Safari Books Online has introduced an online searchable reference library service that puts IBM Press and thousand of books and articles at your fingertips for one flat monthly fee.
Learn more about the new Safari Library and receive a special introductory rate when you subscribe.
************************************************************Featured Selection: Developing Quality Technical Information************************************************************
Developing Quality Technical InformationBy Michelle Carey, Gretchen Hargis, Ann Kilty Hernandez, Polly Hughes, Deirdre Longo, Shannon Rouiller, and Elizabeth Wilde
In memory of Gretchen Hargis.
Direct from IBM's own documentation experts, this is the definitive guide to developing outstanding technical documentation--for the Web and for print. Using extensive before-and-after examples, illustrations, and checklists, the authors show exactly how to create documentation that's easy to find, understand, and use.
Whether you're a writer, editor, designer, or reviewer, if you want to create great documentation, this book shows you how!
Read Chapter 2: Task-Oriented Writing for Techies
In this chapter you will learn how to become a more effective writer by ensuring your topics are task oriented, focused on the user's needs, and presented from the user's perspective. You'll learn to divide task information into tasks and subtasks; provide clear, imperative, and usable steps; and keep the conceptual clutter from how-to information.
BUY any two IBM Press titles and save an additional $5.00 off the complete order when you buy from ibmpressbooks.com. PLUS receive FREE ground shipping in the U.S.
Enter case sensitive Coupon Code: BUYTWO0307 at checkout.************************************************************
svisser1 2700018UK9 2.854 Visualizações
Last year I met a student name Ankit Asthana who was working in the Toronto Lab for the summer. Ankit came to me to see if I was able to help him publish a book that he had written on a previous co-op term. I'm not sure if I was much help at all, but Ankit's book was recently published by New Age International: C++ For Beginners.....Masters.
Congratulations Ankit! I hope you feel much pride for publishing this book so early in your career!
I hope you'll be able to find this book: DB2 9 Fundamentals Certification Study Guide in actual bookstores... but if not, check out amazon.com. Today they put the book on sale with a 37% discount!
Today I received my copies of the book. They look amazing. The most unique thing about the book is the large number of sample questions. Each chapter has several study questions along with reasons why the correct answer is the right one. Each of these study questions are repeated in Appendix B... and take up 105 pages of the book. By far the most complete study guide for a DB2 exam that has ever been produced.
This book prepares you to pass the DB2 9 Fundamentals Exam (730). Roger is working on the second book in the series and has plans for a third book as well.
An IBM Certified Advanced Database Administrator is the lead DBA for the DB2 products on one or more of the following platforms: Linux, UNIX (including AIX, HP-UX, and Sun Solaris), and Windows. This individual has extensive experience as a DBA and extensive knowledge of DB2 9. This person is capable of performing the advanced tasks such as performance, high availability, security and networking that are required.
To earn an IBM Certified Advanced Database Administrator Certification for DB2 9, you must pass the following exams:
1) Exam 734 - DB2 9 for Linux, Unix and Windows Advanced Database Administrator2) EITHER Exam 736 - Upgrade Exam for DB2 9 for Linux, Unix and Windows Database Administrator OR Exam 731 - Full Exam for DB2 9 for Linux, Unix and Windows Database Administrator3) EITHER Exam 700 - DB2 V8 Family Fundamentals OR Exam 730 - DB2 9 Fundamentals (Either exam is acceptable as a pre-requisite.) The test contains six sections with 51 multiple-choice questions. You must score 64% or greater to pass the exam. The percentages after each section title reflect the approximate distribution of the total question set across the sections.
Section 1 - Database Design - 14%Ability to design, create and manage table spacesAbility to design, create and manage buffer poolsAbility to design and configure federated database access
Section 2 - Data Partioning and Clustering - 15%Ability to design, create, and manage database partitioningAbility to design, create and manage multi-dimensional clustered tablesAbility to design, create, and manage table partitioningKnowledge of Balance Configuration Unit (BCU)
Section 3 - High Availability and Diagnostics - 20%Ability to manage database logs for recoveryAbility to use advanced backup featuresAbility to use advanced recovery featuresAbility to enhance database availabilityAbility to use diagnostic tools (db2pd, db2mtrk, inspect, db2dart, db2diag)
Section 4 - Performance and Scalability - 33%Identify and use DB2 registry variables that affect database system performanceIdentify and use configuration parameters that affect database system performanceKnowledge of query optimizer conceptsAbility to manage and tune database, instance and application memory and I/OAbility to use Data CompressionAbility to analyze performance problemsAbility to manage a large number of users and connectionsAbility to determine the more appropriate indexAbility to exploit parallelism
Section 5 - Security - 8%Knowledge of external authentication mechanismsAbility to implement data encryptionAbility to implement Label Based Access Control (LBAC)Ability to use DB2 Audit
Section 6 - Connectivity and Networking - 10%Ability to configure client server connectivity (e.g., db2discovery)Ability to manage connections to host systemsAbility to identify and resolve connection problems
Assessment ExamsTake the Assessment Exam for Exam 734 to gauge your readiness. There is a $10.00 fee per assessment test.
Schedule Your ExamIBM exams are offered worldwide at Prometric and VUE Testing Centers.
Explore Study ResourcesYou can choose from the number of recommended books, self-study tutorials and classroom courses that are available to assist you with your certification preparation.
There aren't any specific books planned at this time to help you prepare for this exam, but it is one of the books that I am pushing for. I have an author team that is working on a proposal, so stay tuned. The following books have some sections that will help you learn the required topics:
IBM DB2 9 New Features by Paul Zikopoulos, George Baklarz, Leon Katsnelson, and Chris Eaton
Understanding DB2 9 Security by Rebecca Bond, Kevin Yeung-Kuen See, Carmen Ka Man Wong, Yuk-Kuen Henry Chan
DRAFT: High Availability and Scalability Guide for DB2 on Linux, UNIX, and Windows
Recommended Reading List - a series of useful article Groups of articles are separated by topic to help you quickly find a series of articles that can provide needed insight into the topics.
Title: DB2 9 for LUW Performance Tuning Monitoring WorkshopNumber: CF41Length: 4 Days
Title: DB2 UDB Advanced DBA for ExpertsNumber: CF46Length: 5 Days
Title: DB2 for LUW Quickstart for Experienced Relational DBAsNumber: CF48Length: 4 Days
Title: DB2 Advanced Recovery for Single Partition DatabasesNumber: CF49Length: 4 Days
All three offers on our IBM Information Management Books web page are expiring soon. Here are the details:
Buy IBM DB2 9 New Features & get 50% off select DB2 9 Certification!
This book has just been released and was written by key members of the IBM database product teams. It offers a concise roadmap to the new features of IBM DB2 Version 9 - the first major release of the database in five years. From now until May 15, 2007, when you visit your favorite US bookstore and purchase the IBM DB2 9 New Features Book (ISBN: 0072264594), you can receive a discount certification voucher good for 50% off one of the two new DB2 9 Certification Exams, 730 and 731. For more information, click here.
Pre-order and Save 35% Off The DB2 9 Fundamentals Certification Study Guide!
The long awaited new certification study guide by Roger Sanders is now available for pre-order from MC Press, with a discount of 35% until May 1, 2007! In DB2 9 Fundamentals Certification Study Guide, Roger Sanders one of the world’s leading DB2 authors and an active participant in the development of IBM’s DB2 certification exams covers everything a reader needs to know to pass the DB2 9 Fundamentals certification exam (Exam 730). The book includes sample questions in each chapter plus a complete practice test of 150 questions that closely models the actual exam. No other source gives you this much help in preparing for this exam.
Save 35% off the list price of Understanding DB2 9 Security
Until May 1, 2007, you can get one of the hottest new Information Management Books at 35% off cover price and even get free Fed Ex ground shipping in the US when you order from the IBM Press Bookstore. This new book is available in both a hard copy and an on-line version.
Understanding DB2 9 Security is the only comprehensive guide to securing DB2 and leveraging the powerful new security features of DB2 9. Direct from a DB2 Security deployment expert and the IBM® DB2 development team, this book gives DBAs and their managers a wealth of security information that is available nowhere else. It presents real-world implementation scenarios, step-by-step examples, and expert guidance on both the technical and human sides of DB2 security.
One of the authors of the book, Rebecca Bond has just held a Q & A session on the book. Check out the dialog and even download a sample chapter of the book before you order!
In order to receive this valuable discount, you must use promotion code BOND5709 during the check out process. To receive complimentary shipping in the USA, please be sure to select the ground option during checkout.
Don't wait till a conference to buy these books... you'll receive a much better deal with these offers than can be offered at conferences.
If you are one of the many people who has earned an IBM Certified Database Administrator - DB2 UDB V8.1 for Linux, UNIX and Windows Certification... you'll be happy to know that the upgrade exam is now available for you to take. You'll only need to answer 38 questions and the price is only $75... half the price of Exam 731.
As with Version 8, there are two different exams that you can take to upgrade to the V9 DBA Certification:
1) Exam 736 - IBM Certified Database Administrator for DB2 9 for Linux, Unix and Windows, Upgrade Exam2) Exam 731 - IBM Certified Database Administrator for DB2 9 for Linux, Unix and Windows, Full Exam
The Upgrade Exam 736 is only an option for candidates who are already certified as an IBM Certified Database Administrator - DB2 UDB V8.1 for Linux, UNIX and Windows, but if you pass, will earn you the same certificate that you'd earn from passing Exam 731.
You must score 55% or greater to pass this exam.
Section 1 - Server Management (29%)
Understand the functionality of AUTOCONFIGUREAbility to manually configure communications (protocol image(IPV6))Ability to enable automatic maintenanceAbility to enable Self Tuning memory ManagerAbility to enable Utility Throttling
Section 2 - Data Placement (21%)
Ability to CREATE DATABASE (new default behavior)Ability to create and manage Automatic Storage tablespacesKnowledge of Table PartitioningKnowledge of Data Row Compression
Section 3 - XML Concepts (13%)
Ability to use XML Data typesAbility to create and manage XML indexesAbility to use basic XML functions (XMLPARSE, XMLSERIALIZE, XMLVALIDATE, XMLQUERY)Understanding XQuery fundamentalsUsing DB2 Utilities with XML data
Section 4 - Analyzing DB2 Activity (16%)
Ability to use DB2 Utilities (db2bfd, db2mtrk, db2pd)Ability to monitor deadlocksAbility to use Adminstrative routines and SNAPSHOT functions
Section 5 - High Availability (10.5%)
Ability to use RECOVER DATABASE commandKnowledge of High Availablity Disaster Recovery (HADR)
Section 6 - Security (10.5%)
Understanding of Label Based Access Control (LBAC)Knowledge of new authentication types
Assessment ExamsThere isn't an Assessment Exam for Exam 736, but it is suggested that you take the Assessment Exam for Exam 731 to gauge your readiness. There is a $10.00 fee per assessment test.
Schedule Your ExamIBM exams are offered worldwide at Prometric and VUE Testing Centers.
Explore Study ResourcesYou can choose from the number of recommended books, self-study tutorials and classroom courses that are available to assist you with your certification preparation.
IBM DB2 9 New Features by Paul Zikopoulos, George Baklarz, Leon Katsnelson, and Chris Eaton
Expert Preparation for IBM Exam 730: DB2 9 Fundamentals Certification Study Guide by Roger E. Sanders
DB2 9 DBA exam 731 prep, Part 1: Server management Learn skills that help you to properly manage your DB2 database servers. This tutorial provides information about data consistency, transactions and how they are initiated and terminated, and the use of locks.
DB2 9 DBA exam 731 prep, Part 2: Data placement Learn how to create DB2 databases, and about the mechanisms available for storing your tables, indexes, and data within the database. This tutorial focuses on partitioning, compression, and XML, which are all important performance and application development concepts that you need to know to store and access data quickly and efficiently.
DB2 9 DBA exam 731 prep, Part 3: Database access Take the various steps required to manage some of the objects within DB2. This tutorial includes overview information for topics such as indexes, constraints, referential integrity, and views.
DB2 9 DBA exam 731 prep, Part 4: Monitoring DB2 activity Become familiar with the different options a DBA has for tuning and configuring their DB2 environments. This tutorial shows you how to use the tools, functions, and applications available in DB2 9 that make this task much simpler.
DB2 9 DBA exam 731 prep, Part 5: DB2 utilities Find out what utilities are provided with DB2 servers for data movement and maintenance. This tutorial shows you how to extract data, populate tables, use the db2move, db2look and other commands, use the DB2 Control Center and much more.
DB2 9 DBA exam 731 prep, Part 6: High availability: Backup and recovery Learn how to protect your data using database backup and recovery. This tutorial explains the different methods of database recovery and logging, and how to use the backup, restore, and rollforward commands.
DB2 9 DBA exam 731 prep, Part 7: High availability: Split mirroring and HADR Learn how to use a split mirror to provide high availability and how to setup a high availability disaster recovery (HADR) system.
Title: DB2 Universal Database Administration WorkshopNumber: CF20 (Linux), CF21 (UNIX), CF23 (Windows)Length: 4 Days
Title: DB2 9 for Linux, UNIX, and Windows TransitionNumber: CG09Length: 3 Days
Title: Query XML Data with DB2 9Number: CG10Length: 2 Days
Title: Query and Manage XML data with DB2 9Number: CG13Length: 4 Days
Title: Fast Path to DB2 9 for Experienced Relational DBAsNumber: CF28Length: 3 Days
See the latest DB2 Magazine edition for an excellent article by Roger Sanders:
Could Label-Based Access Control be the Magic Bullet that Tames the Privacy Beast?
After reading the Distributed DBA column on database cloning for Linux, Unix, and Windows in DB2 Magazine, a reader who works in the heavily regulated banking industry cried out for help. How, he wondered, could he keep sensitive information away from developers' eyes without having to obfuscate multiple tables? "I think I'm searching for a magic bullet that doesn't exist." But does it exist? Columnist Roger Sanders thinks DB2 9 might offer a solution in the form of label-based access control. Find the answer, and lots of other useful information, in the DB2 Magazine Email Newsletter Volume 8, Issue 4.
Also on LBAC, see Rebecca Bond and her team's book Understanding DB2 9 Security
Web Chat: DB2 9: Securing your data with Label-Based Access Control
Replay 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.
Article:DB2 Label-Based Access Control, a practical guide, Part 1: Understand the basics of LBAC in DB2 by Carmen Wong and Stan Musker.
svisser1 2700018UK9 2.885 Visualizações
John Chun from DB2 Support sent me this list of articles and redbooks that he recommends to customers who create applications that run against DB2 servers:
1. IBM Redbooks: DB2 Express-C: The Developer Handbook for XML, PHP, C/C++, Java, and .NET
2. IBM DeveloperWorks article: DB2 packages: Concepts, examples, and common problems
3. IBM DeveloperWorks article: Solve common problems with DB2 UDB Java stored procedures
4. DB2 Magazine article: What’s Hot for Java
5. IBM Redbooks:Powering SOA with IBM Data Servers
Portal: Technical resources for IBM Information Management software
Portal: DB2 Express-C
Free version of DB2: DB2 Express-C: Free to build, deploy, distribute ... No limits
Ready to validate your skills and demonstrate your IBM DB2 9 proficiency with Information Management Professional Certification? The IBM DB2 9 Application Developer Exam (733) is now ready for you to take to prove to yourself and others that your skills are current. Here are some crucial details about the exam:
Length: 70 questionsPassing score: 55%Duration: 90 minutes
Job Role Description:An IBM Certified Application Developer is an intermediate or advanced level application developer specializing in creating applications that run on any of the DB2 platforms: Linux, UNIX (including AIX, HP-UX, and Sun Solaris), and Windows, z/OS, s/390, and iSeries. This individual has strong skills in all common programming tasks as well as strong skills in one or more of the specialty areas: embedded SQL programming, ODBC/CLI programming, .NET programming or Java programming.
Prerequisites:To attain the IBM Certified Application Developer – DB2 9 certification, candidates must pass two exams (730 and 733) or be certified as an IBM Certified Database Associate - DB2 Universal Database V8.1 (exam 700) and pass exam 733.
* section 1 Database objects and Programming Methods 16% * section 2 Data Manipulation 26% * section 3 XML Data Manipulation 10% * section 4 Embedded SQL Programming 4% * section 5 ODBC/CLI Programming 4% * section 6 .NET Programming 7% * section 7 Java Programming 7% * section 8 Advanced Programming 14% * section 9 User Defined Routines 12%
Study Materials:Self Study Preparation TutorialsOn-line Professional Certification Assessment ExamsTake an IBM Exam at Thompson PrometricTake an IBM Exam at Pearson VUE
Suggested Redbooks that can help prepare for specific areas of the exam:
* DB2 9 pureXML Guide
* DB2 Express-C: The Developer Handbook for XML, PHP, C/C++, Java, and .NET
* DB2 UDB for z/OS Version 8: Everything You Ever Wanted to Know, ... and More
* DB2 for z/OS Stored Procedures: Through the CALL and Beyond
For additional information, see the Information Management Certification website.
svisser1 2700018UK9 2.841 Visualizações
Join us for The IMS Integration Suite: What, when, where, why, who and how questions answered teleconfence, Tuesday, April 10, 2007
You’ve been counting on IMS for years for the power of its transaction processing. Now that SOA has arrived, there’s no reason to stop. It’s possible to access your IMS application programs as Web services with direct access to IMS databases from service-based applications. With the right tools and techniques, you can easily integrate your existing assets with an SOA programming model.
In this teleconference, we’ll discuss the role of IMS in SOA implementations, and how IMS customers can leverage existing IMS applications and data in an SOA solution. You’ll learn about the IBM development tools and the IMS integration technologies that can be used to access IMS application programs and databases, as well as details on IMS V10 support for access to Web services.
You’ll come away with a good understanding of how to:
* Rapidly deploy Web services * Use the IMS database for XML documents * Simplify and reduce time or costs for application development * Integrate with Web services and SOA architecture
Speaker: Kenny Blackman – IBM Advanced Technical Support Group, IMS connectivity
In order to accommodate multiple time zones, the teleconference is offered at two separate times. Each will include a live Q&A session.
First Call: 9:30 am ET, 2:30 pm BST, 3:30 pm CET Second Call: 9:30 am PT, 12:30 pm ET, 5:30 pm BST, 6:30 pm CET Susan[Read More]
I blogged about this new voucher promotion last week.... we now have a link to this promotion on the amazon page for the book: IBM DB2 9 New Features and we're getting amazing response. Make sure you don't miss out!
Here is my original post:
Buy a book... get 50% off a certification exam! We only have a limited number of vouchers, so we're expecting to run out quickly. Be one of the first to get a voucher by buying a copy of the IBM DB2 9 New Features by Paul Zikopoulos, George Baklarz, Leon Katsnelson, and Chris Eaton. You don't need to buy the book from amazon, but you do need to send us proof of purchase.
Normally exams cost about $150 ... so this is a savings of $75. For full details, read: Voucher Promotion Details
svisser1 2700018UK9 3.941 Visualizações
Join us for this webcast that will help you understand where DB2 is headed in the future...
IBM DB2 Chat with the Lab - Thursday, April 12th at 11 AM Eastern, 10 AM Central, 8 AM PacificBeyond DB2 Viper - Technology Trends and Directions
The next offering in IBM's Chat with the Lab series will feature Sal Vella, Vice President of DB2 Development for Linux, Unix and Windows and Les King, Program Director of the Data Services Portfolio, who will talk about the next release of DB2 on the distributed platform. A detailed look at key requirements that drive product plans in areas such as XML exploitation, manageability, scalability and performance, optimization and warehousing will be discussed.
Click here to register for the chat.