DB2 Magazine E-Newsletter

August 20, 2003

DB2 Magazine Email Newsletter
Volume 4, Issue 9
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
* Converting to a partitioned tablespace with no downtime
* Increasing virtual buffer pools and adding hiperpools
* Setting MAX DEGREE for query parallelism
2. IBM News
3. DB2 Magazine Trivia Contest: Win Four DB2 Books
4. Skills and Certification
5. At the Bookstore: DB2 Universal Database v8 Application
Development Certification Guide
6. Now Playing at the DB2 Developer Domain

1. ASKED AND ANSWERED
We have a segmented tablespace growing over the 2GB dataset limit that's now in the second 2GB dataset. But we don't have the proper operations window to convert the tablespace into a partitioned tablespace. What is the maximum limit (in GBs) for a segmented tablespace? What is the maximum limit (in GBs) for a partition in a partitioned tablespace?

Because our database wasn't set up correctly from the start, I'm concerned that some of those tables will abend in the middle of some production runs.

For nonpartitioned tablespaces, we don't use DSSIZE -- that means our max partition size can only be 4GB. We need to change the tablespace to DSSIZE to extend to 64GB. However, we don't have downtime in which to change the tablespace definition and unload/reload these large tables. Any suggestions?

Robert Catterall's suggestions
http://www.db2mag.com/qanda/030819a.shtml

I've been wrestling with a performance problem for several weeks (high class 3 wait times in an accounting report). The problem originally surfaced during a stress test with a WebSphere/Java/DB2 Connect/DB2 for z/OS application, but the same high wait times have now been observed running one of the problem queries with a stress test using batch SPUFI (to eliminate the Websphere/Java/DB2 Connect components). Should I increase the size of our virtual buffer pools and add hiperpools?

Read our DBA guru's advice
http://www.db2mag.com/qanda/030819b.shtml

With DB2 Query Parallelism, I've heard that you shouldn't set MAX DEGREE greater than the number of CPs. I don't agree, but I wonder whether setting MAX DEGREE high will have an adverse effect on other users. Any advice?

Find out what Robert Catterall thinks
http://www.db2mag.com/qanda/030819c.shtml

2. IBM NEWS
IBM Web Seminar: Records Management In A Compliance-Driven Setting
October 16, 2003; 11:00 AM PDT; 2:00 PM EDT
Legislation such as the Sarbanes-Oxley Act and regulators such as the SEC and NASD demand that structured records management be applied to electronic business records. Recordkeeping is now a critical component of any enterprise business software deployment. Sound corporate recordkeeping practices, supported by electronic recordkeeping software, give you the means to implement compliant corporate recordkeeping policies and procedures and help reduce the electronic evidence discovery costs of litigation. This Web Seminar provides an in-depth, advanced tutorial on compliance regulations and how you can successfully tackle e-records deployment within a compliance-driven setting.
http://webevents.broadcast.com/cmp/wcs/index.asp?event_id=7579

DB2 Wins Best Cluster Solution at LinuxWorld
The new DB2 Integrated Cluster Environment (DB2 ICE) was awarded the Best Cluster Solution at the LinuxWorld Conference & Expo in August. DB2 ICE is a new Linux database cluster that helps businesses implement a low-cost, high-performance data center based on DB2 UDB for Linux and IBM eServers.
http://www-3.ibm.com/software/data/db2/linux/ice/

DB2 UDB Bests Oracle on Linux in TPC-H Test
DB2 UDB with a 100GB database was benchmarked using the TPC-H standards on an eServer and recently outperformed Oracle on an HP AlphaServer. See the TPC Web site for details.
http://www.tpc.org/

3. DB2 MAGAZINE TRIVIA CONTEST: YOUR CHANCE TO WIN FREE DB2 BOOKS
Play the DB2 Magazine Trivia Contest on DB2mag.com this month for a chance to win four free DB2 books from Prentice Hall: DB2 Universal Database v8 for Linux, Unix, and Windows Database Administration Certification Guide (5th edition); DB2 UDB v8 Handbook for Windows, Unix, and Linux; DB2 SQL Procedural Language for Linux, Unix, and Windows; and the just-published DB2 Universal Database v8 Application Development Certification Guide (2nd Edition). This month's contest is sponsored by BMC Software
http://www.bmc.com/

