|
Monthly DB2 Update
All,
I'm baaack .... Here are new DB2
related topics over the past month or so.
-------------------------------------------------------------------------------------
Redbook: Data Integrity
with DB2 for z/OS
(http://www.redbooks.ibm.com/abstracts/sg247111.html)
DB2 provides functions to guarantee
integrity at the system level and at the application level. From the system
point of view, DB2's integration with zSeries and disk storage architecture
is the cornerstone for data integrity. Logging functionality and COPY and
RECOVER utilities are the building blocks for bringing the table space
back to a current or consistent status in case of hardware or software
failures or when application events need to be rerun.
From the application point of view,
DB2 supports locking and commit at the transaction level, and general data
integrity (at entity and semantic level), and a set of referential constraint
rules for each parent/dependent table relationship. The tables linked by
referential integrity are recognized during the execution of the QUIESCE
utility. Other logical relations across tables, necessary to support business
rules, are implemented via constraints, triggers, user defined functions,
and user defined tables. Informational constraints also exist, they are
not enforced by the database manager, they are used to improve query performance.
In this IBM Redbook, we briefly describe the integration of DB2 for z/OS
with System z architecture, we then explore the data integrity options
and utilize the standard recovery functions for application-related issues.
-------------------------------------------------------------------------------------
Redbook: DB2 9: pureXML
Overview and Fast Start
(http://www.redbooks.ibm.com/abstracts/sg247298.html)
Services Oriented Architectures (SOA)
are an integral part of building an agile enterprise capable of making
decisions quickly, and responding rapidly to new products and services
opportunities, as well as to competitive threats. The explosive growth
of XML data in businesses today across multiple industries has underscored
the role of XML as the "fabric of Services Oriented Architectures"
and the need to integrate XML data into enterprise information infrastructure.
DB2 9 (previously code-named “Viper”)
enables an information-centric approach to service oriented architecture
implementations, which rely upon the ability to access a myriad of data
stored across multiple formats. With its dual pure XML data management
and traditional relational data capability, DB2 9 delivers information
as a service in SOA environments, connecting information on-the-fly, where
you need it, and when you need it!
XML data requires the same coveted qualities
of service that relational databases provide: high availability, reliability,
protection, and performance. The pureXML™ technology in DB2 9 unlocks
the latent potential of XML by providing simple efficient access to XML
with the same levels of security, integrity, and resiliency taken for granted
with relational data. With pureXML innovation in DB2 9, your organization
can expect breakthrough increases in availability, speed, and versatility
of your XML information, along with dramatically reduced development and
administrative costs.
This IBM Redbook serves as an introduction
to the hybrid XML data services in DB2 9 for Linux, UNIX, and Windows.
It also provides data server professionals a fast start for using and exploring
pureXML capabilities in DB2 9 and get them started with leveraging XML
information for maximum return.
-------------------------------------------------------------------------------------
Redbook: Microsoft SQL Server
to IBM DB2 UDB Conversion Guide
(http://www.redbooks.ibm.com/abstracts/sg246672.html)
DB2 Universal Database (DB2 UDB) has
long been known for its technology leadership. This IBM Redbook is an informative
guide that describes how to convert the database system and applications
from Microsoft SQL Server to DB2 UDB Version 8.2.
This guide presents the best practices
in conversion strategy and planning, an architecture overview of the two
relational database systems, migration tools, and practical conversion
examples. It is intended for technical staff involved in a SQL Server to
DB2 UDB conversion project.
We discuss, in detail, the conversion
of database structure, data, and database objects including stored procedures,
triggers, and user defined functions. We address SQL and application conversion
considerations. Examples are used throughout the book to illustrate the
conversion and to provide solutions and work-arounds for different scenarios.
In addition, we provide a DB2 tools
and wizard usage overview, performance considerations, and testing and
troubleshooting techniques. Finally, a migration scenario using the IBM
DB2 Migration Toolkit is included to show the complete migration process.
-------------------------------------------------------------------------------------
Announcement: IBM Entity
Analytics Solutions Global Name Recognition technologies deliver name-recognition
solutions
(http://www-306.ibm.com/common/ssi/fcgi-bin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=897&letternum=ENUS206-160)
IBM Entity Analytics Solutions:
* Increase precision for
name processing by delivering cultural classification as a range of scores
for automated processing
* Add intelligence to
automated name processing by applying business rules specific to the name's
culture
* Increase accuracy and
selectivity by examining each possible name, rather than using a key-based
approach
* Increase usefulness
of search results by delivering matched names in ranked order with a confidence
score for automated processing
* Reduce false positives
by intelligently processing the cultural variations found in names
Entity Analytics Solutions Global Name
Recognition technologies solve the complex problem of searching and managing
data on individuals in a multicultural, error-prone world. The technologies
can spot fraud and other threats. The software takes into account alternative
spellings, cultural nuances, and other linguistic issues as part of an
attempt to return the most relevant information for a search query, rather
than a laundry list of close matches.
-------------------------------------------------------------------------------------
Announcement: IBM DB2 Everyplace
V9.1 offers a small footprint relational data store and enterprise synchronization
solution
(http://www-306.ibm.com/common/ssi/fcgi-bin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=897&letternum=ENUS206-182)
DB2 Everyplace V9.1 is the next-generation
of mobile data stores. It provides a full enterprise synchronization solution
to integrate enterprise and mobile information — from any location or
source, at any time, right in the palm of your hand.
The DB2 Everyplace database is optimized
for SAP Mobile Applications.
Shortens development time:
* Allows invisible/zero
administration
* Supports open standards
and eases integration with existing enterprise applications
Makes operations more efficient:
* A small footprint (approximately
350 KB) relational database able to handle tens of thousands of records
* Advanced conflict detection
and resolution when synchronizing with a JDBC-compliant database such as
DB2, IDS, Oracle, or Microsoft™ SQL Server
* Broad mobile and embedded
device platform support
-------------------------------------------------------------------------------------
DB2 Magazine Email Newsletter
- Volume 7, Issue 7
(http://news.db2mag.com/cgi-bin4/DM/y/eyBi0FhO7y0FLd0BqV70As)
IN THIS ISSUE:
1. From the Editor
* DB2 and Ruby on Rails
* Zend Core for DB2
* Entity Analytics Solutions
2. Asked and Answered
* How to submit a requirement for a technical change to DB2
3. Poll Positions
* Who are you excited to see?
4. Skill Sets
* Free certification, IIUG in Europe, and new Web casts
5. In the Zone
* The latest DB2 and Informix articles from developerWorks
************************************************
1. FROM THE EDITOR
We've just put the finishing touches on the Quarter 3, 2006, issue of
DB2 Magazine, which you'll find in your mailboxes in just a couple of
weeks. The issue is full of practical tips, techniques, and code
samples for working with DB2 9's new XML capabilities using Java, PHP,
Ajax, and more. You'll have to wait to read those articles, but there
are a few notable news items I can share with you now. -- Kim Moutsos
* DB2 and Ruby on Rails
IBM recently released an alphaWorks project called the Starter Toolkit
for DB2 on Rails. The toolkit gives Windows XP and Windows Server 2003
users a single-click installer for Ruby, Rails, learning materials,
DB2 Express-C, three Flash tutorials, and a CHM version of the first
edition of Programming Ruby: The Pragmatic Programmers Guide (Pragmatic
Bookshelf, 2000). Using the toolkit, developers can create a simple DB2
Ruby on Rails application in about 30 minutes. Linux developers can use
DB2 on Rails, too. The alphaWorks project contains complete source code
for the DB2 Ruby driver and the Rails adapter.
--Download the toolkit.
http://news.db2mag.com/cgi-bin4/DM/y/eyBi0FhO7y0FLd0EfaT0AQ
* New Zend Core for IBM Release
Zend released a new version of its PHP development and production
environment Zend Core for IBM, which now includes support for Informix
Dynamic Server (IDS) as well as DB2. Other new features include PHP
Data Object (PDO) support, an embedded Apache server, an integrated
DB2 client, integrated Cloudscape and DB2 Express-C data servers, and
PHP 5.1.4.
--Learn more about the new release.
http://news.db2mag.com/cgi-bin4/DM/y/eyBi0FhO7y0FLd0DYBT0Af
* Entity Analytics Solutions (EAS) V4.1
IBM announced EAS V4.1 with new support for German, French, Spanish,
Italian and Brazilian Portuguese. EAS enables global clients in
government, banking, healthcare, insurance, and other industries to
analyze and compare data stored across information silos to recognize
identities and resolve the relationships of parties
seeking to perpetrate fraud or otherwise threaten organizations or
society. EAS 4.1 supports System z and the Linux operating system.
IBM's EAS software uses Entity Resolution technology to determine
identities, discover non-obvious relationships between identities, and
share this information without compromising the privacy of the
information.
--Find out about entity analytics
http://news.db2mag.com/cgi-bin4/DM/y/eyBi0FhO7y0FLd0EfaU0AR
************************************************
2. ASKED AND ANSWERED
A DB2 for z/OS reader asks how she can submit a requirement for a
technical change to DB2.
--Get advice from the source: Roger Miller, IBM Silicon Valley Lab.
http://news.db2mag.com/cgi-bin4/DM/y/eyBi0FhO7y0FLd0EfkG0AN
************************************************
3. POLL POSITIONS
If you're heading off to the Information On Demand 2006 conference in
Anaheim this fall (and even if you aren't), let us know which keynote
speaker you most want to hear.
--Make your vote count (or, in any case, make us count your vote).
http://news.db2mag.com/cgi-bin4/DM/y/eyBi0FhO7y0FLd0Bw8K0Ao
--Find out what everyone's looking forward to in DB2 9.
http://news.db2mag.com/cgi-bin4/DM/y/eyBi0FhO7y0FLd0EMWq0AK
************************************************
4. SKILL SETS
* Complimentary Certification at IBM Information On Demand 2006
At Information On Demand 2006, October 15 to 20 in Anaheim, Calif.,
attendees can take up to three certification exams at no charge.
Additional exams will incur a fee of $75. No registration is
necessary; testing will take place on a first-come, first-served
basis.
--Find out about Information on Demand 2006
http://news.db2mag.com/cgi-bin4/DM/y/eyBi0FhO7y0FLd0EUEI0AU
* DB2 9 Technical Seminars
IBM is offering free DB2 9 briefings around the world. In the one-day
sessions, attendees participate in developing a real project -- from
requirements analysis, modeling, and design to coding, testing, and
deployment. Live demos show how DB2 Express-C 9, Rational Data
Architect, and Zend Core for IBM work together.
--Get a list of locations.
http://news.db2mag.com/cgi-bin4/DM/y/eyBi0FhO7y0FLd0EfaV0AS
* IIUG Goes to Europe
The International Informix Users Group (IIUG) will work with the
International DB2 Users Group (IDUG) to bring two full tracks of
Informix sessions to the IIUG/IDUG Europe Conference October 2-6 in
Vienna. The conference will provide training on Informix Dynamic
Server V10, IBM Cloudscape and Apache Derby, and related tools, such
as Informix 4GL, PHP, and Java connectivity for Informix users in
Europe.
--Get conference details.
http://news.db2mag.com/cgi-bin4/DM/y/eyBi0FhO7y0FLd0EfkH0AO
* Webcast: Realize Your Information Investment With Data Quality
How much of your IT investment are you leveraging to ensure the
quality of your information? Are your business processes helping you
to make better decisions? Not only is high-quality data critical to
the success of business intelligence, master data management, and
infrastructure consolidation initiatives, it is also
essential for regulatory compliance imposed by the Sarbanes-Oxley Act,
the USA PATRIOT Act, and anti-money-laundering laws. Watch this on
demand Web cast to learn
about IBM products and services that can help you assess your data
quality, develop a game plan, and start improving the quality of your
enterprise data.
--Find out more.
http://news.db2mag.com/cgi-bin4/DM/y/eyBi0FhO7y0FLd0EfaX0AU
* Webcast: Empowering SOA: Providing Information as a Service to the
Business
While the concept has been around for a while, most companies think of
SOA as addressing process-centric issues, and probably haven't
considered it for information integration. Watch this on demand Web
cast to learn how organizations have leveraged SOA to deal with the
need for greater visibility, agility, efficiency, and governance of
their business.
--Watch the Web cast.
http://news.db2mag.com/cgi-bin4/DM/y/eyBi0FhO7y0FLd0EfaY0AV
************************************************
5. IN THE ZONE
* Use PHP scripts to access DB2 UDB for iSeries data with Zend Core
for i5/OS
http://news.db2mag.com/cgi-bin4/DM/y/eyBi0FhO7y0FLd0EfaZ0AW
* Document-level security using DB2 9 pureXML and LBAC
http://news.db2mag.com/cgi-bin4/DM/y/eyBi0FhO7y0FLd0Efaa0Ad
* Introducing DB2 9: Application and development enhancements
http://news.db2mag.com/cgi-bin4/DM/y/eyBi0FhO7y0FLd0Efab0Ae
* Archive Lotus QuickPlace attachments with CommonStore for Lotus
Domino
http://news.db2mag.com/cgi-bin4/DM/y/eyBi0FhO7y0FLd0Efac0Af
* Create customized views for line data reports
http://news.db2mag.com/cgi-bin4/DM/y/eyBi0FhO7y0FLd0Efad0Ag
* Security information management challenges and solutions
http://news.db2mag.com/cgi-bin4/DM/y/eyBi0FhO7y0FLd0Efae0Ah
* Developing with Apache Derby -- Hitting the Trifecta: Database
development with Apache Derby, Part 5
http://news.db2mag.com/cgi-bin4/DM/y/eyBi0FhO7y0FLd0Efaf0Ai
* DB2 9 certification exam 731 prep, Part 4: Monitoring DB2 activity
http://news.db2mag.com/cgi-bin4/DM/y/eyBi0FhO7y0FLd0Efag0Aj
-------------------------------------------------------------------------------------
DB2 Magazine Email Newsletter
- Volume 7, Issue 8
(http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0BqV70Ad)
IN THIS ISSUE:
1. From the Editor
* DB2 Magazine Q3, 2006: XML tips for developers and DBAs
2. IBM News
* IBM to buy FileNet
* IBM Information Server podcast and previews
3. Asked and Answered
* How to access the right data, even when multiple tables share
the
same unqualified table name
4. Poll Positions
* What's on your mind: technology or business?
5. Skill Sets
* Business intelligence certification, plus news and offers
6. Must Read
* IBM Rational ClearCase, Ant, and CruiseControl
7. In the Zone
* The latest DB2 and Informix articles from developerWorks
********************************
1. FROM THE EDITOR
* DB2 Magazine Quarter 3, 2006: XML tips for developers and DBAs
Last month, I promised tips, techniques, code samples, and advice for
working with DB2 9's pureXML abilities. Well, that promise is now
fulfilled. The Quarter 3 issue is so packed with information for
programmers, developers, and DBAs, I'm just going to cut right to the
chase and point you to the highlights. (Make sure you check DB2mag.com
for two bonus articles not available in print.) I'd like to hear what
you think of the articles. The first three readers to send me
comments on the issue can choose a book from a list of IBM Press and
other technical volumes stacked up in my office. You'll find my email
address here ( http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0EiAt0AE
)
or on page 6 of the print magazine. I hope you find the issue useful.
--Kim Moutsos
* For everyone
--XML in Focus. Ken North explores the developer-friendly features
that are speeding application development at companies like
financial-services giant Storebrand.
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0EhzM0AV
--Eye on XQuery. DevX.com contributor Justin Whitney demonstrates DB2
9's Visual XQuery Builder, a versatile design tool for developers new
to XQuery and veterans seeking a faster way to build complex queries.
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0EhzN0AW
* For Java programmers
--Opening the Door to XML. Learn how to connect to DB2 9's new XML
capabilities using techniques you already know.
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0EhzO0AX
* For PHP programmers
--XML Programming with PHP and Ajax. Find out how you can use your
knowledge of popular programming languages to put DB2 9's XML
capabilities to work in business scenarios, including service-oriented
architecture (SOA).
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0EhzP0AY
--PHP and Informix Dynamic Server. How to use the popular
Web-development language to access Informix data.
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0EiAu0AF
* For DBAs
--What's it to You? XML is here to stay. Distributed DBA columnist
Roger E. Sanders tells DBAs what they'll need to know to manage it.
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0EhzQ0AZ
--Parlez-Vous SOA? Robert Catterall schools DBAs in the building
blocks of SOA.
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0EhzR0Aa
********************************
2. IBM NEWS
* IBM to Acquire FileNet
IBM entered into a definitive agreement to acquire FileNet Corp. for
approximately $1.6 billion. The acquisition, subject to FileNet
shareholder approval, regulatory reviews and other customary closing
conditions, is expected to close in the fourth quarter of 2006.
FileNet provides business process and content management solutions.
Following completion of the acquisition, IBM intends to combine
FileNet's operations with IBM's Content Management business and
preserve and enhance customer investments in FileNet and IBM Content
Management platforms. IBM will also integrate its BPM and
service-oriented architecture technologies with the FileNet platform.
--Find out more.
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0Eh850Az
* New Podcast: IBM Information Server
IBM Information Server, working hand-in-hand with the patented
Iterations 2 data integration methodology, supports integration of all
data types and multiple architectures, providing a solid basis for
integrating disparate data and delivering trusted information wherever
and whenever needed. IBM's Michael Curry discusses how Information
Server can impact your business.
--Listen now.
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0Eh860A1
--Find out more on the Information Server Web site.
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0Ehzh0Aw
* IBM Information Server Interactive Overview
This interactive presentation provides an detailed overview of this
new unified platform for data integration.
--Learn more.
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0Eh870A2
********************************
3. ASKED AND ANSWERED
* When a program contains a static SQL statement that references an
unqualified table name, how can you know which table will be accessed
when your database includes several different tables (same structure,
different data) that have the same unqualified name but different
high-level qualifiers (such as different table owner IDs)?
--Find out what DB2 DBA columnist Robert Catterall suggests.
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0EhzS0Ab
--Browse the archive of Asked and Answered questions.
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0EhzT0Ac
********************************
4. POLL POSITIONS
* When you head off to a conference such as Information On Demand 2006
in Anaheim in October, are you looking to boost your technical
abilities, your business savvy, or both?
--Let your opinion be known.
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0EhzU0Ad
--Find out how the former head of the House of Mouse rated in last
month's poll.
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0EMWq0A4
********************************
5. SKILL SETS
* Certified Intelligence
With companies clamoring for business intelligence, a
certification credential can give DBAs and programmers an significant
edge with employers. Certification columnist Howard Fosdick hands out
the inside intel on passing IBM's DB2-based business intelligence
exam.
--Read Fosdick's column
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0EhzV0Ae
--Browse the archives for more certification strategies.
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0EhzW0Af
* IBM skills and certification news and offers
--Get the latest information on where, why, and how to certify.
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0EhzX0Ag
**** Vendor Whitepapers****
Get detailed information on products and strategies that work with
DB2. Whitepapers from Quest, Altova, and others are available for
download today.
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0EiAv0AG
********************************
6. MUST READ
* IBM Rational ClearCase, Ant, and CruiseControl
By Kevin A. Lee
This step-by-step guide to creating Java build processes introduces
best practices for integrating and using three industry standard
tools: IBM Rational ClearCase software configuration management (SCM)
system, the open-source Ant build tool, and CruiseControl for
automating continuous builds. The book explains everything from
configuring SCM environments and defining build scripts to release
packaging and deployment. Key techniques are presented in real-world
context, through a three-tier application case study.
--Read more about the book.
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0Bk8y0A8
********************************
7. IN THE ZONE
* WebSphere Product Center--First Steps
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0EhzZ0Ai
* Create z/OS procedures with Database Add-Ins for Visual Studio 2005
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0Ehza0Ap
* DB2 Partitioning Features: An Overview for Data Warehouses
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0Ehzb0Aq
* Oracle to Informix Dynamic Server Porting Guide
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0Ehzc0Ar
* Develop Custom Client Apps with DB2 Content Manager OOAPI, Part 1
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0Ehzd0As
* SQL & XQuery Tutorial for IBM DB2, Part 1: Introduction to Aroma
and
SQL
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0Ehze0At
* SQL & XQuery tutorial for IBM DB2, Part 2: Basic Queries
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0Ehzf0Au
* DB2 XML Wiki--Share your knowledge or learn from others
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0Ehzg0Av
* New IBM Information Server Platform: A Unified Foundation for
Integrating Information
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0Ehzh0Aw
* Webcast: Migrating to DB2 9 - Advice from the Pros
http://news.db2mag.com/cgi-bin4/DM/y/eycu0FhO7y0FLd0Ehzi0Ax
-------------------------------------------------------------------------------------
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.
