|
All,
I've combined the last two issues of the DB2 Magazine E-Mail Newsletter .... This will do it for me this year. Have a great 2003!
*****************************
DB2 Magazine Email Newsletter
Volume 3, Issue 11 and
Volume 3, Issue 12
http://www.db2mag.com
*****************************
IN THIS ISSUE:
1. The Automated Future: "Techno bigots" need not apply
The Automated Future: Craig S. Mullins heralds the arrival of "Robo-DBAs"
2. Asked and Answered: DB2 and Linux
Asked and Answered: Why is my application still trying to acquire a tablespace lock?
3. IBM News
* IBM acquires Tarian Software
* IBM/Crystal Decisions Webinar
* IBM announces plans to buy Rational Software Corp.
* Intelligent Enterprise names IBM to "The Dozen"
* National Geographic builds image store on IBM technology
4. Skills and Certification
* Free Content Manager Study Guide
* New V.8 Certification Guides
* DB2 UDB for Oracle Administrators Class
5. Now Playing at the DB2 Developer Domain
6. At the Bookstore: Impossible Data Warehouse Situations
At the Bookstore: DB2 UDB For OS/390 v.7.1 Application Certification Guide
******************************
1. The Automated Future:
IBM wants automation and self-management in DB2 to take some of the
performance burden off DBAs. But if performance and tuning is no
longer the heart of the DBA's role, what will be? DB2 Magazine asked
several industry experts to voice their opinion about whether DBAs
will be needed at all and, if so, for what. The article "Where Do You
Want to Go Next?" -- available at http://www.db2mag.com -- summarizes
the experts' views. Now you can read the full interview with
consultant and DBA Howard Fosdick, in which he dishes on how
multimedia and XML projects will impact DBAs and why "techno bigots"
will be left behind
http://news.db2mag.com/cgi-bin4/flo?y=eJpY0EXHHW0CsY0Bm2g0AT
The Automated Future: Take 2
DB2 Magazine asked Craig S. Mullins, director of DB2 technology
planning for BMC Software, to tackle the question of the DBA's future.
Read what he told us about the arrival of "Robo-DBAs" on the data
management scene.
http://news.db2mag.com/cgi-bin4/flo?y=eJ6i0EXHHW0CsY0BoYc0AO
******************************
2. ASKED AND ANSWERED
I have some questions about DB2 and Linux:
1. What Linux kernel parameters need to be tuned for DB2 on Red Hat
Linux Professional 7.2, 7.3/Advanced Server 2.1?
2. What files compile DB2 stored procedures on Linux? When I compile a
stored procedure, DB2 generates a package, Pnnnnnnn, but I don't want
a system-generated package name. I want to name the package myself.
IBM Canada's Paul Zikopoulos sets readers straight at
http://news.db2mag.com/cgi-bin4/flo?y=eJpY0EXHHW0CsY0Bm2h0AU
I have a very volatile table (high insert and delete activity) that
applications were frequently getting contention (unavailable resource
errors) on.
To help solve this problem, I:
* Changed the tablespace to be LOCKSIZE ROW, LOCKMAX 0 (to avoid
escalation)
* Changed or verified that plans and packages accessing the table were
bound with CS and RELEASE(DEALLOCATE)
* Made sure batch programs had commit logic.
These changes helped quite a bit except for one packaged application
that issues dynamic (via JDBC) SQL selects and deletes against the
table. The package is up 24x7, and when it executes at the same time
as a batch program accessing this same table, a timeout (-904) often occurs
on the packaged application.
I plan on double-checking the commit frequency, ISOLATION (CS) and
CURRENTDATA (NO) settings of the batch program, and the commit
frequency of the packaged app. However, a SQL trace of the packaged
application indicates that it's still trying to acquire a tablespace
lock, which surprises me given the changes I made (LOCKSIZE ROW,
LOCKMAX 0). Does this seem likely or even possible?
Find out what DB2 DBA guru Robert Catterall thinks.
http://news.db2mag.com/cgi-bin4/flo?y=eJ6i0EXHHW0CsY0BoYf0AR
******************************
3. IBM NEWS
IBM announces agreement to buy Rational Software
IBM and application-development tool provider Rational Software
announced a definitive agreement for IBM to acquire Rational's equity
for approximately $2.1 billion in cash. The acquisition will enable
IBM to provide a complete software development environment for
companies wanting to integrate their business processes and software
infrastructure. Rational will become a fifth brand in IBM Software
Group, joining siblings DB2, WebSphere, Lotus, and Tivoli.
http://news.db2mag.com/cgi-bin4/flo?y=eJ6i0EXHHW0CsY0BoYd0AP
IBM One of Intelligent Enterprise's Top Picks
Every year, Intelligent Enterprise magazine (published by DB2 Magazine
parent CMP Media LLC) lists the top "12 most influential companies
enabling the intelligent enterprise." Once again, the magazine's
editors place IBM near the top of the list, citing IBM's autonomic
computing initiative in general and DB2 UDB v.8's self-healing
features specifically.
http://news.db2mag.com/cgi-bin4/flo?y=eJ6i0EXHHW0CsY0BoYe0AQ
National Geographic Taps a Visual Gold Mine
The National Geographic Society, the nonprofit scientific and
educational group based in Washington, D.C., has created a new
commercial Web site built on IBM Content Manager, DB2, and WebSphere
technologies. The site will sell, for the first time ever, images from
the Society's massive collection of 10 million images.
http://news.db2mag.com/cgi-bin4/flo?y=eJ6i0EXHHW0CsY0BncI0A6
IBM Acquires Tarian Software
IBM acquired all assets of Canadian records management provider Tarian
Software. IBM says the Tarian acquisition will let Big Blue address
customers' need to digitize, integrate, and manage information.
Records management software enables organizations to apply record
retention and disposal policies to electronically stored information.
The software integrates with a company's existing technology
infrastructure, enabling them to apply rules by which organizations
can comply with record retention policies and meet regulatory
requirements. Tarian operations and staff will be integrated in the
IBM's Data Management Software Group. For details, go to
http://news.db2mag.com/cgi-bin4/flo?y=eJpY0EXHHW0CsY0Bm2i0AV
******************************
4. SKILLS AND CERTIFICATION
Free Content Manager Multiplatform Study Guide
A free self-study certification guide for exam 442, IBM Content
Manager Version 8 is now available for download from the IBM site. The
guide covers installation, configuration, and management of the
Content Manager system.
http://news.db2mag.com/cgi-bin4/flo?y=eJpY0EXHHW0CsY0Bm2k0AX
New DB2 V.8 Exams
Three new DB2 UDB v.8 exams will be available starting December 16,
2002: DB2 UDB v.8.1 Family Fundamentals (Exam 700), DB2 UDB v.8.1 for
Linux, Unix, and Windows Database Administration (Exam 701), and DB2
UDB v.8.1 Family Application Development (Exam 703). For details on
these and other DB2 UDB exams, go to
http://news.db2mag.com/cgi-bin4/flo?y=eJpY0EXHHW0CsY0Bm2l0AY
DB2 UDB for Oracle System Administrators Class
Oracle administrators have an edge in becoming DB2 UDB system
administrators. And now IBM is offering a class tailored specifically
for experienced Oracle administrators who want to understand DB2 UDB.
For more information about the DB2 UDB for Oracle administrators
class, go to
http://news.db2mag.com/cgi-bin4/flo?y=eJpY0EXHHW0CsY0Bk8s0Aj
******************************
5. NOW PLAYING AT THE DB2 DEVELOPER DOMAIN
Tutorial: Efficient ways to publish your DB2 data as XML
http://news.db2mag.com/cgi-bin4/flo?y=eJpY0EXHHW0CsY0Bm2m0AZ
Tutorial: Optimal DB2 Performance with SQLJ and JDBC
http://news.db2mag.com/cgi-bin4/flo?y=eJpY0EXHHW0CsY0Bm2n0Aa
Tutorial: Using SQL Assist to Generate SQL Queries in DB2
http://news.db2mag.com/cgi-bin4/flo?y=eJpY0EXHHW0CsY0Bm2o0Ab
Yet Another Article on Advanced Scripting
http://news.db2mag.com/cgi-bin4/flo?y=eJpY0EXHHW0CsY0Bm2p0Ac
Creating SQL Queries the Easy Way with SQL Assist for DB2 UDB v.8.1
http://news.db2mag.com/cgi-bin4/flo?y=eJpY0EXHHW0CsY0Bm2q0Ad
Writing a Web-based Table Editor GUI for DB2
http://news.db2mag.com/cgi-bin4/flo?y=eJpY0EXHHW0CsY0Bm2r0Ae
DB2 Basics: Fun With Dates and Times
http://news.db2mag.com/cgi-bin4/flo?y=eJpY0EXHHW0CsY0Bm2s0Af
Informix Developer Zone: A Successful Implementation of a Data
Structure for Storing Multilevel Objects with Varying Attributes
http://news.db2mag.com/cgi-bin4/flo?y=eJ6i0EXHHW0CsY0BoYg0AS
Monitoring WebSphere Applications on DB2 Servers
http://news.db2mag.com/cgi-bin4/flo?y=eJ6i0EXHHW0CsY0BoYh0AT
Database Recovery using Incremental Redirected Restore
http://news.db2mag.com/cgi-bin4/flo?y=eJ6i0EXHHW0CsY0BoYi0AU
DB2 Redirected Restore Scripts
http://news.db2mag.com/cgi-bin4/flo?y=eJ6i0EXHHW0CsY0BoYj0AV
Building a Web Service in Delphi with a DB2 Backend
http://news.db2mag.com/cgi-bin4/flo?y=eJ6i0EXHHW0CsY0BoYk0AW
Planning Capacity and Tuning Performance for Query Patroller v.7.2 on
DB2 UDB EEE for AIX
http://news.db2mag.com/cgi-bin4/flo?y=eJ6i0EXHHW0CsY0BoYl0AX
******************************
6. AT THE BOOKSTORE
Impossible Data Warehouse Situations: Solutions from the Experts, by
Sid Adelman, et al.
Building and maintaining a data warehouse is fraught with managerial
and technical pitfalls. Impossible Data Warehouse Situations
introduces possible solutions to 91 common crises that confront
companies of all types, sizes, and structures. Nine leading data
warehousing experts provide detailed guidance for corporate
executives, IT managers and staff, and users. The book serves as a
quick reference for resolving specific data warehouse problems and as
a practical introduction to the realities of data warehousing not
covered in basic texts. Find out more at
http://news.db2mag.com/cgi-bin4/flo?y=eJpY0EXHHW0CsY0Bk8y0Ap
DB2 UDB For OS/390 v.7.1 Application Certification Guide
by Susan Lawson
DB2 UDB for OS/390 v.7.1 Application Certification Guide is a guide to
developing applications with DB2 UDB v.7.1 in OS/390 and z/OS
environments and to preparing for the IBM DB2 UDB v.7.1 Family
Application Development Exam (#514). This book delivers tips,
techniques, and expert guidelines for DB2 application development,
including data structures, SQL, stored procedures,
programming/language environments, object-relational features,
debugging, and tuning. A sample exam on CD-ROM is included.
http://news.db2mag.com/cgi-bin4/flo?y=eJ6i0EXHHW0CsY0Bk8y0A
Jay Allen (ja@...)
Software IT Specialist
IBM Data Management Solutions
(602) 217-2937 - Phone
(602) 217-2937 - Fax
IBM Certified Advanced Technical Expert -
DB2 UDB V6 Database Administration
DB2 for Clusters
|
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.
