Application Development Zone: Archive

IBM Data Studio pureQuery Runtime for z/OS Performance
pureQuery improves application throughput on DB2 for z/OS by making it easy to code and deploy static SQL for Java. The new client optimization feature in Version 1.2 extends the benefits of static SQL to any existing Java application without changing or recompiling Java applications.
Issue 2, 2008

XML Performance: A Surprising Ace in the Hole
Relational database storage brings RDBMS strengths to XML data. But older clumsier storage methods left application performance an open question. Two years after IBM introduced pureXML in DB2 9, that question has been answered.
Issue 2, 2008

"No Excuses" Database Programming for Java
Make your programs fly with static SQL and pureQuery.
Issue 2, 2008

Programmers Only: The Mystery of the DB2 SIX Lock
The truth behind this enigmatic lock and other DB2 for z/OS stumpers.
Issue 2, 2008

IDUG User View: Common DB2 Performance Pitfalls
Build your applications right from the start by avoiding these typical missteps.
Issue 2, 2008

The Easy Way to Quick Data Access
IBM takes the drudgery out of JDBC programming with pureQuery, an integrated language that queries relational databases as well as Java collections and database caches. pureQuery and Data Web Services are components of the new IBM Data Studio, a new common database application development and administration platform.
Issue 3, 2007

Programmers Only: Optimistic Locking, Part 2
When it comes to DB2 for z/OS locks, a pessimistic approach rarely pays.
Issue 3, 2007

DB2 DBA: News from the Client Side
Application developers love Python, Perl, PHP, and Ruby. DB2 is ready to support them -- are you?
Issue 2, 2007

Programmers Only: Optimistic Locking, Part 1
An improvement to this age-old DB2 for z/OS concept helps programmers who look on the bright side.
Issue 1, 2007

What's Hot for Java

Issue 4, 2006

XML Programming with PHP and Ajax

Issue 3, 2006

XML Programming with PHP and Ajax

Issue 3, 2006

Eye On XQuery

Issue 3, 2006

Configuring DB2 9 with WebSphere Application Server 6.1

Issue 3, 2006

Accessing iSeries Data

Issue 3, 2006

DB2 Developer's Release

Issue 2, 2006

Beyond Conventional Wisdom

Issue 1, 2006

Up Start

Issue 4, 2005

Manage, Don't Tune

Issue 4, 2005

Accessible Insight

Issue 4, 2005

High-Performance ETL

Issue 4, 2005

The New Cloudscape View

Issue 4, 2005

Developing with .NET

Issue 3, 2005

Large Objects Get Bigger

Issue 3, 2005

Achieving New Heights with DB2 UDB Version 8.2.2
The newest release of DB2 is optimized for SAP, but better for everyone.
Issue 2, 2005

Built for the Web
IBM's new partnership with Zend Technologies makes PHP Web development even easier.
Issue 2, 2005

Strategies for DB2 Developers
Develop smarter DB2 applications faster with open-source languages and techniques that tap skills you already have.
Issue 2, 2005

Rexx Scripting for DB2
This powerful open-source language lets you take full command of DB2 Universal Database.
Issue 2, 2005

Modernizing Legacy Systems: It's Easier than You Think
No redesign. No reimplementation. No need to hire new staff. User-defined functions are the key to transforming legacy applications one step at a time.
Issue 2, 2005

Say What? Part 4
DB2's three Rs: Reorganize, run statistics, and rebind.
Issue 2, 2005

Advanced Perl with DB2 UDB
Now that you've mastered the basics of Perl and the Perl DBI interface to access DB2 UDB servers, let's move on and take a look at some more advanced topics, including: large object support, stored procedures, and application profiling and tracing.
Issue 1, 2005

Asked & Answered
What exactly do the terms plan and package mean in a DB2 UDB for Linux, Unix, and Windows context?
Issue 1, 2005

Taming the Beast
Merrill Lynch frees developers from integration struggles with a federation-based strategy.
Issue 1, 2005

Grid Iron
Inherent strength and flexibility are helping grids gain ground on the business playing field.
Issue 1, 2005

