DB2 Magazine August Newsletter: How much do you know about DB2 9?
DB2 Magazine
August 2007
The Engine for Information On Demand
Table of Contents DB2 Magazine
From the blogs: Find out how much you know about DB2 9 referential constraints and isolation levels.


Skills set: Resources for information management education.

In the Zone: The latest developerWorks articles on DB2, Informix, U2, and more.

Digital DB2 Magazine: All the content from the print edition in a downloadable PDF format.

FROM THE BLOGS

If you can't see the images, please read the DB2 Magazine newsletter online.

Site: BlogIBM's Information On Demand conference is right around the corner. Whether or not you're planning to take advantage of the free certification testing offered there, try your hand at these sample questions for Exam 730, from the book DB2 9 Fundamentals Certification Study Guide by Roger E. Sanders, reprinted with the permission of publisher MC Press.

Question: Which type of key is defined on the child table to implement a referential constraint? Is it a unique, primary, foreign, or composite key?


Question: A table contains a list of all seats available at a football stadium. A seat consists of a section number, a seat number, and whether or not the seat has been assigned. A ticket agent working at the box office generates a list of all unassigned seats. When the agent refreshes the list, it should only change if another agent assigns one or more unassigned seats. Which is the best isolation level to use for this application: Repeatable Read, Read Stability, Cursor Stability, or Uncommitted Read?

> Get the answers (and the explanations).
> Read up on isolation levels.

Also in the blogs: A new InformationWeek IT salary survey shows that information management professionals are among the highest paid IT workers, but gender, age, and location make a big difference.

Digital DB2 Magazine: All the content from the print edition in a downloadable PDF format.

