Many people were able to purchase the featured books at the IOD conference, but if you were not able to attend the conference, perhaps you'll be interested in knowing the titles of the top 10 books that were sold at the conference.
DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification: Certification Study Guide by Roger E. Sanders, Dwaine R Snow
Competing on Analytics: The New Science of Winning by Thomas H. Davenport, Jeanne G. Harris
The 4-Hour Workweek: Escape 9-5, Live Anywhere, and Join the New Rich by Timothy Ferriss
DB2 9 for z/OS Database Administration: Certification Study Guide by Susan Lawson, Daniel Luksetich
IBM Cognos 8 Business Intelligence: The Official Guide by Dan Volitich
DB2 9 Fundamentals Certification Study Guide by Roger E. Sanders
Administering Informix Dynamic Server: Building the Foundation by Carlton Doe
DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide by Roger E. Sanders
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
DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition) by George Baklarz, Paul C. Zikopoulos
These books can be purchased from online booksellers such as amazon.com and may be available on Books 24x7 for IBMers (w3.ibm.com/learning)).[Read More]
Keep on Learning
Join Hans Miseur and others on the LinkedIn group IDUG Europe 2009 to discuss plans for next year's IDUG conference in Rome.
The current question is regarding whether people are interested in attending a crammer course for Exam 737: DB2 9 System Administration for z/OS. The exam is really new... here are the objectives of the exam:
This certification exam certifies that the successful candidate has important knowledge, skills, and abilities necessary to describe the architecture and administer the processes required to plan, install, manage, and tune secure DB2 for z/OS environments.
Section 1 - Installation and Migration (15%)
1. Given a scenario, demonstrate knowledge of the installation/migration plan process2. Given a scenario, describe how to execute the installation/migration plan3. Evaluate appropriate DSNZPARM settings
Section 2 - Security and Auditing (7%)
1. Given a scenario, demonstrate knowledge of how to protect DB2 subsystem and resources2. Describe auditing techniques3. Describe role-based security and the advantage of deploying it
Section 3 - System Operation and Maintenance (21.5%)
1. Describe how to use and manage DB2 components and processes2. Demonstrate knowledge of DB2 commands3. Given a scenario, describe how to monitor an dcontrol DB2 threads4. Demonstrate knowledge of DB2 commands
Section 4 - Backup and Recovery (20%)
1. Demonstrate knowledge of system level backup and recovery procedures2. Given a scenario, describe how to recover from system failures3. Describe the process for disaster recovery
Section 5 - Performance and Tuning (21.5%)
1. Given a scenario, analyze performance2. Demonstrate knowledge of how buffer pools and ZPARMs can affect performance3. Demonstrate knowledge of statistics, tools, and traces used for monitoring4. Given a scenario, describe techniques to achieve efficient use of memory5. Demonstrate knowledge of workload manager settings for DB2
Section 6 - Troubleshooting (15%)
1. Given a scenario, describe which documentation can be used to solve a problem2. Demonstrate knowledge of operator commands and traces fro troubleshooting3. Describe how to identify contention problems4. Demonstrate knowledge of diagnostic utilities5. Given a scenario, identify and resolve data sharing problems
How can you study for the exam? Currently there are two courses listed on the Exam Preparation page: DB2 9 for z/OS System Administration, Course number: CV85, and DB2 9 for z/OS Implementation Workshop, Course number: CV86.
I personally would like to see a book published in the MC Press certification study series. What do you think? Are you interested in taking this exam? Would you also want a related book? I have an author and an outline, I just need to be sure that there are interested people once the books is available.
Let me know either in a comment to this blog entry, or by sending me an email directly.... or via the linkedIN entry that Hans started. Looking forward to hearing from you.
I'm back to work after IOD and a well-needed vacation. Here is an update on how our community is growing. ChannelDB2.com has nearly 800 members! Many of them are students... but I hope all are finding information that is useful.
Here are some communities that you can join:
Channeldb2, Planetdb2, Informix Zone, the XML Contest homepage, DB2 ListServ, comp.databases.informix, developerWorks forums, groups on facebook and linkedin. There are groups within channeldb2.com that you can join: such as:
* DB2 in Books
* DB2 for Linux, UNIX, Windows
* DB2 for z/OS
* IOD Conference
We have a great community... I've witnessed it first hand! Be active so YOU can help make our online communities better!
This is my last working day before I fly to Vegas for the IOD Conference. I arrive on Saturday morning and will begin my work by ensuring that all the packages (aka books) have arrived as expected. I meet with a publisher on Saturday night and then the full days begin on Sunday. Here is my schedule, so I hope we cross paths once or twice if you're in Vegas as well!
Sunday October 26 7:00 am - 9:30 pm --> Conference Registration12:00 pm - 8:00 pm --> Bookstore - Ellice Uffer10:00 am – 4:00 pm --> Certification Lab - Susan Dykman, Certification Program Manager12:00 pm - 7:00 pm --> Skills Hub - Heather Ramsey, Education Marketing Manager1:00 pm - 4:30 pm --> How to Navigate the Conference 6:00 pm - 8:00 pm --> EXPO Solution Center Grand Opening Reception 6:00 pm --> Ensure pureXML for Dummies at ped, see Conor O'Mahoney8:00 pm – 10:00 pm --> Community Receptions
Monday October 27 10:00 am – 8:00 pm --> Bookstore10:00 am – 5:00 pm --> Certification Lab10:15 am – 6:00 pm --> Skills Hub6:45 am - 7:45 am --> Breakfast8:15 am - 10:00 am --> GRAND OPENING SESSION (events center): "Unlock the Business Value of Your Information" with Ambuj Goyal, Steve Mills, Jon Iwata10:00 am - 11:00 am --> Outside Events Center, Judith Hurwitz, Fern Halper sign Information On Demand for Dummies book.10:30 am - 11:30 am --> Events Center, Business Intelligence and Performance Management with Rob Ashe, General Manager, BI & Performance Management11:30 am - 12:30 am --> Outside Events Center Bill Wong, Paulo Pereira, Dr. Guenter Sauter, Dr. William O’Connell, Bryan Byrne, Phil Downey, Dan Wolfson, Rex Wiederanders, Harriet Fryman, Alan Meyer signing Driving Business Optimization with Trusted Information11:30 am – 2:00 pm --> Lunch12:30 pm – 8:00 pm --> EXPO Solution Center Open2:15 pm - 3:15 pm --> Events Center, Data Management with Arvind Krishna, Vice President, Database Servers3:15 pm – 4:15 pm --> Outside Events Center, Paul Zikopoulos, Belal Tassi, Dwaine Snow, Aamer Sachedina signing of Viper Strikes Again 3:15 pm – 4:15 pm --> Outside Events Center, Carlton Doe signing IBM Informix Dynamic Server 11 and Addendum: IBM Informix Dynamic Server 11.5 Addendum3:15 pm – 4:15 pm --> Mandalay Bay H, Copies of Driving Business Optimization with Trusted Information available at Greg Lotko’s session.5:00 pm - 8:00 pm --> EXPO Solution Center Reception5:30 pm – 7:30 pm --> Reception with Doug White and Paul Zikopoulos8:00 pm - ?? --> Fourth Millennium Technologies' Annual Hospitality Party Tuesday October 28 7:30 am - 7:00 pm --> Bookstore7:00 am – 5:00 pm --> Certification Lab10:00 am – 6:00 pm --> Skills Hub10:00 am – 5:00 pm --> Certification “Members Only” Lounge Open7:00 am - 8:00 am --> Breakfast8:30 am - 9:30 am --> Events Center, GENERAL SESSION "What's Your Information Agenda Approach?" featuring Tom Davenport and Panel of Innovators10:30 am - 11:30 am --> Bayside Foyer, Level 1 of the Mandalay Bay Convention Center, Tom Davenport signing book Competing on Analytics: The New Science of Winning10:00 am - 11:00 am --> Events Center, InfoSphere with Jim Welch, Vice President, InfoSphere11:00 am - 12:00 am --> Outside Events Center, Bill Wong, Paulo Pereira, Dr. Guenter Sauter, Dr. William O’Connell, Bryan Byrne, Phil Downey, Dan Wolfson, Rex Wiederanders, Harriet Fryman, Alan Meyer signing Driving Business Optimization with Trusted Information12:30 am - 7:00 pm --> EXPO Solution Center Open 12:30 pm - 2:00 pm --> Lunch2:15 pm – 3:15 pm --> Session TBI-2814, giveaway of book The Execution Premium: Linking Strategy to Operations for Competitive Advantage4:00 pm - 5:00 pm --> Bayside Foyer, Level 1 of the Mandalay Bay Convention Center, Maria Villar signing of book: The business of data from chaos to confidence. 5:00 pm - 7:00 pm --> EXPO Solution Center Reception7:00 pm – 11:00 pm --> Networking Halloween Party
Wednesday October 29 7:30 am - 4:00 pm --> Bookstore7:00 am - 8:00 am --> Breakfast7:00 am – 6:30 pm --> Certification Lab10:00 am – 6:00 pm --> Skills Hub10:00 am – 5:00 pm --> Certification “Members Only” Lounge Open8:30 am - 9:30 am --> GENERAL SESSION "Future of Information Management" featuring Dr. Irving Wladawsky-Berger12:00 pm - 2:00 pm --> Outside the InfoSphere demo room (on the 2nd floor), Allen Dreibelbis, Eberhard Hechler, Ivan Milman, Martin Oberhofer, Paul Van Run, Dan Wolfson signing Enterprise Master Data Management: An SOA Approach to Managing Core Information. Tickets will be issued at IP&S sessions and book can be picked up in IP&S Demo Room – Mandalay Bay J&K.12:30 pm - 2:00 pm --> Lunch12:30 pm - 3:45 pm --> EXPO Solution Center Open1:30 pm - 2:30 pm --> Bayside Foyer, Level 1 of the Mandalay Bay Convention Center, Roger E. Sanders, Dwaine R Snow signing DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification: Certification Study Guide1:30 pm - 2:30 pm --> Bayside Foyer, Level 1 of the Mandalay Bay Convention Center Carlton Doe signing Administering Informix Dynamic Server: Building the Foundation3:00 pm – 4:00 pm --> Bayside Foyer, Level 1 of the Mandalay Bay Convention Center George Baklarz, Paul Zikopoulos signing DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition)6:00 pm - 7:00 pm --> Pick up ticket from Express C people, BOF-2502A DB2 - Free as in Beer on Wednesday October 29 6-7pm6:00 pm - 7:00 pm --> Mandalay Bay South - Breakers G, IOD BOF: Data Management Blogging Community (not just for bloggers!)6:00 pm - 7:00 pm --> Location: Mandalay Bay South Convention Center - South Seas A-B, BOF-2267A Women In Technology: Leveraging Our Unique Abilities to Build Success6:30 pm --> House of Blues, Mandalay Bay, DB2's 25th Anniversary Reception
Yes, I'll be busy... as will all attendees at the event!
Today I received my copies today.... what a great book!
Expert Preparation for Exam 734 - DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification Study Guide. This book contains everything you'll need to study for Exam 734 AND is full of reference details that go far beyond the exam!
With this book, you will:
• Gain the knowledge necessary to pass the DB2 9 Advanced Database Administration for Linux, UNIX, and Windows exam (Exam 734)
• Receive an explanation of every topic included on the test…by experts involved in the creation of the actual exam
• Find appendices with information beyond the test requirements on monitoring buffer pool activity, using MQTs, employing advanced joining techniques, and using the Explain Tools.
• Discover over 100 sample questions plus a 120-question practice exam, all with comprehensive answers and explanations
Congratulations to authors Dwaine Snow and Roger Sanders on the release of their latest book!
Thanks also to the team of reviewers who ensured that the book was accurate and had the quality that you demand:
Bob BernardRoger ArchambaultMelanie StopferMatthew RheaDan TuckAdil SardarNick TchervenskiEmilia CifaniSalma ElshatanoufyTariq Al-OmariKevin See
I received amazing feedback from a reader that I want to share with you:
This person took Exam 734 and didn't pass. She asked me for a recommendation, so I gave her an early version of the book on the condition that she would give me feedback. She read the book and tried the exam again... and this time passed. She says the book was essential to her passing the exam!
I can't send out an early version of the book to everyone, but this testimonial is very encouraging to me in my quest have quality, useful books published. I hope everyone who reads the book can say the same thing... and please say it publicly as we all benefit from your feedback.
If you are attending IOD, you can purchase a copy of the book while at the conference for a discount that is offered for attendees.
You can also meet the authors Roger E. Sanders and Dwaine R Snowand have them sign YOUR copy ofDB2 9 for Linux, UNIX, and Windows Advanced Database Administration...on Wednesday Oct 29, 1:30 – 2:30at the Book Signing Area in Bayside Foyer.
Enjoy the book... and make sure you get your copy ASAP... they'll go fast!
If you are a DBA and only want to buy a single book to have as a reference, here's what I suggest:
DB2 for Linux, UNIX, and Windows
DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition)
Written by long time DB2 experts and DB2 evangelists, George Baklarz and Paul Zikopoulos, this book is the reference and guide that you will use over and over as you do your job!
DB2 for z/OS
DB2 Developer's Guide (5th Edition) by long time DB2 expert and consultant, Craig Mullins. This book keeps on selling and selling... so it may be that everyone who works on DB2 for z/OS already owns a copy! If you don't, you should!
Informix Dynamic Server
Administering Informix Dynamic Server: Building the Foundation by long time IDS expert Carlton Doe. At this point, this is the ONLY up to date IDS book that is available! Buy it because it WILL update you on all the changes in the product, but also, the more books that sell, the more likely it is that we'll have more IDS books published!
If you do not find that these books fill your needs... don't worry... we have many others! See our IBM IM Bookstore and the channelDB2.com DB2inBooks discussion group.
(Practice) test yourself : Online Information Management pre-exams
Come prepared for complimentary exams offered at the IBM Information On Demand 2008 conference, coming to Las Vegas Oct. 26 - 31, with free Information Management certification practice tests. Usually offered through Prometric for a fee, take these tests online for at no charge for two weeks leading up to the conference.
How? If you are registered for the conference, you will receive an email containing your promocode allowing you to take the practice test for FREE.
If the results of the practice test indicate that you need to improve your skills... here are a few suggestions:
Exam Preparation Documents
For exam objectives and cutscores for each exam, see the exam preparation documents.
We now have an extensive collection of Certification Prep Guides, including
DB2 9 Fundamentals Certification Study Guide for Exam 730 by Roger Sanders
DB2 9 Database Administration Certification Study Guide for Exam 731 by Roger Sanders
DB2 9 for z/OS Database Administration Certification Study Guide for Exam 732 by Susan Lawson and Dan Luksetich
DB2 9 for Linux, UNIX, and Windows Advanced Database Administration Certification: Certification Study Guide for Exam 734 by Roger Sanders and Dwaine Snow
DB2 9 Database Administration Upgrade Certification Study Guide for Exam 736 by Roger Sanders
See also the DB2inBooks group on channeldb2.com.
Pre-Conference Crammer Courses
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.
Remember: Those who are certified are eligible to attend the certification lounge at the IOD conferences... for FREE MASSAGES!
For additional conference information, see also the IOD Conference group on channeldb2.com.
Thanks to Rafael Coss for providing me with this list of published articles about pureQuery that I can share with you!
1) IBM Data Studio software: "The big picture" - Managing information for maximum value throughout the lifecycle by Holly Hayes 2) The Easy Way to Quick Data Access by Rafael A. Coss, Stephen A. Brodsky, and Vijay Bommireddipalli. IBM takes the drudgery out of JDBC programming with pureQuery, an integrated language that queries relational databases as well as Java collections and database caches. pureQuery and Data Web Services are components of the new IBM Data Studio, a new common database application development and administration platform. 3) IBM Data Studio pureQuery Runtime for z/OS Performance by Rajesh Sambandhan and Simon Harris. pureQuery improves application throughput on DB2 for z/OS by making it easy to code and deploy static SQL for Java. The new client optimization feature in Version 1.2 extends the benefits of static SQL to any existing Java application without changing or recompiling Java applications.
4) "No Excuses" Database Programming for Java - Make your programs fly with static SQL and pureQuery by Kathy Zeidenstein and Bill Bireley
5) Increase productivity in Java database development with new IBM pureQuery tools, Part 1: Overview of pureQuery tools - 10 unique scenarios, 10x productivity improvement by Sonali Surange
6) Write high performance, Java data access applications, Part 1: Introducing pureQuery annotated method style - Maximize security and configurability by Heather Lamb
7) Write high performance, Java data access applications, Part 2: Introducing pureQuery inline method style - Streamline common tasks for simplicity and usability by Daya Vivek
8) Write high performance Java data access applications, Part 3: Data Studio pureQuery API best practices - Learn about pureQuery best practices by looking at code snippets and real-world scenarios by Vitor Rodrigues
9) Optimize your existing JDBC applications using pureQuery - Improve security and performance for existing JDBC applications by Patrick Titzler and Zeus Courtois
Enjoy the articles. Consider also joining channelDB2.com to easily find articles like this.
In 2008, IBM introduced in-memory database technology known as solidDB. This week I found out that Lily Ryzebol is now on the solidDB team... and coincidentally, the ID person (Katriina) from Finland is visiting the lab this week and is sitting at a desk near me.
That's the extent of what I know about solidDB at this point, so if you're like me and would like to learn more, join this chat with the lab to learn more:
DB2 Chat with the Lab - Wednesday, October 15th 8AM Pacific, 10 AM Central, 11 AM Eastern, 4 PM London, 5 PM ParisIBM solidDB - Complementing DB2 to Provide up to 10X Data Acceleration
This presentation will cover the key capabilities of IBM solidDB * micro-second response time* high transaction throughput* instant failover
– and how those capabilities address the real-time requirements for data access in key DB2 markets including financial services, healthcare, retail, and communications.
The presentation will also provide details about how solidDB in-memory cache complements DB2 to accelerate response times and increase transaction throughput, achieving extreme speed for data residing in DB2. Use cases will be explored.
There will also be good opportunities for technical Q&A. Our speakers will be Sal Vella, Vice President of Development for Linux, Unix and Windows and Business Intelligence and Ari Valtanen, Director of solidDB Technology (CTO). Ari comes to IBM from the acquisition of Solid Information Technology, where he was Co-Founder, Senior Vice President and Chief Technology Officer. As a member of the founding team at Solid, Valtanen spent 7 years as an Architect in core product development in Helsinki, Finland. He will be speaking with us from the lab in Helsinki.
RSVP for this call at: DB2 chat with the Lab Series (7530145) or by calling 800-289-0579 and referencing confirmation code 7530145.
Yesterday I was a last minute attendee / booth girl for the BMODUG event that was taking place down the road from my office. I met up with many people I already knew (Tim Johnson, Yvonne Kulker, Joe Borges, Susan Lawson and Melanie Stopfer), but also met quite a few new people. I strongly encouraged the new people to take a look at my blog, so I'll do a short recap today.
At the booth, I was handing out DB2 Gaming DVDs. For those who were not able to get a copy here is the site ibm.com/software/data/education/games.html where you can learn more about the games and also where you can download what you need to play or share the games. Happy Gaming!
I also had a few copies of a DVD that was created last year that contained a bunch of IBM Redbooks. Although it is nice to have a DVD with all this content, it is best to get the IBM Redbooks from the website as you can be sure that the content is most current.
Pearson Education Canada supplied the postcards that provided a Canadian website for you to purchase IBM Press books. The offer is for a 35% discount. Books that you might want to consider from this site are: IBM Press in Canada.
Understanding DB2(R): Learning Visually with Examples (2nd Edition) The book is the best way to learn (or relearn) DB2 for Linux, Unix and Windows. The book is filled with case studies, study questions, and well-written details on everything you'll need to know. Some competitively trained people who have read this book have told me that this is exactly what they needed to take the fear out of switching to DB2!
DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep, 6th Edition This is the one book that all DBAs should have on their bookshelf. This book was written by George Baklarz and Paul Zikopoulos, two very well-known DB2 experts who know how to write a good book! The book is the best guide and reference that you can own and will surely be one of the most used books on your bookshelf.
Enterprise Master Data Management: An SOA Approach to Managing Core Information I mentioned this book to a few people yesterday. This is beyond a database topic... but is really insightful as to how data can be managed effectively throughout an industry... I read the book in draft form about a year ago and am surprised with the amount that I've been able to retain. I highly recommend this book if you are looking for a place to go beyond data.
I helped a few people with some certification questions that I have... and since today is testing day, I hope everyone does well on their exams! The best places on the web to go to are:
1) To help you decide where to start, see the certification roadmaps: ibm.com/software/data/education/cert-roadmaps.html.
2) For a breakdown of the exam objectives and the recommended study materials, see ibm.com/software/data/education/certprep.html
Many people were interested in the information I was giving about the ILO classes that are now available. ILO = instructor-led online and means that you sit at your desk at home or work and take part in an actual class via your computer (headphones and mic absolutely essential). You interact with the instructor and the other classmates as you would if you were sitting in a class with them, but you do it without needing to travel! There are 70 different ILO classes now available, some are short and take place in the evening, but others are full day classes. For all information, see: Instructor-Led Online Training. See also a recent blog entry that I wrote.
And finally, community! You are all community, so consider joining one of the groups on ChannelDB2.com:
DB2 in Books
I've listed every published book in this discussion group and I encourage you to use this as a way to reach the authors or to find related information such as events that the authors are taking part in, podcasts or webinars that are related to the book topic, and so on....
DB2 for Linux, UNIX, Windows
This is a place where you can find information about anything related to DB2 for LUW. Feel free to add discussions for areas that are not yet created. I've created a few discussions that you might find useful, including information about the latest ILO courses or current promotions that are being offered.
DB2 for z/OS
Same as the one above, only content is specific to the z platform.
I just started this group to be a collection of the many things that are happening at the IOD conference. With so much information being sent on a daily basis in regards to the conference, isn't it nice to have one spot that collects that information? And better yet, this is a place where you can share your thoughts on events that are taking place at the conference.
What do you think? Worth checking out? I hope so. When you're a member, make me a friend! A girl can never have too many friends!