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.
Keep on Learning
svisser1 2700018UK9 2,791 Views
IBM Informix Dynamic Server 11, the Next Generation in OLTP Data Server Technology was written by one of the industry's foremost authorities on IDS 11, Carlton Doe. The availability of this book is very limited... but one way you can guarantee yourself a copy is through our latest promotion.
Attend one of the following IDS classes between now and December 31, 2007 you will receive a copy of this book:
IBM Informix Stored Procedures and Triggers (FN335)IBM Informix Structured Query Language (FN613)IBM Informix Advanced Structured Query Language (FN757)Managing and Optimizing IBM Informix Dynamic Server Databases (FN848)IBM Informix Dynamic Server Administration (L1846)IBM Informix Dynamic Server Enterprise Replication (L2615)Troubleshooting IBM Informix Dynamic Server (L2880)Informix Dynamic Server 11 Systems Administration (IX810)Informix Dynamic Server 11 Database Administration: Managing and Optimizing Data (IX220)Informix Dynamic Server 11 Replication (IX420)IBM Informix Dynamic Server Advanced Performance Tuning (MW729)
For detailed information, visit our offer page.
PS... the book has proven to be extremely popular, so clearly there is a need for new books on IDS!
svisser1 2700018UK9 2,755 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.
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 2,937 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 2,724 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 2,517 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....