Table Spaces And Locking Levels, Part 1
Yes, programmers, you do acquire table space and table locks.
Issue 1, 2005

Perls of Wisdom
Follow these simple steps to use the free Perl language with DB2.
Issue 1, 2005

Beyond the White Pages

Issue 4, 2004

By Popular Demand
What Aunt Louise's grocery shopping method reveals about index usage.
Issue 4, 2004

Taming the Wild West, Part 2
Implementation can be a challenge, but Web content management benefits outweigh the costs.
Issue 3, 2004

Programs vs. Utilities Revisited
Utilities in DB2 for z/OS v.8 let you be the hero with very little programming.
Issue 3, 2004

Doing More With More
The latest release of DB2 Universal Database is brimming with features that make life easier for developers and DBAs alike.
Issue 3, 2004

Totally RAD
With all the enhancements in DB2 UDB v.8.2, developing DB2 applications for a .Net environment has never been cooler.
Issue 3, 2004

Brewing Up Stronger Java Support
Improvements to the DB2 JDBC Universal Driver in DB2 UDB v.8.2 let developers take advantage of eye-opening performance and manageability.
Issue 3, 2004

Say What? Part 3
What to do when you find yourself in a bind.
Issue 2, 2004

Over the Top Performance
DB2 UDB v.8's latest adaptations boost performance for even the most modern applications.
Issue 1, 2004

Say What? Part 2
How the separated twins - modified source code Arnold and DB2 SQL Danny - find each other again.
Issue 1, 2004

Securing Your Database
Don't let your Web applications threaten your data's security.
Issue 1, 2004

Combining Triggers and UDFs
Now DB2 can handle tasks once left to application developers.
Issue 4, 2003

Say What?
Plans + DBRMS + Packages + Collections + Versions = Confusion
Issue 4, 2003

Old Dogs, New Tricks
With all the advances in DB2, giving up old habits really pays off.
Issue 3, 2003

Can We Talk?
Collaboration tools enable groups to communicate in a virtual world.
Issue 3, 2003

Tracking The Truth
IBM and the National Geographic Society are teaming up to answer age-old questions about human migration. A flexible, secure information system lets the team share findings with each other and present personalized results to participants.
Quarter 4, 2006

What's Hot for Java
DB2 9 perks up Java development with new features and functions.
Quarter 4, 2006

XML in Focus
DB2 9's pureXML technology is speeding development for early customers, including financial-services giant Storebrand. Explore the developer-friendly features behind the radical improvements.
Quarter 3, 2006

Opening the Door to XML
DB2 9 offers new XML capabilities that you can connect to using familiar and standard industry techniques.
Your knowledge of popular programming languages and techniques is all you need to put DB2 9's XML capabilities to work in service-oriented architectures and other business scenarios. Quarter 3, 2006

XML Programming with PHP and Ajax
Your knowledge of popular programming languages and techniques is all you need to put DB2 9's XML capabilities to work in service-oriented architectures and other business scenarios.
Quarter 3, 2006

Eye on XQuery
DB2 9's Developer Workbench includes the Visual XQuery Builder, a versatile visual design tool for developers new to the XQuery syntax—and for veterans seeking a faster way to build complex queries.
Quarter 3, 2006

The Rubber Meets the Road
How will DB2 Viper's hybrid XML-relational data server work in the real world? Customers and partners are kicking the tires, revving the engine, and testing performance and handling. Here's what to look for when you take it out for a spin.
Quarter 2, 2006

DB2 Developer's Release
The Microsoft crowd gets an early look at planned support for Visual Studio 2005 and ADO.Net.
Quarter 2, 2006

Take The Fast Train
The new DB2 Express-C is the quickest ride to the latest data server technologies. And there's one more interesting thing: It's free.
Quarter 1, 2006

Information At Your Service
When you stop servicing mountains of data, you can start providing a valuable service to your company: information.
Quarter 1, 2006

Open For Business
Has IBM solved the age-old challenge of getting the right information into the right hands at the right time? Ambuj Goyal, new GM of Information Management Software, says it has. And his claim is backed by expertise and technologies from every corner of the tech giant's realm.
Quarter 1, 2006

