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.
Keep on Learning
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.
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
These days it seems that most DBAs are in the position where they need to know multiple database products. I know that in many cases that means a non-IBM database such as SQL Server or Oracle, in addition to one of IBM's database products, but for many DBAs, the reality is multiple IBM products. I've attempted to pull together useful information for DBAs who are in this position.
Zone: DBA Central Products: DB2 Family
DB2 9 for Linux, UNIX, WindowsDB2 9 for Linux, Unix and Windows is a hybrid data server for both XML and relational data that is enabled for SOA and optimized for SAP.Viper: DB2 9 for Linux, UNIX, Windows DB2 podcast series: Voice of the Community Recommended reading list: DB2 for Linux, UNIX, and Windows database administrationCerts, Education, Books, Tutorials: Education ResourcesRedbook: DB2 9 pureXML GuideRetail book: IBM DB2 9 New FeaturesRetail book: Understanding DB2 9 Security
DB2 9 z/OSUse DB2 on the mainframe to run powerful enterprise applications, and make e-commerce a reality.Products: DB2 for z/OS and OS/390 Redbook: Data Integrity with DB2 for z/OSLaunch page: DB2 for z/OSTool site: DB2 and IMS Blog: Willie Favero'sMost resources coming soon... Certs, Education, Books, Tutorials: Education Resources
IDSExceptional, low maintenance online transaction processing (OLTP) data server for enterprise and workgroup computing.Zone: IBM Informix Launch site: IDS Cheetah Blog: Cheetah ExpertsWebcast: Integrated Data Solutions for Information On Demand using IBM Informix Cheetah Article: How to go hand-in-hand with DB2 and InformixRedbook: Informix Dynamic Server V10 . . . Extended Functionality for Modern BusinessTest Run: IDS CheetahChat with the Lab Series: IDSMost resources coming soon... Certs, Education, Books, Tutorials: Education Resources
Oracle or SQL ServerConsider switching... it's easy with these resources:Redbook: Oracle to DB2 UDB Conversion Guide Redbook: Microsoft SQL Server to IBM DB2 UDB Conversion GuideZone: Porting to DB2 for Linux, UNIX, and Windows Station: Migration
Now this list was a difficult one to put together. In fact, I went to Louise McNicoll from the Toronto Lab for this list... and you may discover that it isn't all inclusive. You may notice that the authors are all employees of the Toronto Lab. Yes, the employees from the US and India have published articles as well, but I have not yet been able to pull together a complete list. One of my goals for the New Year!
Nevertheless, you'll notice that this is a very lengthy list, so clearly the list will be much longer when I get all the details.
I hope you find this list useful. Happy Reading :)
Comparing real time cardinality to the optimizer cardinality estimatesby Samir Kapoor, Sid Selvarajah, Kaarel Truuvert
A quick start: Developing and testing SQLJ programs using Rational Application Developerby Yongli An, Joyce Coleman
Set up a Multi-tier SPECjAppServer2004 cluster with DB2by Tony Lau, Meng Fu
Set up a WebSphere v6 SPECjAppServer2004 cluster with DB2 for Linux, UNIX, and Windowsby Tony Lau
Backup/Restore Schemas for DB2 Universal Databaseby Serge Rielau
Configure DB2 UDB ESE V8.2 with the Database Partitioning Feature on SUSE Linux Enterprise Serverby Sam Poon, Fraser McArthur
DB2 9 XML Performance Characteristicsby Irina Kogan, Matthias Nicola, Berni Schiefer
DB2 Partitioning Features: an overview for data warehousesby Paul McInerney
DB2 Developer's releaseby Paul Zikopoulos
DB2 Universal Database: The Database Explorer, Part 1by Paul Zikopoulos
DB2 Universal Database: The Database Definition Windows, Part 2by Paul Zikopoulos DB2 Universal Database: Building Stored Procedures using the Database Expolorer View, Part 3by Paul Zikopoulos DB2 Universal Database: Building User Defined Functions using the Data Definition View, Part 4by Paul Zikopoulos DB2 Universal Database: Generating SQL Statements Using the SQL Editor, part 5by Paul Zikopoulos DB2 Universal Database: Productivity Features of the SQL Builder, Part 6 by Paul Zikopoulos Building Tables with the DB2 Designer and Visual Studio 2005 by Paul Zikopoulos Build a DB2 Bound Data Application using Visual Studio 2005by Paul Zikopoulos How to Build an ASP.NET Web Site Using DB2 Data with Visual Studio 2005by Paul Zikopoulos Binding DB2 Data to Visual Studio 2005 Windows Applicationsby Paul Zikopoulos Creating an XML Schema Document (XSD) with the DB2 Tools for Visual Studio 2005 Database Journal (www.databasejournal.com)by Paul Zikopoulos
DB2 9 Fundamentals exam 730 prep, Part 1: DB2 planningby Paul Zikopoulos DB2 9 Fundamentals exam 730 prep, Part 3: Accessing DB2 data by George Baklarz
Information on Demand Global Conference Web 2.0 Personal Plannerby Leons Petrazickis, Grant Hutchison
DB2 9 Fundamentals exam 730 prep, Part 4: Working with DB2 databy Roman Melnyk
Introducing DB2 9: DB2 9 unveiledby Rav Ahuja
Introducing DB2 9: Application development enhancements by Rav Ahuja
Introducing DB2 9, Part 1: Data compression in DB2 9 by Rav Ahuja
Introducing DB2 9, Part 2: Table partitioning in DB2 9 by Rav Ahuja
Introducing DB2 9, Part 3: Self-tuning memory in DB2 9 by Rav Ahuja
Introducing DB2 9, Part 4: Autonomic and other enhancements in DB2 9by Rav Ahuja
Setting up DB2 for UNIX and Linux on NFS mounted file systemsby Felix Lee
DB2 Developer Workbench, Part 1: Developer Workbench concepts and basic tasksby Chris Eaton
DB2 Developer Workbench, Part 2: Developer Workbench and stored proceduresby Debra Eaton
DB2 XML evaluation guideby Gerald Leung, Grant Hutchison
Kick-start your J2EE applications using DB2 9 with pureXML and WebSphere Community Editionby Gerald Leung, Lin Sun
DB2 Express-C, the developer-friendly alternative by Grant Hutchison
Work with XML Data in the Zend Framework: Getting started with the Zend_Db_Xml Incubator Project by Salvador Ledezma
Take the Fast Trainby Rahul Kitchlu, Boris Bialek
Cost-based Optimization in DB2/XMLby John Hornibrook, Andrey Balmin, Tom Eliaz, Lipyeow Lim, David Simmen, Guy Lohman, Min Wang, Chun Zhang
Automating DB2 HADR Failover using IBM Tivoli System Automation for Linuxby Melody Ng, Steve Raspudic, Chris Felix
Installing the DB2 Plug-in for Nagios System Monitor (PDF download)by Chris Thomason
What's Hot for Javaby Christine Law
HASE: A Hybrid Approach to Selectivity Estimation for Conjunctive Predicatesby Calisto Zuzarte, Xiaohui Yu, Nick Koudas High Availability with IBM® DB2® 9 and xkoto GRIDSCALE (PDF download)by David Tam, Belal Tassi Workload Adaptation in Autonomic DBMSsby Randy Horman, Baoning Niu, Patrick Martin, Wendy Powley, Paul Bird CASCON 2006
Using Zend Core for IBM and IBM® DB2 Technologies to Implement an OLTP System Supporting Tens of Thousands of Simultaneous Database Connectionsby Nailah Bissoon, John Tran, Sunil Kamath Zend Developer Zone
A Recipe for Services Oriented Architectureby Paul Zikopoulos
Taking Control: DB2 Query Patrollerby Paul Zikopoulos, Dwaine Snow
Introducing the db2pd Tool – A Not-So-Well Known Friend for a DBAA Simple Fix to a DB2 Query Patroller Locking Problemby Paul Zikopoulos
Accessible Standy Database in IBM DB2 UDB HADR Environement Using VERITAS Volume Instant Snapshots (PDF download)by Nuzio Ruffolo www.ibm.com[Read More]
Have you heard of the DB2 Detective Game? I was part of a small team that created this game a few years ago with the objective of teaching people how to query a DB2 database. Our original audience was a SHAD Valley group of high achieving high school students (http://www.shad.ca/). One of the people on our team was a former SHAD grad who was on a coop term at IBM. Teaching the students was an amazing experience. They like the competitiveness of playing a game, but it was astonishing how quickly they picked up the skill of writing queries to get important information from the database.
The game has gone through many iterations of improvements and is now called the DB2 business game and is available on developerWorks for all to "play". Give it a try....
Here are the details:
The DB2 business gamehttp://www.ibm.com/developerworks/edu/dm-dw-dm-0609cao-i.htmlTest your DB2 querying skillsLevel: Introductory
If you're a beginner with IBM® DB2® and SQL, you may wonder how the technical skills you're learning are used in the "real world." Here is a chance for you to put your DB2 SQL skills into play in this interactive game! Jump into a "run your own business" scenario, where your company's future depends on a key report needed to secure funds for a critical upgrade. Use your relational database skills to build this report.
Put your DB2 SQL skills into play using a "real world" business scenario.
Have you taken IBM certification exams in the past, but don't remember what you've passed? Have you received the certificates that you are entitled to? Check on the Member Site for IBM Certified Professionals to see where you stand.
IBM's Certification Member Site allows you to:
* View your test and certification history, including shipping status of certificates
* Submit requests to merge multiple candidate/testing IDs
* View and update your demographic information
* Request additional copies of your certificates (softcopy via email or hardcopy)
* Download the IBM Certification marks to which you are entitled
Remember, certification results are confidential to you, so if you have earned a certification, the only way for your manager to know is if you tell them. I suggest that you print a copy of the certificate and give it directly to your manager.
I prefer to send people to amazon and its related sites for people to purchase technical books for their great prices, ranking and review system, and international presence. Outside of amazon, I would recommend the following places:
This is the "bookstore" that my team maintains. We choose a new title roughly every month and usually link from the book to amazon.com.
This is the site that is maintained by IBM and is updated with the latest on the IBM Press books that are available.
This is the site that our publishing partner, Pearson Education, updates. From here you can get a newsletter, purchase books, get chapter downloads, and more. Quite often we'll point to this site if we have an electronic coupon that we are promoting.
If you DO NOT reside in the US and would like to purchase books in your local currency with lower shipping costs, use this link. From here you can get to our Canadian http://www.pearsontechnology.ca/DB2/ or European http://www.pearson-books.com/ibmpressbookshop/ IBM Press pages. We've also listed the books that are available in translated or low cost editions with details as to how you can order them.
5) http://safari.informit.com/ or http://www.books24x7.com
For electronic versions of books see either of these sites. IBM employees have a subscription to books 24x7, but many universities, colleges, and business have a subscription to Safari. Both engines allow individual subscribers as well.
If you work for IBM, go to this site for details on how to access employee purchase sites.
I'd like to say that you can also buy technical books in bookstores, but this is usually only true for mass appeal books. One day I hope that DB2 books move into this category!
If you have another favourite place where you buy books, share your information.
The latest edition of certmag.com has an article about using advanced certifications to advance your career:
After reading this article, I checked our database to see the how many people have been certifed at our Advanced DBA level (you need to pass Exam 704 after achieving a DBA cert): http://www.ibm.com/certify/certs/dbdvud81.shtml.
Although I can't tell you how many certifications have been achieved, I can tell you that only 7% of those who have earned a IBM Certified Database Administrator - DB2 UDB V8.1 for Linux, UNIX and Windows have also earned the Advanced DBA certification.
I really believe that anyone who has passed Exam 701 also has a good chance of passing Exam 704. If you are one of these people, take the challenge and try Exam 704.
Exam 704 contains a total of 57 questions. Candidates are required to score 56% or better to pass the exam and will have 75 minutes to complete the exam.
Section 1 - Advanced Administration (32%)
Ability to design table spaces
Ability to create table spaces
Ability to manage table spaces
Ability to design buffer pools
Ability to create buffer pools
Ability to manage buffer pools
Ability to exploit intra-parallelism
Ability to exploit inter- parallelism
Ability to design and configure federated database access
Ability to manage distributed unit of work
Section 2 - High Availability (19%)
Ability to develop a logging strategy
Ability to use advanced backup features
Ability to use advanced recovery features
Ability to implement a standby database (log shipping, replication, failover, fault monitor)
Section 3 - Performance and Scalability (37%)
Identify and use configuration parameters that affect database system performance
Identify and use DB2 registry variables that affect database system performance
Knowledge of query optimizer concepts
Ability to manage and tune memory and I/O
Ability to analyze performance problems
Ability to manage a large number of users and connections
Ability to partition large amounts of data for performance
Ability to manage the number of partitions in a database
Ability to create and manage multi-dimensional clustered tables
Ability to determine the more appropriate index
Section 4 - Networking & Security (12%)
Ability to configure a partitioned database on multiple servers
Ability to manage connections to host systems
Ability to identify and resolve connection problems
Knowledge of external authentication mechanisms
Ability to implement data encryption
The best way to prepare for this exam is a combination of EXPERIENCE and STUDY. The only book that was written for this exam is:
Advanced DBA Certification Guide and Reference for DB2 UDB v8 for Linux, Unix and Windows
by Dwaine Snow and Thomas Phan
Notice that this book has received 12 customer comments on amazon: all 5 stars, except one 4 star.
One of the features of this book that I want to make you aware of is that there are excellent sample study questions in the book. Each chapter contains several questions that are similar to the questions that you'll see on the certification exam. The authors then tell you which answer is correct, and why. Dwaine was on the exam development team and helped create many of the questions that are on the certification exam, so make sure you benefit from his knowledge by reading this book!
Yesterday I participated in a workshop about business blogs - The Business of Blogging: Being Social in a Pervasive, Networked World.
The speakers discussed the history of blogging, tools that are available, research on who is blogging, as well as the issues of using blogs for business.
Speakers included Alvin Chin and Mark Chignell from University of Toronto, Joey de Villa from Tucows, Ian Graham from BMO Financial Group, and Veronica Holmes from Bell Canada.
From the research, it was shown that people who read blogs are highly educated people in their 30s or 40s who earn high salaries. Primarily, bloggers are looking for information that is hard to find in other places. You can see why businesses are getting more and more interested in setting up blogs to support their products / services.
For more information on CASCON, as well as details of all the conference proceedings, see https://www.ibm.com/ibm/cas/cascon/[Read More]