(Blair Adamache) Read these tips on how you can easily allow your users to search data in a way that is natural for them-with no worries about case sensitivity.
Tag: IBM
DB2 LUW Performance: Write I/O Optimization
(Scott Hayes) A student who took this class last week at WDUG emailed me the day after to thank me. He said he enjoyed the class and successfully reduced the elapsed time of a troublesome query from two hours to three minutes! If you missed the WDUG session, I hope you will be able to join my Ed Sem
Database Archiving Trends and Best Practices Webinar
(Craig Mullins) Just a quick blog entry today to promote my upcoming webinar on May 30, 2008 titled Database Archiving Trends and Best Practices.
DB2 9.5 and IBM Data Studio Part 9: The SQL Editor Development Accelerators
(Paul Zikopoulos) So far, in this series about the IBM Data Studio integrated development environment (IDE) that’s available with DB2 Version 9.5 (DB2 9.5), I’ve shown you how to set up database connection objects and the actions that you can perform on them. In addition, I introduced you (in Part 2
XForms and DB2 pureXML
(Keith Wells, Susan Malaika and Christian Pichler) Understand the end-to-end exchange of XML data from an XForms-based browser to an IBM DB2 database with full XML support. Learn how easy it is to create XForms and have them communicate with a DB2 database, where XML data can be stored, retrieved, o
Using SQL syntax to override DB2 automatic column name generator on iSeries
(Kent Milligan) In production, we never drop and recreate tables. In test we do. Recently, we used the ALTER statement to remove a column in the table. The column removed seemed to have the internal name of MAX_P00001. In the production table there is still a MAX_P00002 and a MAX_P00003. In test tab
IDUG Members: Take a free online assessment exam!
(Kate Dawson) If you are planning to take a certification exam at the IDUG North America Conference, May 18 – 22, 2008, you’ll be interested in this offer! Information Management is offering free online assessment exams prior to and during the event, May 4 through May 22, 2008. These assessment exam
Data Web Services on WebSphere Application Server, Part 2: Enable transport-level security
(Michael Schenker and Namrata Misra) Part 1 of this series explored the basic development and deployment steps to use an IBM® Data Web Service with WebSphere® Application Server. Now you are ready to explore more advanced topics. This tutorial shows you how to configure the sample Data Web Service a
Why Tune SQL?
(Peter Plevka) What is your biggest challenge in managing applications in a DB2 for z/OS environment? Is it keeping data and the application available 24/7? Is it meeting ever-more stringent service level agreements (SLAs), including optimal response time? Is it managing the ever-growing complexity
The information perspective of SOA design, Part 7: The execution approach for the data quality analysis pattern in SOA
(Brian Byrne, John Kling, David McCarty, Dr. Guenter Sauter, Harald Smith and Peter Worcester) This is the seventh paper in a series called the “The Information Aspect of SOA Design.” The purpose of this article is to demonstrate to an architect community the execution approach of detailed data qual
