|
DB2 MAGAZINE EMAIL NEWSLETTER
VOLUME 3, ISSUE 9
http://www.db2mag.com
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
******************************************************************
1. ASKED AND ANSWERED
* In your article on OLTP and data warehouse performance tuning --
"Tuning Up for OLTP and Data Warehousing,"
http://www.db2mag.com/db_area/archives/2002/q3/hayes.shtml
-- 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://news.db2mag.com/cgi-bin4/flo?y=eI310EXHHW0CsY0Bi5O0AM
**********************************************************************
* 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://news.db2mag.com/cgi-bin4/flo?y=eI310EXHHW0CsY0Bi5P0AN
* 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,"
http://news.db2mag.com/cgi-bin4/flo?y=eI310EXHHW0CsY0Bi5Q0AO -- 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://news.db2mag.com/cgi-bin4/flo?y=eI310EXHHW0CsY0Bi5R0AP
* In "Tuning Data Sharing Performance" --
http://news.db2mag.com/cgi-bin4/flo?y=eI310EXHHW0CsY0Bi5S0AQ --
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://news.db2mag.com/cgi-bin4/flo?y=eI310EXHHW0CsY0Bi5T0AR
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@...). 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://news.db2mag.com/cgi-bin4/flo?y=eI310EXHHW0CsY0Bi5h0Al
4. NOW PLAYING AT THE DB2 DEVELOPER DOMAIN
Sneak peek of a new book on DB2 SQL Procedure Language for V8,
http://news.db2mag.com/cgi-bin4/flo?y=eI310EXHHW0CsY0Bi450At
Updateable UNION ALL Views in DB2 V8,
http://news.db2mag.com/cgi-bin4/flo?y=eI310EXHHW0CsY0Bi460Au
Setting up an MBCS Database on an English OS in DB2 UDB V8,
http://news.db2mag.com/cgi-bin4/flo?y=eI310EXHHW0CsY0Bi470Av
Building Entity EJBs That Span Federated Data,
http://news.db2mag.com/cgi-bin4/flo?y=eI310EXHHW0CsY0Bi480Aw
Working with XML Schema and Data Types in DB2,
http://news.db2mag.com/cgi-bin4/flo?y=eI310EXHHW0CsY0Bi5A0A7
Yet Another Implementation of Optimistic Locking in DB2,
http://news.db2mag.com/cgi-bin4/flo?y=eI310EXHHW0CsY0Bi5B0A8
DB2 Everyplace Synchronization Using Horizontal Filtering,
http://news.db2mag.com/cgi-bin4/flo?y=eI310EXHHW0CsY0Bi5C0AA
Download: Web Services Object Runtime Framework for DB2,
http://news.db2mag.com/cgi-bin4/flo?y=eI310EXHHW0CsY0Bi5D0AB
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://news.db2mag.com/cgi-bin4/flo?y=eI310EXHHW0CsY0Bi5U0AS
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://news.db2mag.com/cgi-bin4/flo?y=eI310EXHHW0CsY0Bi5i0Am
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://news.db2mag.com/cgi-bin4/flo?y=eI310EXHHW0CsY0BitJ0AK
|
"Jay Allen" <ja@...>
ibm4swarug
 Offline
 Send Email
|
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
