December 2, 2008
Volume 9, Issue 24
IN THIS ISSUE:
1. Online only
* 5 more surprising things to do with DB2 Query Monitor
* Asked and answered: Using recursive SQL to set a delay in DB2 for z/OS
2. From the blogs
* DB2 9 certification challenge: memory allocation and compression dictionaries
3. Community connections
* IBM Database Magazine launches new Facebook group
* Planet IDS joins the data management community
4. Tech term of the day
* Are you a fan of "dancing baloney?"
*************************************
1. Online only
* 5 more surprising things to do with DB2 Query Monitor
Most people use query monitors to display performance information about specific queries. But reader Tom Glaser points out that DB2 Query Monitor can do much more than that. This second half of his top 10 list covers dynamic SQL overhead, -904 errors, access path changes, logging increases, and subsystem statistics.
—Read the first article for five other surprising DB2 Query Monitor capabilities.
* Asked and answered: Using recursive SQL to set a delay in DB2 for z/OS
Can an SQL statement be written to delay for a set period of time using recursion? Reader Kris Edwards says it can, and he has the solution.
2. From the blogs
* DB2 9 certification challenge: memory allocation and compression dictionaries
Find out what you should know about exploring memory allocation and creating compression dictionaries before you tackle the DB2 9 DBA certification exam.
3. Community connections
* IBM Database Magazine launches new Facebook group
If you're not already using Facebook, you might be surprised how many database professionals are. If you are one of those who are already using it, join the new IBM Database Magazine group. Your participation will help shape future coverage, plus you'll get to socialize with other readers, writers, editors, bloggers, and experts. If you're not on Facebook yet, maybe this is the time to try it.
* Planet IDS joins the data management community
Informix gets its own blog aggregator, thanks to the boundless energies of Eric Herber, who already runs The Informix Zone and who earlier this year was honored as an IBM Data Champion for his efforts. Planet IDS is a one-stop shop for Informix-related blogs and links to other Informix information.
4. Tech term of the day
* Are you a fan of "dancing baloney?"
It either drives you crazy or drives you in. Find out what Web site feature has earned this evocative moniker.
Copyright (c) 2008 United Business Media LLC
600 Community Dr,
Manhasset NY 11030
|
