DB2 Magazine E-Newsletter
November 4, 2003
DB2 Magazine Email Newsletter
Volume 4, Issue 13
www.db2mag.com
*****************************
This message has been sent to you as a valued subscriber of DB2
Magazine by the editors. List removal and subscription information
appears at the bottom of this message.
*****************************
IN THIS ISSUE:
1. Asked and Answered: How to detect stored procedure reloading activity
2. The On Demand Infrastructure: Your feedback could be worth $250
3. DB2 Magazine Trivia Contest: Play for a chance to win $100
4. DB2 Magazine Quarter 4, 2003: Data archiving, inside SQL processing, and more
5. Sarbanes-Oxley e-book
1. ASKED AND ANSWERED
How do I determine whether or not stored procedures marked as "STAY
RESIDENT YES" are actually reloading? All of our modules so marked
were created as "PROGRAM TYPE MAIN," which is the default.
Find out how (and get some bonus performance advice) from DB2 DBA
columnist Robert Catterall.
http://www.db2mag.com/qanda/031103.shtml
2. THE ON DEMAND INFRASTRUCTURE
The U.S. Tennis Association, National Geographic, The Sesame Workshop
and other companies are making the most of their information assets by
relying on a flexible, extensible information infrastructure. DB2
Magazine authors Paul Zikopoulos and Craig Mullins show how these and
other companies are using infrastructure to gain advantage-and how you
can, too. Once you've read this special section, fill out the feedback
form to let us know what you thought-and for a chance to win a $250
American Express Gift Cheque.
http://www.db2mag.com/ondemand/
3. DB2 MAGAZINE TRIVIA CONTEST: PLAY TO WIN $100
What new product, based on DB2, was introduced in 2000 to handle
multimedia asset management? Answer correctly and enter the drawing
for a $100 American Express Gift Cheque. This month's contest is
sponsored by Computer Associates,
http://www.ca.com/db/
Play the Trivia Contest
http://www-306.ibm.com/software/data/education/cert/
Get a hint from the DB2 anniversary poster
http://www.db2magazine.com/db_area/archives/2003/q1/AnvPostrTimelineSide.pdf
4. DB2 MAGAZINE QUARTER 4, 2003
Don't miss these articles from the latest edition of DB2 Magazine.
Take a Load Off: Archive Inactive Data
A data explosion threatens to bog down, fill up, and generally
complicate DBMSs. Archiving lets companies hold on to the data they
need and keep DB2 performing at top speed.
http://www.db2mag.com/story/showArticle.jhtml?articleID=15300109
SQL Under the Covers
Ever wonder what happens in response to a query? Peek inside DB2 to
find out.
http://www.db2mag.com/story/showArticle.jhtml?articleID=15300108
Combining Triggers and UDFs
Now DB2 can handle tasks once left to application developers.
http://www.db2mag.com/story/showArticle.jhtml?articleID=15300024
Say What?
Plans + DBRMS + Packages + Collections + Versions = Confusion.
Programmers Only columnist Bonnie Baker makes sense of it all.
5. From Intelligent Enterprise and Transform Magazine E-BOOK: "COMPLYING WITH SARBANES-OXLEY"
With their integrity on the line, CEOs, CFOs and other corporate
officers mean business when they demand "confidence in the numbers".\
Where can top executives and IT managers turn for answers?
This e-book produced jointly by Intelligent Enterprise and Transform
Magazine covers the basics of management technology, including
enterprise content management, records management and the basics of
devising a compliance strategy, policies and enforcement programs.
Also addressed are the more important organizational and behavioral
challenges organizations must meet in order to bring the right content
into effective life cycle management."
Register to read it at
http://www.iemagazine.com/register/ebook/sarbanesoxley/
SUBSCRIBE TO DB2 MAGAZINE
If you like what you read in this newsletter, you'll love DB2
Magazine.
It's free. It's filled with expert advice.
Don't miss a single issue issue. Sign up today!
http://www.db2mag.com/subscribe/
Get your own copy of this DB2 Email delivered directly to your inbox
each month.
http://www.db2mag.com/newsletter/
|
