|
Monthly DB2 Update
All,
Here are new DB2 related topics over
the past month or so.
-------------------------------------------------------------------------------------
Save the Date! IBM Information
On Demand 2006 global conference
(http://www-306.ibm.com/software/data/ondemandbusiness/conf2006/)
The IBM Information On Demand 2006 global
conference is the premier information management event for business and
IT executives, managers, professionals, DBA's and developers. More
IBM technical and business solutions content will be in one place than
ever before. Select from over 800 sessions: a 2 1/2 day business
leadership track with 180 sessions and a 5 day technical track with 650
sessions.
Jay's Note: this conference combines
the DB2 Technical Conference, the Informix User's Conference, the IMS Technical
Conference and IBM Information Integration Live! into a single week of
technical content. This IS IBM's Information Management premier educational
conference.
Jay's Note: are you interested
in presenting at the conference? If so and you haven't received the
call for presentations, please contact me and I'll get the information
to you as quickly as possible.
-------------------------------------------------------------------------------------
IDUG North America - May 7 - 11,
2006
(http://conferences.idug.org/Default.aspx?alias=conferences.idug.org/na)
Go Further...with formal educational
sessions, informal networking, a products and services exhibition, and
IBM developer panel sessions. Register today!
IDUG 2006 – North America will take
place May 7-11, 2006 in Tampa, Florida. Once again, this premier user-run
educational forum for IBM database technology users not only provides you
with essential information needed for long-term career success, but addresses
timely topics of interest as determined by your peers who share many of
the same challenges as you.
Jay's Note: this year, the International
Informix Users Group Conference will take place in conjunction with IDUG
in Tampa, FL. Let your Informix colleagues know about the event if
they haven't already heard.
-------------------------------------------------------------------------------------
Redbook: E-mail Archiving
and Records Management Integrated Solution Guide Using IBM DB2 CommonStore
and DB2 Records Manager
(http://www.redbooks.ibm.com/abstracts/sg246795.html)
As more companies need to manage their
e-mail to support regulatory compliance, litigation, and corporate policy
and to improve system performance and productivity, the e-mail archiving
and records management solution presented in this IBM Redbook is here to
rescue.
In this book, we provide a general solution
guide to address e-mail archiving and records management issues using the
following IBM products:
- IBM DB2 CommonStore for Lotus Domino
V8.3 or IBM DB2 CommonStore for Exchange Server V8.3
- IBM DB2 Records Manager V4.1.2
- IBM DB2 Content Manager V8.3
- IBM DB2 Content Manager Records Enabler
V8.3
We describe the products’ roles in
the solution and introduce the basic concepts behind e-mail archiving and
e-mail records enabling. We cover features and functions of CommonStore,
Records Manager, and Records Enabler, and address key areas to understand
and consider when planning and designing each piece of the solution and
the overall integrated solution. In addition, we discuss different system
configurations, implementation paths, security, the end-to-end solution
installation and configuration, and some advanced topics such as records
disposition and discovery.
This book is intended for IT architects
and specialists who will be responsible in planning, designing, and implementing
an e-mail archiving and records management solution.
-------------------------------------------------------------------------------------
Redbook: IBM DB2 Recovery
Expert for Multiplatforms V2 Usage Guide
(http://www.redbooks.ibm.com/abstracts/sg247133.html)
IBM DB2 Recovery Expert for Multiplatforms
provides an enhanced data recovery solution that enables more precise recovery
operations while reducing disruption during the recovery process. DB2 Recovery
Expert creates and maintains additional recovery assets that you can use
for intelligent analysis of both DB2 and DB2 Recovery Expert assets to
find the most efficient recovery path. DB2 Recovery Expert facilitates
the process of rebuilding your database assets, such as tables, indexes,
and data, to a specified point-in-time, often without taking the database
or the business operations offline.
This IBM Redbook shows you how to install
and implement DB Recovery Expert and the Fast Backup and Grouper components.
It also describes the DB2 Recovery Expert assets and how to manage these
assets.
In addition, this redbook explains the
summary and detail reports of Log Analysis, including the DPF environment.
It shows, in detailed examples, point-in-time recovery and cloning of tables,
table spaces, and databases.
-------------------------------------------------------------------------------------
Benchmark Results: DB2 8.2
on 16way p5 570 delivers record breaking performance
(http://blogs.ittoolbox.com/database/technology/archives/007767.asp)
On February 14, 2006 IBM delivered another
first in TPC-C. The first to break the 1 million tpmC mark with only 16
processor cores. DB2 8.2 running on a 16way eServer p5 570 delivered 1,025,169
tpmC. This is the first time any vendor has delivered this level of performance
on only 16 processors.
Jay's shameless plug: all of you
that work with or support DB2 UDB in the Linux, Unix or Windows environment
should subscribe to Chris Eaton's blog. Good stuff delivered to your
e-mail inbox every week!
-------------------------------------------------------------------------------------
On Demand Webcast: EAI, ETL, EII,
SOA - Achieving Interoperability Among Multiple Integration Technologies
(http://www-306.ibm.com/software/sw-events/webcast/T247840Y94716N27.html)
In recent years, IT departments have
struggled to integrate application silos they deployed in the late 1990s.
These departments now face "meta-integration" projects
that stitch together multiple integration tools and technologies
into a cohesive integration infrastructure. This process is complex
and little understood, yet fundamental to data-grid and service-oriented
technology practices, as well as real-time and on-demand business practices.
Watch this on demand Web seminar and hear from TDWI and IBM Software
Group to learn how progressive IT departments are achieving interoperability
among multiple integration technologies. Watch the replay.
-------------------------------------------------------------------------------------
White Paper: IBM Information Integration
Platform Delivers Information You Can Trust (registration required)
(http://ibm.ascential.com/litlib/files.html/download/368)
This new white paper provides an introduction
to information integration and the benefits that can result from information
provided as a service, regardless of its location, its complexity or the
diversity of data sources within the enterprise. You will learn to
recognize the information integration requirements associated with six
critical business initiatives and the fundamental capabilities of the IBM
Information Integration platform.
-------------------------------------------------------------------------------------
White Paper: Hurwitz and
Associates publishes a new customer benefit study on information integration
(registration required)
(http://ibm.ascential.com/litlib/files.html/download/384)
A sound information infrastructure is
critical for companies to be successful in today's market. In this
new paper, Hurwitz and Associates, a research and consulting firm that
provides objective and pragmatic guidance to buyers and sellers of information
technologies, performed a benefits study with a set of IBM Information
Integration customers and framed these benefits in a discussion of the
importance of information integration and IBM's forward-thinking approach
to it. Companies noted very tangible technical and business benefits,
including significant increases in productivity, improved decision making
and an increased ability to respond to opportunities and threats, using
IBM's technology.
-------------------------------------------------------------------------------------
developerWorks: Leverage
data partitioning for scalability and high performance on Linux
(http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0601poon/index.html)
Visit this site to learn and explore
the performance and scalability advantages of the IBM DB2® Universal Database(TM)
Data Partitioning Feature (DPF) in DB2 UDB for Linux®, UNIX®, and Windows®.
Walk through the steps to install and configure DB2 with DPF on SUSE
Linux Enterprise Server.
-------------------------------------------------------------------------------------
Product Announcement: IBM
DB2 Alphablox V8.4 broadly deploys customized analytics
(http://www-306.ibm.com/common/ssi/fcgi-bin/ssialias?infotype=an&subtype=ca&appname=plc_qmf&htmlfid=897/ENUS206-051)
DB2 Alphablox for Linux, UNIX, and Windows
V8.4 offers new capabilities that deliver customized, embedded analytical
applications. It can help you and partners maximize the value of information
assets by delivering contextual business insight to the right people at
the point of decision.
New capabilities that enable this include
improved clustering, scalability enhancements, improved relational cubing
engine, lowered cost for multilanguage deployments, and several additional
features and functions.
In addition, V8.4 delivers AJAX-based
components, a comprehensive framework for integrating analytics into existing
business processes and systems.
-------------------------------------------------------------------------------------
Product Announcement: IBM
DB2 Data Warehouse Edition V9.1 delivers a next-generation integrated platform
for data warehousing and analytic application support
(http://www-306.ibm.com/common/ssi/fcgi-bin/ssialias?infotype=an&subtype=ca&appname=plc_qmf&htmlfid=897/ENUS206-049)
IBM DB2 Data Warehouse Edition (DWE)
V9.1, the first fully integrated data warehousing platform from IBM, provides
deeper integration of metadata and runtime infrastructure. DWE helps you
achieve information on demand by integrating core components for warehouse
administration, data mining, Online Analytical Processing (OLAP), and inline
analytics/reporting along with the improved performance and usability of
business intelligence (BI) features for real-time insight and decision
making.
Key to this new release is an integrated
Design Studio. The Eclipse-based application opens up interoperability
with IBM's Rational development tools as well as allowing for custom plug-ins.
Tasks that were previously managed in a diverse way are now pulled together
into a single, Eclipse-based console that permits the architecture, design,
coding, and testing of all aspects of your data warehouse from a single
interface. This increases DBA productivity while opening the data mining
and OLAP areas to intuitive control.
DWE is based on the technology of SQL
Warehousing Tool, Intelligent Miner, Cube Views, and Alphablox. The Eclipse-based
Design Studio integrates Rational Data Architect plug-ins for physical
data modeling, together with other DWE components for modeling of warehouse-based
analytic structures.
DWE contains a full, unrestricted copy
of DB2 Enterprise Server Edition database, delivering to users a relational
database system with the ability to handle the most demanding OLTP work
loads. Featured is a loosely coupled, shared-nothing architecture that
permits linear scaling, lack of performance bottlenecks, and the most feature-rich
and fully integrated capabilities IBM has ever offered for enterprise data
warehouses.
Jay's note: with DB2 Data Warehouse
Edition V9.1, IBM is also announcing the withdrawal from marketing of DB2
Cube Views and DB2 Intelligent Miner. Going forward, these products
will be integrated into DB2 Data Warehouse Edition and will not be available
as separately orderable products. See http://www-306.ibm.com/common/ssi/fcgi-bin/ssialias?infotype=an&subtype=ca&appname=plc_qmf&htmlfid=897/ENUS906-047
for details.
-------------------------------------------------------------------------------------
Product Announcement: IBM
Rational Data Architect is an enterprise data modeling, integration, and
development tool designed to help data architects understand information
assets
(http://www-306.ibm.com/common/ssi/fcgi-bin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=897&letternum=ENUS206-056)
IBM Rational Data Architect V6.1 is
a new enterprise data modeling tool in the Information Management software
portfolio. Rational Data Architect is designed to help data architects
understand information assets and their relationships, design federated
databases, and streamline database projects. Rational Data Architect provides
advanced features to help data architects discover, model, visualize, relate,
and develop heterogeneous data assets. Architected for integration, Rational
Data Architect combines traditional data modeling capabilities with data
source mapping discovery and model analysis, all organized in a modular
project-based manner. Rational Data Architect is integrated with requirements
management and team products for improved project time-to-value, consistency,
and accuracy in the enterprise environment.
IBM Rational Data Architect 6.1 has
rich functionality, which gives data professionals the ability to:
* Intelligently design a relational
or federated database
* Discover and define relationships
within and across data sources and targets
* Perform impact analysis across models
* Compare and synchronize models to
deployed databases
* Create enterprise data standards,
verify compliance, and generate compliant models
-------------------------------------------------------------------------------------
DB2 Magazine Email Newsletter
- Volume 7, Issue 2
(http://news.db2mag.com/cgi-bin4/DM/y/euhn0FhO7y0FLd0BqV70AX)
*********************************
IN THIS ISSUE:
1. From the Editor
* DB2 Magazine Quarter 1, 2006 highlights
2. Asked and Answered
* More on split mirroring
3. Poll Positions
* Who's planning for SOAs?
4. Skill Sets
* Advanced certification hints, Web casts, training discounts,
and
more
5. Must Reads
* Database Modeling and Design: Logical Design
6. In the Zone
* The latest DB2 and Informix articles from developerWorks
*********************************
1. FROM THE EDITOR: DB2 Magazine Quarter 1 Highlights
* The High Cost of Not Knowing
There's a funny turn of phrase in an article you'll read in this
issue. The writer has just shared an anecdote about being a customer
of four different divisions of one company. Instead of allowing the
company to capitalize on an extensive relationship, the author says
the multiple touch points turn into "a plethora of opportunities for
my financial provider not to know me."
Missed opportunities resulting from an inability to deliver accurate,
complete information where it's needed is a very common business
problem. IBM is betting that its customers are savvy enough to
recognize the potential to get in front of their competitors by
capitalizing on information. That's why it announced a $1 billion
investment in Information On Demand last month. Information On Demand
technologies combined with service-oriented architectures will produce
a "tectonic shift" in the way companies manage information, according
to Ambuj Goyal, general manager of IBM information services.
--Read the interview with Ambuj Goyal.
http://news.db2mag.com/cgi-bin4/DM/y/euhn0FhO7y0FLd0EJwE0Ai
--Follow data on the path to information.
http://news.db2mag.com/cgi-bin4/DM/y/euhn0FhO7y0FLd0EJwF0Aj
--Browse these additional highlights.
* Take the Fast Train
The new DB2 Express-C is the quickest ride to the latest data server
technologies. And there's one more interesting thing: It's free.
http://news.db2mag.com/cgi-bin4/DM/y/euhn0FhO7y0FLd0EJwG0Ak
* Zooming In On Saturn
DB2 version 8.2.2 introduced new features for SAP users that are as
innumerable (and in some cases as invisible to the naked eye) as the
rings of Saturn. An SAP/DB2 customer turns his lens on the features he
expects will exert the greatest pull for SAP shops.
http://news.db2mag.com/cgi-bin4/DM/y/euhn0FhO7y0FLd0EJwH0Al
--Read the latest DB2 and Informix technical tips from Robert
Catterall, Roger Sanders, Lester Knutsen, and more.
http://news.db2mag.com/cgi-bin4/DM/y/euhn0FhO7y0FLd0EJwI0Am
*********************************
2. ASKED AND ANSWERED
* In your recent column on split mirroring for DB2 for Linux, Unix,
and Windows, you write that the SET WRITE RESUME command must be
executed from the same database connection that has executed the SET
SUSPEND command. What do you do when this session has abended?
--Read Roger Sanders' advice.
http://news.db2mag.com/cgi-bin4/DM/y/euhn0FhO7y0FLd0EJwJ0An
*********************************
3. POLL POSITIONS
* What's your company's position on service-oriented architectures?
--Let your opinion count in the DB2 Magazine poll.
http://news.db2mag.com/cgi-bin4/DM/y/euhn0FhO7y0FLd0Bw8K0AT
* Last month, more than 500 people revealed their deepest, darkest
secrets: How much they know (or don't know) about XML.
--Read the final results.
http://news.db2mag.com/cgi-bin4/DM/y/euhn0FhO7y0FLd0EJ7z0AX
*********************************
4. SKILL SETS
* Skill Zone
Columnist Howard Fosdick reveals the secrets to earning the most
advanced DB2 DBA credential.
http://news.db2mag.com/cgi-bin4/DM/y/euhn0FhO7y0FLd0EJwK0Ao
* Upcoming IBM Webcasts
-- March 7: Learn about DB2 Viper technology (March 7th)
http://news.db2mag.com/cgi-bin4/DM/y/euhn0FhO7y0FLd0EJwL0Ap
-- March 15: Getting top performance out of your Business
Intelligence solution
http://news.db2mag.com/cgi-bin4/DM/y/euhn0FhO7y0FLd0EJwM0Aq
* IBM Webcast Replays Available
-- Optimizing Power Solutions with DB2 Express to Deliver
Information on Demand
http://news.db2mag.com/cgi-bin4/DM/y/euhn0FhO7y0FLd0EJwN0Ar
* IBM Education Discounts
Enroll in certain public IBM classes (valued at $1,995 or greater)
between February 1 and April 4, 2006, and can save $500 off the
tuition price.
--Read offer details and get the priority code.
http://news.db2mag.com/cgi-bin4/DM/y/euhn0FhO7y0FLd0EJwO0As
*********************************
5. MUST READ
* Database Modeling and Design: Logical Design
By Toby J. Teorey, Sam Lightstone, and Tom Nadeau
The fourth edition of Database Modeling and Design separates logical
and physical design into two separate books to address what the
authors call "vast and explosive changes" in database design
techniques. The Logical Design volume covers entity-relationship and
Unified Modeling Language (UML) approaches.
--Learn more about this book.
http://news.db2mag.com/cgi-bin4/DM/y/euhn0FhO7y0FLd0Bk8y0A2
*********************************
6. NOW PLAYING AT THE DEVELOPERWORKS DB2 ZONE
* Leverage Your MySQL skills to Learn DB2 Express
http://news.db2mag.com/cgi-bin4/DM/y/euhn0FhO7y0FLd0EJwP0At
* Improve Persistence with Apache Derby and iBATIS, Part 2
http://news.db2mag.com/cgi-bin4/DM/y/euhn0FhO7y0FLd0EJwQ0Au
* Develop and test SQLJ programs for DB2 using Rational Application
Developer
http://news.db2mag.com/cgi-bin4/DM/y/euhn0FhO7y0FLd0EJwR0Av
* Configure and use IDS/OnBar with Tivoli Storage Manager
http://news.db2mag.com/cgi-bin4/DM/y/euhn0FhO7y0FLd0EJwS0Aw
* Configure Informix Dynamic Server with WebSphere Application Server
http://news.db2mag.com/cgi-bin4/DM/y/euhn0FhO7y0FLd0EJwT0Ax
-------------------------------------------------------------------------------------
Jay Allen (ja@...)
Consulting Software IT Specialist
IBM Data Management Solutions
(602) 217-2937 - Phone
(602) 217-2937 - Fax
|
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.