Beyond Conventional Wisdom
Enterprise Generation Language (EGL) makes "old school" new again.
Quarter 1, 2006

The New Cloudscape View
A new release promises a bright future for this increasingly popular database option.
Quarter 4, 2005

Building Blox
Delivering contextual, accurate intelligence can be as difficult as finding a needle in a haystack. But the reusable components in DB2 Alphablox make that task a snap.
Quarter 4, 2005

Developing with .NET
A guide to creating your first DB2 .Net application.
Quarter 3, 2005

Large Objects Get Bigger
Once a niche subject, LOBs are demanding attention-and additional resources.
Quarter 3, 2005

Achieving New Heights with DB2 UDB Version 8.2.2
The newest release of DB2 is optimized for SAP, but better for everyone.
Quarter 2, 2005

Say What Part 4
DB2's three Rs: Reorganize, run statistics, and rebind.
Quarter 2, 2005

Built for the Web
IBM's new partnership with Zend Technologies makes PHP Web development even easier.
Quarter 2, 2005

Perls of Wisdom
Follow these simple steps to use the free Perl language with DB2.
Quarter 1, 2005

Table Spaces And Locking Levels, Part 1
Yes, programmers, you do acquire table space and table locks.
Quarter 1, 2005

Beyond the White Pages
LDAP technology helps companies manage information about their most valuable resources.
Quarter 4, 2004

By Popular Demand
What Aunt Louise's grocery shopping method reveals about index usage.
Quarter 4, 2004

Totally RAD: Developing with .Net
With all the enhancements in DB2 UDB v.8.2, developing DB2 applications for a .Net environment has never been cooler.
Quarter 3, 2004

Brewing Up Stronger Java Support
Improvements to the DB2 JDBC Universal Driver in DB2 UDB v.8.2 let developers take advantage of eye-opening performance and manageability.
Quarter 3, 2004

Doing More With More
The latest release of DB2 Universal Database is brimming with features that make life easier for developers and DBAs alike.
Quarter 3, 2004

Taming the Wild West, Part 2
Implementation can be a challenge, but Web content management benefits outweigh the costs.
Quarter 3, 2004

Programs vs. Utilities Revisited
Utilities in DB2 for z/OS v.8 let you be the hero with very little programming.
Quarter 3, 2004

Taming The Wild West, Part 1
Using Web content management can marshal Web sites, intranets, and portals into a force for productivity.
Quarter 2, 2004

Say What? Part 3
What to do when you find yourself in a bind.
Quarter 2, 2004

Combining Triggers and UDFs
Now DB2 can handle tasks once left to application developers.
Quarter 4, 2003

Say What?
Plans + DBRMS + Packages + Collections + Versions = Confusion.
Quarter 4, 2003

Can We Talk?
Collaboration tools enable groups to communicate in a virtual world.
Quarter 3, 2003

Old Dogs, New Tricks
With all the advances in DB2, giving up old habits really pays off.
Quarter 3, 2003

Combining Triggers and UDFs
Now DB2 can handle tasks once left to application developers.
Quarter 4, 2003

Say What?
Plans + DBRMS + Packages + Collections + Versions = Confusion.
Quarter 4, 2003

APS: E-Business Suite Spots?
Application platform suites might Turn out to be the next big thing - or no big deal.
Quarter 2, 2003

Programs vs. Utilities
Before you write another INSERT or DELETE program, take a look at DB2 utilities.
Quarter 2, 2003

More Joys of Commitment
How to know when it's time to COMMIT
Quarter 1, 2003

Are XML Databases Necessary?
XML databases may help development efforts in some situations - but an RDBMS may still be the best choice.
Quarter 1, 2003

Go Ahead, COMMIT On A Read
COMMITting in a read-only situation releases locks and sets your application free.
Quarter 4, 2002

Optimizing for Top Performance
Fine-tuning your database access will keep applications and database in harmony.
Quarter 4, 2002

The Joys of Commitment
Good Things Happen When You Decide to COMMIT.
Quarter 4, 2002