Enter the contest:
http://www.db2magazine.com/
Find out more about the four Prentice Hall titles:
http://www.db2mag.com/trivia.shtml

4. SKILLS AND CERTIFICATION NEWS
Just Released: DB2 UDB v8.1 Handbook for Linux, Unix, and Windows
The latest DB2 Information Management Book to be released this month, this book offers complete, start-to-finish coverage of DB2 UDB V8 administration and development, including database design. In addition, learn how to use appropriate DB2 programming techniques; deploy networked and Internet-centered database applications; and migrate to DB2 UDB from other databases or earlier versions of DB2.
http://www-3.ibm.com/software/data/education/bookstore/ref.html

Free DB2 Certification and Study Materials
IBM certification validates your skills and may give you an advantage in this tough job market. The journey to becoming an IBM Certified Database Associate starts with Exam 700: DB2 Universal Database V8.1 Family Fundamentals.

Visit this IBM site for free resources to help you prepare.
http://www-3.ibm.com/software/data/education/certprep.html
Visit this site for details on the complementary DB2 UDB certification testing offered at the Data Management Technical Conference Oct. 27-31 in Las Vegas.
http://www-3.ibm.com/services/learning/conf/us/dm/certification.html

Free DB2 UDB Certification Vouchers Expire This Month
If you took advantage of the latest DB2 UDB certification voucher offer, make sure you schedule your free exam at a local Prometric testing center this month. The non-transferable vouchers expire August 31, 2003. Eligible exams include 442: DB2 Content Manager V8; 516: DB2 V7.1 for OS/390 Database Administration; 701: DB2 UDB V8.1 for Linux, Unix, and Windows Database Administration; 703: DB2 UDB V8.1 Family Application Development; 704: DB2 UDB v.8.1 for Linux, Unix, and Windows Advanced Database Administration; and 705: Business Intelligence Solutions V8.1.

Visit this site for more information
http://www-3.ibm.com/software/data/db2/skills/voucher.html

5. AT THE BOOKSTORE
DB2 Universal Database v8 Application Development Certification Guide (Second Edition)
by David Martineau, Steve Sanyal, Kevin Gashyna, and Michael Kyprianou
The official IBM guide to becoming an IBM Certified Application Developer for the DB2 UDB v8 family, this new edition covers all the skills and techniques needed to build enterprise, Web, and e-business applications. The book, written by experts who helped develop the application development certification exam, now includes information to help readers prepare for the DB2 Family Fundamentals exam, a prerequisite to the application development exam. The thoroughly revised and updated application development section reflects new powerful features of DB2. The book explains the DB2 client/server environment, the role of SQL, and the basic structure of a DB2 application. It also compares the programming interfaces available for DB2 application development.

Find out more in the DB2 Magazine bookstore. http://www.db2mag.com/bookstore/

6. NOW PLAYING AT THE DB2 DEVELOPER DOMAIN
Meet the Experts: Don Chamberlin
http://www7b.boulder.ibm.com/dmdd/library/techarticle/0308chamberlin/0308chamberlin.html

Developing DB2 UDB Stored Procedures With the Microsoft Visual Studio .NET Add-In
http://www7b.boulder.ibm.com/dmdd/library/tutorials/0308jamshidi/index.html

Tips for Installing Fix Pack 3 on DB2 Universal Database v.8.1
http://www7b.boulder.ibm.com/dmdd/library/techarticle/0308zikopoulos/0308zikopoulos.html

Migrating to DB2 Universal Database Express Edition V8.1: A Roadmap for Developers and Administrators
http://www7b.boulder.ibm.com/dmdd/library/techarticle/0308carew/0308carew.html

Implementing an SQL EJB Wrapper as a Model Helper Using an Access Bean
http://www7b.boulder.ibm.com/dmdd/library/techarticle/0308lau/0308lau.html

An Analysis of IBM DB2 Enterprise Content Management Products
http://www7b.boulder.ibm.com/dmdd/library/techarticle/0308ayachitula/0308ayachitula.html

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/