(Mike Faust) In my past two TechTips, I reviewed 11 of the new built-in SQL functions added to the iSeries implementation of DB2 UDB in V5R3. Now, let’s take a look at the 14 remaining new functions. I’ll break the functions down into groupings based on the type of values handled by the function.

(Nagaraju Inturi) This article describes schema evolution (the support of alter table operations for replicated tables) in the Enterprise Replication environment. Schema evolution support in Enterprise Replication is a new feature for IBM Informix Dynamic Server Version 10.00. This feature lets you

(Howard Fosdick) The DBA certifications are the most popular DB2 credentials. They’re not earned lightly, but with a little preparation, you can pass the test. IBM splits the certified DBA credential by platform: Exam #701 covers Linux, Unix, and Windows, and Exam #702 covers the mainframe. I’ll cov

(Whei-Jen Chen, Alain Fisher, Stefan Hummel, Shailendra Kishore, Wei Bin Teah, Ted Wasserman and Jie Zhang) 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

(Dirk Fechner) Trace data at the interface between application and database provides the developer with information to identify program errors and to optimize database access. The DB2 Legacy JDBC Driver is based on the DB2 Call Level Interface (CLI) layer and allows for JDBC or CLI tracing through c

(Bryan Paulsen) DB2 UDB for z/OS Version 8 introduces two new system-level utilities that provide for robust backup and restore solution at the DB2 system level instead of the DB2 object level. The new utilities are Backup System and Restore System. These utilities provide functionality for backing

(Jeff K. Wilson) This tutorial is for J2EE developers struggling to find the best method of incorporating disparate environments and looking for an easy way to leverage standard data access methodologies for consuming data. With WebSphere Information Integrator, developers can access data — ult

(Ann Fred and Glenn Stump) Extend your Web applications to BlackBerry handhelds with IBM WebSphere Everyplace Access Version 5.0 and DB2 Everyplace Version 8.1.4. This article examines the WebSphere Everyplace Access and DB2 Everyplace runtime features you can use to extend applications to Black

(Michael Liebow) The enormous amount of activity surrounding service-oriented architecture over the past few weeks has moved the adoption needle more than any previous comparable amount of time. The ecosystem for SOA is rapidly growing with each passing day, as application providers deliver SOA-

(Hana Curtis) This tutorial discusses data types, tables, views, and indexes as defined by DB2 Universal Database. It explains the features of these objects, how to create and manipulate them using Structured Query Language (SQL), and how they can be used in an application. (pdf)