If you or someone you know is looking to learn DB2, I recommend these two books:
Beginning DB2: From Novice to Professional (Expert's Voice) by Grant Allen
Understanding DB2(R): Learning Visually with Examples (2nd Edition) by Raul F. Chong, Xiaomei Wang, Michael Dang, Dwaine R. Snow
Both of these books are excellent choices if you are trained on a competitive database and wish to quickly transfer your skills to DB2.
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: November 2008 X
I had forgotten that I saw this cool youtube.com video about Mashups... that I encourage you to take a look at. I met up with Guylaine Cantin today and she reminded me.
Introduction to Mashups Video: Learn what mashups are and why they matter with this short animated video. (Click on the link to the video in the featured news section.)
I hope you enjoy.
Guylaine also mentioned that there is a wide range of information regarding this technology on the following site: greenhouse.lotus.com
Check out this new ILO course:Managing IDS Using the SQL Admin API and Scheduler ILO course (3S301)
In this course, learn about the features of the Informix SQL Administration Application Programming Interface (API). Learn how to write SQL statements to perform a variety of system administration tasks, and will see different ways in which the Administration API can be used. Also learn about the Informix Dynamic Server (IDS) Scheduler and how to create tasks to be performed at regular times or intervals. You will also learn how to create sensors to gather system information into tables over time. Examples will be presented on how tasks and sensors can be used.View this course in other countries
Note: This is an Instructor Led On Line course. Please do not make travel arrangements for this course. Your system should have a microphone and speakers for interfacing with the instructor and other students. After you receive confirmation that you are enrolled, you will be sent further instructions to access audio, video and remote labs.
This course is eligible for the IBM Education Advantage Program.
Audience This is an intermediate course for Informix Dynamic Server System and Database Administrators.
PrerequisitesYou should have: IBM Informix Dynamic Server System Administration (IX810) or (IX811), or 6 months experience with IDS system administration.
Skills taught * Distinguish between the task and admin functions * Write SQL commands to perform administration tasks * Create and schedule administrative tasks * Create and schedule sensors to collect system information * Analyze the information collected by sensors
I. The sysadmin Database
II. SQL Administration API
* API functions: admin and task * Admin API commands and options * Administration command examples * ONMODE examples * Admin API scenarios
III. Built-in Database Scheduler
* Creating and scheduling a task * Task examples * Creating and scheduling a sensor * Built-in sensors * Sensor examples * Task and sensor scenarios
Course code: 3S301 Skill level: IntermediateDuration: 0.5 days Delivery type: ClassroomCourse type: Public only Public price: USD $199.00 plus tax
Make sure you check the course catalog regularly for new Instructor Led On Line courses as they launch.
When at the IOD Conference, I had the pleasure of meeting two people who are experts in the mashup area: Bobbi Cochrane and Ginny Ghezzo. On both occasions we randomly met while eating breakfast... and ended up talking about mashups with all the people sitting at the table.
Bobbi gave me a card that introduced the IBM Mashup Center which is an enterprise mashup platform to unlock data, remix content, and unleash productivity. Give it a try on greenhouse.lotus.com.
Also at the conference I met the publishers from Wiley who publish the Dummies series of books. They mentioned that they are interested in new titles including one on mashups. That brings me to mashup experts in Haifa: Ohad Greenshpan and Aya Soffer who have written several articles on the topic... and may make excellent authors of a book.
The IBM Database Magazine that came out today introduced me to the Mashup Camp which looks very interesting. The website calls it The Unconference for the Uncomputer. This issue also has a link to the a podcast of Curt Cotner speaking about mashups.
So far I can only find two books on amazon about mashups: Pro Web 2.0 Mashups: Remixing Data and Web Services (Expert's Voice in Web Development) by Raymond Yee. There are 4 reader comments on amazon, all positive, but let me know if you've read the book and if you recommend it. It published in February this year, so it is fairly recent.
A search on developerWorks brings up 359 matches on the keyword mashups.... so, you'll be able to find many articles if you search, including this one: Choosing between mashups and traditional Web applications - Considerations for leveraging IBM Mashup Center.
I'm looking forward to learning more about this area and hope you are as well.
svisser1 2700018UK9 4,643 Views
They're nearly all gone! Don't miss out on the chance to get your very own Chumby. You must enroll in an eligible U.S. class by December 9 and attend by December 12.
For more information, including a list of eligible classes, see the chumby site.
Enjoy! And... if you get one, be sure to tell me how much you like it. A chumby was on display at the IOD conference and it looks pretty interesting!
Another author we featured at the IOD conference was Maria Villar. Maria and Theresa Kushner recently published the book Managing Your Business Data: From Chaos to Confidence.
I didn't attend Maria's sessions, but had the pleasure of sitting with Maria while she did a book signing! I very much enjoyed my time with Maria and could tell by the comments from the people who did attend the session and came to buy a book, they they were captivated by Maria's ideas.
I now have a copy of the book and intend to read it. Take a look for it. It should be on amazon.com very soon, but you can also get it direct from the publisher racombooks.com.
What's in the book? Here is the information from the publisher:
As a business person, you probably have more data and more kinds of data available than ever before. But has it helped? Sometimes, maybe. But, for many executives more data has just added more fuel to feed the fire of their love/hate relationship with it. You love it when it gives you good information about which markets to pursue or how to compete more effectively. But you hate it when you can’t get sales figures in time or worse still, when they don’t reflect "reality."
This book was written for the executive who wants to understand the lifeblood of his/her company, wants to be able to make better decisions, and knows that managing information is the best way to protect and grow a business. This book is designed to help you as a business leader think about the use of data and its impact on your daily operation. In 2 sections and 12 chapters it provides practical guidance to balance the use of hard facts and your professional instincts; how to identify and focus on the numbers that matter for your organization; how to overcome the obstacles to getting a complete view of your customer; how to meet risk and security standards; 12 steps to effective business performance management; and how to grow a data culture and make it work for you.
Newly minted MBAs are known for saying, “Just give me your number.” Savvy managers know that it’s not that simple. They also know that it’s not that difficult. Managing Your Business Data provides the wise counsel that every executive can use to manage his or her organization’s data more productively.
Enjoy! susan[Read More]
svisser1 2700018UK9 5,094 Views
One of the books that we featured at IOD was The Execution Premium by authors Robert Kaplan and David Norton.
The publisher sent me information about a webinar related to this book that you might be interested in:
The Execution Premium: Making Strategy Your Competitive Advantage NowA conversation with David Norton, author of The Balanced Scorecard and The Execution PremiumWednesday, December 10, noon – 1:30 U.S./Canadian EST
To learn more, click here.[Read More]
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]
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!