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.
The developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this blog will no longer be available. More details available on our FAQ.
Keep on Learning
From archive: August 2007 X
svisser1 2700018UK9 4,315 Views
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.
With the summer holidays coming to an end (sad).... and school about to start for a good portion of the population... it seems like the right time to give you a summary of all the IM books we've published this year so far... and those that are coming very soon.
I'm very proud of the number of books and the breadth of content that we covered this year... with quite a few more still on their way! I hope you are able to find one or two books that match your needs perfectly!
Understanding DB2 9 Security (IBM Press) by Rebecca Bond, Kevin Yeung-Kuen See (IBM), Carmen Ka Man Wong (IBM), Yuk-Kuen Henry Chan (IBM). Promotion: Q&A with Rebecca Bond.
IBM DB2 9 New Features (McGraw-Hill) by Paul Zikopoulos, George Baklarz, Leon Katsnelson, Chris Eaton (all IBM)
DB2 9 Fundamentals Certification Study Guide (MC Press) by Roger Sanders
IBM Informix Dynamic Server 11, the Next Generation in OLTP Data Server Technology (MC Press) by Carlton Doe (IBM)Distributed by IBM at selected events.
Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more (Morgan Kaufmann) by Sam Lightstone (IBM), Toby J. Teorey, Tom Nadeau Published March 21, 2007 and covers DB2, Oracle, SQL Server, and other databases
Mining the Talk: Unlocking the Business Value in Unstructured Information by Scott Spangler, Jeffrey Kreulen (both IBM)Written by IBM researchers, so product teams were not involved in creating or reviewing content. Doesn’t describe a product that is for sale, but techniques used in research at IBM and by IBM consultants on customer service engagements. IBM Alphaworks provides a free demonstration copy of one of the early text-mining tools called IBM Unstructured Information Modeler, as an adjunct to this book: alphaworks.ibm.com/tech/uimodeler.
ABOUT TO PUBLISH
DB2 9 for Linux, Unix, and Windows: DBA Guide, Reference and Exam Prep (IBM Press) by George Baklarz (Author), Bill Wong (Author), Paul C. Zikopoulos (Author)- Sixth Edition of our most popular book EVER!
DB2 for Developers (MC Press) by Phil Gunning - expected in December.... SPECIAL 37% PRE-ORDER DISCOUNT!
DB2 9 for z/OS Database Administration Certification Study Guide for Exam 732 (MC Press) by Susan Lawson and Dan Luksetich - October - SPECIAL 30% DISCOUNT ON PRE-ORDERS!
Building an Intelligent Web: Theory and Practice (Jones & Bartlett Publishers) – to include DB2 Express; book is a university text book. - expected in Oct.
DB2 9 Database Administration Certification Study Guide for Exam 731 (MC Press) by Roger Sanders - October
DB2 9 Database Administration Upgrade Certification Study Guide for Exam 736 (MC Press) by Roger Sanders
WHERE TO BUY?You can buy these books in most countries in the world. We have set up a bookstore website to give you URLs for the sites that give the best prices: ibm.com/software/data/education/bookstore. Choose the international tab on this page for locations outside of the US, including Canada.
I have a few other really interesting projects in the works, but I'll wait to tell you about those once I have a few more details firmed up.
As always, stay tuned :)
svisser1 2700018UK9 4,518 Views
I hope many of you are able to join us in Las Vegas this October for the second annual Information On Demand Global Conference. If you are able to come, remember that tomorrow is the deadline for the Early Bird Special where you can save $200 on registration.
I've been putting together a book signing schedule for some of the speakers who are also authors. Those who are confirmed for a signing:
1) Stephen Covey - The 8th Habit: From Effectiveness to Greatness2) Chris Anderson - The Long Tail3) Paul Zikopoulos - To be announced at the conference.4) Carlton Doe - IBM Informix Dynamic Server 11, The Next Generation of OLTP Data Server Technology5) Carl Kessler - Outside-in Software Development: A Practical Approach to Building Successful Stakeholder-based Products
In addition, here is what the team has planned for this year's conference:
* 7,000+ attendees * 200+ customer and Business Partner speakers* An Expo Solutions Center powered by 200 Business Partners* More compelling content: 589 total elective 1 hour sessions; 100 Business Leader sessions; 468 Technical Skill Building sessions* More technical opportunities* Enhanced community programs* And the list goes on . . .
I hope to see you there! Besides the book signings, you'll find me helping in the certification lounge.... were you there last year with all the decadent food and even better: the massages!
Have you seen this yet?
Watch DB2 on YouTube
Rav Ahuja has been posting video interviews with DB2 Viper 2 architects on YouTube. This is part of his Voice of the DB2 Community podcast series.
You can find all the videos on YouTube’s Channel DB2. The videos are also available at the Channel DB2 social network.
Thanks to John P. Kennedy for this information!!
I wanted to make sure that you were aware of this promotion that my team is currently running:
With every qualifying IBM Information Management classroom training course you attend between June 5, 2007 and October 31, 2007, you will receive a certification discount voucher good for 50% off the cost of an eligible Information Management certification exam. Along with industry recognition, IBM Certified Professionals proudly get to display the IBM Certified Professional Logo and will receive an official Information Management Certified Professional t-shirt!
For a list of the eligible courses and exams... as well as the usual legal verbiage, see our Train and Save Promotion page.
Distinguish yourself in this highly skilled marketplace by joining our elite group of IBM Certified Professionals, there is no better time!
svisser1 2700018UK9 4,365 Views
Have you ever looked at the annual results of the Certification Magazine Salary Survey? This year, take part in the survey to see how your salary measures up to the others who answer the survey!
Here are the details:
On Aug. 7, 2007 Certification Magazine launched its 2007 Salary Survey, which compiles compensation, certification and education information for IT professionals. The Litchfield Group, an independent research company, will conduct the research and finalize the data. The survey will close Friday, Aug. 31. To participate in this year’s survey, visit www.certmag.com/salarysurvey.
Last year, 22 companies agreed to partner with Certification Magazine as Salary Survey sponsors. Their extensive promotional efforts via e-mail, newsletters and Web sites helped draw more than 35,000 respondents worldwide — given this participation level, it was truly an industry-wide survey. This year, 23 companies have agreed to partner with Certification Magazine as Salary Survey sponsors. Additionally, the survey has been revised to expand its scope to represent the industry as a whole. The survey results will be reported in the cover story of Certification Magazine’s December 2007 issue. Every year, this article provides vital analysis on the state of the certification industry and IT in general. To ensure delivery of the December issue, sign up for a FREE subscription to Certification Magazine at www.certmag.com/subscribe.
svisser1 2700018UK9 3,891 Views
Check out Daniel Krook's blog from Aug 3: "Thoughts on the DB2 9 Fundamentals exam" where he discusses his study strategy and experience in preparing for, and passing, Exam 730: DB2 9 Fundamentals. You can find Daniel's blog, plus many others on PlanetDB2.
Let me know if you want to share your thoughts as well....
Quite a few people in the Toronto Lab are upgrading their certifications to the V9 level this summer, and I thought I'd pass on study tips for Exam 733 that I learned from the candidates this week.
1) There isn't a book available for Exam 733, nor is there one in plan. People recommend reading the V8 book by Roger Sanders to help prepare for Exam 733. If you work for IBM, remember that you can access this and other books through Books 24x7.
2) The two biggest additions to the 733 exam versus the 703 exam is .net and XML content. Of course, neither of these topics are covered to a great extent in the V8 book.
3) There are free tutorials for Exam 733, and it is recommended that you use these to prepare for at least the .net and XML areas, but perhaps reading all the 733 tutorials would be beneficial.
4) Not many of the people here take the assessment exams, but they are still valuable at helping you gauge your readiness to pass the exam.
Now available for pre-orders: Expert Preparation for Exam 732: DB2 9 for z/OS Database Administration Certification Study Guide by Susan Lawson and Daniel Luksetich.
The book is expected to publish BEFORE the IOD conference in October despite the website saying the book publishes in November.
Book Description:DB2 9 for z/OS Database Administration Certification Study Guide is the definitive guide to preparing for the IBM Certification 732 Version 9 DBA Certification Exam. The book covers all topics on the exam and also provides a wealth of information about DB2 z/OS Version 9. It also includes a lot of practical information and tips for best performance and usage of DB2. The book is written by two industry experts who were both members of the team that created the 732 exam.
This book covers all of the topics that are on the exam: Database design and implementation, operation and recovery, security and auditing, performance, and installation and migration. There are practice questions with detailed answers at the end of each chapter as well as an 80+ question practice exam. But beyond certification prep, it also covers the new features of version 9 for both database and application development. It will serve as an essential tool for studying for exam 732 as well as a reference that all DB2 DBAs will want on their desktops.
732 Exam Objectives Covered in the Book: * Section 1 - Database Design and Implementation* Section 2 - Operation and Recovery* Section 3 - Security and Auditing* Section 4 – Performance* Section 5 - Installation and Migration/Upgrade
Table of Contents: Preface 1. DB2 Product Fundamentals 2. Environment 3. Access and Security 4. Database Objects 5. Retrieving & Manipulating Objects 6. Advanced SQL Coding 7. Maintaining Data 8. Recovery and Restart 9. Data Sharing 10. Using SQL in an Application Program 11. Binding an Application 12. Application Program Features 13. Stored Procedures 14. Accessing Distributed Data 15. Advanced Functionality 16. Locking and Concurrency 17. Performance, Monitoring, and Tuning Appendix A: DB2 Sample Database Appendix B: Practice Exam Questions Appendix C: Practice Exam Answers