Sponsored by DataMirror DataMirror
DataMirror
's integration solutions capture critical data and business events without impacting system performance, and distribute them between DB2 and other heterogeneous environments in real time. Learn more at http://www.datamirror.com/products/tserver/default.aspx
DB2 Magazine INFORMIX UPDATE
IIUG.TV: The Truth is Out There
IIUG.tv debuts with a light-hearted ride in the Truth Mobile, as one intrepid reporter battles glory grabbers, lava lamp fanciers, and other obstacles en route to discovering whether Informix really is everywhere.
> Watch the video.
> Read about Informix's role in Cisco's Unified Communications Manager.
IIUG Heads to the Informix Homeland
The International Informix Users Group will hold its 2008 Users Conference at the Overland Park Marriott in Overland Park, Kansas, April 27-30, 2008. The three-day event features four tracks of Informix sessions and a day of tutorials prior to the conference opening.
> Answer the call for presentations.
> Submit your presentation proposal.
> Read more about the conference.
"Ready for Informix Dynamic Server" Program and Mark
IBM introduced the "Ready for Informix Dynamic Server" program and mark for independent software vendors (ISVs) and global and regional solution integrators. Becoming validated with IBM demonstrates that IDS solutions meet IBMs integration standards.
> Explore program details at the Informix Solution Portal or email the team at validate@ca.ibm.com.
IDS Partner Pavilion at Information On Demand 2007
The IDS Partner Pavilion at Information On Demand 2007 in Las Vegas this October is an opportunity for business partners to exhibit Informix integrated solutions in a high visibility, heavily trafficked area close to the specialty IBM IDS booths.
> For more information, contact Irina Delidjakova at idelidja@ca.ibm.com or 905-413-3312.
DB2 Magazine AT THE BOOKSTORE
Mining the Talk: Unlocking the Business Value in Unstructured Information (IBM Press)
by Scott Spangler and Jeffrey Kreulen
Two IBM researchers introduce a new approach to unlocking the business value in everything from word processing documents to Web sites, email, and instant messages. Writing for business professionalsnot just data mining specialiststhe authors explain techniques for exploring, understanding, and analyzing unstructured data.
> Find out more about the book.
Recently Featured Books
Sponsored By JustSystems JustSystems
JustSystems:
create, integrate, visualize and deliver data and documents to empower knowledge workers, stay ahead of the competition, and see your business come to life. Learn more at http://na.justsystems.com/index.php
DB2 Magazine SKILLS SET
International DB2 User Group (IDUG) Updates
IDUG announced the DB2 Deep Compression Challenge sponsored by IBM. DB2 9 users can report actual or estimated compression ratios they achieved using DB2s Deep Compression and Inspect tool, while users of a competitive DBMS can access a Database Storage Analyzer tool that will report estimated savings available through the Deep Compression feature.
> Take the challenge.
IDUG 2007  Europe, 5-9 November, Athens, Greece
Register by 21 September and capitalize on early bird savings. Use the online registration form or download a print-friendly version.
> Get complete details.
> The IDUG 2008 - North America Call for Presentations closes Friday, September 4, 2007. Submit your presentation.
IBM Business Intelligence Virtual Symposium
IBM presents "From Insight to Foresight," Tuesday, Sept 18 9:00 a.m. EDT and for 90 days afterwards.
> Log in from your desk.
New Content Manager OnDemand for i5/OS Professional Certification
This new exam and certification earns successful testers the IBM Certified Solutions Expert for Content Manager OnDemand i5/OS credential.
> Get prepared.
Information Management Certification Discounts
Attendees of qualifying IBM Information Management classroom training course occurring between June 5, 2007 and October 31, 2007 will receive a voucher for 50 percent off the cost of an eligible Information Management certification exam.
> Offer details.
Pre-Order: DB2 9 for z/OS Database Administration Certification Study Guide
MC Press is offering this new book by Susan Lawson and Dan Luksetich, due in November, for $20 off the cover price. The study guide covers all topics on Exam 732 plus DB2 9 for z/OS performance tips.
> Find out more.
Pre-conference technical education at IBM Information On Demand 2007
IBM's full-day pre-conference education classes are offered on Sunday October 14th, 2007 from 8:30 am to 4:30 pm. Classes offered include product deep dives and certification preparation workshops.
>Get details.
New Instructor-Led Online Courses
IBM has added new DB2 courses to its instructor-led online (ILO) offerings.
> Get the full list of ILO classes.
Sponsored By Intel Intel
Intel
's Dual-core Intel® Xeon® processors provide unmatched energy-efficient processing power for the new IBM Information Server Blade. Learn more at http://www.ibm.com/software/data/integration/info_server/blade/
DB2 Magazine IN THE ZONE
DB2 self-tuning memory manager log parser
Deploy, debug, and correct your SQL stored procedures for Visual Studio 2005
System Administration Certification exam 918 for IDS 11 prep, Part 8
Bring native XML data into your relational database using DB2 Express-C
IDS 11 System Administration Certification exam 918 prep series

This newsletter is sent to you as a valued subscriber of DB2 Magazine. If you no longer wish to receive the newsletter, forward this message to: unsub_db2@news.db2mag.com. To subscribe, forward this message to sub_db2@news.db2mag.com.

http://www.cmp.com/delivery/privacy.html

Copyright (c) 2007 CMP Media LLC
600 Community Dr,
Manhasset NY 11030
CAREER CENTER
Ready to take that job and shove it?
SEARCH JOBS
RECENT JOB POSTINGS
CAREER NEWS
10 Search Engines You Don't Know About
Go beyond Google and get vertical. These specialized search sites will help you find the business information you need -- fast.

Subscribe to the new digital version of IBM Database Magazine
New Digital Version

Sponsored links:



Subscribe to the IBM Database Magazine Newsletter

Email Address *
First Name
Last Name
HTML Preference
HTML Text
 

Fields with * are required.

 




Visit these other IBM and TechWeb Partner Sites: :
Maximizing ROI Through Business Process Management (BPM) and Service-Oriented Architecture (SOA)
Internet Evolution – The Macrosite for News, Analysis, & Opinion About the Future of the Internet
Business Innovation – Technology Strategies and Solutions for Driving Business Success


:: IBM Database Magazine ::