DB2 Magazine November newsletter: Understanding, monitoring and troubleshooting DB2 memory
DB2 Magazine
November 2007
The Engine for Information On Demand
Table of Contents DB2 Magazine
From the editor: Advice on monitoring and tuning memory from a dedicated reader and a performance expert.


Poll positions: Name your favorite technology that just won't die (despite reports to the contrary).

IBM news: DB2 9.5 (codenamed "Viper 2") makes a fast start.

Skills set: News and information about IBM education.

In the Zone: A list of DB2 Magazine's application development content, plus recent developerWorks articles.

Sponsored by Quest Software
The Evolution of DB2 Application Development

In this Quest white paper, expert Jim Wankowski explores the progression of DB2 application development over the last three decades. Jim discusses DB2 programming trends and solutions for maximum application performance in today's development environment.

Read this valuable white paper today.

FROM THE EDITOR

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

Memory Matters

Memory is the mother of all wisdom, wrote the Greek playwright Aeschylus. He certainly wasn't writing about database administration when he penned those words more than 2,000 years ago, yet the quote still rings true. A DBA who understands DB2 memory usage can apply that knowledge to successful tuning and troubleshooting efforts. Two contributors share their memory wisdom this month.

Blogger Scott Hayes explains STMM.
 Scott Hayes
Reader Radhesh Kumar contributes this piece on Monitoring and Tuning Memory in DB2 9 for Linux, Unix, and Windows Kumar explains DB2 memory usage in general and introduces DB2 9's self tuning memory manager (STMM), which dynamically tunes DB2 parameters for a specific workload, and other DB2 9 memory features.

The latest blog post by DB2 for LUW performance guru Scott Hayes explores when to use STMM and how to make the most of it in both data warehouse and OLTP scenarios.

--Browse Scott's entries on DB2 for LUW performance
--Browse all blog categories

DB2 Magazine MUST READ
DB2 9 for Linux, UNIX, and Windows Database Administration Upgrade Certification Upgrade Exam Study Guide
by Roger E. Sanders
This new study guide covers everything you'll need to know to pass the short—but challenging—DB2 9 for LUW DBA Certification Upgrade exam (Exam 736). Roger Sanders, who is part of the team that develops DB2 certification exams, covers all the topics included in the exam, including server management, data placement, XML concepts, activity analysis, high availability, database security, and more. Each chapter includes a set of practice questions (and detailed answers) that closely resemble the kinds of questions on the real exam.
--Read more about the book
--Browse Sanders' Distributed DBA column on DB2 performance and administration.
DB2 Magazine INFORMIX UPDATES
The Informix View
International Informix User Group board member Jean Georges Perrin brought an Informix-eye view to the Information On Demand 2007 conference in Las Vegas last month. Read about his experiences in the DB2 Magazine Informix blogs.
--Find out about the upcoming all Informix conference.
--Get tips on working with the IDS 11 Sysmaster database.
DB2 Magazine DB2 MAGAZINE E-BOOK
Label-Based Access Control in DB2 9
Despite companies' best efforts to keep intruders out of networks and sensitive systems, more than 70 percent of data breaches are carried out by employees. Label-based access control makes it possible to grant and restrict read and write access to individual rows and columns based on an employee's job function, department, or other designated criteria. DB2 guru Roger E. Sanders shows how to implement this important security feature.
Download the e-book.

Browse all DB2 Magazine e-books.

Browse CMP e-books on Web 2.0, business intelligence, server consolidation, and more.
Sponsored by NEON Enterprise Software, Inc.
An IBM IOD Conference Diamond Sponsor

Skyrocketing data volumes and regulations make complying with retention requirements difficult. Join Craig Mullins and Bill Baker to learn how TITAN Archive satisfies data retention needs.

Sign up now at www.neonesoft.com

DB2 Magazine POLL POSITIONS
The Great Undead Technologies
What's your favorite "undead" technology/tech category (an undead technology is one that's been pronounced dead — sometimes repeatedly — yet continues to live long and prosper). Choose from the list at db2mag.com
--Read DB2 Magazine editor Kim Moutsos' list of favorites.
--Browse past poll results.
DB2 Magazine IBM NEWS
IBM to Acquire Cognos
IBM has entered into a definitive agreement to acquire Cognos, an Ottowa, Canada-based company that sells business intelligence tools for query and reporting, analytics, scorecards, and dashboards. The $5 billion-deal is expected to close in the first quarter of 2008, subject to Cognos shareholder approval. The Cognos purchase is the 23rd IBM acquisition in support of its Information on Demand strategy. IBM says the acquisition will enable new business insights to be delivered to a broader set of users than business intelligence traditionally reaches.
DB2 9.5 Takes Off
IBM released DB2 9.5 (codenamed "Viper 2") on October 31. The new DB2 release features new pureXML data management capabilities that boost XML data transaction performance and result in significant storage savings. DB2 Viper 2 also provides "extreme autonomics" that tune the data server for optimal performance without human intervention. These enhancements include: automatic deep compression to save storage capacity and costs, autonomic memory management, and integrated automated failover and backup to simplify system set-up and minimize downtime.
--Read "DB2 Viper 2 Accelerates IT Agility."
DB2 Magazine SKILLS SET
Complimentary headset with Information Management ILO courses
Take an IBM Information Management course in the new Instructor-Led Online (ILO) format and receive a complimentary USB headset in the mail. Learn online at your convenience. View the online demo to see how this interactive training format works.
T-shirt offer with certification vouchers
If you participated in the train-and-save promotion by attending a qualifying class between June 5 and Oct. 31, 2007, there's still time to redeem your certification discount voucher. Use it by December 31, 2007 to save 50% off the cost of an eligible Information Management certification exam. Once certified, you will receive an official Information Management Certified Professional shirt!
IBM Press discounts
You can save 35% at the IBM Press Bookstore on or between October 15 and December 31, 2007, plus receive ground shipping in the United States at no charge. To take advantage of this special offer, visit the IBM Press Bookstore, select your books and enter case-sensitive coupon code SAVEDB2 at Step 3 during checkout.
IBM Training catalog
Read about the latest Information Management courses and conferences in the IBM Training Fall catalog. Download it from the Web or order a hard copy.
IBM Education Pack online account
The IBM Education Pack is an online account offering a flexible prepaid discount option. You can save up to $10,000 with this limited-time offer, valid from October 9 through February 15, 2008.
DB2 Magazine IN THE ZONE
Browse a list of recent developerWorks articles, plus DB2 Magazine's application development content.
Recent DB2 Magazine articles
pureQuery—The Easy Way to Quick Data Access: 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.

Optimistic Locking, Parts 1 and 2
Recent developerWorks articles
Get started with IBM Data Studio V1.1.0 and Eclipse, Part 1

Column-level encryption in IDS

Validate data types in U2 using XML Schema

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 ::