DB2 Magazine E-Newsletter

June 25, 2002

DB2 MAGAZINE EMAIL NEWSLETTER
VOLUME 3, ISSUE 6
http://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: Authors address your queries about:
   * Using SQL with iSeries
   * Triggers and upgrading
   * Data Sharing with DDF
2. IBM News: New Redbook CD; SQL Reference for Cross-Platform Development
3. At the Bookstore: Understanding Web Services: XML, WSDL, SOAP, and UDDI
4. Intelligent Enterprise NetSeminar: Web Services: The Strategic IT View
5. Now Playing at the DB2 Developer Domain

*****************SPONSORED BY BMC***********************
***Free Trial!***
See how Space Expert for DB2 UDB offers all the features necessary for you to achieve peak database performance...with failure-point identification, proactive prevention of space management problems, and sophisticated analysis of your complete DB2 database environment.

http://www.bmc.com/offers/space_expert/db2udb_trial/
*****************************************************************

ASKED AND ANSWERED: AUTHORS ADDRESS YOUR QUERIES
Granting Wishes: iSeries SQL Triggers
( http://www.db2mag.com/db_area/archives/2002/q2/pavlak.shtml )
1. We're upgrading from V4R4 to V5R1 of the operating system. We currently use triggers but wonder if there are any major concerns with triggers on V5R1. Find out at http://www.db2mag.com/qanda/020625a.shtml .

2. I tried entering the RUNSQLSTM, CRTSQLCI, and CRTSQLRPG commands and got messages saying the commands are not found. What library are these commands located in, or what feature of OS/400 do I need to use SQL? Read Michael Pavlak's advice at http://www.db2mag.com/qanda/020625b.shtml .

"DDF vs. CICS," DB2 DBA
( http://www.db2mag.com/db_area/archives/2000/q4/db2dba.shtml )
Is DDF as an option for sharing data between four DB2 subsystems that will be needed for read-only batch jobs? Robert Catterall explains http://www.db2mag.com/qanda/020625c.shtml .

"When Less is More," DB2 DBA
( http://www.db2mag.com/db_area/archives/2002/q2/db2dba.shtml )
Why not place the table in question in its own tablespace? Then it could be attached to its own buffer pool and sized according the table data? This way there would be no need to change applications. Find out at http://www.db2mag.com/qanda/020625d.shtml .

IBM NEWS
Free Redbook CD from IBM
IBM is offering a free CD that contains more than 100 IBM Data Management Redbooks on such topics as: DB2, Content Manager, data warehousing, z/OS, OS/390, IMS, and tools. The material on the CD provides implementation experiences and step-by-step guidelines. Sample code and other support materials are often included. For details, go to https://www6.software.ibm.com/reg/redbook/redbook-i?S_TACT=102BEW08&S_CMP=__S_CMP__ .

New SQL Reference for Cross-Platform Development now available
Writing portable applications just got easier. IBM released a free SQL reference to help you develop SQL applications that are portable across the DB2 UDB family, including DB2 UDB for: z/OS and OS/390 version 7 iSeries version 5 Release 1 Linux, Unix, and Windows Version 7.2. For more information, go to http://www7b.software.ibm.com/dmdd/library/techarticle/0206sqlref/0206sqlref.html .

AT THE BOOKSTORE
Understanding Web Services: XML, WSDL, SOAP, and UDDI , by Eric Newcomer
This book introduces the main ideas and concepts behind core and extended Web services technologies and provides developers with a primer for each major technology that has emerged. In addition, Understanding Web Services summarizes the major architectural approaches to Web services, examines the role of Web services within the .NET and J2EE communities, and provides information about major product offerings from BEA, Hewlett-Packard, IBM, IONA, Microsoft, Oracle, Sun Microsystems, and others. Key topics include: XML facilities for structuring and serializing data. Find out more at the DB2 Magazine online bookstore ( http://www.db2mag.com/bookstore/ ).

WEB SERVICES NETSEMINAR FROM INTELLIGENT ENTERPRISE
On Tuesday, July 30, Intelligent Enterprise will host a NetSeminar called "Web Services: The Strategic IT View." Ken North (an author, speaker, and analyst who covers Web services and enterprise computing) and Jack Hakim (founder and CEO of EC Wise Inc., a software design and development consultancy) join moderator Justin Kestelyn (editor-in-chief of Intelligent Enterprise) to discuss this burgeoning IT market. Register today at: http://www.netseminar.com/nss/showSeminar?sem_num=663 .

NOW PLAYING AT THE DB2 DEVELOPER DOMAIN
A Quick Reference for Tuning DB2 EEE
http://www7b.software.ibm.com/dmdd/library/techarticle/0205parlapalli/0205parlapalli.html

Tutorial: Creating an XML-based Customer Repository using XML Extender
https://www6.software.ibm.com/reg/devworks/dw-db2xmlx-i?S_TACT=102B7W62&S_CMP=DB2DD

Meet the Experts: Roger Miller, DB2 for z/OS and OS/390 Strategist
http://www7b.software.ibm.com/dmdd/library/techarticle/0206miller/0206miller.html

Java Stored Procedures, WebSphere, and DB2 on the IBM eServer zSeries
http://www7b.software.ibm.com/dmdd/library/techarticle/0206baylor/0206baylor.html

From Data Management to Information Integration: A Natural Evolution
http://www7b.software.ibm.com/dmdd/library/techarticle/0206roth/0206roth.html