This one is Exam 732 - DB2 for z/OS V9 Database Administration exam.
If you are already certified as an IBM Certified Database Administrator - DB2 8 for z/OS, all you need is to take and pass the new exam 732.
If you are new to certification, you must take Exam 732 plus the prerequisite: Exam 730 - DB2 9 Fundamentals.
Exam 732 has 73 questions and you are allowed a maximum of 90 minutes to complete the exam. You must score 57% or greater to pass the exam. The sections and weightings for this exam are:
* Design and Implementation 26%* Operation and Recovery 29%* Security and Auditing 11%* Performance 29%* Installation and Migration/Upgrade 5%
The IBM Certified Database Administrator - DB2 9 for z/OS certification is meant for the lead database administrator (DBA) for the DB2 9 product on the z/OS operating system. This individual has significant experience as a DBA and extensive knowledge of the DB2 9, specifically the new features and functionality related to Version 9. They are capable of performing the intermediate to advanced tasks related to database design and implementation, operation and recovery, security and auditing, performance, and installation and migration/upgrades specific to the z/OS operating system.
For more information about this exam and others that were released for DB2 9, see our Training and Certification web site.
Susan Lawson's book is getting close to being available as well... stay tuned... but I suspect it will be ready in time for the IOD conference in October. If you are planning to be at the conference, consider signing up for the pre-conference class to help you prepare to pass the exam, free of charge, while at the conference.
Keep on Learning
svisser1 2700018UK9 2,834 Views
Apache Derby -- Off to the Races
Duffbert's Random Musings
"If you've ever been curious about using or integrating Apache Derby (or IBM Cloudscape) into your project, here's the book you'll need... Apache Derby - Off to the Races by Paul C. Zikopoulos, Dan Scott, and George Baklarz. Very well done... "-- Thomas Duff
Buy the book: http://www.amazon.com/gp/product/0131855255/102-8524566-1932154?n=283155
svisser1 2700018UK9 2,816 Views
In the mail today, I received an invitation to the next IDUG NA Conference that is taking place in San Jose in May. Given the recent announcement of DB2 9 for z/OS, and the close proximity to the lab that creates the product, I'm sure you'll have a chance to meet many of the developers who took part in the product's creation.
Also at the conference, Roger Sanders and Susan Lawson will be offering their pre-conference cert prep courses:
DB2 V8 for z/OS DBA Certification Crammer CourseSusan Lawson, YL&AFull-day
DB2 9 for LUW Database Administrator Certification Exam PreparationRoger E. Sanders, Network Appliance, Inc.Full-day During the conference you'll have a chance to test your skills by taking the V9 exams, free of charge. Come prepared to pass! Roger's next book will be published just in time for the conference, but Susan's will be in production, so only pre-orders will be possible.
The invitation I received today mentioned a special early bird registration rate when you register on or before March 23, 2007. Also, see the IDUG site to find out how you can win your registration fee!
I hope to see you at the conference.
svisser1 2700018UK9 2,809 Views
Last month we published an ebook entitled: DB2 9: pureXML Overview and Fast StartYou can find this ebook on the redbook site: http://www.redbooks.ibm.com/abstracts/sg247298.html
This ebook is a collection of important XML articles that previously appeared on devworks, written by Cynthia M. Saracco, Don Chamberlin, and Rav Ahuja. We feel that this is the essential group of articles that you need to read to quickly become aware of how XML would benefit your company.
Here is the Table of Contents:Chapter 1. Managing XML for maximum returnChapter 2. What’s new in DB2 9: XML to the core Chapter 3. Get off to a fast start with pureXML Chapter 4. Querying XML data with SQL Chapter 5. Querying XML data with XQuery Chapter 6. Developing Java applications for XML data Chapter 7. Case study: Storebrand Foreword by Sal Vella; V.P., IBM DB2 Development:
Services Oriented Architectures (SOA) are an integral part of building an agile enterprise capable of making decisions quickly, and responding rapidly to new products and services opportunities, as well as to competitive threats. The explosive growth of XML data in businesses today across multiple industries has underscored the role of XML as the "fabric of Services Oriented Architectures" and the need to integrate XML data into enterprise information infrastructure.
DB2 9 (previously code-named “Viper”) enables an information-centric approach to service oriented architecture implementations, which rely upon the ability to access a myriad of data stored across multiple formats. With its dual pure XML data management and traditional relational data capability, DB2 9 delivers information as a service in SOA environments, connecting information on-the-fly, where you need it, and when you need it!
XML data requires the same coveted qualities of service that relational databases provide: high availability, reliability, protection, and performance. The pureXML™ technology in DB2 9 unlocks the latent potential of XML by providing simple efficient access to XML with the same levels of security, integrity, and resiliency taken for granted with relational data. With pureXML innovation in DB2 9, your organization can expect breakthrough increases in availability, speed, and versatility of your XML information, along with dramatically reduced development and administrative costs.
This IBM Redbook serves as an introduction to the hybrid XML data services in DB2 9 for Linux, UNIX, and Windows. It also provides data server professionals a fast start for using and exploring pureXML capabilities in DB2 9 and get them started with leveraging XML information for maximum return.
svisser1 2700018UK9 2,807 Views
Building an Intelligent Web: Theory and Practice will be available in October. The book is intended to be a textbook, so the price is higher than other books that I mention.
Here are the details:
The World Wide Web has become an extremely popular way of publishing and distributing electronic resources. Though the Web is rich with information, collecting and making sense of this data is difficult because it is rather unorganized. Building an Intelligent Web introduces students and professionals to the state-of-the art development of Web Intelligence techniques and teaches how to apply these techniques to develop the next generation of intelligent Web sites. Each chapter contains theoretical bases, which are also illustrated with the help of simple numeric examples, followed by practical implementation. Students will find Building an Intelligent Web to be an active and exciting introduction to advanced Web mining topics.
Topics covered include Web Intelligence, Information Retrieval, Semantic Web, Classification and Association Rules, SQL, Database Theory, Applications to e-commerce and Bioinformatics, Clustering, Modeling Web Topology, and much more!
Includes IBM DB2 Express-C, a data server used in the development and deployment of applications including: XML, C/C++, Java, .NET, PHP, and more.
If you are a professor or curriculum developer, request a sample copy from the publisher. We're very pleased that the authors and publisher of this book decided to include DB2 Express-C on the CD that is shipped with the book. Most publishers are reluctant to ship CDs with their books any longer, but it can be very important, especially for students.
svisser1 2700018UK9 2,798 Views
Every now and again, it is useful to have a list of valuable links..... Here is a list that I was quickly able to put together.
* IBM DB2 product support on-line
* For IBM DB2 Version 9 product documentation (HTML)
* For IBM DB2 Version 9 product documentation (PDF)
* DB2 9 Home Page
* Information Management Training and Certification – Certification, training, retail books, offers, and more
* DB2 9 Information Center
* DB2 9 Support Home Page
* DB2 9 Manuals and Documentation
* The DB2ZONE
* Blog on DB2 LUW
* IDUG DB2-L Listserver
* IBM developerWorks - DB2 portal
* LAZYDBA Listserver
* comp.databases.ibm-db2 Google Newsgroup
* IBM Redbooks
* Planet DB2 - a blog aggregator that combines DB2 blogs from around the world.
* IDUG – International DB2 User’s Group
* DB2 Magazine Online
I hope you find it useful. If there are other links that you'd like me to be aware of, make a comment. We often use these links as part of promoting our skills resources.
svisser1 2700018UK9 2,794 Views
Rick Van der Lans and Klaas Brant have joined forces and are running a series of DB2 Symposiums in various locations:
* Veldhoven, Netherlands April 18-20, 2007* Bonn, Germany April 23-26, 2007* Boston MA, USA May 21-23, 2007* San Jose CA, USA November 12-14, 2007
I've met Rick and Klaas several times at IBM Gold Consultant meetings over the past several years. I met with Rick and Klaas this morning to see how I can help with the symposiums in terms of books and certifications.
Rick is also an author and has several books that may be of interest. Here is a link to the English version of his latest book: Introduction to SQL: Mastering the Relational Database Language (4th Edition)
svisser1 2700018UK9 2,791 Views
I work out of the IBM Toronto Software Lab. This year the lab celebrates 40 years of operation! An article where the first lab director is interviewed, was recently published in the itbusiness.ca newsletter.
Our current office is 6 years old, is state of the art with wireless available through out the building, and is home to 2500 people, all in the software creation business. The lab may be known for its work on the Linux, Unix, and Windows version of DB2, but there are also people working on Tivoli, WebSphere, Rational, and Lotus. This covers all 5 major brands of software that is produced by IBM Software Group! Beyond these 5 brands, there are also quite a few additional areas that are worked on, but I’m not qualified to even mention them!
I've worked for IBM for 18 years now... most of them in the lab. Very enjoyable! Time flies!
svisser1 2700018UK9 2,791 Views
Have you signed up for the IBM Press newsletter? The copy that came out today has part of the interview with Rebecca Bond, lead author of the soon to be published book... the FIRST retail book to cover VIPER / DB2 9 content:
Understanding DB2 9 Securityby Rebecca Bond, Kevin Yeung-Kuen See, Carmen Ka Man Wong,and Yuk-Kuen Henry Chan
Understanding DB2 9 Security is the only comprehensive guideto securing DB2 and leveraging the powerful new securityfeatures of DB2 9. Direct from a DB2 Security deploymentexpert and the IBM DB2 development team, this book givesDBAs and their managers a wealth of security informationthat is available nowhere else. It presents real-worldimplementation scenarios, step-by-step examples, and expertguidance on both the technical and human sides of DB2security.
To read the interview, visit: http://www.ibmpressbooks.com/promotion/3977
To subscribe to the IBM Press newsletter, visit: http://www.ibmpressbooks.com/newsletters
svisser1 2700018UK9 2,773 Views
The February edition of the Certification Magazine has an article about the value IBM places on employees becoming certified. Kellye Whitney wrote the article and interviewed IBM's Chief Learning Officer, Ted Hoff for his insight to the types of people who are hired into IBM and the life long learning goals that IBMers take on.
I have the printed version of the magazine on my desk, but was able to locate the article online as well: IBM: A Technical and Professional Development Mecca for IT.
I just wanted to add that one of the roles that I have at IBM is to administer DB2 certification exams to employees at the Toronto Lab. We have a very large DB2 development team at this location, so I end up administering quite a few exams to new hires, students, and full-time employees. I'm also one of the regular speakers at the Lab's New Hire Presentations and deliver a message as to why getting certified is an important goal.
DB2 exams are experienced based, meaning an exam candidate using DB2 day-in-and-out in a particular job role (for example, DBA), will have a fairly easy time passing the exam, regardless of the amount of studying. On the other hand, not many of the people working on the DB2 development team have job experience as professional DBAs, so the exams are much harder to pass and these people must learn the product through books, tutorials, courses, and trial & error using the product. The benefit is that in preparing to pass the exam, IBM employees are putting themselves in the mindset of professional DBAs and this knowledge will in turn help him or her build more usable features for future releases.
Use the new developerWorks tutorial created by Eric Johnson to learn how to debug SQL stored procedures using Visual Studio 2005.
Title: IBM Database Add-Ins for Visual Studio 2005, Part 2: Deploy, debug, and correct your SQL stored procedures
Follow steps to deploy, debug, and correct SQL stored procedures using IBM® Database Add-ins for Visual Studio 2005.
In this tutorial
* Create a stored procedure that updates the salaries in the EMPLOYEE table of the sample database.* Use the major features of the SQL stored procedure debugger.
* Use the SQL stored procedure debugging features to test SQL stored procedures, and to find and fix problems in them.* Learn about the features of debugging SQL stored procedures when run from Visual Studio 2005.
This tutorial is written for DB2® SQL PL programmers. Familiarity with DB2 SQL PL is assumed.
General familiarity with the IBM Database Add-ins for Visual Studio 2005 is also assumed. To become more familiar with the general features of the IBM Database Add-ins for Visual Studio, see Overview of IBM Database Add-ins for Visual Studio 2005 and the Develop proof-of-concepts .NET applications tutorial series.
System requirements To complete this tutorial, you need a DB2 9 database server. You also need to have the DB2 server or client installed on a workstation with Microsoft Visual Studio 2005 and Version 9 fix pack 2 (FP2) or later of the IBM Database Add-ins for Visual Studio 2005. Finally, you need the sample database that comes with the DB2 database server.
svisser1 2700018UK9 2,765 Views
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!
svisser1 2700018UK9 2,765 Views
There were plenty of notes about the DB2 wiki when it first launched, but have you had a chance to benefit from it yet?
The purpose of this wiki is to provide technical information about using DB2 on Windows/Unix/Linux platforms in a slightly less formal manner than the product documentation. The wiki was started to support DB2 Express C users who have downloaded DB2 for free, but since DB2 Express C is largely the same as other editions of DB2, all can benefit from this information.
If you would like to ask questions about the product, try the Discussion/ Help forums. You'll see a lot of ongoing activity on these forums, so join in if you can.
svisser1 2700018UK9 2,764 Views
The August edition of the DB2 Magazine Newsletter came out today and I learned about this challenge that IDUG is running... IBM is sponsoring:
Introducing the DB2 9 Deep Compression Challenge
Based on feedback from early users, Deep Compression is a hugely-popular feature of DB2 9 for Linux/UNIX/Windows, IBM's latest data server. To highlight this feature, the International DB2 Users Group (IDUG®) is pleased to announce the IDUG DB2 9 Deep Compression Challenge, a non-competitive industry-wide competition aimed at highlighting the storage optimization benefits - costs savings, in particular- users can achieve with the Deep Compression feature available in DB2 9 for Linux, UNIX and Windows.
For details see the August edition of the DB2 Magazine Newsletter and the description of the IDUG DB2 9 Deep Compression Challenge.
svisser1 2700018UK9 2,738 Views
A friend / co-worker of mine has just self-published a book about her dog, Dylan. The book is filled with humourous stories about Dylan when he was a puppy. Lots of photos too! I haven't received my copy yet, but I'm quite impressed with the comments posted on amazon:
Dylanisms - Short Stories About a Dog by Ellice D. Uffer[Read More]