DB2 Magazine E-Newsletter
September 27, 2002
DB2 MAGAZINE EMAIL NEWSLETTER
VOLUME 3, ISSUE 9
http://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
* When is intra-parallelism appropriate in a DSS environment?
* How do I query databases located on two different servers?
* Have you really moved small domain tables to CICS?
* When are locks released after package and plan execution?
2. What Do You Think?
Air your views on the best of DB2
3. IBM News: Nominations Open for IBM and Lotus Beacon Awards
4. Now Playing at the DB2 Developer Domain
5. At the Bookstore: SQL:1999 and a reader recommendation
6. NetSeminar: Enterprise Storage: The Strategic IT View
*************SPONSORED BY COMPUTER ASSOCIATES**************
Computer Associates International, Inc. (CA) cordially invites you to
a free half-day seminar on managing the challenges in your DB2
environment. Learn firsthand from
industry-recognized DB2 authority
Gabrielle Wiorkowski, who will provide practical insight into
exploiting the opportunities offered by V7. Register Today
http://ca.com/db2forum/
****************************************************
1. ASKED AND ANSWERED
* In your article on OLTP and data warehouse performance tuning --
"
Tuning Up for OLTP and Data Warehousing
,"
--
you write: "In a DW database, you nearly always want to use an
INTRA_PARALLEL value of YES". Is that correct? IBM is telling us to
turn it off, although in my last DB2 Enterprise-Extended Edition (EEE)
shop, we saw significant query improvements when we turned
intra-parallel on. When is intra-parallelism appropriate in a DSS
environment and when isn't it? Find out what Scott Hayes recommends
and why at
http://www.db2mag.com/qanda/020926a.shtml
**************SPONSORED BY BMC SOFTWARE**************************
Space Expert for DB2 Campaign:
Get your FREE trial!
Effectively improve database performance... and go home a hero.
With the intelligent space management capabilities of Space Expert
for DB2 UDB from BMC Software, identifying and reorganizing your
most active objects is done easily and automatically.
http://www.bmc.com/offers/space_expert/db2udb_trial/
**********************************************************************
* How do I query databases located on two different servers (for
example, DB01 on SRVR1 and DB02 on SRVR2)? Read DB2 DBA guru Robert
Catterall's advice at
http://www.db2mag.com/qanda/020926b.shtml
* We want to move a few small domain tables that are heavily
referenced by online programs to CICS. You wrote about making use of
CICS tables for such purposes --
"
When Less is More
" -- but no
one I talk to seems to know about using CICS tables for application
data. Were you using it as a synonym for TSQ/TDQ? Robert Catterall's
response is online at
http://www.db2mag.com/qanda/020926c.shtml
* In "
Tuning Data Sharing Performance
"
you recommended using RELEASE(DEALLOCATE) on the bind parameters to
reduce global lock contention. You wrote,
"RELEASE(DEALLOCATE) causes
tablespace locks, once acquired, to be retained until thread
deallocation". We rebound with RELEASE(DEALLOCATE) on some of our
CICS/DB2 plans and packages executing in a three-way CICS/DB2 data
sharing environment, and the elapsed times increased by more than 30
seconds. The traces noted that the next execution of the transaction
would begin once the thread terminated. We rebound them back to
RELEASE(COMMIT) and the transaction elapsed times returned to normal.
However, on some of our other
transactions for this same application
(bound with RELEASE(COMMIT)), we're seeing global lock contention.
Basically, I'm not sure when and what locks (both logical and
physical) are released at the end of a package execution and at the
end of the entire plan when using RELEASE(DEALLOCATE) vs.
RELEASE(COMMIT). I'm re-reading your articles on data sharing and
CICS/DB2, but I am still perplexed. Find out if Robert Catterall can
clear up the confusion at
http://www.db2mag.com/qanda/020926d.shtml
.
****************SPONSORED BY JD EDWARDS***************************
A recent independent study found that DB2 delivers the lowest
database. Total Cost of Ownership for J.D.Edwards.
Get a free copy of this May 2002 study at
http://www.ibm-jdedwards.com/
**********************************************************************
2. WHAT DO YOU THINK? AIR YOUR VIEWS ON THE BEST OF DB2
IBM's DB2 database software marched onto the data management field in
1983. Twenty years and many upgrades later, it's playing in a very
different game. What do you think are the most important innovations,
strategies, or technology breakthroughs in DB2 history? Make your
views known in the DB2 Magazine online poll at
http://www.db2mag.com
or email the editor
(
kmoutsos@cmp.com
). Your
opinion may be featured in a future issue of DB2 Magazine.
3. IBM NEWS
IBM and Lotus Beacon Awards
Submit your nomination for the "Best Data Management Solution"
category of the IBM and Lotus Beacon Awards, which recognize IBM
Software Business Partners who have delivered outstanding products,
services, and solutions based on IBM technologies. Beacon Award
winners receive a customizable press kit for promoting their award to
specific geographic regions, target markets, and industry contacts.
The IBM PR team promotes the winning solutions in
leading industry
publications such as VARBusiness, CRN, and InformationWeek.
PartnerWorld for Developers members and PartnerWorld for Software
members are eligible to compete in both the IBM Beacon Awards and the
Lotus Beacon Awards. The deadline for nominations is October 31. For
information, go to
http://www-100.ibm.com/beacons/lotusbeacon03.nsf
4. NOW PLAYING AT THE DB2 DEVELOPER DOMAIN
Sneak peek of a new
book on DB2 SQL Procedure Language for V8,
http://www7b.software.ibm.com/dmdd/library/techarticle/0209yip/splbook.html
Updateable UNION ALL Views in DB2 V8,
http://www7b.software.ibm.com/dmdd/library/techarticle/0209rielau/0209rielau.html
Setting up an MBCS Database on
an English OS in DB2 UDB V8,
http://www7b.software.ibm.com/dmdd/library/techarticle/0209kline/0209kline.html
Building Entity EJBs That Span Federated Data,
http://www7b.software.ibm.com/dmdd/library/techarticle/0209saracco/0209saracco1.html
Working with XML
Schema and Data Types in DB2,
http://www7b.software.ibm.com/dmdd/library/techarticle/0209lima/0209lima.html
Yet Another Implementation of Optimistic Locking in DB2,
http://www7b.software.ibm.com/dmdd/library/techarticle/0209kuznetsov/0209kuznetsov.html
DB2
Everyplace Synchronization Using Horizontal Filtering,
http://www7b.software.ibm.com/dmdd/library/techarticle/0209casey/0209casey.html
Download: Web Services Object Runtime Framework for DB2,
http://www7b.software.ibm.com/dmdd/zones/webservices/worf/
5. AT THE BOOKSTORE
Advanced SQL: 1999 -- Understanding Object-Relational and Other
Advanced Features
, by Jim Melton
An authoritative guide to the standard's practical application,
Advanced SQL: 1999 -- Understanding Object-Relational and Other
Advanced Features
shows readers how to make applications
standard-compliant. Useful to those upgrading from earlier versions of
SQL and those with no previous experience, the book focuses on topics
important to programmers connecting applications to databases. It
details SQL: 1999's object facilities, including structured
user-defined types (UDTs), typed tables, user-defined routines, and
routine invocation, and examines facilities new to SQL, including
those relating to OLAP, management of external data, and Java support.
Appendices cover a SQL: 1999 example using UDTs and status codes. Find
out more at
http://www.db2mag.com/bookstore/
Reader Recommendation
Database Management Systems
, by Raghu Ramakrishnan and
Johannes Gehrke
Recommended by: Edwin Knorr, University of British Columbia
This is an excellent database management systems textbook, covering
E-R diagrams, normalization, indexing, concurrency, locking, crash
recovery, query optimization, performance, Internet databases, data
warehousing, etc. DB2 (and other DBMSs) are mentioned throughout the
text, and the ARIES recovery algorithm (used for logging and recovery
in DB2) is presented in detail. The book is well written, with a nice
balance between
theory and practice. The third edition has just been
released (copyright 2003).
Check it out or recommend your own favorite data management read at
http://www.db2mag.com/bookstore/readers.shtml
6. ENTERPRISE STORAGE: THE STRATEGIC IT VIEW
Sponsored by Dell. Hosted by Intelligent Enterprise.
WEDNESDAY, October 30, 2002
11:00 AM PST; 2:00 PM EST
Intelligent Enterprise will host a NetSeminar on Enterprise Storage:
The Strategic
IT View. Moderator Justin Kestelyn, Editor-in-Chief of
Intelligent Enterprise, has secured two great speakers for the event:
Michael Peterson, President and Senior Analyst, Strategic Research
Corporation, and Arun Taneja, Senior Analyst, Enterprise Storage
Group. Don't miss this opportunity to interact with Enterprise Storage
thought leaders on this crucial, and often costly, component of
information. Register today at:
http://www.netseminar.com/nss/showSeminar?sem_num=742
|