Is ColdFusion For Real?
Macromedia's latest release seeks to debunk the skeptics.
Quarter 3, 2002

Once Upon a Time in DB2
Think you understand cursors and fetching in DB2? What you think you know may be nothing more than a fairy tale.
Quarter 3, 2002

Web Services the Easy Way
Views that integrate data from heterogeneous databases are the first step to lightening the programming load for Web service developers.
Quarter 2, 2002

When in Rome: Developing for DB2
New to DB2 application development? With this field guide in hand, you'll master DB2's customs and culture in no time.
Quarter 2, 2002

Granting Wishes: iSeries SQL Triggers
Wish you could automate tedious coding tasks or get more from your legacy applications? With new SQL triggers to work with, your wishes just might come true.
Quarter 2, 2002

Meeting the Challenge of Enterprise Applications
DB2 Universal Database for z/OS and OS/390 offers new features - inspired by the complex requirements of packaged enterprise applications - that produce rewards in any DB2 environment.
Quarter 2, 2002

Cursors! Foiled No More
They're necessary in nearly every DB2 program. But with their one-directional abilities, cursors could seem a formidable foe. Arriving to save the day? New, scrollable cursors in DB2 UDB for z/OS and OS/390.
Quarter 2, 2002

Off to a Model Start
The Unified Modeling Language helps developers and business users understand each other before any coding begins.
Quarter 2, 2002

> Search for more articles on this topic

HOT OFF THE PRESS
The latest information management news from around the Web.
 
>Protect your data with Label-Based Access Control support in IDS -
>Data integration with Salesforce CRM using IBM InfoSphere Information Server -
>Extend IBM Rational Data Architect to meet your data modeling and integration requirements, Part 1: Modifying RDA models and customizing properties -
>Troubleshooting locking problems in WebSphere Commerce with DB2 -
>How multithreaded architecture works in DB2 9.5 -
Industry Events
IDUG North America, May 6-10, San Jose, Calif. U2U University - August 4-7, 2008 - Sydney, Australia

IDUG 2008 – India - August 21-23, 2008 - Bangalore (Bengaluru), Karnataka India

U2U University - September 15-18, 2008 - San Diego, CA

> More Events
Reader-to-Reader
Tip of the Wiki

Join the community in building the best collection of tips and tricks for IBM information management software (including DB2, Informix, and more). Browse available topics and consider adding your own.

Get involved by contributing to one of these projects.

Blog Spot
Blog IBM Database Magazine authors share tips and insight on DB2 and Informix performance, certification, security, and more. Join the conversation by adding a comment or asking a question.
 
Latest posts:
Podcast
Book Notes: Susan Visser on DB2 and Informix Books [6.25 MB]
IBM Press Program Manager for Information Management Susan Visser covers the latest in Informix and DB2 certification titles.
>DOWNLOAD
Must Read
Administering Informix Dynamic Server: Building the Foundation Administering Informix Dynamic Server: Building the Foundation
by Carlton Doe
This new guide by IBM's Carlton Doe focuses on the basic skills required to administer and maintain Informix Dynamic Server (IDS). The book, available for pre-order in advance of its October 2008 release, reviews IDS installation, configuration, back up, recovery, and an introduction to monitoring instance operations.

[More Books]

IBM Database Magazine Authors
Certification Guides

CAREER CENTER
Ready to take that job and shove it?
SEARCH JOBS
RECENT JOB POSTINGS
CAREER NEWS
10 Search Engines You Don't Know About
Go beyond Google and get vertical. These specialized search sites will help you find the business information you need -- fast.

Subscribe to the new digital version of IBM Database Magazine
New Digital Version

Sponsored links:



Subscribe to the IBM Database Magazine Newsletter

Email Address *
First Name
Last Name
HTML Preference
HTML Text
 

Fields with * are required.

 




Visit these other IBM and TechWeb Partner Sites: :
Maximizing ROI Through Business Process Management (BPM) and Service-Oriented Architecture (SOA)
Internet Evolution – The Macrosite for News, Analysis, & Opinion About the Future of the Internet
Business Innovation – Technology Strategies and Solutions for Driving Business Success