DB2 basics: An introduction to
the SQL/XML publishing functions (http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0511melnyk/)
Use the SQL/XML publishing functions
to produce a tagged XML document from relational data. IBM DB2® Universal
Database (DB2 UDB) includes built-in SQL/XML publishing functions that
make it easy to publish XML documents using data that is stored in a DB2
database. This article introduces you to the SQL/XML publishing functions
and shows you, by way of working examples, how to use these functions.
Application development with DB2
UDB (http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0511appdev/)
When it comes to application developers,
no other database provides the level of tooling and language integration
like IBM DB2® Universal Database (DB2 UDB). Whether you want to write
your applications in an Open Source language like PHP, you're exploring
the world of Web services vis-a-vis a Services Oriented Architecture (SOA),
live for Java(TM) or love .NET, the DB2 UDB database platform is there
for you. See for yourself just how easy it is to develop applications
for the DB2 platform.
Understand the DB2 Universal Database
security plug-ins (http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0512chong/)
Customize the DB2® UDB security mechanisms
to meet your individual needs for safe and secure database authentication.
Learn how you can write your own plug-in.
Information Management developerWorks
community (http://www-128.ibm.com/developerworks/db2/community/index.html)
Get involved in the Information Management
community and keep up on the latest topics. You'll find out what
developerWorks® has to offer by visiting our many forums, blogs and experts'
columns and through subscribing to Information Management newsletters.
IBM DB2, IMS, and WebSphere tools
expanded and enhanced to help you better manage database environments (http://www.ibm.com/isource/cgi-bin/goto?it=usa_annred&on=205-320)
New and enhanced DB2, IMS, and WebSphere
tools deliver:
* Application management
o
DB2 Data Archive Expert z/OS, V2 (5697-J22)
o
DB2 Test Database Generator for z/OS, V2.2 (5697-I02)
* Database administration
o
Data Encryption for IMS and DB2 Databases (5655-P03)
o
IMS Sysplex Manager for z/OS (5655-P01)
* Performance management
o
DB2 Query Monitor for z/OS, V2.2 (5697-I03)
* Recovery management
o
DB2 Change Accumulation Tool for z/OS, V1.4 (5655-F55)
* WebSphere information
integration
o
WebSphere Information Integrator Classic Event Publisher for Software AG
Adabas, V8.2 (5655-P12)
New database archiving tool for
multiplatforms and other enhanced tools enrich IBM DB2 (http://www.ibm.com/isource/cgi-bin/goto?it=usa_annred&on=205-323)
DB2 Data Archive Expert for Multiplatforms
V2.1 is an autonomic tool that offers a fast, flexible, and efficient way
to archive and retrieve DB2 data objects. With support for DB2 UDB on Linux,
UNIX, and Microsoft Windows, DB2 Data Archive Expert can help:
* Increase the performance
of your IBM DB2 UDB environment
* Lower disk storage costs
by moving seldom-used data to less expensive media
* Reduce database administration
costs through improved application efficiency
DB2 Test Database Generator for Multiplatforms
V2.2 helps safeguard confidential production data needed in test environments.
V2.2 helps companies:
* Easily create DB2 test
data for new and existing applications
* Respond with confidence
to today's data privacy regulations
DB2 Performance Expert V2.2 includes
support for Linux on xSeries 64-bit.
IBM System p5 with DB2 and/or
WebSphere rebate offering (http://www.ibm.com/isource/cgi-bin/goto?it=usa_annred&on=305-221)
If you acquire a solution that consists
of:
* an eligible new IBM
System p5™ 520, 550, or 550Q server minimum configuration, and
* eligible new IBM DB2®
UDB software licenses, and/or
* eligible new IBM WebSphere®
Application Server software licenses
you can receive a rebate.
The amount of the rebate is dependent
upon the server and software licenses acquired.
There is a limit of one rebate per machine
type serial number.
For a list of eligible products, refer
to the Qualifying/Eligible products section.
IBM WebSphere Information Integrator
OmniFind Edition V8.3 improves search reach, relevancy, and security (http://www.ibm.com/isource/cgi-bin/goto?it=usa_annred&on=205-342)
WebSphere Information Integrator OmniFind
Edition:
* Is the strategic IBM
enterprise-strength search solution for finding the most relevant corporate
information across intranets, extranets, corporate public Web sites, and
a wide range of content repositories
* Includes significant
enhancements in refined search quality, scalability, access to multiple
and disparate information sources, and additional integrations with organization-wide
security
1. From the Editor
* Looking forward to 2006
2. Asked and Answered
* Where to find code for accessing stored procedures
3. At the Bookstore
* Our readers' top five books of 2005
5. Now Playing at the developerWorks DB2 Domain
* Integrating unstructured content, tools for Visual Studio .NET,
and more
6. New E-Book
* Application Development Options: Perl, PHP, And Rexx
*****************************
1. FROM THE EDITOR
As the year draws to a close, many people take time to reflect
and set new goals for the coming year. I'd like to hear your
thoughts on how this newsletter and DB2mag.com can support you in
reaching those goals (at least the work related ones). What features
do you find most useful? What are the big challenges you face in 2006?
What topics would you like to see us cover? What additional Web site
functions are you looking for? Send your thoughts to me at
db2mag@....
Happy holidays from the DB2 Magazine team!
--Kim Moutsos, Editor
*****************************
2. ASKED AND ANSWERED
* At the top of this reader's wish list is a code snippet for
accessing DB2 for z/OS stored procedures in Java. Resident guru Robert
Catterall comes through with the answer.
http://news.db2mag.com/cgi-bin4/DM/y/espq0FhO7y0FLd0D2FY0Ax
--Read more about stored procedures.
http://news.db2mag.com/cgi-bin4/DM/y/espq0FhO7y0FLd0DYBW0AW
*****************************
3. AT THE BOOKSTORE
* Top 5 Books of 2005
If gifts of knowledge are on your holiday list, take another look at
these five titles that clicked with this newsletter's readers.
--SQL in a Nutshell, 2nd Edition
http://news.db2mag.com/cgi-bin4/DM/y/espq0FhO7y0FLd0D2FZ0Ay
--Understanding DB2: Learning Visually with Examples
http://news.db2mag.com/cgi-bin4/DM/y/espq0FhO7y0FLd0D2Fa0A6
--Self-Service Linux: Determining Problems and Finding Solutions
http://news.db2mag.com/cgi-bin4/DM/y/espq0FhO7y0FLd0D2Fb0A7
--Apache Derby--Off to the Races
http://news.db2mag.com/cgi-bin4/DM/y/espq0FhO7y0FLd0D2Fd0AA
*****************************
4. SKILLS AND EDUCATION NEWS
* Information Management Training Quick Finder
In a marketplace that's all about skills, it's critical that you can
find the training you need. Use IBM's World Wide Training quick
finder to select the training courses that are right for you.
http://news.db2mag.com/cgi-bin4/DM/y/espq0FhO7y0FLd0D2Ff0AC
* Information Management Learning Framework
Whether you are building a skills plan, or simply looking for
educational resources, IBM can help you define a software skills
program. Select from a wide variety of training options, use the
skills resources and communities, and verify your skill level through
role-based certification.
http://news.db2mag.com/cgi-bin4/DM/y/espq0FhO7y0FLd0D2Fg0AD
* Complimentary Role-Based Skills Roadmaps
IBM's complimentary roadmaps show you the path to acquiring
career-advancing skills. Base technology prerequisites are documented,
and courses and other applicable learning options are also listed.
Because the roadmaps are based on skills for specific roles
(developer, administrator, and architect, and so on) they show the
opportunities most relevant to your job requirements.
http://news.db2mag.com/cgi-bin4/DM/y/espq0FhO7y0FLd0C8T40Af
*****************************
5. NOW PLAYING AT THE DEVELOPERWORKS DB2 DOMAIN
* Integrate Unstructured Content into a Distributed Federated System
http://news.db2mag.com/cgi-bin4/DM/y/espq0FhO7y0FLd0D2Fh0AE
* New IBM DB2 Tools for Visual Studio .NET
http://news.db2mag.com/cgi-bin4/DM/y/espq0FhO7y0FLd0D2Fj0AG
* Generate Sequence Numbers in DB2 Content Manager
http://news.db2mag.com/cgi-bin4/DM/y/espq0FhO7y0FLd0D2Fk0AH
* Use The GSS-API with the DB2 UDB Security Plug-Ins
http://news.db2mag.com/cgi-bin4/DM/y/espq0FhO7y0FLd0D2Fl0AI
* DB2 UDB V8.2 Express Configuration and Rules of Thumb
http://news.db2mag.com/cgi-bin4/DM/y/espq0FhO7y0FLd0D2Fm0AJ
*****************************
6. E-BOOK: APPLICATION DEVELOPMENT OPTIONS: PERL, PHP, AND REXX
* When it comes to development, DB2 is open to all options. IBM's
commitment to open, standards-based interfaces and its support for a
range of tools mean that developers can build DB2 applications with
the tools and programming languages they like. This special e-book
presents DB2-specific code, tips, and techniques for working with
three increasingly popular choices: Perl, PHP and Rexx.
http://news.db2mag.com/cgi-bin4/DM/y/espq0FhO7y0FLd0D2Fn0AK
All, Here are new DB2 related topics over the past month or so. It's a long one this month, so grab a cup of coffee, put your feet up and enjoy the ...
All, Here are new DB2 related topics over the past month or so. ... Register for the DB2 Information Management Tech Conference in Orlando - Sep. 12-16 ...
All, Here are new DB2 related topics over the past month or so. ... An Expert's Guide to DB2 Technology (http://blogs.ittoolbox.com/database/technology/) About...
All, Here are new DB2 related topics over the past month or so. If I don't see or talk to you before the end of the year, have a happy and healthy holiday...
All, Stick a fork in me ... I'm done for this year! Here's my last installment of DB2 related topics for 2006. Here's hoping that all of you have a safe,...
All, Here are new DB2 related topics over the past month or so. OK ... so it's probably been a bit longer than a month, so this submission is a bit longer...
All, Here are new DB2 related topics over the past month or so. ... Announcement - IBM DB2 V9.1 (code named 'Viper') for Linux, UNIX, and Windows delivers...
All, Here are new DB2 related topics over the past month or so. ... Redbook: DB2 Express-C: The Developer Handbook for XML, PHP, C/C++, Java, and .NET ...
All, Here are new DB2 related topics over the past month or so. ... Redbook - Stored Procedures, Triggers, and User-Defined Functions on DB2 Universal Database...
All, This is my last installment for 2006! Here's hoping that you, your friends and your families have a safe, happy, healthy and prosperous Holiday Season. ...
All, Here's my installment of DB2 Updates over the last month. Take note of the first announcement - the availability of DB2 V9.1 for z/OS! Also, I've...
All, It's been about two months, but here's my latest update on what's going on in the "DB2 World". Jay Allen ... Redbook - Integrating IBM DB2 with the IBM...
All, Here's my installment of DB2 Updates over the last few weeks. ... DB2 Viper 2 Open Beta Program (http://www-306.ibm.com/software/data/db2/9/openbeta.html)...
All, Here's my installment of DB2 Updates over the last month or so. Please take note of the FixPaks available for DB2 UDB V8 and DB2 9 HIPER APARs. Jay Allen...
All, Here's my installment of DB2 Updates over the last month. Jay Allen ... Announcement - IBM DB2 V9.5 for Linux, UNIX, and Windows provides agility to align...
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.
Offline 
Send Email